Known issues with upgrading from version 5.5.10 using Oracle Database implementation

If you want to upgrade Insight from version 5.5.10 to a later version and your database implementation uses the Oracle database, perform these steps first:

  1. Drop the table "AO_8542F1_IFJ_OBJ_KEY_MAP".
  2. Run this script to set back the upgrade number:

    UPDATE propertystring
    SET propertyvalue =
    WHERE id = (
    SELECT id
    FROM propertyentry
    WHERE property_key =
  3. Upgrade to the latest version of Insight.
If you've already upgraded and still encounter issues with Insight, follow the steps from 1 → 3 with new step 3: Reinstall the latest version of Insight.

If you receive the following error message:

Error : 955, Position : 16, Sql = CREATE SEQUENCE "AO_8542F1_IFJ_OBJ_K1221106816" INCREMENT BY 1 START WITH 1 NOMAXVALUE MINVALUE 1, OriginalSql = CREATE SEQUENCE "AO_8542F1_IFJ_OBJ_K1221106816" INCREMENT BY 1 START WITH 1 NOMAXVALUE MINVALUE 1, Error Msg = ORA-00955: name is already used by an existing object

This means there's a sequence that is already present in your database. In this case, you need to drop the sequence as well reference the old table you dropped. Try the following steps:

  1. Run this SQL:

    SELECT AO_8542F1_IFJ_OBJ_K1221106816.nextval from DUAL;
  2. Drop this sequence (AO_8542F1_IFJ_OBJ_K1221106816).
  3. Retry to re-install Insight.

You're all set.

This will prevent you from getting the following error message:

Error message about contacting admin

And rendering the following stack trace in your atlassian-jira.log, it might also cause issues starting Insight:

com.atlassian.cache.CacheException: com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.riadalabs.jira.plugins.insight]
    at com.atlassian.cache.memory.DelegatingCache.get(
Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
    - name:Oracle
    - version:Oracle Database 12c Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
    - minor version:1
    - name:Oracle JDBC driver
    - version:
java.sql.SQLException: ORA-02429: cannot drop index used for enforcement of unique/primary key
    at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(

Last modified on Oct 14, 2021

Was this helpful?

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