Try our conversational search powered by Generative AI!

AI OnAI Off

[Commerce Azure]Get exception when executing update-epidatabase

Found in

EPiServer.Commerce.Azure.8.6.0

Created

Dec 19, 2014

Updated

Mar 06, 2015

Area

Falcon/Commerce

State

Closed, Fixed and Tested

Steps to reproduce

Steps to reproduce

  1. Install EPiServer Visual Studio Extension
  2. Using that extension to create EPiServer CMS project
  3. Install EPiServer.Commerce.Sample nuget package to that project
  4. Import Catalog and Site contents
  5. Install EPiServer.Commerce.Azure nuget package
  6. Run Update-Epidatabase

    Expected: No error message during this executing

    Actual: Got following error in PM Console

Processing C:\EPiServer\EPiServerSite1TestNuget\packages\EPiServer.Commerce.Azure.8.6.0\tools\epiupdates_CMS\sql\1.0.0.sql

epideploy.exe :

At C:\EPiServer\EPiServerSite1TestNuget\packages\EPiServer.Framework.7.19.0\tools\upgrade.psm1:188 char:3

+ &$epiDeployPath -a $action -s $sitePath -p $updatePath\* -c $settings["conne ...

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ CategoryInfo : NotSpecified: (:String) [], RemoteException

+ FullyQualifiedErrorId : NativeCommandError

EPiDeploy was stopped due to an exception, more details:

　

System.Data.SqlClient.SqlException (0x80131904): There is no user table matching the input name 'aspnet_Membership' in the current database or you do not have permission to access the table.

There is no user table matching the input name 'aspnet_Profile'

in the current database or you do not have permission to access the table.

There is no user table matching the input name 'aspnet_PersonalizationAllUsers' in the current database or you do not have permission to access the table.

There is no user table matching the input name 'aspnet_PersonalizationPerUser' in the current database or you do not have permission to access the table.

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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at EPiDeploy.Sql.ScriptRunner.<>c__DisplayClass5.<ExecuteScript>b__3()

at EPiDeploy.Sql.DatabaseHandler.Execute[T](Func`1 f, Boolean commit)

at EPiDeploy.Sql.ScriptRunner.ExecuteScript(StreamReader stream)

at EPiDeploy.Sql.ScriptRunner.ExecuteScripts(IEnumerable`1 files, Boolean requiresValidation)

at EPiDeploy.Sql.ScriptRunner.<>c__DisplayClass1.<Execute>b__0()

at EPiDeploy.Sql.DatabaseHandler.Execute[T](Func`1 f, Boolean commit)

at EPiDeploy.Common.Executor.Execute(ILocation location)

at EPiDeploy.Common.Executor.Execute(ILocation location)

at EPiDeploy.Common.Executor.Execute(ILocation location)

at EPiDeploy.Common.Executor.Execute(ILocation location)

at EPiDeploy.Common.Executor.Execute(ILocation location)

at EPiDeploy.Common.Executor.Execute(ILocation location)

at EPiDeploy.Common.Executor.Execute(ILocation location)

at EPiDeploy.Common.Executor.Execute(ILocation location)

at EPiDeploy.Common.Executor.Execute(ILocation location)

at EPiDeploy.Deploy.Execute(Options options, ILocation startPosition)

at EPiDeploy.Deploy.Run(Options options)

at EPiDeploy.Program.Main(String[] args)

ClientConnectionId:0784e678-2e20-42e1-aa8f-d6dbfcffd80d

Error Number:15388,State:1,Class:11