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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics RMS (Archived)

Error logs?

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Community Member Profile Picture
    on at

    Depends. What kind of error are you facing?

  • Community Member Profile Picture
    on at

    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.

  • Community Member Profile Picture
    on at

    *bump*

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

    -2147467259 ?  What are the words?

    Have you searched the error message in this forum/community?

  • Community Member Profile Picture
    on at

    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?

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

    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"

  • Community Member Profile Picture
    on at

    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?

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

    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!!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans