ORA-22285 error running Data Archiving of RSA Identity Governance & Lifecycle
Originally Published: 2019-12-20
Article Number
Applies To
RSA Version/Condition: 7.1.x
Issue
11/14/2019 12:31:56.230 WARN (default task-47) [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] SQL Error: 22285, SQLState: 99999 11/14/2019 12:31:56.232 ERROR (default task-47) [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] ORA-22285: non-existent directory or file for FILEEXISTS operation ORA-06512: at "SYS.DBMS_LOB", line 786 ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1451 ORA-06512: at line 1 ... Caused by: Error : 22285, Position : 0, Sql = BEGIN :1 := ArchivePurge_Pkg.DBServer_FileExists(:2 ); END;, OriginalSql = {? = call ArchivePurge_Pkg.DBServer_FileExists(?)}, Error Msg = ORA-22285: non-existent directory or file for FILEEXISTS operation ORA-06512: at "SYS.DBMS_LOB", line 786 ORA-06512: at "AVUSER.ARCHIVEPURGE_PKG", line 1451 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ... 92 more
Cause
The required Export/Import directory is not configured properly as documented in the RSA Identity Governance & Lifecycle Database Setup and Management Guide V7.1 as it is missing the READ-WRITE permissions.
Resolution
--To confirm you have this issue...run this query
-- Follow the instructions in the guide or.... I believe it is ok here to replicate the steps needed to fix this issue even though they are documented in the guide but it is important to emphasize that they are documented You did mention the guide which is great but I'd like to see more emphasis on the fact that if you run into this issue, for once it is not the product's fault. (It has enough problems.)
-- To confirm this issue is fixed.... run this query.
Related Articles
How to resolve ORA-22285 error thrown in the Data Archiving process of RSA Identity Governance & Lifecycle Number of Views On RSA Via Lifecycle and Governance the aveksa_server start returns message: Cannot connect to the database, but the DB is up Number of Views Error "keytool error: java.lang.Exception: Failed to establish chain from reply" when importing the SSP CA signed certific… Number of Views How to create and configure certificates for HTTPS access when using intermediate CA certs in RSA Identity Governance & Li… Number of Views Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory Number of Views
Trending Articles
RSA Authentication Manager Upgrade Process RSA Release Notes for RSA Authentication Manager 8.8 RSA RADIUS Server service failed to start in the RSA Authentication Manager 8.1 Operations Console Microsoft Entra ID External MFA - Relying Party Configuration Using OIDC - RSA Ready Implementation Guide RSA Release Notes: Cloud Access Service and RSA Authenticators
Don't see what you're looking for?
