Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Retail Transactions no...
Finance | Project Operations, Human Resources, ...
Unanswered

Retail Transactions not Syncing

(1) ShareShare
ReportReport
Posted on by Ahmed ElDeeb 83 5

The retail transactions are not pulling from Channel database of one particular store to AX HQ database, so we “reset” the channel database to re-upload all records into a new RPF file, we followed the below steps:

  1. Stop the AsyncClient in the StoreDB machine
  2. Make a backup of the Channel Database
  3. Delete records from table crt.TABLEREPLICATIONLOG
  4. Start the Async Client
  5. Run the P-job

 

After that we found that the P-0001 job was unable to sync the transactions from Channel database of one particular store to the AX database. Whereas at the same time, all the 9999 jobs (sync from AX database to channel database) were working fine and also the P-0001 job (sync from channel database to the AX database) for all remaining store was working fine.

 

I can see new RPF files is created in upload folder but no change in AX data also CRT.TABLEREPLICATIONLOG table is not populating the records, When I check the Event Viewer in the Channel Database server of that store, I see the below error message:

 

Failed to upload session data of uploadSessionId 296710 for DataStore with name : 789SDB due to Exception. Error Detail: System.IO.IOException: The process cannot access the file '\\AX-live\AXRetail\upload\789SDB\789SDB-296710-R.rpf' because it is being used by another process.

   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)

   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)

   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share)

   at Microsoft.Dynamics.Retail.SynchService.DataManager.UploadSessionDataManager.UploadSessionData(String dataStoreName, Int64 uploadSessionId, Byte[] data)System.IO.IOException: The process cannot access the file '\\AX-live\DramaAXRetail\upload\789SDB\789SDB-296710-R.rpf' because it is being used by another process.

   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)

   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)

   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share)

   at Microsoft.Dynamics.Retail.SynchService.DataManager.UploadSessionDataManager.UploadSessionData(String dataStoreName, Int64 uploadSessionId, Byte[] data)

 

We followed the below steps:

  1. Clearing the RPF files out of the upload working folder
  2. Truncate the RETAILCDXUPLOADSESSION out of the AX DB
  3. Truncate the CRT.TABLEREPLICATIONLOG in the Store DB.
  4. Install again Async Client service, with a new message DB.
  5. Create channel data group
  6. Create a copy of P-001 job
  7. Sync Metadata after changing the job,
  • Vysakh Profile Picture
    Vysakh 135 on at
    RE: Retail Transactions not Syncing

    We removed the channel database and prepared a fresh new database. The store team re-entered the missing sales on the POS and they got pulled to HQ somehow.

    Granted, this is not a proper solution and it is only a workaround.

  • AX POS Profile Picture
    AX POS 10 on at
    RE: Retail Transactions not Syncing
    Hi,
    I've followed below step, but still can not identify which process is holding the file as error in the event view.
    ---------
    Identify what program is using a file
    Using Process Explorer there is a simple way to find the program:
    Open Process Explorer (running as administrator).
    On the toolbar, find the gunsight icon on the right.
    Drag the icon and drop it on the open file or folder that is locked.
    The executable that is using the file will be highlighted in the Process Explorer main display list.
    Identify which handle or DLL is using a file
    Open Process Explorer (running as administrator).
    Enter the keyboard shortcut Ctrl+F.
    Alternatively, click the “Find” menu and select “Find a Handle or DLL”. A search dialog box will open.
    Type in the name of the locked file or other file of interest. Partial names are usually sufficient.
    Click the button “Search”.
    A list will be generated. There may be a number of entries.
    And then kill this process.
    ----
    Anyone have the resolution?
    Any help?
    Thanks.
  • AX POS Profile Picture
    AX POS 10 on at
    RE: Retail Transactions not Syncing

    hi Ahmed,

    We're facing the same issue, do you resolve it?

    Thanks

  • Vysakh Profile Picture
    Vysakh 135 on at
    RE: Retail Transactions not Syncing

    Hi Ahmed,

    Can you clarify how you resolved this issue?

  • Ramune Profile Picture
    Ramune on at
    RE: Retail Transactions not Syncing

    Hi Ahmed,

    If you have a project on LCS environment, from there you can create a support ticket.

  • Ahmed ElDeeb 83 Profile Picture
    Ahmed ElDeeb 83 5 on at
    RE: Retail Transactions not Syncing

    Thanks for your reply, could you please let me know how can I create support ticket

  • Ramune Profile Picture
    Ramune on at
    RE: Retail Transactions not Syncing

    Hi Ahmed,

    I will leave this for the community to answer. Let's see if anybody has experienced the same and can advise for you anything. If you will not get any help there, please create a support ticket for us.

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

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,289 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,068 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans