Cannot create a backup from older version of JIRA.

[Pat B.]

We've been upgrading Jira from an older release to the actual 7.8.1, hosted on Windows Server 2008R2 on MSSQL.

After performing this, we're having some strange issues.

1. Cannot start a manual XML backup

   Fehler

   • Ausnahme bei Sicherung: java.lang.IllegalStateException: TABLE: AO_013613_EXPENSE: AMOUNT - CREATED - CREATED_BY - DATE - DESCRIPTION - EXPENSE_CATEGORY_ID - ID - SCOPE - SCOPE_TYPE - can't find type -151 (precision=23,scale=3) in field CREATED
2. Cannot create a Jira Help Desk project
   1. Hmm... we couldn't create your project due to an unknown error. Try refreshing the page to start again

How can we correct this? It's the first time we're having Issues with Jira - Please tell me how to troubleshoot this.

We will then move the Jira installation to a Ubuntu/Postgres based setup.

Kind regards

patrick

[Pat B. · Accepted solution]

Just to keep you updated - it was caused by an unsupported encoding of the SQL Database :)

[victor_martinez]

speaking about the backup and accessing this backup file I think would be nice to have the possibility to download from JIRA https://jira.atlassian.com/browse/JRASERVER-74216 (so don't need to access directly the server's disk)

[Pat B.]

In the meantime, I've as well uninstall/deleted the add-on as well as deleted the given table in the SQL database. But the XML backup still doesn't work. The error persists, just altering the table name.

Any ideas?

[Mirek]

TABLE: AO_013613_EXPENSE seems like an issue with Tempo Timesheets plugin. Are you using it? Did you upgrade it to the latest version after upgrading JIRA? You should run 8.8.1 or later if using 7.8 JIRA..

https://tempoplugin.jira.com/wiki/spaces/TT/pages/39321676/Tempo+Timesheets+Compatibility+with+JIRA

It the upgrade of Tempo successfully completed?

Please check official docs for more information about upgrading Tempo - https://tempoplugin.jira.com/wiki/spaces/TT/pages/38797469/Tempo+Timesheets+upgrade+notes

[Pat B.]

Thank you for your reply!

Yes, we indeed use Tempo Timesheets, in the actual version 8.9.1. But I found another error while accessing the admin page in the Add-on where I tried to access the "secure/admin/TempoGlobalConfiguration!default.jspa" site. Got the "Oops" 404 error...

[Pat B.]

I had a look at the MSSQL DB and found out the table AO_013613_EXPENSE is empty!