Getting "SQL execution error, ORA-20006: ORA-20004: DLP Trigger Error (T_DLP_CASE_ASSESSORA-20004: DLP Trigger Error (T_SCASE_MASTER_COUNTORA-01422: exact fetch returns more than requested number of rows" error when upgrading from 6.0.1 to 7.0.1
(Doc ID 1532534.1)
Last updated on DECEMBER 05, 2019
Applies to:Oracle Argus Safety - Version 6.0.1 to 7.0.1 [Release 6.0 to 7.0.0]
Information in this document applies to any platform.
***Reviewed for currency: 13-Jan-2015***
Argus Safety 701 upgrade: Trigger error with cmn_profile
Got the following error when upgrading from AS 6.0.1 to 7.0.1 (including DLP):
Failing script is \SQL70\ARGUS_70_special_data_change4.sql
CURSOR C1 IS SELECT CASE_ID FROM case_master where case_id > 0 and deleted is null;
FOR c1_rec IN c1
x := gss_util.f_update_worklist_for_case(c1_rec.case_id);
SQL execution error, ORA-20006: ORA-20004: DLP Trigger Error (T_DLP_CASE_ASSESSORA-20004: DLP Trigger Error (T_SCASE_MASTER_COUNTORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "DLP_STAGE.T_SCASE_MASTER_COUNT", line 116
ORA-04088: error during execut
ORA-06512: at "ARGUS_APP.GSS_UTIL", line 1391
ORA-06512: at line 7
Steps to Repeat:
Upgrade a 6.0.1 Safety and DLP database to 7.0.1 using the default Oracle Scripts
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document