Store Operations Business Rules Error - A server failure occurred while attempting to read Cashier


K

Kaibin

I am having a problem with POS registers recently.
Since the last 3 days, when the cashiers log-in to the POS in the morning,
the system does not allow them entry (after a minute freeze) and displays
the following error message:

Store Operations Business Rules

! Error # -2147217871
Timeout expired
(Source: Microsoft OLE DP Provide for SQL Server) (Native Error:0) No Help
File Available UPDATECashier SET Failed logon Attempts=0 WHERE Number =?

When I click on ¡®OK¡¯ then I get the following message:

X Server Failure 135
A server failure occurred while attempting to read Cashier Error
# -2147217871
(Source: Microsoft OLE DP Provide for SQL Server) (Native Error:0) No Help
File Available UPDATECashier SET Failed logon Attempts=0 WHERE Number =?

The only way I could get the system to work again is to restart the
backoffice in the morning. Everything is ok then. The same problem
re-occurs again the following morning!

I can¡¯t figure out why this problem is occurring all of a sudden. Can
anyone tell what to do?

TIA
 
G

Glenn Adams [MVP - Retail Mgmt]

That really has nothing to do with the cashier - you've just lost connection
to the SQL Server for some reason. Either the backoffice or register may
have gone into power save mode. The router may have been reset. You may
have had a power outage. If this only happens after a period of inactivity,
I'd look at power settings first - something is probably going to sleep.
 
Ad

Advertisements

K

Kaibin

Problem is fixed now. It turns out that the Database Log file grew to 38
Gbyte!!! And we shrunk it down again.
 
Ad

Advertisements

M

Mark

Kaibin said:
Problem is fixed now. It turns out that the Database Log file grew to 38
Gbyte!!! And we shrunk it down again.
Two possibilities:
1) You didn't use the default settings in Administrator when you setup MSDE
for RMS.
2) You have the full version of SQL and have the incorrect settings.

In either case you need to fix the settings or this problem will return.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

South Africa COS for small service industry business 0
UK Starting new business 2
Seeking Guidance On Business Forecasting Tools & Services 0
USA Business bad debt or non buisness bad debt 0
UK Service items 1
USA CapEx or OpEx? 0
USA Error Correction 7
USA Owner contribution in business 4

Top