Microsoft KB Archive/916165

= Error message when you try to go offline in the Microsoft Dynamics CRM laptop client for Outlook: &quot;Failed move data for entity  during action saInsert, countRows=. Contact your system administrator for assistance&quot; =

Article ID: 916165

Article Last Modified on 8/31/2007

-

APPLIES TO


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

-



SYMPTOMS
When you try to go offline in the Microsoft Dynamics CRM 3.0 laptop client for Microsoft Office Outlook, you may receive the following error message:

Failed move data for entity  during action saInsert, countRows=. Contact your system administrator for assistance.

Note In this message,  is a placeholder for the name of an actual entity, and   is a placeholder for the actual number of rows.

An error message that is similar to the following error message is logged in the event log:

Event Type: Error

Event Source: MSCRMOfflineSync

Event Category: None

Event ID: 6000

Description: An error occurred during Offline Synchronization. Try going offline again, or restart Microsoft Outlook. GetBCPFile failed during action Insert for entity , batchRows=0 with exception System.Net.WebException: The remote server returned an error: (401) Unauthorized. ---> System.ComponentModel.Win32Exception: The logon attempt failed at System.Net.NTAuthentication.GetOutgoingBlob(Byte[] incomingBlob, Boolean& handshakeComplete) at System.Net.NTAuthentication.GetOutgoingBlob(String incomingBlob, Boolean& handshakeComplete) at System.Net.NegotiateClient.DoAuthenticate(String challenge, WebRequest webRequest, ICredentials credentials, Boolean preAuthenticate) at System.Net.NegotiateClient.DoAuthenticate(String challenge, WebRequest webRequest, ICredentials credentials, Boolean preAuthenticate) at System.Net.NegotiateClient.Authenticate(String challenge, WebRequest webRequest, ICredentials credentials) at System.Net.AuthenticationManager.Authenticate(String challenge, WebRequest request, ICredentials credentials) at System.Net.AuthenticationState.AttemptAuthenticate(HttpWebRequest httpWebRequest, ICredentials authInfo) --- End of inner exception stack trace --- at System.Net.HttpWebRequest.CheckFinalStatus at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult) at System.Net.HttpWebRequest.GetResponse at Microsoft.Crm.Application.Outlook.OfflineSync.BcpTransferDataProvider.GetBCPFile(String entityName, Action action, Int32 batchSize).

For more information, see Help and Support Center at http://support.microsoft.com.

A warning message that is similar to the following message is logged in the event log:

Event Type: Warning

Event Source: MSCRMOfflineSync

Event Category: None

Event ID: 6001

Description: An unexpected result was returned during Offline Synchronization. #temp count inserts 54!=27 requested count inserts.

For more information, see Help and Support Center at http://support.microsoft.com.

Note In this message,  is a placeholder for an actual table name for the entity.



CAUSE
This problem occurs because one or more of the following conditions are true:
 * The Microsoft CRM laptop client for Outlook does not have the permissions to access the BCP folder.
 * The version of Microsoft XML (MSXML) on the Microsoft CRM laptop client for Outlook is incorrect.
 * The offline data filters on the Microsoft CRM laptop client for Outlook are incorrect.
 * The Microsoft CRM server installation is corrupted.
 * The user account that runs the application pool on the Microsoft CRM Web site cannot access the offline data folder on the Microsoft CRM server.
 * The Microsoft SQL Server databases are moved to a new server. The Microsoft CRM System DSN ODBC Data Source on the Microsoft CRM server continues to point to the previous server that is running SQL Server.
 * The computer that is running SQL Server and that contains the MSCRM databases is sending more records than is typical to the offline database.
 * The /3GB switch has been added to the Boot.ini file on the Microsoft CRM Server. This problem causes the server to run out of memory when it tries to perform the BCP process.
 * Microsoft Data Access Components (MDAC) 2.8 Service Pack 1 (SP1) is not installed.



RESOLUTION
To resolve this problem, use one or more of the following methods.

Method 1
Grant permissions for the BCP folder to the Microsoft CRM laptop client for Outlook user. To do this, follow these steps:  Log on to the Microsoft CRM laptop client for Outlook computer, and then locate the BCP folder. Typically, the BCP folder is located on the following path on the client computer:

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

Notes  On a Windows Vista-based computer, the BCP folder is located on the following path:

C:\Users\ \AppData\Roaming\Microsoft\MSCRM\BCP

 In this step,  is a placeholder for the actual user name.  Locate and then right-click the folder. Then click Properties.</li> Click the Security tab.</li> From the Group or user names list, select the Microsoft CRM laptop client for Outlook user.</li> In the Permissions for  list, make sure that the Allow check box in the Full Control row is selected. Then click OK.

Note In this step,  is a placeholder for the actual user name.</li></ol>

Method 2
Make sure that the version of the Msxml4.dll file is at least 4.20.9828 on the client computer. To do this, follow these steps: <ol> Locate the system32 folder. Typically, this folder is located on the following path:

C:\WINDOWS\system32\</li> Locate and right-click the Msxml4.dll file, and then click Properties. Click the Version tab.</li> Verify whether the value for File version is at least 4.20.9828. If the value is earlier than this version, go to step 4.</li> If the version of the Msxml4.dll file is earlier than 4.20.9828, the file must be updated. For more information about how to obtain an updated file, visit the following Microsoft Web site:

