U4-2788 - Error installing Umbraco 6.1.5 with SQL CE 4 option

Created by Tito 04 Sep 2013, 10:12:34 Updated by Sebastiaan Janssen 30 Sep 2013, 12:52:41

Note that i have more umbraco installations working in this server. I have installed Umbraco 6.0.7 and it works. I think it is about Umbraco 6.1.x

The step 3 installing database with the SQL CE 4 option fails at 90% showing this error: The database configuration failed with the following message: Keyword not supported: 'file access retry timeout'. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')

I see this exception in the umbraco trace log:

2013-09-04 12:02:52,330 [40] WARN Umbraco.Web.UmbracoModule - [Thread 57] Umbraco is not configured 2013-09-04 12:02:55,534 [40] ERROR Umbraco.Core.UmbracoApplicationBase - [Thread 58] An unhandled exception occurred System.Web.HttpUnhandledException (0x80004005): Se produjo una excepci├│n de tipo 'System.Web.HttpUnhandledException'. ---> System.Data.SqlServerCe.SqlCeException (0x80004005): The database file cannot be found. Check the path to the database. [ Data Source = C:\Inetpub\vhosts\icreativos.com\subdomains\maqueta4\App_Data\Umbraco.sdf ] en System.Data.SqlServerCe.SqlCeConnection.ProcessResults(Int32 hr) en System.Data.SqlServerCe.SqlCeConnection.Open(Boolean silent) en System.Data.SqlServerCe.SqlCeConnection.Open() en Umbraco.Core.Persistence.FaultHandling.RetryPolicy.<>c__DisplayClass1.b__0() en Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) en Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction(Action action) en Umbraco.Core.Persistence.PetaPocoConnectionExtensions.OpenWithRetry(IDbConnection connection, RetryPolicy retryPolicy) en Umbraco.Core.Persistence.PetaPocoConnectionExtensions.OpenWithRetry(IDbConnection connection) en Umbraco.Core.Persistence.Database.OpenSharedConnection() en Umbraco.Core.Persistence.Database.<Query>d__71.MoveNext() en System.Collections.Generic.List1..ctor(IEnumerable1 collection) en System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) en Umbraco.Core.Persistence.SqlSyntax.SqlCeSyntaxProvider.GetTablesInSchema(Database db) en Umbraco.Core.Persistence.Migrations.Initial.DatabaseSchemaCreation.ValidateSchema() en Umbraco.Core.DatabaseContext.ValidateDatabaseSchema() en Umbraco.Web.UI.Install.Steps.Welcome.Page_Load(Object sender, EventArgs e) en System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) en System.Web.UI.Control.OnLoad(EventArgs e) en System.Web.UI.Control.LoadRecursive() en System.Web.UI.Control.LoadRecursive() en System.Web.UI.Control.LoadRecursive() en System.Web.UI.Control.LoadRecursive() en System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) en System.Web.UI.Page.HandleError(Exception e) en System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) en System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) en System.Web.UI.Page.ProcessRequest() en System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) en System.Web.UI.Page.ProcessRequest(HttpContext context) en ASP.install_default_aspx.ProcessRequest(HttpContext context) en System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() en System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

1 Attachments

Download UmbracoTraceLog.txt

Comments

Sebastiaan Janssen 04 Sep 2013, 12:52:39

Seems like a permissions issue, make sure the application pool user has modify rights on the App_Data folder.


Tito 04 Sep 2013, 15:58:12

I have a bat file that set permissions for the app_data. In fact, i have installed 6.0.7 with no problems in the same folder


Tito 04 Sep 2013, 16:02:11

I have a bat file that set permissions for the app_data. In fact, i have installed 6.0.7 with no problems in the same folder. Its with 6.1.x versions. I attach the entire umbracotracelog.txt to this comment, may be its another issue..


Sebastiaan Janssen 04 Sep 2013, 16:34:58

Actually I think this is your problem: http://forums.asp.net/t/1844679.aspx/1?Keyword+not+supported+file+access+retry+timeout+

Which means that you're not using the SQLCE dll that we ship with Umbraco.


Tito 04 Sep 2013, 22:13:58

Thanks Sebastiaan, so i have to update to SQL Server CE 4.0 SP1? why versions bellow 6.1.x work?


Sebastiaan Janssen 05 Sep 2013, 06:38:36

@Alberto You really shouldn't need to do anything but make sure the System.Data.SqlServerCe and System.Data.SqlServerCe.Entity dlls are in your bin folder and either the amd64 or x86 folder is in your bin folder. Like all other v6 versions of Umbraco.


Tito 05 Sep 2013, 09:33:53

Yes, that dlls are in the bin folder, i downloaded the UmbracoCms.WebPI.6.1.5.zip from http://our.umbraco.org/contribute/releases/615, changed umbracoSettings.config render forms to Mvc, set permissions and begin the installation. Its the same process i use for every 6.x Umbraco installation. The only difference is that 6.1.x dont work for me this way. Thanks


Sebastiaan Janssen 05 Sep 2013, 15:16:28

We changed to the newer SQL CE version in 6.1.0 I think so the issue might be that because you have SQL CE installed that it prefers to use your installed version over the version in the bin folder (but I'm not sure).

So in that case, I would recommend upgrading your SQL CE install (or, if you're not actually using it for anything you can just uninstall it, we made it so that it runs as a stand-alone version and is not required to be installed anywhere on your system).

Also: Why are you using the WebPI (Web Platform Installer) version? UmbracoCms.6.1.5.zip is the version everybody should use. The WebPI version is specifically there so that the Windows Application Gallery can download and use it in WebMatrix and the Web Platform Installer. It's not different at all, but you shouldn't need to download that version.


Sebastiaan Janssen 30 Sep 2013, 12:52:41

I've removed the "File Access Retry Timeout" setting for now until we can figure out why exactly it is not using the SQLCE files from the bin folder.


Priority: Normal

Type: Bug

State: Fixed

Assignee:

Difficulty: Normal

Category:

Backwards Compatible: True

Fix Submitted:

Affected versions:

Due in version: 6.1.6

Sprint:

Story Points:

Cycle: