cancel
Showing results for 
Search instead for 
Did you mean: 

CRM Middleware - Queue Stuck: User is Locked/Doesn't Exist

Former Member
0 Kudos

Hello SAP Experts,

I'm facing the following issue in both our SAP CRM 5.0 and 7.0:

There are several Queues in SMQ1 and SMQ2 which display the following errors:

     - User is Locked: Please inform responsabile

     - User account no longer exists or is not valid

After checking with Security, the issue is that these users do not belong to the Company anymore or are locked for a particular reason (they already left the company and cannot be unlocked).

The queues affected by this problem are of this type:

CSABUPA*

CRM_BT_LRP*

WFM_CORE2PUBLISH

How could I process these Queues without unlocking these users? Is there a way to Change the Users under which these Queues are processed?

I've tried reading forums regarding this but I was unable to find any issue similar to mine.

I'll greatly appreciate any sort of tip.

Thanks.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

I already know what is the problem, basically users are locked.

Problem is I'd like to process these queues under a generic User ID, but I'm not familiar on how to do this.

Michael said something about going to SMQR-SMQS, do you know which steps should I take to perform suck task?

Former Member
0 Kudos

Hi Uriel,

We are facing the same problem as what you have described above. Queues are stucked because certain users are now no more with company and we are receiving an error "User account not in validity date".

I can see four queues in SMQ1 and all of them have status "SYSFAIL" with same error given above.

Did you find the resolution for your problem? If yes, could you please share it here? It would be really helpful.

Thank You,

Nilima

vijayalakshmi_r
Explorer
0 Kudos

Hi Nilima,

I'm not sure if this would work - but maybe you can try this:

In SMQS, click on the destination. This will open the RFC destination. Under the Logon & Security tab, you'll find a check box 'Current User'. Check this and save your changes.

When you reprocess the queues, you'll be asked to enter the current user's credentials. Once you enter this, the queue should then be processed successfully.

Regards,

Vijayalakshmi

Former Member
0 Kudos

Hi Nilima,

I haven't been able to solve this issue yet. I first thought about doing a debug and trying to alter the user on the go for those queues already stuck.

This is the piece of information I was given before:

I guess the RFC connection used for the replication (either in transaction SMOEAC in CRM or in table CRMRFCPAR in ECC) is not correctly configured in SM59. Normally you would use a RFC connection with a replication user assigned (SAP proposes user ALEREMOTE for this). If you setup your RFC this way, the replication will always be carried out using that user.

This is all I have so far, but I wasn't able to test it out since I don't have permission to make those modifications in the system.

Hope this helps.

Regards,

Uriel

Former Member
0 Kudos

Hi Uriel,

Thanks for your time.

Not sure if I understood correctly about the information which you gave me. Can you please elaborate bit more?  We are trying to load data from CRM to BW.

Also, in SMQ2 we see various user IDs. Is there a way by which we can have common user ID for all transactions?

When I further dig into SMW01, I can also see that some BDOCs are stucked with status I04 "BDoc stored before update task (intermediate state" and I am not sure if it affects consistency of data between CRM and BW.

Can you please help me understand how BDOCs displayed in SMW01 are related with my SMQ2 details? These concepts are very nnew to me and I am just trying to figure out the whole picture.

Thank you so much for your time.

Regards,

Nilima

0 Kudos

Hi Nilima,

whenever we are trying replicate any data to CRM , there are bdocs (tx- SMW01) generated for it . when you go to tx. SMW01 you can find out the tab name " queue name" actually this queue name is nothing but the queue responsible for transferring the data .. if you double click on any one of the queue name it will directly take you to the tx SMQ2 displaying the respective queue which you selected on the SMW01 screen. Hope it helps you .

Regards

Sumit Srivastava

Venkat_Sesha
Employee
Employee
0 Kudos

Hi Uriel,

Goto SMQ1 or SMQ2 whichever the first that trigger. I mean SMQ2 if data flows from ECC, SMQ1 for CRM.

Goto the respective Queue which you have stated above.

DB Click on the Queue. It shows a detail screen with Error.

Reprocess the queue. Now there is a option called Debug LUW.

Click on the Debug LUW on selecting the Queue.

this will trigger a Debugger session and now In the Debugger Menu Goto Break at Statement/Keyword.

Enter the keyword 'MESSAGE'. Now Press F8. it will stop at the error message. Do a Bottoms-Up Approach from there. This will resolve your Issue.

Hope this helps.

former_member188843
Participant
0 Kudos

one option, process the queue record with debug, change the user during debug. or change the return of check user.