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 JANUARY 13, 2015

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***

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms