• 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