Symptoms

The following appears in the atlassian-jira.log or catalina.out file:

Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:

Database:
name:PostgreSQL
version:9.1.2
minor version:1
major version:9

Driver:
name:PostgreSQL Native Driver
version:PostgreSQL 9.0 JDBC4 (build 801)
org.postgresql.util.PSQLException: ERROR: relation "AO_60DB71_ISSUERANKINGLOG_ID_seq" does not exist  Position: 16
        at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create(EntityManagedActiveObjects.java:79)
        at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.create(DelegatingActiveObjects.java:58)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

Cause

1. Database tables were created without the proper permissions.
2. JIRA's Database does not have the default schema. Per this ticket GHS-4443 - Getting issue details... STATUS the database may be using a different schema.
3. The JIRA DB user was excluded from the database search scope.

Resolution

1. Shut down JIRA
2. Make a full backup of your database.

3. Run the following command against the database:

   ALTER USER jirauser SET search_path TO jira,public;

   
   

   Remember to replace 'jirauser' with your actual JIRA database username and replace 'JIRA' with your actual JIRA database schema name

4. Restart JIRA