Developer forum

Forum » Integration » Error when importing assortments

Error when importing assortments

E-mail notifications
Niels Foldager
Reply
Posted on 03/10/2017 13:57:50

Hi Dynamicweb,

When importing assortments in DW 9.3.4 using the DynamicwebProvider, I get an error when importing EcomAssortmentGroupRelations, where some GroupID's doesn't exist in EcomGroups.

<item table="EcomAssortmentGroupRelations">
  <column columnName="AssortmentGroupRelationAssortmentID"><![CDATA[PET]]></column>
  <column columnName="AssortmentGroupRelationGroupID"><![CDATA[2428]]></column>
</item>

There is no error when using the EcomProvider or when importing the same data in DW8. There may have been a hotfix for this error i DW8, which has not been moved up to DW9.

Best regards
Niels Foldager

EcomAssortmentGroupRelations.png

Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 04/10/2017 13:36:24
Reply

Hi Niels,
I was not able to reproduce this problem. I was using the xml with just one item from your post and it was imported OK (XML -> Dynamicweb provider job).
Packages used:
Dynamicweb.DataIntegration.Providers.DynamicwebProvider.dll 1.0.9
Dynamicweb.DataIntegration.Providers.SqlProvider.dll 1.0.9
Dynamicweb.DataIntegration.dll 1.0.14

Could you check if you are using the latest packages and if the problem still exists could you attach your source xml file and Data integration job xml so I can try to reproduce it?
Regards, Dmitrij

 
Anders Ebdrup
Anders Ebdrup
Posted on 07/10/2017 15:22:57
Reply

Hi Dmitrij,

 

I have been debugging the code I can see that you are missing a "null" check for non-existing groups, before trying to load products related to the non-existing group.

 

Please see this screen dump: https://www.screencast.com/t/cnRqf6y2f8

 

Best regards, Anders

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 09/10/2017 14:08:46
Reply

Hi Anders,
nicely found. TFS# 40339 created.
Kind regards, Dmitrij

 
Anders Ebdrup
Anders Ebdrup
Posted on 10/10/2017 11:18:49
Reply

Hi Dmitrij,

 

Is it possible that the fix for this issue can be added to the 9.3 release, as it gives us some problems?

 

Best regards, Anders

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 10/10/2017 11:33:57
Reply

Hi Anders,
yes, should be present in the next, 9.3.5
Regards, Dmitrij

 
Kristian Kirkholt Dynamicweb Employee
Kristian Kirkholt
Posted on 11/10/2017 13:08:52
Reply

Hi Anders and Niels

The problem TFS#40339 "Error when importing assortments EcomAssortmentGroupRelations where some GroupID's doesn't exist in EcomGroups" has now been fixed in version 9.3.5

You are able to find this build in the download section:

http://doc.dynamicweb.com/releases-and-downloads/releases

Please contact Dynamicweb Support if you need any additional help regarding this.

Kind Regards
Dynamicweb Support
Kristian Kirkholt

 

You must be logged in to post in the forum