Problems with Sincronization

hi again today have a problem, i have an HQ database with 180,000 items. I need to transmit to all SO stores and i use the Worksheet 260 to download the items in the stores. But, when the store starts the sincronization around 45 minutes before to hq client start to procces the Worksheet and give me a error about the TIME CONECTION (The wait time was ended), and give me this: UPDATE Item SET TagAlongItem = ISNULL(A.ID,0) FROM #Temp JOIN Item ON #Temp.HQID = ItemHQID LEFT JOIN Item AS A ON (#Temp.TagAlongItem0A.HQID) AND (A.HQID 0) SELECT @@ROWCOUNT AS REcorsAffected.

Although this, the items were loaded in my SO STORE. I tried with around 10,000 items, and there's no problem.

My question is, are too much the quantity of Items??

Reply to
robertinho
Loading thread data ...

Why are you doing a 260 for 180K Items? The 260 is not generally recommended at all - the 250 is favored.

If you are sending all items, does that mean that you are rolling out new stores? If so, you should EXPORT the stores in HQ Administrator rather than sending the items to the stores.

It looks like the items were added, but some of the properties may not have been updated - note that the error message includes an UPDATE statement rather than an INSERT.

Glenn Adams Tiber Creek C> hi again

Reply to
Glenn Adams [MVP - Retail Mgmt]

thanks for the answer.

Well, i tried to export the Items when i created and export the stores, but > Why are you doing a 260 for 180K Items? The 260 is not generally

Reply to
robertinho

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.