web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Aync Client issue in D...
Microsoft Dynamics AX (Archived)

Aync Client issue in DAX Retail 2012 r3 CU10

(0) ShareShare
ReportReport
Posted on by malioni91 50

Hello everyone,

I believe that I have a problem with the communication between the Async Server and Async Client, however, Can someone please help?

Thanks in advance

My current environment
I am installing the Dynamics AX 2012 R3 (CU10) retail components on three different servers (all under the same domain):

1 - AOS/Client server

2 - CDX (Commerce Data Exchange) server

3 - Dynamics AX DB server

On the AOS/Client server I have installed Retail Headquarters, Retail POS, and Retail Channel Configuration Utility.

On the CDX server I have installed Real-time Sercie, Async Server and Async Client (see image below)

On the CDX server I have installed also a retail channel DB on a SQL Server 2012 Express (with Advanced Features) instance. 

On the DB server I have installed the main Dynamics AX database on a SQL Server 2012 Standard Edition.

The issue that I am facing

Every time that I do a full synch of the data all the jobs in the Download Session remain "Available" instead of becoming "Applied". Additionally, the Message, Date requested, Date downloaded and Date applied arte blank (see image below).

DownloadSession.png

And these are the DBs installed in my CDX (Commerce Data Exchange) server:

4130.DownloadSession.png


MSGHQ is the Message DB

TiranaChannel and ChannelTEST are both channel databasees

*This post is locked for comments

I have the same question (0)
  • Rodolfo Recalde Profile Picture
    Rodolfo Recalde on at

    Hi Malion,

    a. Click in "Process Status Messages" at download sessions form to update the progress of jobs.

    b. Check the event viewer, perhaps the job is falling in some exception in channel DB.

    c. Verify that the Async Client Service is started.

    Any news, update us.

    I hope this helps!

    Regards,

    Rodolfo Recalde.

  • malioni91 Profile Picture
    malioni91 50 on at

    I have performed step. a multiple times, yet I have the same issue.

    No error is present on the event viewer regarding this issue.

    The Async Client is running and the Log On As has been set to the AsuncClient service account.

  • Rodolfo Recalde Profile Picture
    Rodolfo Recalde on at

    Test Connection. Verify Async Client Configuration Utility.

    In Windows Explorer, browse to:

     C:\Program Files (x86)\Microsoft Dynamics AX\60\CDX\Async Client\Package

    Start AsyncClientConfigurationUtility.exe. 

    AsyncClienUtility_5F00_DAX_5F00_Recalde.png

    I hope this Helps!

    Regards,

    Rodolfo Recalde.

  • malioni91 Profile Picture
    malioni91 50 on at

    I have done those steps as well, however the issue still persists...

    Is it possible that the issue with the status of the messages might be related to the SSL certificate used by the Async Server?

    I have created the self-signed certificate only on CDX (Commerce Data Exchange) server and I am able to see the Upload and Download Services XML in there without anyproblem. For example when I open comdataexch/.../DownloadService.svc I get to see the XML.

    However when I try to access the same URL from the AOS/Client server, I can see the XML but with certificate errors....

    Can I use the same SSL on the AOS/Client server as well?

  • Rodolfo Recalde Profile Picture
    Rodolfo Recalde on at

    Yes. Use the same certificate. Install certificate in Async Client and POS Machines.

  • malioni91 Profile Picture
    malioni91 50 on at

    So I did install the same certificate on the POS machine (Async Client has been installed on the same server as Async Server so they have the same SSL certificate) and it still doesn't work...

    Everytime that it tries to initiate a download session, I see this error coming up in Even Viewer. Any idea what it might be?:

    Exception during DownloadAgent.Execute. Error Details: System.Data.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Invalid column name 'DateRequested'.

    Invalid column name 'DateDownloaded'.

    Invalid column name 'DateApplied'.

    Invalid column name 'Status'.

    Invalid column name 'Message'.

      at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

      at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

      at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

      at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()

      at System.Data.SqlClient.SqlDataReader.get_MetaData()

      at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

      at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)

      at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

      at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

      at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

      at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

      at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)

      --- End of inner exception stack trace ---

      at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)

      at System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)

      at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)

      at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()

      at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source)

      at System.Linq.Queryable.SingleOrDefault[TSource](IQueryable`1 source)

      at Microsoft.Dynamics.Retail.SynchClient.DataManager.DownloadSessionDataManager.GetDownloadSession(Int64 id)

      at Microsoft.Dynamics.Retail.SynchClient.DataManager.DownloadSessionDataManager.UpdateDownloadSession(Int64 id, String jobId, Int64 fileSize, String checksum, DownloadSessionStatus status, String message)

      at Microsoft.Dynamics.Retail.SynchClient.Core.DownloadAgent.ProcessDownloadSession(DownloadSession session)

      at Microsoft.Dynamics.Retail.SynchClient.Core.DownloadAgent.Execute()System.Data.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Invalid column name 'DateRequested'.

    Invalid column name 'DateDownloaded'.

    Invalid column name 'DateApplied'.

    Invalid column name 'Status'.

    Invalid column name 'Message'.

      at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

      at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

      at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

      at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()

      at System.Data.SqlClient.SqlDataReader.get_MetaData()

      at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

      at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)

      at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

      at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

      at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

      at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

      at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)

      --- End of inner exception stack trace ---

      at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)

      at System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)

      at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)

      at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()

      at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source)

      at System.Linq.Queryable.SingleOrDefault[TSource](IQueryable`1 source)

      at Microsoft.Dynamics.Retail.SynchClient.DataManager.DownloadSessionDataManager.GetDownloadSession(Int64 id)

      at Microsoft.Dynamics.Retail.SynchClient.DataManager.DownloadSessionDataManager.UpdateDownloadSession(Int64 id, String jobId, Int64 fileSize, String checksum, DownloadSessionStatus status, String message)

      at Microsoft.Dynamics.Retail.SynchClient.Core.DownloadAgent.ProcessDownloadSession(DownloadSession session)

      at Microsoft.Dynamics.Retail.SynchClient.Core.DownloadAgent.Execute()

  • Rodolfo Recalde Profile Picture
    Rodolfo Recalde on at

    Please, double check:

    - Try Initialize Retail without errors.

    Click > Retail >Setup >Parameters > Retail parameters > Initialize button

    - Then, try Sync Metadata

    Click > Retail >Setup >Parameters > Retail Scheduler Parameters > Sync Metadata button

  • Verified answer
    malioni91 Profile Picture
    malioni91 50 on at

    I figured out how to resolve this issue by following the Retail installation training material downloaded from PartnerSource :). I realized that I had made two mistakes in the installation of the Async Client:

    1 - Channel Message Database: Instead of creating a new message database for the channel, I used the HQ message database that I had created previously for the Async Server. So for everyone who has this error, make sure to install a new message database for the Async Client.

    2 - I had not configured the AOS Profile for retail. Make sure to input the correct information in that field as well.

    Other checks that you can make:

    1 - Check if the firewall is blocking the communication between your CDX and you AOS server.

    2 - The POS application will not be accessible unless you give the retail-oriented users read/write permissions on the SQL Server instance which is used to run the CDX component.

    3 - Additionally make sure to enable the Directory Browsing option in the IIS Server.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans