Skip to Content

SAP HANA Calculation View - Phantom element

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!


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 21, 2017 at 03:37 PM

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

    Add comment
    10|10000 characters needed characters exceeded