Deploying a Fresh Orchard 1.7 Source Code Drop to a Windows Azure Website Gives a Server Error for a Moment

Topics: Installing Orchard
Aug 27, 2013 at 2:13 AM
Hi there,

We receive a server error. Steps to resolve.
  1. Wait five minutes.
  2. Refresh the browser page.
  3. It just works now.
Here, though, are the steps to reproduce the error.
  1. Go to https://orchard.codeplex.com/SourceControl/list/changesets
  2. Click on commit 5e0c26f73cf5 (it's the most recent as of 26 Aug 2013)
  3. After it opens click "Download"
  4. Extract the zip to a local directory (hereafter known as theDir)
  5. Open a developer command prompt at theDir
  6. Run build Precompiled
  7. Wait
  8. Meanwhile, go to manage.windowsazure.com
  9. New > Website > Quick Create
    url: orchardRocks
    location: West US
    Create Website
  10. Wait
  11. Meanwhile, the build should have completed successfully (yah!), so...
  12. Open FileZilla.
  13. Quick Connect to the newly created Azure website.
  14. Initiate the upload of the entire contents of theDir/build/Precomplied to /site/wwwroot
  15. Wait
  16. Meanwhile, edit your discussion thread for clarity :-)
  17. Once done, go to orchardRocks.azurewebsites.net
  18. Complete the Get Started
    Orchard Rocks
    admin
    23jkbfso83234kjnasdkfj@$@#$@GSR
    23jkbfso83234kjnasdkfj@$@#$@GSR
    Use built-in data storage (...)
    Blog
    Finish Setup
  19. Wait for the recipe to cook (about 5 minutes)
  20. Observe the error message.
  21. Check the /site/wwwroot/App_Data/Logs
  22. View the following error message.
2013-08-27 00:34:49,367 [9] NHibernate.AdoNet.AbstractBatcher - Could not execute command: SELECT * FROM Settings_ShellDescriptorRecord
System.Data.SqlServerCe.SqlCeException (0x80004005): The specified table does not exist. [ Settings_ShellDescriptorRecord ]
at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan()
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery()
at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd)

There's more but the discussion does not allow that long a post.
Aug 27, 2013 at 2:14 AM

Further Details

