Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Service update deploym...
Finance | Project Operations, Human Resources, ...
Answered

Service update deployment of Dynamics 365 Finance V10.0.39 fails

(1) ShareShare
ReportReport
Posted on by Celeste 263
Service update deployment of Dynamics 365 Finance V10.0.39 fails
We are trying to deploy the Service update V10.0.39 to a Sandbox environment.  It initially failed due to license algorithm changes that was required by an ISV.  Code changes was deployed successfully to the environment, but the update is still failing.
 
The service update package that we’re deploying, was saved from the Available updates section under the sandbox environment in LCS, and uploaded to Asset Library.  The build version is build 10.0.1860.68

Downloading the error logs, the following SqlException is thrown:
There is already an object named 'LICENSING_POPULATEROLEPRIVILEGELICENSEMAPV2' in the database.

Any assistance will be appreciated greatly.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,684 Super User 2024 Season 2 on at
    Service update deployment of Dynamics 365 Finance V10.0.39 fails
    @Nick,

    In case there are issues with an update deployment on a production environment, you would need to create a ticket for Microsoft Support. Microsoft is indeed handling this type of issue as there is no direct access to the service.
  • Nick Jordy Profile Picture
    Nick Jordy 9 on at
    Service update deployment of Dynamics 365 Finance V10.0.39 fails
    How would you do the Drop Procedure on a tier 3 Production environment (cloud deployment)? Would that need to be handled by Microsoft?
  • Verified answer
    Celeste Profile Picture
    Celeste 263 on at
    Service update deployment of Dynamics 365 Finance V10.0.39 fails
    The issue has been resolved, there were two things that we needed to do:
     
    1: ISV license issue:
    Confirm with all ISVs if latest versions should be deployed (if the ISV is used the SHA1 algorithm for generating licenses).
    In our case, I redeployed Dynaway modules as well as license.
    Create a new deployable package with the re-deployment and deploy to the environment before attempting the upgrade.
     
    2:  If the upgrade fails with an issue with procedure [DBO].[LICENSING_POPULATEROLEPRIVILEGELICENSEMAPV2], perform these steps:
    1. Create a Just in Time session on the environment and login to the Microsoft SQL database
    2. Expand the AxDB under Databases
    3. Under stored procedures, right click on object [DBO].[LICENSING_POPULATEROLEPRIVILEGELICENSEMAPV2]
    4. Script to new query window and save query (to have a backup)
    5. Click on Create new query and select database AxDB
    6. Run this script:
    7. DROP PROCEDURE IF EXISTS LICENSING_POPULATEROLEPRIVILEGELICENSEMAPV2
    8. GO
    9. Exit Microsoft SQL
     
    Then Upgrade environment.
  • Anthony Blake Profile Picture
    Anthony Blake 2,201 Super User 2024 Season 2 on at
    Service update deployment of Dynamics 365 Finance V10.0.39 fails
  • Judy Profile Picture
    Judy Microsoft Employee on at
    Service update deployment of Dynamics 365 Finance V10.0.39 fails
    Hi, for the error messages, maybe you can try to delete the existing object 'LICENSING_POPULATEROLEPRIVILEGELICENSEMAPV2' from the database after you have backed it up.
    Then you can retry the service update deployment to see if it can help.
    Hope other experts can suggest on this.
     
    Best Regards,
    Judy

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,684 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,414 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans