AI OnAI Off

updateDatabaseSchema="true" with commerce

Scott Reed
Scott Reed
Vote:
 

Hi again,

I have a site on the DXC which I've done some package updates for. We have the  flag in the CMS project set which I thought would auto apply the schema updates but isn't.

Does this need adding to the commerce manager web.config as well? I've always applied the updates locally with the update-epidatabase on the CMS project and it's been fine?

#182358
Sep 15, 2017 16:31
Quan Mai
Quan Mai
Vote:
 

No, it should be done in the front-end site (the "CMS site" as you call) only. It would be very strange if you enabled that flag, have your CMS database updated, but not your Commerce database.

#182360
Sep 15, 2017 16:51
Scott Reed
Scott Reed
Vote:
 

Yes that's what I thought, It's definately an upgrade schema issue as it's one I saw locally before applying update-epidatabase. For now I've asked the DXC service portal to update from a bacpac but it's nothing something I'll be able to do once content changes on the different envionments are made :-(

#182361
Sep 15, 2017 16:54
Quan Mai
Quan Mai
Vote:
 

On DXC site shouldn't it be <add key="episerver:UpdateDatabaseSchema" value="true" /> in appSettings? It's actually the same as <episerver.framework updateDatabaseSchema="true"> but it's more manageable for DXC ...

#182363
Sep 15, 2017 17:01
Scott Reed
Scott Reed
Vote:
 

The documentation (https://world.episerver.com/releases/episerver---update-83/) says that's for overriding it specific to envionment which I have no need of, I've always made use of automatic schema updates in builds without commerce fine, I just need the commerce database to update properly as well.

#182365
Sep 15, 2017 17:11
Bob Maes
Bob Maes
Vote:
 

Hello,

I have the same issue for the moment, by upgrading the following (and related) packages to the latest.

<package id="EPiServer.CMS.Core" version="10.10.1" targetFramework="net461" />
<package id="EPiServer.Commerce.Core" version="10.8.0" targetFramework="net461" />

By running the upgrade scripts manually, the problem is resolved. But this is not really an option, because my deployment setup is foreseen for this.

Stacktrace:

Exception information: 
    Exception type: TargetInvocationException 
    Exception message: Exception has been thrown by the target of an invocation.
   at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
   at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
   at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
   at System.Activator.CreateInstance(Type type, Boolean nonPublic)
   at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, StackCrawlMark& stackMark)
   at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
   at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture)
   at System.Web.HttpRuntime.CreateNonPublicInstance(Type type, Object[] args)
   at System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context)
   at System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext)

Exception in [ecf_PaymentMethod_Language]: 
   at Mediachase.Data.Provider.SqlDataProvider.LoadDataSet(DataCommand command)
   at Mediachase.Data.Provider.DataService.LoadDataSet(DataCommand command)
   at EPiServer.Commerce.Initialization.InitializationModule.GetPaymentMethods()
   at EPiServer.Commerce.Initialization.InitializationModule.VerifyPaymentProviders()
   at EPiServer.Commerce.Initialization.InitializationModule.InitializeCartMode(ServiceConfigurationContext context)
   at EPiServer.Commerce.Initialization.InitializationModule.ConfigureContainer(ServiceConfigurationContext context)
   at EPiServer.Framework.Initialization.Internal.ModuleNode.<>c__DisplayClass4_0.<ConfigureContainer>b__0()
   at EPiServer.Framework.Initialization.Internal.ModuleNode.Execute(Action a, String key)
   at EPiServer.Framework.Initialization.Internal.ModuleNode.ConfigureContainer(ServiceConfigurationContext context)
   at EPiServer.Framework.Initialization.InitializationEngine.ConfigureCurrentModules(Boolean final)
   at EPiServer.Framework.Initialization.InitializationEngine.ExecuteTransition(Boolean continueTransitions)
   at EPiServer.Framework.Initialization.InitializationEngine.Initialize()
   at EPiServer.Framework.Initialization.InitializationModule.<>c.<FrameworkInitialization>b__7_0(InitializationEngine e)
   at EPiServer.Framework.Initialization.InitializationModule.EngineExecute(HostType hostType, Action`1 engineAction)
   at EPiServer.Framework.Initialization.InitializationModule.FrameworkInitialization(HostType hostType)
   at EPiServer.Global..ctor()
   at Neuhaus.Ecom.Web.EPiServerApplication..ctor()
   at ASP.global_asax..ctor()

Procedure or function 'ecf_PaymentMethod_Language' expects parameter '@ApplicationId', which was not supplied.
   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, Boolean isInternal, Boolean forDescribeParameterEncryption)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   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(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at Mediachase.Data.Provider.SqlDataProvider.<>c__DisplayClass17_2.<LoadDataSet>b__0()
   at EPiServer.Data.Providers.SqlTransientErrorsRetryPolicy.Execute[TResult](Func`1 method)
   at Mediachase.Data.Provider.SqlDataProvider.WithRetry[TResult](Func`1 action)
   at Mediachase.Data.Provider.SqlDataProvider.LoadDataSet(DataCommand command)
#182375
Sep 17, 2017 14:29
Quan Mai
Quan Mai
Vote:
 

We already have a bug report for that issue. It seems it is affecting multiple customers, we'll make sure to look into it. 

#182383
Sep 17, 2017 18:23
Quan Mai
Quan Mai
Vote:
 

I would suggest you to run this

DECLARE @Name nvarchar(1000);
DECLARE @Sql nvarchar(1000);
DECLARE @Result int;

DECLARE ObjectCursor CURSOR FAST_FORWARD FOR
SELECT QUOTENAME(SCHEMA_NAME(o.schema_id)) + '.' + QUOTENAME(OBJECT_NAME(o.object_id))
FROM sys.objects o
WHERE type_desc IN (
'SQL_STORED_PROCEDURE',
'SQL_SCALAR_FUNCTION');

OPEN ObjectCursor;

FETCH NEXT FROM ObjectCursor INTO @Name;

WHILE @@FETCH_STATUS = 0
BEGIN
PRINT N'Refreshing ''' + @Name + '''';
SET @Sql = N'EXEC sp_refreshsqlmodule ''' + @Name + '''';

BEGIN TRY
EXEC @Result = sp_executesql @Sql;
IF @Result <> 0 RAISERROR('Failed', 16, 1);
END TRY
BEGIN CATCH
PRINT 'The module ''' + @Name + ''' does not compile.';
IF @@TRANCOUNT > 0 ROLLBACK TRANSACTION;
END CATCH

FETCH NEXT FROM ObjectCursor INTO @Name;
END

CLOSE ObjectCursor;
DEALLOCATE ObjectCursor;

GO

on your Commerce database

It should solve your problem. We are working on a fix

/Q

#182386
Edited, Sep 17, 2017 23:05
Bob Maes
Bob Maes
Vote:
 

Hello,

regarding ETA of a fix. Do talk about days or weeks?

Just to know if I wait for new nuget package, or foresee some custom code to trigger this custom script during our deploy's / local setup.

thanks

#182398
Sep 18, 2017 13:32
Quan Mai
Quan Mai
Vote:
 

We can speed up fixing (it's already treated as high priority bug), but we can't guarantee any fixed date. I would expect one week from now, but that's not a promise.

To make sure we understand the problem correctly, what does your ecf_PaymentMethod_Language SP look like? 

#182400
Sep 18, 2017 13:39
Bob Maes
Bob Maes
Vote:
 

Update,

the provided script didn't resolve the issue. Update-epidatabase does.

Also, this time I got a new exception on a find table:

=>

Each package is licensed to you by its owner. NuGet is not responsible for, nor does it grant any licenses to, third-party packages. Some packages may include dependencies which are governed by additional licenses. Follow the package source (feed) URL to determine any dependencies.

Package Manager Console Host Version 4.3.1.4445

Type 'get-help NuGet' to see all available NuGet commands.

File not found at: C:\#####\test\Neuhaus.Ecom.IntegrationTest\web.config
PM> Update-EPiDatabase
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\7.8.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\7.10.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\7.11.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\7.12.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\7.13.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\7.14.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\7.16.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\7.19.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\7.19.1.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\8.0.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\8.4.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\8.6.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\8.7.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\8.9.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\8.10.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\9.0.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\9.0.1.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\9.0.2.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\9.1.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\9.1.1.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\9.2.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\9.3.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\9.4.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\9.5.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\9.6.2.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\9.7.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\9.8.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\9.8.1.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\9.8.2.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\9.8.3.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\10.0.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\10.1.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\10.2.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\10.3.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\10.3.2.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\10.4.1.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\10.5.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\10.6.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\10.7.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\10.8.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\10.9.0.sql
Processing C:\#####\packages\EPiServer.CMS.Core.10.10.4\tools\epiupdates\sql\10.10.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Azure.11.2.2\tools\epiupdates_CMS\sql\1.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Azure.11.2.2\tools\epiupdates_commerce\sql\1.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Azure.11.2.2\tools\epiupdates_commerce\sql\1.0.1.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_CMS\sql\7.6.0.1.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_CMS\sql\8.0.1.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_CMS\sql\8.0.1.2.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_CMS\sql\9.0.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\5.1.0.1.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\5.1.1.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\5.1.2.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\5.2.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\5.2.1.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\5.3.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\5.4.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\5.5.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\5.5.1.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\5.5.2.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\5.6.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\5.6.1.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.0.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.0.1.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.0.2.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.1.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.1.1.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.2.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.3.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.3.1.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.3.2.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.4.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.4.1.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.4.2.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.4.3.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.5.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.6.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.7.0.1.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.7.1.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.8.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.9.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.9.1.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.9.2.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.9.3.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.10.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.10.1.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.10.2.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.10.3.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.10.4.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.10.5.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\6.10.6.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.0.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.0.1.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.0.2.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.0.3.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.0.4.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.0.5.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.0.6.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.0.7.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.0.8.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.0.9.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.0.10.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.0.11.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.0.12.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.0.13.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.0.14.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.0.15.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.0.16.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.1.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.1.1.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.2.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.2.1.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.2.2.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.3.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.3.1.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.4.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.4.1.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.4.2.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.4.3.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.4.4.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.4.5.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.4.6.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.4.7.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.4.8.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.4.9.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.5.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.5.1.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.5.2.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.5.3.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.5.4.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.5.5.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.5.6.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.5.7.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.5.8.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.5.9.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.6.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.6.1.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.6.2.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.6.3.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.6.4.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.7.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.8.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.9.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.10.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\7.10.1.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\8.0.0.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\8.0.1.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\8.0.2.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\8.0.3.0.sql
Processing C:\#####\packages\EPiServer.Commerce.Core.11.2.2\tools\epiupdates_commerce\sql\8.0.4.0.sql
Processing C:\#####\packages\EPiServer.Find.Cms.12.5.3\tools\epiupdates\sql\1.0.1.sql
Processing C:\#####\packages\EPiServer.Find.Cms.12.5.3\tools\epiupdates\sql\12.2.8.sql
epideploy.exe : 
At C:\#####\packages\EPiServer.Framework.10.10.4\tools\upgrade.psm1:310 char:3
+         &$epiDeployPath  -a $action -s $sitePath  -p $updatePath\* -c ...
+         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:String) [], RemoteException
    + FullyQualifiedErrorId : NativeCommandError
 
EPiDeploy was stopped due to an exception, more details:


System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'tblFindIndexQueue' in the database.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Sy
stem.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& usedCache, Boolean asyncWrite, Boolean inRetry)
   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.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:869e3d34-0796-4d6e-9b78-0a21e32fc60d
Error Number:2714,State:6,Class:16

PM>
#182402
Sep 18, 2017 13:52
Bob Maes
Bob Maes
Vote:
 

Hey,

ecf_PaymentMethod_Language before update-epidatabase

USE [nesh.commerce.qa-20170727.5-original]
GO
/****** Object:  StoredProcedure [dbo].[ecf_PaymentMethod_Language]    Script Date: 18/09/2017 13:54:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[ecf_PaymentMethod_Language]
	@ApplicationId uniqueidentifier,
	@LanguageId nvarchar(128),
	@ReturnInactive bit = 0
AS
BEGIN
	select * from [PaymentMethod] 
	where COALESCE(@LanguageId, [LanguageId]) = [LanguageId] and 
		(([IsActive] = 1) or @ReturnInactive = 1) and 
		[ApplicationId] = @ApplicationId order by [Ordering]
	select PMP.* from [PaymentMethodParameter] PMP 
	inner join [PaymentMethod] PM on PMP.[PaymentMethodId] = PM.[PaymentMethodId] 
		where COALESCE(@LanguageId, PM.[LanguageId]) = [LanguageId] and 
		((PM.[IsActive] = 1) or @ReturnInactive = 1) and 
		PM.[ApplicationId] = @ApplicationId
	select SPR.* from [ShippingPaymentRestriction] SPR  
	inner join [PaymentMethod] PM on SPR.[PaymentMethodId] = PM.[PaymentMethodId] 
		where COALESCE(@LanguageId, PM.[LanguageId]) = [LanguageId] and 
		((PM.[IsActive] = 1) or @ReturnInactive = 1) and 
		PM.[ApplicationId] = @ApplicationId and SPR.[RestrictShippingMethods]=0
			
	select MPM.* from [MarketPaymentMethods] MPM  
	inner join [PaymentMethod] PM on MPM.[PaymentMethodId] = PM.[PaymentMethodId] 
		where COALESCE(@LanguageId, PM.[LanguageId]) = [LanguageId] and 
		((PM.[IsActive] = 1) or @ReturnInactive = 1) and
		PM.[ApplicationId] = @ApplicationId
END

after:

USE [nesh.commerce.qa-20170727.5]
GO
/****** Object:  StoredProcedure [dbo].[ecf_PaymentMethod_Language]    Script Date: 18/09/2017 13:53:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[ecf_PaymentMethod_Language]
	@LanguageId nvarchar(128),
	@ReturnInactive bit = 0
AS
BEGIN
	select * from [PaymentMethod] 
	where COALESCE(@LanguageId, [LanguageId]) = [LanguageId] and 
		(([IsActive] = 1) or @ReturnInactive = 1) order by [Ordering]
	select PMP.* from [PaymentMethodParameter] PMP 
	inner join [PaymentMethod] PM on PMP.[PaymentMethodId] = PM.[PaymentMethodId] 
		where COALESCE(@LanguageId, PM.[LanguageId]) = [LanguageId] and 
		((PM.[IsActive] = 1) or @ReturnInactive = 1)
	select SPR.* from [ShippingPaymentRestriction] SPR  
	inner join [PaymentMethod] PM on SPR.[PaymentMethodId] = PM.[PaymentMethodId] 
		where COALESCE(@LanguageId, PM.[LanguageId]) = [LanguageId] and 
		((PM.[IsActive] = 1) or @ReturnInactive = 1) and 
		SPR.[RestrictShippingMethods]=0
			
	select MPM.* from [MarketPaymentMethods] MPM  
	inner join [PaymentMethod] PM on MPM.[PaymentMethodId] = PM.[PaymentMethodId] 
		where COALESCE(@LanguageId, PM.[LanguageId]) = [LanguageId] and 
		((PM.[IsActive] = 1) or @ReturnInactive = 1)
END
#182403
Edited, Sep 18, 2017 13:55
Quan Mai
Quan Mai
Vote:
 

@Scott Redd: Make sure your appSetting episerver:UpdateDatabaseSchema is set to true, or removed. This setting has higher priority than updateDatabaseSchema in episerver.framework section

@Bob: we know what is wrong - a fix is coming 

#182412
Sep 18, 2017 15:18
Bob Maes
Bob Maes
Vote:
 

Hello,

will the fix be through a package update? or something that you'll post in this thread?

I don't think it was included in update 180.

thanks,

bob

#182485
Sep 20, 2017 23:53
Quan Mai
Quan Mai
Vote:
 

It is not yet released, will be in Commerce 11.2.4 (probably next week)

#182488
Sep 21, 2017 7:02
Quan Mai
Quan Mai
Vote:
 

It's fixed in 11.2.4, the packages are ready and will be published later today, or early next week.

#182560
Sep 22, 2017 16:01
Scott Reed
Scott Reed
Vote:
 

I have had the chance to redeploy to the DXC now with the fixes and am getting a GetContentSchemaVersionNumber does not existing error when trying to load the site. I can't see this table in my load databases either?

#183040
Oct 03, 2017 17:22
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.