ora-00904 and sql error 904 errors in logs


Article ID: 107672


Updated On:


CA Release Automation - Release Operations Center (Nolio) CA Release Automation - DataManagement Server (Nolio)


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.


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.


CA Release Automation 6.5.0 and above.


A fix will be coming soon for versions 6.5 and 6.6.