Symptom
You are unable to import service requests via Data Workbench work center. An error occurs. Error: Please correct the duration. XXX is no valid ISO format (where XXX stands for duration).| Please correct Due Date for Completion. DD.MM.YYYY HH:SS is no valid ISO format.
The same error as for Due Date for Completion might also occur for Due Date, Request closed at time point, Request finished at time point, Request initial receipt time point, Request in process at time point, and Resolved On Date etc.
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to Data Workbench work center
- Click on Insert Individual Object
- Search for ServiceRequest
- Click on Next
- Upload file
- Click on Next until Import Data
- Go to Monitor view
Cause
The cause is that the dates/ times and the duration are not formatted in the correct ISO format.
Resolution
Combined date and time format is e.g. YYYY-MM-DDTHH:SS:00Z.
Duration format is PTXXXS (where XXX stands for the duration calculated to hours and minutes).
Keywords
import service requests, DWB, runs into errors, data and duration fields, format requirements, iso format, , KBA , LOD-CRM-INT-DWB , Data Workbench , Problem