I’m very sorry for the slow reply. Did the system work for a long time and then recently start losing data?
There are a few possible causes:
- The database could be responding slowly, due to the amount of data, or for a different reason.
- The database connection could be periodically going down, causing data to go to the data cache, and perhaps the data cache is responding slowly.
- Trigger conditions on the group, and data characteristics from the OPC server, are causing events to be missed.
- A problem with the OPC server is preventing data from being delivered to FactorySQL.
The first place to look would be the FactorySQL error log, under Help>Log Viewer. Are there many messages? Are there messages indicating errors?
Next, look under Connection>System Status. Click on “Statistics”. What are the values for:
- Avg Group execution cost
-Avg Exec Delay
Browse down to one of the groups that is missing events, what do the statistics for that group look like?
Finally, in windows explorer, go to “C:\Program Files\Inductive Automation\FactorySQL”, assuming that is where it was installed. How large are the files “system_database.fdb” and “data_cache_db.fdb”?