Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Cannot create a backup from older version of JIRA.

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


    • 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


4 answers

1 accepted

0 votes
Answer accepted

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

speaking about the backup and accessing this backup file I think would be nice to have the possibility to download from JIRA (so don't need to access directly the server's disk)

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?

0 votes
Mirek Community Leader Mar 26, 2018

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..

It the upgrade of Tempo successfully completed?

Please check official docs for more information about upgrading Tempo -

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...

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

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events