SAP Knowledge Base Article - Public

2517765 - Date/Time Extension Field Value is not Valid in Migration Tool

Symptom

When trying to execute migration for a business object which contains an extension field of type Date/Time, the migration tool raises the below error message:

"Registered Products-XYZ:'ABC' is not a valid value; edit source value" (XYZ represents the extension field name, ABC represents the value in the field)

This case document is also valid for the same error message when executing migration of other business objects, not only for Registered Products.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Enter Business Configuration work center.
  2. Navigate to Implementation Projects view.
  3. Open Activity List.
  4. Search for Migration of Registered Products.
  5. Click on Migrate Registered Products using the Migration Tool.
  6. Select the file to be migrated and click on Execute Migration.
  7. In the validation step, the error message is raised by the system.

Cause

This issue is caused by the conversion of date/time extension fields for the migration template.

Currently, the system does not support date/time fields for the migration template, so the extension fields with this data type are mapped as a number type field.

The extension fields with simple date or time type are properly mapped to the templates. This issue only occur for date/time fields.

Resolution

In order to fulfill the date/time migration template fields, you need to provide date in the following format:

YYYYmmddhhmmss

Keywords

date time, extension field, date/time , KBA , SRD-CC-FED , Feeds , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions