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



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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.