ora-00904 and sql error 904 errors in logs

Document ID : KB000107672
Last Modified Date : 24/07/2018
Show Technical Document Details
Issue:
We repeatedly see these errors in the nolio_dm_al llog file: 2017-03-24 10:38:18,738 [auditThreadPoolTaskExecutor-1] ERROR (org.hibernate.engine.jdbc.spi.SqlExceptionHelper:144) - ORA-00904: "E"."REVTYPE": invalid identifier 2017-03-24 10:38:18,738 [auditThreadPoolTaskExecutor-1] WARN (org.hibernate.engine.jdbc.spi.SqlExceptionHelper:143) - SQL Error: 904, SQLState: 42000

We'd like to understand what these are and if they need to be addressed.
Environment:
CA Release Automation 6.5.0 and above.
Cause:


This is an auditing related issue associated with creation of an artifact package / version from xml.   When creating an artifact package / version via xml the artifact package and version are in fact created, but they are not added to the audit report and errors are observed in the logs.  The only functional impact of this defect are the errors observed in the log files and the fact that the artifact package / version creation does not appear in the Audit History Report.
Resolution:
A fix will be coming soon for versions 6.5 and 6.6.