Error: Query too complex. General ODBC Error:[Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to numeric. Native error:8114- when running a gift query with the criteria Finder number Blank

When a user runs a gift query with the criteria Finder Number blank, the user immediately receives the error Query too complex. General ODBC Error:[Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to numeric. Native error:8114.
 
We are currently evaluating this issue and will update this article when we have more information.  In the meantime, users can query for gift records with blank Finder Number fields by doing the following:
  1. Click Query>New Query
  2. Select Gift from the Query type drop-down
  3. Select Static or Dynamic from the Query format drop-down
  4. Click OK
  5. Click File>Save
  6. Name the query Query #1
  7. Click Save
  8. Close the query
  9. Click Query>New Query
  10. Select Gift from the Query type drop-down
  11. Select Static or Dynamic from the Query format drop-down
  12. Click OK
  13. On the Criteria tab, select Gift Information>Finder Number
  14. Change the Operator to not blank
  15. Click Run Now
  16. Click File>Save
  17. Name the query Query #2
  18. Click Save
  19. Close the query
  20. Click Query>Merge Queries...
  21. Click the binoculars icon in the Primary Query field
  22. Search for Query #1 (saved in step 6)
  23. Click Open
  24. Click the binoculars icon in the Secondary Query field
  25. Search for Query #2 (saved in step 17)
  26. Click Open
  27. Select Sub from the Merge Operator drop-down
  28. Click OK
  29. Select your desired fields on the Output tab of the merged query
  30. Click Run Now

Steps to Duplicate

  1. Click Query>New Query
  2. Select Gift from the Query type drop-down
  3. Select Static or Dynamic from the Query format drop-down
  4. Click OK
  5. On the Criteria tab, select Gift Information>Finder Number
  6. Change the Operator to blank
  7. Click Run Now
  8. Error appears

Environment

 Raiser's Edge
 7.95

Was this article helpful?