cancel
Showing results for 
Search instead for 
Did you mean: 

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

dennis_gimenez
Explorer
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

simon25
Advisor
Advisor
0 Kudos

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
Explorer
0 Kudos

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