Symptom
You are upgrading your NetWeaver on HANA system with SUM and in phase PREP_SPACECALC/TR_GET_SPCREQ_ADD it is aborting with the following error (e.g.: in logfile SAPup.ECO):
ERROR: Statement: SELECT TABLE_NAME FROM TABLES WHERE SCHEMA_NAME =
CURRENT_SCHEMA ORDER BY TABLE_NAME
ERROR: SQL ERROR 7:
ERROR: Statement: SELECT TABLE_NAME FROM TABLES WHERE SCHEMA_NAME =
CURRENT_SCHEMA ORDER BY TABLE_NAME
ERROR: ERROR 256: invalid statement handle
ERROR: SQL ERROR 7:
If you manually execute SQL-statement
SELECT TABLE_NAME FROM TABLES WHERE SCHEMA_NAME = CURRENT_SCHEMA ORDER BY TABLE_NAME
in the HANA Studio SQL Editor the following error occurs:
Could not execute 'SELECT TABLE_NAME FROM TABLES WHERE SCHEMA_NAME = CURRENT_SCHEMA ORDER BY TABLE_NAME'
SAP DBTech JDBC: [7] (at 23): feature not supported: cannot select user-defined type: line 1 col 24 (at pos 23)
Read more...
Keywords
CRM, update, SQL error 256 , 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.