# Store and Forward Issues? **URL:** \ **Category:** Ignition\ **Tags:** database, ignition81, perspective\ **Created:** [January 15, 2025, 9:48pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-issues/100951 "2025-01-15T21:48:07Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Estera\_Cioroch](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/estera_cioroch/32/59889_2.png) [@Estera\_Cioroch](https://forum.inductiveautomation.com/u/Estera_Cioroch)\ **Post date:** [January 15, 2025, 9:48pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-issues/100951/1 "2025-01-15T21:48:07Z")
Background: At one of our job sites, daily reports are set to generate every night at 12:05am covering data from midnight to midnight. However, the data populates as "N/A" from 20:00 to midnight every day, with only the occasional report populating fully (maybe every 8-10 days.) The support for our reporting software tried a variety of tests and said that it appears that data is not present in the database at the time of the automatic report generation (12:05am), and think it is tied to the Store and Forward for the system. I'm not very familiar with this feature in Ignition and haven't been able to glean much from the Help Manual that would help me solve this. We do not have the "Schedule" enabled so from my understanding the data should be forwarding at all times. Any ideas as to why this is not the case? I left all the settings on the Store and Forward as defaults. Or is it likely that something else is causing this problem? Thanks in advance! ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [January 15, 2025, 10:01pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-issues/100951/2 "2025-01-15T22:01:51Z")
The repeatability suggests some link in the chain is going to sleep. ---
**Author:** ![Estera\_Cioroch](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/estera_cioroch/32/59889_2.png) [@Estera\_Cioroch](https://forum.inductiveautomation.com/u/Estera_Cioroch)\ **Post date:** [January 15, 2025, 10:23pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-issues/100951/3 "2025-01-15T22:23:37Z")
It really does!! To try to rule the PC out, we also examined logs on the PC via Windows Event Viewer, and even checked screen saver settings, just for the heck of it. And by the way, if we generate a report on-demand (during normal work hours, aka NOT at 12:05am), the data populates just fine on the report. So it gets to the database eventually. Which is why the reporting software suggested the store and forward for the system. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [January 15, 2025, 10:30pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-issues/100951/4 "2025-01-15T22:30:35Z")
Any chance something is bogging the database down during that time period every day? (If the data gets there eventually, it suggests the S&F is working perfectly.) ---
**Author:** ![Chris\_Bingham](https://avatars.discourse-cdn.com/v4/letter/c/e5b9ba/32.png) [@Chris\_Bingham](https://forum.inductiveautomation.com/u/Chris_Bingham)\ **Post date:** [January 15, 2025, 10:41pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-issues/100951/5 "2025-01-15T22:41:07Z")
As a starting point, consider monitoring the [System] tags for Local Cache, also Memory Buffer. One option, create a couple of new memory tags with the following expressions (pick the correct tags from the tag picker): ```python {[System]Gateway/StoreAndForward//Local Cache/PendingRecords} / {[System]Gateway/StoreAndForward//Local Cache/MaxRecords} * 100.0 ``` and ```python {[System]Gateway/StoreAndForward//Memory Buffer/PendingRecords} / {[System]Gateway/StoreAndForward//Memory Buffer/MaxRecords} * 100.0 ``` Then, configure history and/or alarms (@ \> 90%?). See if there is some correlation between times-of-day and utilization of the S&F system load. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [January 15, 2025, 11:17pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-issues/100951/6 "2025-01-15T23:17:30Z")
> [@Chris\_Bingham](#): > > (@ \> 90%?). I would think they are not approaching an S&F limit, or they'd be losing data occasionally. Would be interesting to trend that, though. ---
**Author:** ![Estera\_Cioroch](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/estera_cioroch/32/59889_2.png) [@Estera\_Cioroch](https://forum.inductiveautomation.com/u/Estera_Cioroch)\ **Post date:** [January 16, 2025, 3:43pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-issues/100951/7 "2025-01-16T15:43:09Z")
> [@pturmel](#): > > Any chance something is bogging the database down during that time period every day? > [@Chris\_Bingham](#): > > consider monitoring the [System] tags for Local Cache, also Memory Buffer. > [@Chris\_Bingham](#): > > See if there is some correlation between times-of-day and utilization of the S&F system load. Thanks for the suggestion!! I just set things up according to @Chris_Bingham's suggestion and will monitor those tags for the next couple days to see if it gives me any leads. I'll let you know how it goes! ---
**Author:** ![Estera\_Cioroch](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/estera_cioroch/32/59889_2.png) [@Estera\_Cioroch](https://forum.inductiveautomation.com/u/Estera_Cioroch)\ **Post date:** [January 24, 2025, 5:50pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-issues/100951/8 "2025-01-24T17:50:28Z")
Quick follow up! I tried gleaning some info on the local cache and memory buffer per @Chris_Bingham 's suggestion but that didn't reveal anything. I decided to change the time the reports auto-generate, and every hour I selected past midnight eliminated a row of N/A values, so that now if I set the reports to auto-generate at 5am or later, data populates the reports just fine. This is a "good enough" fix for the site for now, however, it still doesn't explain why there is a 4-hr data lag before midnight specifically. If anyone else encounters a similar issue even months or years later, please let me know! This is a very unsatisfying conclusion. 😐 ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [January 24, 2025, 6:38pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-issues/100951/9 "2025-01-24T18:38:56Z")
Sounds like a time zone issue. ---
**Author:** ![Estera\_Cioroch](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/estera_cioroch/32/59889_2.png) [@Estera\_Cioroch](https://forum.inductiveautomation.com/u/Estera_Cioroch)\ **Post date:** [January 27, 2025, 4:22pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-issues/100951/10 "2025-01-27T16:22:59Z")
Great thought! Doesn't seem to be the issue, thanks for the suggestion though! ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [January 27, 2025, 5:41pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-issues/100951/11 "2025-01-27T17:41:25Z")
> [@Estera\_Cioroch](#): > > Doesn't seem to be the issue How do you know that? Do you have a logger in a script in the report that shows the time and time zone at which it thinks it is running? ---
**Author:** ![drojas](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drojas/32/3403_2.png) [@drojas](https://forum.inductiveautomation.com/u/drojas)\ **Post date:** [January 27, 2025, 5:57pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-issues/100951/12 "2025-01-27T17:57:13Z")
Can you share what "the support for our reporting software" is? Are you using the reporting module in Ignition or some external system? I have seen expressions for querying start date and end date in reports that don't take into account the timezone of the ignition server or sql database. Perhaps if you could share details of the query, we can help pinpoint the problem. I know that personally, I run reports around 3 or 4 am to allow any daylight savings time shifts to occur (and dealing with different timezones of remote sites) to take effect. I know you said that running on-demand reports works fine, but that means you are sending different start/end times. Remember that the designer and running project can run in a different timezone than the gateway. And the scheduled reports are working on the gateway's clock. ---
**Author:** ![Chris\_Bingham](https://avatars.discourse-cdn.com/v4/letter/c/e5b9ba/32.png) [@Chris\_Bingham](https://forum.inductiveautomation.com/u/Chris_Bingham)\ **Post date:** [January 27, 2025, 6:56pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-issues/100951/13 "2025-01-27T18:56:56Z")
Where is the data coming from? ~~If an Edge gateway, there could also be a schedule for which the remote gateways send their S&F data (via Remote History Sync Settings).~~ Edit: Never mind, the above wouldn't amount to: > [@Estera\_Cioroch](#): > > every hour I selected past midnight eliminated a row of N/A values Otherwise, I vote +1 for a time-zone issue (either the data is not being inserted with correct Unix timestamp, or reporting engine is not interpreting the time stamp correctly?)