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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.