ORA-22285 error running Data Archiving of RSA Identity Governance & Lifecycle
Originally Published: 2019-12-20
Last Modified: 2026-05-13
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
Can RSA Identity Governance and Lifecycle 7.0.0 run on SLES 11 SP4? Number of Views How to increase the max-pool-size for the Workpoint data source (WPDS) in RSA Identity Governance & Lifecycle Number of Views Test connector settings of an Active Directory LDAP AFX Connector configured to use SSL over port 636 fails with 'Failed c… Number of Views Problem syncing interface error when committing network changed on the RSA SecurID Access Identity Router Number of Views How to purge table data prior to version 7.0.1 in RSA Identity Governance & Lifecycle Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Authentication Manager Security Console and Operations Console Inaccessible After Certificate Update How to Forward RSA Authentication Manager 8.4 or Later Logs to Multiple Syslog Servers Using rsyslog RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
