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?