Running Data_Retention_Pkg.Prune_Access_Request gets ORA-01722: invalid number in RSA Identity Management and Governance
2 years ago
Originally Published: 2016-12-05
Article Number
000043026
Applies To
RSA Product Set: Identity Management and Governance
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 6.9.1P15
 
Issue
In certain circumstances, running the command EXECUTE Data_Retention_Pkg.Prune_Access_Request(SYSDATE-90); can result in the following error.
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
The error is cause by non-numeric data in the column AVUSER.WP_WORK_ITEM_HIST.LU_ID.  In most cases, this column will contain only numeric data.  However, in some cases, it may contain the value Workpoint.
Resolution
Note: Do not attempt to remove the Workpoint data from table AVUSER.WP_WORK_ITEM_HIST.  To resolve this issue, upgrade to 6.9.1 P21.
Workaround
No workaround is available.