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

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:

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


Suggest an answer

Log in or Join to answer
Community showcase
Louis De Jaeger
Posted Thursday in Off-topic

Friday fun: your best joke

Hi all Lets make this Friday fun really fun and post one (or more) of your best jokes! The joke can be about an Atlassian product, or just a really fun joke you want to share! I’m not the best j...

189 views 12 3
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot