It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Trying to do a full export of jira getting an error

I'm looking to upgrade from 5.1 to 5.2 and always try to take an export before doing this, however I'm getting

Error exporting data: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, CREATED, TOKEN, TOKEN_SECRET, TOKEN_TYPE, CONSUMER_KEY, USERNAME, TTL, spauth, CALLBACK, spverifier, spversion, SESSION_HANDLE, SESSION_CREATION_TIME, SESSION_LAST_RENEWAL_TIME, SESSION_TIME_TO_LIVE FROM oauthsptoken (Invalid column name 'SESSION_HANDLE'.)

when I try to do the export. Is there something I can do to remedy this ?

2 answers

1 accepted

0 votes
Answer accepted

I wasn't trying an upgrade at the time, just trying to get a manual backup before upgrade. This did't work so I went ahead anyway (already had autoexport disabled from a previous upgrade).

The upgrade was ok and now I can backup too.

Hi Paul,

It looks like the problem may occur because of missing column in the oauthsptoken. Hence, the problem occurs when we try to generate a copy of JIRA backup data.

I did a quick check on this, and I believe that this KB article may help us to fix the problem:
- https://confluence.atlassian.com/display/JIRAKB/JIRA+Upgrade+Fails+with+Invalid+Column+Name+Error

Therefore, could you kindly try to perform the workaround suggested, and see if it helps?

Thanks.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published Thursday in Confluence

Confluence CVEs and common questions

Two vulnerabilities have been published for Confluence Server and Data Center recently: March 20, 2019 CVE-2019-3395 / CVE-2019-3396 April 17, 2019 CVE-2019-3398 The goal of this article is...

116 views 0 10
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you