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:
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).
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 "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.
- 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.
STATUS
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.
MORE INFORMATION
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
916165 Error message when you try to go offline in the Microsoft Dynamics CRM laptop client for Outlook: "Failed move data for entity <EntityName> during action saInsert, countRows=<CountNumber>. Contact your system administrator for assistance"
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: "Failed move data for entity"
REFERENCES
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:
824684 Description of the standard terminology that is used to describe Microsoft software updates
887283 Microsoft Business Solutions CRM software hotfix and update package naming standards
Additional query words: crm3 crm30 crm3.0
Keywords: kberrmsg kbbug kbqfe kbpubtypekc kbmbsmigrate kbhotfixserver kbmbscustomization kbcrmv3cno KB918108
