This is on an existing site. I'm logged in as the admin. I've attempted this both running the site locally (through VS), and through IIS (localhost). The only reason I say that is b/c I had trouble installing uCommerce on a blank Umbraco instance w/o running it locally (through VS).
Anyways, this is about the 10th time I've installed uCommerce on this existing site. Everything installs as it should (I mean no errors).
If I look in the database, there's only (9) tables created by the uCommerce install. That's right, 9. Not 80 or however many there's supposed to be
uCommerce_
Country
Currency
Customer
EmailProfile
OrderAddress
OrderNumberSerie
OrderStatus
ProductCatalogGroup
PurchaseOrder
I'm assuming the error that I get when I click on the uCommerce icon inside Umbraco CMS,
Failed to retrieve data for application tree uCommerce
It's obvious the install did not go correctly, but I cannot keep uninstalling the package and reinstalling again and again to no avail. And yes, I've tried to re-install on top of the already installed pkg as well.
Have you tried looking through the Umbraco log files and see if they show any errors?
Also i would like if you could look at the uCommerce_SystemVersion table and see what number is in the column "SchemaVersion".
You should have this table as it is the first table being created when installing uCommerce.
Under the website in a path similar to this Website\Umbraco\ucommerce\install, there should be some numbered sql scripts, You will have to manually execute all the scripts with a number greater than your current schema version on the database.
Then you will have to update the schema version in the uCommerce_SystemVersion to the number on the last script that you executed.
This should update the database to the right version.
I've had success installing uCommerce on an empty environment, but not an existing.
Another developer had installed "TeaCommerce" awhile ago, as in last year. I uninstalled the plugin prior to doing the multiple installs for uCommerce, but it never deletes the tables in the database, so I go in there manually and remove them. I didn't know if this could be related.
The table, uCommerce_SystemVersion did not get created when doing the install, only those (9) tables that are above in the OP.
I tried to execute the SQL scripts months ago in order from 001 - XXX, but I couldn't get passed 004 b/c of constraint issues w/ the DB tables.
I just attempted to reinstall the package again just now and received both those errors in the tracelog.
I see this error a lot
Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action1[System.Action])
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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.ExecuteScalar()
at UCommerce.Installer.DbInstaller.GetSchemaVersion()
2015-03-09 12:57:43,253 [134] INFO umbraco.BusinessLogic.Log - [Thread 131] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Error | User: 0 | NodeId: -1 | Comment: Error in uCommerce.DbInstaller.InstallDatabase() script:C:\Swarm\GitHubWorkspace\TruSpec\UmbracoSite\umbraco\ucommerce\install\uCommerceDB.001.sql, error: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'UmbracoMemberId'.
And this one
2015-03-09 12:58:47,403 [18] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: select user0.UserId as UserId100, user0.ExternalId as ExternalId100 from uCommerceUser user0 where user0.ExternalId=@p0
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'uCommerceUser'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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, TaskCompletionSource1 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:409f4ec3-2e60-431b-b38a-28587f64591d
2015-03-09 12:58:47,405 [18] ERROR NHibernate.Util.ADOExceptionReporter - Invalid object name 'uCommerceUser'.
2015-03-09 12:58:47,415 [18] ERROR NHibernate.Util.ADOExceptionReporter - Invalid object name 'uCommerceUser'.
2015-03-09 12:58:47,417 [18] ERROR NHibernate.Util.ADOExceptionReporter - Invalid object name 'uCommerce_User'.
I've also thought about it a little more, and this website that I'm trying to install uCommerce on is an existing website, with document types and all. One of the ALREADY created document types is called "Product", which I think uCommerce uses as well. Perhaps this can be causing the issue?
I'll have to go ahead and try again, it was forever ago that I gave up attempting to install uCommerce on the website. It did, however, install on a empty instance of Umbraco.
Give me a little to get back w/ you. Thanks for the assistance.
Jesper - you're the best! After removing all constraints and deleting the (9) tables, I re-ran through the 130 sql scripts and it's loading now. Appreciate it!
Failed to retrieve data for application tree uCommerce
This is on an existing site. I'm logged in as the admin. I've attempted this both running the site locally (through VS), and through IIS (localhost). The only reason I say that is b/c I had trouble installing uCommerce on a blank Umbraco instance w/o running it locally (through VS).
Anyways, this is about the 10th time I've installed uCommerce on this existing site. Everything installs as it should (I mean no errors).
If I look in the database, there's only (9) tables created by the uCommerce install. That's right, 9. Not 80 or however many there's supposed to be
uCommerce_
I'm assuming the error that I get when I click on the uCommerce icon inside Umbraco CMS,
Failed to retrieve data for application tree uCommerce
is b/c there's not the correct tables installed.
Here's what's in console -
GET http://WEBSITE/umbraco/backoffice/UmbracoTrees/ApplicationTree/GetApplicationTrees?application=uCommerce&tree=&isDialog=false 500 (Internal Server Error)
It's obvious the install did not go correctly, but I cannot keep uninstalling the package and reinstalling again and again to no avail. And yes, I've tried to re-install on top of the already installed pkg as well.
Any help is GREATLY appreciated!!!!
Here's the stacktrace from the 500 error in console
)]}', {"Message":"An error has occurred.","ExceptionMessage":"Invalid column name 'Guid'.","ExceptionType":"System.Data.SqlClient.SqlException","StackTrace":" at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action
1 wrapCloseInAction)\r\n at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()\r\n at System.Data.SqlClient.SqlDataReader.get_MetaData()\r\n at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)\r\n at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)\r\n at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)\r\n at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()\r\n at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)\r\n at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session)\r\n at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer)\r\n at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer)\r\n at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer)"}Hey Scott
Have you tried looking through the Umbraco log files and see if they show any errors?
Also i would like if you could look at the uCommerce_SystemVersion table and see what number is in the column "SchemaVersion". You should have this table as it is the first table being created when installing uCommerce.
Under the website in a path similar to this Website\Umbraco\ucommerce\install, there should be some numbered sql scripts, You will have to manually execute all the scripts with a number greater than your current schema version on the database.
Then you will have to update the schema version in the uCommerce_SystemVersion to the number on the last script that you executed.
This should update the database to the right version.
Kind regards
Thomas arvidsen
I've had success installing uCommerce on an empty environment, but not an existing.
Another developer had installed "TeaCommerce" awhile ago, as in last year. I uninstalled the plugin prior to doing the multiple installs for uCommerce, but it never deletes the tables in the database, so I go in there manually and remove them. I didn't know if this could be related.
The table, uCommerce_SystemVersion did not get created when doing the install, only those (9) tables that are above in the OP.
I tried to execute the SQL scripts months ago in order from 001 - XXX, but I couldn't get passed 004 b/c of constraint issues w/ the DB tables.
I just attempted to reinstall the package again just now and received both those errors in the tracelog.
I see this error a lot
Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action
1[System.Action]) at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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.ExecuteScalar() at UCommerce.Installer.DbInstaller.GetSchemaVersion() 2015-03-09 12:57:43,253 [134] INFO umbraco.BusinessLogic.Log - [Thread 131] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Error | User: 0 | NodeId: -1 | Comment: Error in uCommerce.DbInstaller.InstallDatabase() script:C:\Swarm\GitHubWorkspace\TruSpec\UmbracoSite\umbraco\ucommerce\install\uCommerceDB.001.sql, error: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'UmbracoMemberId'.And this one
2015-03-09 12:58:47,403 [18] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: select user0.UserId as UserId100, user0.ExternalId as ExternalId100 from uCommerceUser user0 where user0.ExternalId=@p0 System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'uCommerceUser'. 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, TaskCompletionSource1 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:409f4ec3-2e60-431b-b38a-28587f64591d 2015-03-09 12:58:47,405 [18] ERROR NHibernate.Util.ADOExceptionReporter - Invalid object name 'uCommerceUser'. 2015-03-09 12:58:47,415 [18] ERROR NHibernate.Util.ADOExceptionReporter - Invalid object name 'uCommerceUser'. 2015-03-09 12:58:47,417 [18] ERROR NHibernate.Util.ADOExceptionReporter - Invalid object name 'uCommerce_User'.Hello Rob,
There is something going very wrong for the database installation of uCommerce. :-S
The errors look like they are looking for a table called "uCommerceUser". It should be "uCommerce_User", with an underscore.
When the database is not installed correct, everything else is messed up.
Which database is this on?
Kind regards,
Jesper
This is on an Azure SQL 2012 DB.
I've also thought about it a little more, and this website that I'm trying to install uCommerce on is an existing website, with document types and all. One of the ALREADY created document types is called "Product", which I think uCommerce uses as well. Perhaps this can be causing the issue?
Hello Rob,
I see now that the missing underscores are simply an issue of displaying the exception.
Please try removing all the tables whose names start with "uCommerce_". Again! ;-)
Then try manually running the database scripts from number 001 onwards.
You mentioned that you could not get past number 4, because of a constraint. This is the key to the problem, I believe.
What is the constraint? Can it be removed?
Kind regards,
Jesper
I'll have to go ahead and try again, it was forever ago that I gave up attempting to install uCommerce on the website. It did, however, install on a empty instance of Umbraco.
Give me a little to get back w/ you. Thanks for the assistance.
Jesper - you're the best! After removing all constraints and deleting the (9) tables, I re-ran through the 130 sql scripts and it's loading now. Appreciate it!
is working on a reply...