SAP Knowledge Base Article - Preview

2709011 - Upgrade is getting failed in phase PARMVNT_XCNV with error : SQL-error "39726-ORA-39726: unsupported add/drop column operation on compressed tables

Symptom

Below is the sample error coming in phase  MAIN_SWITCH/PARMVNT_XCNV:

Directory: SUM/abap/log

Logfile: PD900921_PARMVNT_XCNV.Log

3 ETP000 "XPCPT" VARCHAR2 (000003)
3 ETP000 DEFAULT ' ' NOT NULL
3 ETP000 )
3 ETP000
2WETP000 12:53:06: Retcode 1: error in DDL statement for "ADCP " - repeat
2EETP345 12:53:18: Retcode 1: SQL-error "39726-ORA-39726: unsupported add/drop column operation on
2EETP345 compressed tables" in DDL statement for "ADCP "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 12:53:18: error in DDL, nametab for "ADCP" not activated

3 ETP000 "XPCPT" VARCHAR2 (000003)
3 ETP000 DEFAULT ' ' NOT NULL
3 ETP000 )
3 ETP000
2WETP000 12:53:18: Retcode 1: error in DDL statement for "ADRC " - repeat
2EETP345 12:53:30: Retcode 1: SQL-error "39726-ORA-39726: unsupported add/drop column operation on
2EETP345 compressed tables" in DDL statement for "ADRC "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 12:53:30: error in DDL, nametab for "ADRC" not activated


Read more...

Environment

Upgrade of NW system using SUM tool

Database: Oracle 12c and higher

Product

SAP Customer Relationship Management 7.0 on SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

KBA , BC-UPG-PRP , Upgrade Preparation , 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 ONE Support launchpad (Login required).

Search for additional results

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