Error: Upgrade fails ORA-00904 CONTAINS invalid identifier

RiskVision upgrade failed with error: "Exception in thread "main" com.agiliance.common.ALException: code: 0 ORA-00904: "CONTAINS": invalid identifier". The issue only occurs when RiskVision is running on an Oracle database.

Resolution: Most likely, the Oracle Text option is not installed on the database server.

1. Make sure to install Oracle Text  
2. Open a command prompt and navigate to the AGILIANCE_HOME\install\toolbox\bin directory.
3. Type the command upgradedatabaseschema.cmd > upgradedatabaseschema.log. When the upgrade is finished, review the upgradedatabaseschema.log for errors.