Upgrade from BRM 73 to 74 Failed While Executing pin_73patch_74_upgrade.pl (Doc ID 1598035.1)

Last updated on MARCH 26, 2019

Applies to:

Symptoms

Scenario 1

• Upgrade is being carried out in the following path 7.2.1 --> 7.3 --> 7.4 --> 7.5
• During upgrade from 7.3 to 7.4, the execution of script pin_73patch_74_upgrade.plfails. See below steps carried out:
  • Install 7.4_7594320_ThirdParty_Upgrade_solaris_32_opt.bin
  • Install 7.4_7594320_Portal_Base_solaris_32_opt.bin
  • Execute perl pin_73patch_74_upgrade.pl
  • There is an error in default_values_74.source.
    Error description:

    "ORA-01427: single-row subquery returns more than one row".

  • Relevant patch 9802683 identified to solve the problem.
  • Apply patch 9802683
  • Execute perl pin_73patch_74_upgrade.pl. Same error occurs:
    

    "ORA-01427:single-row subquery returns more than one row"

  • The problem seems to be in the audit table. The following sql query fails:
    

    SELECT obj_id0 INTO v_obj_id0 FROM au_service_adminclient_t WHERE obj_id0 = (
    SELECT poid_id0 FROM au_service_t WHERE account_obj_id0 = 1 AND POID_TYPE
    = '/au_service/admin_client' AND LOGIN like 'root%');

    Because the following query returns 2 rows:
    

    SELECT * FROM au_service_t WHERE account_obj_id0 = 1 AND POID_TYPE =
    '/au_service/admin_client' AND LOGIN like 'root%'

Scenario 2

• Upgrade is being carried out as 6.5 --> 7.3 --> 7.4 --> 7.5
• During the 7.3 to 7.4 upgrade, the "default_values_74.pl" fails. see below details:
  • Below is the error snippet:
    
  • This happens when "default_values_74.source" tries to execute below sql query as already seen in previous scenario:
    

    SELECT obj_id0 INTO v_obj_id0 FROM au_service_adminclient_t WHERE obj_id0 = (
    SELECT poid_id0 FROM au_service_t WHERE account_obj_id0 = 1 AND POID_TYPE
    = '/au_service/admin_client');

  • On checking further, it seems that the "au_service_t" is empty.

Changes

Cause

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