SQL Tags Problem in FPMI Window

Hi,

We are facing issues with SQL Tags in FPMI. SQL tags are losing connection to the Tags and shows in Red Color. The tags will get connected after few minutes. This cycle will repeat.

When the Tags are not connected, We checked load on the Database (MySQL) which is in normal state.
At any point of time, the no. of threads will not exceed 13 and We set Max Idle, Max Active to 30 in FPMI Data-source Connection Setting.

Please let us know how to resolve this issue.

Thank you

Using the Designer, you should be able to tell the precise quality code for the tags. It could be a number of things, but since you’ve determined that the connection to the database is healthy, I’d look at the OPC connection. What OPC server are you using? Does it report loss of connection to the PLC(s)?

Hi Carl,

We are using KEPServerEX 5.0. There are no instances of losing connection in Event Log of the KEPServerEX. This has a scan rate of 100 milliseconds.

Hi Carl,

We are still facing SQL Tags problem in FPMI. When we use Default Scan Class with Low Rate: 90,000 and Stale Timeout: 90, 000 then Tags seem to be working fine. Can we know what could be the Reason ?

Is it possible to setup a quick web meeting ?

Thank you