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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Data entity returns 1 ...
Finance | Project Operations, Human Resources, ...
Unanswered

Data entity returns 1 empty field (only in PROD)

(0) ShareShare
ReportReport
Posted on by g.verbruggen 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

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 236,802 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.

  • 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

  • Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,634 Moderator 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?

  • Martin Dráb Profile Picture
    Martin Dráb 236,802 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.

  • 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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 765 Super User 2025 Season 2

#2
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 743

#3
Sumit Singh Profile Picture

Sumit Singh 551

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans