SAP Knowledge Base Article - Preview

3437651 - SAP DBTech JDBC: [7]: feature not supported: cannot modify table type of table having page loadable 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:

 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

SAP HANA, platform edition 2.0

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.