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
Stop Fisheye/Crucible.
Make sure you have a complete backup of your Fisheye/Crucible instance.
Grant the database user CREATE SEQUENCES and CREATE TRIGGER permissions.
Restart Fisheye/Crucible.
Was this helpful?