strange error for access orchard.sdf

Topics: Installing Orchard
Oct 22, 2013 at 11:23 PM
clean orchard 1.7.1 zip deploy to gearhost.com to install
the technical support said it is Path error, because they do not have d:\

but i do not think so.

2013-10-22 11:00:12,232 [13] NHibernate.Transaction.AdoTransaction - Begin transaction failed
System.Data.SqlServerCe.SqlCeException (0x80004005): Internal error: Unable to successfully execute disk IO on the file system.
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)
2013-10-22 11:00:12,248 [13] Orchard.Data.Migration.DataMigrationManager - Error while running migration version 4 for Settings
NHibernate.TransactionException: Begin failed with SQL exception ---> System.Data.SqlServerCe.SqlCeException: Internal error: Unable to successfully execute disk IO on the file system.
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.RequireNew(IsolationLevel level) in d:\Builds\OrchardFull\src\Orchard\Data\SessionLocator.cs:line 67
at Orchard.Data.SessionLocator.RequireNew() in d:\Builds\OrchardFull\src\Orchard\Data\SessionLocator.cs:line 49
at Orchard.Data.Migration.DataMigrationManager.Update(String feature) in d:\Builds\OrchardFull\src\Orchard\Data\Migration\DataMigrationManager.cs:line 94
2013-10-22 11:00:12,592 [13] Orchard.Data.Migration.DataMigrationManager - Error while running migration version 4 for Settings
System.ObjectDisposedException: Cannot access a disposed object.
Object name: 'AdoTransaction'.
at NHibernate.Transaction.AdoTransaction.CheckNotDisposed()
at NHibernate.Transaction.AdoTransaction.Rollback()
at Orchard.Data.SessionLocator.RequireNew(IsolationLevel level) in d:\Builds\OrchardFull\src\Orchard\Data\SessionLocator.cs:line 56
at Orchard.Data.SessionLocator.RequireNew() in d:\Builds\OrchardFull\src\Orchard\Data\SessionLocator.cs:line 49
at Orchard.Data.Migration.DataMigrationManager.Update(String feature) in d:\Builds\OrchardFull\src\Orchard\Data\Migration\DataMigrationManager.cs:line 94
2013-10-22 11:00:12,654 [13] Orchard.Data.Migration.DataMigrationManager - Error while running migration version 4 for Common
System.ObjectDisposedException: Cannot access a disposed object.
Object name: 'AdoTransaction'.
at NHibernate.Transaction.AdoTransaction.CheckNotDisposed()
at NHibernate.Transaction.AdoTransaction.Rollback()
at Orchard.Data.SessionLocator.RequireNew(IsolationLevel level) in d:\Builds\OrchardFull\src\Orchard\Data\SessionLocator.cs:line 56
at Orchard.Data.SessionLocator.RequireNew() in d:\Builds\OrchardFull\src\Orchard\Data\SessionLocator.cs:line 49
at Orchard.Data.Migration.DataMigrationManager.Update(String feature) in d:\Builds\OrchardFull\src\Orchard\Data\Migration\DataMigrationManager.cs:line 94
2013-10-22 11:00:13,201 [13] Orchard.Data.Migration.DataMigrationManager - Error while running migration version 1 for Scheduling
System.ObjectDisposedException: Cannot access a disposed object.
Object name: 'AdoTransaction'.
at NHibernate.Transaction.AdoTransaction.CheckNotDisposed()
at NHibernate.Transaction.AdoTransaction.Rollback()
at Orchard.Data.SessionLocator.RequireNew(IsolationLevel level) in d:\Builds\OrchardFull\src\Orchard\Data\SessionLocator.cs:line 56
at Orchard.Data.SessionLocator.RequireNew() in d:\Builds\OrchardFull\src\Orchard\Data\SessionLocator.cs:line 49
at Orchard.Data.Migration.DataMigrationManager.Update(String feature) in d:\Builds\OrchardFull\src\Orchard\Data\Migration\DataMigrationManager.cs:line 94
2013-10-22 11:00:13,592 [13] NHibernate.AssertionFailure - An AssertionFailure occurred - this may indicate a bug in NHibernate or in your custom types.
NHibernate.AssertionFailure: null identifier
2013-10-22 11:00:13,592 [13] Orchard.Exceptions.DefaultExceptionPolicy - An unexpected exception was caught
NHibernate.AssertionFailure: null identifier
at NHibernate.Engine.EntityKey..ctor(Object identifier, String rootEntityName, String entityName, IType identifierType, Boolean batchLoadable, ISessionFactoryImplementor factory, EntityMode entityMode)
at NHibernate.Engine.EntityKey..ctor(Object id, IEntityPersister persister, EntityMode entityMode)
at NHibernate.Event.Default.AbstractSaveEventListener.PerformSaveOrReplicate(Object entity, EntityKey key, IEntityPersister persister, Boolean useIdentityColumn, Object anything, IEventSource source, Boolean requiresImmediateIdAccess)
at NHibernate.Event.Default.AbstractSaveEventListener.PerformSave(Object entity, Object id, IEntityPersister persister, Boolean useIdentityColumn, Object anything, IEventSource source, Boolean requiresImmediateIdAccess)
at NHibernate.Event.Default.AbstractSaveEventListener.SaveWithGeneratedId(Object entity, String entityName, Object anything, IEventSource source, Boolean requiresImmediateIdAccess)
at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.SaveWithGeneratedOrRequestedId(SaveOrUpdateEvent event)
at NHibernate.Event.Default.DefaultSaveEventListener.SaveWithGeneratedOrRequestedId(SaveOrUpdateEvent event)
at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.EntityIsTransient(SaveOrUpdateEvent event)
at NHibernate.Event.Default.DefaultSaveEventListener.PerformSaveOrUpdate(SaveOrUpdateEvent event)
at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.OnSaveOrUpdate(SaveOrUpdateEvent event)
at NHibernate.Impl.SessionImpl.FireSave(SaveOrUpdateEvent event)
at NHibernate.Impl.SessionImpl.Save(Object obj)
at Orchard.Data.Repository1.Create(T entity) in d:\Builds\OrchardFull\src\Orchard\Data\Repository.cs:line 96
at Orchard.Data.Repository
1.Orchard.Data.IRepository<T>.Create(T entity) in d:\Builds\OrchardFull\src\Orchard\Data\Repository.cs:line 36
at Orchard.Roles.Services.RoleService.CreateRole(String roleName)
at Orchard.Roles.DefaultRoleUpdater.AddDefaultRolesForFeature(Feature feature)
at Orchard.Roles.DefaultRoleUpdater.Orchard.Environment.IFeatureEventHandler.Installing(Feature feature)
at Orchard.Events.DelegateHelper.<>c__DisplayClass2b2.<BuildAction>b__2a(Object target, Object[] p) in d:\Builds\OrchardFull\src\Orchard\Events\DelegateHelper.cs:line 116
at Orchard.Events.DefaultOrchardEventBus.TryInvokeMethod(IEventHandler eventHandler, Type interfaceType, String messageName, String interfaceName, String methodName, IDictionary
2 arguments, IEnumerable& returnValue) in d:\Builds\OrchardFull\src\Orchard\Events\DefaultOrchardEventBus.cs:line 80
at Orchard.Events.DefaultOrchardEventBus.TryNotifyHandler(IEventHandler eventHandler, String messageName, String interfaceName, String methodName, IDictionary`2 eventData, IEnumerable& returnValue) in d:\Builds\OrchardFull\src\Orchard\Events\DefaultOrchardEventBus.cs:line 53
2013-10-22 11:00:13,732 [13] Orchard.Data.Migration.DataMigrationManager - Error while running migration version 1 for Orchard.Themes
System.ObjectDisposedException: Cannot access a disposed object.
Object name: 'AdoTransaction'.
at NHibernate.Transaction.AdoTransaction.CheckNotDisposed()
at NHibernate.Transaction.AdoTransaction.Rollback()
at Orchard.Data.SessionLocator.RequireNew(IsolationLevel level) in d:\Builds\OrchardFull\src\Orchard\Data\SessionLocator.cs:line 56
at Orchard.Data.SessionLocator.RequireNew() in d:\Builds\OrchardFull\src\Orchard\Data\SessionLocator.cs:line 49
at Orchard.Data.Migration.DataMigrationManager.Update(String feature) in d:\Builds\OrchardFull\src\Orchard\Data\Migration\DataMigrationManager.cs:line 94
2013-10-22 11:00:14,467 [13] Orchard.Data.Migration.DataMigrationManager - Error while running migration version 2 for Title
System.ObjectDisposedException: Cannot access a disposed object.
Object name: 'AdoTransaction'.
at NHibernate.Transaction.AdoTransaction.CheckNotDisposed()
at NHibernate.Transaction.AdoTransaction.Rollback()
at Orchard.Data.SessionLocator.RequireNew(IsolationLevel level) in d:\Builds\OrchardFull\src\Orchard\Data\SessionLocator.cs:line 56
at Orchard.Data.SessionLocator.RequireNew() in d:\Builds\OrchardFull\src\Orchard\Data\SessionLocator.cs:line 49
at Orchard.Data.Migration.DataMigrationManager.Update(String feature) in d:\Builds\OrchardFull\src\Orchard\Data\Migration\DataMigrationManager.cs:line 94
2013-10-22 11:00:14,904 [13] NHibernate.AssertionFailure - An AssertionFailure occurred - this may indicate a bug in NHibernate or in your custom types.
NHibernate.AssertionFailure: null identifier
Oct 22, 2013 at 11:28 PM
but the following i got strange path on another site instance (not clean 1.7.1,more modules)
notice the path c:\Users\sebros\Documents\My Projects\nhibernate-core\src\NHibernate\Connection\DriverConnectionProvider.cs:line 46
both my computer and gearhost do not have c:\Users\sebros\Documents\
??????????????????????????????????????????????

2013-10-22 09:49:02,875 [12] NHibernate.Transaction.AdoTransaction - Begin transaction failed
System.Data.SqlServerCe.SqlCeException (0x80004005): Internal error: Unable to successfully execute disk IO on the file system.
at System.Data.SqlServerCe.SqlCeConnection.Open(Boolean silent)
at System.Data.SqlServerCe.SqlCeConnection.Open()
at NHibernate.Connection.DriverConnectionProvider.GetConnection() in c:\Users\sebros\Documents\My Projects\nhibernate-core\src\NHibernate\Connection\DriverConnectionProvider.cs:line 46
at NHibernate.AdoNet.ConnectionManager.GetConnection() in c:\Users\sebros\Documents\My Projects\nhibernate-core\src\NHibernate\AdoNet\ConnectionManager.cs:line 196
at NHibernate.Impl.SessionImpl.get_Connection() in c:\Users\sebros\Documents\My Projects\nhibernate-core\src\NHibernate\Impl\SessionImpl.cs:line 1634
at NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel isolationLevel) in c:\Users\sebros\Documents\My Projects\nhibernate-core\src\NHibernate\Transaction\AdoTransaction.cs:line 137
2013-10-22 09:49:02,907 [12] Orchard.Data.Migration.DataMigrationManager - Error while running migration version 6 for Navigation
NHibernate.TransactionException: Begin failed with SQL exception ---> System.Data.SqlServerCe.SqlCeException: Internal error: Unable to successfully execute disk IO on the file system.
at System.Data.SqlServerCe.SqlCeConnection.Open(Boolean silent)
at System.Data.SqlServerCe.SqlCeConnection.Open()
at NHibernate.Connection.DriverConnectionProvider.GetConnection() in c:\Users\sebros\Documents\My Projects\nhibernate-core\src\NHibernate\Connection\DriverConnectionProvider.cs:line 46
at NHibernate.AdoNet.ConnectionManager.GetConnection() in c:\Users\sebros\Documents\My Projects\nhibernate-core\src\NHibernate\AdoNet\ConnectionManager.cs:line 196
at NHibernate.Impl.SessionImpl.get_Connection() in c:\Users\sebros\Documents\My Projects\nhibernate-core\src\NHibernate\Impl\SessionImpl.cs:line 1634
at NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel isolationLevel) in c:\Users\sebros\Documents\My Projects\nhibernate-core\src\NHibernate\Transaction\AdoTransaction.cs:line 137
--- End of inner exception stack trace ---
at NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel isolationLevel) in c:\Users\sebros\Documents\My Projects\nhibernate-core\src\NHibernate\Transaction\AdoTransaction.cs:line 148
at NHibernate.Impl.SessionImpl.BeginTransaction(IsolationLevel isolationLevel) in c:\Users\sebros\Documents\My Projects\nhibernate-core\src\NHibernate\Impl\SessionImpl.cs:line 1451
at Orchard.Data.SessionLocator.RequireNew(IsolationLevel level) in g:\orchard172near-zg\orchard\src\Orchard\Data\SessionLocator.cs:line 71
at Orchard.Data.SessionLocator.RequireNew() in g:\orchard172near-zg\orchard\src\Orchard\Data\SessionLocator.cs:line 49
at Orchard.Data.Migration.DataMigrationManager.Update(String feature) in g:\orchard172near-zg\orchard\src\Orchard\Data\Migration\DataMigrationManager.cs:line 94
2013-10-22 09:49:02,938 [12] NHibernate.Util.ADOExceptionReporter - Internal error: Unable to successfully execute disk IO on the file system.
2013-10-22 09:49:02,953 [12] NHibernate.Util.ADOExceptionReporter - Internal error: Unable to successfully execute disk IO on the file system.
2013-10-22 09:49:02,953 [12] NHibernate.Util.ADOExceptionReporter - Internal error: Unable to successfully execute disk IO on the file system.
2013-10-22 09:49:02,953 [12] Orchard.Exceptions.DefaultExceptionPolicy - An unexpected exception was caught
NHibernate.Exceptions.GenericADOException: could not execute query
[ select datamigrat0_.Id as Id19_, datamigrat0_.DataMigrationClass as DataMigr2_19_, datamigrat0_.Version as Version19_ from Orchard_Framework_DataMigrationRecord datamigrat0_ where datamigrat0_.DataMigrationClass=? ORDER BY GETDATE() OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY ]
Name:p1 - Value:Orchard.ContentPicker.Migrations
[SQL: select datamigrat0_.Id as Id19_, datamigrat0_.DataMigrationClass as DataMigr2_19_, datamigrat0_.Version as Version19_ from Orchard_Framework_DataMigrationRecord datamigrat0_ where datamigrat0_.DataMigrationClass=? ORDER BY GETDATE() OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY] ---> System.Data.SqlServerCe.SqlCeException: Internal error: Unable to successfully execute disk IO on the file system.
at System.Data.SqlServerCe.SqlCeConnection.Open(Boolean silent)
at System.Data.SqlServerCe.SqlCeConnection.Open()
at NHibernate.Connection.DriverConnectionProvider.GetConnection() in c:\Users\sebros\Documents\My Projects\nhibernate-core\src\NHibernate\Connection\DriverConnectionProvider.cs:line 46
at NHibernate.AdoNet.ConnectionManager.GetConnection() in c:\Users\sebros\Documents\My Projects\nhibernate-core\src\NHibernate\AdoNet\ConnectionManager.cs:line 196
at NHibernate.AdoNet.AbstractBatcher.Prepare(IDbCommand cmd) in c:\Users\sebros\Documents\My Projects\nhibernate-core\src\NHibernate\AdoNet\AbstractBatcher.cs:line 96
========================= too long
Oct 22, 2013 at 11:43 PM
strange enough is the same code had run well on their v2( which use iis7.5),
but not v3 (which use iis8)
Coordinator
Oct 23, 2013 at 12:17 AM
Edited Oct 23, 2013 at 12:18 AM
The c:\Users\sebros\Documents\ and d:\Builds\OrchardFull\src paths are completely irrelevant and the support people from Gearhost should know that: it's just where the code was compiled, that's all. The problem is very likely that you don't have the permissions to write into app_data.
Oct 23, 2013 at 12:55 AM
Edited Oct 23, 2013 at 1:04 AM
i guessed that . and told that to them , but they said i have the WRITE permission. i strongly agree with you. i will tell them again.thanks
Coordinator
Oct 23, 2013 at 1:00 AM
Looks like they are lying or not looking at the right user permissions.
Oct 23, 2013 at 4:25 AM
Hi, my name is Mike and I'm with GearHost support. Correct me if I am wrong but if this were a permissions issue wouldn't the Orchard install fail? I've setup Orchard on two different accounts and I tested by simply unzipping the files and also publishing through web matrix. both methods worked. Both sites below are on separate accounts and they are fresh installs I did today.

http://005033-orchard-test.com.v3.cloudsites.gearhost.com/
http://ghmk-orchard-test.com.v3.cloudsites.gearhost.com/

I understand the paths in the error log are from the build. I assumed the error is created because the application is still referencing them.

I obviously have minimal experience with Orchard. The customer is moving their site over from another platform that uses a different file system with different paths. I'm not sure how the connection string references the SQLCE file, if it is absolute that path changed which I provided to the customer. Even being a relative path that may have changed as well depending on if the customer places the sdf outside their domain root.

The connection strings in the settings.txt file appear to be encrypted.

Sorry for the long response, I'm eager to get to the bottom of this as well.
Oct 23, 2013 at 4:52 AM
Edited Oct 23, 2013 at 5:13 AM
my site can run now,look like i can write data to the db, but often got yellow page(especially on admin panel) said:
Internal error: Unable to successfully execute disk IO on the file system
http://www.realestateinfoexchange.com/

which is in the same enviroment as

http://005033-orchard-test.com.v3.cloudsites.gearhost.com/
http://ghmk-orchard-test.com.v3.cloudsites.gearhost.com/
Coordinator
Oct 26, 2013 at 8:14 AM
I would recommend not using SQL CE on such an environment: multiple servers in a farm accessing a single DB in a shared file system is a recipe for failure.