HQ Client Sync Error on 250/260 Sheet


HQ Client Sync Error on 250/260 Sheet

Groups | Search | About

User Password

Lost Password?

Point-Of-Sale Software - - MS Point Of Sale software discussed here

get this group's latest topics as an RSS feed

add this group's latest topics to your My MSN content

add this group's latest topics to your My Yahoo content

add this group's latest topics to your Google content

Yahoo!

Google

Windows Live

del.icio.us digg

digg

Netscape

Subject

Author

Date

HQ Client Sync Error on 250/260 Sheet

Floppy Cow

04-20-2007

RE: HQ Client Sync Error on 250/260 Sheet

Joh

04-23-2007

Re: HQ Client Sync Error on 250/260 Sheet

Jeff @ Check Po...

05-01-2007

Posted by Floppy Cow on April 20, 2007, 12:20 pm

Please log in for more thread options

We are creating a rather large worksheet 250/260(> 33,000 items). It works
fine on one of our stores (running SQL 2000 SP4 same location as HQ) without
any issues. When we run the worksheets for the other store (SQL 2005
Express), it runs for an indetminiate time (about an hour) and fails. The
worksheets run if we break the number down to less than 5000 items. We
adjusted the time on the HQ Client in the registry as recommended. We are
now recieving a new error message related to this syncronization.

