Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Import organization Failed MS CRM 4.0 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I got the error below during the import process:

    OLEDBTimeout is also set to

    86400  before we start the import process.

     

    Can you assist me please??

     



      Error| Import Organization (Name=IPTCRM, Id=f2b62ce3-4f01-e111-aafb-001e0b784ab6) failed with Exception:
    System.InvalidOperationException: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.
       at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)
       at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)
       at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command)
       at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate)
       at Microsoft.Crm.CrmDbConnection.SetTransactionIsolationLevel(IsolationLevel il)
       at Microsoft.Crm.CrmDbConnection.Dispose(Boolean disposing)
       at Microsoft.Crm.SqlExecutionContext.Dispose(Boolean disposing)
       at Microsoft.Crm.SqlExecutionContext.Dispose()
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.Import(Guid organizationId, String organizationUniqueName, String organizationFriendlyName, String sqlServerName, String databaseName, Uri reportServerUrl, String privilegedUserGroupName, String sqlAccessGroupName, String userGroupName, String reportingGroupName, String privilegedReportingGroupName, ICollection`1 users, MultipleTenancy multipleTenancy)
    20:36:55|Warning| Attempting to cancel a long running process: ProgressWizard. This might leave the data in an invalid state and the application might not function correctly.
    20:41:02|Warning| Attempting to cancel a long running process: FinishWizard. This might leave the data in an invalid state and the application might not function correctly.

    hussain
    Friday, October 28, 2011 7:23 PM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi Hussain,

    Add the OLEDBTimeout and the ExtendedTimeout registry subkeys to increase the time-out values

    1. Click Start, click Run, type regedit, and then click OK.
    2. Locate the following registry subkey:
      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM
    3. Right-click MSCRM, point to New, and then click DWORD Value to create a new DWORD value.
    4. Rename the DWORD value to the following value:
      OLEDBTimeout
    5. Right-click the DWORD value, and then click Modify.
    6. In the Edit DWORD Value dialog box, type 86400 in the Value data box, click Decimal in the Base option, and then click OK.Note According to the requirement of the computer that is running SQL server and the number of customization files, the value can be larger than 86400. The value of 86400 is equivalent to 24 hours.
    7. Right-click MSCRM, point to New, and then click DWORD Value to create a new DWORD value.
    8. Rename the DWORD value to the following value:
      ExtendedTimeout
    9. Right-click the DWORD value, and then click Modify.
    10. In the Edit DWORD Value dialog box, type 1000000 in the Value data box, and then click OK.Notes
      • In the Value data box, you can type a value that is larger than 1,000,000. However, do not type a value that is larger than 2,147,483,647. This is hexadecimal 0x7FFFFFFF.
      • If this key already exists, notice the current value. After you have completed the import or the upgrade for Microsoft Dynamics CRM, set the value of this key back to the original value or delete the key if it did not previously exist. The default OLEDB timeout value is 30 seconds
    Thanks & Regards, MS CRM Consultant, V.Surya.
    Saturday, October 29, 2011 9:03 AM
    Answerer