SAP Knowledge Base Article - Preview

3581896 - ALTER TYPE ROW SQL-error "7-feature not supported: cannot modify table type of table having page loadable column: <column_name>" during SUM

Symptom

The Software Update Manager (SUM) stops with an error at phase MAIN_SWITCH/PARMVNT_BAS_TABS. The error log indicates a SQL-error "7-feature not supported: cannot modify table type of table having page loadable column". The issue occurs when SUM attempts to alter the table type from column to row, which results in a failure.

ALTER TABLE "<schema_name>"."<table_name>" ALTER TYPE ROW
18:02:40: Retcode 1: error in DDL statement for "<table>" - repeat
executed ( "0:00:12 (12.016662 sec)" )
18:02:52: Retcode 1: SQL-error "7-feature not supported: cannot modify table type of table
having page loadable column: <column_name>: line 1 col 25 (at pos 24)" in DDL statement for "<table_name>" 


" during SUM"> Read more...

Environment

SAP HANA Database 2.0

Keywords

SUM, upgrade, SQL-error, 7-feature not supported, cannot modify table type, ALTER TABLE, load unit, column, row, ABAP platform, MAIN_SWITCH, PARMVNT_BAS_TABS. , KBA , HAN-DB , SAP HANA Database , 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.