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
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
Creating Multiple Requests and Archiving Requests Number of Views Data Purging after Data Archiving run may take longer than expected in RSA Identity Governance & Lifecycle Number of Views Data Archiving fails with 'Error saving data archival job for the date range' in RSA Identity Governance & Lifecycle Number of Views Script files required to restore a Data Archive in RSA Identity Governance & Lifecycle Number of Views Data Archiving fails in Data Purging step in RSA Identity Governance & Lifecycle Number of Views
Trending Articles
RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA Release Notes for RSA Authentication Manager 8.8 RSA Authentication Manager 8.9 Release Notes (January 2026) Deploying RSA Authenticator 6.2.2 for Windows Using DISM RSA MFA Agent 2.4 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
