History recovery: The JSON value could not be converted to System​.DateTime

When performing a history recovery process and you encounter an error in the log file (HistoryRecovery_<YYYYMMDD>.txt) similar to the following:

{"Timestamp":"2024-08-06T12:44:55.3759847+10:00","Level":"Error","MessageTemplate":"The JSON value could not be converted to System.DateTime. Path: $.checkpoint | LineNumber: 0 | BytePositionInLine: 124.","Properties":{"SourceContext":"DataCurator.HistoryRecovery.MainViewModel"}}

For information on where to find history recovery log files, see History recovery for on-premises data.

Resolution

1. Stop the AVEVA Events to CONNECT and Production Management Data Curator services, and then close the history recovery tool.

2. Delete the following corrupted JSON files from %ProgramData%\OSIsoft\Adapters\EventsToCONNECT\Configuration:

   • ProductionManagementEventData_HistoryRecoveries.json

   • ProductionManagementEventData_IntervalsToRecover.json

3. Start the AVEVA Events to CONNECT and Production Management Data Curator services, open the history recovery tool and start the recovery process.