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 JULY 13, 2023

Applies to:

Symptoms

Argus Safety 701 upgrade: Trigger error with cmn_profile

Issue Description:
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
Error is:
DECLARE
x NUMBER;
CURSOR C1 IS SELECT CASE_ID FROM case_master where case_id > 0 and deleted is null;
BEGIN
FOR c1_rec IN c1
LOOP
x := gss_util.f_update_worklist_for_case(c1_rec.case_id);
END LOOP;
END;

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

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.