Web Hooks Fail with ORA-01031: insufficient privileges Exception
Symptoms
Going to Administration -> Web Hooks generates the following exception in Oracle:
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.
Last modified on Nov 2, 2018
Powered by Confluence and Scroll Viewport.