Spam error during sap bw upgrade

[Former Member]

Dear experts,

During the upgrade of sap bw from support pack 8 to 9, w'he encoutered the following errors during the import_proper phase :

2WETP000 15:47:50: Retcode 1: error in DDL statement for "DEMO_CDS_UNTCNV               " - repeat

2EETP345 15:48:02: Retcode 1: SQL-error "4121-Cannot find either column "dbw" or the user-defined f

2EETP345 unction or aggregate "dbw.UNIT_CONVERSION", or the name is ambiguous." in DDL statement fo

2EETP345 r "DEMO_CDS_UNTCNV               "

2 ETP000  --------------- DB-ROLLBACK() ---------------

2EETP334 15:48:02: error in DDL, nametab for "DEMO_CDS_UNTCNV" not activated

2 ETP301 ----------------------------------------------------------------------

3 ETP361 "0" Shadow-Nametabs activated, DDL executed

2 ETP362 "2" Shadow-Nametab activations failed

2 ETP360 Begin: Act. of Shadow-Nametabs with DDL ("2015/03/03 15:47:38")

2 ETP363 End  : Act. of Shadow-Nametabs with DDL ("2015/03/03 15:48:02")

2 ETP301 ----------------------------------------------------------------------

2 ETP301 ----------------------------------------------------------------------

2 ETP364 Begin: Act. of Shadow-Nametabs ("2015/03/03 15:48:02")

2 ETP301 ----------------------------------------------------------------------

2 ETP301 ----------------------------------------------------------------------

2 ETP338XTouch Load of nametabs

2 ETP301 ----------------------------------------------------------------------

2 ETP301 ----------------------------------------------------------------------

3 ETP365 "0" TouchLoad succeeded

3 ETP362 "0" TouchLoad failed

2 ETP364 Begin: TouchLoad of Nametabs ("2015/03/03 15:48:02")

2 ETP366 End:   TouchLoad of Shadow-Nametabs ("2015/03/03 15:48:02")

2 ETP301 ----------------------------------------------------------------------

1 ETP172 MOVE OF NAMETABS

Thanks in advance for your help.

[manumohandas82 · Accepted solution]

Hi Tariq ,

Please check the following SAP Note

2109638 - CDS views: Conversion functions do not exist in the database; CREATE statement is not exec...

and follow the instructions as instructed in the note

Thanks ,

Manu

[Former Member · Accepted solution]

Many thanks Manu, my problem has been solved via the sap note "2109638"