Skip to main content

Notifications

Announcements

No record found.

Supply chain | Supply Chain Management, Commerce
Suggested answer

UpdateRetailChannelDatabase.ps1 failed line 272

(0) ShareShare
ReportReport
Posted on by 15

Hello Everyone,

I am trying to upgrade MS D365 FO from version "10.0.28" to version "10.0.29" on Local VM downloaded before through LCS.

I am upgrading it using Runbook via command prompt.

Note: - Please note that I have already executed SQL script <ServiceVolue>:\DeployablePackages\<PackageGUID>\RetailServer\Scripts\DropAllRetialChannelDbObjects.sql

But still getting same error.

Below are the error generated from CMD

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

C:\Temp\FinanceAndOperations_10.0.1326.46_Application>AXUpdateInstaller.exe execute -runbookid="Dev-runbook22092022" -rerunstep=60
Start executing runbook : Dev-runbook22092022
Executing step: 60
GlobalUpdate script for service model: RetailServer on machine: MININT-57EHFHJ
Update the Retail Channel database.
UpdateRetailChannelDatabase.ps1 failed.
try{
$erroractionpreference = 'stop';
& 'C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1'
}
catch
{
$erroractionpreference = 'Continue';
Write-Error ($_ | Format-List * -Force | Out-String -Width 4096);
[Environment]::Exit(999)
} :
PSMessageDetails :
Exception : System.Management.Automation.RuntimeException:

PSMessageDetails :
Exception : System.Management.Automation.RuntimeException: Scriptblock exited with error code 2.
TargetObject : Scriptblock exited with error code 2.
CategoryInfo : OperationStopped: (Scriptblock exited with error code 2.:String) [], RuntimeException
FullyQualifiedErrorId : Scriptblock exited with error code 2.
ErrorDetails :
InvocationInfo : System.Management.Automation.InvocationInfo
ScriptStackTrace : at Invoke-ScriptBlock, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\Common-Configuration.ps1: line 2085
at Invoke-Script, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\Common-Configuration.ps1: line 2099
at Run-DatabaseUpgrade, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 76
at Upgrade-RetailChannelDatabase, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line
228
at <ScriptBlock>, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 272
at <ScriptBlock>, <No file>: line 3
at <ScriptBlock>, <No file>: line 1
PipelineIterationInfo : {}


TargetObject :

PSMessageDetails :
Exception : System.Management.Automation.RuntimeException: Scriptblock exited with error code 2.
TargetObject : Scriptblock exited with error code 2.
CategoryInfo : OperationStopped: (Scriptblock exited with error code 2.:String) [], RuntimeException
FullyQualifiedErrorId : Scriptblock exited with error code 2.
ErrorDetails :
InvocationInfo : System.Management.Automation.InvocationInfo
ScriptStackTrace : at Invoke-ScriptBlock, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\Common-Configuration.ps1: line 2085
at Invoke-Script, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\Common-Configuration.ps1: line 2099
at Run-DatabaseUpgrade, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 76
at Upgrade-RetailChannelDatabase, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line
228
at <ScriptBlock>, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 272
at <ScriptBlock>, <No file>: line 3
at <ScriptBlock>, <No file>: line 1
PipelineIterationInfo : {}


CategoryInfo : OperationStopped: (

PSMessageDe...fo : {}

:String) [], RuntimeException
FullyQualifiedErrorId :

PSMessageDetails :
Exception : System.Management.Automation.RuntimeException: Scriptblock exited with error code 2.
TargetObject : Scriptblock exited with error code 2.
CategoryInfo : OperationStopped: (Scriptblock exited with error code 2.:String) [], RuntimeException
FullyQualifiedErrorId : Scriptblock exited with error code 2.
ErrorDetails :
InvocationInfo : System.Management.Automation.InvocationInfo
ScriptStackTrace : at Invoke-ScriptBlock, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\Common-Configuration.ps1: line 2085
at Invoke-Script, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\Common-Configuration.ps1: line 2099
at Run-DatabaseUpgrade, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 76
at Upgrade-RetailChannelDatabase, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line
228
at <ScriptBlock>, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 272
at <ScriptBlock>, <No file>: line 3
at <ScriptBlock>, <No file>: line 1
PipelineIterationInfo : {}


