Solution Import Issues 

When we are trying to import large customization files into CRM , the issues I encountered are :

1. Timeout Exceeded
2. MaxRequest Length Exceeded

The Error message we recieve is mentioned below :

System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Crm.Setup.DatabaseInstaller.DatabaseUtility.ExecuteSql(InstallDatabase database, String sql, Int32 timeout) at Microsoft.Crm.Setup.DatabaseInstaller.SqlScriptAction.Execute() at Microsoft.Crm.Setup.DatabaseInstaller.DatabaseInstaller.Install(Int32 languageCode, String file, Boolean upgrade) at Microsoft.Crm.Setup.Server.InstallDatabaseAction.Do(IDictionary parameters) at Microsoft.Crm.Setup.Common.Action.ExecuteAction(Action action, IDictionary parameters, Boolean undo) --- End of inner exception stack trace --- at Microsoft.Crm.Setup.Common.Action.ExecuteAction(Action action, IDictionary parameters, Boolean undo) at Microsoft.Crm.Setup.Common.Installer.Install(IDictionary stateSaver) at Microsoft.Crm.Setup.Server.DatabaseInstaller.Install(IDictionary stateSaver) at Microsoft.Crm.Setup.Common.ComposedInstaller.InternalInstall(IDictionary stateSaver) at Microsoft.Crm.Setup.Common.ComposedInstaller.Install(IDictionary stateSaver) at Microsoft.Crm.Setup.Server.ServerSetup.Upgrade(IDictionary data) at Microsoft.Crm.Setup.Server.ServerSetup.Run()


If it is regarding to Http Timeout , perform below operations : 

1. open IIS Manager ( Internet Information Services) 
2. Navigate to Sites > Microsoft Dynamics CRM
3. Right click and open Web.config
4. Find the line : <httpRuntime executionTimeout="300" maxRequestLength="8192"/>

The max exceutionTimeout we can provide is "3600" and the maxrequestLength - "20000"

5. After modifying above mentioned values according to need , perform IIS Reset and try import\export operation again.

Note : Please revert back the changes after the required operation is completed as it will effect performance of the org

2. As Microsoft ASP.Net limits HTTP Requests to 8MB , if the solution size exceeds 8MB it will limit the operations

OLEDB Setting : Command Timeout ( Reg Key settings ) :

1.Locate HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM
2. Create new DWord Value , edit value to 86400 

Max value setting : 2,147,483,647