Description:
After applying TIBCO ActiveMatrix(R) Platform 3.1.5_hotfix011 or later, the error 'ORA-00904: "AMFAPPLICA9_"."UNDEPLOYING": invalid identifier' is seen when SystemNode is restarted.

Symptoms:
A blank screen is seen after logging into administrator. The following error will be logged to SystemNode log.

Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "AMFAPPLICA9_"."UNDEPLOYING": invalid identifier

        at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)

        at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)

        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
        
The error will be seen in certain scenarios when SystemNode is restarted for the first time after applying TIBCO ActiveMatrix(R) Platform 3.1.5_hotfix011 or later.
Cause:
As part of TIBCO ActiveMatrix(R) Platform 3.1.5_hotfix011, the following three tables will be altered with new columns.

***
alter table "APPLICATION" add column "UNDEPLOYING" bit
alter table "COMPONENTINSTANCE" add column "PREPARINGFORUNDEPLOYFORUPGRADE" bit
alter table "TASKRESULT" add column "IDEMPOTENTSUCCESS" bit
***

If the Administrator Database user does not have DDL privilege to change these tables, the new columns will not be created and the error will be seen when accessing the new entries.

Temporarily grant DDL permission for the Administrator Database user and restart the SystemNode. This DB schema change is documented in TIB_amx_3.1.5_hotfix011_readme_addendum.pdf.

Administrator Database Schema Change
-----------------------------------
The ActiveMatrix 3.1.5_hotfix011 release includes changes that require some additive schema changes to the ActiveMatrix Administrator database (that is,new columns are added to an existing table). After applying this hotfix, the schema is altered automatically when SystemNode is restarted, provided the database user account has Data Definition Language (DDL) permissions. If the database user account has not been granted such permissions, you must temporarily grant DDL permissions for the schema to be amended automatically at SystemNode startup.

Error 'ORA-00904: "AMFAPPLICA9_"."UNDEPLOYING": invalid identifier' when SystemNode is restarted.

TIB_amx_3.1.5_hotfix011_readme_addendum.pdf from ActiveMatrix 3.1.5_hotfix011 installation package.