Symptom
- You are trying to capture a Planviz for a SQL that has an internal table involved as below:
- SELECT /* FDA WRITE */ DISTINCT "EKPO" . "EBELN" , "EKPO" . "EBELP" , .... ? AS "t_00" ("C_0" NVARCHAR(18)) WHERE "EKPO" . "MANDT" = ? AND "EKPO" .
- You are following SAP Note 2971464 - Script HANA_SQL_StatementHash_SQLText / HANA_SQL_StatementHash_DataCollector output question mark "?" instead of real value to get the bind values.
- Although bind values are captured, the first bind parameter appears as an internal table, for example:
SYS:_SYS_PARAM_ITAB_0x00007bf5893a4d80_0x00007e741717ddf0
Read more...
Environment
- HANA database platform 1.0
- HANA database platform 2.0
Product
SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0
Keywords
BIND_VALUES, planviz, SYS:_SYS_PARAM_ITAB, "t_00", Datacollector, internal table, ITAB , KBA , HAN-DB , SAP HANA Database , HAN-DB-PERF , SAP HANA Database Performance , How To
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.
SAP Knowledge Base Article - Preview