Hi - we are working on migrating jira from Postgres to Azure SQL and also upgrade to the latest version.
we are currently at version 7.8.4 of jira and would like to get to 8.11
SInce this migration is between different database, I started with setting up a new empty instance of Version 7.8.4 connecting to the Azure SQL.
Once setup I used the backup XML zip file from our current production Jira instance (v7.8.4) and used it to restore the new instance of same version 7.8.4.
After restore is complete. I see the boards button but when clicked on the button there are not boards to see.
Also when i looked into the table AO_60DB71_RAPIDVIEW and AO_60DB71_SPRINT and they are both empty.
also when i looked at the log during restore, I see after 90% of the import there were error for
(SQL Exception while executing the following:INSERT INTO dbo.projectversion (ID, PROJECT, vname, DESCRIPTION, SEQUENCE, RELEASED, ARCHIVED, URL, STARTDATE, RELEASEDATE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.))
and then after that i see that
2020-09-02 14:47:42,646 JiraImportTaskExecutionThread-1 WARN jiraadmin 765x70x1 1nftu1f 10.141.24.29 /secure/admin/XmlRestore.jspa [c.a.j.p.d.dao.impl.CachingOrganizationDaoImpl] onImportCompleted - clearing cache !!
2020-09-02 14:47:42,673 JiraImportTaskExecutionThread-1 INFO jiraadmin 765x70x1 1nftu1f 10.141.24.29 /secure/admin/XmlRestore.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing data is 100% complete...
2020-09-02 14:47:42,674 JiraImportTaskExecutionThread-1 INFO jiraadmin 765x70x1 1nftu1f 10.141.24.29 /secure/admin/XmlRestore.jspa [c.a.j.bc.dataimport.DefaultDataImportService] JIRA Data Import has finished.
Not sure why Boards are not imported.
Thanks
Gopi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.