Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Data entity returns 1 empty field (only in PROD)

(0) ShareShare
ReportReport
Posted on by 23

Hi All,

I have a very vague issue. Created a couple of data entities for an integration. All these entities work fine in my DEV box, in TEST and in ACC. Tested with Boomi and with Postman.

Two of the entities have problems in PROD. In one entity one field is always empty (a date field). In another entity two fields are always empty (an INT64 and a String). All data is returned correctly except for these 3 always empty fields. All three fields are populated in the postLoad method of the entity (unmapped fields). 

I already changed some small things on the entities and pushed them again to PROD, but this did not help. And I cannot think of anything that could be causing this. 

Has anyone experienced this ? Any solution ?

I'm now creating a V2 version which will be available in PROD tomorrow. I will post an update when I've tested these V2 versions.

Thanks !

Gerard

  • g.verbruggen Profile Picture
    g.verbruggen 23 on at
    RE: Data entity returns 1 empty field (only in PROD)

    Hi Martin and Bharani,

    It's been a struggle, but it's fixed. At least for one of the two data entities. I will do the same with the other one and I'm sure it will work as well.

    @Bharani: Fields are not read only. Same properties as all other fields on the entity.

    @Martin: I was talking about the Regenerate mapping in data management. I know this should not matter, but when something is not working, you try everything :)

    I see I forgot to mention this in my first post: When I export the data entities in data management in Dynamics, the fields were populated (also in PROD).

    I did two things this morning:

    Made a copy of one of the entities (new name, new Staging table).

    Re-created one of the entities from scratch

    I moved these changes to TEST/ACC/PROD.

    The copy entity still had the same problems in PROD (and not in DEV/TEST/ACC)

    The newly created entity however was 100% OK.

    I compared the entities, and except for a different field order, they are exactly the same..... So I still have no idea what is going on here. Specially because it was only an issue in PROD. But it's solved and that's the main thing.

    Thanks for your time and attention !!

    Cheers,

    Gerard

  • Martin Dráb Profile Picture
    Martin Dráb 230,836 Most Valuable Professional on at
    RE: Data entity returns 1 empty field (only in PROD)

    I don't know what exactly you mean when saying that you updating mappings, but I would go and take a look at both mappings to see whether the field is mapped there or not.

  • Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,587 Super User 2024 Season 1 on at
    RE: Data entity returns 1 empty field (only in PROD)

    So if the fields are populating at postload, then have you checked at the table how these fields are there? Are they editable?

    Also how is the read-only property for the ds of these fields?

  • g.verbruggen Profile Picture
    g.verbruggen 23 on at
    RE: Data entity returns 1 empty field (only in PROD)

    Hi Martin,

    Thanks, but I updated the mappings as well ( 350 times I think ;o))

    I will let you know the results of V2 by tomorrow.

    Cheers,

    Gerard

  • Martin Dráb Profile Picture
    Martin Dráb 230,836 Most Valuable Professional on at
    RE: Data entity returns 1 empty field (only in PROD)

    If both the entity definition and data is correct, the field mapping may be to blame.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans