Ansicht
Dokumentation

03378 - SQL904 - DBIF_RSQL_SQL_ERROR - Resource Limit Exceeded

03378 - SQL904 - DBIF_RSQL_SQL_ERROR - Resource Limit Exceeded

Fill RESBD Structure from EBP Component Structure   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.
SAP E-Book

SQL904 - DBIF_RSQL_SQL_ERROR - Resource Limit Exceeded

Volker....I found the information in the dev trace.old

Take a peek.....it is reason code 7

We are 4.6C / 4.6D kernel patch lvl 706
O/S V4R5; cume lvl C01198; dbfix=09
compliant with IBM apar as of mid August

C Sat Oct 6 22:08:56 2001
C *** ERROR => Error -904 in function prep_cached_op
[dbsldb4.cpp 6413]
C Library name: R3P01X0000
C Package name: ZMATP
C Statement name: "IDCKNKCBJDMFKOBM"
C Failing statement is:
C , UPDATE R3P01DATA/"ZMATP" SET "FXHOR" = ? , "PLAN_WEEK" = ? WHERE
"MANDT" = ? AND "SPART" IN ( ? , ? , ? , ? ) AND "WERKS" = ? AND "VKORG" = ?
C *** ERROR => SQL error -904 with reason code 7
[dbsldb4.cpp 3945]
B ***LOG BY4=> sql error -904 performing PRE on table ZMATP [dbtran
6980 ]
B ***LOG BY0=> Resource limit exceeded. Job=010673/QUSER/QXDARECVR [dbtran
6980 ]
B dbtran ERROR LOG (hdl_dbsl_error): DbSl 'PRE'
B FHDR: {tab='ZMATP ', fcode=146, mode=2, bpb=0,
dbcnt=0, crsr=0,
B hold=0, keep=1, xfer=0, pkg=0, upto=0, init:b=0,
B init:p=00000000000000000000000000000000, init:#=0,
wa:p=00000000000000000000000000000000, wa:#=0}
B dbtran ERROR LOG (hdl_dbsl_error): DbSl 'PRE'
B STMT: {stmt:#=1, bndfld:#=7, prop=0x1, distinct=0, select*=0,
B fld:#=0, alias:p=00000000000000000000000000000000, fupd:#=0,
tab:#=1,where:#=8,
B groupby:#=0, having:#=0, order:#=0, primary=0, hint:#=0}
B CRSR: {tab='', id=0, hold=0, prop=0x1000, max.inZ0=4, fae:blk=0,
B con:nm='R/3', con:id=0, con:vndr=2, val=2,
B key:1=0, key:#=4, xfer=0, xin:#=0, xout:#=0, upto=0,
B wa:p=8000000000000000C8E89C116B4B7B30,
init:p=00000000000000000000000000000000, init:#=0, init:b=0}
M ***LOG R68=> ThIRollBack, roll back () [thxxhead.c 10274]
A Sat Oct 6 22:08:57 2001
A Sat Oct 6 22:08:57 2001(tm)ABAP/4 Program ZCLRZMATP
A Source ZCLRZMATP Line 20.
A Error Code DBIF_RSQL_SQL_ERROR.
A Module $Id: //bas/46D/src/krn/runt/absapsql.c#10 $ SAP.
A Function ExecuteCall Line 5752.
A SQL error -904 occurred when accessing table ZMATP

Doreen Anderson
Operations / SAP Basis Manager
Ball Horticultural Company
630-588-3214
dandersoZb...

-----Original Message-----
From: Gueldenpfennig, Volker [mailto:volker.gueldenpfennigZs...]
Sent: Tuesday, October 09, 2001 12:13 AM
To: 'dandersoZb...'
Cc: Sap400 (E-mail)
Subject: RE: SQL904 - DBIF_RSQL_SQL_ERROR - Resource
Limit Exceeded


Hi Doreen,

are you really sure, that you are observing here SQL0904 with the reason
code 7 ?
Since V4R5 and PTFs around january the system should itself supersede "old"
SQL-Packs, so that the 512 MB SQL-Packs can no longer overflow.

Regards

Volker

Durban Tours - Südafrika Safari

Fill RESBD Structure from EBP Component Structure   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by SAP AG.

Length: 3569 Date: 20240328 Time: 193227     sap01-206 ( 2 ms )