Skip to Content
avatar image
-2
Former Member

Why the table or view could not be found?

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 12 at 02:15 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded