2 Replies Latest reply on Dec 26, 2012 10:54 AM by Steven Hawkins Branched to a new discussion.

    Teiid JDBC and ODBC transport services don't startup?

    baris dogan Newbie

      My Teiid 8.2 Final,Teiid Designer 8.0, Eclipse Juno 4.2 on RHEL 6.2, uses standard teiid-standalone.xml configured with mysql-connector-java-5.1.22-bin.jar in modules under <jbossinstalldir>.

       

      When I click jdbc connection test in teiid server properties page in eclipse, ILogon Exception is thrown with componentnotfoundexception error, and can not establish jdbc connection for vdb.

       

      Any hint is appreciated, thanks.

       

      Console output, where the problems arise, is as follows:

       

      10:49:06,773 WARN  [com.arjuna.ats.arjuna] (Transaction Expired Entry Monitor) ARJUNA012210: Unable to use InetAddress.getLocalHost() to resolve address.

      10:49:07,451 INFO  [org.infinispan.jmx.CacheJmxRegistration] (pool-11-thread-1) ISPN000031: MBeans were successfully registered to the platform mbean server.

      10:49:07,466 INFO  [org.infinispan.jmx.CacheJmxRegistration] (pool-10-thread-1) ISPN000031: MBeans were successfully registered to the platform mbean server.

      10:49:07,467 INFO  [org.jboss.as.clustering.infinispan] (pool-11-thread-1) JBAS010281: Started resultset-repl cache from teiid container

      10:49:07,467 INFO  [org.jboss.as.clustering.infinispan] (pool-10-thread-1) JBAS010281: Started resultset cache from teiid container

      10:49:07,805 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS]

      10:49:07,821 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-3) JBAS010400: Bound data source [java:jboss/datasources/MySqlDS]

      10:49:08,232 INFO  [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50001 Teiid Engine 8.2.0.Final Started = Wed Dec 26 10:49:08 EET 2012

      10:49:08,266 INFO  [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50038 Teiid Embedded transport enabled. Bound to: teiid/queryengine

      10:49:28,681 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-2) MSC00001: Failed to start service jboss.teiid.transport.jdbc: org.jboss.msc.service.StartException in service jboss.teiid.transport.jdbc: Failed to start service

          at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1767) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.7.0_09]

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.7.0_09]

          at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_09]

      Caused by: org.teiid.core.TeiidRuntimeException: TEIID40065 Failed to resolve the bind address

          at org.teiid.transport.SocketConfiguration.resolveHostName(SocketConfiguration.java:82)

          at org.teiid.transport.SocketConfiguration.getHostAddress(SocketConfiguration.java:103)

          at org.teiid.transport.SocketListener.<init>(SocketListener.java:55)

          at org.teiid.jboss.TransportService.start(TransportService.java:171)

          at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

          at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

          ... 3 more

       

      10:49:38,656 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-4) MSC00001: Failed to start service jboss.teiid.transport.odbc: org.jboss.msc.service.StartException in service jboss.teiid.transport.odbc: Failed to start service

          at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1767) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.7.0_09]

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.7.0_09]

          at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_09]

      Caused by: org.teiid.core.TeiidRuntimeException: TEIID40065 Failed to resolve the bind address

          at org.teiid.transport.SocketConfiguration.resolveHostName(SocketConfiguration.java:82)

          at org.teiid.transport.SocketConfiguration.getHostAddress(SocketConfiguration.java:103)

          at org.teiid.transport.SocketListener.<init>(SocketListener.java:55)

          at org.teiid.transport.ODBCSocketListener.<init>(ODBCSocketListener.java:43)

          at org.teiid.jboss.TransportService.start(TransportService.java:195)

          at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

          at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

          ... 3 more

       

      10:49:38,886 INFO  [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service status report

      JBAS014777:   Services which failed to start:      service jboss.teiid.transport.jdbc: org.jboss.msc.service.StartException in service jboss.teiid.transport.jdbc: Failed to start service

            service jboss.teiid.transport.odbc: org.jboss.msc.service.StartException in service jboss.teiid.transport.odbc: Failed to start service

       

      10:49:39,363 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-4) JBAS015876: Starting deployment of "teiid-connector-ldap.rar"

      10:49:39,336 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "teiid-connector-file.rar"

      10:49:39,336 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015876: Starting deployment of "teiid-connector-ws.rar"

      10:49:39,363 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015876: Starting deployment of "teiid-connector-google.rar"

      10:49:39,402 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "teiid-connector-salesforce.rar"

      10:49:39,403 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015876: Starting deployment of "teiid-connector-infinispan.rar"

      10:49:43,705 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-2) JBAS018567: Deployment "deployment.teiid-connector-ws.rar" is using a private module ("org.apache.cxf:main") which may be changed or removed in future versions without notice.

      10:49:43,706 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-2) JBAS018567: Deployment "deployment.teiid-connector-ws.rar" is using a private module ("org.apache.cxf:main") which may be changed or removed in future versions without notice.

      10:49:43,711 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-3) JBAS018567: Deployment "deployment.teiid-connector-salesforce.rar" is using a private module ("org.apache.cxf:main") which may be changed or removed in future versions without notice.

      10:49:43,732 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-3) JBAS018567: Deployment "deployment.teiid-connector-salesforce.rar" is using a private module ("org.apache.cxf:main") which may be changed or removed in future versions without notice.

      10:49:43,796 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-4) JBAS018567: Deployment "deployment.teiid-connector-infinispan.rar" is using a private module ("org.infinispan.client.hotrod:main") which may be changed or removed in future versions without notice.

      10:49:43,798 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-4) JBAS018567: Deployment "deployment.teiid-connector-infinispan.rar" is using a private module ("org.infinispan.cachestore.remote:main") which may be changed or removed in future versions without notice.

      10:49:43,800 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-4) JBAS018567: Deployment "deployment.teiid-connector-infinispan.rar" is using a private module ("org.jboss.as.clustering.infinispan:main") which may be changed or removed in future versions without notice.

      10:49:43,801 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-4) JBAS018567: Deployment "deployment.teiid-connector-infinispan.rar" is using a private module ("org.infinispan.client.hotrod:main") which may be changed or removed in future versions without notice.

      10:49:43,804 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-4) JBAS018567: Deployment "deployment.teiid-connector-infinispan.rar" is using a private module ("org.infinispan.cachestore.remote:main") which may be changed or removed in future versions without notice.

      10:49:43,805 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-4) JBAS018567: Deployment "deployment.teiid-connector-infinispan.rar" is using a private module ("org.jboss.as.clustering.infinispan:main") which may be changed or removed in future versions without notice.

      10:49:45,030 INFO  [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-3) IJ020001: Required license terms for file:/opt/jboss-install/jboss-as-7.1.1.Final/standalone/tmp/vfs/tempc89a67dd47ddd5bc/teiid-connector-ldap.rar-281802927d6ee376/contents/

      10:49:45,030 INFO  [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-1) IJ020001: Required license terms for file:/opt/jboss-install/jboss-as-7.1.1.Final/standalone/tmp/vfs/tempc89a67dd47ddd5bc/teiid-connector-infinispan.rar-4925f4a8b1ad681e/contents/

      10:49:45,278 INFO  [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/opt/jboss-install/jboss-as-7.1.1.Final/standalone/tmp/vfs/tempc89a67dd47ddd5bc/teiid-connector-salesforce.rar-675841adf342758e/contents/

      10:49:45,344 INFO  [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-4) IJ020001: Required license terms for file:/opt/jboss-install/jboss-as-7.1.1.Final/standalone/tmp/vfs/tempc89a67dd47ddd5bc/teiid-connector-google.rar-21c5436daa9ca3/contents/

      10:49:45,350 INFO  [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-3) IJ020001: Required license terms for file:/opt/jboss-install/jboss-as-7.1.1.Final/standalone/tmp/vfs/tempc89a67dd47ddd5bc/teiid-connector-file.rar-a92525716a9a3b28/contents/

      10:49:45,355 INFO  [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-4) IJ020001: Required license terms for file:/opt/jboss-install/jboss-as-7.1.1.Final/standalone/tmp/vfs/tempc89a67dd47ddd5bc/teiid-connector-ws.rar-6bd64c425c53dff5/contents/

      10:49:45,475 INFO  [org.jboss.as] (MSC service thread 1-4) JBAS015951: Admin console listening on http://127.0.0.1:9990

      10:49:45,475 ERROR [org.jboss.as] (MSC service thread 1-4) JBAS015875: JBoss AS 7.1.1.Final "Brontes" started (with errors) in 80736ms - Started 327 of 431 services (2 services failed or missing dependencies, 100 services are passive or on-demand)

      10:49:46,034 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-connector-infinispan.rar"

      10:49:46,036 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-connector-salesforce.rar"

      10:49:46,036 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-connector-file.rar"

      10:49:46,037 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-connector-google.rar"

      10:49:46,038 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-connector-ldap.rar"

      10:49:46,038 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-connector-ws.rar"