Symptom
While performing a GET call via OData, the error "Error occurred while processing property 'xxx' of entity no. 'zzz'|Property 'yyy' has invalid value 'www'" is returned. This error is usually tied to a task getting interrupted on Data Workbench.
Environment
SAP Cloud for Customer
Reproducing the Issue
- Perform a GET call on the Object which is failing on Data Workbench, example for Tickets: 'https://myxxxxxx.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/ServiceRequestCollection'
- The error "Error occurred while processing property 'xxx' of entity no. 'zzz'|Property 'yyy' has invalid value 'www'" occurs
Cause
A specific record in this Business Object has an invalid value which leads to the error while performing a GET call and, in the case of Data Workbench, the task gets interrupted if this record is part of the results.
Resolution
The error message will inform what needs to be corrected:
"Error occurred while processing property 'xxx' of entity no. 'zzz'|Property 'xxx' has invalid value 'www'"
- xxx = The name of the field which has the wrong value
- zzz = The position of the problematic result in the OData call
- www = The value of field xxx
- Since 'zzz' will only inform the position of the record, and not the ID of it, the ID may be found using the following endpoint:
https://myxxxxxx.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/ServiceRequestCollection?$top=1&$skip=<the number of zzz -1>&$format=json&$select=ID
For example, if the error comes up "of entity no. '520'", the endpoint would be:
https://myxxxxxx.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/ServiceRequestCollection?$top=1&$skip=519&$format=json&$select=ID - After the ID is found, The value of 'xxx' may be changed in this object to any valid value. This should correct the issue.
See Also
SAP KBA 3334088 - File getting interrupted when trying to export using Data Workbench
SAP KBA 2631487 - Export is Interrupted in Data Workbench
Keywords
rror occurred while processing property , entity no. , Interrupted; Interruption; wrong; invalid; dump; error; , KBA , LOD-CRM-INT-DWB , Data Workbench , LOD-CRM-INT-API , OData API (C4C Only) , Problem
SAP Knowledge Base Article - Public