Store and Forward Issues?

Ignition
, ,
1

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!

2

The repeatability suggests some link in the chain is going to sleep.

3

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.

4

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.)

3 Likes
5

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):

{[System]Gateway/StoreAndForward/<YourHistorianHere>/Local Cache/PendingRecords}
/ {[System]Gateway/StoreAndForward/<YourHistorianHere>/Local Cache/MaxRecords}
* 100.0

and

{[System]Gateway/StoreAndForward/<YourHistorianHere>/Memory Buffer/PendingRecords}
/ {[System]Gateway/StoreAndForward/<YourHistorianHere>/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.

1 Like
6

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.

7

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!