2153042 - HANA SQL Error 7 - ALTER TABLE fails with "feature not supported: cannot modify type of column table to column" | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2153042 - HANA SQL Error 7 - ALTER TABLE fails with "feature not supported: cannot modify type of column table to column"

Symptom

The Software Update Manager (SUM) log file or any other HANA client shows the below SQL error code on execution of a particular ALTER TABLE ... ALTER TYPE statement on the HANA database:

3 ETP355Xstatements:
3 ETP000 ALTER TABLE "REPOSRC~" ALTER TYPE COLUMN
3 ETP000
2WETP000 08:16:38: Retcode 1: error in DDL statement for "REPOSRC " - repeat
2EETP345 08:16:50: Retcode 1: SQL-error "7-feature not supported: cannot modify type of column table to column" in DDL statement for "REPOSRC "
2 ETP000                 DB-ROLLBACK()
2EETP334 08:16:50: error in DDL, nametab for "REPOSRC" not activated

Read more...

Environment

  • SAP HANA Platform, any revision
  • SUM - Software Update Manager
  • SAP Netweaver Application Server 7.40

Product

SAP HANA, platform edition all versions

Keywords

KBA , BC-DB-HDB-POR , DB Porting for SAP HANA , HAN-DB , SAP HANA Database , HAN-LM-UPG-SAP , Upgrade of SAP Systems on HANA , 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.