Initial load delete

[Former Member]

Hi Gurus,

How can i delete initial load once it is started?.

Regards,

Bhargav

[Former Member]

Hi Prem,

I assume that you have triggered initial load for customers.  If that is the case then -

If you start an initial load(say BUPA_MAIN) and kill it, there's no effect on the system. However your respective data tables would be partially populated.

I hope after killing the BUPA_MAIN initial load process in R3AM1, you had cleared up the queues in your respective CRM system.

To stop forming thousands of queues, just maintain a pertinent block size in R3AC1 for BUPA_MAIN(depending upon the no. of records you want to download).

Hope this will be useful

Thanks and Regards

DJ

[Former Member]

Hi joshi,

Thanks for your reply, my case here is, we are using CRM 7.0 EHP1 and ECC 6.0 EHP6. first CRM system was connected to 040 client and now they changed to 120 client, so i changed site attributes

in SMOEAC by removing 040 RFC destination and now i gave 120 RFC destination. I did initial load for materials, prod hierarchies, customers when it was connected to 040 client. now i want to do the same

for 120 client. But can i do that now, coz it's showing me as initial load already started. Please help me on this.

Regards,

prem

[former_member420332]

You started the initial load in client 040 but if i'm correct the initial load didn't finish.

First cancel the process in transaction R3AM1 for your object.

Because you already connected the CRM system to a different client, you probably have to remove the record in table CRMMLSGUID in CRM. You can also check to make sure if there is no record in table CRMPRLS in ECC client 120. Check Note 588701 for details.

To clean up you can remove the queues for your object in transaction SMQ2 in ECC client 040.

You should now be able to start the initial load, but I can't tell you what will happen to the items that are already processed with the initial load from client 040.