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.
The above errors mean Appian is unable to see those objects in the configured schema. The following are possible reasons for this:
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.
This article applies to all versions of Appian.
Last Reviewed: February 2017
© 2020 Appian. All rights reserved.