Running Data_Retention_Pkg.Prune_Access_Request gets ORA-01722: invalid number in RSA Identity Management and Governance
Originally Published: 2016-12-05
Article Number
Applies To
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 6.9.1P15
Issue
Error starting at line : 2 in command -
EXECUTE Data_Retention_Pkg.Prune_Access_Request(SYSDATE-90)
Error report -
ORA-01722: invalid number
ORA-06512: at "AVUSER.DATA_RETENTION_PKG", line 59
ORA-06512: at line 1
01722. 00000 - "invalid number"
*Cause: The specified number was invalid.
*Action: Specify a valid number.Cause
Resolution
Workaround
Related Articles
An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x Number of Views Reports failing with error "net.sf.jasperreports.engine.JRException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid … Number of Views Office365 Collector fails to process 'Is Disabled' and 'Is Locked' flags and Admin Error 'ORA-01722: invalid number' in RS… Number of Views Using SQL Select nodes with RSA Identity Management and Governance Number of Views 'ORA-01722: invalid number' or 'Non supported SQL92 token at position: XXX' errors in the aveksaServer.log when rendering … Number of Views
Trending Articles
Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Governance & Lifecycle 8.0.0 Administrators Guide RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
