Developer forum

Hi Casper,
how is your integration running? Do you have regular data integration job run or scheduled task/tasks running?
Maybe this is a case when you have several scheduled tasks that uses same data integration job running at the same time?
If that is your case try to set different times/timeouts so they don't affect each other.
Is this a problem with your custom provider being used in the integration or with existing Dynamicweb providers?
Regards, Dmitrij

Hi Dmitriy

I have several integrations, but at the moment i am only running one at a time, and the problem i am having at the moment is my custom source provider getting users and passing them on to the DynamicWeb User Provider.

Hi Casper,
Can you check you are using the logging correctly? Could you attach your sources for your custom source provider?
Regards, Dmitrij

Hi Dmitriy

Attached are my 2 source files, hope they give a better picture.

Hi Casper,
In WebCrmSoourceReader try to not use the passed Logger2 logger object,
instead of passing Logger2 pass the logFile string and make a new instance of the logger like this:
Logger = new Logger(logFile);
Also in the LogResult method try to optimize the amount of calls made for each object to the logger,
you can prepare a one string message and write just this at one time instead of writting for each column,
this will help with perfomance too.
Regards, Dmitrij

Ok thanks that seems to solve my problem.

Now though at the very end i am getting this message

Den givne værdi af typen String fra datakilden kan ikke konverteres til typen nvarchar for den angivne destinationskolonne.

Basically in english its saying that the type of string from the datasource can not be converted to the type nvarchar for the destinationcolumn.

Any idea what this means?

HI Casper,
seems the solution is here: This could be caused by a too-short column. For example, if your column is defined as nvarchar(20) and you have a 40 character string, you may get this error.
Regards, Dmitrij