Error in phase MAIN_SWITCH/PARMVNT_XCNV during EHP5 upgrade

[Former Member]

Dear All,

I am doing upgrade of ERP system from EHP4 to EHP5 on AIX 6.1 and DB2 LUW 9.7

I am stuck in phase MAIN_SWITCH/PARMVNT_XCNV. The following is the error :

MVNTABS ERRORS: ddlntabs and RETURN CODE in PD001016.DEV

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

2EETP345 08:24:44: Retcode 1: SQL-error "-190-SQL0190N ALTER TABLE "SAPDEV.ADMI_FILE_DAVLNK" speci

2EETP345 fied attributes for column "DAS_HOST" that are not compatible with the existing column. S

2EETP345 QLSTATE=42837" in DDL statement for "ADMI_FILE_DAVLNK "

2EETP334 08:24:44: error in DDL, nametab for "ADMI_FILE_DAVLNK" not activated

2EETP345 08:24:56: Retcode 1: SQL-error "-190-SQL0190N ALTER TABLE "SAPDEV.CTSOBJLIST" specified a

2EETP345 ttributes for column "DETAILSURI" that are not compatible with the existing column. SQLST

2EETP345 ATE=42837" in DDL statement for "CTSOBJLIST "

2EETP334 08:24:56: error in DDL, nametab for "CTSOBJLIST" not activated

2EETP345 08:25:08: Retcode 1: SQL-error "-190-SQL0190N ALTER TABLE "SAPDEV.CTSOBJLISTT" specified

2EETP345 attributes for column "NAMEEXT" that are not compatible with the existing column. SQLSTAT

2EETP345 E=42837" in DDL statement for "CTSOBJLISTT "

2EETP334 08:25:08: error in DDL, nametab for "CTSOBJLISTT" not activated

2EETP345 08:25:20: Retcode 1: SQL-error "-190-SQL0190N ALTER TABLE "SAPDEV.FDT_WD_PARAMS" specifie

2EETP345 d attributes for column "PARAM_VALUE" that are not compatible with the existing column. S

2EETP345 QLSTATE=42837" in DDL statement for "FDT_WD_PARAMS "

2EETP334 08:25:20: error in DDL, nametab for "FDT_WD_PARAMS" not activated

2EETP345 08:25:32: Retcode 1: SQL-error "-190-SQL0190N ALTER TABLE "SAPDEV.SCTS_PROJECTT" specifie

2EETP345 d attributes for column "DESCRIPTION" that are not compatible with the existing column. S

2EETP345 QLSTATE=42837" in DDL statement for "SCTS_PROJECTT "

2EETP334 08:25:32: error in DDL, nametab for "SCTS_PROJECTT" not activated

1 ETP111 exit code : "8"

Please help me resolve this ASAP.

Thanks

[Former Member]

Hello,

This similar problem thread seems nearby your problem -

Thanks

[Former Member]

Thanks for your response.

Could you be more specific as in what steps do I have to execute? The thread talks about 'Invalid Modifications to column' error. In my case the error is as follows :

ETP399 ALTER TABLE "SCTS_PROJECTT"

3 ETP399 ALTER COLUMN "DESCRIPTION" set data type SAPDB6VARCHAR(000512)

3 ETP399

2WETP000 08:00:14: Retcode 1: error in DDL statement for "SCTS_PROJECTT " - repeat

2EETP345 08:00:26: Retcode 1: SQL-error "-190-SQL0190N ALTER TABLE "SAPDEV.SCTS_PROJECTT" specifie

2EETP345 d attributes for column "DESCRIPTION" that are not compatible with the existing column. S

2EETP345 QLSTATE=42837" in DDL statement for "SCTS_PROJECTT "

2 ETP399 -

---

DB-ROLLBACK() -

---

2EETP334 08:00:26: error in DDL, nametab for "SCTS_PROJECTT" not activated

It is trying to set data type SAPDB6VARCHAR to column "DESCRIPTION" and that is where it is failing. Please help me.