Symptom
- During an upgrade/update using the SUM tool, it stops in phase MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE with following error:
Log directory: <DIR_PUT>/log /SAPUpConsole.log
Severe error(s) occurred in phase MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE!
Last error code set: Single errors (code <= 8) found in logfile 'DBCLONE.ELG'
*ERROR* :
Detected the following errors:
# D:\usr\sap\<SID>\SUM\abap\log\DBCLONE01.<SID>:
3 ETGCLN END GUI_E2E_XML -> GUI_E2E_XML~ 20140904144610
5 ETGCLN GUI_E2E_XML done in 1 seconds
3 ETGCLN START GVD_BGPROCESS -> GVD_BGPROCESS~ 20140904144610
3 ETGCLN Primary key strategy for current table is 0
3 ETGCLN CREATE TABLE "GVD_BGPROCESS~" ("SNAPSHOT_ID" VARCHAR2 (000030)
DEFAULT '0000000000' NOT NULL, "INST_ID" NUMBER (000022, 000000) DEFAULT 0 NOT
NULL, "NAME" VARCHAR2 (000015) DEFAULT ' ' NOT NULL, "PADDR" RAW (000008),
"DESCRIPTION" VARCHAR2 (000192) DEFAULT ' ' NOT NULL, "ERROR" NUMBER (000022,
000000) DEFAULT 0 NOT NULL) PCTFREE 00 PCTUSED 00 INITRANS 001 TABLESPACE
PSAPSR3 COMPRESS BASIC STORAGE (INITIAL 0000000064 K NEXT 0000001024 K
MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001
FREELIST GROUPS 01)
1EETGCLN ORA-00922: missing or invalid option
1EETGCLN GVD_BGPROCESS
1EETGCLN Error when cloning table structure
======================================================================
Log directory: <DIR_PUT>/log/DBCLONE.ELG
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
CLONING ERRORS and RETURN CODE in DBCLONE01.<SID>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
8 ETGCLN START CLONING TABLES
3 ETGCLN Reading D:\usr\sap\<SID>\SUM\abap\mem\TAIATRANS.DAT
3 ETGCLN START GVD_BGPROCESS -> GVD_BGPROCESS~ 20140904153905
3 ETGCLN Primary key strategy for current table is 0
3 ETGCLN CREATE TABLE "GVD_BGPROCESS~" ("SNAPSHOT_ID" VARCHAR2 (000030) DEFAULT '0000000000' NOT NULL, "INST_ID" NUMBER (000022, 000000) DEFAULT 0 NOT NULL, "NAME" VARCHAR2 (000015) DEFAULT ' ' NOT NULL, "PADDR" RAW (00
1EETGCLN ORA-00922: missing or invalid option
1EETGCLN GVD_BGPROCESS
1EETGCLN Error when cloning table structure
3 ETGCLN START GVD_DATABASE -> GVD_DATABASE~ 20140904153906
3 ETGCLN Primary key strategy for current table is 0
3 ETGCLN CREATE TABLE "GVD_DATABASE~" ("SNAPSHOT_ID" VARCHAR2 (000030) DEFAULT '0000000000' NOT NULL, "INST_ID" NUMBER (000022, 000000) DEFAULT 0 NOT NULL, "DBID" NUMBER (000022, 000000) DEFAULT 0 NOT NULL, "NAME" VARCH
1EETGCLN ORA-00922: missing or invalid option
1EETGCLN GVD_DATABASE
1EETGCLN Error when cloning table structure
3 ETGCLN START GVD_DB_CACHE_ADV -> GVD_DB_CACHE_ADV~ 20140904153906
3 ETGCLN Primary key strategy for current table is 0
3 ETGCLN CREATE TABLE "GVD_DB_CACHE_ADV~" ("SNAPSHOT_ID" VARCHAR2 (000030) DEFAULT '0000000000' NOT NULL, "INST_ID" NUMBER (000022, 000000) DEFAULT 0 NOT NULL, "ID" NUMBER (000022, 000000) DEFAULT 0 NOT NULL, "NAME" VAR
1EETGCLN ORA-00922: missing or invalid option
1EETGCLN GVD_DB_CACHE_ADV
1EETGCLN Error when cloning table structure
- Phase MAIN_NEWBAS/PARCONV_UPG has errors like following:
2EETP345 21:48:33: Retcode 1: SQL-error "922-ORA-00922: missing or invalid option" in DDL statement
2EETP345 for "/SAPPCE/TDPC01 "
2 ETP000 DB-ROLLBACK()
2EETP334 21:48:33: error in DDL, nametab for "/SAPPCE/TDPC01" not activated
Read more...
Environment
- Upgrade ABAP stack using SUM tool
- Oracle Database
Product
Keywords
DBCLONE , SUM, ORACLE, Upgrade, ORA-00922 , ABAP , KBA , BC-UPG-TLS-TLA , Upgrade tools for ABAP , BC-DB-ORA , Oracle , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.