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.
- Make sure to install Oracle Text
- Open a command prompt and navigate to the AGILIANCE_HOME\install\toolbox\bin directory.
- Type the command upgradedatabaseschema.cmd > upgradedatabaseschema.log. When the upgrade is finished, review the upgradedatabaseschema.log for errors.