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.
SAP Knowledge Base Article - Preview