SUM 1.0 SP18 Error: MAIN_POSTPROC/JOB_RSFIXUPG - Oracle 12C

[Former Member]

Hello There

Error:

We are upgrade with SUM 1.0 SP18 (PL8) the GW developer system (Before Upgrade 7.4 SP05), We are planning to upgrade to 7.4 SP16.

On phase MAIN_POSTPROC/JOB_RSFIXUPG we received this error ->

# E:\temp\SUM\abap\log\RSFIXUPG2.GWD:
4 ETG011 "+-- DROP SHADOW GTTs --+"
4 ETG011 "+-- DROP /1FS/* TABLES --+"
4 ETG011 "+-- DROP ECM,COM,CME-TABLES --+"
4 ETG011 "+-- CHECK INDEX TRDIRT~NAM --+"
4 ETG011 "+-- CREATE VER_CLUSTR and CLU4 --+"
2EETG013 "CLU4" "needs to be created" "on the database"
2EETG013 "VER_CLUSTR" "needs to be created" "on the database"

Solution:

The problem was with the creation of tables CLU4 & VER_CLUSTR (Oracle Error - "The SQL statement was note executed), Error with option "NO INMEMORY", I create those tables & indexes manually and continue with the SUM.

-- Table
CREATE TABLE "VER_CLUSTR"
("CLIENT" VARCHAR2 (000009) DEFAULT '000' NOT NULL,
"ARG1" VARCHAR2 (000009) DEFAULT ' ' NOT NULL,
"PAGENO" NUMBER (000005) DEFAULT 0 NOT NULL,
"TIMESTMP" VARCHAR2 (000138) DEFAULT ' ' NOT NULL,
"PAGELG" NUMBER (000005) DEFAULT 0 NOT NULL,
"VARDATA" BLOB)
PCTFREE 10
PCTUSED 40
INITRANS 001
TABLESPACE PSAPSR3
NOCOMPRESS
STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)
LOB("VARDATA") STORE AS SECUREFILE ( NOCOMPRESS );

-- Index
select dbms_metadata.get_ddl('INDEX','VER_CLUSTR~0','SAPSR3') FROM DUAL;

CREATE UNIQUE INDEX "SAPSR3"."VER_CLUSTR~0" ON "SAPSR3"."VER_CLUSTR" ("CLIENT", "ARG1", "PAGENO")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE( INITIAL 16384 NEXT 655360 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0)
TABLESPACE "PSAPSR3"

-- Table
CREATE TABLE "CLU4"
("K1N5" VARCHAR2 (000015) DEFAULT '00000' NOT NULL,
"PAGENO" NUMBER (000005) DEFAULT 0 NOT NULL,
"TIMESTMP" VARCHAR2 (000138) DEFAULT ' ' NOT NULL,
"PAGELG" NUMBER (000005) DEFAULT 0 NOT NULL,
"VARDATA" BLOB)
PCTFREE 10
PCTUSED 40
INITRANS 001
TABLESPACE PSAPSR3
NOCOMPRESS
STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)
LOB("VARDATA") STORE AS SECUREFILE ( NOCOMPRESS )

--Index
select dbms_metadata.get_ddl('INDEX','CLU4~0','SAPSR3') FROM DUAL;

CREATE UNIQUE INDEX "SAPSR3"."CLU4~0" ON "SAPSR3"."CLU4" ("K1N5", "PAGENO")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE( INITIAL 16384 NEXT 655360 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0)
TABLESPACE "PSAPSR3"

Enjoy 🙂

Aviv Cohen

[Former Member · Accepted solution]

Problem was resolved

Please see the Solution section on the question.

Thanks

Aviv Cohen