Web Hooks Fail with ORA-01031: insufficient privileges Exception

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

Going to Administration -> Web Hooks generates the following exception in Oracle:

1 2 3 4 5 6 com.atlassian.activeobjects.internal.ActiveObjectsSqlException - There was a SQL exception thrown by the Active Objects library: Database: - name:Oracle - version:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning option - minor version:2 - major version:11 Driver: - name:Oracle JDBC driver - version:11.2.0.2.0 java.sql.SQLException: ORA-01031: insufficient privileges There was a SQL exception thrown by the Active Objects library: Database: - name:Oracle - version:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning option - minor version:2 - major version:11 Driver: - name:Oracle JDBC driver - version:11.2.0.2.0 java.sql.SQLException: ORA-01031: insufficient privileges ORA-01031: insufficient privileges You are running release CR3.0.2 FE3.0.2 (20130702014905 2013-07-02), please report your release number when reporting bugs.

Cause

This exception is related to the Active Objects component of Fisheye/Crucible. The Active Objects plugin requires the CREATE SEQUENCES and CREATE TRIGGER permissions for the Oracle user, and when this is not available, this error will occur.

Resolution

  1. Stop Fisheye/Crucible.

  2. Make sure you have a complete backup of your Fisheye/Crucible instance.

  3. Grant the database user CREATE SEQUENCES and CREATE TRIGGER permissions.

  4. Restart Fisheye/Crucible.

Updated on April 8, 2025

Still need help?

The Atlassian Community is here for you.