Error: Arithmetic Overflow for data type tinyint value = -1

When attempting to import recurring gift payments the error "Error: Arithmetic Overflow for data type tinyint value = -1" is received when the application type code field is mapped as 0 
Download and install the latest service pack, which contains all fixes from previous service packs. If you are running an older version, download and install the latest version and then the service pack. 
                                         
Workaround: Change the Application Type Code to the Application indicated below

2 = 'Pledge Payment'  
 

Steps to Duplicate

  1. Create an import file with recurring gift payments ensuring the application type code field is mapped as 0
  2. Run the import process
  3. Go to import and run the import process to bring the file in
  4. Open the batch created from the import process and notice the error

Environment

 Blackbaud CRM
 4.0
 4.0
 Service Pack 7
 SP2 to SP6
 4.0.141

Was this article helpful?