Andy Heinzer Atlassian Team

Ah, thanks for letting me know. I think this is specific to that plugin for Jira, and not Jira itself. I have added the tags for that plugin to this thread. I also came across this other post that seems directly related to the situation you mentioned:…

It depends on your version of Jira. What version of Jira are you using? Jira added support for Postgresql 9.6.x starting with version 7.4.0 https://confluence.atlassian.com/adminjiraserver074/supported-platforms-881683157.html If you're running a version of Jira before this, such as 7.3.7, then upgrading the database won't…

I can see the problem now. You're using a MySQL 5.7.22 database version with Jira. As a result this database version is using a slightly different setup than MySQL versions before 5.7.6. In that version of that database MySQL implemented a different permission needed in order to create foreign key constraints. Your logs…

What is your server ID for this instance? If you applied a Jira Core license, please let me know what SEN you used for this. You can in turn use the same Server ID for the core license in order to create the license for Jira Software. For Server products, you server ID should be 4 sets of 4 characters with hyphens in…

I'd suggest looking at the $JIRAHOME/log/atlassian-jira.log file when this error happens. What action are you doing in Jira to create this 500 error?

Responsible is not a system field, so I can't say for sure. But this same problem can happen to other user fields like reporter or assignee. If your responsible field is a user field like one of those, then yes, that bug is clearly the one you are seeing here. I'm confident that upgrading to a newer version of Jira will…

You could create a dummy account in Jira for a user with that exact email address, and then deactivate the account. Jira won't send email notifications to any user with an inactive account, but that goes for the entire Jira site, which means not just service desk projects. I would only suggest this course of action for…

Hi Zethof, I am afraid I can't see any clear problems in this log that would account for the behavior you are describing. As such, I went ahead and created a support request for this issue with our support team. Please see https://getsupport.atlassian.com/servicedesk/customer/portal/28/JPO-3026 for details, we have…

Hi Eric, This feature was originally developed for the Atlassian Cloud platform. In that platform you don't need to create an application link, AND there is a presumption that both applications will have the same user accounts. We can't always make that presumption in the Server platform of these same products. This…

It's difficult to see because your screenshot is cropped so much I can't see the full error. However I think that your lexoranking in Jira has some kind of corrupted data, and that would explain why you can't delete issues. Please try to follow the steps in…

Hi Emilia, That version of Jira is susceptible to these pair of bugs about user fields: https://jira.atlassian.com/browse/JRASERVER-63109 and https://jira.atlassian.com/browse/JRASERVER-62628 I think they account for the first behavior you described. I would recommend upgrading Jira to a version such as 7.2.6 or higher in…

Hi Eric, Since you're seeing that error message it tends to indicate that Confluence needs to authorize the user to see that content. It might be possible to setup this integration when using different users bases between products, but personally I have not had much success doing that. I've only been able to get this to…

* What version of Jira is this? I suspect this might have been a bug that was resolved in a later version. * 6 thousand items on a single board is a lot of data to show on a screen all at once. This is a scrum board or a kanban? If this is a kanban, then there is also the concern over what the subfilter is for this board.…

The Server ID does not have to match your license key. It's only when you first generate the license key do you need to enter in a server ID. After that you can apply that license key to a server with a different server ID if need be. It's a common misconception that the server ID is required to match that specifically…

Hi Alan, I'm not sure I understand the problem here. I can link issues together in a Jira Cloud business project, but I don't yet understand how that correlates to a duration of time to complete between these tasks. Are you running a specific report In Jira to observe this problem? Or if you can tell me more about where…

When using an LDAP/AD directory with Jira, you can't add users from that user directory into groups that exist in other user directories. The exception to this is if you are using the option called 'Read-only with local groups' and then it only allows you to place LDAP/AD users into groups that exist in the local internal…

Actually Jira has not supported MS SQL 2008 since 7.1.x versions, see the Jira 7.3 supported platforms documentation. However we didn't see very many user reported problems in Atlassian support with admins utilizing this database version for Jira 7.2 -> 7.3.x versions. That's just in regards to Jira itself. But Portfolio…

Did you add the CA cert before you specified the JAVA_HOME? If so, then it's possible Jira could have been using a different JRE and in turn a different cacert location for the keystore/truststore. Also, after you set the JAVA_HOME, did you restart Jira? I would expect this to have to take place for Jira to start up with…

You mentioned using 7.9.2, what version of Jira were you using before this upgrade? I am confused by which product you have here. You have used both Jira Server and Jira Cloud specific terms here. Jira Cloud is a different product that is hosted by Atlassian. If you have this, then your site will have a atlassian.net or…

That specific error message is known to happen when Jira is using IMAP with a shared mailbox on office 365. There is a KB on that error in: A3 BAD User is authenticated but not connected error message when using JIRA with Office365 From that KB: Cause * JIRA does not support IMAP integrated with a Shared Mailbox. This…

The license key is valid. However if you're seeing that error, it tends to be that there is a bigger problem with Jira being unable to commit that license information into the database. I suspect that the $JIRAHOME/log/atlassian-jira.log file will have a number of errors when trying to activate this license key. I am…

Ah, well yeah, using this specific database version can cause a lot more problems for more recent versions of Jira. I found this error in your logs: Caused by: com.querydsl.core.QueryException: Caught SQLServerException for select ACTION.id, ACTION.issueid, ACTION.author, ACTION.actiontype, ACTION.actionlevel,…

Hi @Ryan Cho What version of Microsoft's SQL server are you using? I ask because we have a few different guides in regards to the different database versions that are actually supported by Jira, such as: * Connecting Jira applications to SQL Server 2012 * Connecting Jira applications to SQL Server 2014 * Connecting Jira…

I can't seem to recreate this problem. I'm using the same versions in my test instance, but I also am using a postgresql database on my back end. I'm not sure what database type you are using with Jira (postgres, mysql, ms sql, or Oracle all have supported versions for Jira). Please let me know the database type/version…

I recommend that you use the Jira internal directory to get past this problem. Since you cannot change the order of that directory, it tends to mean that your current account is being logged into Jira through that particular user directory. If you can create a Jira System administrator level account that exists in the Jira…

That's strange that this works when visiting the site from the jira server. That tends to indicate to me that there could be a problem with the way the page is being loaded from other locations. It might be worth using a browser like Chrome or firefox, loading this page from a system where this does not work, and then take…

@Bryan Trummer - ReleaseTEAM Upgrading to 7.8.4 would also resolve this problem. Those versions (7.6.5, 7.7.3, 7.8.3, and 7.9.1) were all pulled from distribution and in turn they all suffer the same problem in regards to this marketplace error. However any other version of Jira won't have this same issue.

I'm not sure why you might not be able to download that file, but I posted it to my google share drive as well, you should also be able to download this class file from this link: https://drive.google.com/file/d/1X5eobuFPDPk6pJwr2xKYQ9FGiFt4Pkqu/view?usp=sharing I would recommend that you try to run that utility directly…

I'd like to look at the log file this error references. You can find this in the $JIRAHOME/log/atlassian-jira.log file. I would expect this log will have a more complete stacktrace that provides more clues on this problem. On a side note, using MySQL with Jira is possible, but it has an additional step that using other…

Hi Volkmar, My intention was not to dismiss your concerns, but rather manage your expectations here. I appreciate that you want to pursue this issue as a bug in Jira. I am willing to investigate that route. However in order for me to create a bug ticket for this specific problem, I need to have a clear set of steps…