Cisco Finesse 11.5 Error in RTMT at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:125)

karthikageer · ‎03-23-2020

Finesse version 11.5, When i try to login in to finesse primary node, the connection is getting failover to secondary node even though the primary server is up, and in the Real time trace i pulled using RTMT is showing the below errors.

2020.03.23 02:48:05 Database selected
java.sql.SQLWarning: Database selected
at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:125)
at com.informix.util.IfxWarnMsg.getSQLWarning(IfxWarnMsg.java:149)
at com.informix.jdbc.IfxSqliConnect.a(IfxSqliConnect.java:2375)
at com.informix.jdbc.IfxSqliConnect.t(IfxSqliConnect.java:4673)
at com.informix.jdbc.IfxSqliConnect.b(IfxSqliConnect.java:3224)
at com.informix.jdbc.IfxSqliConnect.a(IfxSqliConnect.java:3097)
at com.informix.jdbc.IfxSqli.c(IfxSqli.java:2924)
at com.informix.jdbc.IfxSqli.executeOpenDatabase(IfxSqli.java:2070)
at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1721)
at sun.reflect.GeneratedConstructorAccessor19.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:254)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
2020.03.23 02:48:20 time=1584946100018,total_active_sessions=8,msgs_sent=5,msgs_queue=0,msgs_drop=0,bytes_sent=3832
2020.03.23 02:48:50 time=1584946130021,total_active_sessions=8,msgs_sent=5,msgs_queue=0,msgs_drop=0,bytes_sent=3832
2020.03.23 02:49:20 time=1584946160032,total_active_sessions=8,msgs_sent=5,msgs_queue=0,msgs_drop=0,bytes_sent=3832
2020.03.23 02:49:50 time=1584946190031,total_active_sessions=9,msgs_sent=5,msgs_queue=0,msgs_drop=0,bytes_sent=3883
2020.03.23 02:50:04 A connection to 2400@vfinesse01a.rpega.com/desktop is open
2020.03.23 02:50:06 Session to 2400@vfinesse01a.rpega.com/desktop is being closed
2020.03.23 02:50:06 Processed close session request for 2400@vfinesse01a.rpega.com/desktop.
Last active time : 2020-03-23T02:50:04.884Z. Closed now: 0, in closed state: 2 out of 2 connections.
at org.jivesoftware.openfire.http.HttpSession.getCalleeTrace(HttpSession.java:209)
at org.jivesoftware.openfire.http.HttpSession.closeSession(HttpSession.java:1177)
at org.jivesoftware.openfire.http.HttpSession.access$400(HttpSession.java:79)
at org.jivesoftware.openfire.http.HttpSession$HttpVirtualConnection.closeVirtualConnection(HttpSession.java:1237)
at org.jivesoftware.openfire.net.VirtualConnection.close(VirtualConnection.java:179)
at org.jivesoftware.openfire.http.HttpSession.close(HttpSession.java:231)
at org.jivesoftware.openfire.handler.IQBindHandler.handleIQ(IQBindHandler.java:139)
at org.jivesoftware.openfire.handler.IQHandler.process(IQHandler.java:65)
2020.03.23 02:50:06 A connection to 2400@vfinesse01a.rpega.com/desktop is open
2020.03.23 02:50:06 Session to 2400@vfinesse01a.rpega.com/desktop is being closed
2020.03.23 02:50:06 Processed close session request for 2400@vfinesse01a.rpega.com/desktop.
Last active time : 2020-03-23T02:50:06.728Z. Closed now: 0, in closed state: 1 out of 1 connections.
at org.jivesoftware.openfire.http.HttpSession.getCalleeTrace(HttpSession.java:209)
at org.jivesoftware.openfire.http.HttpSession.closeSession(HttpSession.java:1177)
at org.jivesoftware.openfire.http.HttpSession.access$400(HttpSession.java:79)
at org.jivesoftware.openfire.http.HttpSession$HttpVirtualConnection.closeVirtualConnection(HttpSession.java:1237)
at org.jivesoftware.openfire.net.VirtualConnection.close(VirtualConnection.java:179)
at org.jivesoftware.openfire.http.HttpSession.close(HttpSession.java:231)
at org.jivesoftware.openfire.handler.IQBindHandler.handleIQ(IQBindHandler.java:139)
at org.jivesoftware.openfire.handler.IQHandler.process(IQHandler.java:65)
2020.03.23 02:50:07 A connection to 2400@vfinesse01a.rpega.com/desktop is open
2020.03.23 02:50:20 time=1584946220035,total_active_sessions=9,msgs_sent=6,msgs_queue=0,msgs_drop=0,bytes_sent=4097

please let me know how to fix this issue.

thanks,

Karthik

dekwan · ‎03-23-2020

Hi,

Are you logging into Finesse using the out of the box agent desktop or a custom desktop?

If you are using the Finesse out of the box desktop, I would suggest opening up a TAC case.

Thanx,

Denise

karthikageer · ‎03-24-2020

We usually use our own Cti desktop tool for login, some times we use finesse desktop for testing the behaviour in Finesse desktop

Thanks,

Karthik

dekwan · ‎03-24-2020

Hi,

Do you see this same behavior if you are using the Finesse out of the box desktop? I am trying to determine if this is an issue with the Finesse environment itself or specifically with your custom cti desktop tool. Is this desktop tool using the Finesse APIs to log in?

Thanx,

Denise

karthikageer · ‎04-06-2020

Yes, We are using Finesse API for custom Desktop. I am yet to try with Finesse out of the box desktop, I will keep you posted once i have the information.