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

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
Community showcase
Posted Tuesday in United States

Topic Tuesday: What's your favorite topic?

Good morning All, Our goal is to get you into the habit of while enjoying your favorite morning drink you are checking the NOVA "space" for topics and comments. Your input is really needed and...

67 views 4 0
View post

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