Skip to main content
ExLibris

  • Subscribe by RSS
    • Rosetta
    Ex Libris Knowledge Center

    Upgrade to 3.2.1 failed with timeout on rep_DPS_10919.sql

    1. Last updated
      00:19, 9 Dec 2015
    2. Save as PDF
    • Article Type: General
    • Product: Rosetta
    • Product Version: 3.2.1

    Problem Symptoms:
    Upgrade to 3.2.1 fails with :

    xxxxx_rep00@DPS> Connected.
    Executing add index HDECONTROL_MV_IDX01 on column PID materialized view
    HDECONTROL_MV
    DECLARE
    *
    ERROR at line 1:
    ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
    ORA-06512: at line 18

    Cause:
    rep_DPS_10919.sql fails on timeout

    Resolution:
    1. Do the following:
    a) cd /exlibris/dps/d4_1/tmp/sp/3.21/build_dir_3.2.1.0/install_sp_dir/sql/structure_sql/3_2_0/ERROR/
    b) s+ rep00
    c) @rep_DPS_10919

    2. Then rerun the SP installation

    Category: SP installation

    • Article last edited: 11/20/2013