Introduction
It's uncommon, but you may occasionally encounter a message regarding future data in DPA. DPA saves monitoring data based on the current time of its server, so this issue usually arises when the system time is briefly set to a future date.
Error Message
In the DPA log files, you'll see an error message that reads: "Ignite detected future monitoring data. This can occur when the clock is set back or if a stats query runs for an extended period (>10 min). Monitoring will automatically resume after [2024-11-12 06:59:59.0]. No action required by user." While it states that no action is needed, monitoring will pause until November 12th (currently October 25th as I write this). If you want DPA to resume monitoring sooner, consider following the steps below.
Workaround for Future Data
Deleting all future data has been effective in resolving this issue. The attached script will assist you in this process. Depending on your repository type, running the SELECT query will identify all tables and columns with date data types, generating a list of DELETE statements that you can manually execute in your preferred query tool. To ensure the best results, I recommend the following steps:
- Stop the DPA application by stopping the Windows service named "Ignite PI Server."
- Run the SELECT statement in the attached script to generate a set of DELETE statements.
- Copy and paste the DELETE statements and execute them against the DPA repository database.
- Restart DPA.
Please let me know in the comments if this information has helped or if you have any questions.
