Error installing AbleCommerceGold-GoldR11SR1-b8858-WAP

[mbartens]

I'm trying to install the demo site locally. We have an active version of R9-b7670 that is customized. I'd like to get V11 up and running and run a file and db schema compare and move the changes over. I'm guessing I should add the customization to R11.

I'm getting ahead of myself though, I've tried multiple times to install 11 and I keep getting errors. I've set all the files in the Website directory with the IIS account for Full Control just to rule that out.
I'm using SQLExporess (SQL Server 10.50.4042) on my local machine. I tried starting the site in Visual Studio but couldn't get past the database login. I also tried starting the site in IIS locally, same problem.
When that didn't work I tried to remote in to our development server and started the install via iis. That failed so I went to my browser and started the install that way. Same error.
At this point I'm guessing it's locked?
Also, I created a new blank database where I want this installed on.
Here's the errors from the AppLog:

Code: Select all

2016-04-13 10:18:00,933 ERROR AbleCommerce         An error has occured at http://srvdev2/Clients/Able11/Website/Errors/GeneralError.aspx?aspxerrorpath=/Clients/Able11/Website/Install/Configure1.aspx
System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.ArgumentException: Format of the initialization string does not conform to specification starting at index 0.
   at System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String& keyname, String& keyvalue)
   at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)
   at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)
   at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
   at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key)
   at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
   at NHibernate.Connection.DriverConnectionProvider.GetConnection()
   at NHibernate.Tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.Prepare()
   at NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.GetReservedWords(Dialect dialect, IConnectionHelper connectionHelper)
   at NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.Update(ISessionFactory sessionFactory)
   at NHibernate.Impl.SessionFactoryImpl..ctor(Configuration cfg, IMapping mapping, Settings settings, EventListeners listeners)
   at NHibernate.Cfg.Configuration.BuildSessionFactory()
   at CommerceBuilder.Common.DatabaseConfiguration.get_SessionFactory()
   at CommerceBuilder.Common.DatabaseSessionManager.GetSession()
   at CommerceBuilder.DomainModel.NHibernateHelper.QueryOver[T]()
   at CommerceBuilder.Services.StoreLocator.LocateCurrent()
   at CommerceBuilder.Common.AbleContext.get_Store()
   at AbleCommerce.Errors.GeneralError.GetContact()
   at ASP.errors_generalerror_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer)
   at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
   at System.Web.UI.Page.Render(HtmlTextWriter writer)
   at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
2016-04-13 10:18:00,960 ERROR AbleCommerce         Could not write to online error log.
System.ArgumentException: Format of the initialization string does not conform to specification starting at index 0.
   at System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String& keyname, String& keyvalue)
   at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)
   at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)
   at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
   at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key)
   at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
   at NHibernate.Connection.DriverConnectionProvider.GetConnection()
   at NHibernate.Tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.Prepare()
   at NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.GetReservedWords(Dialect dialect, IConnectionHelper connectionHelper)
   at NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.Update(ISessionFactory sessionFactory)
   at NHibernate.Impl.SessionFactoryImpl..ctor(Configuration cfg, IMapping mapping, Settings settings, EventListeners listeners)
   at NHibernate.Cfg.Configuration.BuildSessionFactory()
   at CommerceBuilder.Common.DatabaseConfiguration.get_SessionFactory()
   at CommerceBuilder.Utility.Logger.a(MessageSeverity A_0, String A_1, String A_2)

[jmestep]

Do you have the full set of files for R11? That would be the original R11 with the files from the patch copied over since the patch didn't include all the site files, just the changed ones.
This wouldn't be causing a problem with the install, but make sure you want the WAP version because you will have to recompile the site after you make some of the changes- you can't make them on the fly like you can in the WSP version. Your live sites might be running WSP version. If they have a folder App_Code and you have not added that folder, they are running WSP version.

[mazhar]

Make sure under App_Data folder you have a file called database.config. Before any successful install its content should be

Code: Select all

<connectionStrings>
  <add name="AbleCommerce" connectionString="CONNECTIONSTRING" providerName="System.Data.SqlClient" />
</connectionStrings>

Now try to install from /install/default.aspx and provide the required details. After successful install the database.config should have your connection details. In your web.config you can turn off custom errors to get more detailed error instead of being redirected to GeneralError page.

[mbartens]

I unzipped the file to start fresh this morning and I initially got an error while entering the db info with a username and password so I copied the connection string from the other site that doesn't use credentials and changed the database name and it worked.
So I'm not sure what I did wrong but it works now so I'm happy
Thank you everyone

[mazhar]

Glad that its working for you now, may database connection credentials were not correct in attempt you made before.