Symptom
Upgrade to SP12, resulted in following error message when calling a procedure that uses a temporary table:
{"result":"dberror($.hdb.Connection.executeProcedure): 259 - SQL error, server error code: 259. invalid table name: search table error: \"<Default Schema Name>\".\<Procedure Name>\": line 680 col 1 (at pos 40991): [259] (range 3) invalid table name exception: invalid table name: Could not find table/view <#Temporary Table Name>in schema <Schema Name>: line 1 col 152 (at pos 151) (please check lines: 680) at /<path to workspace>/WorkspaceName_fa~hana1sp12/s/ptime/query/plan_executor/trex_wrapper/trex_wrapper_body/trex_query.cc:1330"}
Read more...
Environment
SAP HANA 1.0 SP 12
Product
Keywords
HANA 1.0, temp, table, not found, fail, error, SP12 , 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.