offline sync problem

Posted by Rich on December 18, 2005, 10:25 pm

Please log in for more thread options

Yesterday I had a customer's 8 register system lose internet connectivity, so
all the registers went off-line. They are using RMS 1.2 SR3 on a SBS
Professional 2003 Server with XP SP2 registers. When internet connectivity
was restored today, all but one of the registers sync'd. On the register
that did not, the last transaction in the batch was at about 7:40pm
yesterday. No transactions were recorded after that time. I manually took
the register off-line today and could not find any batch or blind-closed
batch with any transactions after 7:40pm.

I also checked, via MS Access and ODBC connection, the TRANSACTION table and
no transactions recorded, either normally or off-line tagged.

Next I tried to connect via ODBC to the local register database, but it
looks like there are no transactions there. (If I had the right database?)

How do you ODBC connect via MS Access to the local registers off-line
database? What should I see in the TRANSACTION table there either before or
after an off-line sync?

Thanks for your help.
--Rich

Posted by Dak on March 13, 2006, 4:44 pm

Please log in for more thread options

First thing I would check is to make sure the transactions did not actualy
get uploaded to the main DB.

I would not know what you named your DBs but all transactions on a register
either talk to the main DB or the offline DB.

The basic databases you will find on a clean install are:
master
model
msdb
Northwind
pubs
tempdb

Anything other then that would be one that you put on the system.

As for what information you should find, for an offline DB you should find
transactions on the offline DB. Typicly you should only find the ones that
that register did while on offline mode. If the transactions table is empty
then they either did not get recorded (odd) or they did in fact get uploaded
to the DB.

In the main DB check the register numbers, date and time on the transactions
to located all the ones for the down time and see if it has any of the
transactions from that register druing that time.

Good luck,
Dak

"Rich" wrote:

> Yesterday I had a customer's 8 register system lose internet connectivity, so

> all the registers went off-line. They are using RMS 1.2 SR3 on a SBS

> Professional 2003 Server with XP SP2 registers. When internet connectivity

> was restored today, all but one of the registers sync'd. On the register

> that did not, the last transaction in the batch was at about 7:40pm

> yesterday. No transactions were recorded after that time. I manually took

> the register off-line today and could not find any batch or blind-closed

> batch with any transactions after 7:40pm.

> I also checked, via MS Access and ODBC connection, the TRANSACTION table and

> no transactions recorded, either normally or off-line tagged.

> Next I tried to connect via ODBC to the local register database, but it

> looks like there are no transactions there. (If I had the right database?)

> How do you ODBC connect via MS Access to the local registers off-line

> database? What should I see in the TRANSACTION table there either before or

> after an off-line sync?

> Thanks for your help.

> --Rich