Error: An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'AppealPerformance'. (rsErrorExecutingCommand) Conversion failed when converting the varchar value 'The next installment ID cannot

Users receive error: An error has occurred during report processing. (rsProcessingAborted)
        Query execution failed for dataset 'AppealPerformance'. (rsErrorExecutingCommand)
            Conversion failed when converting the varchar value 'The next installment ID cannot be returned because the record has not been created in the database yet. The calling code needs to call USP_RECURRINGGIFT_ADDMISSINGINSTALLMENTS to add them. (Ignore the datatype conversion error.)' to data type int.” is shown when running the Appeal Performance Report.  
We're currently evaluating this issue for a fix in a future patch or service pack.  

Steps to Duplicate

1.    Go to Marketing & Communications
2.    Select Appeal performance report 
3.    Select Report code 15-VIETNAM_RESCUE
4.    Select View Report
5.    receive error: An error has occurred during report processing. (rsProcessingAborted)
        Query execution failed for dataset 'AppealPerformance'. (rsErrorExecutingCommand)
            Conversion failed when converting the varchar value 'The next installment ID cannot be returned because the record has not been created in the database yet. The calling code needs to call USP_RECURRINGGIFT_ADDMISSINGINSTALLMENTS to add them. (Ignore the datatype conversion error.)' to data type int.” is shown.

Environment

 Blackbaud CRM
 4.0
 4.0.141.0

Was this article helpful?