Oops. Something went wrong ... sorry

Topics: General
Oct 21, 2013 at 4:23 PM
Hello everyone.
Finally I just release my Orchard site!
The only drawback that I have so far is that quite often I get the following error:

Oops. Something went wrong ... sorry
An unhandled exception has occurred and the request was terminated. Please refresh the page. If the error persists, go back

Begin failed with SQL exception

NHibernate.TransactionException: Begin failed with SQL exception ---> System.Data.SqlServerCe.SqlCeException: There is a file sharing violation. A different process might be using the file. [ \hmfsw\web\dtc008\xaradev.com\public_html\App_Data\Sites\Default\Orchard.sdf ] at System.Data.SqlServerCe.SqlCeConnection.ProcessResults(Int32 hr) at System.Data.SqlServerCe.SqlCeConnection.Open(Boolean silent) at System.Data.SqlServerCe.SqlCeConnection.Open() at NHibernate.Connection.DriverConnectionProvider.GetConnection() at NHibernate.AdoNet.ConnectionManager.GetConnection() at NHibernate.Impl.SessionImpl.get_Connection() at NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel isolationLevel) --- End of inner exception stack trace --- at NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel isolationLevel) at NHibernate.Impl.SessionImpl.BeginTransaction(IsolationLevel isolationLevel) at Orchard.Data.SessionLocator.Demand() in d:\Builds\OrchardFull\src\Orchard\Data\SessionLocator.cs:line 44 at Orchard.Data.SessionLocator.For(Type entityType) in d:\Builds\OrchardFull\src\Orchard\Data\SessionLocator.cs:line 34 at Orchard.ContentManagement.DefaultContentManager.GetManyImplementation(QueryHints hints, Action2 predicate) in d:\Builds\OrchardFull\src\Orchard\ContentManagement\DefaultContentManager.cs:line 325 at Orchard.ContentManagement.DefaultContentManager.Get(Int32 id, VersionOptions options, QueryHints hints) in d:\Builds\OrchardFull\src\Orchard\ContentManagement\DefaultContentManager.cs:line 159 at Orchard.ContentManagement.DefaultContentManager.Get(Int32 id, VersionOptions options) in d:\Builds\OrchardFull\src\Orchard\ContentManagement\DefaultContentManager.cs:line 130 at Orchard.Core.Contents.Controllers.ItemController.Display(Int32 id) in d:\Builds\OrchardFull\src\Orchard.Web\Core\Contents\Controllers\ItemController.cs:line 26 at lambda_method(Closure , ControllerBase , Object[] ) at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary2 parameters) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary2 parameters) at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass13.<InvokeActionMethodWithFilters>b__10() at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func1 continuation) at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass13.<>c__DisplayClass15.<InvokeActionMethodWithFilters>b__12() at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func1 continuation) at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass13.<>c__DisplayClass15.<InvokeActionMethodWithFilters>b__12() at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func1 continuation)

???
Oct 22, 2013 at 11:39 PM
i have the similar issue, the site can be run, but it is not stable.
System.Data.SqlServerCe.SqlCeException (0x80004005): Internal error: Unable to successfully execute disk IO on the file system.
https://orchard.codeplex.com/discussions/463213
Oct 22, 2013 at 11:40 PM
i remember one tiome , i also got ur issue
System.Data.SqlServerCe.SqlCeException: There is a file sharing violation. A different process might be using the file
Coordinator
Oct 23, 2013 at 12:19 AM
SqlCe won't work properly in web farms where several processes or servers attempt to access one shared database file. It's simply not the right database to use in such situations. Use a full SQL Server instead or don't run on a web farm.
Oct 24, 2013 at 6:57 AM
Thank you very much BertrandLeRoy. I made ​​the conversion to full SQL Server, and now actually have not appeared more errors and the site in general, feel much lighter! Thank you very much.

This is work!