Trying to use old DB on new Install of Jira.

Chris Scheepers
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 24, 2021

Good morning fellow Atlassianites ,

 

I recently did a test upgrade on Jira server 7.6 to 7.13. .

We then had warnings of Collation issues on the Existing SQL DB. We then had the DBA's try to correct the collation on the DB by editing it.

After they fiddled with it , it went from bad to worse. Some projects didn't want to open with the 500 error etc.

I then requested that a new DB with the correct Collation is created in the test environment and that the prod DB data is copied using native SQL tools .

I then deleted the dbconfig file and ran config.bat to point to the newly created DB which has correct collation and fresh data from the prod instance.

When starting Jira up I am now getting the Jira setup page  . If I select import Data its asking me for a file location .

 

How do I get Jira not to want to set up , but to use the new DB that was populated with prod data ?

 

Please help

 

Thanking you

2 answers

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 25, 2021

Jira will do this if it is connected to an empty database.

First thing to check is if the new database really does have all your old jira data in it and is readable by the user set up for it.

Chris Scheepers
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 26, 2021

Hi Nic ,

Thank you for engaging.

I could see there was quite a difference in size (3GB) between the backup DB and the one I was pointing to.

I have asked the DBA's to investigate 

I believe the user does have access to the DB as the connection in Jira configuration tool is successful .

 

I will revert back once I hear from the DBA

 

Kind regards

0 votes
Chris Scheepers
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 24, 2021

jirasetup.JPGimportdata.JPG

Suggest an answer

Log in or Sign up to answer