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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Service update 10.0.29...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Service update 10.0.29 fails in the 'GlobalUpdate script for service model: RetailServer on machine' step

(0) ShareShare
ReportReport
Posted on by Suren_G 252

Hi All,

I am trying to upgrade the D365FO environment from service update 10.0.28 to 10.0.29 through the LCS. The upgrade process gets failed in the 'GlobalUpdate script for service model: RetailServer on machine' step. I also followed the steps to execute the 'DropAllRetailChannelDbObjects.sql' and also did a full DB sync. But the issue still exist. Please let me know if there is any work around for this error. Please find the error log below

pastedimage1666096980561v2.png

Thanks!

I have the same question (0)
  • Suggested answer
    udaY-ch Profile Picture
    udaY-ch 5,173 on at

    Hi

    If retail is not being used, empty the script "UpdateRetailChannelDatabase.ps1" and retry the steps and it will succeed.

    Else, please log a ticket with Microsoft.

    /Uday

  • Suggested answer
    bass99 Profile Picture
    bass99 10 on at

    Hi,

    If the error is still relevant after executing the 'DropAllRetailChannelDbObjects.sql', I would suggest to navigate to the following folder:

    Documents\RetailChannelDatabaseLogs\YYYY-MM-DD_hh-mm-ss\AxDB

    pastedimage1668720710531v1.png

    Then grab the sql script named CommerceRuntimeScripts_9.28.21084.13_9.32.21271.2.sql and open it on SSMS.

    After executing that script, the following error will be displayed:

    Msg 155, Level 15, State 1, Line 42
    'OPTIMIZE_FOR_SEQUENTIAL_KEY' is not a recognized ALTER TABLE option.

    It means that keyword ('OPTIMIZE_FOR_SEQUENTIAL_KEY') is not compatible with the current version of the SQL server.

    So as solution, remove that keyword from the sql script and save it.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 531

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 402 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 257 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans