Error: The INSERT statement conflicted with the CHECK constraint "CK_CREDITCARD_CREDITCARDFIELDSREQUIRED".

Users receive error:  The INSERT statement conflicted with the CHECK constraint "CK_CREDITCARD_CREDITCARDFIELDSREQUIRED". The conflict occurred in database "27308P_7e18f247-4233-42a2-9387-d1efb60e2d64", table "dbo.CREDITCARD".<br>BBERR_ORIGINAL_ERROR:547<br>BBERR_ORIGINAL_PROCEDURE:USP_CREDITCARD_ADD<br>BBER when attempting to tokenize credit cards using the Tokenizer in CRM 
This has been resolved in Service Pack 17. Please download and install the latest Service Pack or Hot Fix which contains all fixes from previous patches.

Steps to Duplicate

  1. Browse to Tokenizer utility URL
  2. Browse to CSV file  
  3. Map fields
  4. Click Upload
  5. Receive error

Environment

 Blackbaud CRM
 4.0
 4.0
 4.0.180.1716

Was this article helpful?