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.

  • Morten Andreasen 2 posts 22 karma points
    Sep 24, 2014 @ 11:42
    Morten Andreasen
    0

    Unable to install Ucommerce from local package on Azure Websites/SQLAzure

    I am trying to install Ucommerce 6.1.0.14195 from local package onto umbraco 7.1.6 on Azure Websites/SQL Azure

    The installation process fails with an Unhandled Exception

    The umbracosite in question is just installed

    Im not sure whether this is a bug in the umbraco package system og the the Ucommerce package, error the the umbraco tracelog could indicate both.

    The following exceptions catches my eye in the UmbracoTraceLog:

    2014-09-24 08:47:58,516 [15] INFO  umbraco.BusinessLogic.Log - [Thread 5] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Error | User: 0 | NodeId: -1 | Comment: uCommerce.DbInstaller.GetSchemaVersion(). uCommerce_SystemVersion does not exist. This indicates an empty database.
    2014-09-24 08:47:58,516 [15] INFO  umbraco.BusinessLogic.Log - [Thread 19] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Error | User: 0 | NodeId: -1 | Comment: Invalid object name 'uCommerce_SystemVersion'.
    Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.SqlInternalConnection.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.ExecuteScalar()
       at UCommerce.Installer.DbInstaller.GetSchemaVersion()

     

    System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.IO.IOException: The process cannot access the file 'D:\home\site\wwwroot\App_Data\packages\installed\installedPackages.config' because it is being used by another process.
       at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
       at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
       at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
       at System.IO.StreamWriter.CreateFile(String path, Boolean append, Boolean checkHost)
       at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize, Boolean checkHost)
       at System.IO.StreamWriter..ctor(String path, Boolean append)
       at System.IO.File.AppendText(String path)
       at umbraco.cms.businesslogic.packager.Settings.HasFileAccess(Exception& exp)
       at umbraco.presentation.developer.packages.Installer.Page_Load(Object sender, EventArgs e)
       at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
       at System.Web.UI.Control.OnLoad(EventArgs e)
       at umbraco.BasePages.BasePage.OnLoad(EventArgs e)
       at System.Web.UI.Control.LoadRecursive()
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.HandleError(Exception e)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.ProcessRequest()
       at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
       at System.Web.UI.Page.ProcessRequest(HttpContext context)
       at ASP.umbraco_developer_packages_installer_aspx.ProcessRequest(HttpContext context)
       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

    System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.InvalidOperationException: This document already has an 'XmlDeclaration' node.
       at System.Xml.XmlDocument.IsValidChildType(XmlNodeType type)
       at System.Xml.XmlDocument.AppendChildForLoad(XmlNode newChild, XmlDocument doc)
       at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
       at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)
       at System.Xml.XmlDocument.Load(XmlReader reader)
       at System.Xml.XmlDocument.Load(String filename)
       at umbraco.cms.businesslogic.packager.data.Reload(String dataSource)
       at umbraco.cms.businesslogic.packager.data.GetAllPackages(String dataSource)
       at umbraco.cms.businesslogic.packager.InstalledPackage.GetAllInstalledPackages()
       at Umbraco.Web.UI.Umbraco.Developer.Packages.StarterKits.Page_Load(Object sender, EventArgs e)
       at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
       at System.Web.UI.Control.OnLoad(EventArgs e)
       at Umbraco.Web.UI.Pages.BasePage.OnLoad(EventArgs e)
       at System.Web.UI.Control.LoadRecursive()
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.HandleError(Exception e)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.ProcessRequest()
       at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
       at System.Web.UI.Page.ProcessRequest(HttpContext context)
       at ASP.umbraco_developer_packages_starterkits_aspx.ProcessRequest(HttpContext context)
       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

     

    2014-09-24 12:26:25,273 [25] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: select role0_.RoleId as RoleId78_0_, role1_.RoleId as RoleId78_1_, role0_.Name as Name78_0_, role0_.ParentRoleId as ParentRo4_78_0_, role0_.ProductCatalogGroupId as ProductC5_78_0_, role0_.CultureCode as CultureC6_78_0_, role0_.PriceGroupId as PriceGro7_78_0_, role0_.ProductCatalogId as ProductC8_78_0_, role0_.RoleType as RoleType78_0_, role1_.Name as Name78_1_, role1_.ParentRoleId as ParentRo4_78_1_, role1_.ProductCatalogGroupId as ProductC5_78_1_, role1_.CultureCode as CultureC6_78_1_, role1_.PriceGroupId as PriceGro7_78_1_, role1_.ProductCatalogId as ProductC8_78_1_, role1_.RoleType as RoleType78_1_ from uCommerce_Role role0_ left outer join uCommerce_Role role1_ on role0_.ParentRoleId=role1_.RoleId;
    select role0_.RoleId as RoleId78_0_, user2_.UserId as UserId98_1_, role0_.Name as Name78_0_, role0_.ParentRoleId as ParentRo4_78_0_, role0_.ProductCatalogGroupId as ProductC5_78_0_, role0_.CultureCode as CultureC6_78_0_, role0_.PriceGroupId as PriceGro7_78_0_, role0_.ProductCatalogId as ProductC8_78_0_, role0_.RoleType as RoleType78_0_, user2_.ExternalId as ExternalId98_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.SqlInternalConnection.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:3091a69d-6fa8-457f-be7a-9c1e882a3e23
    Error Number:208,State:1,Class:16
    2014-09-24 12:26:25,273 [25] ERROR NHibernate.Impl.MultiQueryImpl - Failed to execute multi query: [select role0_.RoleId as RoleId78_0_, role1_.RoleId as RoleId78_1_, role0_.Name as Name78_0_, role0_.ParentRoleId as ParentRo4_78_0_, role0_.ProductCatalogGroupId as ProductC5_78_0_, role0_.CultureCode as CultureC6_78_0_, role0_.PriceGroupId as PriceGro7_78_0_, role0_.ProductCatalogId as ProductC8_78_0_, role0_.RoleType as RoleType78_0_, role1_.Name as Name78_1_, role1_.ParentRoleId as ParentRo4_78_1_, role1_.ProductCatalogGroupId as ProductC5_78_1_, role1_.CultureCode as CultureC6_78_1_, role1_.PriceGroupId as PriceGro7_78_1_, role1_.ProductCatalogId as ProductC8_78_1_, role1_.RoleType as RoleType78_1_ from uCommerce_Role role0_ left outer join uCommerce_Role role1_ on role0_.ParentRoleId=role1_.RoleId;
    select role0_.RoleId as RoleId78_0_, user2_.UserId as UserId98_1_, role0_.Name as Name78_0_, role0_.ParentRoleId as ParentRo4_78_0_, role0_.ProductCatalogGroupId as ProductC5_78_0_, role0_.CultureCode as CultureC6_78_0_, role0_.PriceGroupId as PriceGro7_78_0_, role0_.ProductCatalogId as ProductC8_78_0_, role0_.RoleType as RoleType78_0_, user2_.ExternalId as ExternalId98_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.SqlInternalConnection.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:3091a69d-6fa8-457f-be7a-9c1e882a3e23
    Error Number:208,State:1,Class:16
    2014-09-24 12:26:25,273 [25] ERROR NHibernate.Util.ADOExceptionReporter - Invalid object name 'uCommerce_Role'.

     

     

  • Søren Spelling Lund 1797 posts 2786 karma points
    Sep 24, 2014 @ 14:53
    Søren Spelling Lund
    0

    I'm wondering about this specific error, "System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.IO.IOException: The process cannot access the file 'D:\home\site\wwwroot\App_Data\packages\installed\installedPackages.config' because it is being used by another process."

    It almost looks like some locks up during install. We don't actually touch this file, only Umbraco does, so it might be easier if you install locally and then move the deployed solution into the website and database.

  • Morten Andreasen 2 posts 22 karma points
    Sep 25, 2014 @ 08:59
    Morten Andreasen
    0

    Thank you Søren.

    Installing it locally and moving the website and database to azure afterwards did indeed work.

    But it seems that umbraco, and especially the package subsystem becomes quite buggy when running on Azure Websites.

    I havent tested with other packages that Ucommerce.

    Morten

Please Sign in or register to post replies

Write your reply to:

Draft