Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Data is not sync from ...
Microsoft Dynamics AX (Archived)

Data is not sync from Store to HQ

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi Experts,

I am new in AX retail, i am using AX 2012 R3 CU8

 i am facing issue, When i run JOB '9999' from Channel database, data is sync in Store ( Data is reflecting in the store).

but when i run P-Job, data is not sync in HQ.

I checked in Event log. In Event Log it shown me Error " Invalid username or Password". 

I reset the password in channel database as well in store ( In AsyncClientConfigurationUtility ).

In Store Async Server connection is proper ( I checked by click on TEST connection button).

but still its not working.

Hope to hear from you soon!

 

thanks and regards,

Amol

*This post is locked for comments

  • Verified answer
    Hassan_rulz Profile Picture
    Hassan_rulz 3,801 on at
    RE: Data is not sync from Store to HQ

    Hi Amol,

    Have you imported RTS & Async certificates in your store machine?

    If no then import all the certificates in trusted root directory.

    Also restart async client service.

    One thing more, check upload session in async db and delete all the logs and re-run P-job.

    Regards,

    Hassan

  • Verified answer
    adam260 Profile Picture
    adam260 1,871 on at
    RE: Data is not sync from Store to HQ

    I would check and verify that your cert files are installed on your servers, they haven't expired and installed with the correct thumbprint. I had an issue were I needed to add them to both the personal folder and the trusted root auth folders in order for it to auth correctly.

  • CattermoleS Profile Picture
    CattermoleS 55 on at
    RE: Data is not sync from Store to HQ

    Hi Amol,

    I have seen something like this before. Try Restarting the SQL Service where the Channel DB is installed. This should trigger the .rpf file to be created. However Any new transactions again are not seen by the Async client.  It's almost as if the transactions aren't submitted until the restart of SQL.

    Upload session wont be created as there is no .rpf file to pick up from the working directory. Have you checked the Max replication counter in the crt.tablereplicationlog is not higher than the replication counter of your last transaction? I tried truncating the tablereplicationlog table which should sync everything back to HQ, however it synced everything to where it got stuck last time.

    Regards,

    Steve

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Data is not sync from Store to HQ

    Hi Mahmoud,

    as per you reply. I did set user ID and Password in channel Database

    as well as change in AsyncClientConfigurationUtility.  ( same USER ID and PASSWORD).

    After that i run Sync Meta Data from Retail Scheduler Parameter.

    then I run P JOB but still got the same error.

    As i mention above, Upload session is not created for that store only.

    regards,

    Amol

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Data is not sync from Store to HQ

    HI Steven,

    In working Upload folder .rpf file is not created.

    upload session is not created for that store. for rest of store upload session is created and applied.

    In HQ there is 15 store out of that 14 is working fine. problem with only this store.

    regards,

    Amol

  • m_anass Profile Picture
    m_anass on at
    RE: Data is not sync from Store to HQ

    Set both user Id and password at Retail->Setup->Retail Scheduler -> Channel Integrations ->Channel Database

    After that run Sync Meta data from Retail -> Parameters -> Retail Scheduler Parameters

  • CattermoleS Profile Picture
    CattermoleS 55 on at
    RE: Data is not sync from Store to HQ

    Hi Amol,

    are there any Packets (.rpf) files in the working upload folder directory that haven't yet been applied to HQ? Have you tried setting the trace to "All" in the Asyc client configuration file? Have any Upload sessions been created?

    Regards,

    Steve

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans