java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges when restoring XML backup
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:
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 application user:
- 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.
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.