SAP Knowledge Base Article - Public

2973843 - Error While Extracting Visits in Data Workbench


Data Workbench export for Visits gets Interrupted.

Reproducing the Issue

  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 -$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


SAP Cloud for Customer core applications 2008