Developer forum

Forum » Integration » Random Crashing

Random Crashing

Casper Andersen
Reply

Hi.

I have created my own source provider that grabs information from a CRM system and feeds it to the standard user destination provider, at first run through i have around 3600 users to add if they do not exist, of course after that i will only take the ones that where added after the last run through, but my integration seems to crash randomly with an error that is this:

Job Failed with the following message: The source reader for the table: [AccessUser] can not get a value for the column: [AccessUserFirstName].The input row is:

But thing is i know that it is not empty since i always log empty fields and even if AccessUserFirstName is empty i put in a different value so it is not empty. And this can sometimes happen after 200 rows or after 1600 rows, any idea what the problem is?

The solution is running on version  8.8.1.6

 


Replies

 
Dmitriy Benyuk
Reply

Hi Casper,

that error means that in your source provider source reader GetNext() method which is returning the Dictionary<string, object>:
row = reader.GetNext();
the row does not contain the Key "AccessUserFirstName" for some rows/records. The failed row should be in the log file after the
"The input row is:"here should be a failed row Key/Value pairs"" which should show no Key "AccessUserFirstName".
So even if there is no value for ""AccessUserFirstName"" but the column  is in the mapping and is Active mapping
the  row["AccessUserFirstName"] should exists with some null/string.Empty value.

Regards, Dmitrij

 
Casper Andersen
Reply

So if i understand you correctly it's not anything i did?

Is there a way to fix this?

 

Thanks for the reply

 
Dmitriy Benyuk
Reply

Hi Casper,
no it looks like a problem on your side. Check your output from the GetNext() method for always availability of the "AccessUserFirstName" key in the dictionary.

Regards, Dmitrij

 
Casper Andersen
Reply

Thing is, the data atm is always the same, but it crashes at random points, and i always make sure that all the fields are either set to a value, and if a field for some reason is not set i make sure to set it to empty string "" and that is for the source, for the destination i just use the built in user provider, besides after trying a couple of times on my local installation i got it to work so for now it does not seem like there is anything wrong with the data.

 
Dmitriy Benyuk
Reply

Hi Casper,
could you attach the log file with the error?
It is located in the Files/System/Log/DataIntegration folder
Regards, Dmitrij

 
Casper Andersen
Reply

Hi.

So feeling stupid now, the problem was that i, when i was mapping the result key value fields in my GetNext method, i asked if some information was empty and if it was, to skip that user, which in turn of course returned a null result, instead of course i made this happen before adding the information to a custom list which the get next method then used to map the fields, thanks for the help and support on this one. And sorry for the fluke.

 

You must be logged in to post in the forum