PersistenceException Error when previewing an RSA Identity Governance & Lifecycle report that has not yet been saved
4 years ago
Originally Published: 2018-08-29
Article Number
000041268
Applies To
RSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.0.2, 7.1.0
 
Issue
When attempting to create a new RSA Identify Governance & Lifecycle report and clicking the Preview button, the report fails to generate a preview and the report displays the following message:
 
com.aveksa.server.db.PersistenceException: com.aveksa.server.db.PersistenceException: n/a
 
User-added image

In addition, the following messages are logged in the /home/oracle/wildfly-10.1.0.Final/standalone/log/aveksaServer.log: 
08/29/2018 17:32:06.643 ERROR (default task-8) [com.aveksa.server.report.Report] Error while saveRunResults
com.aveksa.server.db.PersistenceException: n/a
...
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement
...
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("AVUSER"."T_AV_REPORT_RESULTS"."REPORT_ID"
  
08/29/2018 17:32:06.649 ERROR (default task-8) [com.aveksa.server.report.Report] SQL: SELECT * FROM V_AVR_USERACCESS WHERE 1=1 
com.aveksa.server.db.PersistenceException: com.aveksa.server.db.PersistenceException: n/a
...
Caused by: com.aveksa.server.db.PersistenceException: n/a
...
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement
...
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("AVUSER"."T_AV_REPORT_RESULTS"."REPORT_ID")
  
08/29/2018 17:32:06.650 ERROR (default task-8) [com.aveksa.server.report.Report] Error in fillReport
com.aveksa.server.runtime.ServerException: com.aveksa.server.db.PersistenceException: com.aveksa.server.db.PersistenceException: n/a
...
Caused by: com.aveksa.server.db.PersistenceException: com.aveksa.server.db.PersistenceException: n/a
...
Caused by: com.aveksa.server.db.PersistenceException: n/a
...
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement
...
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("AVUSER"."T_AV_REPORT_RESULTS"."REPORT_ID")
Cause
This is a known issue in the following versions.
  • RSA Identify Governance & Lifecycle 7.0.2 P05 and later
  • RSA Identify Governance & Lifecycle 7.1.0 GA and later
The problem occurs if an attempt is made to preview the report before it has been saved because the REPORT_ID does not yet have a value.
Resolution
This issue is resolved in the following patches:
  • RSA Identify Governance & Lifecycle 7.0.2 P10, and 
  • RSA Identify Governance & Lifecycle 7.1.0 P03
Workaround
This issue does not occur if the report is saved before pressing the Preview button. Save the report once before attempting to preview the report. 

Related Articles

Trending Articles

Don't see what you're looking for?