the field 'xxx' refers to a nonexistent table or view yyyy Build Error in Visual Studio

(0) Share

Report

Posted on by Community Member

This build error started happening in VS2015 despite no modifications in anything to do with the view or table or fields referenced:

Error Path: [dynamics://View/VendInvoiceTotalFromAccountingDistributionView]:On view 'VendInvoiceTotalFromAccountingDistributionView', the field 'InvoiceTotal' refers to a nonexistent table or view named 'AccountingDistribution'.

I found two articles that mention similar errors occurring, possibly just from viewing a table or view.

As suggested in the articles, I have tried many things from the Dynamics 365 menu, including Synchronize database, Build models... and Model Management / Update model parameters, all to no avail. Most of the operations I tried are very lengthy, so any help in pinpointing a solution is greatly appreciated.

Categories:

Development / Customization / SDK

All responses (11)

Answers (0)

Suggested answer

Azeem chisty 25 on at

Like (0)

Report

RE: the field 'xxx' refers to a nonexistent table or view yyyy Build Error in Visual Studio

I tried this suggested answer and found that the error giving entity was used in extension entity as data entity view and related references was not selected for extension model. Once I assigned the reference model it is solved.
Community Member on at

Like (0)

Report

RE: the field 'xxx' refers to a nonexistent table or view yyyy Build Error in Visual Studio

I have started over with a new model in the ISV layer and so I am able to build without errors. Not sure where the original went wrong, but at least I am moving forward. Thank you for the help.
Mea_ 60,278 on at

Like (0)

Report

RE: the field 'xxx' refers to a nonexistent table or view yyyy Build Error in Visual Studio

Update model is exactly what I mean, but, you should not update neither 'Application Suite' nor 'SourceDocumentation'. These 2 are standard models and you cannot add new objects to them. You should have your own model, you need to update it to add missing reference.
Community Member on at

Like (0)

Report

RE: the field 'xxx' refers to a nonexistent table or view yyyy Build Error in Visual Studio

Thanks Ievgen. Although I have been using C# in Visual Studio for over a decade, I am new to the specifics of the D365 FO development extensions.

I do not know how to 'modify your model descriptor'. I have done 'Update model parameters...' for both 'Application Suite' and 'SourceDocumentation' if that is what you mean.
Community Member on at

Like (0)

Report

RE: the field 'xxx' refers to a nonexistent table or view yyyy Build Error in Visual Studio

I did the same steps for 'SourceDocumentation' as I detailed previously for 'Application Suite', but still getting the error.

I even started a brand new project, with no modifications at all, and the error is still there.
Mea_ 60,278 on at

Like (0)

Report

RE: the field 'xxx' refers to a nonexistent table or view yyyy Build Error in Visual Studio

Hi Jeff Sager,

As Brandon mentioned, you probably extended that view. Now your extension is not aware of some objects used by the view. You need to update your model and add references to these models. Check model of "AccountingDistribution" and modify your model descriptor to include a reference to that model.
Suggested answer

BrandonSA 1,673 on at

Like (0)

Report

RE: the field 'xxx' refers to a nonexistent table or view yyyy Build Error in Visual Studio

Hi Jeff

I just had a look at that view. The AccountingDistribution table is in the Source Documentation model. Does your model reference that model? Do you have extensions on this view?

You might have to include the Source Documentation model in your model's references.
Community Member on at

Like (0)

Report

RE: the field 'xxx' refers to a nonexistent table or view yyyy Build Error in Visual Studio
BrandonSA 1,673 on at

Like (0)

Report

RE: the field 'xxx' refers to a nonexistent table or view yyyy Build Error in Visual Studio

Hi Jeff

Do you think you could share a picture of the code and error message?
Community Member on at

Like (0)

Report

RE: the field 'xxx' refers to a nonexistent table or view yyyy Build Error in Visual Studio

Brandon,

Thank you for the very quick reply, I have spent two days on this...

I have tried your suggestion a couple of times, but perhaps I am misunderstanding the exact steps.

This is what I have tried:

From the VS menus, Dynamics 365 / Model Management / Update model parameters...,

For Model name: selected 'Application Suite'

Clicked Next

Selected every choice in Packages [Models]

Clicked Next

Clicked Finish

Still getting the error after building.

I must be missing something!