Procedure or function 'USP_SIMPLEDATALIST_SPONSORSHIPREASON' expects parameter '@TYPE', which was not supplied.

When attempting to create a data list from a constituent Ad-hoc query the following error message is generated:

Duplicated in Sample: Procedure or function 'USP_SIMPLEDATALIST_SPONSORSHIPREASON' expects parameter '@TYPE', which was not supplied.
We’re currently evaluating this issue for a fix in a future service pack. 

Steps to Duplicate



1. Navigate to the Analysis functional area.
2. Click Information library.
3. Click the 'Add an Ad-hoc query' button.
4.  Add the following iteration path.
a. Status
b. Sponsorship opportunity\Child\Ineligible reason
5. Click the Create Data list button.
6. Select the filter by Sponsorship opportunity\Child\Ineligible reason checkbox.
7. Click Save.
8. Note the error message is generated.
 

Environment

 Blackbaud CRM
 4.0
 4.0.172

Was this article helpful?