2013-08-27 00:34:49,367 [9] NHibernate.AdoNet.AbstractBatcher - Could not execute command: SELECT * FROM Settings_ShellDescriptorRecord
System.Data.SqlServerCe.SqlCeException (0x80004005): The specified table does not exist. [ Settings_ShellDescriptorRecord ]
at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan()
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery()
at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd)
2013-08-27 00:34:49,399 [9] NHibernate.Util.ADOExceptionReporter - The specified table does not exist. [ Settings_ShellDescriptorRecord ]
2013-08-27 00:36:43,254 [9] NHibernate.Transaction.AdoTransaction - Begin transaction failed
System.Threading.ThreadAbortException: Thread was being aborted.
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-08-27 00:36:43,270 [9] Orchard.Data.Migration.DataMigrationManager - Error while running migration version 4 for Common
NHibernate.TransactionException: Begin failed with SQL exception ---> System.Threading.ThreadAbortException: Thread was being aborted.
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 c:\Users\Shaun\Documents\GitHub\BigFont\BigFont.Orchard\src\Orchard\Data\SessionLocator.cs:line 67
at Orchard.Data.SessionLocator.RequireNew() in c:\Users\Shaun\Documents\GitHub\BigFont\BigFont.Orchard\src\Orchard\Data\SessionLocator.cs:line 49
at Orchard.Data.Migration.DataMigrationManager.Update(String feature) in c:\Users\Shaun\Documents\GitHub\BigFont\BigFont.Orchard\src\Orchard\Data\Migration\DataMigrationManager.cs:line 94
2013-08-27 00:36:43,333 [9] Orchard.Data.SessionLocator - Error while disposing the transaction.
System.ObjectDisposedException: Cannot access a disposed object.
Object name: 'AdoTransaction'.
at NHibernate.Transaction.AdoTransaction.CheckNotDisposed()
at NHibernate.Transaction.AdoTransaction.Rollback()
at Orchard.Data.SessionLocator.Dispose() in c:\Users\Shaun\Documents\GitHub\BigFont\BigFont.Orchard\src\Orchard\Data\SessionLocator.cs:line 84
2013-08-27 00:36:47,174 [5] NHibernate.AdoNet.AbstractBatcher - Could not execute query: SELECT this_.Id as Id243_4_, this_.Number as Number243_4_, this_.Published as Published243_4_, this_.Latest as Latest243_4_, this_.Data as Data243_4_, this_.ContentItemRecord_id as ContentI6_243_4_, titlepartr3_.Id as Id283_0_, titlepartr3_.Title as Title283_0_, titlepartr3_.ContentItemRecord_id as ContentI3_283_0_, contentite1_.Id as Id242_1_, contentite1_.Data as Data242_1_, contentite1_.ContentType_id as ContentT3_242_1_, blogpartre2_.Id as Id261_2_, blogpartre2_.Description as Descript2_261_2_, blogpartre2_.PostCount as PostCount261_2_, contenttyp8_.Id as Id244_3_, contenttyp8_.Name as Name244_3_ FROM Orchard_Framework_ContentItemVersionRecord this_ inner join Title_TitlePartRecord titlepartr3_ on this_.Id=titlepartr3_.Id inner join Orchard_Framework_ContentItemRecord contentite1_ on this_.ContentItemRecord_id=contentite1_.Id inner join Orchard_Blogs_BlogPartRecord blogpartre2_ on contentite1_.Id=blogpartre2_.Id left outer join Orchard_Framework_ContentTypeRecord contenttyp8_ on contentite1_.ContentType_id=contenttyp8_.Id WHERE this_.Published = @p0 ORDER BY titlepartr3_.Title asc
System.Data.SqlServerCe.SqlCeException (0x80004005): The specified table does not exist. [ Orchard_Blogs_BlogPartRecord ]
at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan()
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
2013-08-27 00:36:47,174 [5] NHibernate.Util.ADOExceptionReporter - The specified table does not exist. [ Orchard_Blogs_BlogPartRecord ]
2013-08-27 00:36:47,174 [5] NHibernate.Util.ADOExceptionReporter - The specified table does not exist. [ Orchard_Blogs_BlogPartRecord ]
2013-08-27 00:36:47,174 [5] NHibernate.Util.ADOExceptionReporter - The specified table does not exist. [ Orchard_Blogs_BlogPartRecord ]
2013-08-27 00:36:47,174 [5] Orchard.Exceptions.DefaultExceptionPolicy - An unexpected exception was caught
NHibernate.Exceptions.GenericADOException: could not execute query
[ SELECT this_.Id as Id243_4_, this_.Number as Number243_4_, this_.Published as Published243_4_, this_.Latest as Latest243_4_, this_.Data as Data243_4_, this_.ContentItemRecord_id as ContentI6_243_4_, titlepartr3_.Id as Id283_0_, titlepartr3_.Title as Title283_0_, titlepartr3_.ContentItemRecord_id as ContentI3_283_0_, contentite1_.Id as Id242_1_, contentite1_.Data as Data242_1_, contentite1_.ContentType_id as ContentT3_242_1_, blogpartre2_.Id as Id261_2_, blogpartre2_.Description as Descript2_261_2_, blogpartre2_.PostCount as PostCount261_2_, contenttyp8_.Id as Id244_3_, contenttyp8_.Name as Name244_3_ FROM Orchard_Framework_ContentItemVersionRecord this_ inner join Title_TitlePartRecord titlepartr3_ on this_.Id=titlepartr3_.Id inner join Orchard_Framework_ContentItemRecord contentite1_ on this_.ContentItemRecord_id=contentite1_.Id inner join Orchard_Blogs_BlogPartRecord blogpartre2_ on contentite1_.Id=blogpartre2_.Id left outer join Orchard_Framework_ContentTypeRecord contenttyp8_ on contentite1_.ContentType_id=contenttyp8_.Id WHERE this_.Published = @p0 ORDER BY titlepartr3_.Title asc ]
Name:cp0 - Value:True
[SQL: SELECT this_.Id as Id243_4_, this_.Number as Number243_4_, this_.Published as Published243_4_, this_.Latest as Latest243_4_, this_.Data as Data243_4_, this_.ContentItemRecord_id as ContentI6_243_4_, titlepartr3_.Id as Id283_0_, titlepartr3_.Title as Title283_0_, titlepartr3_.ContentItemRecord_id as ContentI3_283_0_, contentite1_.Id as Id242_1_, contentite1_.Data as Data242_1_, contentite1_.ContentType_id as ContentT3_242_1_, blogpartre2_.Id as Id261_2_, blogpartre2_.Description as Descript2_261_2_, blogpartre2_.PostCount as PostCount261_2_, contenttyp8_.Id as Id244_3_, contenttyp8_.Name as Name244_3_ FROM Orchard_Framework_ContentItemVersionRecord this_ inner join Title_TitlePartRecord titlepartr3_ on this_.Id=titlepartr3_.Id inner join Orchard_Framework_ContentItemRecord contentite1_ on this_.ContentItemRecord_id=contentite1_.Id inner join Orchard_Blogs_BlogPartRecord blogpartre2_ on contentite1_.Id=blogpartre2_.Id left outer join Orchard_Framework_ContentTypeRecord contenttyp8_ on contentite1_.ContentType_id=contenttyp8_.Id WHERE this_.Published = @p0 ORDER BY titlepartr3_.Title asc] ---> System.Data.SqlServerCe.SqlCeException: The specified table does not exist. [ Orchard_Blogs_BlogPartRecord ]
at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan()
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session)
at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
--- End of inner exception stack trace ---
at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes)
at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results)
at NHibernate.Impl.CriteriaImpl.List(IList results)
Coordinator
Aug 27, 2013 at 3:02 AM
Great repro steps. Could you put them into a new issue?
Aug 27, 2013 at 5:32 PM
Thanks Oh Benevolent Dictator. They were fun to write.

Put them in a new issue. Done. https://orchard.codeplex.com/workitem/20046
Coordinator
Aug 27, 2013 at 9:40 PM
Thanks!