03-23-2020 12:14 AM
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
03-23-2020 01:14 PM
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
03-24-2020 02:03 AM
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
03-24-2020 09:01 AM
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
04-06-2020 01:06 AM
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.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide