web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

service update from 10.0.20 to 10.0.21 fails at step57 in dev machine.

(0) ShareShare
ReportReport
Posted on by 339

Hi Experts,

When I'm updating my dev vm from 10.0.20 to 10.0.21, it got failed at step 57.

Start executing runbook : 251
Executing step: 57
GlobalUpdate script for service model: RetailServer on machine: XYZ1
Update the Retail Channel database.
UpdateRetailChannelDatabase.ps1 failed.
try{
$erroractionpreference = 'stop';
&
'C:\FinanceAndOperations_10.0.960.43_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:\FinanceAndOperations_10.0.960.43_Application\RetailServer\scripts\Upgrade\Core\Common-Configuration.ps1: line 2085
at Invoke-Script,
C:\FinanceAndOperations_10.0.960.43_Application\RetailServer\scripts\Upgrade\Core\Common-Configuration.ps1: line 2099
at Run-DatabaseUpgrade,
C:\FinanceAndOperations_10.0.960.43_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1:
line 76
at Upgrade-RetailChannelDatabase,
C:\FinanceAndOperations_10.0.960.43_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1:
line 228
at <ScriptBlock>,
C:\FinanceAndOperations_10.0.960.43_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:\FinanceAndOperations_10.0.960.43_Application\RetailServer\scripts\Upgrade\Core\Common-Configuration.ps1: line 2085
at Invoke-Script,
C:\FinanceAndOperations_10.0.960.43_Application\RetailServer\scripts\Upgrade\Core\Common-Configuration.ps1: line 2099
at Run-DatabaseUpgrade,
C:\FinanceAndOperations_10.0.960.43_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1:
line 76
at Upgrade-RetailChannelDatabase,
C:\FinanceAndOperations_10.0.960.43_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1:
line 228
at <ScriptBlock>,
C:\FinanceAndOperations_10.0.960.43_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:\FinanceAndOperations_10.0.960.43_Application\RetailServer\scripts\Upgrade\Core\Common-Configuration.ps1: line 2085
at Invoke-Script,
C:\FinanceAndOperations_10.0.960.43_Application\RetailServer\scripts\Upgrade\Core\Common-Configuration.ps1: line 2099
at Run-DatabaseUpgrade,
C:\FinanceAndOperations_10.0.960.43_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1:
line 76
at Upgrade-RetailChannelDatabase,
C:\FinanceAndOperations_10.0.960.43_Application\RetailServer\scripts\Upgrade\Core\UpdateRetailChannelDatabase.ps1:
line 228
at <ScriptBlock>,
C:\FinanceAndOperations_10.0.960.43_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:\FinanceAndOperations_10.0.960.43_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

I don't want to delete the retail components. How can I fix this?

Thanks and regards,

Srihari.

I have the same question (0)
  • Suggested answer
    Suresh M. Parmar Profile Picture
    340 on at

    Hi Srihari Molaka,

    It's related the Retail Channel functionality

    Please refer to below link for the solution,

    Step 57: GlobalUpdate script for service model: RetailServer on machine

    Thanks,

    Suresh Parmar

    Please verify the answer if it satisfies your question. Doing so you'll help the community to identify valid answers.

  • Suggested answer
    mrajeshkumar Profile Picture
    on at

    Please review and perform the below workaround in order to fix the issue, Thanks.

    1. Drop all full text indexes on the table that was giving errors via SSMS
    2. Remove the retail deployment view to let me continue based off instructions in the logs
      1. DROP VIEW __RETAIL_PENDING_DEPLOYMENT
    3. Run the step 57 script manually in SSMS, which should upgrade the retail channel db
    4. Resume the upgrade

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 592 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 478 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 305 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans