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.