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
IWA RSA connector server shows wrong certificate when connecting to it through browser with error : Invalid Request 3Number of Views Authentication Manager Log Messages (13001-13008) 195Number of Views How to turn on debug logging to troubleshoot AFX connectors in version 7.5.2 of RSA Governance & Lifecycle 185Number of Views Authentication Manager Log Messages (10001-10060) 77Number of Views RSA Authentication Manager 8.3 P4 - Summary of Known Third-Party Component Vulnerabilities Under Investigation 36Number of Views
Trending Articles
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x
Don't see what you're looking for?