Microsoft KB Archive/918108

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

Article ID: 918108

Article Last Modified on 9/27/2007

-

APPLIES TO


 * Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers
 * Microsoft Dynamics CRM 3.0
 * Microsoft CRM client for Microsoft Office Outlook, when used with:
 * Microsoft Dynamics CRM 3.0

-



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.



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

Time:

User:

Computer:

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

 Install the hotfix that is described in this article. 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 &quot;Bulk Insert&quot; 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.  After you install these two hotfixes, delete the contents of the following folder before you log off:

C:\Documents and Settings\ \Application Data\Microsoft\MSCRM\BCP\FMT\

</li></ol>

Note The  placeholder represents the actual CRM laptop client user.

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; 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.

<div class="moreinformation_section">

MORE INFORMATION
If you still experience the problem that is described in the &quot;Symptoms&quot; 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: &quot;Failed move data for entity &lt;EntityName&gt; during action saInsert, countRows=&lt;CountNumber&gt;. Contact your system administrator for assistance&quot;

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 3.0 laptop client for Outlook Compatibility Update: &quot;Failed move data for entity&quot;

<div class="references_section">