SAP Knowledge Base Article - Preview

3342375 - ST22 Dump DBIF_RSQL_TABLE_UNKNOWN occurs after DMIS (SLT 2.0) upgrade - SAP ASE for Business Suite

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

SAP Adaptive Server Enterprise 16.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3

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.