Solved: Software Upgrade Manager! FATAL ERROR Checking job...

Dear Experts,

I am upgrading SAP Solution Manager 7.1 SPS with SUM tool.

During PreProcessing Phase ABAP>MAIN_SHDCRE/DBCLONE Server Down.

During this step SUM created 3 background jobs DBCLONE1,DBCLONE2 & DBCLONE3 during this phase our SAP Sytem gone down due to cloud issue. After we started our SOLMAN system job was cancelled in SM37 with status red, i deleted the job with this assumption that SUM will repeat the step n create the job unfortunately SUM is looking for these jobs and giving FATAL error (Screenshot & logs attached)

Please suggest the solution?? i reach to this prepossessing step after 4 days and don't want to scratch SUM.

Waiting for your solution.

Regards,

Qazi

SAP Managed Tags:
SAP NetWeaver Application Server

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

Could you share the usecaseexec.log

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

!--LOGHEADER[START]/-->

Mar 11, 2016 11:16:55 AM [Info ]: Parsing ABAP request, handler version1.0

Mar 11, 2016 11:16:55 AM [Info ]: Setting up shared input adapter with SID 'SMD', J2EE present 1, and instance number 00.

Mar 11, 2016 11:16:55 AM [Info ]: Setting special property SystemId='SMD'.

Mar 11, 2016 11:16:55 AM [Info ]: Setting special property J2EEPresent='1'.

Mar 11, 2016 11:16:55 AM [Info ]: Setting special property ABAPInstanceNumber='00'.

Mar 11, 2016 11:16:55 AM [Info ]: Setting ABAPInstanceNumber '00', to shared input catalogue (may be required by the TREX handler)

Mar 11, 2016 11:16:55 AM [Info ]: Setting special property HasJ2EERequest='1'.

Mar 11, 2016 11:16:55 AM [Info ]: Setting special property HasTREXRequest='0'.

Mar 11, 2016 11:16:55 AM [Info ]: Setting special property HasLCRequest='0'.

Mar 11, 2016 11:16:55 AM [Info ]: Setting special property HasCTCRequest='0'.

Mar 11, 2016 11:16:55 AM [Info ]: Setting special property HasLMAUTORequest='0'.

Mar 11, 2016 11:16:55 AM [Info ]: Setting up unit executor.

Mar 11, 2016 11:16:55 AM [Info ]: Adding configuration observer.

Mar 11, 2016 11:16:55 AM [Info ]: Registering standard observers for dialogue level 2.

Mar 11, 2016 11:16:55 AM [Info ]: Feature "dialogue" registered with level 2.

Mar 11, 2016 11:16:55 AM [Info ]: Feature "dialoghelp" registered with level 1.

Mar 11, 2016 11:16:55 AM [Info ]: Feature "html" registered with level 1.

Mar 11, 2016 11:16:55 AM [Info ]: Registering MID level 4.

Mar 11, 2016 11:16:55 AM [Info ]: Feature "mid" registered with level 4.

Mar 11, 2016 11:16:55 AM [Info ]: Adding request handler observer.

Mar 11, 2016 11:16:55 AM [Info ]: Adding unit control observer level 3.

Mar 11, 2016 11:16:55 AM [Info ]: Feature "unitcontrol" registered with level 3.

Mar 11, 2016 11:16:55 AM [Info ]: Adding progress observer.

Mar 11, 2016 11:16:55 AM [Info ]: Feature "progress" registered with level 2.

Mar 11, 2016 11:16:55 AM [Info ]: Registering shared input observer level 2.

Mar 11, 2016 11:16:55 AM [Info ]: Feature "remotecontrol" registered with level 2.

Mar 11, 2016 11:16:55 AM [Info ]: Registering synchronization observer level 2.

Mar 11, 2016 11:16:55 AM [Info ]: Feature "synchronization" registered with level 2.

Mar 11, 2016 11:16:55 AM [Info ]: Registering evaluation observer.

Mar 11, 2016 11:16:55 AM [Info ]: Feature "evaluation" registered with level 1.

Mar 11, 2016 11:16:55 AM [Info ]: Adding ABAP directory U:\SUM\abap\htdoc as HTTP alias abap

Mar 11, 2016 11:17:31 AM [Info ]: Trying to connect to tool...

Mar 11, 2016 11:17:32 AM [Info ]: Starting tool.

Mar 11, 2016 11:17:33 AM [Info ]: U:\SUM\abap\bin\SAPup.exe stdout=U:\SUM\abap\log\SAPup.out rootdir=U:\SUM\abap uaport=4240

Mar 11, 2016 11:17:33 AM [Info ]: >> Closed input stream

Mar 11, 2016 11:17:34 AM [Info ]: Connected to host ABCKHIHO12 on port 4240.

Mar 11, 2016 11:17:34 AM [Info ]: Waiting for tool to report unit status...

Mar 11, 2016 11:17:34 AM [Info ]: Tool reported version 2.0, using XML syntax for communication.

Mar 11, 2016 11:17:34 AM [Info ]: Handling configuration request from tool.

Mar 11, 2016 11:17:34 AM [Info ]: Feature "dialogue": Tool setting "unknown", server setting "enabled" level 2.

Mar 11, 2016 11:17:34 AM [Warning]: Tool asked for unknown feature "handleerror"!

Mar 11, 2016 11:17:34 AM [Info ]: Feature "handleerror": Tool setting "unknown", server setting "unknown".

Mar 11, 2016 11:17:34 AM [Info ]: Feature "dialoghelp": Tool setting "unknown", server setting "enabled" level 1.

Mar 11, 2016 11:17:34 AM [Info ]: Feature "html": Tool setting "unknown", server setting "enabled" level 1.

Mar 11, 2016 11:17:34 AM [Warning]: Tool asked for unknown feature "console"!

Mar 11, 2016 11:17:34 AM [Info ]: Feature "console": Tool setting "unknown", server setting "unknown".

Mar 11, 2016 11:17:34 AM [Info ]: Feature "progress": Tool setting "unknown", server setting "enabled" level 2.

Mar 11, 2016 11:17:34 AM [Info ]: Feature "unitcontrol": Tool setting "unknown", server setting "enabled" level 3.

Mar 11, 2016 11:17:34 AM [Warning]: Tool asked for unknown feature "unitstatus"!

Mar 11, 2016 11:17:34 AM [Info ]: Feature "unitstatus": Tool setting "unknown", server setting "unknown".

Mar 11, 2016 11:17:34 AM [Warning]: Tool asked for unknown feature "actions"!

Mar 11, 2016 11:17:34 AM [Info ]: Feature "actions": Tool setting "unknown", server setting "unknown".

Mar 11, 2016 11:17:34 AM [Info ]: Feature "remotecontrol": Tool setting "unknown", server setting "enabled" level 2.

Mar 11, 2016 11:17:34 AM [Info ]: Feature "synchronization": Tool setting "unknown", server setting "enabled" level 2.

Mar 11, 2016 11:17:34 AM [Info ]: Feature "mid": Tool setting "unknown", server setting "enabled" level 4.

Mar 11, 2016 11:17:34 AM [Warning]: Tool asked for unknown feature "exit"!

Mar 11, 2016 11:17:34 AM [Info ]: Feature "exit": Tool setting "unknown", server setting "unknown".

Mar 11, 2016 11:17:34 AM [Info ]: Feature "evaluation": Tool setting "unknown", server setting "enabled" level 1.

Mar 11, 2016 11:17:34 AM [Warning]: Tool asked for unknown feature "slpserver"!

Mar 11, 2016 11:17:34 AM [Info ]: Feature "slpserver": Tool setting "unknown", server setting "unknown".

Mar 11, 2016 11:17:34 AM [Warning]: Tool asked for unknown feature "batchconfig"!

Mar 11, 2016 11:17:34 AM [Info ]: Feature "batchconfig": Tool setting "unknown", server setting "unknown".

Mar 11, 2016 11:17:34 AM [Warning]: Tool asked for unknown feature "httpsrvcommand"!

Mar 11, 2016 11:17:34 AM [Info ]: Feature "httpsrvcommand": Tool setting "unknown", server setting "unknown".

Mar 11, 2016 11:17:34 AM [Warning]: Tool asked for unknown feature "failedbuckets"!

Mar 11, 2016 11:17:34 AM [Info ]: Feature "failedbuckets": Tool setting "unknown", server setting "unknown".

Mar 11, 2016 11:17:34 AM [Info ]: Attaching mount points from tool.

Mar 11, 2016 11:17:36 AM [Info ]: >>

Mar 11, 2016 11:17:36 AM [Info ]: >> FATAL ERROR: Checking batch job DBCLONE1/12084500 returned 1

Mar 11, 2016 11:17:36 AM [Info ]: Connection reset

Mar 11, 2016 11:17:36 AM [Info ]: Reporting failed commlink.

Mar 11, 2016 11:17:36 AM [Error ]: Tool closed connection unexpectedly.

Mar 11, 2016 11:17:36 AM [Warning]: Tool died unexpectedly.

Mar 11, 2016 11:17:36 AM [Info ]: SAPup terminated with exit code 20.

Mar 11, 2016 11:17:36 AM [Info ]: >> Closed error stream

Mar 11, 2016 11:23:00 AM [Info ]: Trying to connect to tool...

Mar 11, 2016 11:23:01 AM [Info ]: Starting tool.

Mar 11, 2016 11:23:02 AM [Info ]: U:\SUM\abap\bin\SAPup.exe stdout=U:\SUM\abap\log\SAPup.out rootdir=U:\SUM\abap uaport=4240

Mar 11, 2016 11:23:02 AM [Info ]: >> Closed input stream

Mar 11, 2016 11:23:03 AM [Info ]: Connected to host ABCKHIHO12 on port 4240.

Mar 11, 2016 11:23:03 AM [Info ]: Waiting for tool to report unit status...

Mar 11, 2016 11:23:03 AM [Info ]: Tool reported version 2.0, using XML syntax for communication.

Mar 11, 2016 11:23:03 AM [Info ]: Handling configuration request from tool.

Mar 11, 2016 11:23:03 AM [Info ]: Feature "dialogue": Tool setting "unknown", server setting "enabled" level 2.

Mar 11, 2016 11:23:03 AM [Warning]: Tool asked for unknown feature "handleerror"!

Mar 11, 2016 11:23:03 AM [Info ]: Feature "handleerror": Tool setting "unknown", server setting "unknown".

Mar 11, 2016 11:23:03 AM [Info ]: Feature "dialoghelp": Tool setting "unknown", server setting "enabled" level 1.

Mar 11, 2016 11:23:03 AM [Info ]: Feature "html": Tool setting "unknown", server setting "enabled" level 1.

Mar 11, 2016 11:23:03 AM [Warning]: Tool asked for unknown feature "console"!

Mar 11, 2016 11:23:03 AM [Info ]: Feature "console": Tool setting "unknown", server setting "unknown".

Mar 11, 2016 11:23:03 AM [Info ]: Feature "progress": Tool setting "unknown", server setting "enabled" level 2.

Mar 11, 2016 11:23:03 AM [Info ]: Feature "unitcontrol": Tool setting "unknown", server setting "enabled" level 3.

Mar 11, 2016 11:23:03 AM [Warning]: Tool asked for unknown feature "unitstatus"!

Mar 11, 2016 11:23:03 AM [Info ]: Feature "unitstatus": Tool setting "unknown", server setting "unknown".

Mar 11, 2016 11:23:03 AM [Warning]: Tool asked for unknown feature "actions"!

Mar 11, 2016 11:23:03 AM [Info ]: Feature "actions": Tool setting "unknown", server setting "unknown".

Mar 11, 2016 11:23:03 AM [Info ]: Feature "remotecontrol": Tool setting "unknown", server setting "enabled" level 2.

Mar 11, 2016 11:23:03 AM [Info ]: Feature "synchronization": Tool setting "unknown", server setting "enabled" level 2.

Mar 11, 2016 11:23:03 AM [Info ]: Feature "mid": Tool setting "unknown", server setting "enabled" level 4.

Mar 11, 2016 11:23:03 AM [Warning]: Tool asked for unknown feature "exit"!

Mar 11, 2016 11:23:03 AM [Info ]: Feature "exit": Tool setting "unknown", server setting "unknown".

Mar 11, 2016 11:23:03 AM [Info ]: Feature "evaluation": Tool setting "unknown", server setting "enabled" level 1.

Mar 11, 2016 11:23:03 AM [Warning]: Tool asked for unknown feature "slpserver"!

Mar 11, 2016 11:23:03 AM [Info ]: Feature "slpserver": Tool setting "unknown", server setting "unknown".

Mar 11, 2016 11:23:03 AM [Warning]: Tool asked for unknown feature "batchconfig"!

Mar 11, 2016 11:23:03 AM [Info ]: Feature "batchconfig": Tool setting "unknown", server setting "unknown".

Mar 11, 2016 11:23:03 AM [Warning]: Tool asked for unknown feature "httpsrvcommand"!

Mar 11, 2016 11:23:03 AM [Info ]: Feature "httpsrvcommand": Tool setting "unknown", server setting "unknown".

Mar 11, 2016 11:23:03 AM [Warning]: Tool asked for unknown feature "failedbuckets"!

Mar 11, 2016 11:23:03 AM [Info ]: Feature "failedbuckets": Tool setting "unknown", server setting "unknown".

Mar 11, 2016 11:23:03 AM [Info ]: Attaching mount points from tool.

Mar 11, 2016 11:23:03 AM [Info ]: >>

Mar 11, 2016 11:23:03 AM [Info ]: >> FATAL ERROR: Checking batch job DBCLONE1/12084500 returned 1

Mar 11, 2016 11:23:03 AM [Info ]: Connection reset

Mar 11, 2016 11:23:03 AM [Info ]: Reporting failed commlink.

Mar 11, 2016 11:23:03 AM [Error ]: Tool closed connection unexpectedly.

Mar 11, 2016 11:23:03 AM [Warning]: Tool died unexpectedly.

Mar 11, 2016 11:23:03 AM [Info ]: SAPup terminated with exit code 20.

Mar 11, 2016 11:23:04 AM [Info ]: >> Closed error stream

Above is ABAPUpgrade.log in the same directory as mentioned in JPEG.

Hi Qazi,

are you getting any init option in the SUM screen?

With Regards

Ashutosh Chaturvedi

Hi Ashutosh,

It was giving init option yesterday prior Server Downtime.

init was shown yesterday on SUM prior our server downtime due to cloud issue and its was mentioned that jobs are running wait for job finished then repeat phase... but after server down and restart i deleted the jobs in that assumption SUM will create the jobs again... but now its giving error n searching for job... Plz suggest?? what to do??

and tell me what does actually "init" means??

Qazi

Hi Qazi,

if you have rerun the SUM by checking the INIT box , it would have run the same phase from beginning.

Have you deleted the job from original system.

With Regards

Ashutosh Chaturvedi

HI,

SUM is not working after rerun the SUM.

Yes deleted from original system.

Now suggest

Hi Qazi,

Kindly paste all the three logsfor DBLCONE1,2,3.

Naming convention DBCLONE<NUMBER>.<SID>

With Regards

Ashutosh Chaturvedi

Hi Qazi,

Paste all the three logs which will be having the below naming convention.

Naming convention DBCLONE<NUMBER>.<SID>

I will just try a outbox something , which may work for you.

With Regards

Ashutosh Chaturvedi

tail of DBCLONE1

