Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

messing transactios when upload data from store to HQ

Posted on by Microsoft Employee

Hi everyone 

i have problem with uploading data from store database to ax database 

some of the transactions not send to ax database and to fix that i had to run this code in the store database "truncate table crt.TABLEREPLICATIONLOG" after that all transactions sent to ax database.. the problem is that i have to repeat that every day 

can you help me to fix this issue for one time solution

  

*This post is locked for comments

  • RE: messing transactios when upload data from store to HQ

    Can you please check the Async client Async server logs for any clue of the failed transactions

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: messing transactios when upload data from store to HQ

    there is no failed session ... we have more the 10 branches in every branch has store database and all of them has same issue  

  • RE: messing transactios when upload data from store to HQ

    Hi,

    Do you get the transactions failed in the upload sessions or you are missing the generated RPF files?

    In case of failed upload sessions  you can click retry only the failed session.

    Thanks

    Kathiravan T

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: messing transactios when upload data from store to HQ

    network is fine

  • Suggested answer
    Hassan_rulz Profile Picture
    Hassan_rulz 3,801 on at
    RE: messing transactios when upload data from store to HQ

    What is the networking status? have you tried pinging between pos and store server? is there any time out or high latency?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: messing transactios when upload data from store to HQ

    HI Hassan

    AX version is 2012 R3 with CU12

    we have Aos server and stoer server in another location conected  throw vpn and pos connect to store database throw LAN network

  • Suggested answer
    Hassan_rulz Profile Picture
    Hassan_rulz 3,801 on at
    RE: messing transactios when upload data from store to HQ

    Please share retail architecture and AX version.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans