Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Trying to delete or ch...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Trying to delete or change a field which is causing a migration error

(0) ShareShare
ReportReport
Posted on by sutekh 15

Morning

I have a field in an entity called baselienduration and it's causing the error below when I try and migrate the solution over to a different environment.

cr1b0_WorkPackage.cr1b0_baselineduration
 
  You can't use cr1b0_baselinefinish, which is of type DateTime, with the current function.

i tried to delete the baselinefinish field but I get the below warning:

There are dependencies on this field that are preventing it from being deleted.

The calculation I have in basekineduration is: Set Baseline Duration to DiffInDays(Baseline Start, Baseline Finish)

Anyone had this issue before? How can I resolve it?

  • Linn Zaw Win Profile Picture
    Linn Zaw Win 3,405 on at
    RE: Trying to delete or change a field which is causing a migration error

    Please try and let me know if it solves your problem.

  • sutekh Profile Picture
    sutekh 15 on at
    RE: Trying to delete or change a field which is causing a migration error

    Thanks @Linn Zaw Winn that's really useful. 

  • Suggested answer
    Linn Zaw Win Profile Picture
    Linn Zaw Win 3,405 on at
    RE: Trying to delete or change a field which is causing a migration error

    Can you please check if the Baseline Start and Baseline Finish fields are both DateTime or is Baseline Start is Date Only?

    All DIFF functions require that the first Date and Time field and the second Date and Time field have the same behavior: User Local, Date Only or Time-Zone Independent.

    Ref: https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/define-calculated-fields#calculated-field-functions-syntax:~:text=All%20DIFF%20functions%20require%20that%20the,Time%20field%20have%20the%20same%20behavior

    If you want to recreate the field but having a dependency error, click on Show dependencies to see the list of components dependent on that field and try to remove the field from those components first.

    pastedimage1593006496167v1.png

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans