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
ASR fails to generate with 'ORA-31011: XML parsing failed' and 'LPX-00241: entity reference is not well formed' errors in … Number of Views RSA MFA Agent 9.0 for PAM - Installation and Configuration Guide for Oracle and RHEL (French) Number of Views RSA MFA Agent 9.0 for PAM Release Notes (French) Number of Views Backup fails with an error: "Command failed due to timeout of 3600000 milliseconds" on RSA Authentication Manager in 8.4 Number of Views View history of review definition changes and what changes were made in RSA Identity Governance & Lifecycle Number of Views
Trending Articles
How to delete old or pending certificate signing requests for RSA Authentication Manager console or virtual host replaceme… Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory How to import CA signed console cert from AM 8.x primary into a new primary with same FQDN How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device How to 'Trust' the RSA Authentication Manager Security Console Self-Signed Root CA certificate and prevent Cert warnings.
Don't see what you're looking for?