Here's the error message in the HQ Client Log:
Download Items-Stag
4/20/2007 12:06:40 PM Ref. No.: 52743
4/20/2007 12:07:02 PM Updated 3 record(s) in table 'QuantityDiscount'.
4/20/2007 12:07:03 PM Updated 3 record(s) in table 'ItemClass'.
4/20/2007 12:17:31 PM <<ExecuteCommand>> Error -2147467259:
[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network
documentation.
SELECT #Temp.* INTO #TempInsert
FROM #Temp LEFT JOIN Item ON (#Temp.HQID = Item.HQID) OR (Item.HQID=0

4/20/2007 12:17:34 PM <<OpenRsRead>> Error -2147467259: Connection failure
SELECT * FROM [#TempInsert]
4/20/2007 12:17:34 PM An error occurred while attempting to Update
Inventory Structure.
4/20/2007 12:17:34 PM An error occurred while attempting to Update
Inventory Structure.
4/20/2007 12:17:34 PM Not completed due to errors encountered during
processing.

After clicking OK on the error message the client gets into a loop with the
following error repeating itself:

4/20/2007 12:17:36 PM <<CStateMachine::ExecuteState>> Error 3246:
Connection object cannot be explicitly closed while in a transaction.
(Unhandled Error, state = '9')
4/20/2007 12:17:36 PM An error was detected, connection will be aborted.

Posted by John M on April 23, 2007, 10:46 am

Please log in for more thread options

Anyone have anything more to share.
We are seeming to have network issues:

"Floppy Cow" wrote:

> We are creating a rather large worksheet 250/260(> 33,000 items). It works

> fine on one of our stores (running SQL 2000 SP4 same location as HQ) without

> any issues. When we run the worksheets for the other store (SQL 2005

> Express), it runs for an indetminiate time (about an hour) and fails. The

> worksheets run if we break the number down to less than 5000 items. We

> adjusted the time on the HQ Client in the registry as recommended. We are

> now recieving a new error message related to this syncronization.

> Here's the error message in the HQ Client Log:

> Download Items-Stag

> 4/20/2007 12:06:40 PM Ref. No.: 52743

> 4/20/2007 12:07:02 PM Updated 3 record(s) in table 'QuantityDiscount'.

> 4/20/2007 12:07:03 PM Updated 3 record(s) in table 'ItemClass'.

> 4/20/2007 12:17:31 PM <<ExecuteCommand>> Error -2147467259:

> [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network

> documentation.

> SELECT #Temp.* INTO #TempInsert

> FROM #Temp LEFT JOIN Item ON (#Temp.HQID = Item.HQID) OR (Item.HQID=0

> 4/20/2007 12:17:34 PM <<OpenRsRead>> Error -2147467259: Connection failure

> SELECT * FROM [#TempInsert]

> 4/20/2007 12:17:34 PM An error occurred while attempting to Update

> Inventory Structure.

> 4/20/2007 12:17:34 PM An error occurred while attempting to Update

> Inventory Structure.

> 4/20/2007 12:17:34 PM Not completed due to errors encountered during

> processing.

> After clicking OK on the error message the client gets into a loop with the

> following error repeating itself:

> 4/20/2007 12:17:36 PM <<CStateMachine::ExecuteState>> Error 3246:

> Connection object cannot be explicitly closed while in a transaction.

> (Unhandled Error, state = '9')

> 4/20/2007 12:17:36 PM An error was detected, connection will be aborted.

Posted by Jeff @ Check Point Software on May 1, 2007, 4:50 pm

Please log in for more thread options

: quoted-printable

John,

Stop HQ Server and try searching your computer for QS_*.tmp files and =
delete them. Then restart the HQ Server

Re-index both ends HQ and SO

You have a 60 minute timeout set in the Registry. If a HQ Client =
session takes longer than that, it closes the connection.

--=20

Jeff=20
Check Point Software

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

You must be using Outlook Express/Windows Mail or some other type of =
newsgroup reader to
see and download the file attachment(s). 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
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

Anyone have anything more to share.
We are seeming to have network issues:

"Floppy Cow" wrote:

> We are creating a rather large worksheet 250/260(> 33,000 items). =
It works=20
> fine on one of our stores (running SQL 2000 SP4 same location as HQ) =
without=20
> any issues. When we run the worksheets for the other store (SQL =
2005=20
> Express), it runs for an indetminiate time (about an hour) and =
fails. The=20
> worksheets run if we break the number down to less than 5000 items. =
We=20
> adjusted the time on the HQ Client in the registry as recommended. =
We are=20
> now recieving a new error message related to this syncronization.
>=20
> Here's the error message in the HQ Client Log:
> Download Items-Stag
> 4/20/2007 12:06:40 PM Ref. No.: 52743
> 4/20/2007 12:07:02 PM Updated 3 record(s) in table =
'QuantityDiscount'.
> 4/20/2007 12:07:03 PM Updated 3 record(s) in table 'ItemClass'.
> 4/20/2007 12:17:31 PM <<ExecuteCommand>> Error -2147467259:=20
> [DBNETLIB][ConnectionRead (recv()).]General network error. Check =
your network=20
> documentation.
> SELECT #Temp.* INTO #TempInsert=20
> FROM #Temp LEFT JOIN Item ON (#Temp.HQID =3D Item.HQID) OR =
(Item.HQID=3D0=20
>=20
> 4/20/2007 12:17:34 PM <<OpenRsRead>> Error -2147467259: Connection =
failure
> SELECT * FROM =
[#TempInsert]
> 4/20/2007 12:17:34 PM An error occurred while attempting to Update=20
> Inventory Structure.
> 4/20/2007 12:17:34 PM An error occurred while attempting to Update=20
> Inventory Structure.
> 4/20/2007 12:17:34 PM Not completed due to errors encountered =
during=20
> processing.
>=20
> After clicking OK on the error message the client gets into a loop =
with the=20
> following error repeating itself:
>=20
> 4/20/2007 12:17:36 PM <<CStateMachine::ExecuteState>> Error 3246:=20
> Connection object cannot be explicitly closed while in a =
transaction.=20
> (Unhandled Error, state =3D '9')
> 4/20/2007 12:17:36 PM An error was detected, connection will be =
aborted.
>=20
>
------=_NextPart_000_0382_01C78BF7.BAFE00E0
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.6000.16414" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>John,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Stop HQ Server and try searching your =
computer for=20
QS_*.tmp files and delete them. Then restart the HQ Server</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Re-index both ends HQ and SO</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>You have a 60 minute timeout set in the =
Registry. =20
If a HQ Client session takes longer than that, it closes the=20
connection.</FONT></DIV>
<DIV><BR>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV> </DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express/Windows Mail or some other type =
of=20
newsgroup reader to<BR>see and download the file attachment(s).  If =
you are=20
not using a reader, follow<BR>the link below to setup Outlook =
Express. =20
Click on "Open with newsreader"<BR>under the MS Retail Management System =
on the=20
right.</DIV>
<DIV> </DIV>
<DIV><A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"John M" <<A=20
=
ft.com</A>>=20
wrote in message <A=20
=
B71D3-7338-4150-92FE-99D66DCC8AF9@microsoft.com</A>...</DIV>Anyone=20
have anything more to share.<BR>We are seeming to have network=20
issues:<BR><BR><BR>"Floppy Cow" wrote:<BR><BR>> We are creating a =
rather=20
large worksheet 250/260(> 33,000 items).  It works <BR>> =
fine on=20
one of our stores (running SQL 2000 SP4 same location as HQ) without =
<BR>>=20
any issues.  When we run the worksheets for the other store (SQL =
2005=20
<BR>> Express), it runs for an indetminiate time (about an hour) =
and=20
fails.  The <BR>> worksheets run if we break the number down =
to less=20
than 5000 items.  We <BR>> adjusted the time on the HQ Client =
in the=20
registry as recommended.  We are <BR>> now recieving a new =
error=20
message related to this syncronization.<BR>> <BR>> Here's the =
error=20
message in the HQ Client Log:<BR>> Download Items-Stag<BR>> =
4/20/2007=20
12:06:40 PM  Ref. No.: 52743<BR>> 4/20/2007 12:07:02 PM  =
Updated=20
3 record(s) in table 'QuantityDiscount'.<BR>> 4/20/2007 12:07:03 =
PM =20
Updated 3 record(s) in table 'ItemClass'.<BR>> 4/20/2007 12:17:31 =
PM =20
<<ExecuteCommand>> Error -2147467259: <BR>>=20
[DBNETLIB][ConnectionRead (recv()).]General network error. Check your =
network=20
<BR>> documentation.<BR>> SELECT #Temp.* INTO #TempInsert =
<BR>>=20
FROM   #Temp LEFT JOIN Item ON (#Temp.HQID =3D Item.HQID) OR =

(Item.HQID=3D0 <BR>> <BR>> 4/20/2007 12:17:34 PM =20
<<OpenRsRead>> Error -2147467259: Connection=20
=
failure<BR>>         &nbs=
p;           &nbsp=
;            =
            &=
nbsp;=20
SELECT * FROM  [#TempInsert]<BR>> 4/20/2007 12:17:34 PM  =
An error=20
occurred while attempting to Update <BR>> Inventory =
Structure.<BR>>=20
4/20/2007 12:17:34 PM  An error occurred while attempting to =
Update=20
<BR>> Inventory Structure.<BR>> 4/20/2007 12:17:34 PM  Not=20
completed due to errors encountered during <BR>> =
processing.<BR>>=20
<BR>> After clicking OK on the error message the client gets into a =
loop=20
with the <BR>> following error repeating itself:<BR>> <BR>> =
4/20/2007=20
12:17:36 PM  <<CStateMachine::ExecuteState>> Error =
3246:=20
<BR>> Connection object cannot be explicitly closed while in a =
transaction.=20
<BR>> (Unhandled Error, state =3D '9')<BR>> 4/20/2007 12:17:36 =
PM  An=20
error was detected, connection will be aborted.<BR>>=20
<BR>></BLOCKQUOTE></BODY></HTML>

------=

Similar Threads	Posted
HQ Client and HQ Sync Error	July 10, 2008, 1:14 am
HQ Client will not sync HQ	July 15, 2008, 4:34 pm
Short-circuiting the item price sync in HQ Client	June 24, 2008, 3:47 pm
Sync Error Following Z-out	August 8, 2007, 3:06 pm
Offline Sync Error	December 15, 2005, 10:57 am
Customer Sync error....HELP!!!	June 19, 2006, 3:17 pm
Help - Error Message during Z Report sync	November 6, 2007, 10:27 am
Run-time error during offline DB sync	June 30, 2008, 11:49 am
HQ Client Error	June 13, 2006, 3:06 am
Error 91 in HQ Client	October 17, 2006, 6:34 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software

XML Sitemap