Symptom
- Lots of ST22 dump happen after DMIS 2011 (SLT 2.0) upgrade from SP12 to SP24. Typical ST22 dump is like following:
Category ABAP Programming Error
Runtime Errors DBIF_RSQL_TABLE_UNKNOWN
ABAP Program /1LT/SAPLSLD001000000003154
Application Component Not Assigned
Date and Time 02.06.2023 07:44:28
Error analysis
A table is referred to in an SAP Open SQL statement that either does not
exist or is unknown to the ABAP Data Dictionary.
The table involved is "/1CADMC/00000401" or another table accessed in the
statement.
- Dev trace file shows the problem query in DB side gets error 208 (table not found) as follows:
ERROR: -1 in function StartSelect (execute) [line 25186]
(208) [42000] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]READPAST not found. Specify ow
ner.objectname or use sp_help to check whether the object exists (sp_help may pr
oduce lots of output).
sql statement is ==> SELECT TOP 5000 * FROM "/1CADMC/00000401" ( INDEX [/1CADMC/00000401IU]) , "REA
DPAST" WHERE "IUUC_PROCESSED" = ? ORDER BY "IUUC_PROCESSED" ,"MANDT" ,"INFNR" ,"
IUUC_SEQUENCE"
/* R3:/1LT/SAPLSLD001000000003154:260 T:/1CADMC/00000401 M:300 *
- Checking in ASE DB, the involved table named "/1CADMC/*" (e.g "/1CADMC/00000401") exists in SID database with correct table owner (SAPSR3).
And table READPAST does not exist in DB which means error 208 is normal and expected.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite (BS)
- SAP Netweaver 7.31 SP9
Product
Keywords
DBIF_RSQL_TABLE_UNKNOWN, READPAST, /1CADMC/, IUUC_PROCESSED, /1LT/SAPLSLD, 208 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview