Finance | Project Operations, Human Resources, ...

Insert not supported with the values specified for 'Effective' and 'Expiration

(0) Share

Report

Posted on by DELDYN

484

What would cause such error?

Cannot create a record in Addresses (LogisticsPostalAddress). Insert not supported with the values specified for 'Effective' and 'Expiration'. New record overlaps with multiple existing records

I can't find the error in D365 labels..to look for references. How can i find it?

I have a custom service that updates or creates an address using logisitcsPostalAddressHistoricalCDSV2Entity

I have the same question (0)

All responses (9)

Answers (0)

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

Hi, There might be existing records in this effective and expiration period.

Was this reply helpful? Yes No
Martin Dráb 237,972 Most Valuable Professional on at

Like (0)

Report

It comes from kernel logic for date-effective tables.

You're trying to insert a record with invalid values. It it was allowed, it would cause having several addresses valid at the same time.

Was this reply helpful? Yes No
Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

Hi DELDYN,

Check the below blogs and thread which will help you to understand about the error.

https://www.anegis.com/articles/basics-of-working-with-date-effective-framework-in-ax-2012-p2

https://community.dynamics.com/ax/f/microsoft-dynamics-ax-forum/446934/cannot-create-a-record-in-addresses-logisticspostaladdress-insert-not-supported-with-the-values-specified-for-effective-and-expiration-new-record-overlaps-with-multiple-existing-records

Thanks,

Girish S.

Was this reply helpful? Yes No
DELDYN 484 on at

Like (0)

Report

Hi Martin,

I tried to reproduce by creating addresses that are valid at the same time, but I didn't get any error.

When then would such error appear?

Hi Girish,

Based on ur first link, i tried to add an address that is between an existing period but I didn't get an error as well

Was this reply helpful? Yes No
Martin Dráb 237,972 Most Valuable Professional on at

Like (0)

Report

Your screenshots show addresses for different locations.

Was this reply helpful? Yes No
DELDYN 484 on at

Like (0)

Report

Hi Martin,

If i try to insert record with same data or by changing street only for example, it's going to override it because logisticsPostalAddressHistorecalCDSV2Entity ValidTimeStateEnabled = no

But i tried to change validFrom so that it creates history, it worked so i still can't reproduce the error. can you please tell me the repro steps?

Was this reply helpful? Yes No
Martin Dráb 237,972 Most Valuable Professional on at

Like (0)

Report

Now you have the same location, but different period.

The unique index isn't violated because the records didn't have the same combination of Location and ValidFrom.

Was this reply helpful? Yes No
DELDYN 484 on at

Like (0)

Report

Hi martin,

But as i said, if location and validFrom are the same, then it will never create a new record and it will just update it(maybe it uses correction). As it the validTimeStateEnabled property for this entity is no.

So i tried multiple times but got no errors.

In order to create new records, validFrom needs to be different it seems

Was this reply helpful? Yes No
DELDYN 484 on at

Like (0)

Report

Any idea?

Was this reply helpful? Yes No