ErrorDetails :
InvocationInfo : System.Management.Automation.InvocationInfo
ScriptStackTrace : at <ScriptBlock>, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 291
at <ScriptBlock>, <No file>: line 3
at <ScriptBlock>, <No file>: line 1
PipelineIterationInfo : {}
At line:1 char:1
+ &{ try{
+ ~~~~~~~
+ CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
+ FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException


The step failed.

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Please guide to resolve the above error.

I don't want to mark it as complete. Thanks

  • jvivesru Profile Picture
    jvivesru 2 on at
    UpdateRetailChannelDatabase.ps1 failed line 272
    Hello, 
     
    I've just faced this issue and i've solved it executing the script that you can see in the RetailChannelDatabaseLogs\CommerceRuntimeScripts_0.0.0.0_9.49.24078.1.sql.
    Then I rerun the step and it worked.
     
    Hope it helps you too
  • Suggested answer
    RE: UpdateRetailChannelDatabase.ps1 failed line 272

    Please consider using the version below which contains the following fix:

    pastedimage1666012821638v1.png

    Details for issue 726689 (dynamics.com)

  • Suggested answer
    Anant Dubey Profile Picture
    Anant Dubey 15 on at
    RE: UpdateRetailChannelDatabase.ps1 failed line 272

    Hi,

    Microsoft has suggested me to apply below quality update before proceeding to 10.0.29 version.

    unfortunately my VM got corrupted due to some other reasons and I created new VM so couldn't find out if this QA update will help.

    You can try and share your comments.

    (Quality Update 10.0.28)

  • RE: UpdateRetailChannelDatabase.ps1 failed line 272

    Hi Jurgen,

    Can you please provide more details about the error that you are facing during the installation in runbook logs?

  • RE: UpdateRetailChannelDatabase.ps1 failed line 272

    Hi Guys,

    I am facing the same error messages also on 3 devboxes so far. Dropping the Retail Channel DB objects does not do the trick.

    No idea what is causing the error.

    Looking forward for a solution

  • Ambanna Profile Picture
    Ambanna 20 on at
    RE: UpdateRetailChannelDatabase.ps1 failed line 272

    Hi Anant,

    Did you find the solution for the above issue?

    I am also facing same even after following both the steps

    executing the script file "DropAllRetailChannelDbObjects.sql" & dropping the view, still error comes.

    Thanks for the update.

    Ambanna

  • RE: UpdateRetailChannelDatabase.ps1 failed line 272

    Hi Anant,

    Thank you, so this means that you are facing the known issue that I pointed out previously.

    So, can you please create a support case request with all these logs, then the engineer will work with you and create the missing index, etc..

    Thank you.

  • Anant Dubey Profile Picture
    Anant Dubey 15 on at
    RE: UpdateRetailChannelDatabase.ps1 failed line 272

    Hi Diogo, Thanks for the above suggestions.

    I have executed the suggested query but deployment failed again.

    Pasting new log below: 

    Path - \RunbookWorkingFolder\Dev-runbook22092022\MININT-57EHFHJ\RetailServer\60\Log

    9/28/2022 2:48:56 AM: Getting website physical path for website - RetailServer
    9/28/2022 2:48:56 AM: - Trying to get information of the website - RetailServer ...
    9/28/2022 2:48:56 AM: Found website physical path - C:\RetailServer\webroot
    9/28/2022 2:48:56 AM: Getting web.config path.
    9/28/2022 2:48:56 AM: Found web.config path - C:\RetailServer\webroot\web.config
    9/28/2022 2:48:56 AM: Getting installation info XML path.
    9/28/2022 2:48:56 AM: Found installation info XML path - C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\InstallationInfo.xml
    9/28/2022 2:48:56 AM: - Checking if CustomPublisher node is populated in the installation info file ...
    9/28/2022 2:48:56 AM: No.
    9/28/2022 2:48:56 AM: - Trying to get information of the website - AOSService ...
    Skipping setting 'CertificateHandler.DataEncryptionKey' as it is not in the config file.
    Skipping setting 'CertificateHandler.DataEncryptionIV' as it is not in the config file.
    Skipping setting 'AzureStorage.StorageConnectionString' as it is not in the config file.
    Skipping setting 'Aos.AxPackageStorage' as it is not in the config file.
    Skipping setting 'BiReporting.DWPwd' as it is not in the config file.
    Skipping setting 'BiReporting.DWRuntimePwd' as it is not in the config file.
    Skipping setting 'PowerBIEmbedded.AccessKey' as it is not in the config file.
    Skipping setting 'PowerBIEmbedded.AccessKey2' as it is not in the config file.
    Skipping setting 'PowerBIEmbedded.V2AppAccessKey' as it is not in the config file.
    9/28/2022 2:48:57 AM: Begin upgrading Retail Channel database
    9/28/2022 2:48:57 AM: Servicing information has been migrated to web.config, extract it from web.config
    9/28/2022 2:48:57 AM: This is a Microsoft package, will use axdeployuser to apply critical database changes.
    9/28/2022 2:48:57 AM: Trying to upgrade Retail Channel database.
    9/28/2022 2:48:57 AM: Updating attribute "value" at "Settings/Setting[@key='ChannelDatabaseServerName']" with "localhost".
    9/28/2022 2:48:57 AM: Successfully updated.
    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\channeldb-settings-updated.xml has been written.
    Value for [ChannelDatabaseServerNamedInstanceName] to update settings .xml [C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\channeldb-settings-updated.xml] is null. Skipping update
    9/28/2022 2:48:57 AM: Updating attribute "value" at "Settings/Setting[@key='ChannelDatabaseName']" with "AxDB".
    9/28/2022 2:48:57 AM: Successfully updated.
    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\channeldb-settings-updated.xml has been written.
    9/28/2022 2:48:57 AM: Updating attribute "value" at "Settings/Setting[@key='SqlUserName']" with "axdeployuser".
    9/28/2022 2:48:57 AM: Successfully updated.
    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\channeldb-settings-updated.xml has been written.
    9/28/2022 2:48:57 AM: Updating attribute "value" at "Settings/Setting[@key='ChannelDatabaseUpgradeCustomScriptFolderPath']" with "C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Data\Upgrade\Custom".
    9/28/2022 2:48:57 AM: Successfully updated.
    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\channeldb-settings-updated.xml has been written.
    9/28/2022 2:48:57 AM: Updating attribute "value" at "Settings/Setting[@key='ChannelDatabaseUpgradeDacpacFileFolderPath']" with "C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Data".
    9/28/2022 2:48:57 AM: Successfully updated.
    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\channeldb-settings-updated.xml has been written.
    9/28/2022 2:48:57 AM: Updating attribute "value" at "Settings/Setting[@key='ChannelDatabaseUpgradeRetailScriptFolderPath']" with "C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Data\Upgrade\Retail".
    9/28/2022 2:48:57 AM: Successfully updated.
    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\channeldb-settings-updated.xml has been written.
    9/28/2022 2:48:57 AM: Saved topology file at "C:\Users\Administrator\AppData\Local\Temp\tmpC923.tmp"
    9/28/2022 2:48:57 AM: Making sure all settings were expanded
    Found config <Database id="Channel" install="true" dropifexists="false"><ServerName>localhost</ServerName><ServerNamedInstanceName></ServerNamedInstanceName><DatabaseName>AxDB</DatabaseName><SqlUserName>axdeployuser</SqlUserName><WindowsLogin id="RetailChannelUsers" GroupName="localhost\RetailChannelUsers" CreateIfNotExists="true" MappedSqlRoleName="UsersRole" /><WindowsLogin id="RetailChannelPublishers" GroupName="localhost\RetailChannelPublishers" CreateIfNotExists="true" MappedSqlRoleName="PublishersRole" /><WindowsLogin id="RetailDataSyncUsers" GroupName="localhost\RetailDataSyncUsers" CreateIfNotExists="true" MappedSqlRoleName="DataSyncUsersRole" /><WindowsLogin id="RetailReportUsers" GroupName="localhost\RetailReportUsers" CreateIfNotExists="true" MappedSqlRoleName="ReportUsersRole" /><WindowsLogin id="POSUsers" GroupName="localhost\POSUsers" CreateIfNotExists="true" MappedSqlRoleName="db_datareader" /><WindowsLogin id="POSUsers" GroupName="localhost\POSUsers" CreateIfNotExists="true" MappedSqlRoleName="db_datawriter" /><WindowsLogin id="POSUsers" GroupName="localhost\POSUsers" CreateIfNotExists="true" MappedSqlRoleName="db_executor" /><Installation><InstallationType>SqlScripts</InstallationType><InstallationValue></InstallationValue><Upgrades><RetailScriptPath>C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Data\Upgrade\Retail</RetailScriptPath><CustomScriptPath>C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Data\Upgrade\Custom</CustomScriptPath><DacpacFilePath>C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Data</DacpacFilePath></Upgrades></Installation></Database>
    9/28/2022 2:48:57 AM: All windows group memberships are added.
    9/28/2022 2:48:57 AM: Database deployment logs will be available at: C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailChannelDatabaseLogs\2022-09-28_02-48-57
    9/28/2022 2:48:57 AM: Deploying 1 databases.
    9/28/2022 2:48:57 AM: Loading validation tools from 'C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\DacTools\Microsoft.Dynamics365.Commerce.Tools.DacValidator.dll'
    9/28/2022 2:48:57 AM: AxDB - Processing database 1 of 1
    9/28/2022 2:48:57 AM: AxDB - Deploying database
    9/28/2022 2:48:57 AM: Created connection string (password is omitted): Data Source=localhost;User ID=axdeployuser;Pooling=False;Connect Timeout=30;Application Name=D365RetailDeployment
    9/28/2022 2:48:57 AM: AxDB - Preparing to deploy
    9/28/2022 2:48:57 AM: AxDB - log folder C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailChannelDatabaseLogs\2022-09-28_02-48-57\AxDB doesn't exist. It will be created now.
    9/28/2022 2:48:57 AM: AxDB - database statement execution logs will be available at: C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailChannelDatabaseLogs\2022-09-28_02-48-57\AxDB\DatabaseLogs.log
    9/28/2022 2:48:57 AM: AxDB - Loading publish options from: C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\DeploymentPublishProfile.xml
    9/28/2022 2:48:58 AM: AxDB - Loading the following DAC package to be used for this deployment: C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Data\CommerceRuntimeScripts.dacpac
    9/28/2022 2:48:58 AM: AxDB - check that database exists.
    9/28/2022 2:48:58 AM: AxDB - database exists.
    9/28/2022 2:48:58 AM: AxDB - checking connection against database.
    9/28/2022 2:48:58 AM: AxDB - quering for canary view __RETAIL_CANARY before proceeding. If it exists, we will fail deployment. This can be used to provide manual intervention prior deployment. Run this on the database to create it: CREATE VIEW __RETAIL_CANARY AS SELECT 1 A;
    9/28/2022 2:48:58 AM: AxDB - canary view __RETAIL_CANARY not found. Continuing normally.
    9/28/2022 2:48:58 AM: AxDB - quering current database version against [AX.DBVERSION].
    9/28/2022 2:48:58 AM: AxDB - no version found. Assuming new database deployment.
    9/28/2022 2:48:58 AM: AxDB - current DB version is 0.0.0.0 and upgrade package version is 9.39.22239.2.
    9/28/2022 2:48:58 AM: AxDB - retrieving current binary package from database using CRT.RETAILUPGRADEHISTORY.
    9/28/2022 2:48:58 AM: AxDB - database does not support storing/retrieving DACPACs. CRT.RETAILUPGRADEHISTORY doesn't exist or DACPACFILE column is not present.
    9/28/2022 2:48:58 AM: AxDB - this is a new database deployment (because [ax].[DBVESION] table does not exist), binary package is not required.
    9/28/2022 2:48:58 AM: AxDB - generating creation/upgrade script. This may take several minutes.
    9/28/2022 2:49:12 AM: AxDB - script created. It can be found at C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailChannelDatabaseLogs\2022-09-28_02-48-57\AxDB\CommerceRuntimeScripts_0.0.0.0_9.39.22239.2.sql
    9/28/2022 2:49:12 AM: AxDB - Storing upgrade DAPAC on the database.
    9/28/2022 2:49:12 AM: AxDB - Database does not support storing DACPACs. DACPAC will be stored after database upgrade adds DACPAC storage support.
    9/28/2022 2:49:12 AM: AxDB - Checking whether a previous channel database deployment was not deployed successfully. This will be done by checking whether view __RETAIL_PENDING_DEPLOYMENT exists in DBO
    9/28/2022 2:49:12 AM: AxDB - No previous incomplete deployment was detected. Creating view __RETAIL_PENDING_DEPLOYMENT to signal begining of deployment.
    9/28/2022 2:49:12 AM: AxDB - Starting script execution. This may take several minutes.
    9/28/2022 2:49:13 AM: AxDB -------------------- Start of dump of DB logs
    9/28/2022 2:49:13 AM: AxDB -------------------- End of dump of DB logs
    9/28/2022 2:49:13 AM: ############### Error occurred: ###############
    9/28/2022 2:49:13 AM: AxDB - An error occurred when deploying database. Deployment will continue for other databases, but this deployment will be marked as failed.
    9/28/2022 2:49:13 AM: ############### Error occurred: ###############
    9/28/2022 2:49:13 AM:
    PSMessageDetails :
    Exception : System.Management.Automation.MethodInvocationException: Exception calling "ExecuteSqlText" with "1" argument(s): "User, group, or role 'DataSyncUsersRole' already exists in the current database. Near statement:
    CREATE ROLE [DataSyncUsersRole]
    AUTHORIZATION [dbo];
    ... " ---> System.Exception: User, group, or role 'DataSyncUsersRole' already exists in the current database. Near statement:
    CREATE ROLE [DataSyncUsersRole]
    AUTHORIZATION [dbo];
    ... ---> System.Data.SqlClient.SqlException: User, group, or role 'DataSyncUsersRole' already exists in the current database.
    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& usedCache, Boolean asyncWrite, Boolean inRetry)
    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    at Microsoft.Dynamics365.Commerce.Tools.DacValidator.Database.Execute(IDictionary parameters, String[] sqlCommands)
    --- End of inner exception stack trace ---
    at Microsoft.Dynamics365.Commerce.Tools.DacValidator.Database.Execute(IDictionary parameters, String[] sqlCommands)
    at CallSite.Target(Closure , CallSite , Object , Object )
    --- End of inner exception stack trace ---
    at System.Management.Automation.ExceptionHandlingOps.CheckActionPreference(FunctionContext funcContext, Exception exception)
    at System.Management.Automation.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame frame)
    at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
    at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
    TargetObject :
    CategoryInfo : NotSpecified: (:) [], MethodInvocationException
    FullyQualifiedErrorId : Exception
    ErrorDetails :
    InvocationInfo : System.Management.Automation.InvocationInfo
    ScriptStackTrace : at Deploy-Database, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\Common-Database.ps1: line 864
    at Deploy-DatabaseConfiguration, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\Common-Database.ps1: line 1049
    at <ScriptBlock>, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\Deploy-Databases.ps1: line 45
    at <ScriptBlock>, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 78
    at Invoke-ScriptBlock, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\Common-Configuration.ps1: line 2068
    at Invoke-Script, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\Common-Configuration.ps1: line 2099
    at Run-DatabaseUpgrade, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 76
    at Upgrade-RetailChannelDatabase, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 228
    at <ScriptBlock>, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 272
    at <ScriptBlock>, <No file>: line 3
    at <ScriptBlock>, <No file>: line 1
    PipelineIterationInfo : {}
    9/28/2022 2:49:13 AM: AxDB - Deployment for 'AxDB' finished with errors.
    9/28/2022 2:49:13 AM: ############### Error occurred: ###############
    9/28/2022 2:49:13 AM: Database upgrade FAILED for the following databases: AxDB. You may find more logs under: C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailChannelDatabaseLogs\2022-09-28_02-48-57
    9/28/2022 2:49:13 AM: ############### Error occurred: ###############
    9/28/2022 2:49:13 AM:
    PSMessageDetails :
    Exception : System.Management.Automation.RuntimeException: Database upgrade FAILED for the following
    databases: AxDB. You may find more logs under: C:\Temp\FinanceAndOperations_10.0.1326.46_Applic
    ation\RetailChannelDatabaseLogs\2022-09-28_02-48-57
    TargetObject : Database upgrade FAILED for the following databases: AxDB. You may find more logs under: C:\Tem
    p\FinanceAndOperations_10.0.1326.46_Application\RetailChannelDatabaseLogs\2022-09-28_02-48-57
    CategoryInfo : OperationStopped: (Database upgrad...-09-28_02-48-57:String) [], RuntimeException
    FullyQualifiedErrorId : Database upgrade FAILED for the following databases: AxDB. You may find more logs under: C:\Tem
    p\FinanceAndOperations_10.0.1326.46_Application\RetailChannelDatabaseLogs\2022-09-28_02-48-57
    ErrorDetails :
    InvocationInfo : System.Management.Automation.InvocationInfo
    ScriptStackTrace : at Throw-Error, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\Comm
    on-Configuration.ps1: line 1494
    at Deploy-DatabaseConfiguration, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailSe
    rver\Scripts\Common-Database.ps1: line 1132
    at <ScriptBlock>, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\De
    ploy-Databases.ps1: line 45
    at <ScriptBlock>, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Up
    grade\Core\UpdateRetailChannelDatabase.ps1: line 78
    at Invoke-ScriptBlock, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scrip
    ts\Upgrade\Core\Common-Configuration.ps1: line 2068
    at Invoke-Script, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Up
    grade\Core\Common-Configuration.ps1: line 2099
    at Run-DatabaseUpgrade, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scri
    pts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 76
    at Upgrade-RetailChannelDatabase, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailS
    erver\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 228
    at <ScriptBlock>, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Up
    grade\Core\UpdateRetailChannelDatabase.ps1: line 272
    at <ScriptBlock>, <No file>: line 3
    at <ScriptBlock>, <No file>: line 1
    PipelineIterationInfo : {}
    Executed:
    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\Deploy-Databases.ps1
    Parameter: TopologyXmlFilePath Value: C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\channeldb-topology-cloud.xml
    Parameter: SettingsXmlFilePath Value: C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\channeldb-settings-updated.xml
    Parameter: Credentials Value: System.Management.Automation.PSCredential[]
    Parameter: Verbose Value: True
    Parameter: DeploymentType Value: ChannelDB
    Exiting with error code 2.
    9/28/2022 2:49:13 AM: Table [ax].[GUPITEMBASEPRICE] does not exist, skip creating CONSTRAINT [ax].[GUPITEMBASEPRICE].[I_-1063074925_1429128816] Creating [DataSyncUsersRole]...
    9/28/2022 2:49:13 AM: ############### Error occurred: ###############
    9/28/2022 2:49:13 AM:
    PSMessageDetails :
    Exception : System.Management.Automation.RuntimeException: Scriptblock exited with error code 2.
    TargetObject : Scriptblock exited with error code 2.
    CategoryInfo : OperationStopped: (Scriptblock exited with error code 2.:String) [], RuntimeException
    FullyQualifiedErrorId : Scriptblock exited with error code 2.
    ErrorDetails :
    InvocationInfo : System.Management.Automation.InvocationInfo
    ScriptStackTrace : at Invoke-ScriptBlock, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scrip
    ts\Upgrade\Core\Common-Configuration.ps1: line 2085
    at Invoke-Script, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Up
    grade\Core\Common-Configuration.ps1: line 2099
    at Run-DatabaseUpgrade, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scri
    pts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 76
    at Upgrade-RetailChannelDatabase, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailS
    erver\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 228
    at <ScriptBlock>, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Up
    grade\Core\UpdateRetailChannelDatabase.ps1: line 272
    at <ScriptBlock>, <No file>: line 3
    at <ScriptBlock>, <No file>: line 1
    PipelineIterationInfo : {}
    Executed:
    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1
    Exiting with error code .
    9/28/2022 2:49:13 AM: - Trying to get information of the website - AOSService ...
    Skipping setting 'CertificateHandler.DataEncryptionKey' as it is not in the config file.
    Skipping setting 'CertificateHandler.DataEncryptionIV' as it is not in the config file.
    Skipping setting 'AzureStorage.StorageConnectionString' as it is not in the config file.
    Skipping setting 'Aos.AxPackageStorage' as it is not in the config file.
    Skipping setting 'BiReporting.DWPwd' as it is not in the config file.
    Skipping setting 'BiReporting.DWRuntimePwd' as it is not in the config file.
    Skipping setting 'PowerBIEmbedded.AccessKey' as it is not in the config file.
    Skipping setting 'PowerBIEmbedded.AccessKey2' as it is not in the config file.
    Skipping setting 'PowerBIEmbedded.V2AppAccessKey' as it is not in the config file.

    try{
    $erroractionpreference = 'stop';
    & 'C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailSer
    ver\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1'
    }
    catch
    {
    $erroractionpreference = 'Continue';
    Write-Error ($_ | Format-List * -Force | Out-String -Width 4096);
    [Environment]::Exit(999)
    } :
    PSMessageDetails :
    Exception : System.Management.Automation.RuntimeException:

    PSMessageDetails :
    Exception : System.Management.Automation.RuntimeException: Scriptblock exited with
    error code 2.
    TargetObject : Scriptblock exited with error code 2.
    CategoryInfo : OperationStopped: (Scriptblock exited with error code 2.:String) [],
    RuntimeException
    FullyQualifiedErrorId : Scriptblock exited with error code 2.
    ErrorDetails :
    InvocationInfo : System.Management.Automation.InvocationInfo
    ScriptStackTrace : at Invoke-ScriptBlock,
    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scrip
    ts\Upgrade\Core\Common-Configuration.ps1: line 2085
    at Invoke-Script,
    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Up
    grade\Core\Common-Configuration.ps1: line 2099
    at Run-DatabaseUpgrade,
    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scri
    pts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 76
    at Upgrade-RetailChannelDatabase,
    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailS
    erver\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 228
    at <ScriptBlock>,
    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Up
    grade\Core\UpdateRetailChannelDatabase.ps1: line 272
    at <ScriptBlock>, <No file>: line 3
    at <ScriptBlock>, <No file>: line 1
    PipelineIterationInfo : {}




    TargetObject :

    PSMessageDetails :
    Exception : System.Management.Automation.RuntimeException: Scriptblock exited with
    error code 2.
    TargetObject : Scriptblock exited with error code 2.
    CategoryInfo : OperationStopped: (Scriptblock exited with error code 2.:String) [],
    RuntimeException
    FullyQualifiedErrorId : Scriptblock exited with error code 2.
    ErrorDetails :
    InvocationInfo : System.Management.Automation.InvocationInfo
    ScriptStackTrace : at Invoke-ScriptBlock,
    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scrip
    ts\Upgrade\Core\Common-Configuration.ps1: line 2085
    at Invoke-Script,
    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Up
    grade\Core\Common-Configuration.ps1: line 2099
    at Run-DatabaseUpgrade,
    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scri
    pts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 76
    at Upgrade-RetailChannelDatabase,
    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailS
    erver\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 228
    at <ScriptBlock>,
    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Up
    grade\Core\UpdateRetailChannelDatabase.ps1: line 272
    at <ScriptBlock>, <No file>: line 3
    at <ScriptBlock>, <No file>: line 1
    PipelineIterationInfo : {}




    CategoryInfo : OperationStopped: (

    PSMessageDe...fo : {}



    :String) [], RuntimeException
    FullyQualifiedErrorId :

    PSMessageDetails :
    Exception : System.Management.Automation.RuntimeException: Scriptblock exited with
    error code 2.
    TargetObject : Scriptblock exited with error code 2.
    CategoryInfo : OperationStopped: (Scriptblock exited with error code 2.:String) [],
    RuntimeException
    FullyQualifiedErrorId : Scriptblock exited with error code 2.
    ErrorDetails :
    InvocationInfo : System.Management.Automation.InvocationInfo
    ScriptStackTrace : at Invoke-ScriptBlock,
    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scrip
    ts\Upgrade\Core\Common-Configuration.ps1: line 2085
    at Invoke-Script,
    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Up
    grade\Core\Common-Configuration.ps1: line 2099
    at Run-DatabaseUpgrade,
    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scri
    pts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 76
    at Upgrade-RetailChannelDatabase,
    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailS
    erver\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 228
    at <ScriptBlock>,
    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Up
    grade\Core\UpdateRetailChannelDatabase.ps1: line 272
    at <ScriptBlock>, <No file>: line 3
    at <ScriptBlock>, <No file>: line 1
    PipelineIterationInfo : {}




    ErrorDetails :
    InvocationInfo : System.Management.Automation.InvocationInfo
    ScriptStackTrace : at <ScriptBlock>, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Up
    grade\Core\UpdateRetailChannelDatabase.ps1: line 291
    at <ScriptBlock>, <No file>: line 3
    at <ScriptBlock>, <No file>: line 1
    PipelineIterationInfo : {}
    At line:1 char:1
    + &{ try{
    + ~~~~~~~
    + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException

    Path: \RetailChannelDatabaseLogs\2022-09-28_02-48-57\AxDB

    Table [ax].[GUPITEMBASEPRICE] does not exist, skip creating CONSTRAINT [ax].[GUPITEMBASEPRICE].[I_-1063074925_1429128816]
    Creating [DataSyncUsersRole]...

    Please suggest also let me know if we can check logs from some other place as well. Thanks

  • Suggested answer
    RE: UpdateRetailChannelDatabase.ps1 failed line 272

    Can you execute in SSMS:

    DROP VIEW __RETAIL_PENDING_DEPLOYMENT

    Basically, is Open SQL Management Studio, and create a new query for AxDB Drop VIEW __RETAIL_PENDING_DEPLOYMENT

    And then retry the service update installation?

  • Anant Dubey Profile Picture
    Anant Dubey 15 on at
    RE: UpdateRetailChannelDatabase.ps1 failed line 272

    Hi Diogo,

    Thank you so much for guidance.

    I navigated to "RunbookWorkingFolder\Dev-runbook22092022\MININT-57EHFHJ\RetailServer\60\Log".

    I found below error: -

    9/26/2022 4:12:56 AM: Getting website physical path for website - RetailServer

    9/26/2022 4:12:56 AM:     - Trying to get information of the website - RetailServer ...

    9/26/2022 4:12:56 AM: Found website physical path - C:\RetailServer\webroot

    9/26/2022 4:12:56 AM: Getting web.config path.

    9/26/2022 4:12:56 AM: Found web.config path - C:\RetailServer\webroot\web.config

    9/26/2022 4:12:56 AM: Getting installation info XML path.

    9/26/2022 4:12:56 AM: Found installation info XML path - C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\InstallationInfo.xml

    9/26/2022 4:12:56 AM:     - Checking if CustomPublisher node is populated in the installation info file ...

    9/26/2022 4:12:56 AM:       No.

    9/26/2022 4:12:56 AM:     - Trying to get information of the website - AOSService ...

    Skipping setting 'CertificateHandler.DataEncryptionKey' as it is not in the config file.

    Skipping setting 'CertificateHandler.DataEncryptionIV' as it is not in the config file.

    Skipping setting 'AzureStorage.StorageConnectionString' as it is not in the config file.

    Skipping setting 'Aos.AxPackageStorage' as it is not in the config file.

    Skipping setting 'BiReporting.DWPwd' as it is not in the config file.

    Skipping setting 'BiReporting.DWRuntimePwd' as it is not in the config file.

    Skipping setting 'PowerBIEmbedded.AccessKey' as it is not in the config file.

    Skipping setting 'PowerBIEmbedded.AccessKey2' as it is not in the config file.

    Skipping setting 'PowerBIEmbedded.V2AppAccessKey' as it is not in the config file.

    9/26/2022 4:12:56 AM: Begin upgrading Retail Channel database

    9/26/2022 4:12:56 AM: Servicing information has been migrated to web.config, extract it from web.config

    9/26/2022 4:12:56 AM: This is a Microsoft package, will use axdeployuser to apply critical database changes.

    9/26/2022 4:12:57 AM: Trying to upgrade Retail Channel database.

    9/26/2022 4:12:57 AM: Updating attribute "value" at "Settings/Setting[@key='ChannelDatabaseServerName']" with "localhost".

    9/26/2022 4:12:57 AM: Successfully updated.

    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\channeldb-settings-updated.xml has been written.

    Value for [ChannelDatabaseServerNamedInstanceName] to update settings .xml [C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\channeldb-settings-updated.xml] is null. Skipping update

    9/26/2022 4:12:57 AM: Updating attribute "value" at "Settings/Setting[@key='ChannelDatabaseName']" with "AxDB".

    9/26/2022 4:12:57 AM: Successfully updated.

    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\channeldb-settings-updated.xml has been written.

    9/26/2022 4:12:57 AM: Updating attribute "value" at "Settings/Setting[@key='SqlUserName']" with "axdeployuser".

    9/26/2022 4:12:57 AM: Successfully updated.

    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\channeldb-settings-updated.xml has been written.

    9/26/2022 4:12:57 AM: Updating attribute "value" at "Settings/Setting[@key='ChannelDatabaseUpgradeCustomScriptFolderPath']" with "C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Data\Upgrade\Custom".

    9/26/2022 4:12:57 AM: Successfully updated.

    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\channeldb-settings-updated.xml has been written.

    9/26/2022 4:12:57 AM: Updating attribute "value" at "Settings/Setting[@key='ChannelDatabaseUpgradeDacpacFileFolderPath']" with "C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Data".

    9/26/2022 4:12:57 AM: Successfully updated.

    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\channeldb-settings-updated.xml has been written.

    9/26/2022 4:12:57 AM: Updating attribute "value" at "Settings/Setting[@key='ChannelDatabaseUpgradeRetailScriptFolderPath']" with "C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Data\Upgrade\Retail".

    9/26/2022 4:12:57 AM: Successfully updated.

    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\channeldb-settings-updated.xml has been written.

    9/26/2022 4:12:57 AM: Saved topology file at "C:\Users\Administrator\AppData\Local\Temp\tmpF01C.tmp"

    9/26/2022 4:12:57 AM: Making sure all settings were expanded

    Found config <Database id="Channel" install="true" dropifexists="false"><ServerName>localhost</ServerName><ServerNamedInstanceName></ServerNamedInstanceName><DatabaseName>AxDB</DatabaseName><SqlUserName>axdeployuser</SqlUserName><WindowsLogin id="RetailChannelUsers" GroupName="localhost\RetailChannelUsers" CreateIfNotExists="true" MappedSqlRoleName="UsersRole" /><WindowsLogin id="RetailChannelPublishers" GroupName="localhost\RetailChannelPublishers" CreateIfNotExists="true" MappedSqlRoleName="PublishersRole" /><WindowsLogin id="RetailDataSyncUsers" GroupName="localhost\RetailDataSyncUsers" CreateIfNotExists="true" MappedSqlRoleName="DataSyncUsersRole" /><WindowsLogin id="RetailReportUsers" GroupName="localhost\RetailReportUsers" CreateIfNotExists="true" MappedSqlRoleName="ReportUsersRole" /><WindowsLogin id="POSUsers" GroupName="localhost\POSUsers" CreateIfNotExists="true" MappedSqlRoleName="db_datareader" /><WindowsLogin id="POSUsers" GroupName="localhost\POSUsers" CreateIfNotExists="true" MappedSqlRoleName="db_datawriter" /><WindowsLogin id="POSUsers" GroupName="localhost\POSUsers" CreateIfNotExists="true" MappedSqlRoleName="db_executor" /><Installation><InstallationType>SqlScripts</InstallationType><InstallationValue></InstallationValue><Upgrades><RetailScriptPath>C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Data\Upgrade\Retail</RetailScriptPath><CustomScriptPath>C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Data\Upgrade\Custom</CustomScriptPath><DacpacFilePath>C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Data</DacpacFilePath></Upgrades></Installation></Database>

    9/26/2022 4:12:57 AM: All windows group memberships are added.

    9/26/2022 4:12:57 AM: Database deployment logs will be available at: C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailChannelDatabaseLogs\2022-09-26_04-12-57

    9/26/2022 4:12:57 AM: Deploying 1 databases.

    9/26/2022 4:12:57 AM: Loading validation tools from 'C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\DacTools\Microsoft.Dynamics365.Commerce.Tools.DacValidator.dll'

    9/26/2022 4:12:57 AM: AxDB - Processing database 1 of 1

    9/26/2022 4:12:57 AM: AxDB - Deploying database

    9/26/2022 4:12:57 AM: Created connection string (password is omitted): Data Source=localhost;User ID=axdeployuser;Pooling=False;Connect Timeout=30;Application Name=D365RetailDeployment

    9/26/2022 4:12:57 AM: AxDB - Preparing to deploy

    9/26/2022 4:12:57 AM: AxDB - log folder C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailChannelDatabaseLogs\2022-09-26_04-12-57\AxDB doesn't exist. It will be created now.

    9/26/2022 4:12:57 AM: AxDB - database statement execution logs will be available at: C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailChannelDatabaseLogs\2022-09-26_04-12-57\AxDB\DatabaseLogs.log

    9/26/2022 4:12:57 AM: AxDB - Loading publish options from: C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\DeploymentPublishProfile.xml

    9/26/2022 4:12:57 AM: AxDB - Loading the following DAC package to be used for this deployment: C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Data\CommerceRuntimeScripts.dacpac

    9/26/2022 4:12:58 AM: AxDB - check that database exists.

    9/26/2022 4:12:58 AM: AxDB - database exists.

    9/26/2022 4:12:58 AM: AxDB - checking connection against database.

    9/26/2022 4:12:58 AM: AxDB - quering for canary view __RETAIL_CANARY before proceeding. If it exists, we will fail deployment. This can be used to provide manual intervention prior deployment. Run this on the database to create it: CREATE VIEW __RETAIL_CANARY AS SELECT 1 A;

    9/26/2022 4:12:58 AM: AxDB - canary view __RETAIL_CANARY not found. Continuing normally.

    9/26/2022 4:12:58 AM: AxDB - quering current database version against [AX.DBVERSION].

    9/26/2022 4:12:58 AM: AxDB - no version found. Assuming new database deployment.

    9/26/2022 4:12:58 AM: AxDB - current DB version is 0.0.0.0 and upgrade package version is 9.39.22239.2.

    9/26/2022 4:12:58 AM: AxDB - retrieving current binary package from database using CRT.RETAILUPGRADEHISTORY.

    9/26/2022 4:12:58 AM: AxDB - database does not support storing/retrieving DACPACs. CRT.RETAILUPGRADEHISTORY doesn't exist or DACPACFILE column is not present.

    9/26/2022 4:12:58 AM: AxDB - this is a new database deployment (because [ax].[DBVESION] table does not exist), binary package is not required.

    9/26/2022 4:12:58 AM: AxDB - generating creation/upgrade script. This may take several minutes.

    9/26/2022 4:13:15 AM: AxDB - script created. It can be found at C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailChannelDatabaseLogs\2022-09-26_04-12-57\AxDB\CommerceRuntimeScripts_0.0.0.0_9.39.22239.2.sql

    9/26/2022 4:13:15 AM: AxDB - Storing upgrade DAPAC on the database.

    9/26/2022 4:13:15 AM: AxDB - Database does not support storing DACPACs. DACPAC will be stored after database upgrade adds DACPAC storage support.

    9/26/2022 4:13:15 AM: AxDB - Checking whether a previous channel database deployment was not deployed successfully. This will be done by checking whether view __RETAIL_PENDING_DEPLOYMENT exists in DBO

    9/26/2022 4:13:15 AM: AxDB -------------------- Start of dump of DB logs

    9/26/2022 4:13:15 AM: AxDB -------------------- End of dump of DB logs

    9/26/2022 4:13:15 AM: ############### Error occurred: ###############

    9/26/2022 4:13:15 AM: AxDB - An error occurred when deploying database. Deployment will continue for other databases, but this deployment will be marked as failed.

    9/26/2022 4:13:15 AM: ############### Error occurred: ###############

    9/26/2022 4:13:15 AM:

    PSMessageDetails      :

    Exception             : System.Management.Automation.RuntimeException: AxDB - a previous incomplete deployment was identified. The channel database deployment will not continue to prevent corruption of the database. If you see this message during a retry, please check the previous retry logs for the original error message. To ignore this check and force retry (please make sure you know the implications), execute the following script against the database and retry: DROP VIEW __RETAIL_PENDING_DEPLOYMENT;

    TargetObject          : AxDB - a previous incomplete deployment was identified. The channel database deployment will not continue to prevent corruption of the database. If you see this message during a retry, please check the previous retry logs for the original error message. To ignore this check and force retry (please make sure you know the implications), execute the following script against the database and retry: DROP VIEW __RETAIL_PENDING_DEPLOYMENT;

    CategoryInfo          : OperationStopped: (AxDB - a previo...ING_DEPLOYMENT;:String) [], RuntimeException

    FullyQualifiedErrorId : AxDB - a previous incomplete deployment was identified. The channel database deployment will not continue to prevent corruption of the database. If you see this message during a retry, please check the previous retry logs for the original error message. To ignore this check and force retry (please make sure you know the implications), execute the following script against the database and retry: DROP VIEW __RETAIL_PENDING_DEPLOYMENT;

    ErrorDetails          :

    InvocationInfo        : System.Management.Automation.InvocationInfo

    ScriptStackTrace      : at Deploy-Database, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\Common-Database.ps1: line 855

                           at Deploy-DatabaseConfiguration, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\Common-Database.ps1: line 1049

                           at <ScriptBlock>, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\Deploy-Databases.ps1: line 45

                           at <ScriptBlock>, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 78

                           at Invoke-ScriptBlock, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\Common-Configuration.ps1: line 2068

                           at Invoke-Script, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\Common-Configuration.ps1: line 2099

                           at Run-DatabaseUpgrade, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 76

                           at Upgrade-RetailChannelDatabase, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 228

                           at <ScriptBlock>, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 272

                           at <ScriptBlock>, <No file>: line 3

                           at <ScriptBlock>, <No file>: line 1

    PipelineIterationInfo : {}

    9/26/2022 4:13:15 AM: AxDB - Deployment for 'AxDB' finished with errors.

    9/26/2022 4:13:15 AM: ############### Error occurred: ###############

    9/26/2022 4:13:15 AM: Database upgrade FAILED for the following databases: AxDB. You may find more logs under: C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailChannelDatabaseLogs\2022-09-26_04-12-57

    9/26/2022 4:13:15 AM: ############### Error occurred: ###############

    9/26/2022 4:13:15 AM:

    PSMessageDetails      :

    Exception             : System.Management.Automation.RuntimeException: Database upgrade FAILED for the following

                           databases: AxDB. You may find more logs under: C:\Temp\FinanceAndOperations_10.0.1326.46_Applic

                           ation\RetailChannelDatabaseLogs\2022-09-26_04-12-57

    TargetObject          : Database upgrade FAILED for the following databases: AxDB. You may find more logs under: C:\Tem

                           p\FinanceAndOperations_10.0.1326.46_Application\RetailChannelDatabaseLogs\2022-09-26_04-12-57

    CategoryInfo          : OperationStopped: (Database upgrad...-09-26_04-12-57:String) [], RuntimeException

    FullyQualifiedErrorId : Database upgrade FAILED for the following databases: AxDB. You may find more logs under: C:\Tem

                           p\FinanceAndOperations_10.0.1326.46_Application\RetailChannelDatabaseLogs\2022-09-26_04-12-57

    ErrorDetails          :

    InvocationInfo        : System.Management.Automation.InvocationInfo

    ScriptStackTrace      : at Throw-Error, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\Comm

                           on-Configuration.ps1: line 1494

                           at Deploy-DatabaseConfiguration, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailSe

                           rver\Scripts\Common-Database.ps1: line 1132

                           at <ScriptBlock>, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\De

                           ploy-Databases.ps1: line 45

                           at <ScriptBlock>, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Up

                           grade\Core\UpdateRetailChannelDatabase.ps1: line 78

                           at Invoke-ScriptBlock, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scrip

                           ts\Upgrade\Core\Common-Configuration.ps1: line 2068

                           at Invoke-Script, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Up

                           grade\Core\Common-Configuration.ps1: line 2099

                           at Run-DatabaseUpgrade, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scri

                           pts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 76

                           at Upgrade-RetailChannelDatabase, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailS

                           erver\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 228

                           at <ScriptBlock>, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Up

                           grade\Core\UpdateRetailChannelDatabase.ps1: line 272

                           at <ScriptBlock>, <No file>: line 3

                           at <ScriptBlock>, <No file>: line 1

    PipelineIterationInfo : {}

    Executed:

    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\Deploy-Databases.ps1

    Parameter: TopologyXmlFilePath Value: C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\channeldb-topology-cloud.xml

    Parameter: SettingsXmlFilePath Value: C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\Scripts\channeldb-settings-updated.xml

    Parameter: Credentials Value: System.Management.Automation.PSCredential[]

    Parameter: Verbose Value: True

    Parameter: DeploymentType Value: ChannelDB

    Exiting with error code 2.

    9/26/2022 4:13:16 AM: ############### Error occurred: ###############

    9/26/2022 4:13:16 AM:

    PSMessageDetails      :

    Exception             : System.Management.Automation.RuntimeException: Scriptblock exited with error code 2.

    TargetObject          : Scriptblock exited with error code 2.

    CategoryInfo          : OperationStopped: (Scriptblock exited with error code 2.:String) [], RuntimeException

    FullyQualifiedErrorId : Scriptblock exited with error code 2.

    ErrorDetails          :

    InvocationInfo        : System.Management.Automation.InvocationInfo

    ScriptStackTrace      : at Invoke-ScriptBlock, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scrip

                           ts\Upgrade\Core\Common-Configuration.ps1: line 2085

                           at Invoke-Script, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Up

                           grade\Core\Common-Configuration.ps1: line 2099

                           at Run-DatabaseUpgrade, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scri

                           pts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 76

                           at Upgrade-RetailChannelDatabase, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailS

                           erver\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 228

                           at <ScriptBlock>, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Up

                           grade\Core\UpdateRetailChannelDatabase.ps1: line 272

                           at <ScriptBlock>, <No file>: line 3

                           at <ScriptBlock>, <No file>: line 1

    PipelineIterationInfo : {}

    Executed:

    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1

    Exiting with error code .

    9/26/2022 4:13:16 AM:     - Trying to get information of the website - AOSService ...

    Skipping setting 'CertificateHandler.DataEncryptionKey' as it is not in the config file.

    Skipping setting 'CertificateHandler.DataEncryptionIV' as it is not in the config file.

    Skipping setting 'AzureStorage.StorageConnectionString' as it is not in the config file.

    Skipping setting 'Aos.AxPackageStorage' as it is not in the config file.

    Skipping setting 'BiReporting.DWPwd' as it is not in the config file.

    Skipping setting 'BiReporting.DWRuntimePwd' as it is not in the config file.

    Skipping setting 'PowerBIEmbedded.AccessKey' as it is not in the config file.

    Skipping setting 'PowerBIEmbedded.AccessKey2' as it is not in the config file.

    Skipping setting 'PowerBIEmbedded.V2AppAccessKey' as it is not in the config file.

    try{

                                                        $erroractionpreference = 'stop';

                                                        & 'C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailSer

    ver\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1'

                                                    }

                                                    catch

                                                    {

                                                        $erroractionpreference = 'Continue';

                                                        Write-Error ($_ | Format-List * -Force | Out-String -Width 4096);

                                                        [Environment]::Exit(999)

                                                    }  :

    PSMessageDetails      :

    Exception             : System.Management.Automation.RuntimeException:

                           PSMessageDetails      :

                           Exception             : System.Management.Automation.RuntimeException: Scriptblock exited with

    error code 2.

                           TargetObject          : Scriptblock exited with error code 2.

                           CategoryInfo          : OperationStopped: (Scriptblock exited with error code 2.:String) [],

    RuntimeException

                           FullyQualifiedErrorId : Scriptblock exited with error code 2.

                           ErrorDetails          :

                           InvocationInfo        : System.Management.Automation.InvocationInfo

                           ScriptStackTrace      : at Invoke-ScriptBlock,

    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scrip

                                                   ts\Upgrade\Core\Common-Configuration.ps1: line 2085

                                                   at Invoke-Script,

    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Up

                                                   grade\Core\Common-Configuration.ps1: line 2099

                                                   at Run-DatabaseUpgrade,

    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scri

                                                   pts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 76

                                                   at Upgrade-RetailChannelDatabase,

    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailS

                                                   erver\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 228

                                                   at <ScriptBlock>,

    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Up

                                                   grade\Core\UpdateRetailChannelDatabase.ps1: line 272

                                                   at <ScriptBlock>, <No file>: line 3

                                                   at <ScriptBlock>, <No file>: line 1

                           PipelineIterationInfo : {}

    TargetObject          :

                           PSMessageDetails      :

                           Exception             : System.Management.Automation.RuntimeException: Scriptblock exited with

    error code 2.

                           TargetObject          : Scriptblock exited with error code 2.

                           CategoryInfo          : OperationStopped: (Scriptblock exited with error code 2.:String) [],

    RuntimeException

                           FullyQualifiedErrorId : Scriptblock exited with error code 2.

                           ErrorDetails          :

                           InvocationInfo        : System.Management.Automation.InvocationInfo

                           ScriptStackTrace      : at Invoke-ScriptBlock,

    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scrip

                                                   ts\Upgrade\Core\Common-Configuration.ps1: line 2085

                                                   at Invoke-Script,

    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Up

                                                   grade\Core\Common-Configuration.ps1: line 2099

                                                   at Run-DatabaseUpgrade,

    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scri

                                                   pts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 76

                                                   at Upgrade-RetailChannelDatabase,

    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailS

                                                   erver\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 228

                                                   at <ScriptBlock>,

    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Up

                                                   grade\Core\UpdateRetailChannelDatabase.ps1: line 272

                                                   at <ScriptBlock>, <No file>: line 3

                                                   at <ScriptBlock>, <No file>: line 1

                           PipelineIterationInfo : {}

    CategoryInfo          : OperationStopped: (

                           PSMessageDe...fo : {}

                           :String) [], RuntimeException

    FullyQualifiedErrorId :

                           PSMessageDetails      :

                           Exception             : System.Management.Automation.RuntimeException: Scriptblock exited with

    error code 2.

                           TargetObject          : Scriptblock exited with error code 2.

                           CategoryInfo          : OperationStopped: (Scriptblock exited with error code 2.:String) [],

    RuntimeException

                           FullyQualifiedErrorId : Scriptblock exited with error code 2.

                           ErrorDetails          :

                           InvocationInfo        : System.Management.Automation.InvocationInfo

                           ScriptStackTrace      : at Invoke-ScriptBlock,

    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scrip

                                                   ts\Upgrade\Core\Common-Configuration.ps1: line 2085

                                                   at Invoke-Script,

    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Up

                                                   grade\Core\Common-Configuration.ps1: line 2099

                                                   at Run-DatabaseUpgrade,

    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scri

                                                   pts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 76

                                                   at Upgrade-RetailChannelDatabase,

    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailS

                                                   erver\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1: line 228

                                                   at <ScriptBlock>,

    C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Up

                                                   grade\Core\UpdateRetailChannelDatabase.ps1: line 272

                                                   at <ScriptBlock>, <No file>: line 3

                                                   at <ScriptBlock>, <No file>: line 1

                           PipelineIterationInfo : {}

    ErrorDetails          :

    InvocationInfo        : System.Management.Automation.InvocationInfo

    ScriptStackTrace      : at <ScriptBlock>, C:\Temp\FinanceAndOperations_10.0.1326.46_Application\RetailServer\scripts\Up

    grade\Core\UpdateRetailChannelDatabase.ps1: line 291

                           at <ScriptBlock>, <No file>: line 3

                           at <ScriptBlock>, <No file>: line 1

    PipelineIterationInfo : {}

    At line:1 char:1

    + &{ try{

    + ~~~~~~~

       + CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorException

       + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException

    Please let me know if I got you correctly and pasted the right error. Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,759 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,468 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans