Error: Data form could not be loaded. Adding a value to a 'datetimeoffset' column caused an overflow - when adding a program to a group sale reservation

You may receive this error message when clicking Add > Scheduled Program in the itinerary of a group sale reservation.  You will not receive this error message when adding a daily admission program or custom item.
This is caused by an extremely high value for the on sale period ends value on the program record.
  1. Go to Tickets > Program Search.
  2. Open the program with the high on sale period.
  3. Go to the On-sale tab.
  4. Click on the green downward arrows for Group Sales and click Edit.
  5. Change the on-sale period ends value from a very high figure such as 920,000,000 to something much lower like 900 hours after start.
  6. Save the changes.
If you do not know which program has the high on sale period ends value, Chat with Support with this article number.

Steps to Duplicate

  1. Go to Sales > Group Sales.
  2. Open a group sale reservation that has two itineraries.
  3. Click on the second itinerary.
  4. Click Add > Scheduled Program.
  5. You may receive an error message: Error: Data form could not be loaded.  Adding a value to a 'datetimeoffset' column caused an overflow

Environment

 Altru Arts & Cultural
 Yes

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.