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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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 189

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
I have the same question (0)
  • Suggested answer
    Fannie30 Profile Picture
    Fannie30 2,990 Moderator on at

    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.

  • Suggested answer
    Santosh bhagat Profile Picture
    Santosh bhagat 464 on at
    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.

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 > Field Service

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans