SAP Knowledge Base Article - Preview

2849731 - SUM Upgrade: Error copying table data table SPROXHDR

Symptom

During SAP system upgrade using SUM the following error is reported in the MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE phase.

LINE.jpg
DBCLONE01.SID ->

3 ETGCLN ALTER TABLE "SPROXHDR~" APPEND YES

3 ETGCLN INSERT INTO "SPROXHDR~" ( "OBJECT", "OBJ_NAME", "INACTIVE", "OBJECT_M", "OBJ_NAME_M", "HASH_ID", "ID", "IFR_GLOBAL", "IFR_TYPE", "IFR_NAME", "IFR_NSPCE", "IFR_GNSPCE", "CREATED_ON", "CREATED_BY", "CHANGED_ON", "CHANGED_BY", "GEN_VERS", "PREFIX", "CATEGORY", "DIRECTION", "SYNCHRON", "GEN_APPL", "ENH_NAME", "ENH_NSPCE", "ENH_HASH_ID", "XML_NSPCE", "XML_NAME", "FURTHER_DATA", "BO_DATA", "CHANGED_ON_IFR", "VERSION_ID", "IFR_STATE", "EVENT", "DYNAMIC", "STCM" ) SELECT "OBJECT", "OBJ_NAME", "INACTIVE", "OBJECT_M", "OBJ_NAME_M", "HASH_ID", "ID", "IFR_GLOBAL", "IFR_TYPE", "IFR_NAME", "IFR_NSPCE", "IFR_GNSPCE", "CREATED_ON", "CREATED_BY", "CHANGED_ON", "CHANGED_BY", "GEN_VERS", "PREFIX", "CATEGORY", "DIRECTION", "SYNCHRON", "GEN_APPL", "ENH_NAME", "ENH_NSPCE", "ENH_HASH_ID", "XML_NSPCE", "XML_NAME", "FURTHER_DATA", "BO_DATA", "CHANGED_ON_IFR", "VERSION_ID", "IFR_STATE", "EVENT", "DYNAMIC", "STCM" FROM "SPROXHDR" WHERE "OBJECT" >= 'TABL' AND ( "OBJECT" < 'TTYP' )

3 ETGCLN INSERT INTO "SPROXHDR~" ( "OBJECT", "OBJ_NAME", "INACTIVE", "OBJECT_M", "OBJ_NAME_M", "HASH_ID", "ID", "IFR_GLOBAL", "IFR_TYPE", "IFR_NAME", "IFR_NSPCE", "IFR_GNSPCE", "CREATED_ON", "CREATED_BY", "CHANGED_ON", "CHANGED_BY", "GEN_VERS", "PREFIX", "CATEGORY", "DIRECTION", "SYNCHRON", "GEN_APPL", "ENH_NAME", "ENH_NSPCE", "ENH_HASH_ID", "XML_NSPCE", "XML_NAME", "FURTHER_DATA", "BO_DATA", "CHANGED_ON_IFR", "VERSION_ID", "IFR_STATE", "EVENT", "DYNAMIC", "STCM" ) SELECT "OBJECT", "OBJ_NAME", "INACTIVE", "OBJECT_M", "OBJ_NAME_M", "HASH_ID", "ID", "IFR_GLOBAL", "IFR_TYPE", "IFR_NAME", "IFR_NSPCE", "IFR_GNSPCE", "CREATED_ON", "CREATED_BY", "CHANGED_ON", "CHANGED_BY", "GEN_VERS", "PREFIX", "CATEGORY", "DIRECTION", "SYNCHRON", "GEN_APPL", "ENH_NAME", "ENH_NSPCE", "ENH_HASH_ID", "XML_NSPCE", "XML_NAME", "FURTHER_DATA", "BO_DATA", "CHANGED_ON_IFR", "VERSION_ID", "IFR_STATE", "EVENT", "DYNAMIC", "STCM" FROM "SPROXHDR" WHERE "OBJECT" >= 'TTYP' AND ( "OBJECT" = 'TTYP' AND "OBJ_NAME" < 'NWATSVOIEKOINGREDIENT_TAB' )

