Hi,
We have implemented chat in our environment. GAD is deployed in websphere. But we are facing some issues in GAD, like slowness in GAD, and GAD getting freezed. When we look at the GAD logs we were getting some exceptions. Also in UCS we could find the below errors
Here is the execution query request:
13:47:56.292 Trc 21284 [.143:319767] <GAD> JDBC: [OraDriver] #920 cursor #4 return to the pool (select count(*) from Interaction where (Interaction.ContactId = :1) and (Interaction.Status != :2) and (Interaction.Id != :3) and (Interaction.SubtypeId != :4) and (Interaction.SubtypeId != :5) and (Interaction.SubtypeId != :6) and (Interaction.SubtypeId != :7))
Here is the condition returned back in response to the request from GAD:
13:47:56.292 Dbg 29999 [.143:319767] <GAD> [Main DS] Returning connection into the pool.
13:47:56.292 Trc 21284 [.143:319767] <GAD> JDBC: [Pool Driver]ProxyConnection.close
13:47:57.480 Trc 21284 [.143:319771] <GAD 0000Ta5S6U4A04VC> JDBC: com.inet.ora.af: [OraDriver] Connection refused: connect
13:47:57.480 Trc 21284 [.143:319771] <GAD 0000Ta5S6U4A04VC> JDBC: at com.inet.ora.aq.a(Unknown Source)
Additionally I see the following:
JDBC: [OraDriver] Try: SERVER:1521
13:47:58.573 Trc 21284 [.143:319771] <GAD 0000Ta5S6U4A04VC> JDBC: com.inet.ora.af: [OraDriver] Connection refused: connect
Any idea why this error comes?
Pointers to resolve this issue wud be appreciated.
Thanks....
