1. Home
  2. Point-Of-Sale Software
  3. SQL Time on Worksheet 250/260

SQL Time on Worksheet 250/260

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.

Ref. No.: 52610

4/15/2007 10:58:56 AM Updated 3 record(s) in table 'QuantityDiscount'. 4/15/2007 10:58:57 AM Updated 3 record(s) in table 'ItemClass'. 4/15/2007 11:47:01 AM Error -2147217871: Timeout expired SELECT #Temp.* INTO #TempInsert FROM #Temp LEFT JOIN Item ON (#Temp.HQID = Item.HQID) OR (Item.HQID=0 AND #Temp.ItemLookupCode=Item.ItemLookupCode) OR (Item.HQID0 AND Item.HQID<
Reply to
Floppy Cow
Loading thread data ...

Reply to
Ahmed Nashat

Thank you, That is a big help

John & Tom

"Ahmed Nashat" wrote:

predefined timeout for HQ Client (1 hour), to change the HQ client timeout, please do the following: -

System\Headquarters\Client\Timeout

Reply to
John M

Which registry key under timeout should we be editing? I changed the key "Message" as it had the value of 3600.

Tom

"Ahmed Nashat" wrote:

predefined timeout for HQ Client (1 hour), to change the HQ client timeout, please do the following: -

System\Headquarters\Client\Timeout

Reply to
Floppy Cow

This is correct, it's the "Message" variable

Reply to
Ahmed Nashat

We have tried changing the Time to 7200 and 14400 and still does not work. It seems to time out after about 15mins.

John M

"Ahmed Nashat" wrote:

Reply to
John M

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.