locked
SSIS - SQL 2012 - CozyRoc Dynamic CRM Destination "The value is too large to fit in the column data area " Error RRS feed

  • Question

  • Hi, 

    Iam using Cozyroc Dynamic CRM destination plug in to "Update" against a Microsoft CRM entity.

    I get the following error while running the SSIS package - 

    "

    Error: 0xC002F304 at Sync CRM Dynamics Client Updates, CRM Contact Destination [50]: 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)".
    Error: 0xC02090F9 at Sync CRM Dynamics Client Updates, CRM Contact Destination [50]: The CRM Contact Destination was unable to process the data.
    Error: 0xC0047022 at Sync CRM Dynamics Client Updates, SSIS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "CRM Contact Destination" (50) failed with error code 0xC02090F9 while processing input "Dynamics CRM Destination Input" (62). 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." 

    There is no way to find out what the specific error is , as it doesn't mention the "failure column" details.

    Can someone provide any information in this regard?

    Thanks!



    • Edited by SQLDev555 Wednesday, October 8, 2014 2:59 AM
    Wednesday, October 8, 2014 2:06 AM

Answers

  • Figured out what the problem is.

    Cozyroc CRM Destination has some "Error Output Columns" - one of them being "ErrorDescription". The default length of this column is set to Unicode String (1024).

    The failure was due to the fact that the "error description" generated was larger than this length, and hence it was failing.

    It would have been helpful, if this information was given in the "Error Output" information.

    I now changed the length of this output field to 4000 and this has resolved the problem.

    

    

    • Marked as answer by SQLDev555 Wednesday, October 8, 2014 2:45 AM
    Wednesday, October 8, 2014 2:44 AM

All replies

  • Figured out what the problem is.

    Cozyroc CRM Destination has some "Error Output Columns" - one of them being "ErrorDescription". The default length of this column is set to Unicode String (1024).

    The failure was due to the fact that the "error description" generated was larger than this length, and hence it was failing.

    It would have been helpful, if this information was given in the "Error Output" information.

    I now changed the length of this output field to 4000 and this has resolved the problem.

    

    

    • Marked as answer by SQLDev555 Wednesday, October 8, 2014 2:45 AM
    Wednesday, October 8, 2014 2:44 AM
  • Thank you for taking the time to document your solution.
    Saturday, October 18, 2014 3:08 AM
  • Can I ask how you got to this? I am seeing the same error and believe this to be the correct solution; however, I'm not able to find this Advanced window.

    Thanks!

    Monday, February 29, 2016 9:05 PM