java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges when restoring XML backup
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
When trying to restore the XML backup of the instance, you will hit into the following ERROR stack trace as an example:
The following appears in the atlassian-jira.log or catalina.out:
1
2
3
4
5
6
7
2013-07-19 22:48:29,555 JiraImportTaskExecutionThread-1 ERROR admin 815x337x1 1f1udes 10.9.13.94 /secure/admin/XmlRestore.jspa [jira.bc.dataimport.DefaultDataImportService] Error during ActiveObjects restore
com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin Atlassian Navigation Links Plugin(com.atlassian.plugins.atlassian-nav-links-plugin) #3.2.2.1 (table AO_38321B_CUSTOM_CONTENT_LINK):Error executing update for SQL statement 'CREATE SEQUENCE "AO_38321B_CUSTOM_CO518521787" INCREMENT BY 1 START WITH 1 NOMAXVALUE MINVALUE 1'
at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:30)
...
Caused by: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)Cause
This is caused by the user permissions used by JIRA a application for connecting to your Oracle database.
Resolution
Ensure that the following permissions are granted as they are needed by the JIRA applicationuser:
grant connect to <user>;
grant create table to <user>;
grant create sequence to <user>;
grant create trigger to <user>;
ℹ️ For more information about how to connect JIRA applications to an Oracle database, please refer to the Connecting JIRA applications to Oracle document.
Was this helpful?