Errors or incorrect Appeal information added when using Segment tab in 7.96

The following errors may occur when using the Segment tab in Quick Letters, Labels, Envelopes, or Cards in Mail to add appeals to constituent records and a query created prior to the 7.96 upgrade is populated in the Input query field of the second segment row:

Error: Runtime Error '0'
Error: Automation Error
or Error: Type Mismatch 

These errors may lead to others when clicking another module in The Raiser's Edge menu:
Error: Error in Main Page Load
The Raiser's Edge was unable to load this page.
Please try accessing this page again. If you still encounter an error, please note the following error and contact Blackbaud support.
Error in Main Page Load ''[path]'
Error number :13
Error description : 'Type mismatch'
.

Additionally, Users may also notice that when populating the Input query field of the second segment row with a query created after the 7.96 upgrade,the Runtime error 0 error does not appear, but when they navigate to the Appeals tab of the segmented constituents, historical appeal data is erroneously added to constituent records when marking the Add Appeal and Package to constituent record checkbox and running the mail merge.

This was resolved in Raiser's Edge version 7.96 patch 1, which was released on November 15 and applied to databases in Blackbaud Hosting Services. If your database is installed locally, download and install the latest version and patch, if applicable.

*Note: The changes in the patch were implemented in Blackbaud Hosting Services, but Blackbaud-hosted databases will still display version 7.96.6401.0 under Help > About the Raiser's Edge. What is in Patch 1 for Raiser's Edge 7.96?

Steps to Duplicate

  1. Select Mail > Quick Letters.
  2. On the Segment tab of the Quick Letters mailing, mark the following checkboxes:
    • Segment mail run
    • Add Appeal and Package to Constituent Record
    • Update Number Solicited for Each Appeal
  3. In the first available Input Query field, press F7.
  4. Select the appropriate query from the list of available queries
  5. Click OK.
  6. In the corresponding Appeal field, press F7 to select the appeal to add to constituents in the query.
  7. In the second-available Input Query field, press F7
  8. Select a query created prior to the 7.96 release
  9. Click OK
  10. In the corresponding Appeal field, press F7 and select any desired appeal
  11. Repeat steps 3-5 as needed
  12. Select Export/Merge/Preview
  13. Errors occur
OR
 
  1. Select Mail > Quick Letters.
  2. On the Segment tab of the Quick Letters mailing, mark the following checkboxes:
    • Segment mail run
    • Add Appeal and Package to Constituent Record
    • Update Number Solicited for Each Appeal
  3. In the first available Input Query field, press F7.
  4. Select the appropriate query from the list of available queries
  5. Click OK.
  6. In the corresponding Appeal field, press F7 to select the appeal to add to constituents in the query.
  7. In the second-available Input Query field, press F7
  8. Select a query created after to the 7.96 release
  9. Click OK
  10. In the corresponding Appeal field, press F7 and select any desired appeal
  11. Repeat steps 3-5 as needed
  12. Select Export/Merge/Preview
  13. Notice the errors don't apepar
  14. Navigate to the Appeals tab of a constituent in one of the segments who might have been included in a segment of a previously-saved mail merge
  15. Notice there are erroneous appeals populated along with the appeal from the mail merge being used

Environment

 Raiser's Edge
 7.96

Was this article helpful?