Skip to Content
-2

Why the table or view could not be found?

Apr 11 at 05:51 PM

36

avatar image

Tried to execute a query for HANA ATRRIBUTE VIEW from SQL console on eclipse, the tenent database is on HANA Trial account.

The query is :

Select * from "_SYS_BIC"."pkg_sami/AT_CUSTOMER"

The message I get is :

Could not execute 'Select * from "_SYS_BIC"."pkg_sami/AT_CUSTOMER"'
SAP DBTech JDBC: [259]: invalid table name: Could not find table/view pkg_sami/AT_CUSTOMER in schema _SYS_BIC: line 1 col 26 (at pos 25)

The CUSTOMER table is on a schema I created.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Thomas Jung
Apr 12 at 02:15 PM
0

Its not saying that CUSTOMER table can't be found but that your view AT_CUSTOMER can't be found in _SYS_BIC. Are you are sure you are in the same tenant where you created this View? Are you sure its activated?

Share
10 |10000 characters needed characters left characters exceeded