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. * Cannot start a manual XML backupFehler * 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 * Cannot create a Jira Help Desk project* 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

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

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

Accepted answers

Pat B.

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

All comments

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!

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?

Pat B.

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

victor_martinez_0mplxo

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)

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-core

backup