Distribution jobs issue: Failed to convert parameter value from a String to a DateTime
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.
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.
- Update existing datetime NULL values with default value – this was enough to fix the issue with the job
- Alter SQL column definition to set a default value for NULL cells in future like this
Failed to convert parameter value from a String to a DateTime. —> System.FormatException: String was not recognized as a valid DateTime.