topic Re: SQL code: 259" with the error text "SQL message: invalid table name: Could not find table/view in DevOps and System Administration Forum

SQL code: 259" with the error text "SQL message: invalid table name: Could not find table/view

former_member160102 — Tue, 25 Jan 2022 06:00:13 GMT

Hi,

i got the error during updatign the SAP BASIS Patch in HANA Database.

SQL code "SQL code: 259" with the error text "SQL message: invalid table name: Could not find table/view ACM_DDLSTBVIW_1R in schema

as per SAP note 2574962 - SAP FS-BA: Dump DBSQL_TABLE_UNKNOWN during Bank Analyzer processes running, i have executed the SAP_DROP_TMPTABLES for the '01' type tables.

But still same error is coming.

Re: SQL code: 259" with the error text "SQL message: invalid table name: Could not find table/view

S_Sriram — Tue, 25 Jan 2022 09:34:57 GMT

Hi Arif

Could you share the full error log

Regards

Re: SQL code: 259" with the error text "SQL message: invalid table name: Could not find table/view

former_member160102 — Tue, 25 Jan 2022 10:19:28 GMT

OS Level Log
3 EPU182 Post-processing for &2"PDWS" &3"77400627" was already performed success fully earlier&1"R3TR"

3 EPU182 Post-processing for &2"PDWS" &3"77400640" was already performed success fully earlier&1"R3TR"

3 EPU123 Post-import method "RH_ACTIVATE_WFOBJECT_AFTER_IMP" completed for "PDWS " "L", date and time: "20220125130554"

2 EPU122XPost-import method "SACMDT_AFTER_IMP_DCL" started for "DCLS" "L", date and time: "20220125130554"

A4 EACM_SYNTAX 100 &2"2022-01-25 06:05:54 UTC": Starting DCL AIM (user = &1"DDIC ")

A4 EACM_SYNTAX 122 &2"2022-01-25 06:05:54 UTC": Deleting ABAP artifacts for DCL &1"DEMO_CDS_ROLE_LITERAL" (&3"1"/&4"4")

1AETR012XProgram canceled (job "RDDEXECL", number "13055300")

1AEPU320 See job log"RDDEXECL""13055300""HDA"

1 ETP162 EXECUTION OF REPORTS AFTER PUT

1 ETP110 end date and time : "20220125130608"

1 ETP111 exit code : "12"

1 ETP199 ######################################

ST22 Error

Error analysis

In an SAP Open SQL statement, a table is specified that either does not

exist on the database, or that is not known to the ABAP Data

Dictionary.

This is table "ATOV_PK_ITEM_CONTI_JOIN", or another table which the statement

wants to

access. The database has returned SQL code "SQL code: 259" with the error text

"SQL message: invalid table name: Could not find table/view ATO_V_PK_CONTI in

schema SAPABAP1: line 1 col 95 (at pos 94)".

Re: SQL code: 259" with the error text "SQL message: invalid table name: Could not find table/view

former_member160102 — Tue, 25 Jan 2022 14:47:18 GMT

issue is resolved -

Error - SQL Code 259
Solution

Run the report – RUTDDLSACT
Put * in the DDL Source or View Names field

Execute in background.

second issue was - SQL Code 328

Solution
Follow - 2543179 - DBSQL_TABLE_UNKNOWN after clean installation of S/4 HANA
Run the report – RUTDDLSACT

Put ACM_DDLSTBVIW_1R in the DDL Source or View Names field

Execute RUTDDLSACT