topic Catch DBSQL_TABLE_UNKNOWN in Application Development and Automation Discussions

Catch DBSQL_TABLE_UNKNOWN

former_member309012 — Mon, 13 Jul 2020 09:55:22 GMT

We have a secondary database connected, using tc DBCO. Read access is set up and works fine.

We use some dynamic SELECT on different table names, where P_DBCON is the secondary database.

Example

*- Secondary database

TRY.
SELECT COUNT( * ) FROM (lv_tabname)
CONNECTION (p_dbcon).
CATCH cx_sy_dynamic_osql_semantics.
MESSAGE ….
ENDTRY.

Problems occur, if an invalid table-name is specified in LV_TABNAME. The system does note raise a catchable exception CX_SY_DYNAMIC_OSQL_SEMANTICS. Instead it creates a runtime error DBSQL_TABLE_UNKNOWN.

Is there a way to determine, whether table LV_TABNAME exists in the secondary db? Note that there is no metadata (e.g. a table DD02L) to access to find out.
Or is there any way to catch this scenario, so it won’t result in a dump?

Thank you in advance, Ulrich

Re: Catch DBSQL_TABLE_UNKNOWN

Sandra_Rossi — Mon, 13 Jul 2020 11:12:54 GMT

Are you sure that ABAP doesn't catch that, did you try with CATCH cx_root? Check SAP notes or contact SAP support to make sure that it's not just a bug.

By the way, the ABAP documentation says:

The database tables or views specified in the current ABAP SQL statement 
must be active in ABAP Dictionary in the current AS ABAP regardless of the
specified database connection. In a secondary database, an identically 
named and usable object with a suitable structure must exist for each 
database table or view specified in the current ABAP SQL statement. If not,
an exception is raised.

Re: Catch DBSQL_TABLE_UNKNOWN

former_member309012 — Tue, 14 Jul 2020 06:45:32 GMT

Hi Sandra,

yes, I tried to Catch w/ different exception classes, starting from CX_SY_DYNAMIC_OSQL_SEMANTICS (which Catchs on a primary db) and going up the class-tree to CX_ROOT. It still dumps 😕

The requirements named in the ABAP documentation are fulfilled: The secondary db is a subset of the primary db.

Re: Catch DBSQL_TABLE_UNKNOWN

Sandra_Rossi — Tue, 14 Jul 2020 08:36:15 GMT

Please use COMMENT, the button ANSWER is reserved to propose a solution.

Re: Catch DBSQL_TABLE_UNKNOWN

former_member747610 — Tue, 28 Jun 2022 19:37:26 GMT

Hi Ulrich,

Were you able to resolve? I am encountering same issue and I too have tried with CATCH but nothing is being captured.

Re: Catch DBSQL_TABLE_UNKNOWN

ThorstenHoefer — Wed, 29 Jun 2022 06:02:30 GMT

For dynamic sql, it is always a good choice to use class cl_abap_dyn_prg.

You can check the table name with the function

DDIF_NAMETAB_GET or DD_GET_NAMETAB_HEADER

In case your database system for your connection is HANA,

you can check the table name with the systemview tables:

select * from tables

Regards

Thorsten