Skip to content

Instantly share code, notes, and snippets.

Created December 27, 2013 20:18
Show Gist options
  • Save anonymous/8152071 to your computer and use it in GitHub Desktop.
Save anonymous/8152071 to your computer and use it in GitHub Desktop.
uCommerce 5.1 - database tables not being installed
2013-12-27 21:13:28,311 [29] INFO NHibernate.Driver.BasicResultSetsCommand - select role0_.RoleId as RoleId76_0_, role1_.RoleId as RoleId76_1_, role0_.Name as Name76_0_, role0_.ParentRoleId as ParentRo4_76_0_, role0_.ProductCatalogGroupId as ProductC5_76_0_, role0_.CultureCode as CultureC6_76_0_, role0_.PriceGroupId as PriceGro7_76_0_, role0_.ProductCatalogId as ProductC8_76_0_, role0_.RoleType as RoleType76_0_, role1_.Name as Name76_1_, role1_.ParentRoleId as ParentRo4_76_1_, role1_.ProductCatalogGroupId as ProductC5_76_1_, role1_.CultureCode as CultureC6_76_1_, role1_.PriceGroupId as PriceGro7_76_1_, role1_.ProductCatalogId as ProductC8_76_1_, role1_.RoleType as RoleType76_1_ from uCommerce_Role role0_ left outer join uCommerce_Role role1_ on role0_.ParentRoleId=role1_.RoleId;
select role0_.RoleId as RoleId76_0_, user2_.UserId as UserId94_1_, role0_.Name as Name76_0_, role0_.ParentRoleId as ParentRo4_76_0_, role0_.ProductCatalogGroupId as ProductC5_76_0_, role0_.CultureCode as CultureC6_76_0_, role0_.PriceGroupId as PriceGro7_76_0_, role0_.ProductCatalogId as ProductC8_76_0_, role0_.RoleType as RoleType76_0_, user2_.ExternalId as ExternalId94_1_, users1_.RoleId as RoleId0__, users1_.UserId as UserId0__ from uCommerce_Role role0_ left outer join uCommerce_Permission users1_ on role0_.RoleId=users1_.RoleId left outer join uCommerce_User user2_ on users1_.UserId=user2_.UserId;
2013-12-27 21:13:28,312 [29] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: select role0_.RoleId as RoleId76_0_, role1_.RoleId as RoleId76_1_, role0_.Name as Name76_0_, role0_.ParentRoleId as ParentRo4_76_0_, role0_.ProductCatalogGroupId as ProductC5_76_0_, role0_.CultureCode as CultureC6_76_0_, role0_.PriceGroupId as PriceGro7_76_0_, role0_.ProductCatalogId as ProductC8_76_0_, role0_.RoleType as RoleType76_0_, role1_.Name as Name76_1_, role1_.ParentRoleId as ParentRo4_76_1_, role1_.ProductCatalogGroupId as ProductC5_76_1_, role1_.CultureCode as CultureC6_76_1_, role1_.PriceGroupId as PriceGro7_76_1_, role1_.ProductCatalogId as ProductC8_76_1_, role1_.RoleType as RoleType76_1_ from uCommerce_Role role0_ left outer join uCommerce_Role role1_ on role0_.ParentRoleId=role1_.RoleId;
select role0_.RoleId as RoleId76_0_, user2_.UserId as UserId94_1_, role0_.Name as Name76_0_, role0_.ParentRoleId as ParentRo4_76_0_, role0_.ProductCatalogGroupId as ProductC5_76_0_, role0_.CultureCode as CultureC6_76_0_, role0_.PriceGroupId as PriceGro7_76_0_, role0_.ProductCatalogId as ProductC8_76_0_, role0_.RoleType as RoleType76_0_, user2_.ExternalId as ExternalId94_1_, users1_.RoleId as RoleId0__, users1_.UserId as UserId0__ from uCommerce_Role role0_ left outer join uCommerce_Permission users1_ on role0_.RoleId=users1_.RoleId left outer join uCommerce_User user2_ on users1_.UserId=user2_.UserId;
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'uCommerce_Role'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
at NHibernate.Driver.BatcherDataReaderWrapper..ctor(IBatcher batcher, IDbCommand command)
at NHibernate.Driver.BasicResultSetsCommand.GetReader(Nullable`1 commandTimeout)
at NHibernate.Impl.MultiQueryImpl.DoList()
ClientConnectionId:300c3baf-9af2-4f34-9d27-78e75d85985f
2013-12-27 21:13:28,312 [29] ERROR NHibernate.Impl.MultiQueryImpl - Failed to execute multi query: [select role0_.RoleId as RoleId76_0_, role1_.RoleId as RoleId76_1_, role0_.Name as Name76_0_, role0_.ParentRoleId as ParentRo4_76_0_, role0_.ProductCatalogGroupId as ProductC5_76_0_, role0_.CultureCode as CultureC6_76_0_, role0_.PriceGroupId as PriceGro7_76_0_, role0_.ProductCatalogId as ProductC8_76_0_, role0_.RoleType as RoleType76_0_, role1_.Name as Name76_1_, role1_.ParentRoleId as ParentRo4_76_1_, role1_.ProductCatalogGroupId as ProductC5_76_1_, role1_.CultureCode as CultureC6_76_1_, role1_.PriceGroupId as PriceGro7_76_1_, role1_.ProductCatalogId as ProductC8_76_1_, role1_.RoleType as RoleType76_1_ from uCommerce_Role role0_ left outer join uCommerce_Role role1_ on role0_.ParentRoleId=role1_.RoleId;
select role0_.RoleId as RoleId76_0_, user2_.UserId as UserId94_1_, role0_.Name as Name76_0_, role0_.ParentRoleId as ParentRo4_76_0_, role0_.ProductCatalogGroupId as ProductC5_76_0_, role0_.CultureCode as CultureC6_76_0_, role0_.PriceGroupId as PriceGro7_76_0_, role0_.ProductCatalogId as ProductC8_76_0_, role0_.RoleType as RoleType76_0_, user2_.ExternalId as ExternalId94_1_, users1_.RoleId as RoleId0__, users1_.UserId as UserId0__ from uCommerce_Role role0_ left outer join uCommerce_Permission users1_ on role0_.RoleId=users1_.RoleId left outer join uCommerce_User user2_ on users1_.UserId=user2_.UserId;
]
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'uCommerce_Role'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
at NHibernate.Driver.BatcherDataReaderWrapper..ctor(IBatcher batcher, IDbCommand command)
at NHibernate.Driver.BasicResultSetsCommand.GetReader(Nullable`1 commandTimeout)
at NHibernate.Impl.MultiQueryImpl.DoList()
ClientConnectionId:300c3baf-9af2-4f34-9d27-78e75d85985f
2013-12-27 21:13:28,312 [29] WARN NHibernate.Util.ADOExceptionReporter - System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'uCommerce_Role'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
at NHibernate.Driver.BatcherDataReaderWrapper..ctor(IBatcher batcher, IDbCommand command)
at NHibernate.Driver.BasicResultSetsCommand.GetReader(Nullable`1 commandTimeout)
at NHibernate.Impl.MultiQueryImpl.DoList()
ClientConnectionId:300c3baf-9af2-4f34-9d27-78e75d85985f
2013-12-27 21:13:28,312 [29] ERROR NHibernate.Util.ADOExceptionReporter - Invalid object name 'uCommerce_Role'.
2013-12-27 21:13:28,313 [29] ERROR Umbraco.Core.UmbracoApplicationBase - [Thread 32] An unhandled exception occurred
Castle.MicroKernel.ComponentActivator.ComponentActivatorException: ComponentActivator: could not instantiate UCommerce.Security.RoleService ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> NHibernate.Exceptions.GenericADOException: Failed to execute multi query[SQL: select role0_.RoleId as RoleId76_0_, role1_.RoleId as RoleId76_1_, role0_.Name as Name76_0_, role0_.ParentRoleId as ParentRo4_76_0_, role0_.ProductCatalogGroupId as ProductC5_76_0_, role0_.CultureCode as CultureC6_76_0_, role0_.PriceGroupId as PriceGro7_76_0_, role0_.ProductCatalogId as ProductC8_76_0_, role0_.RoleType as RoleType76_0_, role1_.Name as Name76_1_, role1_.ParentRoleId as ParentRo4_76_1_, role1_.ProductCatalogGroupId as ProductC5_76_1_, role1_.CultureCode as CultureC6_76_1_, role1_.PriceGroupId as PriceGro7_76_1_, role1_.ProductCatalogId as ProductC8_76_1_, role1_.RoleType as RoleType76_1_ from uCommerce_Role role0_ left outer join uCommerce_Role role1_ on role0_.ParentRoleId=role1_.RoleId;
select role0_.RoleId as RoleId76_0_, user2_.UserId as UserId94_1_, role0_.Name as Name76_0_, role0_.ParentRoleId as ParentRo4_76_0_, role0_.ProductCatalogGroupId as ProductC5_76_0_, role0_.CultureCode as CultureC6_76_0_, role0_.PriceGroupId as PriceGro7_76_0_, role0_.ProductCatalogId as ProductC8_76_0_, role0_.RoleType as RoleType76_0_, user2_.ExternalId as ExternalId94_1_, users1_.RoleId as RoleId0__, users1_.UserId as UserId0__ from uCommerce_Role role0_ left outer join uCommerce_Permission users1_ on role0_.RoleId=users1_.RoleId left outer join uCommerce_User user2_ on users1_.UserId=user2_.UserId;
] ---> System.Data.SqlClient.SqlException: Invalid object name 'uCommerce_Role'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
at NHibernate.Driver.BatcherDataReaderWrapper..ctor(IBatcher batcher, IDbCommand command)
at NHibernate.Driver.BasicResultSetsCommand.GetReader(Nullable`1 commandTimeout)
at NHibernate.Impl.MultiQueryImpl.DoList()
--- End of inner exception stack trace ---
at NHibernate.Impl.MultiQueryImpl.DoList()
at NHibernate.Impl.MultiQueryImpl.ListUsingQueryCache()
at NHibernate.Impl.MultiQueryImpl.List()
at NHibernate.Impl.FutureQueryBatch.GetResultsFrom(IMultiQuery multiApproach)
at NHibernate.Impl.FutureBatch`2.GetResults()
at NHibernate.Impl.FutureBatch`2.get_Results()
at NHibernate.Impl.FutureBatch`2.GetCurrentResult[TResult](Int32 currentIndex)
at NHibernate.Impl.FutureBatch`2.<>c__DisplayClass4`1.<GetEnumerator>b__3()
at NHibernate.Impl.DelayedEnumerator`1.<get_Enumerable>d__0.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at UCommerce.EntitiesV2.Queries.Security.AllRolesQuery.Execute(ISession session)
at UCommerce.Security.RoleService..ctor(IRepository`1 roleRepository, IRepository`1 priceGroupRepository, IRepository`1 productCatalogGroupRepository, IUserService userService, ILanguageService languageService)
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeConstructorInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Castle.MicroKernel.ComponentActivator.DefaultComponentActivator.FastCreateInstance(Type implType, Object[] arguments, ConstructorCandidate constructor)
at Castle.MicroKernel.ComponentActivator.DefaultComponentActivator.CreateInstanceCore(ConstructorCandidate constructor, Object[] arguments, Type implType)
--- End of inner exception stack trace ---
at Castle.MicroKernel.ComponentActivator.DefaultComponentActivator.CreateInstanceCore(ConstructorCandidate constructor, Object[] arguments, Type implType)
at Castle.MicroKernel.ComponentActivator.DefaultComponentActivator.CreateInstance(CreationContext context, ConstructorCandidate constructor, Object[] arguments)
at Castle.MicroKernel.ComponentActivator.DefaultComponentActivator.InternalCreate(CreationContext context)
at Castle.MicroKernel.ComponentActivator.AbstractComponentActivator.Create(CreationContext context, Burden burden)
at Castle.MicroKernel.Lifestyle.AbstractLifestyleManager.CreateInstance(CreationContext context, Boolean trackedExternally)
at Castle.MicroKernel.Lifestyle.ScopedLifestyleManager.<>c__DisplayClass1.<Resolve>b__0(Action`1 afterCreated)
at Castle.MicroKernel.Lifestyle.Scoped.DefaultLifetimeScope.GetCachedInstance(ComponentModel model, ScopedInstanceActivationCallback createInstance)
at Castle.MicroKernel.Lifestyle.ScopedLifestyleManager.Resolve(CreationContext context, IReleasePolicy releasePolicy)
at Castle.MicroKernel.Handlers.DefaultHandler.ResolveCore(CreationContext context, Boolean requiresDecommission, Boolean instanceRequired, Burden& burden)
at Castle.MicroKernel.Handlers.DefaultHandler.Resolve(CreationContext context, Boolean instanceRequired)
at Castle.MicroKernel.Resolvers.DefaultDependencyResolver.ResolveFromKernelByType(CreationContext context, ComponentModel model, DependencyModel dependency)
at Castle.MicroKernel.Resolvers.DefaultDependencyResolver.Resolve(CreationContext context, ISubDependencyResolver contextHandlerResolver, ComponentModel model, DependencyModel dependency)
at Castle.MicroKernel.ComponentActivator.DefaultComponentActivator.CreateConstructorArguments(ConstructorCandidate constructor, CreationContext context)
at Castle.MicroKernel.ComponentActivator.DefaultComponentActivator.Instantiate(CreationContext context)
at Castle.MicroKernel.ComponentActivator.DefaultComponentActivator.InternalCreate(CreationContext context)
at Castle.MicroKernel.ComponentActivator.AbstractComponentActivator.Create(CreationContext context, Burden burden)
at Castle.MicroKernel.Lifestyle.AbstractLifestyleManager.CreateInstance(CreationContext context, Boolean trackedExternally)
at Castle.MicroKernel.Lifestyle.ScopedLifestyleManager.<>c__DisplayClass1.<Resolve>b__0(Action`1 afterCreated)
at Castle.MicroKernel.Lifestyle.Scoped.DefaultLifetimeScope.GetCachedInstance(ComponentModel model, ScopedInstanceActivationCallback createInstance)
at Castle.MicroKernel.Lifestyle.ScopedLifestyleManager.Resolve(CreationContext context, IReleasePolicy releasePolicy)
at Castle.MicroKernel.Handlers.DefaultHandler.ResolveCore(CreationContext context, Boolean requiresDecommission, Boolean instanceRequired, Burden& burden)
at Castle.MicroKernel.Handlers.DefaultHandler.Resolve(CreationContext context, Boolean instanceRequired)
at Castle.MicroKernel.DefaultKernel.ResolveComponent(IHandler handler, Type service, IDictionary additionalArguments, IReleasePolicy policy)
at Castle.MicroKernel.DefaultKernel.Castle.MicroKernel.IKernelInternal.Resolve(Type service, IDictionary arguments, IReleasePolicy policy)
at Castle.Windsor.WindsorContainer.Resolve[T]()
at UCommerce.Umbraco.Menu.LoadCatalog.CreateRootNode(XmlTreeNode& rootNode)
at umbraco.presentation.webservices.TreeDataService.LoadAppTrees(TreeRequestParams treeParams)
at umbraco.presentation.webservices.TreeDataService.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment