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

View products that this article applies to.

SYMPTOMS

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

Failed move data for entity 'entity_name' 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 "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".
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

Back to the top

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.

Back to the top

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 (http://support.microsoft.com/kb/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: "The OLE DB provider "BULK" for linked server "(null)" reported an error"
If Microsoft SQL Server Express 2005 Service Pack 2 is installed on the computer that is running the Microsoft CRM 3.0 laptop client for Outlook, install hotfix 941450.
941450 (http://support.microsoft.com/kb/941450/ ) Cumulative update package 4 for SQL Server 2005 Service Pack 2

Back to the top

MORE INFORMATION

Steps to reproduce the problem

On an entity, create a custom attribute that uses the NTEXT type and that can contain 5000 characters. For example, create a "new_LongField" field on the Account entity.
Add the custom attribute field to the main form.
Publish the changes.
For a record, populate this custom attribute field to contain more than 4000 characters.
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.

Back to the top

REFERENCES

For more information if you are using the Microsoft Dynamics 3.0 CRM laptop client for Outlook, click the following article number to view the article in the Microsoft Knowledge Base:

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

Back to the top

APPLIES TO

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

Microsoft Dynamics CRM 4.0
Microsoft CRM 3.0

Microsoft Dynamics CRM Online Professional Edition
Microsoft Dynamics CRM Online Professional Plus

Back to the top

kbmbscrmonlineoutlook kbfreshness2008 kbmbscrmonline kbmbscrm40 kbmbscustomization kberrmsg kbexpertisebeginner kbtshoot kbmbsmigrate kbprb kbexpertiseinter KB938065

Back to the top