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.
What helped:
Failed to convert parameter value from a String to a DateTime. —> System.FormatException: String was not recognized as a valid DateTime.