Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


These support forums are now closed for new topics and comments.
Please head on over to http://eureka.ucommerce.net/ for support.

  • Daniel 4 posts 24 karma points
    Aug 10, 2011 @ 15:05
    Daniel
    0

    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:

     

    
                

    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.

  • Søren Spelling Lund 1797 posts 2786 karma points
    Aug 10, 2011 @ 15:10
    Søren Spelling Lund
    0

    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.

  • Daniel 4 posts 24 karma points
    Aug 10, 2011 @ 15:15
    Daniel
    0

    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?

  • Søren Spelling Lund 1797 posts 2786 karma points
    Aug 15, 2011 @ 15:43
    Søren Spelling Lund
    0

    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.

Please Sign in or register to post replies

Write your reply to:

Draft