HANA - hierarchy view issues error [6991] Each predecessor (except the root node) must also appear as a successor

[Former Member]

Hi,

I am trying to execute HANA hierarchy view. But i am getting the following error.

Could not execute 'SELECT RESULT_NODE ROW_ID FROM ...' in 107 ms 833 µs .

SAP DBTech JDBC: [2048]: column store error: search table error:  [6991] Each predecessor (except the root node) must also appear as a successor.272092 272138 272140 272142 272144 272146 272148 272150 272152 272154 272156 272158 272160 272162 272164 272166 272168 272170 272172 272299 272347 272349 272351 272353 272355 272357 272359 272361 272363 272365 272367 272369 272371 272373 272375 272377 272379 272381

What would be the cause?

Thanks,

Suren.

[former_member185943]

Hi, Suren,

I had the same problem and I made some research on it, which resulted in this blog. I hope that it will help you too.

KR,

Igor