Error calculating the segment record counts: The definition for column 'ID' must include a data type.

When trying to calculate segments, you might encounter the error, "Error calculating the segment record counts: The definition for column 'ID' must include a data type."
This has occurred with old segments which have been in use through several updates. It is likely that they have been in use and the updater could not update them during the upgrade process.

Create a marketing effort query filtering on the marketing effort receiving this error
In the display fields show
  • Segments\Segments\Name.
  • Segments\Segments\Record count.
  • Segments\Segments\Current as of.
If any of the segments do not show as having a record count value or Current as of date, these are likely the problem.
Edit those segments and Save to update them.

Steps to Duplicate

1) Create a marketing effort
2) Add constituent segments
3) Run the Calculate segments process
4) Notice the process errors with the message, "Error calculating the segment record counts: The definition for column 'ID' must include a data type."

Environment

 Blackbaud CRM
 4.0
 4.0.172.0

Was this article helpful?