Error: Conversion failed when converting from a character string to uniqueidentifier. When using the sum function in a Data Warehouse ad-hoc query.

When creating a data warehouse ad-hoc query and displaying the SUM of an amount, error message occurs. Error: Conversion failed when converting from a character string to uniqueidentifier. 
We are currently evaluating this issue for a fix in a future service pack.

Steps to Duplicate

1. Click Analysis tab
2. Click Information Library
3. Create a Revenue (from the Blackbaud Data Warehouse) ad-hoc query
4. Results fields to display: 'SUM(Amount)'
5. See error message

Environment

 Blackbaud CRM
 4.0
 4.0.180

Was this article helpful?