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-31061 or ORA-19202 generating ASR report or Log Artifacts in RSA Identity Governance & Lifecycle 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 How to create an Aveksa Statistics Report (ASR) in RSA Identity Governance & Lifecycle Number of Views Software Token for Windwos DeskTop, SWTDT v. 5.0.2 and later “No token storage device was detected" after reboot due to ro… Number of Views RSA Via Lifecycle and Governance 6.9.1 workflow fails with error: Symbol " has not been defined Number of Views
Trending Articles
RSA Authentication Manager 8.3 Dell 630 and 230 hardware appliance loses ability to access keyboard when running PING 4.0 … RSA SecurID software token .sdtid file fails to import into RSA SecurID Software Token 5.0 for Windows RSA Release Notes for RSA Authentication Manager 8.8 How a Multi-App Entitlement Collector (MAEDC) resolves entitlement relationships with accounts and groups collected by a M… RSA Governance & Lifecycle 8.0 Patch 10 Release Notes
Don't see what you're looking for?
