Developer forum

Forum » Integration » Error importing products and categoryFields

Error importing products and categoryFields

E-mail notifications
Jose Caudevilla
Reply
Posted on 05/05/2020 14:29:52

Hello, 

Im trying to import a set of products from a excel file into DynamicWeb PIM.

This excel file contains the basic information of a product and his productCategoryFields.

I create a excel - Ecom provider data integration mapping the basic information of the product and the categoryFields.

 

Here is a snapshot of the data integration mapping:

 

When i execute the integration task i get this error:

 

Do you know what can happen?

Im using DynamicWeb 9.8.5 , with older version i hadnt this problem.

Thanks,

Jose.

 

 

 

 

 

 

 


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 06/05/2020 09:33:30
Reply
This post has been marked as an answer

Hi Jose,
it is not clear what is a problem. Could you replace your Dynamicweb.DataIntegration.Providers.EcomProvider.dll with the one attached here in your web site "bin" folder and run the job again?
Then in the job log file you can find more information about the problem, the log file will be located in the /Files/System/Log/DataIntegration folder, sort by Date changed desc.
Kind regards, Dmitrij

Votes for this answer: 1
 
Jose Caudevilla
Posted on 06/05/2020 10:00:01
Reply

Hi Dmitriy,

I Get this error message when i replaced the dll:

 

 

I think the problem its about a bug of the Excel provider.

 

Regards, Jose

 

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 06/05/2020 10:08:15
Reply
This post has been marked as an answer

Hi Jose,
could you attach the DI job log file from the /Files/System/Log/DataIntegration folder? It contains more log information than just shown in the DI job log UI.
Regards, Dmitrij

Votes for this answer: 1
 
Jose Caudevilla
Posted on 06/05/2020 10:54:51
Reply

Yes of course:

Here is the log response:

2020-05-06 10:51:33.297: Starting job - PIMHornos.
2020-05-06 10:51:33.360: Job Failed with the following message: An item with the same key has already been added.
2020-05-06 10:51:33.360:    at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)    at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)    at Dynamicweb.DataIntegration.Providers.EcomProvider.EcomDestinationWriter.InitColumnMappings(String tableName, ColumnMappingCollection mappings)    at Dynamicweb.DataIntegration.Providers.EcomProvider.EcomDestinationWriter.InitMappings()    at Dynamicweb.DataIntegration.Providers.EcomProvider.EcomDestinationWriter..ctor(Job job, SqlConnection connection, Boolean deactivateMissinProducts, SqlCommand commandForTest, Boolean deleteExcess, ILogger logger, Boolean updateOnlyExistingProducts, String defaultLanguageId, Boolean discardDuplicates, Boolean partialUpdate, Boolean removeMissingAfterImportDestinationTablesOnly, Boolean useStrictPrimaryKeyMatching)    at Dynamicweb.DataIntegration.Providers.EcomProvider.EcomProvider.RunJob(Job job)
2020-05-06 10:51:33.375: Job failed.
2020-05-06 10:51:33.375: Finished job - PIMHornos.
2020-05-06 10:51:33.375: Batch failed.

 

Kind Regards,

Jose

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 07/05/2020 09:55:03
Reply
This post has been marked as an answer

Hi Jose,
it looks like you have two or more source tables with the same name in the mappings that is causing this issue. Or two or more same destination columns in the table mappings.
Can you try to run the job with the new dll attached here?
Could you also attach your DI job xml file?
Regards, Dmitrij

Votes for this answer: 1
 
Jose Caudevilla
Posted on 07/05/2020 10:20:16
Reply

Hi Dmitriy,

I replaced the dll getting the same error at my first message:

2020-05-07 10:09:52.297: Starting job - PIMHornos.
2020-05-07 10:09:52.735: Starting import to temporary table for EcomProducts.
2020-05-07 10:09:52.969: Job Failed with the following message: Object reference not set to an instance of an object.
2020-05-07 10:09:52.969:    at Dynamicweb.DataIntegration.Providers.ExcelProvider.ExcelSourceReader.IsDone()    at Dynamicweb.DataIntegration.Providers.EcomProvider.EcomProvider.RunJob(Job job)
2020-05-07 10:09:53.031: Job failed.
2020-05-07 10:09:53.031: Finished job - PIMHornos.
2020-05-07 10:09:53.031: Batch failed.

 

I was checking my excel integration and i have this:

Maybe the #FilterDabase is causing the problem, i will check it.

Also i attach my xml job file.

 

Thanks,

Jose.

 

 
Jose Caudevilla
Posted on 08/05/2020 11:17:10
Reply

Hi Dmitry,

Finally the problem was the #_FilterDatabase source table.

I solved it creating a new excel file ,copy all data inside the new excel file and creating a new Data integration.

 

A lot of thanks!

Kind Regards,

Jose.

 

You must be logged in to post in the forum