2263255 - Error ORA-01792 occurs in MAIN_SHDIMP/PARMVNT_SHD phase

Error ORA-01792 occurs in MAIN_SHDIMP/PARMVNT_SHD phase during upgrade.

For example:

As to the error infomation, more than 1000 columns are defined in table “ADRC”, which is NOT acceptable.

 

In phase PARMVNT_SHD, shadow instance is not existing any more, but shadow tables are still existing. Database objects for these shadow tables are to be created/adjusted, as well as runtime objects to be created. 

 

In the relevant log file <DIR_PUT>/log/PD<timestamp>.<SID>, you can find the complete trace:

3 ETP379X06:52:08: activating Nametab "ADRC":
2 ETP000 >> Name of inactive nametab to read : DDXTT~
2 ETP000 >> Format of inactive nametab to read: 5.0
3 ETP355Xstatements:
3 ETP000 ALTER TABLE "ADRC~"
3 ETP000 ADD ("ADRC_UUID" RAW (000016)
3 ETP000 ,
3 ETP000 "UUID_BELATED" VARCHAR2 (000003)
3 ETP000 DEFAULT ' ' NOT NULL
3 ETP000 ,
3 ETP000 "ID_CATEGORY" VARCHAR2 (000003)
3 ETP000 DEFAULT ' ' NOT NULL
3 ETP000 ,
3 ETP000 "ADRC_ERR_STATUS" VARCHAR2 (000003)
3 ETP000 DEFAULT ' ' NOT NULL
3 ETP000 ,
3 ETP000 "COUNTY_CODE" VARCHAR2 (000024)
3 ETP000 DEFAULT ' ' NOT NULL
3 ETP000 ,
3 ETP000 "COUNTY" VARCHAR2 (000120)
3 ETP000 DEFAULT ' ' NOT NULL
3 ETP000 ,
3 ETP000 "TOWNSHIP_CODE" VARCHAR2 (000024)
3 ETP000 DEFAULT ' ' NOT NULL
3 ETP000 ,
3 ETP000 "TOWNSHIP" VARCHAR2 (000120)
3 ETP000 DEFAULT ' ' NOT NULL
3 ETP000 ,
3 ETP000 "MC_COUNTY" VARCHAR2 (000075)
3 ETP000 DEFAULT ' ' NOT NULL
3 ETP000 ,
3 ETP000 "MC_TOWNSHIP" VARCHAR2 (000075)
3 ETP000 DEFAULT ' ' NOT NULL
3 ETP000 ,
3 ETP000 "XPCPT" VARCHAR2 (000003)
3 ETP000 DEFAULT ' ' NOT NULL
3 ETP000 )
3 ETP000
2WETP000 14:56:18: Retcode 1: error in DDL statement for "ADRC " - repeat
2EETP345 14:56:30: Retcode 1: SQL-error "1792-ORA-01792: maximum number of columns in a table or vi
2EETP345 ew is 1000" in DDL statement for "ADRC "
2 ETP000 DB-ROLLBACK()
2EETP334 14:56:30: error in DDL, nametab for "ADRC" not activated

 

It indicates that shadow table ADRC~ is to be adjusted with more columns added, but it is found that ADRC~ will have more than 1000 columns with these new columns' adding.

However as to the above SQL statement, only 11 new columns to be added, which means that the current ADRC~ already has neally 1000 columns included.

Is it really true?

If you check using "desc ADRC~", the result shows only 89 columns existing in shadow table ADRC~. Even with 11 new columns added, ADRC~ will have 100 columns, but not 1000 columns.

 

So why error "ORA-01792: maximum number of columns in a table or view is 1000" occurs on shadow table ADRC~? How to resolve the error? 

Read more...

Release based on NetWeaver

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; 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

 ORA-01792, PARMVNT_SHD, maximum number of columns in a table or view is 1000, unused column, hidden column, DBA_UNUSED_COL_TABS,  DROP UNUSED COLUMNS , KBA , BC-DWB-DIC-AC , ABAP Dictionary Activation and Conversion , BC-UPG-TLS-TLA , Upgrade tools for ABAP , BC-DB-ORA , Oracle , Problem