on 05-11-2010 6:31 AM
Hi Guys, since the kernel upgrade the system has been having a huge number of dumps & the performance has gone down drastically. did some checking on SM50 & DB01, i can see so many locks on the NRIV table.
Has anyone come across this issue before ?
Thanks in advance
Chris
Termination occurred in the ABAP program "SAPLSNR3" - in "READ_NRIV".
The main program was "RBDAPP01 ".
In the source code you have the termination point in line 245
of the (Include) program "LSNR3F01".
The program "SAPLSNR3" was started as a background job.
Job Name....... "Z_AUTOBILL"
Job Initiator.. "BATCHADM"
Job Number..... 15174905
The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in
procedure "READ_NRIV" "(FORM)", but it was neither handled locally nor declared
in the RAISING clause of its signature.
The procedure is in program "SAPLSNR3 "; its source code begins in line
240 of the (Include program "LSNR3F01 ".
>>>>> SELECT SINGLE FOR UPDATE * FROM NRIV WHERE
246 OBJECT = P_OBJECT
247 AND SUBOBJECT = P_SUBOBJECT
248 AND NRRANGENR = P_NR_RANGE_NR
249 AND TOYEAR = '0000'.
Solved by SAP OSS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
First thing.. SAP asked us to reduce the frequency of the job that was causing the dumps... from 1 min... to every 7mins....
Check note 1453114
restart this morning with the active parameter dbs/db4/connect_type = L has solved the poor database response time that was contributing to system slowness.
The Machine Pool has been increased
Hi Chris,
unfortunately, this is "normal" and a typical application issue.
NRIV is "THE" number buffering table. If you do have locks there, you have to investigate the currently running and failing applications. One of them will not work properly with the number rage table.
Perhaps, it might be an option, to buffer the table for the "row in problem" - but this needs to be discussed with the application people, because sometimes, this is forbidden.
Regards
Volker Gueldenpfennig, consolut international ag
http://www.consolut.net - http://www.4soi.de - http://www.easymarketplace.de
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.