Error: String or binary data would be truncated RRS feed

  • Question


    Hi Experts,


    We are using Microsoft Dynamics GP 9.0 with Service Pack 2. I have recently Installed CRM 3.0, when i am trying to run import utility the following Error Message Appear:



    Event Type:        Error

    Event Source:    MbsIntegration

    Event Category:                None

    Event ID:              0

    Date:                     4/23/2008

    Time:                     12:01:00 PM

    User:                     N/A

    Computer:        CRM-SERVER


    The description for Event ID ( 0 ) in Source ( MbsIntegration ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: 4/23/2008 12:01:00 PM: ERROR : 5996: 2228: InitForm: getData: Exception while executing SP: Exception Message : String or binary data would be truncated.

    String or binary data would be truncated.

    calling int_DataSync_ProcessGPCustomers

    Entering int_DataSync_ProcessGPCustomers

    Entering int_DataSync_CopyGPCustomers

    The statement has been terminated.

    Exiting int_DataSync_CopyGPCustomers

    Entering int_DataSync_CopyGPAddresses

    The statement has been terminated.

    Exiting int_DataSync_CopyGPAddresses

    Exiting int_DataSync_ProcessGPCustomers


    Can anyone help me on this Issue.





    Wednesday, April 23, 2008 6:28 PM


  • Sajid,


    It might be because one or more source field(GP) is larger than the target field(CRM).

    Try a very simple migration first before you run the full job, you might find the problem.






    Thursday, April 24, 2008 4:39 PM