Application Server gets stuck

[Former Member]

Hi!

Since nearly two weeks we now have a problem with one of our Application servers.

Twice a day (always nearly at the same time) all processes are used by wf-batch user and the programs SAPLSNR3 and RK2ANK01. SAPLSNR3 with direct read to table NRIV. Itu2019s not possible to work with that Applicationserver, cause you get no free DIA-WP. In the DIA-Queue the queued entries grow up to 500 and more entries.

Sometimes the server gets rid of the queued dialog processes (in that case it wonu2019t grow up that muchu2026) but in most cases we have to restart the Applicationserver. After restarting the Server work goes on without problems. The other Applicationservers and the DB-server are running fine in the meanwhile.

We now tried to find any job which would explain that, but wasnu2019t lucky with that and have no idea what to do now.

Any suggestions where I could have a closer look?

Perhaps anybody can give me a hint how to monitor the Workflow to get an clue what the system is doing at that moment?

The System is an ECC6.0-System running on W2k3 64bit with Oracle 10.2. Only ABAP-Stack.

Br

Alex

[mercedes_fernandez · Accepted solution]

Hello Alex,

the NRIV table is the number range table.

You would need to identify the object and application producing the lock on NRIV that is holding the rest.

At the time of the problem in transaction DB01 you could see the process locking the rest, with double click in that record you could see the number range object that is being accesed.

SAP Notes 572905 describes different that could cause this.

kind regards,

Mercedes

[Former Member]

Just thought I should close this one - there want be anything helpfull anymore.

Two things:

• first of all we changed a lot of parameters (we didn't use our Hardware as we could - that helped )

• There seemd to be a problem during IDOC transfer from other SAP-ECC System into our System. We couldn't finds the error but it was possible to fix the problem by setting up a queue for that documents

To be honest - the performance improvements by changing the parameters nearly solved the problem. The queue just helps to get over the spikes which would kill the system...

br

Alex

[Former Member]

Hi,

NRIV is number range table getting the intervals buffered from DB. This could lead to problems especially when the system try to get the range during business hours.

Please check the Note 408099 - "Wait situation on NRIV with semaphores 8 and WAIT NUM" and sub notes specified there.

Regards,

Sitarama.