Error: Column names in each table must be unique. Column name 'VALUE' in table '@RETURNTABLE' is specified more than once.

After adding two or more Smart Fields to an Ad-Hoc query, attempting to save it as a Smart Query produces the following error:
Error loading spec 'XXXXX'.  Column names in each table must be unique. Column name 'VALUE' in table '@RETURNTABLE' is specified more than once.

Where XXXXX is the name that you specified for the Smart Query you tried to save.
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.

Workaround:

1. Edit the smart field which is mentioned in the error message
2. Add characters or digits to the beginning of the name of the Smart Field
3. Return to the Smart Query
4. Remove the Smart Fields in the Query
5. Add them back to the Smart Query
6. Save

 

Environment

 Blackbaud CRM
 2.9
 3.0
 Service Pack 10

Was this article helpful?