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

Article translations Article translations
Article ID: 938065 - View products that this article applies to.
Expand all | Collapse all

On This Page

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

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.

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: "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 Cumulative update package 4 for SQL Server 2005 Service Pack 2

MORE INFORMATION

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 "new_LongField" 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.

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

Properties

Article ID: 938065 - Last Review: May 15, 2009 - Revision: 4.0
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
Keywords: 
kbmbscrmonlineoutlook kbfreshness2008 kbmbscrmonline kbmbscrm40 kbmbscustomization kberrmsg kbexpertisebeginner kbtshoot kbmbsmigrate kbprb kbexpertiseinter KB938065

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