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

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
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.

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans