Blog

Distribution jobs issue: Failed to convert parameter value from a String to a DateTime

Description


Distribution job was not able to copy data from a channel (store) database to AX2012 because of the error: Failed to convert parameter value from a String to a DateTime.


Solution


Error tells us that something is wrong with data in a table we are trying to transfer. When checking the data, we found out some DateTime SQL fields that had NULL values – and Async client was not able to transfer these NULL fields.


What helped:


  1. Update existing datetime NULL values with default value – this was enough to fix the issue with the job
  2.  Alter SQL column definition to set a default value for NULL cells in future like this

Error details


Failed to convert parameter value from a String to a DateTime. —> System.FormatException: String was not recognized as a valid DateTime.

Blog