4 Replies Latest reply on Aug 19, 2014 7:57 PM by Karthik Nagaramu

    Unable to login to BCO Console

    Karthik Nagaramu
      Share This:

      Hi,

       

      I am facing an error while logging in to BCO Console.

      Login failure due to BCO_WEB_ERR015: Console exhausted the connection pool to the database.

      And from the details following is the message I could see.

      com.neptuny.cpit.entity.ExceptionContainer:

      com.neptuny.cpit.querymanager.QueryException - message: [com.neptuny.cpit.database.DatabaseConnectionManagerException] - Unable to borrow datasource connection:

      "Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'" - [borrowed=0]

      com.neptuny.cpit.entity.EntityException - message: SELECT_ALL_FAILED

      Class --> com.neptuny.cpit.entity.base.AcObject

      Attributes --> objname=null;

       

      at com.neptuny.cpit.entity.EntityDBHelper.selectAll(EntityDBHelper.java:268)

      at com.neptuny.cpit.entity.EntityCacher.cacheEntity(EntityCacher.java:110)

      at com.neptuny.cpit.entity.EntityCacher.getCachedEntity(EntityCacher.java:199)

      at com.neptuny.cpit.entity.EntityCacher.getEntityList(EntityCacher.java:178)

      at com.neptuny.cpit.entity.EntityCacher.getEntityListNotCloned(EntityCacher.java:163)

      at com.neptuny.cpit.acl.BasicAccessControlManager.checkAcObjectSet(BasicAccessControlManager.java:109)

      at com.neptuny.cpit.acl.BasicAccessControlManager.checkCachedStructures(BasicAccessControlManager.java:101)

      at com.neptuny.cpit.acl.BasicAccessControlManager.(BasicAccessControlManager.java:97)
      at com.neptuny.cpit.acl.BasicAccessControlManager.getInstance(BasicAccessControlManager.java:88)
      at com.neptuny.cpit.entity.DatabaseFacade.(DatabaseFacade.java:58)
      at com.bmc.cpit.security.AuthServlet.process(AuthServlet.java:145)
      at com.bmc.cpit.security.AuthServlet.doPost(AuthServlet.java:112)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.neptuny.cpit.web.servlets.filters.UTF8Filter.doFilter(UTF8Filter.java:193)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:558)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:394)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
      at java.lang.Thread.run(Unknown Source)

       

      Any suggestion how to proceed with this error.

        • 1. Re: Unable to login to BCO Console
          Alessandro Trolli

          Hi,

           

          that exception is typically related to database unavailability: listener down or password expired are frequent cases.

           

          If are you able to connect to the database using sqlplus or another database client, you can try to restart BMC Capacity Optimization and see if it fixes.

           

          Please verify that all BCO database users (BCO_OWN, BCO_DASH) are able to connect and database is configured to accept more than 100 concurrent sessions.

          If database passwords expire on a time based, and you have sysdba privileges on that instance, you can execute the following script to disable automatic expiration

           

          ALTER PROFILE DEFAULT LIMIT

            FAILED_LOGIN_ATTEMPTS UNLIMITED

            PASSWORD_LIFE_TIME UNLIMITED;

          • 2. Re: Unable to login to BCO Console
            Karthik Nagaramu

            Hi,

             

            Thanks for your reply.

            I verified that I am able to connect using BCO_OWN user directly to database and concurrent users are allowed.

            I am not sure what else is the issue here.

             

            Regards,

            Karthik

            • 3. Re: Unable to login to BCO Console
              Alessandro Trolli

              I've just analyzed better the log...

              the root cause seems related to oracle client and jdbc libraries:

              "Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver"

               

              Is oracle client properly installed and $ORACLE_HOME/jdbc/lib folder reachable from bco os user?

              you can also check if Oracle related variables are properly configured within env.sh.

              • 4. Re: Unable to login to BCO Console
                Karthik Nagaramu

                Hi,

                 

                It was a access issue the cpit user was not able to access the jdbc directory for the drivers. Once the access is provided I am able to login to console now. Thanks for the help.

                 

                Regards,

                Karthik