Developer forum

Forum » Integration » Cannot access destination table 'EcomProductsTempTableForBulkImport1'

Cannot access destination table 'EcomProductsTempTableForBulkImport1'

E-mail notifications
Dynamicweb Employee
Jeremy Fesmire
Reply
Posted on 15/11/2024 15:53:07
 I am encountering an error on our  UAT Keystone site (https://uat-krvc.mydwsitec.com/Admin/Default) in the data integration jobs that is causing inconsistent results in the data.
 
Intermittently, although rather frequently, I am seeing errors like this one:
 
"2024-11-14 18:16:14.449: Start checking input files changing 2024-11-14 18:16:19.465: Finish checking input files changing 2024-11-14 18:16:19.465: reading configuration 2024-11-14 18:16:20.262: Starting import to temporary table for EcomProducts. 2024-11-14 18:16:20.278: Added 100 rows to temporary table for EcomProducts. 2024-11-14 18:16:20.278: Finished import to temporary table for EcomProducts. 2024-11-14 18:16:20.278: Starting update products information. 2024-11-14 18:16:21.403: Update products information finished. 2024-11-14 18:16:21.559: Error: Bulk copy failures: Error: Cannot access destination table 'EcomProductsTempTableForBulkImport1'.Row data:..."
 
What we are finding is that when this error occurs, some of the data updates, particularly constants set in the job, but the rest of the fields remain as they were prior to the import.  The batch also is certifying with this error, so we move on to the next set of records. I believe this is due to the "Update products information finished." reporting as successful although the data is not updating in the destination table.  This occurring with the User, Ecom, and Dynamicweb destination providers across many tables and different integration jobs.
 
Looking for how we can prevent this error from occurring or any ideas why it might be happening?

Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 15/11/2024 18:19:51
Reply

Hi Jeremy,

Can not find what is the exact problem. Can it be that the same temp table "'EcomProductsTempTableForBulkImport1" is used by several sites/threads at the same time?
Can you try to check the option "Persist successful rows and skip failing rows" in the destination provider or check why the rows are failed to be imported?
I saw you have a custom import data add-in so you can check if it is not setting the XmlProvider "ExportIsDone=false" so the temp table is not cleared between the job runs.

BR, Dmitrij

 
Dynamicweb Employee
Jeremy Fesmire
Posted on 15/11/2024 20:05:39
Reply

Hi Dmitrij,

Thanks for looking!
Can it be that the same temp table "'EcomProductsTempTableForBulkImport1" is used by several sites/threads at the same time? - Well I was ready to say no here as the only site connected to that database should be uat-krvc.mydwsitec.com, but when double checking I am finding records on EcomProducts that have updated since I turned our task and job off yesterday for troubleshooting. The integration logs on the site don't have any record of these rows importing either, so we may have a rogue site causing the importtable to lock. Investigating this angle with our sysadmin team.

Can you try to check the option "Persist successful rows and skip failing rows" in the destination provider or check why the rows are failed to be imported? - Turned this on in the import products job. It did expose a list of similar errors, here is one:
Error: The given ColumnMapping does not match up with any column in the source or destination.Row data: [ProductLanguageId: "LANG1"] (System.String), [ProductNumber: "659448"] (System.String), [ProductName: "Dinette-Top-40 3/4" x 26 5/8"-Sprinter"] (System.String), [ProductPrice: "37.183"] (System.Double), [LastSyncDate: "11/15/2024 6:15:14 PM"] (System.DateTime), [IsBackedByIntegration: "True"] (System.Boolean), [ProductId: "659448"] (System.String), [ProductReplacementProductId: ""] (System.String), [ProductDiscontinuedAction: "0"] (System.Int32), [ProductType: "0"] (System.Int32), [ProductStockLocation: "CS"] (System.String), [VendorPart: ""] (System.String), [ProductDiscontinued: "False"] (System.Boolean), [ProductNeverOutOfStock: "True"] (System.Boolean), [KeystoneWarehouse: "CS"] (System.String), [SerialNumberforClaimRequired: "False"] (System.Boolean), [ModelNumberforClaimRequired: "False"] (System.Boolean), [DisplayUnits: "Each"] (System.String), [ProductPriceType: "0"] (System.Int32), [ProductVariantId: ""] (System.String), [ProductVariantProdCounter: "0"] (System.Int32), [ProductVariantGroupCounter: "0"] (System.Int32), [ProductVariantCounter: "0"] (System.Int32)

The only mappings here that don't match appear to be the Variant fields (bolded) which I believe are added by the EcomProvider.

I saw you have a custom import data add-in so you can check if it is not setting the XmlProvider "ExportIsDone=false" so the temp table is not cleared between the job runs. - I don't see anything in the addin that is setting ExportIsDone, but i have attached the .cs file for the addin if you would like to review.

 

Best Regards,
Jeremy

 

 
Dynamicweb Employee
Jeremy Fesmire
Posted on 15/11/2024 20:24:06
Reply

Hi Dmitrij,

Just got confimation from our sysadmin that there was another site incorrectly configured and pointing to the same database. Hopefully fixing that will fix the issues we are seeing here. 

best regards, Jeremy

 

You must be logged in to post in the forum