We have experienced time outs after tendering a transaction. When this happens the transaction posts to the sales departments but not to the total sales and a receipt is not printed. We have tried to extend the timeout period in administrator but this has not alleviated the problem. Has anyone experienced this error message before and has a possible solution:
Store Operations Business Rules
Error 2147217871
Timeout expired
Source: Microsoft OLE DB Provider For SQL Server
(SQL State: HYTOO)
(Native Error:0)
No help file available
Select ItemID, SUM (Quantity) AS Quantity INTO # Temp
From Transaction Entry WITH (NOLOCK)
WHERE Transaction Number = ?
GROUP BY Item ID
UPDATE Item
SET Item.Quantity = Item.Quantity ? CASE WHEN Item Item Type = 7 THEN 0 ELSE # Temp.Quantity END,
Item.Buydown. Quantity CASE WHEN (Item.ItemType = 7 OR Item.BuydownPrice = 0)
THEN
Item.Buydown.Quantity - # Temp Quantity
ELSE 0
END
END,
Last Sold =?
Last Updates = Get Date ( )
Frome # Temp
INNERJOIN Item On Item.ID = # Tmp.ItemID
After you hit ?OK? you get a small pop up that says
Error #5
Invalid procedure call or argument
(Source QSRules)
Error in Post Transaction Entries