java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges when restoring XML backup

Still need help?

The Atlassian Community is here for you.

Ask the community

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

(info) 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

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.