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:
error: ALTER TABLE "SAPABAP1"."PLMM_AUDIT_SYS" ALTER TYPE COLUMN
2WETP000 12:42:38: Retcode 1: error in DDL statement for "PLMM_AUDIT_SYS" - repeat
3 ETP355 executed ( "0:00:12 (12.022910 sec)" )
2EETP345 12:42:50: Retcode 1: SQL-error "7-feature not supported: cannot modify type of column table
2EETP345 es to column" in DDL statement for "PLMM_AUDIT_SYS"
After following the KBA 2153042 the error below is reported :
Could not execute 'ALTER TABLE "SAPABAP1"."PLMM_AUDIT_SYS" ALTER TYPE ROW'
SAP DBTech JDBC: [7]: feature not supported: cannot modify table type of table having page loadable column: $trexexternalkey$: line 1 col 24 (at pos 23)
Read more...
Environment
- SAP HANA Platform
- SAP Netweaver Application Server 7.5
Product
Keywords
table having page loadable column, inconsistent, ABAP Runtime, Database object , KBA , BC-DB-HDB-POR , Dictionary & Consistency checks for SAP HANA , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.