R12.1.1 upgrade fails on zpbsecupg.sql
R12.1.1 upgrade fails on zpbsecupg.sql
Problem Summary
---------------------------------------------------
R12.1.1 upgrade fails on zpbsecupg.sql
Problem Description
---------------------------------------------------
worker fails with
sqlplus -s APPS/***** @/trv/trn/app/apps/apps_st/appl/zpb/12.0.0/patch/115/sql/zpbsecupg.sql
DECLARE
*
ERROR at line 1:
ORA-33262: Analytic workspace ZPB.ZPBANNOT2 does not exist.
aw attach ZPB.ZPBANNOT2 rw
ORA-06512: at "SYS.DBMS_AW", line 93
ORA-06512: at "SYS.DBMS_AW", line 122
ORA-06512: at "APPS.ZPB_AW", line 24
ORA-06512: at "APPS.ZPB_AW", line 465
ORA-06512: at line 23
Error Codes
---------------------------------------------------
ORA-33262
Looked at the code in the failing script. The analytic workspace it is looking for doesn't exist. The value of data_aw is NOT ZPB but ZPBDATA2.
Problem Summary
---------------------------------------------------
R12.1.1 upgrade fails on zpbsecupg.sql
Problem Description
---------------------------------------------------
worker fails with
sqlplus -s APPS/***** @/trv/trn/app/apps/apps_st/appl/zpb/12.0.0/patch/115/sql/zpbsecupg.sql
DECLARE
*
ERROR at line 1:
ORA-33262: Analytic workspace ZPB.ZPBANNOT2 does not exist.
aw attach ZPB.ZPBANNOT2 rw
ORA-06512: at "SYS.DBMS_AW", line 93
ORA-06512: at "SYS.DBMS_AW", line 122
ORA-06512: at "APPS.ZPB_AW", line 24
ORA-06512: at "APPS.ZPB_AW", line 465
ORA-06512: at line 23
Error Codes
---------------------------------------------------
ORA-33262
Looked at the code in the failing script. The analytic workspace it is looking for doesn't exist. The value of data_aw is NOT ZPB but ZPBDATA2.
Tagged:
0