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 DECEMBER 31, 2020

Applies to:

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


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:

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

  FOR cur_c1 IN enterprise
  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)
  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;
  pkg_rls.set_context ('system', 0, 'ARGUS_SAFETY');

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


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

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