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

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) / Loyalty Transaction at...
Microsoft Dynamics AX (Archived)

Loyalty Transaction at Offline Mode Takes Almost 1 Minutes to Complete

(1) ShareShare
ReportReport
Posted on by Community Member

Hello,

I have a problem when switching to offline mode in Retail POS AX 2012. 

When there is no connection between the POS to the retail server, the POS will switched to offline mode. The regular customer and loyalty customer transaction went smooth when using this mode. However, when the loyalty customer (not regular customer) want to pay the item (pay cash or pay card), the process took very long time and it showed "Updating accrued loyalty point" text in the screen for almost 1 minute and then it printed the receipt. Normally, when using online mode (connected to the retail server), that process only takes about 1 second to finish the transaction and printed the receipt. As you know, customers won't accept that they have to wait almost 1 minute to finish the transaction.

I was using SQL Profiler to figure out why the process was so long, and i saw that every 10 seconds the system will check RETAILTERMINALSYNCSTATUS whether the field isOffline is true or false. And the checking process happens 5 times in a single loyalty transaction. So, it takes about 50 seconds to complete the loyalty transaction. 

Any idea how to solve this problem? Can i shortened the interval or can i modify the checking process, so whenever it is offline mode, it won't check the sync status because it's offline.

Thanks in advance

*This post is locked for comments

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

    Hi Yonathan,

    By default, the offline service check every 10 seconds if the POS is online or offline to synchronize data.

    Verify Microsoft.Dynamics.Retail.Offline.Service.exe.config file
    Parameter SyncInterval 
      <value>00:00:10</value>
    (Increase the time value, according to your business need)

    Parameter SyncInParalelel
       <value>true</value>

    (Change to "false" so that synchronization does not occur in parallel, this reduces the use of CPU / Memory resources)

    I Hope this Helps!

    Regards,

    Rodolfo Recalde.

  • Community Member Profile Picture
    Community Member on at

    Hi Rodolfo,

    Thank you for the answer. I have check that before, but unfortunately the sync interval can't be reduced to below 10 seconds. Can we disable the sync interval if the POS was in offline mode?

    I already got the issue now, the waiting time (50 seconds) is happening because our client's loyalty scheme is set to realtime. So it updates automatically to the server if the member earns a loyalty point. Therefore, whenever the loyalty transaction occurs in the offline mode (standalone because of lost connection to the retail server), the POS system still do a connection check (sync interval) to the retail server even though the status is offline.  That's why we have to wait almost 50 seconds in order to complete the transaction, because it checking the connection 5 times every 10 seconds before the transaction finished. It's like why the system need to check 5 times within the interval 10 seconds before the system finally know that the connection status is offline and finishing the transaction.

    My question is, Can we disabled sync status? So, whenever the connection status is in offline mode, the sync process is not happen.

    Regards,

    Yonathan

  • Verified answer
    Rodolfo Recalde Profile Picture
    Rodolfo Recalde on at

    No. Not disable sync status. You need to sync the data when the service comes online.

    What is the AX version? CU10? CU11? Is it EPOS or MPOS ?

    I'll check later on SQL profile this behavior in my environment.

    Also, check that these KBs are update in your test environment. Maybe, after installing, you may have some different result.

    KB 3195075 Retail Offline Sync is not cleaning up RETAILOFFLINESYNCLOG table

    PROBLEM
    Retail Offline Sync is not cleaning up RETAILOFFLINESYNCLOG table
    DESCRIPTION OF CHANGE
    Data was not getting removed from the incorrect table so fix is to update the correct table name
     

    *****

    *****

    KB 3190175 Retail Terminal Sync Status is not always updated, which causes the sync service not to sync the transaction.

    PROBLEM
    Retail Terminal Sync Status is not always updated, which causes the sync service not to sync the transaction.
    DESCRIPTION OF CHANGE
    The fix includes changes to show a message to the user indicating that offline DB specified in the configuration file is not accessible and confirm it is ok to switch to online DB

    throw new PosisException(LSRetailPosis.ApplicationLocalizer.Language.Translate(99525));

    *****

    *****

    KB 3124589 High load on Store server due to Offline Synchronization

    Release: CU11
    PROBLEM
    High load is on Store server due to Offline Synchronization.

    DESCRIPTION OF CHANGE
    The changes in the hotfix resolve this issue. When RetailOfflineService is checking the time in the RetailOfflineSynclog, it logs an entry that time changed since last check and will not execute synchronization API call if it didn't reach the next sync frequency time.
    *****
    *****
    I Hope this Helps!
    Regards,
    Rodolfo Recalde.

     

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans