Error message when you try to go offline on a laptop client computer that is running Microsoft Dynamics CRM 3.0: "Failed move data for entity"

Article translations Article translations
Article ID: 918108 - View products that this article applies to.
The hotfix that is discussed in this article is not available for the Chinese version of Microsoft Dynamics CRM or for the Japanese version of Microsoft Dynamics CRM.
Expand all | Collapse all

SYMPTOMS

When you try to go offline on a laptop client computer that is running Microsoft Dynamics CRM 3.0, you cannot go offline successfully. You receive the following error message:
Failed move data for entity 'entity_name' during action salnsert, countRows=1. Contact your system administrator for assistance and try going offline again.
Additionally, the following error message is logged in the Application log on the laptop client computer:

Event Type: Error
Event Source: MSCRMOfflineSync
Event Category: None
Event ID: 6000
Date: date
Time: time
User: user_name
Computer: computer_name

Description:

An error occurred during Offline Synchronization. Try going offline again, or restart Microsoft Outlook. saInsert failed for entity 'Account', batchRows=0 with exception System.Data.SqlClient.SqlException: Bulk Insert fails. Column is too long in the data file for row 1, column 71. Make sure the field terminator and row terminator are specified correctly.

OLE DB provider 'STREAM' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'STREAM' IRowset::GetNextRows returned 0x80004005: The provider did not give any information about the error.].
The statement has been terminated.
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Crm.Application.Outlook.OfflineSync.Utility.ExecuteSql(String strCommand, CrmDbConnection dbConnection)
at Microsoft.Crm.Application.Outlook.OfflineSync.BcpTransferDataProvider.PopulateTempTable(String tempTableName, String fileName, CrmDbConnection dbConnection, Int32 count, String formatFile)
at Microsoft.Crm.Application.Outlook.OfflineSync.BcpTransferDataProvider.DoInsertTable(EntityMetadata entity, String fileName, Int32 count, Boolean extension, String attributes)
at Microsoft.Crm.Application.Outlook.OfflineSync.BcpTransferDataProvider.DoInsert(EntityMetadata entity, String fileName, Int32 count)
at Microsoft.Crm.Application.Outlook.OfflineSync.BcpTransferDataProvider.ExecuteInsert(String entityName, Int32 count)
at Microsoft.Crm.Application.Outlook.OfflineSync.SyncData.DoBatchStep(ITransferDataProvider transferDataProvider, String entityName, SyncAction action, Int32 batchRows).

CAUSE

This problem may occur when the following conditions are true:
  • You added a custom attribute field that uses the NTEXT type to the main form of an entity.
  • The custom attribute field on a related record contains more than 4,000 characters.

RESOLUTION

This problem is fixed in Microsoft Dynamics CRM 3.0 Update Rollup 1.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:
922815Update Rollup 1 for Microsoft Dynamics CRM 3.0 is available
This problem is fixed in Update Rollup 1 for Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:
935731 Update Rollup 1 for Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers is available
  1. Install the hotfix that is described in this article.
  2. Install the Microsoft SQL Server hotfix that is described in the following KB article:
    923327 FIX: You may receive an access violation error message when you import data by using the "Bulk Insert" command in SQL Server 2000
    Notes
    • Install the hotfix that is described in this article on each client workstation to the MachineName\CRM instance of SQL Server.
    • The hotfix exposed a Microsoft SQL Server bug in the Bulk Insert process. This bug must be addressed when you install the hotfix.
  3. After you install these two hotfixes, delete the contents of the following folder before you log off:
    C:\Documents and Settings\<crm laptop client user>\Application Data\Microsoft\MSCRM\BCP\FMT\
Note The <crm laptop client user> placeholder represents the actual CRM laptop client user.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was corrected in Microsoft Dynamics CRM 3.0 Update Rollup 1 and in Update Rollup 1 for Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers.

MORE INFORMATION

If you still experience the problem that is described in the "Symptoms" section after you install the hotfix, click one of the following article numbers to view the article in the Microsoft Knowledge Base.

For Microsoft Dynamics CRM 3.0 laptop client for Outlook

916165 Error message when you try to go offline in the Microsoft Dynamics CRM laptop client for Outlook: "Failed move data for entity &lt;EntityName&gt; during action saInsert, countRows=&lt;CountNumber&gt;. Contact your system administrator for assistance"

For Microsoft Dynamics CRM 3.0 laptop client for Outlook Compatibility Update

938065 Error message when you try to go offline in the Microsoft Dynamics CRM client for Outlook: "Failed move data for entity"

REFERENCES

For more information about the terminology that is used to describe Microsoft software updates, click the following article numbers to view the articles in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
887283 Microsoft Business Solutions CRM software hotfix and update package naming standards

Properties

Article ID: 918108 - Last Review: September 27, 2007 - Revision: 8.3
APPLIES TO
  • Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers
  • Microsoft CRM 3.0
  • Microsoft CRM client for Microsoft Office Outlook, when used with:
    • Microsoft CRM 3.0
Keywords: 
kbcrmv3cno kberrmsg kbbug kbmbscustomization kbhotfixserver kbqfe kbmbsmigrate KB918108

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com