http://support.microsoft.com/kb/887606/en-us

Notes  You can also obtain the Msxml4.dll file from the client installation CD. Typically, the Msxml4sp2-kb887606-x86-enu.exe file is located on the following path:

\Client\MSXML\KB887606\</li> This fix does not require that you restart the computer.</li></ul> </li></ol>

Method 3
Remove all the offline data filters, and then add and synchronize these filters one by one on the client computer. To remove the offline data filters, follow these steps:
 * 1) In the Microsoft CRM laptop client for Outlook, click Local Data on the CRM menu.
 * 2) In the Local Data dialog box, highlight all filters, click Deactivate, and then click OK.

To add and synchronize the filters, follow these steps:
 * 1) On the CRM menu, click Local Data.
 * 2) Click the Inactive Data Groups tab.
 * 3) Select one of the filters. Then click Activate.
 * 4) Click OK.
 * 5) Click Go Offline to start the synchronization process. Then click Go Online to complete the synchronization process.
 * 6) Repeat steps 3 through 5 for each deactivated filter.

Method 4
Run the repair process on the Microsoft CRM server. To do this, follow these steps:
 * 1) Log on to the Microsoft CRM server. Click Start, click Control Panel, and then click Add or Remove Programs.
 * 2) Click Microsoft CRM Server. Then click Change/Remove.
 * 3) Click the Repair option. Then click Next to start the Microsoft CRM 3.0 Server Setup wizard.

Method 5
Make sure that the user account that runs the application pool on the Microsoft CRM Web site can access the OfflineData folder. This folder stores the BCP (Bulk Copy Process) data files that the client obtains from the server that is running SQL Server. To make sure that the OfflineData folder can be accessed, follow these steps: <ol> Determine which account is running the application pool. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> Log on to the Microsoft CRM server.</li> Click Start, click Administrative Tools, and then click Internet Information Services (IIS) Manager.</li> Expand the local computer name, expand Application Pools, right-click CRMAppPool, and then click Properties.</li> Click the Identity tab.</li> <li>Verify permissions according to the following guidelines:

If the Predefined option is selected, both the NetworkService and LocalSystem accounts are represented by the  \ $ account. Therefore, when you must verify permissions for the NetworkService account or for the LocalSystem account, you must also verify permissions for the  \ $ account.

If the Configurable option is selected, you must verify permissions for the specified user account.

Note If the Predefined option is selected, use the  account as the user in step 5. If the Configurable option is selected, use the specified user account as the user in step 5.</li></ol> </li> <li>On the Microsoft CRM server, locate the following folder:



Note In this step,  is a placeholder for the actual drive on which you installed Microsoft CRM.</li> <li>Right-click the folder. Then click Properties.</li> <li>Click the Security tab.</li> <li>From the Group or user names list, select the user who you identified in step 1.</li> <li>In the Permissions for  list, make sure that the Allow check box in the Full Control row is selected. Then click OK.

Note In this step,  is a placeholder for the actual user name.</li></ol>

Method 6
Modify the Microsoft CRM System DSN ODBC Data Source on the Microsoft CRM server to point to the new server that is running SQL Server. To do this, follow these steps:
 * 1) Click Start, point to Administrative Tools, and then click Data Sources (ODBC).
 * 2) In the ODBC Data Source Administrator dialog box, click the System DSN tab, click the Microsoft CRM in the System Data Sources list, and then click Configure.
 * 3) In the first Microsoft SQL Server DSN Configuration window, locate the Server list that contains the names of computers that are running SQL Server. Click the server that you want to connect to.
 * 4) Click Next three times to configure the data source.
 * 5) Click Finish.
 * 6) In the ODBC Microsoft SQL Server Setup window, click Test Data Source to validate the connection to the server.
 * 7) Click OK two times to complete the configuration.
 * 8) Click OK to close the ODBC Data Source Administrator dialog box.

Method 7
<ol> <li>Exit Microsoft Dynamics CRM 3.0.</li> <li>Click Start, click Run, type regedit, and then click OK.</li> <li>Locate and then click the following registry subkey:

</li> <li>Right-click the OfflineRowsBatchSize DWORD value, and then click Modify.</li> <li>In the Value data box, type a value that is smaller than the current value, such as 10 or 1. Then click OK.

Note By default, the OfflineRowsBatchSize DWORD value is set to 100000.</li> <li>Exit Registry Editor.</li></ol>

Method 8
Remove the /3GB switch from the Boot.ini file on the Microsoft CRM server. For the change to take effect, you must restart the computer after you remove the switch.

Method 9
Install MDAC 2.8 Service Pack 1. To install MDAC 2.8 SP1, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=78CAC895-EFC2-4F8E-A9E0-3A1AFBD5922E&displaylang=en

Method 10
If recent updates to the Windows operating system were applied to the Microsoft Dynamics CRM server or to the server that is running SQL Server, restart the affected server.

<div class="moreinformation_section">

MORE INFORMATION
If you still experience the problem that is described in the &quot;Symptoms&quot; section, 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: &quot;Failed move data for entity&quot;

<div class="references_section">