During data migrations, there could be multiple data issues that we encounter. Here is one such issue related to loading events and steps to overcome the issue.
If the IsAllDayEvent is set to false on the event record, then, ActivityDateTime is required and either DurationInMinutes or EndDateTime is required.
However on instances where there is a timestamp for ActivityDateTime and no timestamp for EndDateTime, blank the EndDateTime and set DurationInMinutes to 1440. This will help to fix the data load issue around this.
Written by Prabha Krishnamurthy