Data entity returns 1 empty field (only in PROD)

(0) Share

Report

Posted on by g.verbruggen

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)

All responses (5)

Answers (0)

Martin Dráb 237,965 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No
g.verbruggen 23 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

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?

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

Like (0)

Report

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.

Was this reply helpful? Yes No
g.verbruggen 23 on at

Like (0)

Report

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

Was this reply helpful? Yes No

Join the conversation

Community site session details

Data entity returns 1 empty field (only in PROD)

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Data entity returns 1 empty field (only in PROD)

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates