Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Field Service forum / Field service upgrade ...
Field Service forum
Suggested answer

Field service upgrade is failed due to uninstallation of my existing version is failed , and i found reason.but i don't know what it try to say?

(0) ShareShare
ReportReport
Posted on by aakash chaudhari 175

The DELETE statement conflicted with the REFERENCE constraint "solution_roleprivileges". The conflict occurred in database "db_crmcorenam_20190628_12464304_022a", table "dbo.RolePrivilegesBase", column 'SolutionId'.
The statement has been terminated

Categories:
Scheduling (URS)
Presales and Invoicing
Other
Connected Field Service
Resource Scheduling Optimization
Web and mobile experience
Administration
Agreement
Documentation
Analysis and Integration
Inventory and Purchasing
Work Order
  • Suggested answer
    Santosh bhagat Profile Picture
    Santosh bhagat 464 on at
    Field service upgrade is failed due to uninstallation of my existing version is failed , and i found reason.but i don't know what it try to say?
    Use below fetch to know role name, replace solution id:
    <fetch>
      <entity name="privilege" >
        <attribute name="name" />
        <attribute name="privilegeid" />
        <filter>
          <condition attribute="ismanaged" operator="eq" value="1" />
        </filter>
        <link-entity name="roleprivileges" from="privilegeid" to="privilegeid" link-type="inner" >
          <attribute name="privilegeid" />
          <attribute name="roleid" />
          <attribute name="roleprivilegeid" />
          <filter>
            <condition attribute="solutionid" operator="eq" value="24525318-9941-4a2f-88f7-f7a6864dfe73" />
          </filter>
          <link-entity name="solution" from="solutionid" to="solutionid" >
            <attribute name="uniquename" />
          </link-entity>
        </link-entity>
      </entity>
    </fetch>
    Delete that security role from target environment.
    Reimport solution. Issue should resolved.
  • Suggested answer
    Fannie30 Profile Picture
    Fannie30 2,990 on at
    RE: Field service upgrade is failed due to uninstallation of my existing version is failed , and i found reason.but i don't know what it try to say?

    I would suggest logging a ticket with Microsoft Support.  I've not seen this one before and appears this is probably an issue support/engineering will need to resolve.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

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

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Community Spotlight for September 2024

Kudos to Mohana Yadav!

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,252 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,089 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans