Log Artifacts generation fails due to ORA-31061 error in ASR report generation in RSA Identity Governance & Lifecycle
Originally Published: 2021-03-11
Article Number
Applies To
RSA Version/Condition: 7.1.1, 7.2.0, 7.2.1
Issue
The Log Artifacts generation fails when generating the ASR (Aveksa System Report). The following error is logged in the aveksaServer.log:
02/01/2021 13:17:51.664 WARN (LogArtifactJob) [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] SQL Error: 31061, SQLState: 99999 02/01/2021 13:17:51.664 ERROR (LogArtifactJob) [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] ORA-31061: XDB error: special char to escaped char conversion failed.
The ASR (Aveksa System Report) fails when generated from the UI > Admin > Diagnostics tab. The following error is logged in the aveksaServer.log:
01/07/2021 20:16:47.131 ERROR (SystemReportGenerator) [com.aveksa.server.system.SystemReportGenerator] ASR Params: [Lcom.aveksa.server.db.ProcedureParameter;@62c33be7com.aveksa.server.db.PersistenceException: java.sql.SQLException: ORA-31061: XDB error: special char to escaped char conversion failed.ORA-06512: at "AVUSER.SYSTEM_REPORT", line 287ORA-06512: at line 1
Cause
Resolution
- RSA Identity Governance & Lifecycle 7.1.1 P13
- RSA Identity Governance & Lifecycle 7.2.0 P08
- RSA Identity Governance & Lifecycle 7.2.1 P03
Workaround
Related Articles
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired Number of Views ORA-31061 or ORA-19202 generating ASR report or Log Artifacts in RSA Identity Governance & Lifecycle Number of Views RSA Authentication Manager 8.2 SP1 Vulnerabilities in the Linux kernel – False Positive Number of Views Require Users to Change Their RSA SecurID PINs Number of Views Data Archiving fails with 'Error saving data archival job for the date range' in RSA Identity Governance & Lifecycle Number of Views
Trending Articles
RSA Authentication Manager 8.9 Release Notes (January 2026) Artifacts to gather in RSA Identity Governance & Lifecycle RSA MFA Agent 2.4.3 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.8 Setup and Configuration Guide RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
