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.
SAP Knowledge Base Article - Preview