Good day everyone,
I am facing a strange problem in Dynamics where I can use some help.
We created a customization to add the RetailVariantId column to the InventWarehouseOnHandV2Entity data entity. In order to do this, we created extensions to add the field to
- InventSumByWarehouse view
- InventOnHandByWarehouse view
- InventWarehouseOnHandView view
- InventWarehouseOnHandAggregatedView view
- InventWarehouseOnHandV2Entity data entity
- InventWarehouseOnHandV2Staging table
On my local development onebox VM this works fine. However, on our sandbox cloud environment we get an SQL error when trying to export the DMF project:
"Error adding updating OLEDB source properties-Exception from HRESULT: 0xC0202009"
To debug this issue, I looked at the SQL database on the sandbox server. When looking at the views, I noticed that our new field is correctly added to the first 3 views, but the field is not added to the InventWarehouseOnHandAggregatedView view. I have checked and verified that the extension is merged to the correct branch for the sandbox server.
I am not entirely sure yet, but I suspect that this could be the source of the SQL error.
Has anyone seen anything like this before? That a view extension is not properly synchronized to the database? Can I do anything to debug or fix this issue?
