Error: Error loading spec 'test'. Invalid OutputField element. There is no field with the name 'NAMINGOPPORTUNITYRECOGNITIONSCONSTITUENTNAMIN' in the table-valued function

When trying to create a Smart Query from an Ad-hoc Query and pulling an output field from under Naming Opportunity Recognitions, Constituent, Naming Opportunity Recognitions, Associated Revenue, a user may receive Error: Error: Error loading spec 'test'.  Invalid <OutputField> element. There is no field with the name 'NAMINGOPPORTUNITYRECOGNITIONSCONSTITUENTNAMIN' in the table-valued function 'UFN_SMARTQUERY_ADHOCQUERY_026E2DA2_A932_4C83_9BF7_5250CEE20029'
Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Environment

 2.9.1001.78
 2.91.1535, patch 46

Was this article helpful?