Skip to Content
0
Oct 28, 2019 at 08:15 AM

PLAN OPERATION FAILED due to column store error

416 Views Last edit Oct 28, 2019 at 10:04 AM 5 rev

Dear Experts,

I am facing below error while refreshing tableau extracts using HANA

com.tableausoftware.nativeapi.dll.DataSourceException: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;2048 column store error: search table error: "_SYS_BIC"."pro-sp.production.software/SOFTWARE/proc": line 920 col 1 (at pos 45805): [2048] (range 3) :column store error: search table error: "_SYS_BIC"."pro-sp.production.software/SOFTWARE_C1/proc": line 56 col 1 (at pos 1670): [2048] (range 3) :column store error: search table error: [2620] executor: plan operation failed (please check lines: 165, 266, 362, 554, 621) (please check lines: 560, 596, 632, 677, 752, 920)

"_SYS_BIC"."pro-sp.production.software/SOFTWARE_C1/proc" calculation view is fetching Total 244,638 records and taking total exection memory approx 200 Gb

when we try to refresh dashboard two three times above error doesn't come and dashboard refreshed successfully .

tried to find out the exact field or expression but no luck.

I would appreciate if someone help me to fix this error .