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"

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: 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).

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.

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: 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:

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  (http://support.microsoft.com/kb/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.

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.

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

For Microsoft Dynamics CRM 3.0 laptop client for Outlook Compatibility Update

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: