Ansicht
Dokumentation

03381 - SQL904 - DBIF_RSQL_SQL_ERROR - Resource Limit Exceeded RC7

03381 - SQL904 - DBIF_RSQL_SQL_ERROR - Resource Limit Exceeded RC7

TXBHW - Original Tax Base Amount in Local Currency   Vendor Master (General Section)  
This documentation is copyright by SAP AG.
SAP E-Book

SQL904 - DBIF_RSQL_SQL_ERROR - Resource Limit Exceeded RC7

Hi Doreen,

I checked with a DBSL-developer from our site and he confirmed that this
shouldn't occur in V4R5 since about beginning of this year. As you are
current with the PTFs, this should be a DB-problem.
So I would please ask you to open a PMR for this issue at IBM so that they
know about this issue and can perhaps give some ideas for the next occurence
what to do, perhaps doing a SAVOBJ of the big package.

Regards

Volker

> -----Original Message-----
> From: Anderson, Doreen [mailto:DAndersoZb...]
> Sent: Mittwoch, 10. Oktober 2001 00:19
> To: Gueldenpfennig, Volker
> Cc: Sap400 (E-mail)
> Subject: RE: 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

General Data in Customer Master   General Material Data  
This documentation is copyright by SAP AG.

Length: 4995 Date: 20240328 Time: 200458     sap01-206 ( 3 ms )