java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges when restoring XML backup
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
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) #220.127.116.11 (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)
This is caused by the user permissions used by JIRA a application for connecting to your Oracle database.
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.