Symptom
Dump DBIF_PGNT_SQL_ERROR occurs as below:
Category Error in database interface
Runtime Errors DBIF_yoPGNT_SQL_ERROR
Date and Time <timestamp>
Short Text
SQL error 129 occurred when accessing structure description
"<DDIC_Type_Name>".
What happened?
Database error text: "transaction rolled back by an internal error: TrexUpdate
failed on table 'SAPHANADB:REPOSRC_ADM' with error: transaction rolled back
due to unavailable resource: max number of SqlExecutor threads are exceeded:
current=61, max=60 (checked twice recent 100 "
....
Database Interface Information
C E execute() of C_0834, #rec=0, rc=1, rcSQL=129 [/bas/775_REL/src/dbs/hdb/dbsdbsql.cpp#2202]
C E EXECUTE C_0834 on connection 0, rc=129 [/bas/775_REL/src/dbs/hdb/dbslsdb.cpp#10223]
C 1 SQLCODE : 129 [/bas/775_REL/src/dbs/hdb/dbsdbtrc.cpp#526]
C 1 SQLERRTEXT : transaction rolled back by an internal error: TrexUpdate failed on table 'SAPHANA
C 1 h error: transaction rolled back due to unavailable resource: max number of SqlEx
C 1 exceeded: current=61, max=60 (checked twice recent 100 msec), rc=74000002 - enfor
C 1 sc_p=7f6394b52430,no=834,idc_p=7f6394bd43c8,con=0,act=1,slen=180,smax=1536,#vars=7,stmt=7f6395
C 1 stmtid = <6/REPOSRC_ADM /17666/20190118035104> [/bas/775_REL/src/d
C 1 UPDATE "REPOSRC_ADM" SET "SDATE" = ? , "STIME" = ? WHERE "PROGNAME" = ? AND "R3STATE" = ? AND
C 1 ATE" < ? OR ( "SDATE" = ? AND "STIME" < ? ) ) WITH RANGE_RESTRICTION('CURRENT'); [/bas/775_RE
B 1 DBREPO: report table: 'REPOSRC ' [/bas/775_REL/src/krn/dbi/dbe
B 1 DBREPO: program: '<Program_Mame>' [/bas/775_REL/src/krn/dbi/dbeu/dbr
B 1 DBREPO: state: A, lang = *, mach = 0 [/bas/775_REL/src/krn/dbi/dbeu/dbrepo.c#4945]
B E ***LOG BY4=> sql error 129 performing UPD on table REPOSRC [dbrepo#4945]
B E ***LOG BY0=> transaction rolled back by an internal error: TrexUpdate failed on table 'SAPHANA
B 1 NTAB: note_modify: TOUCH_TAB_USERS (touch_mode = TOUCH_SAFE) for tabname: ISPURCHASECONTRACTIT
B 1 NTAB: db_repo_touch_tab_users returned 1 [/bas/775_REL/src/krn/dbi/dbi/dbntab.c#10043]
B 1 NTAB: db_pgntab(): NTPG_CLOSEPUT: pgname: ISPURCHASECONTRACTITEMWD2_D [/bas/775_REL
B 1 NTAB: NTPG_CLOSEPUT: note_modify failed, returning 1 [/bas/775_REL/src/krn/dbi/dbi/dbn
Read more...
Environment
NetWeaver based systems
Product
Keywords
DBIF_PGNT_SQL_ERROR, SQL error 129, Category Error in database interface, GENER* starting inline generation, deadlock, DDIC_TYPE_INCONSISTENCY, DDIC_TYPE_REF_ACCESS_ERROR, compile error during remote generation, deadlock , KBA , BC-DB-DBI , DB Independent Database Interface , BC-DWB-DIC-AC , ABAP Dictionary Activation and Conversion , 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.