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.