000034502 - Running Data_Retention_Pkg.Prune_Access_Request gets ORA-01722: invalid number in RSA Identity Management and Governance

Document created by RSA Customer Support Employee on Mar 1, 2017Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000034502
Applies ToRSA Product Set: Identity Management and Governance
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 6.9.1P15
IssueIn 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.
CauseThe 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.
ResolutionNote: 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.
WorkaroundNo workaround is available.