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

[#1]

Article Number

000036669

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
 

Image description

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.