Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-13785

Change logging level for Oracle UCP, if SID is wrong

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Trivial
    • Resolution: Fixed
    • Affects Version/s: 7.0.0
    • Fix Version/s: 7.0.0
    • Component/s: None
    • Labels:
    • Environment:
      OpenIDM 7.0.0-SNAPSHOT (d19ff81)
      database-enterprise:12.2.0.1
    • Target Version/s:
    • Verified Version/s:
    • Story Points:
      1
    • Sprint:
      2019.17 - IDM, 2020.04 - IDM

      Description

      If user set url in datasource.jdbc-ucp-oracle.json with wrong :SID, IDM try start it but without success and without errors. On logging level FINEST is mentioned reason, why not started.

      [17] Sep 18, 2019 5:25:59.777 PM oracle.ucp.logging.ClioSupport _log
      FINEST: oracle.ucp.common.UniversalConnectionPoolBase:start:oracle.ucp.jdbc.oracle.OracleConnectionConnectionPool@70fccc0c:throwing: Cannot get Connection from Datasource: java.sql.SQLException: Listener refused the connection with the following error:
      ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
        : [oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:336), oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:59), oracle.ucp.jdbc.oracle.OracleDataSourceConnectionFactoryAdapter.createConnection(OracleDataSourceConnectionFactoryAdapter.java:133), oracle.ucp.common.Database.createPooledConnection(Database.java:256), oracle.ucp.common.Topology.start(Topology.java:235), oracle.ucp.common.Core.start(Core.java:1795), oracle.ucp.common.UniversalConnectionPoolBase.start(UniversalConnectionPoolBase.java:709), oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.start(OracleJDBCConnectionPool.java:129), oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:938), oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1969), oracle.ucp.jdbc.PoolDataSourceImpl.access$500(PoolDataSourceImpl.java:198), oracle.ucp.jdbc.PoolDataSourceImpl$30.build(PoolDataSourceImpl.java:4353), oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1924), oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1887), oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1872), org.forgerock.openidm.datasource.jdbc.impl.JDBCDataSourceService.lambda$initDataSourceService$0(JDBCDataSourceService.java:138), org.forgerock.openidm.repo.util.Retryable.retryWithDelay(Retryable.java:43), org.forgerock.openidm.datasource.jdbc.impl.JDBCDataSourceService.initDataSourceService(JDBCDataSourceService.java:136), org.forgerock.openidm.datasource.jdbc.impl.JDBCDataSourceService.newInstance(JDBCDataSourceService.java:123), org.forgerock.openidm.datasource.jdbc.JDBCDataSourceServiceFactory.newInstance(JDBCDataSourceServiceFactory.java:127), org.forgerock.openidm.repo.jdbc.impl.Activator.start(Activator.java:71), org.apache.felix.framework.util.SecureAction.startActivator(SecureAction.java:698), org.apache.felix.framework.Felix.activateBundle(Felix.java:2402), org.apache.felix.framework.Felix.startBundle(Felix.java:2308), org.apache.felix.framework.Felix.setActiveStartLevel(Felix.java:1539), org.apache.felix.framework.FrameworkStartLevelImpl.run(FrameworkStartLevelImpl.java:308), java.lang.Thread.run(Thread.java:748)]
      [17] Sep 18, 2019 5:25:59.778 PM oracle.ucp.logging.ClioSupport _log
      FINEST: oracle.ucp.common.UniversalConnectionPoolBase:start:oracle.ucp.jdbc.oracle.OracleConnectionConnectionPool@70fccc0c:throwing: Invalid life cycle state. Check the status of the Universal Connection Pool : [oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:336), oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:59), oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:106), oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.checkLifecycle(UniversalConnectionPoolImpl.java:775), oracle.ucp.common.UniversalConnectionPoolImpl$UniversalConnectionPoolInternal.access$200(UniversalConnectionPoolImpl.java:683), oracle.ucp.common.UniversalConnectionPoolImpl.purge(UniversalConnectionPoolImpl.java:425), oracle.ucp.common.UniversalConnectionPoolBase.start(UniversalConnectionPoolBase.java:735), oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.start(OracleJDBCConnectionPool.java:129), oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:938), oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1969), oracle.ucp.jdbc.PoolDataSourceImpl.access$500(PoolDataSourceImpl.java:198), oracle.ucp.jdbc.PoolDataSourceImpl$30.build(PoolDataSourceImpl.java:4353), oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1924), oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1887), oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1872), org.forgerock.openidm.datasource.jdbc.impl.JDBCDataSourceService.lambda$initDataSourceService$0(JDBCDataSourceService.java:138), org.forgerock.openidm.repo.util.Retryable.retryWithDelay(Retryable.java:43), org.forgerock.openidm.datasource.jdbc.impl.JDBCDataSourceService.initDataSourceService(JDBCDataSourceService.java:136), org.forgerock.openidm.datasource.jdbc.impl.JDBCDataSourceService.newInstance(JDBCDataSourceService.java:123), org.forgerock.openidm.datasource.jdbc.JDBCDataSourceServiceFactory.newInstance(JDBCDataSourceServiceFactory.java:127), org.forgerock.openidm.repo.jdbc.impl.Activator.start(Activator.java:71), org.apache.felix.framework.util.SecureAction.startActivator(SecureAction.java:698), org.apache.felix.framework.Felix.activateBundle(Felix.java:2402), org.apache.felix.framework.Felix.startBundle(Felix.java:2308), org.apache.felix.framework.Felix.setActiveStartLevel(Felix.java:1539), org.apache.felix.framework.FrameworkStartLevelImpl.run(FrameworkStartLevelImpl.java:308), java.lang.Thread.run(Thread.java:748)]
      

        Attachments

          Activity

            People

            • Assignee:
              cgdrake Chris Drake
              Reporter:
              petr.bednar Petr Bednar [X] (Inactive)
              QA Assignee:
              Alexander Dracka
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: