Issue with Update of Table VARINUM

[former_member195698]

Hi,

I am getting waiting Issues with Update of table VARINUM. Has anybody faced such an issue.

I have a lot of Jobs which are running in background. I am submitting it through a report. what can be the issue.

Regards,

Abhishek jolly

[Former Member]

If each of the jobs is updating the table, they could be waiting for locks to release.

Rob

[former_member195698]

There is no locking on the table VARINUM by SAP. The system goes into Waiting forever and it timesout after sometime.

[naimesh_patel]

May be your update processes are not free. Check in the SM51.

Regards,

Naimesh Patel

[former_member195698]

I am having issue in the production system where a lot of processes are going on.

Its only the table VARINUM that is having issues with Update.

Regards,

Abhishek

[Former Member]

Can you post the update code? Is it doing a SELECT SINGLE FOR UPDATE?

Rob

[former_member195698]

There are only around 300 entries in the table VARINUM. The code below is having issues.

varinum-numid = 'VJ'.

varinum-report = progname.

update varinum set vnumber = vnumber + 1

where numid = varinum-numid

and report = varinum-report.

There are a lot of jobs submitted through BAPI in Background which try to update this table. Because of concurrency of the No of Processes trying to udpate VARINUM the update goes into a long wait..

[naimesh_patel]

Can you try with this?

arinum-numid = 'VJ'.
varinum-report = progname.
l_vnumber = vnmumber + 1.

update varinum set vnumber = l_vnumber  " <<
where numid = varinum-numid
and report = varinum-report.

Regards,

Naimesh Patel

[former_member195698]

Hi,

Its part of Standard Sap report. is there any SAP Note for this or anything that can be done from the Basis side

[Former Member]

Hard to tell - what program/transaction is it?

Rob

[former_member195698]

RSDBSPJS program is being called.

Regards,

Abhishek

[former_member195698]

raised with SAP

[MarcelloUrbani]

Thisi is quite old, but not answered properly yet, so there you go:

SAP generates a new job and temporary variant on report RSDBSPJS, for each HTTP call,which creates database locks on table VARINUM .

This causes any heavyweight BSP application  to hang and give timeout errors.

The problem is fixed applying OSS note 1791958, which is not included in any service pack.