1 Reply Latest reply on Jun 12, 2017 10:31 AM by Ramesh Reddy

    teiid throwing listener does not currently know of SID given in connect descriptor

    Kulbhushan Chaskar Master

      Hi,

       

      I am trying to connect to  oracle database using dynamic VDB and dynamic datasource but teiid throwing an error :

      throwing listener does not currently know of SID given in connect descriptor

      Note : I am using teiid admin api to deploy dynamic VDB version is 9.1.3 and Wildfly 10.0.0

       

      Full stack trace:

      WFLYUT0021: Registered web context: /odata4

      2017-06-09 19:56:39,238 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (Worker0_async-teiid-threads0)  IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: IJ031084: Unable to create connection

              at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:343)

              at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:350)

              at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:285)

              at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.createConnectionEventListener(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1319)

              at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.getConnection(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:496)

              at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:626)

              at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:598)

              at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:590)

              at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:429)

              at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:747)

              at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:138)

              at org.jboss.as.connector.subsystems.datasources.WildFlyDataSource.getConnection(WildFlyDataSource.java:66)

              at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:278)

              at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:69)

              at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:205)

              at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:72)

              at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:62)

              at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)

              at org.teiid.jboss.VDBService$6.run(VDBService.java:360)

              at org.teiid.jboss.VDBService$7.run(VDBService.java:411)

              at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)

              at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)

              at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)

              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

              at java.lang.Thread.run(Thread.java:745)

       

       

      Caused by: 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

       

       

              at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

              at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)

              at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)

              at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:480)

              at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)

              at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)

              at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)

              at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)

              at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)

              at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:319)

              ... 25 more

      Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:

      ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

       

       

              at oracle.net.ns.NSProtocol.connect(NSProtocol.java:361)

              at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966)

              at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292)

              ... 30 more

       

       

      2017-06-09 19:56:39,245 WARN  [org.teiid.RUNTIME] (Worker0_async-teiid-threads0)  TEIID50036 VDB SvcSourceVdb_TESTDSORACLE20170609183701962.1 model "TESTDSORACLE20170609183701962" metadata failed to load. Reason:TEIID31178 Could not obtain connection for schema TESTDSORACLE20170609183701962, but one is required for metadata load. : org.teiid.translator.TranslatorException: TEIID31178 Could not obtain connection for schema TESTDSORACLE20170609183701962, but one is required for metadata load.

              at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:76)

              at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:62)

              at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)

              at org.teiid.jboss.VDBService$6.run(VDBService.java:360)

              at org.teiid.jboss.VDBService$7.run(VDBService.java:411)

              at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)

              at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)

              at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)

              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

              at java.lang.Thread.run(Thread.java:745)

      Caused by: org.teiid.translator.TranslatorException: TEIID11009 java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/TESTDSORACLE20170609183540384

              at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:282)

              at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:69)

              at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:205)

              at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:72)

              ... 10 more

      Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/TESTDSORACLE20170609183540384

              at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:146)

              at org.jboss.as.connector.subsystems.datasources.WildFlyDataSource.getConnection(WildFlyDataSource.java:66)

              at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:278)

              ... 13 more

      Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/TESTDSORACLE20170609183540384

              at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:656)

              at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:429)

              at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:747)

              at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:138)

              ... 15 more

      Caused by: javax.resource.ResourceException: IJ031084: Unable to create connection

              at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:343)

              at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:350)

              at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:285)

              at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.createConnectionEventListener(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1319)

              at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.getConnection(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:496)

              at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:626)

              at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:598)

              at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:590)

              ... 18 more

      Caused by: 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

       

       

              at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

              at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)

              at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)

              at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:480)

              at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)

              at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)

              at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)

              at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)

              at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)

              at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:319)

              ... 25 more

      Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:

      ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

       

       

              at oracle.net.ns.NSProtocol.connect(NSProtocol.java:361)

              at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966)

              at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292)

      ... 30 more

       

      Thanks,

      Kulbhushan Chaskar.