You’re offline. This is a read only version of the page.
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 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!!!
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.
Depends on the problem please explain
Has there been a solution to this ?
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/
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (