ora-00904 and sql error 904 errors in logs

book

Article ID: 107672

calendar_today

Updated On:

Products

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

Issue/Introduction

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.

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.

Environment

CA Release Automation 6.5.0 and above.

Resolution

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