Need to restore all data in Jira from MS SQL backup

Question

Hi Team,

SEN-3355779

We have Jira Server installed on Linux server with MS SQL server database & it got crashed due to unexpectedly restart the server. Now it is not working properly. Tomcat is shutting down automatically. We need to setup again Jira with Old data.

We have SQL Database, Old Jira Home Directory, Old installed directory.

Now Please provide us the steps to configure jira with old database and all previous plugins & settings.

cybage_bitbucket · Answer

As per our analysis Jira is using crowd for the authentication. I have installed Jira on new server with old database. It was working propely on new server but after reindexing in Jira I am getting authentication error & unable to login into Jira.

I am using SQL Server for Jira database. Can we modify database so Jira will use jira internal directory for jira authentication instead of crowd.

Plugin issue is resolved.

Nic Brough -Adaptavist- · Answer

Ok, that's indicative of the high load at startup time overloading your system.

Start with https://confluence.atlassian.com/display/JIRAKB/JIRA+System+Plugin+Timeout+While+Waiting+for+Plugins+to+Enable

cybage_bitbucket · Answer

Hi Nic,

I have installed Jira on new server with old database. It was working propely on new server but after reindexing in Jira I am getting below error.

___ FAILED PLUGIN REPORT _____________________

3 plugins failed to load during JIRA startup.

'com.atlassian.jira.gadgets' - 'Atlassian JIRA - Plugins - Gadgets Plugin'  failed to load.

Application context initialization for 'com.atlassian.jira.gadgets-plugin' has timed out

It has the following missing service dependencies :

&dashboardService of type (objectClass=com.atlassian.gadgets.dashboard.DashboardService)

It was loaded from /var/atlassian/application-data/jira/plugins/.bundled-plugins/jira-gadgets-plugin-6.2.7.jar

'com.atlassian.jira.collector.plugin.jira-issue-collector-plugin' - 'JIRA Issue Collector Plugin'  failed to load.

Application context initialization for 'com.atlassian.jira.collector.plugin.jira-issue-collector-plugin' has timed out