Conversion failed when converting from a character string to uniqueidentifier when viewing the results of a constituent query based on the data warehouse

We get an error when querying an attribute and using the count function for revenue in a constituent query based on the data warehouse.
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. 

Steps to Duplicate

1.  Select Information library from the analysis functional area
2.  Select BBtest 13022839 and click edit definition
3.  View the results

Environment

 Blackbaud CRM
 4.0
 4.0
 Service Pack 9

Was this article helpful?