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 forum / GlobalUpdate script fo...
Finance forum

GlobalUpdate script for service model: AOSService on machine: Dev

(0) ShareShare
ReportReport
Posted on by MUhammdYasirDaVinci 90

Hi all,

While updating my machine platform from 21 to 24 (application version 8). I get following error on step 19:

GlobalUpdate script for service model: AOSService on machine: Dev

Moving forward when I see the log the step 19 log it gives error on three standard tables BIConfiguration, FormRunConfiguration and SysClientPerf. The error is as following:

Table Sync Failed for Table: BIConfiguration. Exception: System.InvalidOperationException: Database execution failed: Violation of PRIMARY KEY constraint 'I_65518FIELD'. Cannot insert duplicate key in object 'dbo.SQLDICTIONARY'. The duplicate key value is (4451, 29, 1, 0).

The same error has logged for FormRunConfiguration and SysClientPerf. 

What can be done to clear this issue? Should I delete these table data or table+schema from Sql (after taking backup)? or is there any workaround to get rid of these errors?

Please help with your experience. Thank you.

Categories:
Upgrade
Continuous Updates
Implementation Lifecycle
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 307,166 Super User 2026 Season 2 on at

    Hi,

    Have you tried to rerun the step? Sometimes this helps. Is there any reason to go for PU24 instead of the latest available? You can also try the latest available PU.

  • MUhammdYasirDaVinci Profile Picture
    MUhammdYasirDaVinci 90 on at

    Hi Andre,

    Thanks for reply. I resumed multiple times but it didn't help. Now I just aborted it and start again. We are refreshing our one environment database to Dev environment to reproduce a scenario there. The source environment is currently on PU24. We want everything on Dev as it is on source environment. That's why before refreshing data we are updating Dev to PU24.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 307,166 Super User 2026 Season 2 on at

    Hi MuhammdYasirDaVinci,

    The restart would also be an option. Please update the thread if you did or did not succeed with the update.

  • Verified answer
    MUhammdYasirDaVinci Profile Picture
    MUhammdYasirDaVinci 90 on at

    Hi Andre,

    It took me a while to check what really the problem was. After spending some time I found the solution to this problem. I wrote a detailed blog on it to help others.

    [View:https://microsoftdynamix.blogspot.com/2019/05/d365fo-platform-update-lcs-globalupdate.html:750:50]

    Thanks again.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 307,166 Super User 2026 Season 2 on at

    Thanks for your feedback. As moderator, I have verified your answer as you probably were not able to mark your own answer.

  • Rudi Hansen Profile Picture
    Rudi Hansen 4,079 on at

    Just wanted to add that I also got this error on an update 26, and I just opened Visual Studio and Synchronized the database, and got no errors.

    Then I just Retried the upgrade script, and it ran to completion.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans