Symptom
Data Workbench export for Visits gets Interrupted.
Reproducing the Issue
- Data Workbench workcenter
- Export view
- Search Visit BO
Export file Interrupts
Cause
Data Workbench export fails due to complex property in OData Service: Activity.
Complex Type is not supported by Data Workbench tool.
Hence, we disabled the creation of Complex property in OData service and all the complex property is added as flat attribute.
The complex type of 'QUANTITY' ,'QUANTITY2', 'QUANTITY3' is 'activity.Quantity' in the dwb enabled Odata service. This is why Data Workbench is not able to parse the exported data only for Visit.
Here is the metadata url -
https://myxxxxxx.crm.ondemand.com/sap/c4c/odata/v1/activity/$metadata
(myxxxxxx is Tenant ID)
Resolution
You need to remove and re-add the error-ed attributes to OData service.
Note: Only remove and re-add the attributes from OData service and not the attribute itself.
Keywords
Visit, Data Workbench, Complex Type, Acivity , KBA , LOD-CRM-INT-API , OData API (C4C Only) , Problem