Error: Cannot insert the value NULL into column 'TYPECODE', table '48502_5b6c7a31-f36e-4c25-a542-39d4bb460981.dbo.BATCHREVENUEADDITIONALAPPLICATIONS'; column does not allow nulls. INSERT fails when running the Generate Revenue Update Batch process

When users run a Generate Revenue Update Batch process they receive an error: Cannot insert the value NULL into column 'TYPECODE', table '48502_5b6c7a31-f36e-4c25-a542-39d4bb460981.dbo.BATCHREVENUEADDITIONALAPPLICATIONS'; column does not allow nulls. INSERT fails.
BBERR_ORIGINAL_ERROR:515
BBERR_ORIGINAL_PROCEDURE:USP_REVENUEBATCH
 
We're currently evaluating this issue for a fix in a future patch or service pack.  

Steps to Duplicate

Steps to duplicate:
  1. Login to CRM
  2. Go to Revenue
  3. Select Generate Revenue Update Batch
  4. Find the process named UK Amend revenue batch detail
  5. Run this process.  It will complete with exceptions
  6. select View Exception Report
  7. Receive error: Cannot insert the value NULL into column 'TYPECODE', table '48502_5b6c7a31-f36e-4c25-a542-39d4bb460981.dbo.BATCHREVENUEADDITIONALAPPLICATIONS'; column does not allow nulls. INSERT fails.
    BBERR_ORIGINAL_ERROR:515
    BBERR_ORIGINAL_PROCEDURE:USP_REVENUEBATCH

Environment

 Blackbaud CRM
 4.0
 4.0.141.0

Was this article helpful?