Troubleshooting tool reports incompatible database

Tim Deardeuff

After I updated some plug-ins but not Jira itself nor the database, the troubleshooting and support tool is reporting that my database is incompatible. I'd like to find out which plugin is reporting the incompatibility and how serious it is. I've done this in my dev environment and need to know before I make the changes in production. Here's the exact message:

"Oracle Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning option is not supported. You should migrate to a supported database version."

Andy Heinzer

Hi Tim,

Sorry to hear about this problem.  It sounds like the health check plugin in Jira might be giving you some kind of false positive.  However before we jump to that conclusion, I'd be interested to learn more about your environment, such as

1. Your Jira version here
2. The version of the Oracle JDBC database driver you have installed in Jira
3. The version of the Support Tools plugin (Atlassian Troubleshooting and support tools is the current name).

 

For #1 you can find this at the bottom of pages like the dashboard.

For #2 You can login as an admin to Jira and go to the page /secure/admin/ViewSystemInfo.jspa There should be a 'Database driver' entry there that can provide us the specific database driver version Jira is using.

For #3 - You can go into the Manage apps (or add-ons for earlier versions) in order to see the plugins you have installed in Jira.  If you expand this support tools one you should be able to find the version you currently have installed.

You could then uninstall this plugin from Jira on that manage apps/add-ons page.  This would serve as a means to see if this warning disappears.  This specific plugin does have a bundled version of it that tends to have been shipped with many versions of Jira since at least 7.3 if I recall correctly.  Hence uninstalling the update should leave your Jira without this plugin entirely.

You could then manually reinstall an older version that you could download from https://marketplace.atlassian.com/apps/1217696/troubleshooting-and-support-jira/version-history

But you will want to make sure you pick a version that is listed as compatible with your version of Jira.

Please let me know the results.

Andy