Retail Scheduler Job – Apply failed | The given value of type String from the data source cannot be converted to type datetime of the specified target column

Hi Guys, Hope you all are keeping up with RetailDAXing. In this blog, I will help you troubleshoot one of those many scheduler job errors which annoy everyone. Sometimes it gets very hard to troubleshoot and find the exact reason for the cause. This is my small efforts to help you with these error.

This blog is about the error you get in the Download session form under message column-

Troubleshooting Commerce Data exchange- Async Server & Async client in Dynamics AX for Retail R3

Hi Guys, this blog post will provide you the troubleshooting procedure for Async Server and Async Client for data distribution in Microsoft Dynamics AX for Retail R3. Commerce Data Exchange: Async Server is part of the asynchronous system that shares data between the Microsoft Dynamics AX database and channel databases. Async Server is installed at headquarters and communicates with Microsoft Dynamics AX. In addition to Async Server, Commerce Data Exchange includes Commerce Data Exchange: Async Client, which is installed at channels and communicates with the channel database.

You might be working on the Demo VM or pre-installed AX 2012 R3 machine and found out that the data distribution is not working. Follow the below procedure in order to fix this issue.

Configure the Retail Scheduler parameters:

In Microsoft Dynamics AX client, go to Retail module >> Setup >> Parameters >> Retail Scheduler Parameters >> General Tab. Enter the details.

• Server Name : The name of the computer that hosts the message database for Async Server (if you are working on Demo VM then type retail.contoso.com)
• Database Server Instance : The name of the SQL Server instance that hosts the message database for Async Server.
• Database Name : The name of the message database for Async Server. (if you are working on Demo VM then  type ASyncServerHeadOffice (matching the HO message DB name in SQL))