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 Office365 Collector fails to process 'Is Disabled' and 'Is Locked' flags and Admin Error 'ORA-01722: invalid number' in RS… Number of Views Reports failing with error "net.sf.jasperreports.engine.JRException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid … 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 Using SQL Select nodes with RSA Identity Management and Governance Number of Views
Don't see what you're looking for?
