Error Implementing HANA SDI flowgraph task partitioning

[sumitbajaj599]

Has anyone worked on SDI flowgraph task partitioning in HANA 1.0 SP12. we are using calculation view which has current_date as input parameter $$IP_DELTA_TIMESTAMP$$. We are using this input parameter in flowgraph to pass value. When we try to execute flowgraph without partitioning it runs fine while when we apply partitioning it throws below error.

Instantiation of calculation model failed;exception 306106: Undefined variable: $$IP_DELTA_TIMESTAMP$$. Variable is marked as required but not set in the query (please check lines: )

[werner_daehn]

Very likely a bug. Yes, I use the exact same version of Hana and many tables are partitioned.

It sounds to me as if the partitioned reader does not pass the variable value into the calcview into all select clauses. An oversight in SDI development.

You can proof that by creating a view calling your calcview and providing a constant value for the parameter. Then use this new view as the actual source of the partitioned reader. I bet it will work. Obviously not a solution for you use case but a proof point for SAP support where the problem is.

If you are lucky they will tell that it is a known issue and solved in Hana 2.0. If they don't respond like that, ask them to validate with newer versions.