My activities

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.logWhen the upgrade is finished, review the upgradedatabaseschema.log for errors.


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Powered by Zendesk