Using OpenAPI to collect data on various devices and components and have experienced instances of missing data in the query results.
Running a query for metrics every 5 minutes for the last 5 minutes worth of data.
All supported Performance Management releases
Query frequency is too frequent. It doesn't allow enough time for the polled data to be inserted to the database after each poll cycle completes.
As a result, it's random what metrics will have had the data inserted when they query is resulting in mixed results.
The problem stems from the inability to know exactly when a poll is run or started, or when the data point is inserted to the DB for retrieval. No way to determine and base a schedule off that timing.