SAP Knowledge Base Article - Preview

2765810 - DUMP DBIF_PGNT_SQL_ERROR in ST22

Symptom

Dump DBIF_PGNT_SQL_ERROR occurs as below:

Category Error in database interface
Runtime Errors DBIF_PGNT_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

SAP NetWeaver all versions

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 , Activation Prog., Conversion Prog., DB-Utility, MC, SPDD , Problem

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.