offline database sync

Posted by R MOORE on September 12, 2006, 7:27 pm

Please log in for more thread options

My laptops are not updating the "offline" database when they are back online,
Z'd and signed back on, they update the main database with the offline sales,
but not the other way too update the offline one. Can you manually force
this update?? I have removed all firewalls, norton programs, and such to no
avail, local partner and one in Ohio have not come up with anything. The
updating worked fine both ways previously, but not now??
--
THANKS, RICK

Posted by Jeff on September 12, 2006, 11:24 pm

Please log in for more thread options

: quoted-printable

Rick,

Make sure that you've added SOManager.exe, SOPOSUser.exe and =
SQLServr.exe to your _any_ Firewall or turn it off to test. You must =
turn it off or allow the programs on _both_ ends!

We always set the database server machine's IP address to a static =
address and then use that IP address in the SO Admin server name field.

Also you need to make sure that you are logged in as an Administrator =
or as a Limited user that has rights to modify the registry. The key =
you need is HKEY_LOCAL_MACHINESOFTWAREMicrosoftRetail Management =
System | right click on it | Permissions | Allow Full Control for that =
user

You can also delete the existing offline database and re-create it in SO =
Admin. using the rmsdb.bck file. =20

Do a z-out

Any errors?

--=20
*
Get Secure! - www.microsoft.com/security

You must be using Outlook Express or some other type of newsgroup reader =
to
see and download the file attachment. If you are not using a reader, =
follow
the link below to setup Outlook Express. Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz

**********

My laptops are not updating the "offline" database when they are back =
online,=20
Z'd and signed back on, they update the main database with the offline =
sales,=20
but not the other way too update the offline one. Can you manually =
force=20
this update?? I have removed all firewalls, norton programs, and such =
to no=20
avail, local partner and one in Ohio have not come up with anything. =
The=20
updating worked fine both ways previously, but not now??
--=20
THANKS, RICK
------=_NextPart_000_0183_01C6D6A9.639E65A0
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable

=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.2900.2963" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Rick,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Make sure that you've added SOManager.exe,=20
SOPOSUser.exe and SQLServr.exe to your _any_ Firewall or turn it off to=20
test.  You must turn it off or allow the programs on _both_=20
ends!</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>We always set the database server machine's =
IP address=20
to a static address and then use that IP address in the SO Admin server =
name=20
field.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Also  you need to make sure that you are =
logged in=20
as an Administrator or as a Limited user that has rights to modify the=20
registry.  The key you need is=20
HKEY_LOCAL_MACHINESOFTWAREMicrosoftRetail Management System | right =
click on=20
it | Permissions | Allow Full Control for that user</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>You can also delete the existing offline =
database and=20
re-create it in SO Admin. using the rmsdb.bck file.  </FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Do a z-out</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Any errors?</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><BR>-- <BR>*<BR>Get Secure! - <A=20
href=3D"http://www.microsoft.com/security">www.microsoft.com/security</A>=
</DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express or some other type of newsgroup =
reader=20
to<BR>see and download the file attachment.  If you are not using a =
reader,=20
follow<BR>the link below to setup Outlook Express.  Click on "Open =
with=20
newsreader"<BR>under the MS Retail Management System on the right.</DIV>
<DIV> </DIV>
<DIV><A =
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A></DIV>
<DIV> </DIV>
<DIV>**********<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"R MOORE" <<A=20
=
soft.com</A>>=20
wrote in message <A=20
=
D91C8-0105-4D99-BA7E-69A6ABA814CF@microsoft.com</A>...</DIV>My=20
laptops are not updating the "offline" database when they are back =
online,=20
<BR>Z'd and signed back on, they update the main database with the =
offline=20
sales, <BR>but not the other way too update the offline one.  Can =
you=20
manually force <BR>this update??  I have removed all firewalls, =
norton=20
programs, and such to no <BR>avail,  local partner and one in =
Ohio have=20
not come up with anything.  The <BR>updating worked fine both =
ways=20
previously, but not now??<BR>-- <BR>THANKS, =
RICK</BLOCKQUOTE></BODY></HTML>

------=

Posted by Nashat on September 13, 2006, 3:25 am

Please log in for more thread options

I saw before an offline database that couldn't upload its offline sales to
the master database but the offline database was successfully updated ! which
is the opposite of what u r facing, the reason for that was -as jeff
mentioned- a registry access privileges.
RMS changes a flag in registry whenever it comes online or offline, and if
it can't write into registry, it fails to know that it was offline b4 and
therefore it doesn't even try to upload offline sales.
On the other side, updating the offline database is an automatic process
that comes upon z-out regardless it was offline or not, so i guess u might
have a different problem, which is the collation.
Please check the collation of the main database and the collation of the
offline databases, make sure they r all the same.

Nashat

"Jeff" wrote:

> Rick,

> Make sure that you've added SOManager.exe, SOPOSUser.exe and SQLServr.exe to

your _any_ Firewall or turn it off to test. You must turn it off or allow the
programs on _both_ ends!

> We always set the database server machine's IP address to a static address and

then use that IP address in the SO Admin server name field.

> Also you need to make sure that you are logged in as an Administrator or as a

Limited user that has rights to modify the registry. The key you need is
HKEY_LOCAL_MACHINESOFTWAREMicrosoftRetail Management System | right click on
it | Permissions | Allow Full Control for that user

> You can also delete the existing offline database and re-create it in SO

Admin. using the rmsdb.bck file.

> Do a z-out

> Any errors?

> --

> *

> Get Secure! - www.microsoft.com/security

> You must be using Outlook Express or some other type of newsgroup reader to

> see and download the file attachment. If you are not using a reader, follow

> the link below to setup Outlook Express. Click on "Open with newsreader"

> under the MS Retail Management System on the right.

> http://tinyurl.com/75bgz

> **********

> My laptops are not updating the "offline" database when they are back

online,

> Z'd and signed back on, they update the main database with the offline

sales,

> but not the other way too update the offline one. Can you manually force

> this update?? I have removed all firewalls, norton programs, and such to no

> avail, local partner and one in Ohio have not come up with anything. The

> updating worked fine both ways previously, but not now??

> --

> THANKS, RICK