Skip to Content
0

SAP HANA Calculation View - Phantom element

Dec 20, 2017 at 06:08 PM

60

avatar image
Former Member

Hi Gurus,

I have a Graphical Calculation View that has an inspiegable behavior.

I removed a member from a Union node, the generated SQL query seems correct but an error occur: "Could not execute 'SELECT "SOURCE", "CURTYPE", "RECTYPE", "COMP_CODE", "FISCVARNT", "FISCPER", "BILL_NUM", ...' in 40 ms 764 µs . SAP DBTech JDBC: [2048]: column store error: search table error: [34023] Instantiation of calculation model failed;exception 306105: Invalid query. Failed to find 'VERSION' at node 'PLAN_Aggr'"

First, the field VERSION exists in node "PLAN_Aggr", second this node is part of a Calculation View that is not present in the one that generates the error, third in the older version of CV the field VERSION was anyway not part of the union node: why the system search it?

It seems that there is a "phantom node" that the system can't delete.

Any idea to solve this problem?

Best regards and thanks in advance!

Dario

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Dec 21, 2017 at 03:37 PM
0

Solved deleting the block and reactivating the CV as first step; recreating and reactivating again the CV all is right.

Share
10 |10000 characters needed characters left characters exceeded