AnsweredAssumed Answered

Clarity application Down

Question asked by sreeram.babu on Mar 1, 2011
Latest reply on Mar 1, 2011 by sreeram.babu
Hi everyone,

Need help on this on urgent basis. Yesterday there was problem with Clarity application , as there was failure in DB connection , We found the problem as the port number has been changed automatically in the DB settings in NSA. Today we have got differnt problem, we could able to open the Clarity URL but None of the users could login..
The error shown below. We enquired DBA team and found theres no error related to SQL connection and App server. No logs are registered on SQL side. Have anyone of the Guys had the same problem .Please help.....(FYI, both the DB servers and APP servers are rebooted)
ERROR 2011-03-01 01:18:24,134 [NMS Message Receiver] proxool.ProxoolDriver (none:none:none) Problem
java.sql.SQLException: Couldn't get connection because we are at maximum connection count and there are none available

at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:167)

at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)

at java.sql.DriverManager.getConnection(DriverManager.java:525)

at java.sql.DriverManager.getConnection(DriverManager.java:140)

at com.niku.union.persistence.connection.ProxoolContext.getConnection(ProxoolContext.java:118)

at com.niku.union.persistence.PersistenceController.createLocalContext(PersistenceController.java:346)

at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:431)

at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:221)

at com.niku.bpm.eventmgr.messageserver.MessageServerPersistenceUtils.getDBMessages(MessageServerPersistenceUtils.java:143)

at com.niku.bpm.eventmgr.messageserver.MessageServerImpl.getDBMessages(MessageServerImpl.java:990)

at com.niku.bpm.eventmgr.messageserver.MessageServerImpl.runMessageReceiver(MessageServerImpl.java:1024)

at com.niku.bpm.eventmgr.messageserver.MessageServerImpl.access$000(MessageServerImpl.java:38)

at com.niku.bpm.eventmgr.messageserver.MessageServerImpl$1.run(MessageServerImpl.java:135)

at java.lang.Thread.run(Thread.java:595)
ERROR 2011-03-01 01:18:24,134 [NMS Message Receiver] bpm.eventmgr (none:none:none) Cannot read messages. Will try again later.
com.niku.union.bpm.messageserver.MessageServerException: getMessages - Cannot get messages

at com.niku.bpm.eventmgr.messageserver.MessageServerPersistenceUtils.getDBMessages(MessageServerPersistenceUtils.java:197)

at com.niku.bpm.eventmgr.messageserver.MessageServerImpl.getDBMessages(MessageServerImpl.java:990)

at com.niku.bpm.eventmgr.messageserver.MessageServerImpl.runMessageReceiver(MessageServerImpl.java:1024)

at com.niku.bpm.eventmgr.messageserver.MessageServerImpl.access$000(MessageServerImpl.java:38)

at com.niku.bpm.eventmgr.messageserver.MessageServerImpl$1.run(MessageServerImpl.java:135)

at java.lang.Thread.run(Thread.java:595)
Caused by: com.niku.union.persistence.PersistenceException: Error getting a DB connection

at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:482)

at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:221)

at com.niku.bpm.eventmgr.messageserver.MessageServerPersistenceUtils.getDBMessages(MessageServerPersistenceUtils.java:143)

... 5 more
Caused by: java.sql.SQLException: Couldn't get connection because we are at maximum connection count and there are none available

at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:167)

at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)

at java.sql.DriverManager.getConnection(DriverManager.java:525)

at java.sql.DriverManager.getConnection(DriverManager.java:140)

at com.niku.union.persistence.connection.ProxoolContext.getConnection(ProxoolContext.java:118)

at com.niku.union.persistence.PersistenceController.createLocalContext(PersistenceController.java:346)

at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:431)

... 7 more
ERROR 2011-03-01 01:18:24,134 [NMS Message Receiver] utilities.SystemOptions (none:none:none)
com.niku.bpm.BpmException: getSystemOptions - Cannot get options.

at com.niku.bpm.utilities.PersistenceUtils.getSystemOptions(PersistenceUtils.java:127)

at com.niku.bpm.utilities.SystemOptions.loadOptions(SystemOptions.java:238)

at com.niku.bpm.utilities.SystemOptions.getMessagesReceiverInterval(SystemOptions.java:170)

at com.niku.bpm.eventmgr.messageserver.MessageServerImpl.runMessageReceiver(MessageServerImpl.java:1090)

at com.niku.bpm.eventmgr.messageserver.MessageServerImpl.access$000(MessageServerImpl.java:38)

at com.niku.bpm.eventmgr.messageserver.MessageServerImpl$1.run(MessageServerImpl.java:135)

at java.lang.Thread.run(Thread.java:595)
Caused by: com.niku.union.persistence.PersistenceException: Error getting a DB connection

at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:482)

at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:221)

at com.niku.bpm.utilities.PersistenceUtils.getSystemOptions(PersistenceUtils.java:98)

... 6 more
Caused by: java.sql.SQLException: Connection unavailable

at com.niku.union.persistence.connection.ProxoolContext.getConnection(ProxoolContext.java:105)

at com.niku.union.persistence.PersistenceController.createLocalContext(PersistenceController.java:346)

at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:431)

... 8 more

:sad

Thanks in advance

Sreeram

Outcomes