My Oracle Support Banner

Error Upgrading Argus 8.0 Database : ORA-01427: Single-row Subquery Returns More Than One Row ORA-06512: at line 13 (Doc ID 2738893.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Safety - Version 8.0 and later
Information in this document applies to any platform.

Goal

Upgrading to Argus Safety 8.2.2 from Argus 7.0.7.

In order to achieve this executing Patch 24497302 to first upgrade from Argus 7.0.7 to Argus 8.1 and then to Argus 8.2.2

While executing the DB Upgrade from Patch 24497302 on Argus 8.0 Database (Oracle 12c) getting below error message:


DECLARE
  CURSOR enterprise
  IS
  SELECT enterprise_id
  FROM cfg_enterprise;
BEGIN
  pkg_rls.set_context ('system', 0, 'ARGUS_SAFETY');

  FOR cur_c1 IN enterprise
  LOOP
  pkg_rls.set_context ('system', cur_c1.enterprise_id, 'ARGUS_SAFETY');

  UPDATE lm_study_references lsr
  SET (REFERENCE, license_id) =
  (SELECT lic.lic_number, lic.license_id
  FROM lm_license lic
  WHERE lic.lic_number = lsr.REFERENCE)
  WHERE EXISTS (SELECT 1
  FROM lm_study_references lsr, lm_license lic
  WHERE lsr.REFERENCE = lic.lic_number)
  AND lsr.ref_type_id = 5
  AND lsr.country_id = 223;
  END LOOP;
  pkg_rls.set_context ('system', 0, 'ARGUS_SAFETY');
END;


Exception: Exception: ORA-01427: single-row subquery returns more than one row
ORA-06512: at line 13


Above SQL originates from the file "Argus_81_data_change3.sql"

Below are the details for the patch being utilized to upgrade:

1) Patch Number : 2449730
2) DB Installer path : p24497302_80000_Generic\AS8.1.0.91\ARGUS_UPGRADE_FROM_707_TO_81\ARGUS_UPGRADE_FROM_80_TO_81\Argus\DBInstaller
 

Solution

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
Goal
Solution
References


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