I created new Store. then I Download more than 41000 items from HQ to Store. Now when I am trying to upload the Datat from Store to HQ.It is giving me Timeout Error.
Please find the Connection Detail below.
Information Store 03-Jun-13 1:35:33 PM ======= CONNECTION STARTED =======
Information Store 03-Jun-13 1:35:33 PM Opening of local datasource '(local).GSMARDB' was successful.
Information Store 03-Jun-13 1:35:34 PM Local and HQ databases are synchronized.
Information Store 03-Jun-13 1:35:34 PM Store-HQ Time Zone Difference: 0 minutes
Information Store 03-Jun-13 1:35:35 PM Number of worksheets to process: 1
Information Store 03-Jun-13 1:35:36 PM 1. Processing worksheet style 401
Information Store 03-Jun-13 1:35:36 PM Title: Request Data Upload
Information Store 03-Jun-13 1:35:36 PM Ref. No.: 24214
Information Store 03-Jun-13 1:35:39 PM Uploading store data to HQ.
Information HQ 02-Jun-13 1:36:06 PM Uploaded 2 record(s) from table 'Batch'.
Information HQ 02-Jun-13 1:36:06 PM Uploaded 129 record(s) from table 'Cashier'.
Information HQ 02-Jun-13 1:36:06 PM Uploaded 1 record(s) from table 'Configuration'.
Error HQ 02-Jun-13 2:06:21 PM <<ExecuteCommand>> Error -2147217871: Timeout expired
UPDATE ItemDynamic
SET QuantityCommitted = ItemDynamic.SnapShotQuantityCommitted
FROM #Temp JOIN ItemDynamic
ON #Temp.ItemID = ItemDynamic.ItemID
AND ItemDyna
Information HQ 02-Jun-13 2:06:21 PM Uploaded 41472 record(s) from table 'Item'.
Error HQ 02-Jun-13 2:06:21 PM An error occurred while uploading transaction data to HQ database.
Error Store 03-Jun-13 2:05:59 PM Not completed due to errors encountered during processing.
Information Store 03-Jun-13 2:06:01 PM Closed local database (local).GSMARDB
Please help to Solve this Problem.
Umar Khitab
*This post is locked for comments