KB-1053 "ORA-00904: "XXXX": invalid identifier" or "ORA-02289: sequence does not exist" errors thrown when running Query Database smart service

Symptoms

If an Oracle database was recently upgraded or migrated, either of the following errors could appear in the form of an Appian alert when running the Query Database smart service:

There was a problem executing the SQL query. SQL Message : ORA-00904: "XXXX": invalid identifier

There was a problem executing the SQL query. SQL Message : ORA-02289: sequence does not exist

The same error will also be seen in application server log.

Cause

The above errors mean Appian is unable to see those objects in the configured schema. The following are possible reasons for this:

• If the database has been upgraded or migrated recently, then the original data may not have been migrated properly or at all.
• If using JBoss, appian-ds.xml may be misconfigured and pointing to the wrong schema. Alternatively, the user account may not have enough permissions to see the objects, tables, or sequences in the schema.

Action

• Have your DBA verify the integrity of the migration by redoing the migration in the database.

• If using JBoss, make sure appian-ds.xml is properly configured to point to the correct schema and the user account has sufficient permissions over the schema.

Affected Versions

This article applies to all versions of Appian.