Does RMS log errors anywhere? I don't see anything in the Windows Event Viewer and there doesn't appear to be anything useful under ...\Store Operations\Logs\
*This post is locked for comments
We only sell UPS devices that have an Automatic Voltage Regulator (AVR) in them. What that means is that power comes from the UPS continuously, not like most that are Stand By or Switching. Both of those sense the outage and turn on, if you will, and supply power to the computer. Sometimes the switching isn't fast enough. $10-20 difference, but worth it
That setting is for all SQL installs, Express or not. It all depends on how much memory you've got. and how much you want to give SQL. Non Express versions can/will use all of the RAM the machine has, eek!!
Thanks for the suggestions. I've done most of that already. I've been planning on trying adding a UPS to see if that makes any difference...server and network switch are on a UPS but registers/workstations aren't currently. Is there a basic UPS you recommend?
Would the max server memory setting just be for a full SQL version since Express can only use 1GB I believe?
You are losing network connections. POS checks every second to see if there is a network connection. If not there, up pops the error.
Is every device, computers, network switch/router/hub on a battery backup? They must be on the battery side.
Turn off the power saving on the network card. Update the network card driver.
Create a static IP address for the database server machine and point to it in SO Admin | File | Connect and | File | Configuration, then add it to the Client Network Utility | move Named Pipes and TCP/IP to the right | Alias tab | Add | enter the IP address of the Server and select TCP/IP on the left | Add | Named Pipes and the Server's name as a second line.
If using SQL Express, set it to not sleep. SO Admin | Query | New | add the following 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
-- Turn off AutoClose in Express versions
EXEC sp_dboption 'databasename', 'autoclose', 'FALSE'
RECONFIGURE WITH OVERRIDE
-- Change Recovery Mode to Simple to prevent log file growth
ALTER DATABASE "databasename" SET RECOVERY SIMPLE
Change the databasename to your name in the last two lines and change the memory amount per the "Set max server memory"
The one I see the most often is General network error, SELECT GETDATE() AS CurrentDateTime. I have searched this forum and the old microsoft.public.pos newsgroup and tried every possible solution I've found with no effect. It continues to happen on all registers and backoffice computers at seemingly random times.
So apparently there's no way to get RMS to log these kind of errors in the event log or anywhere else?
-2147467259 ? What are the words?
Have you searched the error message in this forum/community?
*bump*
Database connection errors are what I'm looking to see currently. ie. error -2147467259 I'd like to see how often it's happening and try to determine if there's any pattern.
Depends. What kind of error are you facing?
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (