I have an RDBMSPI interface running on a PI server. It connects to an Oracle database and runs a few simple querys. I have a problem however, that if the ODBC Connection is lost (which it will be at least once a month due to maintenance), it stops working. The ODBC connection is reestablished automatically according to the log, and the pipoints seem to be reloaded, but the querys doesn't seem to run. To make it work again, I have to restart the interface.
Any ideas on how to fix this? Version numbers below.
Also, how can I prevent the interface from writing digital status to the pipoints? I would like it to not write I/O Timeout or Bad Status.