3 ETGCLN START IWB2PHIO -> IWB2PHIO~ 20160310072011

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "IWB2PHIO~" ("PHIO_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "PH_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "LOIO_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "LO_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "STATE" VARCHAR2 (000012) DEFAULT '0000' NOT NULL, "DESCRIPT" VARCHAR2 (000192) DEFAULT ' ' NOT NULL, "LANGU" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "CREA_USER" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "CREA_TIME" VARCHAR2 (000042) DEFAULT '00000000000000' NOT NULL, "CHNG_USER" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "CHNG_TIME" VARCHAR2 (000042) DEFAULT '00000000000000' NOT NULL, "STOR_CAT" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "DOC_FORMAT" VARCHAR2 (000012) DEFAULT ' ' NOT NULL, "DOC_PROT" VARCHAR2 (000012) DEFAULT ' ' NOT NULL, "PROP01" VARCHAR2 (000045) DEFAULT ' ' NOT NULL, "PROP02" VARCHAR2 (000045) DEFAULT ' ' NOT NULL, "PROP03" VARCHAR2 (000045) DEFAULT ' ' NOT NULL, "PROP04" VARCHAR2 (000045) DEFAULT ' ' NOT NULL, "PROP05" VARCHAR2 (000060) DEFAULT ' ' NOT NULL, "PROP06" VARCHAR2 (000060) DEFAULT ' ' NOT NULL, "PROP07" VARCHAR2 (000060) DEFAULT ' ' NOT NULL, "PROP08" VARCHAR2 (000120) DEFAULT ' ' NOT NULL, "PROP09" VARCHAR2 (000120) DEFAULT ' ' NOT NULL, "PROP10" VARCHAR2 (000120) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000010240 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB2PHIO~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "IWB2PHIO^0" ON "IWB2PHIO~" ("PHIO_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB2PHIO~' AND INDEXNAME = '0'

3 ETGCLN IWB2PHIO content is not required.

3 ETGCLN CREATE INDEX "IWB2PHIO^LID" ON "IWB2PHIO~" ("LOIO_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB2PHIO~' AND INDEXNAME = 'LID'

3 ETGCLN END IWB2PHIO -> IWB2PHIO~ 20160310072011

5 ETGCLN IWB2PHIO done in 0 seconds

3 ETGCLN START IWB2PHRE -> IWB2PHRE~ 20160310072012

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "IWB2PHRE~" ("REP1_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "REIO_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "REP1_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "RE_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "REP2_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "REP2_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "CREA_USER" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "CREA_TIME" VARCHAR2 (000042) DEFAULT '00000000000000' NOT NULL, "CHNG_USER" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "CHNG_TIME" VARCHAR2 (000042) DEFAULT '00000000000000' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000010240 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB2PHRE~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "IWB2PHRE^0" ON "IWB2PHRE~" ("REP1_ID", "REIO_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB2PHRE~' AND INDEXNAME = '0'

3 ETGCLN IWB2PHRE content is not required.

3 ETGCLN CREATE INDEX "IWB2PHRE^P2" ON "IWB2PHRE~" ("REP2_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB2PHRE~' AND INDEXNAME = 'P2'

3 ETGCLN CREATE UNIQUE INDEX "IWB2PHRE^REL" ON "IWB2PHRE~" ("REIO_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB2PHRE~' AND INDEXNAME = 'REL'

3 ETGCLN END IWB2PHRE -> IWB2PHRE~ 20160310072012

5 ETGCLN IWB2PHRE done in 0 seconds

3 ETGCLN START IWB2RE -> IWB2RE~ 20160310072012

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "IWB2RE~" ("REIO_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "RE_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "REP1_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "REP1_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "REP2_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "REP2_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "CREA_USER" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "CREA_TIME" VARCHAR2 (000042) DEFAULT '00000000000000' NOT NULL, "CHNG_USER" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "CHNG_TIME" VARCHAR2 (000042) DEFAULT '00000000000000' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB2RE~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "IWB2RE^0" ON "IWB2RE~" ("REIO_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB2RE~' AND INDEXNAME = '0'

3 ETGCLN IWB2RE content is not required.

3 ETGCLN CREATE INDEX "IWB2RE^P1" ON "IWB2RE~" ("REP1_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB2RE~' AND INDEXNAME = 'P1'

3 ETGCLN CREATE INDEX "IWB2RE^P2" ON "IWB2RE~" ("REP2_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB2RE~' AND INDEXNAME = 'P2'

3 ETGCLN END IWB2RE -> IWB2RE~ 20160310072012

5 ETGCLN IWB2RE done in 0 seconds

3 ETGCLN START IWB4CHKF -> IWB4CHKF~ 20160310072012

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "IWB4CHKF~" ("PHIO_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "FILE_NUM" VARCHAR2 (000030) DEFAULT '0000000000' NOT NULL, "PH_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "FILE_NAME" VARCHAR2 (000765) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000160 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB4CHKF~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "IWB4CHKF^0" ON "IWB4CHKF~" ("PHIO_ID", "FILE_NUM") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000080 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB4CHKF~' AND INDEXNAME = '0'

3 ETGCLN IWB4CHKF content is not required.

3 ETGCLN END IWB4CHKF -> IWB4CHKF~ 20160310072012

5 ETGCLN IWB4CHKF done in 0 seconds

3 ETGCLN START IWB4LOIO -> IWB4LOIO~ 20160310072012

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "IWB4LOIO~" ("LOIO_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "LO_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "MASTER_LG" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "CREA_USER" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "CREA_TIME" VARCHAR2 (000042) DEFAULT '00000000000000' NOT NULL, "CHNG_USER" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "CHNG_TIME" VARCHAR2 (000042) DEFAULT '00000000000000' NOT NULL, "PROP01" VARCHAR2 (000045) DEFAULT ' ' NOT NULL, "PROP02" VARCHAR2 (000045) DEFAULT ' ' NOT NULL, "PROP03" VARCHAR2 (000045) DEFAULT ' ' NOT NULL, "PROP04" VARCHAR2 (000045) DEFAULT ' ' NOT NULL, "PROP05" VARCHAR2 (000060) DEFAULT ' ' NOT NULL, "PROP06" VARCHAR2 (000060) DEFAULT ' ' NOT NULL, "PROP07" VARCHAR2 (000060) DEFAULT ' ' NOT NULL, "PROP08" VARCHAR2 (000120) DEFAULT ' ' NOT NULL, "PROP09" VARCHAR2 (000120) DEFAULT ' ' NOT NULL, "PROP10" VARCHAR2 (000120) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000010240 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB4LOIO~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "IWB4LOIO^0" ON "IWB4LOIO~" ("LOIO_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB4LOIO~' AND INDEXNAME = '0'

3 ETGCLN IWB4LOIO content is not required.

3 ETGCLN CREATE INDEX "IWB4LOIO^001" ON "IWB4LOIO~" ("PROP10") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB4LOIO~' AND INDEXNAME = '001'

3 ETGCLN CREATE INDEX "IWB4LOIO^002" ON "IWB4LOIO~" ("PROP08") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB4LOIO~' AND INDEXNAME = '002'

3 ETGCLN END IWB4LOIO -> IWB4LOIO~ 20160310072012

5 ETGCLN IWB4LOIO done in 0 seconds

3 ETGCLN START IWB4LORE -> IWB4LORE~ 20160310072013

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "IWB4LORE~" ("REP1_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "REIO_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "REP1_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "RE_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "REP2_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "REP2_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "CREA_USER" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "CREA_TIME" VARCHAR2 (000042) DEFAULT '00000000000000' NOT NULL, "CHNG_USER" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "CHNG_TIME" VARCHAR2 (000042) DEFAULT '00000000000000' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000160 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB4LORE~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "IWB4LORE^0" ON "IWB4LORE~" ("REP1_ID", "REIO_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000080 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB4LORE~' AND INDEXNAME = '0'

3 ETGCLN IWB4LORE content is not required.

3 ETGCLN CREATE INDEX "IWB4LORE^P2" ON "IWB4LORE~" ("REP2_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000080 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB4LORE~' AND INDEXNAME = 'P2'

3 ETGCLN CREATE UNIQUE INDEX "IWB4LORE^REL" ON "IWB4LORE~" ("REIO_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000080 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB4LORE~' AND INDEXNAME = 'REL'

3 ETGCLN END IWB4LORE -> IWB4LORE~ 20160310072013

5 ETGCLN IWB4LORE done in 0 seconds

3 ETGCLN START IWB4PHHR -> IWB4PHHR~ 20160310072013

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "IWB4PHHR~" ("REP1_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "REIO_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "REP1_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "RE_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "REP2_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "REP2_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "CREA_USER" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "CREA_TIME" VARCHAR2 (000042) DEFAULT '00000000000000' NOT NULL, "CHNG_USER" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "CHNG_TIME" VARCHAR2 (000042) DEFAULT '00000000000000' NOT NULL, "DESCRIPT" VARCHAR2 (000192) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000010240 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB4PHHR~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "IWB4PHHR^0" ON "IWB4PHHR~" ("REP1_ID", "REIO_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB4PHHR~' AND INDEXNAME = '0'

3 ETGCLN IWB4PHHR content is not required.

3 ETGCLN CREATE INDEX "IWB4PHHR^P2" ON "IWB4PHHR~" ("REP2_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB4PHHR~' AND INDEXNAME = 'P2'

3 ETGCLN CREATE UNIQUE INDEX "IWB4PHHR^REL" ON "IWB4PHHR~" ("REIO_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB4PHHR~' AND INDEXNAME = 'REL'

3 ETGCLN END IWB4PHHR -> IWB4PHHR~ 20160310072013

5 ETGCLN IWB4PHHR done in 0 seconds

3 ETGCLN START IWB4PHPR -> IWB4PHPR~ 20160310072013

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "IWB4PHPR~" ("OBJECT_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "PROP_NAME" VARCHAR2 (000075) DEFAULT ' ' NOT NULL, "PROP_INDEX" VARCHAR2 (000015) DEFAULT '00000' NOT NULL, "IO_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "PROP_VALUE" VARCHAR2 (000192) DEFAULT ' ' NOT NULL, "PROP_SECI" VARCHAR2 (000036) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000010240 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB4PHPR~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "IWB4PHPR^0" ON "IWB4PHPR~" ("OBJECT_ID", "PROP_NAME", "PROP_INDEX") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB4PHPR~' AND INDEXNAME = '0'

3 ETGCLN IWB4PHPR content is not required.

3 ETGCLN CREATE INDEX "IWB4PHPR^ID1" ON "IWB4PHPR~" ("PROP_NAME", "PROP_SECI", "IO_CLASS") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB4PHPR~' AND INDEXNAME = 'ID1'

3 ETGCLN END IWB4PHPR -> IWB4PHPR~ 20160310072014

5 ETGCLN IWB4PHPR done in 1 seconds

3 ETGCLN START IWB5CHKF -> IWB5CHKF~ 20160310072014

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "IWB5CHKF~" ("PHIO_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "FILE_NUM" VARCHAR2 (000030) DEFAULT '0000000000' NOT NULL, "PH_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "FILE_NAME" VARCHAR2 (000765) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000160 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5CHKF~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "IWB5CHKF^0" ON "IWB5CHKF~" ("PHIO_ID", "FILE_NUM") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000080 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5CHKF~' AND INDEXNAME = '0'

3 ETGCLN IWB5CHKF content is not required.

3 ETGCLN END IWB5CHKF -> IWB5CHKF~ 20160310072014

5 ETGCLN IWB5CHKF done in 0 seconds

3 ETGCLN START IWB5LOIO -> IWB5LOIO~ 20160310072014

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "IWB5LOIO~" ("LOIO_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "LO_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "MASTER_LG" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "CREA_USER" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "CREA_TIME" VARCHAR2 (000042) DEFAULT '00000000000000' NOT NULL, "CHNG_USER" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "CHNG_TIME" VARCHAR2 (000042) DEFAULT '00000000000000' NOT NULL, "PROP01" VARCHAR2 (000045) DEFAULT ' ' NOT NULL, "PROP02" VARCHAR2 (000045) DEFAULT ' ' NOT NULL, "PROP03" VARCHAR2 (000045) DEFAULT ' ' NOT NULL, "PROP04" VARCHAR2 (000045) DEFAULT ' ' NOT NULL, "PROP05" VARCHAR2 (000060) DEFAULT ' ' NOT NULL, "PROP06" VARCHAR2 (000060) DEFAULT ' ' NOT NULL, "PROP07" VARCHAR2 (000060) DEFAULT ' ' NOT NULL, "PROP08" VARCHAR2 (000120) DEFAULT ' ' NOT NULL, "PROP09" VARCHAR2 (000120) DEFAULT ' ' NOT NULL, "PROP10" VARCHAR2 (000120) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000010240 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5LOIO~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "IWB5LOIO^0" ON "IWB5LOIO~" ("LOIO_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5LOIO~' AND INDEXNAME = '0'

3 ETGCLN IWB5LOIO content is not required.

3 ETGCLN CREATE INDEX "IWB5LOIO^001" ON "IWB5LOIO~" ("PROP10") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5LOIO~' AND INDEXNAME = '001'

3 ETGCLN CREATE INDEX "IWB5LOIO^002" ON "IWB5LOIO~" ("PROP08") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5LOIO~' AND INDEXNAME = '002'

3 ETGCLN END IWB5LOIO -> IWB5LOIO~ 20160310072014

5 ETGCLN IWB5LOIO done in 0 seconds

3 ETGCLN START IWB5LORE -> IWB5LORE~ 20160310072014

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "IWB5LORE~" ("REP1_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "REIO_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "REP1_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "RE_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "REP2_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "REP2_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "CREA_USER" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "CREA_TIME" VARCHAR2 (000042) DEFAULT '00000000000000' NOT NULL, "CHNG_USER" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "CHNG_TIME" VARCHAR2 (000042) DEFAULT '00000000000000' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000160 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5LORE~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "IWB5LORE^0" ON "IWB5LORE~" ("REP1_ID", "REIO_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000080 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5LORE~' AND INDEXNAME = '0'

3 ETGCLN IWB5LORE content is not required.

3 ETGCLN CREATE INDEX "IWB5LORE^P2" ON "IWB5LORE~" ("REP2_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000080 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5LORE~' AND INDEXNAME = 'P2'

3 ETGCLN CREATE UNIQUE INDEX "IWB5LORE^REL" ON "IWB5LORE~" ("REIO_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000080 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5LORE~' AND INDEXNAME = 'REL'

3 ETGCLN END IWB5LORE -> IWB5LORE~ 20160310072015

5 ETGCLN IWB5LORE done in 1 seconds

3 ETGCLN START IWB5PHHR -> IWB5PHHR~ 20160310072015

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "IWB5PHHR~" ("REP1_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "REIO_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "REP1_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "RE_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "REP2_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "REP2_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "CREA_USER" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "CREA_TIME" VARCHAR2 (000042) DEFAULT '00000000000000' NOT NULL, "CHNG_USER" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "CHNG_TIME" VARCHAR2 (000042) DEFAULT '00000000000000' NOT NULL, "DESCRIPT" VARCHAR2 (000192) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000010240 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5PHHR~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "IWB5PHHR^0" ON "IWB5PHHR~" ("REP1_ID", "REIO_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5PHHR~' AND INDEXNAME = '0'

3 ETGCLN IWB5PHHR content is not required.

3 ETGCLN CREATE INDEX "IWB5PHHR^P2" ON "IWB5PHHR~" ("REP2_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5PHHR~' AND INDEXNAME = 'P2'

3 ETGCLN CREATE UNIQUE INDEX "IWB5PHHR^REL" ON "IWB5PHHR~" ("REIO_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5PHHR~' AND INDEXNAME = 'REL'

3 ETGCLN END IWB5PHHR -> IWB5PHHR~ 20160310072015

5 ETGCLN IWB5PHHR done in 0 seconds

3 ETGCLN START IWB5PHNM -> IWB5PHNM~ 20160310072015

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "IWB5PHNM~" ("REP2_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "REP1_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "REP2_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "REP1_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "REIO_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "RE_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "CREA_USER" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "CREA_TIME" VARCHAR2 (000042) DEFAULT '00000000000000' NOT NULL, "CHNG_USER" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "CHNG_TIME" VARCHAR2 (000042) DEFAULT '00000000000000' NOT NULL, "DESCRIPT" VARCHAR2 (000192) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5PHNM~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "IWB5PHNM^0" ON "IWB5PHNM~" ("REP2_ID", "REP1_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5PHNM~' AND INDEXNAME = '0'

3 ETGCLN IWB5PHNM content is not required.

3 ETGCLN CREATE INDEX "IWB5PHNM^P1" ON "IWB5PHNM~" ("REP1_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5PHNM~' AND INDEXNAME = 'P1'

3 ETGCLN CREATE UNIQUE INDEX "IWB5PHNM^REL" ON "IWB5PHNM~" ("REIO_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5PHNM~' AND INDEXNAME = 'REL'

3 ETGCLN END IWB5PHNM -> IWB5PHNM~ 20160310072016

5 ETGCLN IWB5PHNM done in 1 seconds

3 ETGCLN START IWB5PHRE -> IWB5PHRE~ 20160310072016

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "IWB5PHRE~" ("REP1_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "REIO_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "REP1_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "RE_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "REP2_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "REP2_CLASS" VARCHAR2 (000030) DEFAULT ' ' NOT NULL, "CREA_USER" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "CREA_TIME" VARCHAR2 (000042) DEFAULT '00000000000000' NOT NULL, "CHNG_USER" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "CHNG_TIME" VARCHAR2 (000042) DEFAULT '00000000000000' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000010240 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5PHRE~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "IWB5PHRE^0" ON "IWB5PHRE~" ("REP1_ID", "REIO_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5PHRE~' AND INDEXNAME = '0'

3 ETGCLN IWB5PHRE content is not required.

3 ETGCLN CREATE INDEX "IWB5PHRE^P2" ON "IWB5PHRE~" ("REP2_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5PHRE~' AND INDEXNAME = 'P2'

3 ETGCLN CREATE UNIQUE INDEX "IWB5PHRE^REL" ON "IWB5PHRE~" ("REIO_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5PHRE~' AND INDEXNAME = 'REL'

3 ETGCLN END IWB5PHRE -> IWB5PHRE~ 20160310072017

5 ETGCLN IWB5PHRE done in 1 seconds

3 ETGCLN START IWB5PHRIPR -> IWB5PHRIPR~ 20160310072017

3 ETGCLN Primary key strategy for current table is 0

4 EPU202XEND OF SECTION BEING ANALYZED END OF WASTED_LOG ===================================================

head of DBLCONE1

4 EPU201XBEGIN OF SECTION BEING ANALYZED LASTOFFSET 2536073 NOW BEGIN OF WASTED_LOG ===============

3 ETGCLN ************(080846)************

8 ETGCLN START CLONING TABLES

3 ETGCLN Reading U:\SUM\abap\mem\TAIATRANS.DAT

3 ETGCLN START /OSP/T_BM_CTX -> /OSP/T_BM_CTX~ 20160310070847

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "/OSP/T_BM_CTX~" ("MANDT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "RULE_TYPE" VARCHAR2 (000012) DEFAULT ' ' NOT NULL, "CONTEXT_PAR_NAME" VARCHAR2 (000090) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_BM_CTX~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "/OSP/T_BM_CTX^0" ON "/OSP/T_BM_CTX~" ("MANDT", "RULE_TYPE", "CONTEXT_PAR_NAME") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_BM_CTX~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_BM_CTX content is not required.

3 ETGCLN END /OSP/T_BM_CTX -> /OSP/T_BM_CTX~ 20160310070849

5 ETGCLN /OSP/T_BM_CTX done in 2 seconds

3 ETGCLN START /OSP/T_BM_RLVT -> /OSP/T_BM_RLVT~ 20160310070849

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "/OSP/T_BM_RLVT~" ("MANDT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "LANG" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "RV_TYPE" VARCHAR2 (000012) DEFAULT ' ' NOT NULL, "DESCRIPTION" VARCHAR2 (000180) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_BM_RLVT~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "/OSP/T_BM_RLVT^0" ON "/OSP/T_BM_RLVT~" ("MANDT", "LANG", "RV_TYPE") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_BM_RLVT~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_BM_RLVT content is not required.

3 ETGCLN END /OSP/T_BM_RLVT -> /OSP/T_BM_RLVT~ 20160310070849

5 ETGCLN /OSP/T_BM_RLVT done in 0 seconds

3 ETGCLN START /OSP/T_CJS_GJ -> /OSP/T_CJS_GJ~ 20160310070849

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "/OSP/T_CJS_GJ~" ("MANDT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "UUID" RAW (000016) NOT NULL, "S_ID" VARCHAR2 (000180) DEFAULT ' ' NOT NULL, "SV_ID" VARCHAR2 (000045) DEFAULT ' ' NOT NULL, "SA_ID" VARCHAR2 (000180) DEFAULT ' ' NOT NULL, "SAS_ID" VARCHAR2 (000180) DEFAULT ' ' NOT NULL, "SASA_ID" VARCHAR2 (000009) DEFAULT ' ' NOT NULL, "ID" VARCHAR2 (000360) DEFAULT ' ' NOT NULL, "MD5" VARCHAR2 (000765), "CREATED" VARCHAR2 (000042) DEFAULT ' ' NOT NULL, "MODIFIED" VARCHAR2 (000042) DEFAULT ' ' NOT NULL, "VERSION" VARCHAR2 (000042) DEFAULT '00000000000000' NOT NULL, "DELETED" VARCHAR2 (000003) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000327680 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_CJS_GJ~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "/OSP/T_CJS_GJ^0" ON "/OSP/T_CJS_GJ~" ("MANDT", "UUID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000081920 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_CJS_GJ~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_CJS_GJ nothing to copy.

3 ETGCLN Number of original rows: 0. Number of copied rows: 0.

3 ETGCLN CREATE INDEX "/OSP/T_CJS_GJ^001" ON "/OSP/T_CJS_GJ~" ("MANDT", "ID", "SA_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000081920 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_CJS_GJ~' AND INDEXNAME = '001'

3 ETGCLN END /OSP/T_CJS_GJ -> /OSP/T_CJS_GJ~ 20160310070850

5 ETGCLN /OSP/T_CJS_GJ done in 1 seconds

3 ETGCLN START /OSP/T_CON_VAR -> /OSP/T_CON_VAR~ 20160310070850

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "/OSP/T_CON_VAR~" ("MANDT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "VAR_NAME" VARCHAR2 (000090) DEFAULT ' ' NOT NULL, "VAR_TYPE" VARCHAR2 (000006) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_CON_VAR~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "/OSP/T_CON_VAR^0" ON "/OSP/T_CON_VAR~" ("MANDT", "VAR_NAME") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000640 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_CON_VAR~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_CON_VAR : only client 000 will be copied

3 ETGCLN insert /*+ APPEND */ into "/OSP/T_CON_VAR~" ( "MANDT", "VAR_NAME", "VAR_TYPE" ) select "MANDT", "VAR_NAME", "VAR_TYPE" from "/OSP/T_CON_VAR" WHERE "MANDT"='000'

3 ETGCLN Number of original rows: 5. Number of copied rows: 5.

3 ETGCLN END /OSP/T_CON_VAR -> /OSP/T_CON_VAR~ 20160310070850

5 ETGCLN /OSP/T_CON_VAR done in 0 seconds

3 ETGCLN START /OSP/T_CORR_SAP -> /OSP/T_CORR_SAP~ 20160310070850

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "/OSP/T_CORR_SAP~" ("MANDT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "OBJECT_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "OBJECT_TYPE" VARCHAR2 (000012) DEFAULT '0000' NOT NULL, "CORRELATION_ID" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "EXT_RELEVANT" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "STATUS" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "CREATED_BY" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "CREATED_ON" VARCHAR2 (000024) DEFAULT '00000000' NOT NULL, "MODIFIED_BY" VARCHAR2 (000036) DEFAULT ' ' NOT NULL, "MODIFIED_ON" VARCHAR2 (000024) DEFAULT '00000000' NOT NULL, "RFC_DEST" VARCHAR2 (000096) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000163840 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_CORR_SAP~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "/OSP/T_CORR_SAP^0" ON "/OSP/T_CORR_SAP~" ("MANDT", "OBJECT_ID", "OBJECT_TYPE", "CORRELATION_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000040960 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_CORR_SAP~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_CORR_SAP content is not required.

3 ETGCLN CREATE INDEX "/OSP/T_CORR_SAP^00" ON "/OSP/T_CORR_SAP~" ("CORRELATION_ID", "STATUS") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000040960 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_CORR_SAP~' AND INDEXNAME = '001'

3 ETGCLN END /OSP/T_CORR_SAP -> /OSP/T_CORR_SAP~ 20160310070850

5 ETGCLN /OSP/T_CORR_SAP done in 0 seconds

3 ETGCLN START /OSP/T_GD_VALUE -> /OSP/T_GD_VALUE~ 20160310070850

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "/OSP/T_GD_VALUE~" ("MANDT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "SETTING_TYPE" VARCHAR2 (000150) DEFAULT ' ' NOT NULL, "SETTING_VALUE" VARCHAR2 (000150) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000020480 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_GD_VALUE~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "/OSP/T_GD_VALUE^0" ON "/OSP/T_GD_VALUE~" ("MANDT", "SETTING_TYPE", "SETTING_VALUE") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000005120 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_GD_VALUE~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_GD_VALUE : only client 000 will be copied

3 ETGCLN insert /*+ APPEND */ into "/OSP/T_GD_VALUE~" ( "MANDT", "SETTING_TYPE", "SETTING_VALUE" ) select "MANDT", "SETTING_TYPE", "SETTING_VALUE" from "/OSP/T_GD_VALUE" WHERE "MANDT"='000'

3 ETGCLN Number of original rows: 353. Number of copied rows: 353.

3 ETGCLN END /OSP/T_GD_VALUE -> /OSP/T_GD_VALUE~ 20160310070850

5 ETGCLN /OSP/T_GD_VALUE done in 0 seconds

3 ETGCLN START /OSP/T_MDR_APPL -> /OSP/T_MDR_APPL~ 20160310070850

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "/OSP/T_MDR_APPL~" ("MANDT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "APPL_ID" VARCHAR2 (000012) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_MDR_APPL~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "/OSP/T_MDR_APPL^0" ON "/OSP/T_MDR_APPL~" ("MANDT", "APPL_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_MDR_APPL~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_MDR_APPL : only client 000 will be copied

3 ETGCLN insert /*+ APPEND */ into "/OSP/T_MDR_APPL~" ( "MANDT", "APPL_ID" ) select "MANDT", "APPL_ID" from "/OSP/T_MDR_APPL" WHERE "MANDT"='000'

3 ETGCLN Number of original rows: 1. Number of copied rows: 1.

3 ETGCLN END /OSP/T_MDR_APPL -> /OSP/T_MDR_APPL~ 20160310070850

5 ETGCLN /OSP/T_MDR_APPL done in 0 seconds

3 ETGCLN START /OSP/T_MDR_SCNT -> /OSP/T_MDR_SCNT~ 20160310070850

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "/OSP/T_MDR_SCNT~" ("MANDT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "LANGUAGE" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "APPL_ID" VARCHAR2 (000012) DEFAULT ' ' NOT NULL, "SCN_ID" VARCHAR2 (000012) DEFAULT ' ' NOT NULL, "SCN_DESC" VARCHAR2 (000120) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_MDR_SCNT~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "/OSP/T_MDR_SCNT^0" ON "/OSP/T_MDR_SCNT~" ("MANDT", "LANGUAGE", "APPL_ID", "SCN_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_MDR_SCNT~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_MDR_SCNT content is not required.

3 ETGCLN END /OSP/T_MDR_SCNT -> /OSP/T_MDR_SCNT~ 20160310070851

5 ETGCLN /OSP/T_MDR_SCNT done in 1 seconds

3 ETGCLN START /OSP/T_MDR_SETVL -> /OSP/T_MDR_SETVL~ 20160310070851

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "/OSP/T_MDR_SETVL~" ("MANDT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "SCN_ID" VARCHAR2 (000012) DEFAULT ' ' NOT NULL, "SETTING" VARCHAR2 (000075) DEFAULT ' ' NOT NULL, "SETTING_TYPE" VARCHAR2 (000060) DEFAULT ' ' NOT NULL, "SETTING_VALUE" VARCHAR2 (000075) DEFAULT ' ' NOT NULL, "SETTING_UNIT" VARCHAR2 (000030) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_MDR_SETVL~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "/OSP/T_MDR_SETVL^0" ON "/OSP/T_MDR_SETVL~" ("MANDT", "SCN_ID", "SETTING", "SETTING_TYPE") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_MDR_SETVL~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_MDR_SETVL : only client 000 will be copied

3 ETGCLN insert /*+ APPEND */ into "/OSP/T_MDR_SETVL~" ( "MANDT", "SCN_ID", "SETTING", "SETTING_TYPE", "SETTING_VALUE", "SETTING_UNIT" ) select "MANDT", "SCN_ID", "SETTING", "SETTING_TYPE", "SETTING_VALUE", "SETTING_UNIT" from "/OSP/T_MDR_SETVL" WHERE "MANDT"='000'

3 ETGCLN Number of original rows: 21. Number of copied rows: 21.

3 ETGCLN END /OSP/T_MDR_SETVL -> /OSP/T_MDR_SETVL~ 20160310070851

5 ETGCLN /OSP/T_MDR_SETVL done in 0 seconds

3 ETGCLN START /OSP/T_RAUI_CMVL -> /OSP/T_RAUI_CMVL~ 20160310070851

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "/OSP/T_RAUI_CMVL~" ("MANDT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "RV_TYPE" VARCHAR2 (000012) DEFAULT ' ' NOT NULL, "REPORT" VARCHAR2 (000120) DEFAULT ' ' NOT NULL, "RFCDEST" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "PARAM_NAME" VARCHAR2 (000090) DEFAULT ' ' NOT NULL, "PARAM_SEQ_NO" VARCHAR2 (000024) DEFAULT '00000000' NOT NULL, "DFLT_SIGN" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "DFLT_OPTN" VARCHAR2 (000150) DEFAULT ' ' NOT NULL, "DFLT_LOW" VARCHAR2 (000765) DEFAULT ' ' NOT NULL, "DFLT_HIGH" VARCHAR2 (000765) DEFAULT ' ' NOT NULL, "VAR_NAME" VARCHAR2 (000090) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_RAUI_CMVL~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "/OSP/T_RAUI_CMVL^0" ON "/OSP/T_RAUI_CMVL~" ("MANDT", "RV_TYPE", "REPORT", "RFCDEST", "PARAM_NAME", "PARAM_SEQ_NO") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000640 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_RAUI_CMVL~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_RAUI_CMVL content is not required.

3 ETGCLN END /OSP/T_RAUI_CMVL -> /OSP/T_RAUI_CMVL~ 20160310070851

5 ETGCLN /OSP/T_RAUI_CMVL done in 0 seconds

3 ETGCLN START /OSP/T_RAUI_CSER -> /OSP/T_RAUI_CSER~ 20160310070851

3 ETGCLN Primary key strategy for current table is 0

Hi Qazi,

Kindly paste the log for DBCLONE.ELG

and also attach the DBCLONE.LOG

With Regards

Ashutosh Chaturvedi

Hi Qazi,

Create a job DBCLONE1 with the program name RSUPG_CLONE_TABLES and variant SAP_DBCLONE_1 with DDIC user in 000 client.

Save the job and keep it in schedule state.

Now run the below command at DB level

update SAPSR3.TBTCO set JOBCOUNT='12084500' , STATUS='A' where JOBNAME='DBCLONE1'

After running the above query , DBCLONE1 will be in cancel status.

Now retry the step in SUM.

With Regards

Ashutosh Chaturvedi

Hello Ashutosh,

Should i create 3 jobs with name DBCLONE01,DBLCONE02 and 03 respectively? that has been deleted and run oracle commands for each??

Regards

Qazi

Hi Qazi,

Go one by one because we dont know the jobcount value for other two jobs DBCLONE2 and DBCLONE3

With Regards

Ashutosh Chaturvedi

Hi Qazi,

Any update on this.

With Regards

Ashutosh Chaturvedi

Hello Dear,

Not applied yet because sat sun off days and i dont have remote or VPN access of the Systems.

Will apply your suggestion tomorrow.

I will create jobs simultaneously because JOB count is known as per DBCLONE.ELG Log tail,,, check n suggest.

3 ETQ399 7643 entries matched.

2 ETQ399 Added 7643 empty tables.

1 ETQ399 Distributing 12986 tables on 3 processes.

1 ETQ399 Process 1 will copy 4318 tables with total size of 4235.360988 MB.

1 ETQ399 Process 2 will copy 4333 tables with total size of 4235.360917 MB.

1 ETQ399 Process 3 will copy 4335 tables with total size of 4235.360948 MB.

1 ETQ399 Total size cloned: 12706.082852 MB.

2 ETQ399 Requested task ID is 'CLONE_DISTTABLES'.

3 ETQ399 'LIST': Distributed 12986 statements.

3 ETQ399 Generated TQL file 'CLONEINIT.SQL' with 1 SQL statements, log file 'SQLDBSCRIPT.OUT'.

4 ETQ276 Executing SQL-script "CLONEINIT.SQL"

3 ETQ120 20160310120834: PID 5368 execute 'U:\SUM\abap\bin\SAPuptool execdb ..\var\CLONEINIT.SQL', output written to 'U:\SUM\abap\log\SQLSTMTSTD.OUT'.

3 ETQ123 20160310120843: PID 5368 exited with status 0 (time 0.000 real)

3 ETQ399 Reading SQL output from 'SQLDBSCRIPT.OUT'.

1 ETQ399 Number of scheduled processes: 3

2 ETQ399 Requested task ID is 'CLONE_CHK_DISTTABLES'.

4 ETQ399 Preparing internal output table 'LIST' to receive named fields.

3 ETQ399 Generated TQL file 'CHECKCLONEDIST.TQL' with 1 SQL statements, log file 'CHECKCLONEDIST.LOG'.

4 ETQ276 Executing SQL-script "CHECKCLONEDIST.TQL"

3 ETQ120 20160310120843: PID 3580 execute 'U:\SUM\abap\bin\SAPuptool execdb ..\var\CHECKCLONEDIST.TQL', output written to 'U:\SUM\abap\log\SQLSTMTSTD.OUT'.

3 ETQ123 20160310120844: PID 3580 exited with status 0 (time 0.000 real)

3 ETQ399 Reading selections from 'CHECKCLONEDIST.LOG'.

4 ETQ399 Read 0 entries for table 'LIST'.

2 ETQ399 Starting 3 jobs:

4 ETQ265 Starting report "RSUPG_CLONE_TABLES" with variant "SAP_DBCLONE_1" in batch

1 ETQ359 RFC Login to: System="SMD", AsHost="ABCKHIHO12" Nr="00", GwHost="ABCKHIHO12", GwService="sapgw00"

2 ETQ232 RFC Login succeeded

4 ETQ010 Date & Time: 20160310120844

1 ETQ233 Calling function module "SUBST_START_REPORT_IN_BATCH" by RFC

2 ETQ373 parameter "IV_ABORT_ON_ERROR" = ""

2 ETQ373 parameter "IV_AUTHCKNAM" = "DDIC"

2 ETQ373 parameter "IV_BATCHHOST" = "ABCKHIHO12"

2 ETQ373 parameter "IV_JOBNAME" = "DBCLONE1"

2 ETQ373 parameter "IV_REPNAME" = "RSUPG_CLONE_TABLES"

2 ETQ373 parameter "IV_SCHEDEVER" = " "

2 ETQ373 parameter "IV_VARIANTTEXT" = "Parallel tables cloning"

2 ETQ373 parameter "IV_VARNAME" = "SAP_DBCLONE_1"

2 ETQ373 parameter "IV_LANGUAGE" = "E"

2 ETQ399 Table TT_REPORTPARAM (#8):

3 ETQ399 "LOGFILE","P","","","DBCLONE01.SMD",""

3 ETQ399 "ORTAB","P","","","",""

3 ETQ399 "CPTAB","P","","","",""

3 ETQ399 "EXE","P","","","X",""

3 ETQ399 "SHOWSQL","P","","","X",""

3 ETQ399 "TABTYPE","P","","","1",""

3 ETQ399 "TABSMAP","P","","","TAIATRANS.DAT",""

3 ETQ399 "BRIDGE","P","","","",""

2 ETQ373 parameter "IV_BATCHINSTANCE" = ""

1 ETQ234 Call of function module "SUBST_START_REPORT_IN_BATCH" by RFC succeeded

4 ETQ010 Date & Time: 20160310120845

2 ETQ373 parameter "EV_JOBCOUNT" = "12084500"

2 ETQ374 parameter "EV_STARTRC" = "0"

2 ETQ374 parameter "EV_VARIWRC" = "0"

4 ETQ311 Batch job "DBCLONE1" with job count "12084500" scheduled

4 ETQ265 Starting report "RSUPG_CLONE_TABLES" with variant "SAP_DBCLONE_2" in batch

1 ETQ359 RFC Login to: System="SMD", AsHost="ABCKHIHO12" Nr="00", GwHost="ABCKHIHO12", GwService="sapgw00"

2 ETQ232 RFC Login succeeded

4 ETQ010 Date & Time: 20160310120845

1 ETQ233 Calling function module "SUBST_START_REPORT_IN_BATCH" by RFC

2 ETQ373 parameter "IV_ABORT_ON_ERROR" = ""

2 ETQ373 parameter "IV_AUTHCKNAM" = "DDIC"

2 ETQ373 parameter "IV_BATCHHOST" = "ABCKHIHO12"

2 ETQ373 parameter "IV_JOBNAME" = "DBCLONE2"

2 ETQ373 parameter "IV_REPNAME" = "RSUPG_CLONE_TABLES"

2 ETQ373 parameter "IV_SCHEDEVER" = " "

2 ETQ373 parameter "IV_VARIANTTEXT" = "Parallel tables cloning"

2 ETQ373 parameter "IV_VARNAME" = "SAP_DBCLONE_2"

2 ETQ373 parameter "IV_LANGUAGE" = "E"

2 ETQ399 Table TT_REPORTPARAM (#8):

3 ETQ399 "LOGFILE","P","","","DBCLONE02.SMD",""

3 ETQ399 "ORTAB","P","","","",""

3 ETQ399 "CPTAB","P","","","",""

3 ETQ399 "EXE","P","","","X",""

3 ETQ399 "SHOWSQL","P","","","X",""

3 ETQ399 "TABTYPE","P","","","2",""

3 ETQ399 "TABSMAP","P","","","TAIATRANS.DAT",""

3 ETQ399 "BRIDGE","P","","","",""

2 ETQ373 parameter "IV_BATCHINSTANCE" = ""

1 ETQ234 Call of function module "SUBST_START_REPORT_IN_BATCH" by RFC succeeded

4 ETQ010 Date & Time: 20160310120845

2 ETQ373 parameter "EV_JOBCOUNT" = "12084500"

2 ETQ374 parameter "EV_STARTRC" = "0"

2 ETQ374 parameter "EV_VARIWRC" = "0"

4 ETQ311 Batch job "DBCLONE2" with job count "12084500" scheduled

4 ETQ265 Starting report "RSUPG_CLONE_TABLES" with variant "SAP_DBCLONE_3" in batch

1 ETQ359 RFC Login to: System="SMD", AsHost="ABCKHIHO12" Nr="00", GwHost="ABCKHIHO12", GwService="sapgw00"

2 ETQ232 RFC Login succeeded

4 ETQ010 Date & Time: 20160310120845

1 ETQ233 Calling function module "SUBST_START_REPORT_IN_BATCH" by RFC

2 ETQ373 parameter "IV_ABORT_ON_ERROR" = ""

2 ETQ373 parameter "IV_AUTHCKNAM" = "DDIC"

2 ETQ373 parameter "IV_BATCHHOST" = "ABCKHIHO12"

2 ETQ373 parameter "IV_JOBNAME" = "DBCLONE3"

2 ETQ373 parameter "IV_REPNAME" = "RSUPG_CLONE_TABLES"

2 ETQ373 parameter "IV_SCHEDEVER" = " "

2 ETQ373 parameter "IV_VARIANTTEXT" = "Parallel tables cloning"

2 ETQ373 parameter "IV_VARNAME" = "SAP_DBCLONE_3"

2 ETQ373 parameter "IV_LANGUAGE" = "E"

2 ETQ399 Table TT_REPORTPARAM (#8):

3 ETQ399 "LOGFILE","P","","","DBCLONE03.SMD",""

3 ETQ399 "ORTAB","P","","","",""

3 ETQ399 "CPTAB","P","","","",""

3 ETQ399 "EXE","P","","","X",""

3 ETQ399 "SHOWSQL","P","","","X",""

3 ETQ399 "TABTYPE","P","","","3",""

3 ETQ399 "TABSMAP","P","","","TAIATRANS.DAT",""

3 ETQ399 "BRIDGE","P","","","",""

2 ETQ373 parameter "IV_BATCHINSTANCE" = ""

1 ETQ234 Call of function module "SUBST_START_REPORT_IN_BATCH" by RFC succeeded

4 ETQ010 Date & Time: 20160310120846

2 ETQ373 parameter "EV_JOBCOUNT" = "12084600"

2 ETQ374 parameter "EV_STARTRC" = "0"

2 ETQ374 parameter "EV_VARIWRC" = "0"

4 ETQ311 Batch job "DBCLONE3" with job count "12084600" scheduled

2 ETQ399 20160310120847: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310120847: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310120847: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:08:47: sleeping 30 seconds

2 ETQ399 20160310120917: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310120917: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310120917: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:09:17: sleeping 30 seconds

2 ETQ399 20160310120947: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310120947: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310120947: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:09:47: sleeping 30 seconds

2 ETQ399 20160310121017: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121017: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121017: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:10:17: sleeping 30 seconds

2 ETQ399 20160310121047: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121047: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121047: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:10:47: sleeping 30 seconds

2 ETQ399 20160310121117: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121117: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121117: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:11:17: sleeping 30 seconds

2 ETQ399 20160310121148: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121148: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121148: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:11:48: sleeping 30 seconds

2 ETQ399 20160310121218: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121218: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121218: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:12:18: sleeping 30 seconds

2 ETQ399 20160310121248: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121248: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121248: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:12:48: sleeping 30 seconds

2 ETQ399 20160310121318: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121318: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121318: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:13:18: sleeping 30 seconds

2 ETQ399 20160310121348: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121348: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121348: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:13:48: sleeping 30 seconds

2 ETQ399 20160310121418: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121418: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121418: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:14:18: sleeping 30 seconds

2 ETQ399 20160310121448: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121448: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121448: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:14:48: sleeping 30 seconds

2 ETQ399 20160310121518: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121518: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121519: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:15:19: sleeping 30 seconds

2 ETQ399 20160310121549: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121549: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121549: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:15:49: sleeping 30 seconds

2 ETQ399 20160310121619: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121619: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121619: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:16:19: sleeping 30 seconds

2 ETQ399 20160310121649: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121649: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121649: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:16:49: sleeping 30 seconds

2 ETQ399 20160310121719: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121719: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121719: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:17:19: sleeping 30 seconds

2 ETQ399 20160310121749: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121749: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121749: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:17:49: sleeping 30 seconds

2 ETQ399 20160310121819: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121819: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121819: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:18:19: sleeping 30 seconds

2 ETQ399 20160310121849: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121849: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121849: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:18:49: sleeping 30 seconds

2 ETQ399 20160310121919: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121919: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121919: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:19:19: sleeping 30 seconds

2 ETQ399 20160310121949: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121950: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121950: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:19:50: sleeping 30 seconds

1 ETQ359 RFC Login to: System="SMD", AsHost="ABCKHIHO12" Nr="00", GwHost="ABCKHIHO12", GwService="sapgw00"

2EETQ231 RFC Login failed

3EETQ399 Checking job #0 'RSUPG_CLONE_TABLES' failed with RFC login to system SMD ashost ABCKHIHO12 nr 00 gwhost ABCKHIHO12 gwservice sapgw00 failed with code 8 key RFC_TIMEOUT: Timeout while opening a RFC connection.

2 ETQ399 2016/03/10 12:23:20: sleeping 30 seconds

Then our System down due to cloud issue.... and i have deleted the jobs..

I think picture is more clear to you now??

Regards

Hi Ashutosh,

I have created jobs but SQL statement is not working...

its giving output 2 and not cancelling tha job in SM 37 Output...

However i have option to cancel tha job manually in sm37 but what about JOB count ???

Plz response.

Regards
Qazi

Hi Qazi,

Cancel the job and then retry the SUM.

With Regards

Ashutosh Chaturvedi

Tried it no success same issue Plz suggest

Regards

Hi Qazi,

have you updated the jobcount?

With Regards

Ashutosh Chaturvedi

Yes from the command line screenshot attached.

now suggest

Hi Qazi,

Can you please paste the SUM log file.

DBCLONE.log and .ELG log file.

With Regards

Ashutosh Chaturvedi

Hi Qazi,

After running the above query , have you given the commit command in the end.

With Regards

Ashutosh Chaturvedi

How to commit? can you please give example???

Regards.

Got It... now try with ;

But i have manually cancel the jobs from sm37.. if i update with commit do u think it works with SUM restart???

Regards

Hi Qazi,

After running the qery above

sql>commit;

It will commit the sql query and data will be updated in table.

Retry the steps in SUM.

if you get any error , kindly paste the logs.

With Regards

Ashutosh Chaturvedi

Same Error after commit as well.

Hi Qazi,

Paste the logs once again.

With Regards

Ashutosh Chaturvedi

tail: DBCLONE01.SMD

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5LORE~' AND INDEXNAME = ' '

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5LORE~' AND INDEXNAME = '0'

3 ETGCLN IWB5LORE content is not required.

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5LORE~' AND INDEXNAME = 'P2'

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5LORE~' AND INDEXNAME = 'REL'

3 ETGCLN END IWB5LORE -> IWB5LORE~ 20160310072015

5 ETGCLN IWB5LORE done in 1 seconds

3 ETGCLN START IWB5PHHR -> IWB5PHHR~ 20160310072015

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5PHHR~' AND INDEXNAME = ' '

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5PHHR~' AND INDEXNAME = '0'

3 ETGCLN IWB5PHHR content is not required.

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5PHHR~' AND INDEXNAME = 'P2'

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5PHHR~' AND INDEXNAME = 'REL'

3 ETGCLN END IWB5PHHR -> IWB5PHHR~ 20160310072015

5 ETGCLN IWB5PHHR done in 0 seconds

3 ETGCLN START IWB5PHNM -> IWB5PHNM~ 20160310072015

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5PHNM~' AND INDEXNAME = ' '

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5PHNM~' AND INDEXNAME = '0'

3 ETGCLN IWB5PHNM content is not required.

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5PHNM~' AND INDEXNAME = 'P1'

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5PHNM~' AND INDEXNAME = 'REL'

3 ETGCLN END IWB5PHNM -> IWB5PHNM~ 20160310072016

5 ETGCLN IWB5PHNM done in 1 seconds

3 ETGCLN START IWB5PHRE -> IWB5PHRE~ 20160310072016

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5PHRE~' AND INDEXNAME = ' '

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5PHRE~' AND INDEXNAME = '0'

3 ETGCLN IWB5PHRE content is not required.

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5PHRE~' AND INDEXNAME = 'P2'

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'IWB5PHRE~' AND INDEXNAME = 'REL'

3 ETGCLN END IWB5PHRE -> IWB5PHRE~ 20160310072017

5 ETGCLN IWB5PHRE done in 1 seconds

3 ETGCLN START IWB5PHRIPR -> IWB5PHRIPR~ 20160310072017

3 ETGCLN Primary key strategy for current table is 0

4 EPU202XEND OF SECTION BEING ANALYZED END OF WASTED_LOG ===================================================

Head: DBCLONE01.SMD

4 EPU201XBEGIN OF SECTION BEING ANALYZED LASTOFFSET 2536073 NOW BEGIN OF WASTED_LOG ===============

3 ETGCLN ************(080846)************

8 ETGCLN START CLONING TABLES

3 ETGCLN Reading U:\SUM\abap\mem\TAIATRANS.DAT

3 ETGCLN START /OSP/T_BM_CTX -> /OSP/T_BM_CTX~ 20160310070847

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_BM_CTX~' AND INDEXNAME = ' '

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_BM_CTX~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_BM_CTX content is not required.

3 ETGCLN END /OSP/T_BM_CTX -> /OSP/T_BM_CTX~ 20160310070849

5 ETGCLN /OSP/T_BM_CTX done in 2 seconds

3 ETGCLN START /OSP/T_BM_RLVT -> /OSP/T_BM_RLVT~ 20160310070849

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_BM_RLVT~' AND INDEXNAME = ' '

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_BM_RLVT~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_BM_RLVT content is not required.

3 ETGCLN END /OSP/T_BM_RLVT -> /OSP/T_BM_RLVT~ 20160310070849

5 ETGCLN /OSP/T_BM_RLVT done in 0 seconds

3 ETGCLN START /OSP/T_CJS_GJ -> /OSP/T_CJS_GJ~ 20160310070849

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_CJS_GJ~' AND INDEXNAME = ' '

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_CJS_GJ~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_CJS_GJ nothing to copy.

3 ETGCLN Number of original rows: 0. Number of copied rows: 0.

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_CJS_GJ~' AND INDEXNAME = '001'

3 ETGCLN END /OSP/T_CJS_GJ -> /OSP/T_CJS_GJ~ 20160310070850

5 ETGCLN /OSP/T_CJS_GJ done in 1 seconds

3 ETGCLN START /OSP/T_CON_VAR -> /OSP/T_CON_VAR~ 20160310070850

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_CON_VAR~' AND INDEXNAME = ' '

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_CON_VAR~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_CON_VAR : only client 000 will be copied

3 ETGCLN insert /*+ APPEND */ into "/OSP/T_CON_VAR~" ( "MANDT", "VAR_NAME", "VAR_TYPE" ) select "MANDT", "VAR_NAME", "VAR_TYPE" from "/OSP/T_CON_VAR" WHERE "MANDT"='000'

3 ETGCLN Number of original rows: 5. Number of copied rows: 5.

3 ETGCLN END /OSP/T_CON_VAR -> /OSP/T_CON_VAR~ 20160310070850

5 ETGCLN /OSP/T_CON_VAR done in 0 seconds

3 ETGCLN START /OSP/T_CORR_SAP -> /OSP/T_CORR_SAP~ 20160310070850

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_CORR_SAP~' AND INDEXNAME = ' '

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_CORR_SAP~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_CORR_SAP content is not required.

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_CORR_SAP~' AND INDEXNAME = '001'

3 ETGCLN END /OSP/T_CORR_SAP -> /OSP/T_CORR_SAP~ 20160310070850

5 ETGCLN /OSP/T_CORR_SAP done in 0 seconds

3 ETGCLN START /OSP/T_GD_VALUE -> /OSP/T_GD_VALUE~ 20160310070850

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_GD_VALUE~' AND INDEXNAME = ' '

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_GD_VALUE~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_GD_VALUE : only client 000 will be copied

3 ETGCLN insert /*+ APPEND */ into "/OSP/T_GD_VALUE~" ( "MANDT", "SETTING_TYPE", "SETTING_VALUE" ) select "MANDT", "SETTING_TYPE", "SETTING_VALUE" from "/OSP/T_GD_VALUE" WHERE "MANDT"='000'

3 ETGCLN Number of original rows: 353. Number of copied rows: 353.

3 ETGCLN END /OSP/T_GD_VALUE -> /OSP/T_GD_VALUE~ 20160310070850

5 ETGCLN /OSP/T_GD_VALUE done in 0 seconds

3 ETGCLN START /OSP/T_MDR_APPL -> /OSP/T_MDR_APPL~ 20160310070850

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_MDR_APPL~' AND INDEXNAME = ' '

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_MDR_APPL~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_MDR_APPL : only client 000 will be copied

3 ETGCLN insert /*+ APPEND */ into "/OSP/T_MDR_APPL~" ( "MANDT", "APPL_ID" ) select "MANDT", "APPL_ID" from "/OSP/T_MDR_APPL" WHERE "MANDT"='000'

3 ETGCLN Number of original rows: 1. Number of copied rows: 1.

3 ETGCLN END /OSP/T_MDR_APPL -> /OSP/T_MDR_APPL~ 20160310070850

5 ETGCLN /OSP/T_MDR_APPL done in 0 seconds

3 ETGCLN START /OSP/T_MDR_SCNT -> /OSP/T_MDR_SCNT~ 20160310070850

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_MDR_SCNT~' AND INDEXNAME = ' '

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_MDR_SCNT~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_MDR_SCNT content is not required.

3 ETGCLN END /OSP/T_MDR_SCNT -> /OSP/T_MDR_SCNT~ 20160310070851

5 ETGCLN /OSP/T_MDR_SCNT done in 1 seconds

3 ETGCLN START /OSP/T_MDR_SETVL -> /OSP/T_MDR_SETVL~ 20160310070851

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_MDR_SETVL~' AND INDEXNAME = ' '

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_MDR_SETVL~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_MDR_SETVL : only client 000 will be copied

3 ETGCLN Number of original rows: 21. Number of copied rows: 21.

3 ETGCLN END /OSP/T_MDR_SETVL -> /OSP/T_MDR_SETVL~ 20160310070851

5 ETGCLN /OSP/T_MDR_SETVL done in 0 seconds

3 ETGCLN START /OSP/T_RAUI_CMVL -> /OSP/T_RAUI_CMVL~ 20160310070851

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_RAUI_CMVL~' AND INDEXNAME = ' '

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_RAUI_CMVL~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_RAUI_CMVL content is not required.

3 ETGCLN END /OSP/T_RAUI_CMVL -> /OSP/T_RAUI_CMVL~ 20160310070851

5 ETGCLN /OSP/T_RAUI_CMVL done in 0 seconds

3 ETGCLN START /OSP/T_RAUI_CSER -> /OSP/T_RAUI_CSER~ 20160310070851

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "/OSP/T_RAUI_CSER~" ("MANDT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "RV_TYPE" VARCHAR2 (000012) DEFAULT ' ' NOT NULL, "REPORT" VARCHAR2 (000120) DEFAULT ' ' NOT NULL, "RFCDEST" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "CHART_TYPE" VARCHAR2 (000150) DEFAULT ' ' NOT NULL, "SERIES_NUMBER" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "ROW_COL_NUM" VARCHAR2 (000009) DEFAULT '000' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_RAUI_CSER~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "/OSP/T_RAUI_CSER^0" ON "/OSP/T_RAUI_CSER~" ("MANDT", "RV_TYPE", "REPORT", "RFCDEST", "CHART_TYPE", "SERIES_NUMBER") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_RAUI_CSER~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_RAUI_CSER content is not required.

3 ETGCLN END /OSP/T_RAUI_CSER -> /OSP/T_RAUI_CSER~ 20160310070851

5 ETGCLN /OSP/T_RAUI_CSER done in 0 seconds

3 ETGCLN START /OSP/T_RAUI_CTG -> /OSP/T_RAUI_CTG~ 20160310070851

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "/OSP/T_RAUI_CTG~" ("MANDT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "CAT_ID" VARCHAR2 (000012) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_RAUI_CTG~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "/OSP/T_RAUI_CTG^0" ON "/OSP/T_RAUI_CTG~" ("MANDT", "CAT_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_RAUI_CTG~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_RAUI_CTG content is not required.

3 ETGCLN END /OSP/T_RAUI_CTG -> /OSP/T_RAUI_CTG~ 20160310070851

5 ETGCLN /OSP/T_RAUI_CTG done in 0 seconds

3 ETGCLN START /OSP/T_RAUI_DCT -> /OSP/T_RAUI_DCT~ 20160310070851

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "/OSP/T_RAUI_DCT~" ("MANDT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "LANG" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "MEND_RFC" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "DC_EVENT_ID" VARCHAR2 (000090) DEFAULT ' ' NOT NULL, "DESCRIPTION" VARCHAR2 (000180) DEFAULT ' ' NOT NULL, "MEND_DESCRIPTION" VARCHAR2 (000180) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_RAUI_DCT~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "/OSP/T_RAUI_DCT^0" ON "/OSP/T_RAUI_DCT~" ("MANDT", "LANG", "MEND_RFC", "DC_EVENT_ID") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_RAUI_DCT~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_RAUI_DCT content is not required.

3 ETGCLN END /OSP/T_RAUI_DCT -> /OSP/T_RAUI_DCT~ 20160310070851

5 ETGCLN /OSP/T_RAUI_DCT done in 0 seconds

3 ETGCLN START /OSP/T_RAUI_DEL -> /OSP/T_RAUI_DEL~ 20160310070851

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "/OSP/T_RAUI_DEL~" ("MANDT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "CAT_ID" VARCHAR2 (000012) DEFAULT ' ' NOT NULL, "REPORT" VARCHAR2 (000120) DEFAULT ' ' NOT NULL, "RFCDEST" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "RP_DEL_TYP" VARCHAR2 (000150) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_RAUI_DEL~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "/OSP/T_RAUI_DEL^0" ON "/OSP/T_RAUI_DEL~" ("MANDT", "CAT_ID", "REPORT", "RFCDEST", "RP_DEL_TYP") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000640 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_RAUI_DEL~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_RAUI_DEL nothing to copy.

3 ETGCLN Number of original rows: 0. Number of copied rows: 0.

3 ETGCLN END /OSP/T_RAUI_DEL -> /OSP/T_RAUI_DEL~ 20160310070851

5 ETGCLN /OSP/T_RAUI_DEL done in 0 seconds

3 ETGCLN START /OSP/T_RAUI_MTT -> /OSP/T_RAUI_MTT~ 20160310070851

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "/OSP/T_RAUI_MTT~" ("MANDT" VARCHAR2 (000009) DEFAULT '000' NOT NULL, "LANG" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "MEND_RFC" VARCHAR2 (000096) DEFAULT ' ' NOT NULL, "SCHEDULE_NO" VARCHAR2 (000015) DEFAULT '00000' NOT NULL, "DESCRIPTION" VARCHAR2 (000180) DEFAULT ' ' NOT NULL) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_RAUI_MTT~' AND INDEXNAME = ' '

3 ETGCLN CREATE UNIQUE INDEX "/OSP/T_RAUI_MTT^0" ON "/OSP/T_RAUI_MTT~" ("MANDT", "LANG", "MEND_RFC", "SCHEDULE_NO") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 NOCOMPRESS STORAGE (INITIAL 0000000016 K NEXT 0000000640 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = '/OSP/T_RAUI_MTT~' AND INDEXNAME = '0'

3 ETGCLN /OSP/T_RAUI_MTT content is not required.

Tail: DBCLONE.LOG

4 ETQ601 - Table "WIZ_STAT"

4 ETQ601 - Table "WPTOTLIUSR"

4 ETQ601 - Table "WRC_CUST"

4 ETQ601 - Table "WRC_DATA"

4 ETQ601 - Table "WRC_DATUSR"

4 ETQ601 - Table "WRC_DEFINE"

4 ETQ601 - Table "WRC_DEFUSR"

4 ETQ601 - Table "WRC_TEXTS"

4 ETQ601 - Table "WRC_TXTUSR"

4 ETQ601 - Table "WSRM_CREA_SID"

4 ETQ601 - Table "WSRM_CSR"

4 ETQ601 - Table "WSRM_DOMAIN_SEQN"

4 ETQ601 - Table "WSRM_EH"

4 ETQ601 - Table "WSRM_EH_SID"

4 ETQ601 - Table "WSRM_ERROR"

4 ETQ601 - Table "WSRM_EVENT_TABLE"

4 ETQ601 - Table "WSRM_INTERVAL"

4 ETQ601 - Table "WSRM_IO_PROCESS"

4 ETQ601 - Table "WSRM_PID_SID_MNR"

4 ETQ601 - Table "WSRM_SEQU_STATUS"

4 ETQ601 - Table "WSRM_TXH_WATCHER"

4 ETQ601 - Table "WSS_PROFILE"

4 ETQ601 - Table "WSS_PROFILE_T"

4 ETQ601 - Table "WSS_STS_URL_TAB"

4 ETQ601 - Table "WWWREPS"

3 ETQ399 7643 entries matched.

2 ETQ399 Added 7643 empty tables.

1 ETQ399 Distributing 12986 tables on 3 processes.

1 ETQ399 Process 1 will copy 4318 tables with total size of 4235.360988 MB.

1 ETQ399 Process 2 will copy 4333 tables with total size of 4235.360917 MB.

1 ETQ399 Process 3 will copy 4335 tables with total size of 4235.360948 MB.

1 ETQ399 Total size cloned: 12706.082852 MB.

2 ETQ399 Requested task ID is 'CLONE_DISTTABLES'.

3 ETQ399 'LIST': Distributed 12986 statements.

3 ETQ399 Generated TQL file 'CLONEINIT.SQL' with 1 SQL statements, log file 'SQLDBSCRIPT.OUT'.

4 ETQ276 Executing SQL-script "CLONEINIT.SQL"

3 ETQ120 20160310120834: PID 5368 execute 'U:\SUM\abap\bin\SAPuptool execdb ..\var\CLONEINIT.SQL', output written to 'U:\SUM\abap\log\SQLSTMTSTD.OUT'.

3 ETQ123 20160310120843: PID 5368 exited with status 0 (time 0.000 real)

3 ETQ399 Reading SQL output from 'SQLDBSCRIPT.OUT'.

1 ETQ399 Number of scheduled processes: 3

2 ETQ399 Requested task ID is 'CLONE_CHK_DISTTABLES'.

4 ETQ399 Preparing internal output table 'LIST' to receive named fields.

3 ETQ399 Generated TQL file 'CHECKCLONEDIST.TQL' with 1 SQL statements, log file 'CHECKCLONEDIST.LOG'.

4 ETQ276 Executing SQL-script "CHECKCLONEDIST.TQL"

3 ETQ120 20160310120843: PID 3580 execute 'U:\SUM\abap\bin\SAPuptool execdb ..\var\CHECKCLONEDIST.TQL', output written to 'U:\SUM\abap\log\SQLSTMTSTD.OUT'.

3 ETQ123 20160310120844: PID 3580 exited with status 0 (time 0.000 real)

3 ETQ399 Reading selections from 'CHECKCLONEDIST.LOG'.

4 ETQ399 Read 0 entries for table 'LIST'.

2 ETQ399 Starting 3 jobs:

4 ETQ265 Starting report "RSUPG_CLONE_TABLES" with variant "SAP_DBCLONE_1" in batch

1 ETQ359 RFC Login to: System="SMD", AsHost="ABCKHIHO12" Nr="00", GwHost="ABCKHIHO12", GwService="sapgw00"

2 ETQ232 RFC Login succeeded

4 ETQ010 Date & Time: 20160310120844

1 ETQ233 Calling function module "SUBST_START_REPORT_IN_BATCH" by RFC

2 ETQ373 parameter "IV_ABORT_ON_ERROR" = ""

2 ETQ373 parameter "IV_AUTHCKNAM" = "DDIC"

2 ETQ373 parameter "IV_BATCHHOST" = "ABCKHIHO12"

2 ETQ373 parameter "IV_JOBNAME" = "DBCLONE1"

2 ETQ373 parameter "IV_REPNAME" = "RSUPG_CLONE_TABLES"

2 ETQ373 parameter "IV_SCHEDEVER" = " "

2 ETQ373 parameter "IV_VARIANTTEXT" = "Parallel tables cloning"

2 ETQ373 parameter "IV_VARNAME" = "SAP_DBCLONE_1"

2 ETQ373 parameter "IV_LANGUAGE" = "E"

2 ETQ399 Table TT_REPORTPARAM (#8):

3 ETQ399 "LOGFILE","P","","","DBCLONE01.SMD",""

3 ETQ399 "ORTAB","P","","","",""

3 ETQ399 "CPTAB","P","","","",""

3 ETQ399 "EXE","P","","","X",""

3 ETQ399 "SHOWSQL","P","","","X",""

3 ETQ399 "TABTYPE","P","","","1",""

3 ETQ399 "TABSMAP","P","","","TAIATRANS.DAT",""

3 ETQ399 "BRIDGE","P","","","",""

2 ETQ373 parameter "IV_BATCHINSTANCE" = ""

1 ETQ234 Call of function module "SUBST_START_REPORT_IN_BATCH" by RFC succeeded

4 ETQ010 Date & Time: 20160310120845

2 ETQ373 parameter "EV_JOBCOUNT" = "12084500"

2 ETQ374 parameter "EV_STARTRC" = "0"

2 ETQ374 parameter "EV_VARIWRC" = "0"

4 ETQ311 Batch job "DBCLONE1" with job count "12084500" scheduled

4 ETQ265 Starting report "RSUPG_CLONE_TABLES" with variant "SAP_DBCLONE_2" in batch

1 ETQ359 RFC Login to: System="SMD", AsHost="ABCKHIHO12" Nr="00", GwHost="ABCKHIHO12", GwService="sapgw00"

2 ETQ232 RFC Login succeeded

4 ETQ010 Date & Time: 20160310120845

1 ETQ233 Calling function module "SUBST_START_REPORT_IN_BATCH" by RFC

2 ETQ373 parameter "IV_ABORT_ON_ERROR" = ""

2 ETQ373 parameter "IV_AUTHCKNAM" = "DDIC"

2 ETQ373 parameter "IV_BATCHHOST" = "ABCKHIHO12"

2 ETQ373 parameter "IV_JOBNAME" = "DBCLONE2"

2 ETQ373 parameter "IV_REPNAME" = "RSUPG_CLONE_TABLES"

2 ETQ373 parameter "IV_SCHEDEVER" = " "

2 ETQ373 parameter "IV_VARIANTTEXT" = "Parallel tables cloning"

2 ETQ373 parameter "IV_VARNAME" = "SAP_DBCLONE_2"

2 ETQ373 parameter "IV_LANGUAGE" = "E"

2 ETQ399 Table TT_REPORTPARAM (#8):

3 ETQ399 "LOGFILE","P","","","DBCLONE02.SMD",""

3 ETQ399 "ORTAB","P","","","",""

3 ETQ399 "CPTAB","P","","","",""

3 ETQ399 "EXE","P","","","X",""

3 ETQ399 "SHOWSQL","P","","","X",""

3 ETQ399 "TABTYPE","P","","","2",""

3 ETQ399 "TABSMAP","P","","","TAIATRANS.DAT",""

3 ETQ399 "BRIDGE","P","","","",""

2 ETQ373 parameter "IV_BATCHINSTANCE" = ""

1 ETQ234 Call of function module "SUBST_START_REPORT_IN_BATCH" by RFC succeeded

4 ETQ010 Date & Time: 20160310120845

2 ETQ373 parameter "EV_JOBCOUNT" = "12084500"

2 ETQ374 parameter "EV_STARTRC" = "0"

2 ETQ374 parameter "EV_VARIWRC" = "0"

4 ETQ311 Batch job "DBCLONE2" with job count "12084500" scheduled

4 ETQ265 Starting report "RSUPG_CLONE_TABLES" with variant "SAP_DBCLONE_3" in batch

1 ETQ359 RFC Login to: System="SMD", AsHost="ABCKHIHO12" Nr="00", GwHost="ABCKHIHO12", GwService="sapgw00"

2 ETQ232 RFC Login succeeded

4 ETQ010 Date & Time: 20160310120845

1 ETQ233 Calling function module "SUBST_START_REPORT_IN_BATCH" by RFC

2 ETQ373 parameter "IV_ABORT_ON_ERROR" = ""

2 ETQ373 parameter "IV_AUTHCKNAM" = "DDIC"

2 ETQ373 parameter "IV_BATCHHOST" = "ABCKHIHO12"

2 ETQ373 parameter "IV_JOBNAME" = "DBCLONE3"

2 ETQ373 parameter "IV_REPNAME" = "RSUPG_CLONE_TABLES"

2 ETQ373 parameter "IV_SCHEDEVER" = " "

2 ETQ373 parameter "IV_VARIANTTEXT" = "Parallel tables cloning"

2 ETQ373 parameter "IV_VARNAME" = "SAP_DBCLONE_3"

2 ETQ373 parameter "IV_LANGUAGE" = "E"

2 ETQ399 Table TT_REPORTPARAM (#8):

3 ETQ399 "LOGFILE","P","","","DBCLONE03.SMD",""

3 ETQ399 "ORTAB","P","","","",""

3 ETQ399 "CPTAB","P","","","",""

3 ETQ399 "EXE","P","","","X",""

3 ETQ399 "SHOWSQL","P","","","X",""

3 ETQ399 "TABTYPE","P","","","3",""

3 ETQ399 "TABSMAP","P","","","TAIATRANS.DAT",""

3 ETQ399 "BRIDGE","P","","","",""

2 ETQ373 parameter "IV_BATCHINSTANCE" = ""

1 ETQ234 Call of function module "SUBST_START_REPORT_IN_BATCH" by RFC succeeded

4 ETQ010 Date & Time: 20160310120846

2 ETQ373 parameter "EV_JOBCOUNT" = "12084600"

2 ETQ374 parameter "EV_STARTRC" = "0"

2 ETQ374 parameter "EV_VARIWRC" = "0"

4 ETQ311 Batch job "DBCLONE3" with job count "12084600" scheduled

2 ETQ399 20160310120847: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310120847: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310120847: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:08:47: sleeping 30 seconds

2 ETQ399 20160310120917: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310120917: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310120917: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:09:17: sleeping 30 seconds

2 ETQ399 20160310120947: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310120947: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310120947: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:09:47: sleeping 30 seconds

2 ETQ399 20160310121017: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121017: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121017: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:10:17: sleeping 30 seconds

2 ETQ399 20160310121047: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121047: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121047: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:10:47: sleeping 30 seconds

2 ETQ399 20160310121117: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121117: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121117: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:11:17: sleeping 30 seconds

2 ETQ399 20160310121148: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121148: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121148: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:11:48: sleeping 30 seconds

2 ETQ399 20160310121218: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121218: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121218: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:12:18: sleeping 30 seconds

2 ETQ399 20160310121248: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121248: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121248: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:12:48: sleeping 30 seconds

2 ETQ399 20160310121318: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121318: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121318: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:13:18: sleeping 30 seconds

2 ETQ399 20160310121348: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121348: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121348: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:13:48: sleeping 30 seconds

2 ETQ399 20160310121418: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121418: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121418: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:14:18: sleeping 30 seconds

2 ETQ399 20160310121448: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121448: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121448: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:14:48: sleeping 30 seconds

2 ETQ399 20160310121518: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121518: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121519: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:15:19: sleeping 30 seconds

2 ETQ399 20160310121549: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121549: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121549: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:15:49: sleeping 30 seconds

2 ETQ399 20160310121619: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121619: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121619: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:16:19: sleeping 30 seconds

2 ETQ399 20160310121649: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121649: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121649: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:16:49: sleeping 30 seconds

2 ETQ399 20160310121719: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121719: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121719: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:17:19: sleeping 30 seconds

2 ETQ399 20160310121749: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121749: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121749: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:17:49: sleeping 30 seconds

2 ETQ399 20160310121819: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121819: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121819: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:18:19: sleeping 30 seconds

2 ETQ399 20160310121849: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121849: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121849: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:18:49: sleeping 30 seconds

2 ETQ399 20160310121919: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121919: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121919: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:19:19: sleeping 30 seconds

2 ETQ399 20160310121949: Job DBCLONE1 jobcount 12084500 still running...

2 ETQ399 20160310121950: Job DBCLONE2 jobcount 12084500 still running...

2 ETQ399 20160310121950: Job DBCLONE3 jobcount 12084600 still running...

2 ETQ399 2016/03/10 12:19:50: sleeping 30 seconds

1 ETQ359 RFC Login to: System="SMD", AsHost="ABCKHIHO12" Nr="00", GwHost="ABCKHIHO12", GwService="sapgw00"

2EETQ231 RFC Login failed

2 ETQ399 2016/03/10 12:23:20: sleeping 30 seconds

1 ETQ359 RFC Login to: System="SMD", AsHost="ABCKHIHO12" Nr="00", GwHost="ABCKHIHO12", GwService="sapgw00"

2EETQ231 RFC Login failed

2 ETQ399 2016/03/10 12:26:50: sleeping 30 seconds

1 ETQ359 RFC Login to: System="SMD", AsHost="ABCKHIHO12" Nr="00", GwHost="ABCKHIHO12", GwService="sapgw00"

2EETQ231 RFC Login failed

2 ETQ399 2016/03/10 12:30:20: sleeping 30 seconds

1 ETQ359 RFC Login to: System="SMD", AsHost="ABCKHIHO12" Nr="00", GwHost="ABCKHIHO12", GwService="sapgw00"

2EETQ231 RFC Login failed

1EETQ399 Last error code set is: Batch jobs (DBCLONE1) may still be running: started 3, finished/aborted/running 0/0/3, check SM37 and SM21 for details

1EETQ204 Upgrade phase "DBCLONE" aborted with severe errors ("20160310123350")

Hi Qazi,

Can you check why RFC is getting failed.

Kindly check the status of DDIC user in 000 client.

With Regards

Ashutosh Chaturvedi

I told you earlier in this thread. WIN Server have downtime due to sudden issue in our cloud. During the downtime thi sDBCLONE phase was running thats why SUM having RFC Issues.

Kindly suggest

Hi Qazi,

It means the log is not getting updated.

Can you start all the system and retry the SUM.

Also paste the screenshot of SUM

With Regards

Ashutosh Chaturvedi

Thanks man i have created jobs again and run your suggested scripts and DBCLONE Phase completed. with 9 batch jobs because i have exended batch jobs as well as per the logs

Regads

Qazi

Hi Ashutosh,

Another error in Step on step DBSTATS_SHDCLONE.

Can i send you logs and screenshots???

Regards,

Qazi

Hi,

Please check below Logs and Screenshots attached.

UPST_SHDCLONE.ELG:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

SQL EXECUTION ERRORS and RETURN CODE in EXSTATE11.LOG

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

3 ETQ398XSQL: '"ARC_DESTR_RES~"' ); END;

3 ETQ398 SQL: BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME =>

3 ETQ398XSQL: '"ARFCRSTATE~"' ); END;

1 ETQ000 ==================================================

4 ETQ010 Date & Time: 20160315112025

1EETQ008 Error message: DBSL error 99 (db code 3113):

1EETQ009XORA-03113: end-of-file on communication channel

1EETQ009XProcess ID: 5428

1EETQ009XSession ID: 346 Serial number: 12505

1EETQ003 exit code: "20"

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

SQL EXECUTION ERRORS and RETURN CODE in EXSTATE15.LOG

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

4 ETQ010 Date & Time: 20160315112401

3 ETQ398 SQL: BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME =>

3 ETQ398XSQL: '"CTS_EXT_PS~"' ); END;

1 ETQ000 ==================================================

4 ETQ010 Date & Time: 20160315112401

1EETQ008 Error message: DBSL error 99 (db code 3113):

1EETQ009XORA-03113: end-of-file on communication channel

1EETQ009XProcess ID: 7348

1EETQ009XSession ID: 59 Serial number: 7477

1EETQ003 exit code: "20"

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

SQL EXECUTION ERRORS and RETURN CODE in EXSTATE16.LOG

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

4 ETQ010 Date & Time: 20160315112401

3 ETQ398 SQL: BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME =>

3 ETQ398XSQL: '"BIZCRDC~"' ); END;

1 ETQ000 ==================================================

4 ETQ010 Date & Time: 20160315112401

1EETQ008 Error message: DBSL error 99 (db code 3113):

1EETQ009XORA-03113: end-of-file on communication channel

1EETQ009XProcess ID: 5948

1EETQ009XSession ID: 250 Serial number: 19527

1EETQ003 exit code: "20"

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

SQL EXECUTION ERRORS and RETURN CODE in EXSTATE17.LOG

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

4 ETQ010 Date & Time: 20160315112401

3 ETQ398 SQL: BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME =>

3 ETQ398XSQL: '"BDSLOIO14~"' ); END;

1 ETQ000 ==================================================

4 ETQ010 Date & Time: 20160315112401

1EETQ008 Error message: DBSL error 99 (db code 3113):

1EETQ009XORA-03113: end-of-file on communication channel

1EETQ009XProcess ID: 5144

1EETQ009XSession ID: 105 Serial number: 23257

1EETQ003 exit code: "20"

Waiting for your response

Regards,

Qazi

Hi Qazi,

Just check the filesystem of the oracle database.

if the filesystem is full , then clear space in corresponding system.

else

take a clean restart of oracle database.

If the issue doesn't get resolve , then open a new thread.

With Regards

Ashutosh Chaturvedi

This is resolved with a retry SUM thats it.

But another issue occurred in step MAIN_SHDRUN/START_SHDI_FIRST

Plz reply on new thread:

Regards

Qazi

Answers (0)

Ask a Question

Top Q&A Solution Author

User

Count

Software Upgrade Manager! FATAL ERROR Checking job DBCLONE1/12084500 returned 1

Accepted Solutions (1)

Accepted Solutions (1)

Answers (0)

Re: Cloud Transport Management configuration betwe...

Is it possible to change the worker-id in S/4HANA ...

Re: How to quantify memory usage of an ABAP instan...

Re: Table DDNTF is not active in the dictionary er...

Splitting commaseperated value and passing it to d...