JIRA 6.4.14 - Issue while exporting database to XML format Edited

Hi, 

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:

  • An exception occurred backing up: 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<br/> )

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.

Thank you,

"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
)
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findListIteratorByCondition(DefaultOfBizDelegator.java:535)
at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.findListIteratorByCondition(WrappingOfBizDelegator.java:349)
at com.atlassian.jira.action.admin.export.DefaultSaxEntitiesExporter.exportEntity(DefaultSaxEntitiesExporter.java:147)
at com.atlassian.jira.action.admin.export.DefaultSaxEntitiesExporter.exportEntities(DefaultSaxEntitiesExporter.java:110)
at com.atlassian.jira.bc.dataimport.DefaultExportService.exportJIRA(DefaultExportService.java:203)
at com.atlassian.jira.bc.dataimport.DefaultExportService.export(DefaultExportService.java:89)
at com.atlassian.jira.bc.dataimport.DefaultExportService.export(DefaultExportService.java:71)
at com.atlassian.jira.service.services.export.ExportService.performBackup(ExportService.java:148)
at com.atlassian.jira.service.services.export.ExportService.run(ExportService.java:133)
at com.atlassian.jira.service.JiraServiceContainerImpl.run(JiraServiceContainerImpl.java:66)
at com.atlassian.jira.service.ServiceRunner.runService(ServiceRunner.java:77)
at com.atlassian.jira.service.ServiceRunner.runServiceId(ServiceRunner.java:54)
at com.atlassian.jira.service.ServiceRunner.runJob(ServiceRunner.java:37)
at com.atlassian.scheduler.core.JobLauncher.runJob(JobLauncher.java:136)
at com.atlassian.scheduler.core.JobLauncher.launchAndBuildResponse(JobLauncher.java:101)
at com.atlassian.scheduler.core.JobLauncher.launch(JobLauncher.java:80)
at com.atlassian.scheduler.quartz1.Quartz1Job.execute(Quartz1Job.java:32)
at org.quartz.core.JobRunShell.run(JobRunShell.java:223)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
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
)
at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:642)
at org.ofbiz.core.entity.GenericDAO.createEntityListIterator(GenericDAO.java:967)
at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:883)
at org.ofbiz.core.entity.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:194)
at org.ofbiz.core.entity.GenericDelegator.findListIteratorByCondition(GenericDelegator.java:1235)
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findListIteratorByCondition(DefaultOfBizDelegator.java:530)
... 18 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)

 

1 answer

0 votes

Hi there,

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.

Kind Regards,
Shannon

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.

Best regards,
Rafal

Hi Rafal,

I've seen that exact message resolved by the earlier article, but here's another one that could be related:

Could not create table due to missing field type definition

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.

Kind Regards,
Shannon

Thank you Shannon, it can be very helpful. I will analyze this document and check if it helps to resolve my issue. 

You're welcome, Rafal. Good luck and let us know if you run into any issues with it.

Kind Regards,
Shannon

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

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

890 views 5 18
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
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