000036669 - PersistenceException Error when previewing an RSA Identity Governance & Lifecycle report that has not yet been saved

Document created by RSA Customer Support Employee on Sep 5, 2018
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000036669
Applies ToRSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.0.2, 7.1.0
 
IssueWhen 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")
CauseThis 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.
ResolutionThis issue is resolved in the following patches:
  • RSA Identify Governance & Lifecycle 7.0.2 P10, and 
  • RSA Identify Governance & Lifecycle 7.1.0 P03
WorkaroundThis issue does not occur if the report is saved before pressing the Preview button. Save the report once before attempting to preview the report. 

Attachments

    Outcomes