Finance | Project Operations, Human Resources, ...

Data Entity Staging table not updated in Entity list

(0) Share

Report

Posted on by Community Member

Hi,

I modified my Data Entity, by adding field on it. And Update Staging afterward. In my AOT I can see the new fields. Build and Synchronize.

Inside D365, go to Data Management - setting - Refresh Data Entity.

But it looks the staging table not being updated. In Data entity structure already saw my new fields. only at Structure and take a look at the mapping, I can see in the staging table didn't have my new fields.

Any advice how to update it.

Thanks

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Blue Wang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Wong,

About add new field to entity,please refer this link, you also need to add field to your staging table.

https://allaboutmsdynamics.wordpress.com/2019/02/13/d365-ax7-data-entityadd-a-new-custom-field-in-standard-or-base-data-entity/

Then Try to regenerate the data mapping of the data entity.

Please follow this blog: community.dynamics.com/.../new-column-is-not-showing-in-data-entity-ax7-amp-d365

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Yes, I did this, but no luck

Was this reply helpful? Yes No
Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

Hi WWwong,

1. Try to double-check if you have field added to entity and to correct staging table (same as mentioned in entity property).

2. Check if field is not disabled by configuration key

3. Field is marked as visible on staging table.

4. Fieid is marked as public on entity level

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,

1. yes, I confirmed the name is correct.

2. there is no configuration key applied

3. fields is visible

4. in the entity it self ? do you meant AccessModifier property ? yes it is Public, not internal

Thanks

Was this reply helpful? Yes No
Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

Hi WWwong,

In this case, try to re-build the solution and sync DB again. Check that you don't have any errors during the build or sync (maybe even full sync). And try to regenerate mapping again as Blue Wang mentioned.

By the way, you mentioned

"But it looks the staging table not being updated. In Data entity structure already saw my new fields. only at Structure and take a look at the mapping, I can see in the staging table didn't have my new fields."

Do you mean that you see field in mapping form for source part, but not for target?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Sergei,

No, I meant in the Data Entity list, in Modify Target Mapping button, over there are the field list including Staging field and Target field, right? the new fields not listed. And if I go to Mapping visualization, in the Target I saw my new fields, but no new fields in Staging field visualization.

Thanks,

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,046 on at

Like (0)

Report
Copy link

Link copied!

Modify/regenerating target mapping should work, alternatively could delete the entity from list and then add manually and suggest

Was this reply helpful? Yes No
Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

Hi WWwong,

So you see new fields in Data entity list -> "Modify target mapping", but you don't see them in data project? In this case you just need to re-add entity to data project.

Was this reply helpful? Yes No
Blue Wang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Wong,

How do you add field into entities or staing table? Add new field manually to each of them?

It didn't update when I tried to do this.

-

You need to add field to the data source table first, and then drag and drop new field into the entity fields and the staging table.

Build and Sync.

Refresh Data Entity.

Modify target mapping.

Was this reply helpful? Yes No