on 05-07-2012 1:55 PM
Hi Forum,
We are trying to do initial load of object DNL_CUST_BASIS3 but the table CRMATAB in both SRM and ECC systems is empty, so we wanted to implement the note 1498111 but strangely the role MW_ADMIN is not there in our SRM system.
Has anyone faced this issue earlier?
Thank you,
Anubhav
Hi,
Refer Link: http://scn.sap.com/thread/3161528
Given link doesn't resemble your issue. But solution should work for your issue.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Anunbhav,
Have you followed the steps in note : 720819. Usually following the steps in the note mentioned has always given me successful material replicaiton.
Regards
sam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Anubhav,
When you triggerred the load was there any queue generated in ERP and this will reach SRM inbound queue.
Have you registered the queue in SRM?
Have you checked your site creation if its holding the right RFC to ERP?
Have you tried deleting all the queue inbound / outbound in ERP and SRM system and then load?
Regards
Sam
Hi Sam,
When you triggerred the load was there any queue generated in ERP and this will reach SRM inbound queue.
--> Yes there are entries in ERP outbound queue with following data
user = rfc_user
function module = CRM_SEND_DATA
Queue Name = R3AI_DNL_CUST_BASIS3
Destination = XXXXX
Date = 15.05.2012
time = 19:08:54
status = Transaction recorded
Have you registered the queue in SRM?
--> Please let me know how to verify this.
Have you checked your site creation if its holding the right RFC to ERP?
-->Yes SMOEAC has correct RFC entry
Have you tried deleting all the queue inbound / outbound in ERP and SRM system and then load?
--> Yes, multiple times
Many thanks,
Anubhav
Hi Sam,
Yes its stuck in ERP outbound but no error there..status is TRANSACTION RECORDED.
Its a new system setup.
I registered the queues using the below link
http://help.sap.com/saphelp_nw70ehp1/helpdata/en/3b/ea11e1618a46118611b36956c1f3bf/content.htm
What else can i check?
Thank you,
Anubhav
HI,
Have you tried navigating inside the queue because there will be many records and if one is stuck the whole process is stuck.
And SRM inbound queue has nothing waiting or processed? In the monitor objects (r3am1) are there any blocks shown?
Check if any bdocs are created in SRM using tcode : smw01
Maybe few screenshots of the queue attached here could help.
-sam
Hi Sam,
Yes I navigated to details of the outbound queues in ERP all have same Transaction Recorded Status.
SRM Inbound has nothing waiting or processed.
R3AM1 has one RUNNING and one ABORTED entry for DNL_CUST_BASIS3.
SMW01 give NO DATA FOUND message for BDocs.
QUIN Scheduler - SMRQ - Scheduler status shows in active and when I try to activate it it shows STARTING for a few seconds and then becomes INACTIVE. Same is the case with QUOT Scheduler-SMQS.
in SMWP
Thanks,
Anubhav
HI,
The problem I see is the queue is ready but the system is unable to execute them automatically.
Is the Rfc from ERP to SRM working. Check the RFC which has the user RFC_USER.
Also just try unlocking the queue by just placing the cursor on the queue stuck in outbound and pressing the unlock icon. Then use the refresh button to see if the recorded transactions are executed.
Regards
Sam.
Hi Sam,
The RFC Users and connections are working fine from both sides.
I tried restarting the queues but it shows Ready for a few minutes and comes back to previous Status again.
One thing I noticed is that in ERP Outbound Queue in SMQ2 the Destination is not that of SRM system, it is of the ERP system itself.
When the details of this queue is selected there also the destination is similarly incorrect.
Can this be the reason? If yes how to correct this.
When Starting the initial load from SRM I eneter correct data in Source and destination.
Regards,
Anubhav
Hi Forum,
SAP Note 1499392 is for uploading the required authorization object in system and then creating the roles.
Additional issue: While debugging the report SMOF_FILL_CRMATAB i found that it internally calls an RFC of ECC system CRMO_WRITE_CRMATAB, but this RFC does not exists in our ECC system, so the report does not create entries in table CRMATAB in ECC and SRM
I found a thread http://scn.sap.com/thread/1948221 that mentions a note
1502607 - Potential disclosure of persisted data((FM CRM0_WRITE_CRMATAB missing in CRM. ))
but this note does not provides solution for missing FM.
Has some one faced this issue earlier?
Thanks,
Anubhav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Anubhav,
I had faced the issue with CRMATAB with one of my clients.
Issue was CRMATAB was empty on the ECC and the RFC user in ECC (RFC called from SRM to ECC) didnt have authorizartion object SCRMMW (from MW_ADMIN role ).
We added the authorization object to RFC user profile and ran report SMOF_FILL_CRMATAB in SRM to fill the entries in ECC.
It doesnot matter if the table doesnot have entries in SRM. It must have entries in ECC.
Let me know if you need more info.
Regards,
Hi Sushil,
We are on SRM 701 and ECC 6 EHP 3 SP 13.
I have checked the note 1501685 but the role MW_ADMIN is missing so that note will not work..
Any other information will be of great help.
Additionaly as I mentioned above the FM CRMO_WRITE_CRMATAB is missing in the ecc system.
Thanks a lot,
Anubhav
Hi Anubhav,
How did you get the role imported into your system ? We are trying to import the files mentioned in the note 1499392 . The objects are not available under the TR and hence cannot be moved to the other systems. Did you faced any similar issue ? Could you please share any thought on this?
Regards,
Abhay
Hi Vinay,
I checked the thread you posted. In my system table TBLSYSDEST in empty in SRM and does not contaisn the SRM RFC Dest entry on ECC Side. Table CRMATAB is empty on both SRM and ECC that is the reason I wanted to apply the note.
Hi Ram,
We are on SRM7.0 .The issue is there with all customzing objects not only DNL_CUST_BASIS3.
Issue is with initial load of objects. After running R3AS SRM outboud queue shows one entry but there is nothing in ECC inboud. In R3AM1 it always shows running status.
Hi Ricardo,
I tried entering manually MW_ADMIN in PFCG but it still shows Role does not exists.
Additional info--
I have done and throughly checked settings as per note 720819 & 872533.
Transaction SMWP-->Runtime Information-->Data Exchange using qRFC Queues-->qRFC Queues in R/3 Backend(s)-->ECCCLNT800-->Loads for CRM Server-->Blocked queues 2.862 entries
Please help to resolve this.
Thanks all,
Anubhav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
If you type the role MW_ADMIN directly, without using the search help, and press enter, is the system still not able to find it?
Regards,
Ricardo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anubhav,
Which SRM Server version you are having ? There is no need of initial load of object DNL_CUST_BASIS3 from SRM 4.0 server.
What is the problem you are facing ?
Best Regards
Ram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.