Sometimes I get this exception when running the DataIntegration, any idea why?
12/18/2013 8:37:18 AM: Starting batch
12/18/2013 8:37:20 AM: Starting job - Products.
12/18/2013 8:37:20 AM: Starting import to temporary table for EcomProducts.
12/18/2013 8:37:41 AM: Added 2220 rows to temporary table for EcomProducts.
12/18/2013 8:37:41 AM: Finished import to temporary table for EcomProducts.
12/18/2013 8:37:41 AM: Starting update products information.
12/18/2013 8:40:34 AM: Update products information completed.
12/18/2013 8:40:42 AM: Job Failed with the following message: Exception: Invalid object name 'EcomVariantOptionsProductRelationTempTableForBulkImport'. Sql query: delete from EcomGroupProductRelation where GroupProductRelationProductID in (select groupproductrelationproductID from ecomgroupproductrelationTempTableForBulkImport); insert into EcomGroupProductRelation (GroupProductRelationGroupID,GroupProductRelationProductID,GroupProductRelationSorting,GroupProductRelationIsPrimary) select GroupProductRelationGroupId, GroupProductRelationProductID,GroupProductRelationSorting,GroupProductRelationIsPrimary from ecomgroupproductrelationTempTableForBulkImport; delete from EcomShopGroupRelation where ShopGroupGroupID in (select ShopGroupGroupID from EcomShopGroupRelationTempTableForBulkImport); insert into EcomShopGroupRelation(ShopGroupShopID,ShopGroupGroupID,ShopGroupRelationsSorting) select shopgroupshopid,shopgroupgroupid,ShopGroupRelationsSorting from ecomshopgrouprelationtemptableforbulkimport; delete from EcomVariantgroupProductRelation where VariantgroupProductRelationProductID in (select VariantgroupProductRelationProductID from EcomVariantgroupProductRelationTempTableForBulkImport); insert into EcomVariantgroupProductRelation (VariantgroupProductRelationID,VariantgroupProductRelationProductID,VariantgroupProductRelationVariantGroupID)select VariantgroupProductRelationID,VariantgroupProductRelationProductID,VariantgroupProductRelationVariantGroupID from EcomVariantgroupProductRelationTempTableForBulkImport;delete from EcomVariantOptionsProductRelation where VariantOptionsProductRelationProductID in (select VariantOptionsProductRelationProductID from EcomVariantOptionsProductRelationTempTableForBulkImport); insert into EcomVariantOptionsProductRelation (VariantOptionsProductRelationProductID,VariantOptionsProductRelationVariantID)select VariantOptionsProductRelationProductID,VariantOptionsProductRelationVariantID from EcomVariantOptionsProductRelationTempTableForBulkImport;insert into EcomShops (ShopID,ShopName) select shopid,shopname from ecomShopsTempTableForBulkImport; insert into EcomProductsRelatedGroups (RelatedGroupID,RelatedGroupName,RelatedGroupLanguageID) select RelatedGroupID,RelatedGroupName,RelatedGroupLanguageID from EcomProductsRelatedGroupsTempTableForBulkImport; delete from EcomProductsRelated where ProductRelatedProductID in (select ProductRelatedProductID from EcomProductsRelatedTempTableForBulkImport); insert into EcomProductsRelated (ProductRelatedProductID,ProductRelatedProductRelID,ProductRelatedGroupID) select ProductRelatedProductID,ProductRelatedProductRelID,ProductRelatedGroupID from EcomProductsRelatedTempTableForBulkImport; delete from EcomGroupRelations where groupRelationsGroupID in (select groupRelationsGroupID from EcomGroupRelationsTempTableForBulkImport);insert into EcomGroupRelations (GroupRelationsGroupID,GroupRelationsParentID,GroupRelationsSorting) select GroupRelationsGroupID,GroupRelationsParentID,GroupRelationsSorting from EcomGroupRelationsTempTableForBulkImport;
12/18/2013 8:40:43 AM: Finished job - Products.
12/18/2013 8:40:43 AM: Batch failed.