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.