SAP Knowledge Base Article - Preview

3405476 - [ASE Error SQL11060]This statement has exceeded the maximum number of recompilations (20) - SAP ASE for BS

Symptom

ERROR: -1 in function StartSelect (execute) [line 35353]
C (11060) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]This Statement has exceeded the maximum number of recompilations (20). This indicates an internal error. Please note the error prior to this one and contact SAP Technical Support.
C
C sql statement is ==> select str("DT"."SIDJDCALDAY",000008,'0') as "0CALDAY" , str("DT"."SIDJDCALMO C NTH",000006,'O') as "OCALMONTH" , str("DT"."SID_0CALQUARTER",000005,'O') as "0 C CALQUARTER" , str("DT"."SIDJDCALWEEK",000006,*0') as "OCALWEEK" , str("DT"."SID C JDCALYEAR",000004,'0') as "0CALYEAR" , "S3"."DBH_DBNA" as "0DBH_DBNA" , "S4"."
C DBH_DBREL" as "0DBH_DBREL" , "S5"."DBH_RH0ST" as "0DBH_RH0ST" , "S6"."HDB_APPL C I" as "0HDB_APPLI" , "S7"."HDB_APPSRC" as "0HDB_APPSRC" , "S8"."HDB_APUSER" a C s "0HDB_APUSER" , "S9"."HDB_CLIIP" as "0HDB_CLIIP" , "S10"."HDB_CLIPID" as "OH C DB_CLIPID" , "Sil"."HDB_LCKCMP" as "OHDB_LCKCMP" , "S12"."HDB_LCKWNA" as "OHDB C _LCKWNA" , "S13"."HDB_P0RT" as "OHDB_PORT" , "S14"."HDB_STHASH" as "OHDB.STHAS C H" , "S15"."HDB_STMTID" as "OHDB.STMTID" , "S16"."HDB_SVNA" as "OHDB.SVNA" , "
C S17"."HDB_THDET" as "OHDB_THDET" , "S18"."HDB_THMET" as "OHDB_THMET" , "S19"."
C HDB_THSTAT" as "OHDB_THSTAT" , "S20"."HDB_THTYP" as "OHDB_THTYP" , "S21"."SMD_
C AEC" as "0SMD_AEC" , "S22"."SMD_AEX" as "0SMD_AEX" , "S23"."SMD_AMEX" as "OSM C D_AMEX" , "S24"."SMD_ASID" as "0SMD_ASID" , "S25"."SMD_ATIM" as "0SMD_ATIM" ,

C transaction aborted by server C dbdssyb: DBSL99 SQL11060
C [ASE Error SQL11060]This statement has exceeded the maximum number of recompilations
B ***LQG BY2=> sql error 11Q6Q performing OPC [dbds    451]    
B ***LOG BY0=> [ASE Error S0L11060]This statement has exceeded the maximum number of re
C    DbSlExeModify    after    transaction    was    aborted:    only    rollback    permitted
C    DbSlEndModify    after    transaction    was    aborted:    only    rollback    permitted
B ***LOG BY4=> sql error 0    performing MOD on table BALDAT [dbdbslst 5138]
B ***LOG BY0=> <message text not available> [dbdbslst 5138]
C    DbSlExeModify    after    transaction    was    aborted:    only    rollback    permitted
C    DbSlEndModify    after    transaction    was    aborted:    only    rollback    permitted


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP NetWeaver (NW) - All versions
  • SAP Solution Manager (SOLMAN) 7.2

Keywords

CR#752991, CR752991, 752991 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BW-SYS-DB-SYB , BW 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.