Log Artifacts generation fails due to ORA-31061 error in ASR report generation in RSA Identity Governance & Lifecycle
Originally Published: 2021-03-11
Last Modified: 2022-06-20
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
RSA WebSerivce "Invalid column name" when creating a change request to terminate a user in RSA Governance & Lifecycle 15Number of Views Change the display language for all RSA Authentication Manager 8.x consoles 397Number of Views RSA Identity Governance & Lifecycle scheduled report generation with attachments in email fails when having a slash (/) in… 61Number of Views Custom JSP pages or page tabs fail to display after upgrading to 7.1.1 or above of RSA Identity Governance & Lifecycle 186Number of Views 'The request could not be handled' error occurs upon clicking and loading change requests from Requests > Requests in RSA … 100Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities IDR SSO - Step 3: Deploy the Identity Router RSA Authentication Manager 8.9 Setup and Configuration Guide
Don't see what you're looking for?