Symptom
The export task in Data Workbench failed with the interrupted status after it's started for a while.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to Data Workbench > Export.
- Select the target object.
- Set up the filters or directly select all data.
- Export data.
- Go to Data Workbench > Monitor.
- The export task will be interrupted after a while.
Cause
The data workbench task is getting interrupted due to corrupt data present in some of the fields. That's say, at least one record contains invalid value.
Resolution
You can either remove this field from the export or correct the data in the field. Let's take exporting service request as an example. You may follow the steps below to locate the invalid value.
- Let's say you are trying to export service requests that have empty territory ID.
- You should have the OData URL: https://myxxxxxx.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/ServiceRequestCollection?$filter=SalesTerritoryID eq null (xxxxxx represents your tenant number. The filter is an example, please configure your own filters as per your business requirements.)
- Start MS Excel and go to Data > Get Data > From Other Sources > From OData Feed.
- Fill in the URL and then hit on OK button.
- Click on Basic tab, and fill in the username and password.
- Hit on Connect button.
- Hit on Load button.
- Wait until an error eventually comes. It can take some time.
- When the above error comes, please go to C4C system.
- Go to Administrator > General Settings > OData API Monitor.
- Find the entry with GET method, 500 error code and the same path.
- Check the Request Payload and Response Payload. You will get the exact error details.
- Access the URL presented in Request Payload and exclude the corrupt data by using the $select method, you will get the ID if the entity. And then you can correct the data. The URL would be like:
https://myxxxxxx.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/ServiceRequestCollection?$top=1&$skip=<the number in requst payload>&$format=json&$select=ID
*Note: If the KBA and the docs in See Also section are not of help, please raise a support ticket to SAP.
See Also
- Data Workbench > Export Help Portal
- 2631487 - Export is Interrupted in Data Workbench
- Leverage the power of ODATA with Excel - SAP Community
Keywords
Export, Data Workbench, Monitor, Interrupted , KBA , LOD-CRM-INT-DWB , Data Workbench , How To