Rms issues after server migration

(0) Share

Report

Posted on by Community Member Microsoft Employee

I am hoping the combined knowledge of everyone here can help me isolate and resolve an ongoing issue.

first for some background, we have just finished moving our 3 retail stores through a domain migration from a separate forest, into a new child domain. We have also moved the RMS store databases onto new Virtual servers running server 2008 R2. Each of our 3 store databases runs on its own instance of Sql express 2008 R2, and our HQ database runs on SQL 2005 Full.

we have everything spread across 3 servers like so:

Store 1: server 2008 R2 runs sql express 2008 r2 for store, and also sql 2005 full for HQ as separate instances on the same box, with 8gb of ram

Store 2: server 2008 R2 runs sql express 2008 r2 for store, with 4gb ram

Store 3: server 2008 R2 runs sql express 2008 r2 for store, with 4gb ram

We have come across an issue since the migration. the issue is that we have tills that are randomly pausing at the posting transaction screen, with nothing printing and will sometimes go through and sometimes fail and drop the transaction.

- we have verified our sql server settings, have set our tills network utility for the pipes and tcp / aliases as I have seen suggested on the forum already. Also our Databases are set to grow only be 20mb and not the 10% default. The strange things about this is it will not affect more then 1 till at a time. so one day till 1 may be pausing and dropping with everything else fine, then the next day its till 2.

Now this is only happening at 1 store, the other 2 have stopped after adjusting the above issues, and its out store 2 with the issue.

the tills are all windows 7 32-bit and run their own local sql express DB for offline transactions. they are also all using DHCP on the network.

if anyone have the knowledge and time to assist me, i would like to find the source of this issue and rectify it.

*This post is locked for comments

All responses (8)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Rms issues after server migration

We have been testing the 1.14 CCO and I cannot say it has made any difference.

I did notice however when an x report had failed that someone had set the POS app to load a .jpg for the storelogo file, which is odd as opos cannot use .jpgs. Afte clearing that off it seems like it has settled down a bit but we are still seeing issues.

Currently i'm trying to log a frozen/delayed transaction while running procmon and wireshark to try and get some additional data as to whats up. But this is a really strange issue.
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Rms issues after server migration

I havent tried the 1.14 CCO but definitely stay away from 1.13.

You could try the Epson provided USB to Serial driver and then set the OPOS to serial instead of USB.

Also make sure to turn off power management for the usb root/hub under Device Manager.

Thanks
Community Member Microsoft Employee on at

Like (0)

Report

RE: Rms issues after server migration

We have TM 88 -III / IV / V 's across our sites. all running usb connections.

This happens on multiple tills at multiple stores so we know its not just 1 specific printer.

the issue does not seem to occur with windows drivers, but we need to use opos for some of our add-ons.

we have tried 2.5, 2.6, and 2.7 opos drivers.

we are currently look at trying the newer 1.14 CCO and see if that plays nicer or not.
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Rms issues after server migration

Try the last 2.6 version release of the epson opos adk. Do not use the 2.7 version.

What model of TM88? 1, II , III, IV, or V. I assume at least model 3 or newer.

Which interface, i.e serial, parallel, network/ ethernet, usb, 485 etc..

Does the windows drivers have any problems at all. Can we rule out the print itself? Can we rule out a receipt image processing within RMS?

Thanks

Ed
Community Member Microsoft Employee on at

Like (0)

Report

RE: Rms issues after server migration

Sorry for not getting back sooner, was on a much needed vacation :)

Things have progressed in finding the root cause. As of right now the issue seems to be caused by our receipt printers. We use Epson Tm-88 printers and they will randomly start take 5-10 mins to print a receipt and thus stop the transaction from finishing. as of now we can clear up the problem by power cycling the printer and till. We have tried using the Epson windows drivers which works great, but the downside is that we have some add-ons that can only use OPOS printing so thats not a real solution. we have been trying out different version of opos drivers to see if we can find one that works better though.

Hopefully someone who knows a bit more about this than I can shed some further light on the problem.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Rms issues after server migration

use static ip addresses for the servers and the stations. If the dhcp renews, there is a slight pause when that happens. Also there is a possibility that the ip address received will be different.

We also turn off IPv6 in windows 7 and 2008R2 on each network interface.

Also did you install the 2005 backwards compatibility pack on each sql express 2008r2 machine?
Community Member Microsoft Employee on at

Like (0)

Report

RE: Rms issues after server migration

The servers are all located in their respective local stores.
RON LIME 245 on at

Like (0)

Report

RE: Rms issues after server migration

Are the store SQL Express instances physically local to the store or across a network? We had a client where the DB's were on VM's in a data center miles away and had the pausing issue also. They gave in an bought a physical server and made it local to the store POS and the problem is resolved.