TimeOut errors

I have about 700000 customer records to bring in RMS HQ tried with all of them it gave me a the following error which I belive is a time out.

Runtime error 3246 Connection object cannot be explicitly closed while in a transaction

Runtime error '440' Automation error.

If i bring the records say 100,000 at a time into HQ it might work but when it syncs to other stores will it give me the same error ?.

Anyone got any ideas about what the time out value should be ?.

Reply to
bangi
Loading thread data ...

Brought in 300,000 customer records and seems to have worked, was running a trace on it and saw this UPDATE [Transaction] SET CustomerID = CustomerID WHERE CustomerID = 294488 UPDATE [TransactionHold] SET CustomerID = CustomerID WHERE CustomerID = 294488 UPDATE [AccountReceivable] SET CustomerID = CustomerID WHERE CustomerID 294488 UPDATE [Order] SET CustomerID = CustomerID WHERE CustomerID = 294488 UPDATE [Payment] SET CustomerID = CustomerID WHERE CustomerID = 294488 UPDATE [Journal] SET CustomerID = CustomerID WHERE CustomerID = 294488 UPDATE [TransactionEntry] SET ItemID = ItemID FROM [TransactionEntry] INNER JOIN [Transaction] ON [TransactionEntry].TransactionNumber = [Transaction].TransactionNumber WHERE [Transaction].CustomerID = 294488

SELECT @@ROWCOUNT AS RecordsAffected

the thing is I do not have any transactions in hq or store yet have to import them from my current erp system. Surely if there are no transactions in either HQ or Store then whats the point of a update query on it.

Regards

Reply to
bangi

Do you have customer numbers already assigned?

When I imported my customers, I was having trouble also and it was the CUSTOMER ID field that was giving errors.

I imported the customers into an intermediary program, assigned them all new Customer IDs that matched my RMS Customer ID field (I set the RMS start number to be greater than the customer import numbers), then re-imported with success.

Reply to
Mickie

Dear Bangi, I agree with you and saw your query: the below of one query not make sense that you are updating the ItemID for same table: UPDATE [TransactionEntry] SET ItemID = ItemID (why FROM [TransactionEntry] INNER JOIN [Transaction] ON [TransactionEntry].TransactionNumber = [Transaction].TransactionNumber WHERE [Transaction].CustomerID = 294488

Check it and rate it.

"bangi" wrote:

Reply to
Akber Alwani

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.