2973843 - Error While Extracting Visits in Data Workbench

Data Workbench export for Visits gets Interrupted.

1. Data Workbench workcenter
2. Export view
3. Search Visit BO

Export file Interrupts

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)

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.

Visit, Data Workbench, Complex Type, Acivity , KBA , LOD-CRM-INT-API , OData API (C4C Only) , Problem