Symptom
Your requirement is to update the data in some of the fields of the respective object using Data Workbench. Upon trying to modify the data in required fields and uploading the file for the object in the Update view in Data Workbench, you see processing errors for the records.
Few examples as below:
Update not allowed for properties: ProcessorPartyName. Check metadata for ServiceRequestCollection
Update not allowed for properties: DistributionChannel,SalesOrganisationID. Check metadata for ProductSalesProcessInformationCollection
Environment
SAP Cloud for Customer
Reproducing the Issue
To export data for the Data Workbench object:
- Go to Data Workbench workcenter
- Go to Export tab
- In the Search field, select the object
- Choose appropriate filters if required
- Select Next
- Export Data
- Go to the Monitor tab
- Download the exported file
Perform the Update of the Object using the same file
- Modify the data for the required fields in the file
- Save the file
- Go to Data Workbench workcenter
- Go to the Import tab
- Select the radio button Individual Objects
- Go to Update tab
- Select the object
- Select Next and Browse for the file
- Select Upload
- Choose Next to review the summary of your selection
- Select Import
- Go to Monitor view to check the status of your import
- The records in the file have the Processing Error
Cause
The properties of the respective Service are updatable=false and therefore, the processing records are in error.
You may verify the Properties for the respective Entity Set by executing the below query in Google Chrome browser.
https://myxxxxxx.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/$metadata (where myxxxxxx represents the tenant)
Once you see the results, find the Entity Type and check the Property accordingly.
You will also be able to see the Properties for the respective Entity Set as below:
1. Go to Administrator work center
2. Go to OData Service Explorer view
3. Show SAP OData Services
4. Highlight the Service name: c4codataapi and select the button Test
5. On the OData Console, for the Service https://myxxxxxx.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi , in the left pane, select the Entity Set
6. Select the tab Entity Details
Example:
DistributionChannel and Sales_Organization_ID is marked as updatable=false in the metadata of the service Product. The exported file has Product Sales data with Distribution_Channel code as 02 and the Sales_Organization_ID XXXXX in the system. But with the Update task, you tried to update the Distribution Channel code as 01 and further update the Sales_Organization_ID to YYYYY. That is, you updated the value of property DistributionChannel and SalesOrganizationID which is marked as updatable=false due to which the update failed with error.
Resolution
The fields which are marked as updatable=false will not be allowed to update via Data Workbench.
Keywords
Data Workbench, updatable=false, c4codataapi, Collection, Update not allowed for properties, Export, Update, Entity Set, Service , KBA , service , collection , c4codataapi , updatable=false , update not allowed for properties , entity set , data workbench , odata , export , metadata , update , LOD-CRM-INT-DWB , Data Workbench , Problem