Data Migration in Data Workbench. (Issue during Email Note update)

[Former Member]

Hello,

I migrate data in new SAP C4C system.

And I found errors. I could understand the difference between the records of 'Emails Note'

• Transition Status 'Sent' : I could not update the Email Note(text)
• Transition Status 'Received' : I could update the Email Note(text)

I have a question about how to update the 'Email Note' of the Transition Status 'Sent'.

(Actually, I could understand that SAP system block not to update the Email text that the system already sent.)

But, it is the data migration step. so it could be possible to migrate data.

I could reproduce the error message from the steps below.

1. Select individual Component 'Email Note'.
2. Upload the file
3. Map the fields
4. Simulate the data migration.

error.png

If there is any professionals to solve this issue, then please give me an advice.

Thanks.

[Former Member · Accepted solution]

I wish to share the information by SAP Support team. It would be helpful.

(Answer from SAP Support team on June 7th is like below)

It is not possible to add notes to outbound emails that are already completed. This is the expected behavior. There is no workaround for this.

Also, it is not possible to revert the status of an outbound email once it is completed. The reason for this is that it has already been sent so it cannot be reverted.

This is why you get error: 'Action NOTIFY_OF_SENDG not possible; action is disabled' when trying to change the status from 'Completed' to 'In Process'.

As this is expected behavior, it is up to the users to ensure all notes are added before the outbound email is sent. Once completed, it cannot be reverted and no more notes can be added.

[leonardo_felini]

Hello Ukho,

Generally speaking, the data workbench provides the same capabilities of the system UI, so if you are able to insert notes on e-mails with status 'sent' in the UI, you should be able to do this also via Data Workbench.

Additionally, could you please provide more details on some points, so we can try to identify a solution:

1. I was not able to find any documentation mentioning this specific error message. Could you please confirm that you are using the standard service "Email notes" from the DWB, or is this a custom implementation?

2. Did you try to perform the update operation from an export file from the tool? I can see that it seems that no external key is being used (for the note or for the e-mail)

Kind regards,

Leonardo

Support Consultant | SAP Product Support

Community:

SAP Business ByDesign: https://www.sap.com/community/topics/business-bydesign.html

SAP Cloud for Customer: https://www.sap.com/community/topics/cloud-for-customer.html

[Former Member]

Hello Leonardo,

Thank you for your comment.

It is the answer that you asked me.

1. I used the standard template 'Email Note'.

2. I use the 'insert' operation with the primary key 'Email ID'.

(I don't need to update the external key. I would think that it is a field for the foreign key.)

And I wished to share the comparable experience during the data migration.

I did data migration using DWB to inserting the 'note' data for these similar objects(Tasks, Appointments)

There was no issue when I inserted data without the external key(foreign key).

Because I used the Id field(task id, appointment id) as a primary key.

So, I am curious what is the workaround or solution for this issue(Inserting of Email note).

Thanks.

Sincerely,

Ukho Bae(David)

[leonardo_felini]

Hello Ukho,

Thank you for the answers. Regarding the usage of the external key, we highly recommend that you set an external key when performing import operations, as the external key is the main identification field used in Data Workbench (for example, when importing notes or involved parties in business objects, the external key is the primary indentification for the parent object).

About the specific error message that you are facing in this case, we understand that it should not be happening in import operations.

As mentioned, the operations performed in Data Workbench are handled the same way as if they were processed in the UI, so even events from custom solutions are triggered during the job. Considering this, I would suggest you to check whether a custom event is being called, otherwise you can create an incident for us to check further an assist you on solving this scenario.

Kind regards,

Leonardo

Support Consultant | SAP Product Support

Community:

SAP Business ByDesign: https://www.sap.com/community/topics/business-bydesign.html

SAP Cloud for Customer: https://www.sap.com/community/topics/cloud-for-customer.html