SAP Knowledge Base Article - Public

2892510 - Error: Please correct the duration. XXX is no valid ISO format.| Please correct Due Date for Completion. DD.MM.YYYY HH:SS is no valid ISO format.

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 pointRequest finished at time pointRequest initial receipt time pointRequest in process at time point, and Resolved On Date etc.

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Go to Data Workbench work center
  2. Click on Insert Individual Object
  3. Search for ServiceRequest
  4. Click on Next
  5. Upload file
  6. Click on Next until Import Data
  7. 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

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions