CRM Destination Task is failing with - error code 0xC02090F9

[Sue]

Ivan,

The complete error message is:

[Dynamics CRM Destination [2]] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException: The value is too large to fit in the column data area of the buffer.
   at Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetString(Int32 columnIndex, String value)
   at Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.set_Item(Int32 columnIndex, Object value)
   at CozyRoc.SqlServer.SSIS.CrmDestination._HandleResult(PipelineBuffer buffer, IStatus[] resList)
   at CozyRoc.SqlServer.SSIS.CrmDestination._SetupData(PipelineBuffer buffer, ArrayList records)
   at CozyRoc.SqlServer.SSIS.CrmDestination.ProcessInput(Int32 inputID, PipelineBuffer buffer)".

[Dynamics CRM Destination [2]] Error: The Dynamics CRM Destination was unable to process the data.

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "Dynamics CRM Destination" (2) failed with error code 0xC02090F9 while processing input "Dynamics CRM Destination Input" (14). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.  There may be error messages posted before this with more information about the failure.

What does this mean? I have too many records to import or one of my columns from my sql table does not match the entity column in CRM?

I saw a similar post that said something about changing the config file. Is this the same issue?

Help!!!!

Thank you,

Sue

[Ivan Peev]

Hi Sue,

The error below is a bit misleading. The CRM server generates an error which is too large to fit in the default length of the ErrorDescription column in the Error Output in the Dynamics CRM Destination component. Increase the length to 4000 and execute the package again. Do you see the error now ?

[Sue Waters]

I will try it in the morning and let you know. thank you

--
You received this message because you are subscribed to a topic in the Google Groups "COZYROC" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/cozyroc/469f8IxQNHg/unsubscribe.
To unsubscribe from this group and all its topics, send an email to cozyroc+u...@googlegroups.com.
To post to this group, send email to coz...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/cozyroc/e990a953-9824-4e9d-a78d-19a3acb89990%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Tim Huemmer]

Ivan,

I am seeing this issue and I have the ErrorDescription column set to 4000.  Any other suggestions?

[Ivan Peev]

Hi Tim,

If you seeing the same error, then you are overflowing the 4000 characters limit. Try using DT_NTEXT instead.