EF Core 6 with Hana client 2.18 throw error "HanaException: 'invalid table name: sap.hana.uis.db"

[dennis_gimenez]

Tutorials: https://developers.sap.com/tutorials/hana-clients-entity-framework.html
--------------------------

Hello! I already do not have any ideas to find the solution.

The next error "Sap.Data.Hana.HanaException: 'invalid table name: sap.hana.uis.db/GET_WIDGET_DATA/tabletype/WIDGET_DATA_TABLE_TYPE: line 1 col 18 (at pos 17)'" throw when my application called the method Database.EnsureDeleted();

I am making all the steps on the tutorial but the result it's the same error again and again.

Can you show me any light? Please.

[michael_fleischer3]

I also failed at the tutorial, but after hours of analysis and reflection I was able to find a solution.
After I filled the value "CurrentSchema" in the ConnectionString accordingly, it worked.

https://github.com/sap-tutorials/Tutorials/issues/23474

[michael_fleischer3]

Have you found a solution?

I have also tried the tutorial and get the same error.
https://developers.sap.com/tutorials/hana-clients-entity-framework.html

From my point of view, the tables with the function "EnsureCreated" are not created.

[simon25]

Hi

This error suggests that the table name referenced here cannot be found or does not exist on the underlying schema "sap.hana.uis.db" in it's tenant Database :

"Sap.Data.Hana.HanaException: 'invalid table name: sap.hana.uis.db/GET_WIDGET_DATA/tabletype/WIDGET_DATA_TABLE_TYPE:"

The TABLES view can be checked in the sql console to verify it's existence.

Kind Regards

Simon

[dennis_gimenez]

Hi Simon.

Indeed, the table does not exist on the schema. Do you know why doesn't it exist?

Now, I need to know if the EF Core 6 with Hana is only for the Hana cloud platform.

My environment is on-premise.

Kind Regards