Ive made several installations off both umbraco 4.6, 4.7 and uCommerce 2.0, but I always end up with a empty Product Catalog.
My webconfig.xml contains the <commerce> section, the umbraco/config/create/UI.xml contains lots of ucommerce nodes and my database contains several inputs of ucommerce in various tables.
When I click on the Product Category and choose "create" I get a popup where I fill in a name and a create button, after a while I get this exception:
Server Error in '/' Application.
A network-related or instance-specific error
occurred while establishing a connection to SQL Server. The server was
not found or was not accessible. Verify that the instance name is
correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating
Server/Instance Specified)
Description: An unhandled exception occurred during
the execution of the current web request. Please review the stack trace
for more information about the error and where it originated in the
code.
Exception Details: System.Data.SqlClient.SqlException:
A network-related or instance-specific error occurred while
establishing a connection to SQL Server. The server was not found or was
not accessible. Verify that the instance name is correct and that SQL
Server is configured to allow remote connections. (provider: SQL Network
Interfaces, error: 26 - Error Locating Server/Instance Specified)
Source Error:
An unhandled exception was generated during the execution of the current
web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5050218
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity) +341
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject) +129
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout) +270
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +195
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +232
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +33
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +524
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +479
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +108
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +126
System.Data.SqlClient.SqlConnection.Open() +125
NHibernate.Connection.DriverConnectionProvider.GetConnection() +104
NHibernate.Tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.Prepare() +15
NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.GetReservedWords(Dialect dialect, IConnectionHelper connectionHelper) +89
NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.Update(ISessionFactory sessionFactory) +80
NHibernate.Impl.SessionFactoryImpl..ctor(Configuration cfg, IMapping mapping, Settings settings, EventListeners listeners) +602
NHibernate.Cfg.Configuration.BuildSessionFactory() +104
FluentNHibernate.Cfg.FluentConfiguration.BuildSessionFactory() +49
[FluentConfigurationException: An invalid or incomplete configuration was used while creating a SessionFactory. Check PotentialReasons collection, and InnerException for more detail.
]
FluentNHibernate.Cfg.FluentConfiguration.BuildSessionFactory() +69
UCommerce.EntitiesV2.SessionProvider.CreateSessionFactory(Boolean enableCache, String cacheProvider) +501
UCommerce.EntitiesV2.SessionProvider.GetSession() +131
UCommerce.EntitiesV2.SoftDeletableRepository`1..ctor(ISessionProvider sessionProvider) +217
[TargetInvocationException: Exception has been thrown by the target of an invocation.]
System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner) +0
System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner) +72
System.Reflection.RuntimeConstructorInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +318
Castle.MicroKernel.ComponentActivator.DefaultComponentActivator.FastCreateInstance(Type implType, Object[] arguments, Type[] signature) +81
Castle.MicroKernel.ComponentActivator.DefaultComponentActivator.CreateInstance(CreationContext context, Object[] arguments, Type[] signature) +174
[ComponentActivatorException: ComponentActivator: could not instantiate UCommerce.EntitiesV2.SoftDeletableRepository`1[[UCommerce.EntitiesV2.ProductCatalogGroup, UCommerce, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]]
Castle.MicroKernel.ComponentActivator.DefaultComponentActivator.CreateInstance(CreationContext context, Object[] arguments, Type[] signature) +346
Castle.MicroKernel.ComponentActivator.DefaultComponentActivator.Instantiate(CreationContext context) +59
Castle.MicroKernel.ComponentActivator.DefaultComponentActivator.InternalCreate(CreationContext context) +20
Castle.MicroKernel.ComponentActivator.AbstractComponentActivator.Create(CreationContext context) +16
Castle.MicroKernel.Lifestyle.PerWebRequestLifestyleManager.Resolve(CreationContext context) +129
Castle.MicroKernel.Handlers.DefaultHandler.ResolveCore(CreationContext context, Boolean requiresDecommission, Boolean instanceRequired) +98
Castle.MicroKernel.Handlers.AbstractHandler.Resolve(CreationContext context, Boolean instanceRequired) +17
Castle.MicroKernel.Handlers.AbstractHandler.Resolve(CreationContext context) +12
Castle.MicroKernel.Handlers.DefaultGenericHandler.ResolveCore(CreationContext context, Boolean requiresDecommission, Boolean instanceRequired) +135
Castle.MicroKernel.Handlers.AbstractHandler.Resolve(CreationContext context, Boolean instanceRequired) +17
Castle.MicroKernel.Handlers.AbstractHandler.Resolve(CreationContext context) +12
Castle.MicroKernel.DefaultKernel.ResolveComponent(IHandler handler, Type service, IDictionary additionalArguments) +88
Castle.MicroKernel.DefaultKernel.Resolve(Type service) +53
Castle.Windsor.WindsorContainer.Resolve(Type service) +13
Castle.Windsor.WindsorContainer.Resolve() +62
UCommerce.Infrastructure.ObjectFactory.Resolve() +57
UCommerce.EntitiesV2.ProductCatalogGroup.GetRepo() +45
UCommerceWeb.Umbraco.UCommerce.Catalog.CreateProductCatalogGroup.UniqueNameValidator_ServerValidate(Object source, ServerValidateEventArgs args) +494
System.Web.UI.WebControls.CustomValidator.OnServerValidate(String value) +146
System.Web.UI.WebControls.CustomValidator.EvaluateIsValid() +100
System.Web.UI.WebControls.BaseValidator.Validate() +89
System.Web.UI.Page.Validate() +160
System.Web.UI.Page.Validate(String validationGroup) +109
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +86
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
My guess is that this exception is related to the problem that there is nothing in the Product Category to begin with.
Does someone know what the problem is? Or how I should proceed to solve this problem? I really need help with this one.
P.s. After the installation I need to go to the user section and add the ucommerce to the admin list, by checking the checkbox, which is not mentioned in the installation is done, all you need to do is press F5.. Please add this to your installation is complete instructions.
From the error it looks like uCommerce can't access your database server. Please check the connection string for uCommerce in web.config in the connectionStrings section. Also uCommerce only work with Microsoft SQL Server (or SQL Server Express). MySQL and SQL CE is not supported.
When we originally created uCommerce SQL CE didn't exist as a product yet. We haven't received enough requests to warrant adding it yet, but with SQL CE being the default choice for many new Umbraco installs it probably is something we'll look into adding in the future.
Product Catalog is empty
Hello,
Ive made several installations off both umbraco 4.6, 4.7 and uCommerce 2.0, but I always end up with a empty Product Catalog.
My webconfig.xml contains the <commerce> section, the umbraco/config/create/UI.xml contains lots of ucommerce nodes and my database contains several inputs of ucommerce in various tables.
When I click on the Product Category and choose "create" I get a popup where I fill in a name and a create button, after a while I get this exception:
My guess is that this exception is related to the problem that there is nothing in the Product Category to begin with.
Does someone know what the problem is? Or how I should proceed to solve this problem? I really need help with this one.
P.s.
After the installation I need to go to the user section and add the ucommerce to the admin list, by checking the checkbox, which is not mentioned in the installation is done, all you need to do is press F5..
Please add this to your installation is complete instructions.
Hi Daniel,
From the error it looks like uCommerce can't access your database server. Please check the connection string for uCommerce in web.config in the connectionStrings section. Also uCommerce only work with Microsoft SQL Server (or SQL Server Express). MySQL and SQL CE is not supported.
Hope this helps.
Was just gonna mention that Ive installed it with a SQL CE database..
I cannot get it to install when I choose SQL Server Express, I suppose Ill have to go back and have another look at that..
Thank you for the information.
Also, why doesnt it support SQL CE when it is installing information into that database?
When we originally created uCommerce SQL CE didn't exist as a product yet. We haven't received enough requests to warrant adding it yet, but with SQL CE being the default choice for many new Umbraco installs it probably is something we'll look into adding in the future.
is working on a reply...