SAP Knowledge Base Article - Preview

2738592 - ASE errors 11021, 249, 225, 102 on SDRAFT_LOCK_EXP - SAP ASE for Business Suite

Symptom

  • One or more of the following errors appear in the SM21 system log every few minutes on SAP ASE systems:
     
    • sql error 225 performing PRE on table SDRAFT_LOCK_EXP [dbdbslst 5137]
      [ASE Error SQL225][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Cannot run query referenced object (name NAME NOT RECOVERABLE) dropped during query optimization.
       
    • Database error 11021 with OPC access to table SDRAFT_PROC_EXP
      [ASE Error SQL11021][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Function VDRAFT_PROC_EXP invoked with wrong number type of argument(s).#
       
    • [ASE Error SQL249][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Syntax error during implicit conversion of VARCHA value 'decimal' to a DECIMAL field.#
       
    • [ASE Error SQL102:42000][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Incorrect syntax near '('.
       
  •  The work process trace shows the affected query:

C ERROR: -1 in function StartSelect (execute) [line 29841]
C (11021) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Function VDRAFT_LOCK_EXP invok
C ed with wrong number or type of argument(s).
C
C sql statement is ==> SELECT "CLIENT" ,"DRAFT_ENTITY" ,"DRAFT_KEY" ,"PRINCIPAL_DRAFT_ENTITY" ,"PRINCIP
C AL_DRAFT_KEY" ,"CREATED_AT" ,"CREATED_BY" ,"LAST_CHANGED_AT" ,"LAST_CHANGED_BY"
C ,"ACTIVE_DOCUMENT_ETAG" ,"ACCESS_TYPE" ,"IN_PROCESS_BY" ,"IN_PROCESS_SINCE" ,"KE
C PT_BY_USER" ,"ENQUEUE_CONTEXT" ,"ENQUEUE_SINCE" FROM /* Entity name: SDRAFT_LOCK
C _EXP */ "VDRAFT_LOCK_EXP" ( ? , ? , ? ) "SDRAFT_LOCK_EXP" WHERE "CLIENT" >= ? AN
C D "DRAFT_ENTITY" >= ? AND "DRAFT_KEY" > ? ORDER BY "SDRAFT_LOCK_EXP" ."CLIENT" ,
C "SDRAFT_LOCK_EXP" ."DRAFT_ENTITY" ,"SDRAFT_LOCK_EXP" ."DRAFT_KEY" ROWS LIMIT ?
C
C /* R3:CL_DRAFT_LOCK_EXP_HANDLER=====CP:196 T:VDRAFT_LOCK_EXP M:000 */
C

  • t-code SE11 reports the dependent objects as consistent in the DDIC and the database - Views: VDRAFT_LOCK_EXP, VDRAFT_CONFIG and Tables: SDRAFT_ADMIN, SDRAFT_LC_CONFIG
  • There are no corresponding errors in the SAP ASE errorlog.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03
  • SAP NetWeaver 7.51, 7.52
  • AS ABAP 7.52 FOR S/4HANA FES

Product

SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver Application Server for ABAP 7.52

Keywords

SDRAFT_LOCK_EXP, view, SE14, recreate, drop, CR815832, CR#815832, 815832, in-lined, table-valued, UDF, user-defined, TUDF, inline, in-line , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.