Microsoft KB Archive/938065

= Error message when you try to go offline in the Microsoft Dynamics CRM client for Outlook: &quot;Failed move data for entity&quot; =

Article ID: 938065

Article Last Modified on 1/4/2008

-

APPLIES TO

 Microsoft Dynamics CRM 4.0 Microsoft Dynamics CRM 3.0 Microsoft CRM client for Microsoft Office Outlook, when used with:  Microsoft Dynamics CRM 4.0

 Microsoft Dynamics CRM 3.0 

-

<div class="symptoms_section">

SYMPTOMS
When you are running the Microsoft Dynamics CRM laptop client for Microsoft Office Outlook Compatibility Update or the Microsoft Dynamics CRM offline client for Microsoft Office Outlook, you receive the following error message when you try to go offline:

Failed move data for entity ' ' during action salnsert, countRows=1. Contact your system administrator for assistance and try going offline again.

Additionally, you receive the following error message in the platform trace:

Insert failed for entity 'Incident', batchRows=0 with exception System.Data.SqlClient.SqlException: The bulk load failed.

The column is too long in the data file for row 1, column 18.

Verify that the field terminator and row terminator are specified correctly.

The OLE DB provider &quot;BULK&quot; for linked server &quot;(null)&quot; reported an error. The provider did not give any information about the error.

Cannot fetch a row from OLE DB provider &quot;BULK&quot; for linked server &quot;(null)&quot;.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery

at Microsoft.Crm.Application.Outlook.OfflineSync.Utility.ExecuteSql(String strCommand, CrmDbConnection dbConnection) in d:\crm\v3rtm\src\Application\Outlook\Components\OfflineSync\Utility.cs:line 55

at Microsoft.Crm.Application.Outlook.OfflineSync.BcpTransferDataProvider.PopulateTempTable(String tempTableName, String fileName, CrmDbConnection dbConnection, Int32 count, String formatFile) in d:\crm\v3rtm\src\Application\Outlook\Components\OfflineSync\BCPTransferDataProvider.cs:line 389

at Microsoft.Crm.Application.Outlook.OfflineSync.BcpTransferDataProvider.DoInsertTable(EntityMetadata entity, String fileName, Int32 count, Boolean extension, String attributes) in d:\crm\v3rtm\src\Application\Outlook\Components\OfflineSync\BCPTransferDataProvider.cs:line 672

at Microsoft.Crm.Application.Outlook.OfflineSync.BcpTransferDataProvider.DoInsert(EntityMetadata entity, String fileName, Int32 count) in d:\crm\v3rtm\src\Application\Outlook\Components\OfflineSync\BCPTransferDataProvider.cs:line 637

at Microsoft.Crm.Application.Outlook.OfflineSync.BcpTransferDataProvider.ExecuteInsert(String entityName, Int32 count) in d:\crm\v3rtm\src\Application\Outlook\Components\OfflineSync\BCPTransferDataProvider.cs:line 333

at Microsoft.Crm.Application.Outlook.OfflineSync.SyncData.DoBatchStep(ITransferDataProvider transferDataProvider, String entityName, SyncAction action, Int32 batchRows) in d:\crm\v3rtm\src\Application\Outlook\Components\OfflineSync\Sync.cs:line 1087

<div class="cause_section">

CAUSE
This problem occurs if the following conditions are true:
 * In the main form of an entity, you added a custom attribute field that uses the NTEXT type.
 * The custom attribute field on a related record contains more than 4,000 characters.

<div class="resolution_section">

RESOLUTION
To resolve this problem, use one of the following methods:  If Microsoft SQL Server Express 2005 Service Pack 1 is installed on the computer that is running the Microsoft CRM 3.0 laptop client for Outlook, install hotfix 937545.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

937545 FIX: Error message when you use the BULK INSERT statement to import a data file into a table in SQL Server 2005 with SP 1: &quot;The OLE DB provider &quot;BULK&quot; for linked server &quot;(null)&quot; reported an error&quot;

</li> If Microsoft SQL Express 2005 Service Pack 2 is installed on the computer that is running the Microsoft CRM 3.0 laptop client for Outlook, install hotfix 936305.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

936305 Cumulative update package 3 for SQL Server 2005 Service Pack 2

</li></ul>

<div class="moreinformation_section">

Steps to reproduce the problem

 * 1) On an entity, create a custom attribute that uses the NTEXT type and that can contain 5000 characters. For example, create a &quot;new_LongField&quot; field on the Account entity.
 * 2) Add the custom attribute field to the main form.
 * 3) Publish the changes.
 * 4) For a record, populate this custom attribute field to contain more than 4000 characters.
 * 5) In the Microsoft Dynamics CRM laptop client for Outlook Compatibility Update or in the Microsoft Dynamics CRM offline client for Outlook, try to go offline.

<div class="references_section">