SMQR Scheduler Status in WAIT and SMQ2 Queue Size increases.

[Former Member]

Hi,

We are Facing the following problem when new Materials are automatically transferred from SAP R/3 ECC to SAP CRM.

a.Status of the System:

1.In SMQ2 all the Materials are blocked with Ready Status,

2.In SMQR the Scheduler Status is in WAIT status.

3.In SM50 there are dialog with status Waiting and Error is filled in for waiting status.

4.In SMW01 there are BDOC error for the Product_mat.

5.No dumps in ST22.

b.Problem:

1.The New materials are transferred to CRM. All the New Material group are not downloaded to CRM and this was observed when the Materials in the Queue was manually processed :Error given out was "Category for the Material Group xxxxx does not exist".

2.As lots of materials are blocked in the Queue and as the scheduler status is in WAIT status, no data is now getting transferred to CRM from R/3

c.Analysis.

1.Downloaded the Customizing object: DNL_CUST_PROD1(product categories) to copy all the new material group from R/3 to CRM.

2.The download of the object ended in WAIT status(red).

3.Restarted the Queue and again downloaded , but still the objects shows in Wait status in R3am1.

Solution Required:

1.What needs to be done to make the Scheduler status to act or inactv.

2.What will be solution to make the downloaded object DNL_CUST_PROD1 successful.

Will this solution work out:

1. If all the queue entries removed from queue and download the object.

Please suggest how to solve this issue.

[rohit_sharma2]

Hello Suvarna,

First of all you would need to ensure DNL_CUST_PROD1 is downloaded fully.

If every initial load of DNL_CUST_PROD1 goes to a WAIT state in R3AM1 my guess is it is not getting enough work processes to execute itself.

Solution:

Just go to table SMOFPARSFA in CRM and search for the variable MAX_PARALLEL_PROCESSES

. Keep its value as 10 or 15. This just signifies how many Initial+Request+DIMA loads can be started in parallel from CRM. IF you have enoguh dialog work processes avaialble, keeping this value as 15 wil do no harm.

Next to solve the Inbound queue scheduler issue, just goto SMQR, select all the queues And deregister them in 1 shot. Then wait for about 10 seconds, select all queues and then Register them. This way the queue scheduler would restart and start processgin the inbound queues.

You can try the same thing out for Transaction SMQS as well.

Let me know if this solves your issues.

Regard,s

Rohit

[Former Member]

Hi Rohit .Thanks for your reply.

I also understand for the WAIT Status of the DNL_CUST_PROD1 is due to the non availability of the work process. This is because the Scheduler status in SMQR is in WAIT.

As suggested I will follow these steps.

In table SMOFPARSFA  Increase the Work process MAX_PARALLEL_PROCESSES value to 15.

In SMQR, Deregister all the queues ,after 10 seconds Register them.

Please let me know Can all the Queue entries in SMQ2 can be deleted. As all the data from R/3 are getting blocked in CRM with the ready status in SMQ2. At which step the deletion needs to be carried out.

Thanks again for your valuable inputs . I will implement the above solutions and keep you updated.

[rohit_sharma2]

Hello Suwarna,

You don't need to delete those SMQ2 queues in READY state. Just restart the SMQR(as I had explained) and see if these queues start getting picked up automatically.

The initial load of DNL_CUST_PROD1 would start after the MAX_PARALLEL_PROCESSES value change.

These 2 issues are not inter-related.