3 ETGCLN INSERT INTO "SPROXHDR~" ( "OBJECT", "OBJ_NAME", "INACTIVE", "OBJECT_M", "OBJ_NAME_M", "HASH_ID", "ID", "IFR_GLOBAL", "IFR_TYPE", "IFR_NAME", "IFR_NSPCE", "IFR_GNSPCE", "CREATED_ON", "CREATED_BY", "CHANGED_ON", "CHANGED_BY", "GEN_VERS", "PREFIX", "CATEGORY", "DIRECTION", "SYNCHRON", "GEN_APPL", "ENH_NAME", "ENH_NSPCE", "ENH_HASH_ID", "XML_NSPCE", "XML_NAME", "FURTHER_DATA", "BO_DATA", "CHANGED_ON_IFR", "VERSION_ID", "IFR_STATE", "EVENT", "DYNAMIC", "STCM" ) SELECT "OBJECT", "OBJ_NAME", "INACTIVE", "OBJECT_M", "OBJ_NAME_M", "HASH_ID", "ID", "IFR_GLOBAL", "IFR_TYPE", "IFR_NAME", "IFR_NSPCE", "IFR_GNSPCE", "CREATED_ON", "CREATED_BY", "CHANGED_ON", "CHANGED_BY", "GEN_VERS", "PREFIX", "CATEGORY", "DIRECTION", "SYNCHRON", "GEN_APPL", "ENH_NAME", "ENH_NSPCE", "ENH_HASH_ID", "XML_NSPCE", "XML_NAME", "FURTHER_DATA", "BO_DATA", "CHANGED_ON_IFR", "VERSION_ID", "IFR_STATE", "EVENT", "DYNAMIC", "STCM" FROM "SPROXHDR" WHERE ( "OBJECT" = 'TTYP' AND "OBJ_NAME" >= 'NWATSVOIEKOINGREDIENT_TAB' OR "OBJECT" > 'TTYP' ) AND "OBJECT" < 'TABL'

3 ETGCLN INSERT INTO "SPROXHDR~" ( "OBJECT", "OBJ_NAME", "INACTIVE", "OBJECT_M", "OBJ_NAME_M", "HASH_ID", "ID", "IFR_GLOBAL", "IFR_TYPE", "IFR_NAME", "IFR_NSPCE", "IFR_GNSPCE", "CREATED_ON", "CREATED_BY", "CHANGED_ON", "CHANGED_BY", "GEN_VERS", "PREFIX", "CATEGORY", "DIRECTION", "SYNCHRON", "GEN_APPL", "ENH_NAME", "ENH_NSPCE", "ENH_HASH_ID", "XML_NSPCE", "XML_NAME", "FURTHER_DATA", "BO_DATA", "CHANGED_ON_IFR", "VERSION_ID", "IFR_STATE", "EVENT", "DYNAMIC", "STCM" ) SELECT "OBJECT", "OBJ_NAME", "INACTIVE", "OBJECT_M", "OBJ_NAME_M", "HASH_ID", "ID", "IFR_GLOBAL", "IFR_TYPE", "IFR_NAME", "IFR_NSPCE", "IFR_GNSPCE", "CREATED_ON", "CREATED_BY", "CHANGED_ON", "CHANGED_BY", "GEN_VERS", "PREFIX", "CATEGORY", "DIRECTION", "SYNCHRON", "GEN_APPL", "ENH_NAME", "ENH_NSPCE", "ENH_HASH_ID", "XML_NSPCE", "XML_NAME", "FURTHER_DATA", "BO_DATA", "CHANGED_ON_IFR", "VERSION_ID", "IFR_STATE", "EVENT", "DYNAMIC", "STCM" FROM "SPROXHDR" WHERE "OBJECT" >= 'TABL'

1EETGCLN
1EETGCLN SPROXHDR
1EETGCLN Error copying table data
9 ETGCLN CLONING TABLES FAILED
3 ETGCLN ************(202333)************
4 EPU202XEND OF SECTION BEING ANALYZED END OF DBCLONE ======================================================
LINE.jpg


Read more...

Environment

  • Db2 z/OS any version

Product

SAP ERP 6.0 ; SAP NetWeaver all versions

Keywords

SPROXHDR~OBJ , KBA , BC-DB-DB2-UPG , DB2 for z/OS - Upgrade , 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.