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

• 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.

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

SDRAFT_LOCK_EXP, VDRAFT_PROC_EXP, VDRAFT_LOCK_EXP, VDRAFT_CONFIG, views, SE14, recreate, drop, SQL249, SQL11021, SQL225, "sql error 225", SQL102, "Incorrect syntax" , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed