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 RMS (Archived) / Slow CC Processing - N...
Microsoft Dynamics RMS (Archived)

Slow CC Processing - Need help

(0) ShareShare
ReportReport
Posted on by billy v 225

Hello,

 we just finally got our RMS system upgraded to 2.01 (the latest) with all the service packs and hotfixes.  Now at two of my stores I'm getting complaints about slow credit card processing.  At some times, it takes a full 5 minutes before a card will process and post transaction.  

 Its getting to where the customers are getting their food before they are done paying, and they have to wait for the receipt to sign...which in the morning can cause a fuss when people want coffee.  

 both stores have excellent internet speeds so I know it isn't that.  Can anyone help?

*This post is locked for comments

I have the same question (0)
  • Gary Matherne Profile Picture
    Gary Matherne 5 on at

    It shouldn't take any longer than 10 seconds for that transaction to process. Bot Credit or Debit cards. If it is IP than you could have an issue with your processing provider. Are you processing through RMS or PC charge? I deal with a lot of RMS customers that we process for if you would like us to help you with the situation. Please contact me if you have any questions at 888-274-2323 ext 110 Gary Matherne.

  • Dave Durrenberger Profile Picture
    Dave Durrenberger 1,622 on at

    Which portion of the transaction is actually slow: a) authorization or b) receipt printing or c) hard to discern.  This can be resolved I'm sure.  If you would like some assistance contact us: http://www.syssolutionsllc.com/

  • jachterberg Profile Picture
    jachterberg 85 on at

    Has there been a solution to this ?

  • Priority Payment Systems Gulf Coast Profile Picture
    Priority Payment Sy... 5 on at

    Depends on the problem please explain

  • jachterberg Profile Picture
    jachterberg 85 on at

    When posting a cc transaction it can take up to 5 minutes to actually print out the receipt. It happens on checks and cc transactions and it just sits on the posting transaction screen. I looked at the transaction log and it was 242 GB. I was not the one who initially set this up. What I think happened is who ever set this up set the log file to grow by 10%. So this log file is getting bigger and bigger and eventually it takes a while to post transactions to the log file.

    What I was able to do since I posted my last question above is, I went into Management Studio Express and shrunk the file. I did this late yesterday and since they haven't had any problems. Its hard to say for sure if this actually fixed their issue, because before I performed this "fix" they could have gone hours without having issues and then all of a sudden they will get an error or it will take a long time to post the transaction.

    The error that they get every so often is "error # 21472117871 Query timeout Expired ( Source: Microsoft OLE DB Provider for SQL Server) ( SQL State: HYTOO Native Error:0) No Help File Available update cashier Set"

    If you have any insight to what may be causing this that would be great.

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,382 on at

    I would try setting the log-file to "Simple" and see if it fixes things;

    We run the following when setting up SQL for RMS in SO/HQ Admin or Studio Express;

    BACKUP FIRST!!!

    Be sure to change the 'databasename' in the last 2 command lines.

    -- Turn on advanced options

    EXECUTE SP_CONFIGURE 'show advanced options', 1

    RECONFIGURE WITH OVERRIDE

    -- Set max server memory = 6400MB for an 8g Server machine  -- 1/2 for 4g

    EXEC  sp_configure'max server memory (MB)',6400;

    RECONFIGURE WITH OVERRIDE

    -- Turn on Ad Hoc Queries

    EXECUTE SP_CONFIGURE 'Ad Hoc Distributed Queries', '1'

    RECONFIGURE WITH OVERRIDE

    -- Turn off advanced options

    EXECUTE SP_CONFIGURE 'show advanced options', 0

    RECONFIGURE WITH OVERRIDE

    -- Change Recovery Mode to Simple to prevent log file growth

    ALTER DATABASE "databasename" SET RECOVERY SIMPLE

    -- Turn off AutoClose in Express versions

    EXEC sp_dboption 'databasename', 'autoclose', 'FALSE'

    BACKUP FIRST!!!

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 RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans