ID Mappings to be deleted via data workbench in C4C

[raghavendra_yadav]

Hi,

1. I want to remove the ID mappings for the "ERP Accounts" mapped with the C4C Account IDs.

2. I followed the steps mentioned in the SAP Note # 2921918 & 2947433 and also the blog "https://help.sap.com/docs/SAP_CLOUD_FOR_CUSTOMER/c52d3ba13f56403ba116560148fd2071/46915a93bb6b4180884a2c530b8a1492.html"

3.Tested the deletion process. Every time i got the following error in the import "Finished" document.

"Local Object ID missing or invalid|Local Object with ID ID Mapping does not exist"

4. I tried it with different combinations but all my efforts are in vain.

5. Is it really working as explained in the Sap Notes & blog?

Thanks.

[Juliuspereira · Accepted solution]

You should be using the data workbench import option to import the file and use the same file that you export from the data workbench, after adding the ToBeDeleted = True column

Is this what you are doing?

Summary of steps.

1. Export required ID mappings using object 'Object Identifier Mapping' in the Data workbench

2. Add ToBeDeleted column to the exported file

3. For all the ID mappings to be deleted, in the column 'ToBeDeleted', set the value to True

4. Import the ID mappings updates using using object 'Object Identifier Mapping' in the data workbench (use the update option).

Julius

[raghavendra_yadav · Accepted solution]

Hi Julius,

Thanks again for the follow up.
YES. I did the same as you mentioned. Apart from it, i tried other combinations too. Nothing has been worked.
As I have no other option and hence, deleted around 59k entries manually.
I have observed one more issue with the Data Workbench. Though this is a different issue.
By using the "UPDATE" function, when i tried to change the name of the all "Obsolete" Customers, the "Import" is showing the run as successful. But the result is not the same. I mean nothing has been changed.
I got the same issue with the ID Mapping import too.
Not sure whether this is a bug in the program.

[Juliuspereira]

Hi Raghavendra,

I'm not sure what you and I are doing differently because when I ran a test of the export/ import process using the DWB, I was able to successfully delete the ID mappings. I'm curious to understand how you manually deleted the ID mappings?

For the other issue where nothing has been changed, I'm guessing that the screenshot you attached refers to that. If that is the case, I see that you only ran the simulation and not the actual update. Did you run an actual update after the simulation?

Julius

[raghavendra_yadav]

Hi Julius,

As i mentioned, there seems a problem with the DWB. Not only ID Mapping, other proposed changes are also not working. Will raise an incident with SAP. Thanks.

[raghavendra_yadav]

Hi Julius,

I figured it out the issue. The mistake was about selecting the "Simulation Mode = ON" all the time. This was the reason why even after showing the monitor result as "SUCCESS" the intended result like field value deletion was not happening. Really appreciated your time and guidance.

[Juliuspereira]

You're welcome. I'm still curious to know how you manually deleted the ID mappings as I did not see any option for that. Can you share how you achieved that?

Julius

[Juliuspereira]

Hi Raghavendra,

Your understanding is correct except for one key aspect. You do not have to export the account object but instead export the id mapping using object 'Object Identifier Mapping'. See screenshot

Then add the column ToBeDeleted = True. and then import the file.

Julius

[raghavendra_yadav]

Hi Julius,

Thanks for the response. Even this option didn't help me. The template "Export" with data is not fitting as it is into the "IMPORT" with addition of the field "ToBeDeleted". System asking to remove "OBJECT ID" column in the first instance. After removing the column, when i tried again with the rest of the data, it is asking me to use the ID Mapping template that contains only 2 fields (External_Key & ID) and the same story is repeating. Ending up with error like "Fatal Exception Occured".

[Juliuspereira]

Hello Raghavendra,

I just gave this a shot in our test tenant and it seems to have deleted it. I exported the values that I want to delete using the DWB and then in the same file I added column ToBeDeleted = TRUE at the end, and then imported the file using DWB.

Are you trying using the same process?

Julius

[raghavendra_yadav]

Hi Julius,

Thanks for the quick response.
As per your statement,

1. Download the "Account" object (Export)

2. Add a new Column "ToBeDeleted" with value as "TRUE"

3. "IMPORT" the updated file.

Please correct if my understanding is wrong here.

If above statement is correct, then it won't work. I have already tested it.

The reason is, the Exported OBJECT contains specific fields (Columns) and adding additional field (ToBeDeleted as column) leads to an error of mismatching the fields.

What am doing here is exactly the same as explained in the SAP Notes and blog..

My steps are,

1. Go to "Import".

2. Click on the "ID Mapping" and select Object ID = Account

3. Download template.

4. Downloaded file displays like this

5. Add a new column name as "ToBeDeleted" with value as "TRUE".
6. Update the template with values of the accounts which you want to delete the ID Mappings (links can be seen in the ADMINISTRATOR --> ID Mapping for Integration --> Edit ID Mapping for Integration --> ERP Accounts).
7. Upload the updated template into the Import --> ID Mapping.

Have tested the template by adding additional field with different values. But none of the scenarios worked for me. You can test on your own and in case if it works, then please let me know. Thanks.