Words in SmartField table get cut off in new CRM 4.0

there is a 99-character limit on SmartFields in the Data warehouse
Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch

Steps to Duplicate

1. Create a constituent smart field with a text datatype with at least one value over 100 characters.

2. Run ETL and notice how the character values are cutoff after 99. 


 Blackbaud CRM
 4.0.180, Service Pack 15

Was this article helpful?