I know that 6.4 is obsolete, but I plan to upgrade it to higher version and wanted to recreate the prod environment on my test machine.
When I try to export database into XML format I receive the following error:
I have already found one possible solution to resolve this issue: disabling auto-export but it does not work for me, although I restarted the JIRA server twice and checked in JIRA UI that jira.autoexport = false . I also checked in database there is no such view/table as "clusteredjob".
Currently I am blocked with the migration. Do you have any idea if there are any other solutions for this problem.
My JIRA instance is standalone and uses Oracle as database. Below I attached stacktrace.
"The backup to file '/opt/apps/jira/jira-data/export/2017-Oct-02--1900.zip' failed.
The backup file has been moved aside to '/opt/apps/jira/jira-data/export/corrupted'.
An exception stack trace follows:
com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, JOB_ID, JOB_RUNNER_KEY, SCHED_TYPE, INTERVAL_MILLIS, FIRST_RUN, CRON_EXPRESSION, TIME_ZONE, NEXT_RUN, VERSION, PARAMETERS FROM clusteredjob (ORA-00942: table or view does not exist
Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, JOB_ID, JOB_RUNNER_KEY, SCHED_TYPE, INTERVAL_MILLIS, FIRST_RUN, CRON_EXPRESSION, TIME_ZONE, NEXT_RUN, VERSION, PARAMETERS FROM clusteredjob (ORA-00942: table or view does not exist
... 18 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
Can you confirm with us the version of Oracle you are running?
You'll want to have a look at this article as well: How to Fix Oracle Error ORA-00942: table or view does not exist. Please also have a look at the following article for a list of required permissions for the Jira user.
Ensure your connection is configured properly, the database server is online, and that your user has the correct permissions. Keep in mind that only versions 11G with Oracle 11.2.x drivers and 12C are supported.
Hi Shannon, Thank you for response.
The database is Oracle 12c and it works fine, There are no issues with connection to it. The only problem I have right now is the database export.
The exception attached in my first message is rather clear. JIRA tries to access clusteredjob table that does not exist in database. It is strange because we did not drop any tables/views. Only limited number of administrators has access to this database.
I also reviewed the provided link but unfortunately they are not connected with this case.
I've seen that exact message resolved by the earlier article, but here's another one that could be related:
You can give that a try and see if it helps to create the clusteredjob table.
If not, please let me know, and I'll create a support ticket in our system where I can obtain your support zip.
If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...
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!
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
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot