HANA Studio error: Cannot get the data provider outline

[Former Member]

Hi Experts,

In HANA Studio we are getting the error Cannot get the data provider outline:

"SAP DBTech JDBC: [2048[: column store error: search table error: [2620] executor: plan operation failed"

Attached is the screenshot of the error we are getting in HANA studio when trying to Data Preview a calculation view.

Details on the issue:

Analytical View works fine

Calculation View "A" works fine (contain some text description manipulation from different tables)

Calculation View "B" which joins the Analytical View and Calc View "A" results in error

Most of the results online refer to a currency decimal error but does not apply to our scenario. Anyone have any thoughts on this? Help would be greatly appreciated. Points will be awarded to the correct answer as well as helpful posts.

Thank you in advance.

[Former Member]

Hi,

There is a known bug in HANA that causes SQL queries to return with errors when the statistics server has no more memory to Optimize and Plan the Operations. SAP has fixed this issue with HANA Revision 74, until then raising the allocation limit or truncating large statistics tables in _SYS_STATISTICS schema should solve the problem.

Try accordingly.

-Pp

[former_member208919]

Hi,

Can you please check in the sematics of your calculation view, If you are running it in SQL engine please change it to default engine (blank). It might work.

If it doesn't work can you please show the screenshot of your design of your calculation view ?

-

Subhash

[former_member226419]

Can you please share bit more with screenshots what you are trying in all 3 views?

Information is insufficient to solve the issue.

[former_member270797]

Hello Efraim,

can you please check the related indexserver trace entry? There we should get some more information.

Best regards.

Moritz