Sign in Register
Go to solution
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.

  • Martin 181 posts 740 karma points
    Dec 12, 2014 @ 22:30
    Martin
    0

    BUG: SQL Table uCommerce_user is missing

    Hi uCommerce,

    A minor bug report from here. I have just installed a clean uCommerce and it seems that uCommerce_user table is not being created during installation.

    My setup is:

    • Umbraco 7.1.9 (Hosted in Azure VM (IIS ASP.NET 4.5) Database:RR-Umbraco)
    • uCommerce 6.5.3.14346 (Database: RR-UCommerce
    • Installation of uCommerce went fine. The logo showed up at the end and no errors occurerd (of what I could see)

    I get the following error message in Umbraco logs

    2014-12-12 21:12:30,262 [7] ERROR NHibernate.Util.ADOExceptionReporter - Invalid object name 'uCommerce_User'.

2014-12-12 21:12:34,148 [7] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: select user0_.UserId as UserId100_, user0_.ExternalId as ExternalId100_ from uCommerce_User user0_ where user0_.ExternalId=@p0

System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'uCommerce_User'.    
   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.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session)    
   at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer)
   at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer)
       at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer)

ClientConnectionId:6bd1b126-d1f1-406c-b67e-5bf27239823b

    I have verified that the table is missing through SQL Server management studio. enter image description here

    Notice: I'm have installed uCommerce into the seperate database by adding "UCommerce" to connectionstrings in web.config

    Best regards

    Martin

    Copy Link
  • Martin 181 posts 740 karma points
    Dec 13, 2014 @ 13:40
    Martin
    100

    Some further information. It seems that all marketing tables are missing as well. I will try to install a clean version on my local SQL server instead of SQL Azure.

    EDIT: Okay when I install in my local SQL server express it works like a charm (sigh). I will try to reinstall in Azure for xxx'th time to see if something "weird" should have been happening during install.

    I just noticed during my local install that if I install uCommerce into a seperate database and the sql user doesn't have access to that database; installation just continue like nothing went wrong. Perhaps there should be looked into some validation before actually trying to install the database.

    EDIT2: Okay I don't have any count on which time it got installed now. But it seems that all tables are created correctly now. I'm still puzzled how it can be that not all tables are installed in first go even if uCommerce logo shows up at the end. I have a hunch that the connection to Azure SQL server is interrupted and then uCommerce just continues the installation (which would be a bit odd).

    Never the less the solution for me was when the installation completed first time I just installed the package once more and the remaining tables was created. Still not sure if this somehow can be handled by the installer.

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft