KB40920: Warehouse and Metadata Partitioning is not supported in SAP HANA 1.0 SP2

SYMPTOM:
When running a report that uses partition tables in SAP HANA 1.0, the report errors out with the following error:

The following error occurs in pass             19:          Execute Query failed.
Error type: Odbc error. Odbc operation attempted: SQLExecDirect. General error;259 invalid table name:  Could not find table/view MD_PMT_INVENTORY in schema MSTRTUTO: line 6 col 6 (at Connection String: SERVERNODE=xxxxxxxx:xxx;DSN=HANA TUTORIAL;UID=xxxxxxxx;. SQL Statement: insert into #T3VSTDVGXPO003

select    a12.QUARTER_ID  QUARTER_ID,

                a11.MONTH_ID  MONTH_ID,

                sum(a11.EOH_QTY)  WJXBFS1,

                sum(a11.BOH_QTY)  WJXBFS2

from      "MD_PMT_INVENTORY"             a11

                join        "Strategy_TUTORIAL"."LU_MONTH"    a12

                  on         (a11.MONTH_ID = a12.MONTH_ID)

group by              a12.QUARTER_ID,

                a11.MONTH_ID.

 

 
CAUSE:
This is a known issue with Strategy 9.3.0 and SAP HANA 1.0 SP2
In Warehouse and Metadata partition mapping, there is a table that contains a table name and an attribute element that defines the data contained in that table. When the SQL executes, the first query is against that table that contains the partitions and their "definitions", the subsequent queries are against the tables that contain data. In SAP HANA the subsequent queries are done against the first table, not the ones that contain the actual data.
 
ACTION:
Strategy will continue to investigate and post updates as soon as they are available.
 
Third Party Software Installation WARNING
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.