Developer forum

Forum » Dynamicweb 10 » Error with User Provider

Error with User Provider

Skylar Kennedy
Reply

Hello forums,

When setting up a new integration job to import customers, the job will succeed using the DynamicWeb Provider but fails using the User Provider. 

Here are the two errors I get, they seem to imply a NULL PK, even though AccessUserExternalId is set as the PK on the job and in the destination settings when using User Provider, and is not null in the source XML.

Error: Value cannot be null. (Parameter 'key') Stack:    at System.Collections.Generic.Dictionary`2.FindValue(TKey key)    at System.Collections.Generic.Dictionary`2.TryGetValue(TKey key, TValue& value)    at Dynamicweb.DataIntegration.Providers.UserProvider.UserDestinationWriter.Write(Dictionary`2 row, Mapping mapping, Boolean discardDuplicates)    at Dynamicweb.DataIntegration.Providers.UserProvider.UserProvider.RunJob(Job job)


Job Failed with the following message: Value cannot be null. (Parameter 'key') The failed input row is:  [AccessUserExternalId:"00073"], [AccessUserCustomerNumber:"00073"], [AccessUserUserName:"WALT MASSEY FORD - DEALER CLOSED"], [AccessUserName:"WALT MASSEY FORD - DEALER CLOSED"], [AccessUserEmail:""], [AccessUserPhone:""], [AccessUser_PaymentTerms:"EOM"], [AccessUser_PaymentMethod:"Check"], [AccessUser_DeliveryTerms:"Pre-Pay"], [AccessUser_DeliveryMode:"OTHER"], [AccessUserActive:"False"], [AccessUserAddress:"25060 HWY 51"], [AccessUserAddress2:""], [AccessUserCity:"Crystal Springs"], [AccessUserState:"MS"], [AccessUserZip:"39059"], [AccessUserCountryCode:"US"], [AccessUserCountry:"United States"]

Attached is my source XML.

Thanks,

Skylar Kennedy

 


Replies

 
Rasmus Sanggaard Dynamicweb Employee
Rasmus Sanggaard
Reply

Hi Skylar, 

I have tried to reproduce the error with XML provider to User provider, but can't find any errors. Are you working with DW9 or DW10? Which versions? If it's DW10, which version of the providers are you using? If possible could you attach the job XML file?

 

BR Rasmus Sanggaard

 
Skylar Kennedy
Reply

Hi Rasmus,

 

I am using DW10. I'm not sure of the version of the user provider. Attached is a copy of my job that fails.

 

Thank you,

 

Skylar Kennedy

 
Skylar Kennedy
Reply

Hi Rasmus,

 

I am using DW10. I'm not sure of the version of the user provider. Attached is a copy of my job that fails.

 

Thank you,

 

Skylar Kennedy

 
Andrew Miller
Reply

Hi All, 

Here is what I found regarding the versions of what is being used for this: 

 

DW 10 Version: Trial 10.10.5+cf2a5e72852901fe193a95b0dffc88ed45d19c88

XML provider: 10.4.1

 
Andrew Miller
Reply

User Provider is: 10.0.23

 
Andrew Miller
Reply
This post has been marked as an answer

Hi All, 

We updated both the User and XML Provider to the current versions, 10.9.1 & 10.6.2 respectively and the user import is now functioning correctly. 

Votes for this answer: 1

 

You must be logged in to post in the forum