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) / AX 2012 R2 Retail Stor...
Microsoft Dynamics AX (Archived)

AX 2012 R2 Retail Store DB Can't be populated

(0) ShareShare
ReportReport
Posted on by Amos 205

I'm trying to set up Retail module with separated Server between AOS and DB server. both of them using Windows Server 2008 R2 and work on VM

  1. i already setup all the requirement properly
  2. The Synch Service has been installed on both server either it's on the AOS or DB server
  3. i already configure all the Synch profile, database profile, and AOS Profile. all of them already tested for connection and working properly
  4. the store database creation using retail database utility also work without any problem
the problem start when i'm using the distribution schedule. all the N-jobs log are work fine and stated successful. but when i check the DBO.outgoing message on the database there's no server message that usually mention how many record data affected by the job and there's no error mention by the system. when i check the Store DB it's also still blank.
can anybody help me with this problem?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    From your description I am assuming you have the HQ Synch Service setup on the AOS and the Store Synch Service setup on the DB Server. Is this correct?

    First off, under Retail\Retail scheduler\Channel integration\AOS profiles I would check to see what is set for the parameter Commerce Data Exchange: Synch Service. Check the Synch Service profile listed here and see what message database is linked to it. I call this the HQ Synch Service and the message database associated with it is where the packets go to first and then they are forwarded to the Store's Synch Service. If they do not make it here they will not make it to the Store Synch Service message database.

  • Amos Profile Picture
    Amos 205 on at

    @michael: the AOS and the store are on the same server. the separated are only the DB. on the DB server "Service Setting" and the AOS Server "Service Setting" using the same setting.

    actually i was once succeed on populating the DB. but there's an error when i'm running N-job 1070 there's an error number 32769. when i try to re-run the job the synch service won't send the data anymore.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Ok. If they are both on the same server you should only need one Synch Service. This is how the AX 2012 R2 Demo is setup.

    I have seen this error before. Shutdown the Synch Service and try deleting all the existing incoming and outgoing messages from the Synch Service message db(s). Then go in and delete the ques and temp files form the Synch Service Work folder(s). After this restart the Synch Service and try again.

  • Amos Profile Picture
    Amos 205 on at

    @Michael: Thank you man. It's work like magic. now all the synch service can work properly

  • Community Member Profile Picture
    Community Member on at

    Your welcome. I am glad I could help you out.

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
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Sukrut Parab Profile Picture

Sukrut Parab 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans