Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Error message in Posit...
Finance forum
Suggested answer

Error message in Position Duration

Posted on by 168
Hi,
 
I am updating 'Activation' and 'Retirement' in Position Duration.
All position IDs are unique right now.
 
However, I got the error message: Cannot create a record in Position durations (HcmPositionDuration). Insert not supported with the values specified for 'Activation' and 'Retirement'. New record overlaps with multiple existing records.
 
In some records, I got another error message: Cannot create a record in Position durations (HcmPositionDuration). Invalid value specified for 'Retirement'. It cannot be greater than or equal to the 'Retirement' of the first record.
 
Has anyone know the cause?
Categories:
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,989 Super User on at
    Error message in Position Duration
    Hi STP,
     
    Can you try using only the entity Positions (HcmPositionEntity)? 
  • STP Profile Picture
    STP 168 on at
    Error message in Position Duration
    @Andre,
    Import sequence was 'Base position' > 'Position detail' > 'Position duration'.
    I got these error message when I imported 'Position duration'.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,989 Super User on at
    Error message in Position Duration
    Thanks for your reply, STP.
     
    Do you get this error when inserting records where no positions were loaded? Or do you have an issue when updating records (the second time importing a sheet containing changes)?
  • STP Profile Picture
    STP 168 on at
    Error message in Position Duration
    @Andre, I am working on the data migration. I used Data management to upload 'Position Duration'.
     
    @Kevin, I am not a developer, I used Data management to upload 'Position Duration'. I checked the data through data browser.
    All records have ValidFrom and ValidTo, however, the system interface doesn't show the date.
    e.g. P-000019 has ValidFrom and ValidTo, however, the user interface doesn't show 'Activation' and 'Retirement'.
  • Suggested answer
    Waed Ayyad Profile Picture
    Waed Ayyad 3,802 on at
    Error message in Position Duration
    Hi,
     
    This table is valid time state table and you should know to update it, you should specify the ValidTimeStateUpdate value, and also make sure that you don't break the key on the table.
     
    You can read more about it on the below links:
     
    I would recommend that you use the same code of the Activation and retirement buttons from position form on your code.
     
    Thanks,
    Waed Ayyad
    If this helped, please mark it as "Verified" for others facing the same issue
     
  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Error message in Position Duration
    Hi,
    Similar problems have been raised before on the forum and solutions have been found, you can refer to these two old threads:
    Best regards,
    Kevin
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,989 Super User on at
    Error message in Position Duration
    Hi STP,
     
    Can you tell us how you are trying to update these position details? Are you importing records, do you have a custom X++ script, or some other method?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans