DB connection health check

Ignition
1

Hello,

I recently watched some videos on Store and Forward and how requests are queued in the event a db connection is down.

I have a use case where I need to "probe" the DB connection from Ignition prior to executing any scripts. In other words, I'm looking to script a health check that will call the DB and see if the connection is in a healthy state. If the response is positive, than all normal ignition processes are allowed to run.

Has anybody done anything similar and can share the scripting objects used to leverage the state of the connection, or any tips involving this subject?

Thanks in advance!
Bela

2

There are system tags available with rich information about each database connection:
https://docs.inductiveautomation.com/display/DOC81/System+Tags#SystemTags-GatewaySystemTags

2 Likes
3

Thanks @PGriffith!

4

Scripts don't go through the store and forward system unless you deliberately choose the *SF* versions of the system functions. You can probably just use try: - except: blocks for simple purposes.

1 Like