4 Replies Latest reply on Dec 20, 2012 10:01 AM by Steven Hawkins

    teiid 8.2 single datasource (jtds) dynamic vdb deploying gets error TEIID11006

    Marco Ardito Master

      Hi,

       

      i managed to install a few jdbc drivers i need in my project, mysql and jtds (for mssql)

       

      i can see them in the web admin console and in profile > datasource i can test their conections with the button there, tha answer is (eg)

       

      "Successfully connected to database testmysql." and the same goes for jtds datasource

       

      if I fresh start AS7 (with -c standalone-teiid.xml) i get this server log

       

      17:34:31,175 INFO  [org.jboss.as.configadmin] (ServerService Thread Pool -- 27) JBAS016200: Activating ConfigAdmin Subsystem
      
      17:34:31,221 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 28) JBAS010403: Deploying JDBC-compliant driver class org.h2.Driver (version 1.3)
      
      17:34:31,282 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 32) JBAS010280: Activating Infinispan subsystem.
      
      17:34:31,304 INFO  [org.jboss.as.connector] (MSC service thread 1-4) JBAS010408: Starting JCA Subsystem (JBoss IronJacamar 1.0.9.Final)
      
      17:34:31,308 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 28) JBAS010404: Deploying non-JDBC-compliant driver class org.teiid.jdbc.TeiidDriver (version 8.2)
      
      17:34:31,330 INFO  [org.jboss.as.naming] (ServerService Thread Pool -- 39) JBAS011800: Activating Naming Subsystem
      
      17:34:31,331 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 28) JBAS010404: Deploying non-JDBC-compliant driver class org.teiid.jdbc.TeiidDriver (version 8.2)
      
      17:34:31,320 INFO  [org.jboss.as.security] (ServerService Thread Pool -- 45) JBAS013101: Activating Security Subsystem
      
      17:34:31,475 INFO  [org.jboss.as.osgi] (ServerService Thread Pool -- 40) JBAS011940: Activating OSGi Subsystem
      
      17:34:31,496 INFO  [org.jboss.as.webservices] (ServerService Thread Pool -- 50) JBAS015537: Activating WebServices Extension
      
      17:34:31,669 INFO  [org.jboss.as.security] (MSC service thread 1-4) JBAS013100: Current PicketBox version=4.0.7.Final
      
      17:34:31,715 INFO  [org.jboss.as.naming] (MSC service thread 1-3) JBAS011802: Starting Naming Service
      
      17:34:31,908 INFO  [org.jboss.as.mail.extension] (MSC service thread 1-3) JBAS015400: Bound mail session [java:jboss/mail/Default]
      
      17:34:31,952 INFO  [org.jboss.ws.common.management.AbstractServerConfig] (MSC service thread 1-4) JBoss Web Services - Stack CXF Server 4.0.2.GA
      
      17:34:32,060 INFO  [org.teiid.SECURITY] (ServerService Thread Pool -- 46) TEIID50011 Security enabled for transport "jdbc" with security-domain set to teiid-security
      
      17:34:32,105 INFO  [org.teiid.SECURITY] (ServerService Thread Pool -- 46) TEIID50011 Security enabled for transport "odbc" with security-domain set to teiid-security
      
      17:34:32,327 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "access" added.
      
      17:34:32,357 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "db2" added.
      
      17:34:32,376 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "derby" added.
      
      17:34:32,391 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "file" added.
      
      17:34:32,403 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "google-spreadsheet" added.
      
      17:34:32,430 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "h2" added.
      
      17:34:32,438 INFO  [org.infinispan.factories.GlobalComponentRegistry] (pool-12-thread-1) ISPN000128: Infinispan version: Infinispan 'Brahma' 5.1.2.FINAL
      
      17:34:32,446 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "hive" added.
      
      17:34:32,464 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "hsql" added.
      
      17:34:32,476 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "infinispan-cache" added.
      
      17:34:32,492 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "informix" added.
      
      17:34:32,508 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "ingres" added.
      
      17:34:32,528 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "ingres93" added.
      
      17:34:32,566 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "intersystems-cache" added.
      
      17:34:32,572 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "jdbc-ansi" added.
      
      17:34:32,578 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "jdbc-simple" added.
      
      17:34:32,588 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "jpa2" added.
      
      17:34:32,596 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "ldap" added.
      
      17:34:32,603 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "loopback" added.
      
      17:34:32,612 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "map-cache" added.
      
      17:34:32,626 INFO  [org.infinispan.jmx.CacheJmxRegistration] (pool-12-thread-1) ISPN000031: MBeans were successfully registered to the platform mbean server.
      
      17:34:32,637 INFO  [org.jboss.as.clustering.infinispan] (pool-12-thread-1) JBAS010281: Started preparedplan cache from teiid container
      
      17:34:32,639 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "metamatrix" added.
      
      17:34:32,664 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "modeshape" added.
      
      17:34:32,685 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "mysql" added.
      
      17:34:32,709 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "mysql5" added.
      
      17:34:32,736 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "netezza" added.
      
      17:34:32,744 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "olap" added.
      
      17:34:32,797 INFO  [org.apache.coyote.http11.Http11Protocol] (MSC service thread 1-1) Starting Coyote HTTP/1.1 on http--127.0.0.1-8080
      
      17:34:32,808 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "oracle" added.
      
      17:34:33,005 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "postgresql" added.
      
      17:34:33,017 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "salesforce" added.
      
      17:34:33,046 INFO  [org.infinispan.jmx.CacheJmxRegistration] (pool-11-thread-1) ISPN000031: MBeans were successfully registered to the platform mbean server.
      
      17:34:33,067 INFO  [org.jboss.as.clustering.infinispan] (pool-11-thread-1) JBAS010281: Started resultset-repl cache from teiid container
      
      17:34:33,064 INFO  [org.infinispan.jmx.CacheJmxRegistration] (pool-10-thread-1) ISPN000031: MBeans were successfully registered to the platform mbean server.
      
      17:34:33,060 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "sqlserver" added.
      
      17:34:33,079 INFO  [org.jboss.as.clustering.infinispan] (pool-10-thread-1) JBAS010281: Started resultset cache from teiid container
      
      17:34:33,076 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-4) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS]
      
      17:34:33,119 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "sybase" added.
      
      17:34:33,156 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "teiid" added.
      
      17:34:33,200 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "teradata" added.
      
      17:34:33,220 INFO  [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50001 Teiid Engine 8.2.0.Final Started = Wed Dec 19 17:34:33 CET 2012
      
      17:34:33,222 INFO  [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50006 Teiid translator "ws" added.
      
      17:34:33,231 INFO  [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50038 Teiid Embedded transport enabled. Bound to: teiid/queryengine
      
      17:34:33,321 INFO  [org.jboss.as.server.deployment.scanner] (MSC service thread 1-1) JBAS015012: Started FileSystemDeploymentService for directory D:\sviluppo\jboss-as-7.1.1.Final\standalone\deployments
      
      17:34:33,348 INFO  [org.jboss.as.remoting] (MSC service thread 1-2) JBAS017100: Listening on /127.0.0.1:9999
      
      17:34:33,353 INFO  [org.jboss.as.remoting] (MSC service thread 1-2) JBAS017100: Listening on /127.0.0.1:4447
      
      17:34:33,396 INFO  [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50012 Teiid JDBC - Host = 127.0.0.1,  Port = 31000, SSL = OFF, security-domains = [teiid-security]
      
      17:34:33,402 INFO  [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50037 Teiid ODBC - Host = 127.0.0.1,  Port = 35432, SSL = OFF, security-domains = [teiid-security]
      
      17:34:33,835 INFO  [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service status report
      
      JBAS014775:    New missing/unsatisfied dependencies:
      
            service jboss.jdbc-driver.jtds-1_3_0_jar (missing) dependents: [service jboss.data-source.java:/magoDS] 
      
            service jboss.jdbc-driver.mysql-connector-java-5_1_22-bin_jar (missing) dependents: [service jboss.data-source.java:/testmysql] 
      
      
      
      17:34:33,885 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "mysql-connector-java-5.1.22-bin.jar"
      
      17:34:33,885 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015876: Starting deployment of "teiid-connector-file.rar"
      
      17:34:33,885 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015876: Starting deployment of "postgresql-9.2-1002.jdbc4.jar"
      
      17:34:33,885 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-4) JBAS015876: Starting deployment of "teiid-connector-ldap.rar"
      
      17:34:33,899 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015876: Starting deployment of "teiid-connector-google.rar"
      
      17:34:33,902 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "teiid-connector-salesforce.rar"
      
      17:34:33,905 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-4) JBAS015876: Starting deployment of "teiid-connector-infinispan.rar"
      
      17:34:33,906 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015876: Starting deployment of "teiid-connector-ws.rar"
      
      17:34:33,903 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015876: Starting deployment of "jtds-1.3.0.jar"
      
      17:34:34,158 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-4) 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.
      
      17:34:34,164 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-4) 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.
      
      17:34:34,192 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-2) 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.
      
      17:34:34,204 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-2) 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.
      
      17:34:34,212 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-2) 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.
      
      17:34:34,220 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-2) 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.
      
      17:34:34,228 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-2) 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.
      
      17:34:34,234 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-2) 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.
      
      17:34:34,198 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-3) 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.
      
      17:34:34,248 WARN  [org.jboss.as.dependency.private] (MSC service thread 1-3) 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.
      
      17:34:34,259 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-4) JBAS010404: Deploying non-JDBC-compliant driver class net.sourceforge.jtds.jdbc.Driver (version 1.3)
      
      17:34:34,276 INFO  [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-3) IJ020001: Required license terms for file:/D:/sviluppo/jboss-as-7.1.1.Final/standalone/tmp/vfs/temp10820f970459d443/teiid-connector-salesforce.rar-686184ca752d7d6a/contents/
      
      17:34:34,282 INFO  [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-4) IJ020001: Required license terms for file:/D:/sviluppo/jboss-as-7.1.1.Final/standalone/tmp/vfs/temp10820f970459d443/teiid-connector-ldap.rar-a0a91b7a34f299c2/contents/
      
      17:34:34,278 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-1) JBAS010404: Deploying non-JDBC-compliant driver class com.mysql.jdbc.Driver (version 5.1)
      
      17:34:34,302 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-2) JBAS010404: Deploying non-JDBC-compliant driver class org.postgresql.Driver (version 9.2)
      
      17:34:34,304 INFO  [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-1) IJ020001: Required license terms for file:/D:/sviluppo/jboss-as-7.1.1.Final/standalone/tmp/vfs/temp10820f970459d443/teiid-connector-file.rar-a9e97dd3da3c12ce/contents/
      
      17:34:34,310 INFO  [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/D:/sviluppo/jboss-as-7.1.1.Final/standalone/tmp/vfs/temp10820f970459d443/teiid-connector-google.rar-36c6e3f2853de40/contents/
      
      17:34:34,335 INFO  [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-3) IJ020001: Required license terms for file:/D:/sviluppo/jboss-as-7.1.1.Final/standalone/tmp/vfs/temp10820f970459d443/teiid-connector-infinispan.rar-cf04bb9e7009f748/contents/
      
      17:34:34,338 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-1) JBAS010400: Bound data source [java:/magoDS]
      
      17:34:34,346 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-1) JBAS010400: Bound data source [java:/testmysql]
      
      17:34:34,336 INFO  [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-4) IJ020001: Required license terms for file:/D:/sviluppo/jboss-as-7.1.1.Final/standalone/tmp/vfs/temp10820f970459d443/teiid-connector-ws.rar-4fe8e2769d4f91a7/contents/
      
      17:34:34,363 INFO  [org.jboss.as] (MSC service thread 1-3) JBAS015951: Admin console listening on http://127.0.0.1:9990
      
      17:34:34,365 INFO  [org.jboss.as] (MSC service thread 1-3) JBAS015874: JBoss Teiid 8.2.Beta2 (AS 7.1.1.Final) started in 4606ms - Started 396 of 505 services (106 services are passive or on-demand)
      
      17:34:34,718 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-connector-ws.rar"
      
      17:34:34,720 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-connector-salesforce.rar"
      
      17:34:34,721 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-connector-ldap.rar"
      
      17:34:34,724 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-connector-infinispan.rar"
      
      17:34:34,725 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-connector-google.rar"
      
      17:34:34,726 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-connector-file.rar"
      
      17:34:34,728 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "postgresql-9.2-1002.jdbc4.jar"
      
      17:34:34,730 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "mysql-connector-java-5.1.22-bin.jar"
      
      17:34:34,733 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "jtds-1.3.0.jar"
      
      17:34:34,735 INFO  [org.jboss.as.controller] (DeploymentScanner-threads - 2) JBAS014774: Service status report
      
      JBAS014776:    Newly corrected services:
      
            service jboss.jdbc-driver.jtds-1_3_0_jar (no longer required)
      
            service jboss.jdbc-driver.mysql-connector-java-5_1_22-bin_jar (no longer required)
      

       

      now i would like to go step-by-step and create the simplest dynamic vdb (xml)

       

      if i try something like this "test-vdb.xml" file

       

       

      <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
      <vdb name="Testmysql" version="1">
          <description>Test VDB</description>
          <property name="UseConnectorMetadata" value="true" />
           <model name="Testmysql">
              <property name="importer.useFullSchemaName" value="false"/>
              <source name="mysql5-connector" translator-name="mysql5" connection-jndi-name="java:/testmysql"/>
          </model>
      </vdb>
      

       

      and copy this file into standalone/deployments i have after a while a "test-vdb.xml.deployed" appears,

       

      in the web console i can see under runtime > manage deployments > a test-vdb.xml deployed and enabled as "File System Deployment"

      enabled

       

      and in the server log i have

       

      17:44:50,289 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "test-vdb.xml"
      
      17:44:50,693 INFO  [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50029 VDB Testmysql.1 model "Testmysql" metadata is currently being loaded. Start Time: 19/12/12 17.44
      
      17:44:50,830 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 1) JBAS018559: Deployed "test-vdb.xml"
      
      17:44:50,835 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50030 VDB Testmysql.1 model "Testmysql" metadata loaded. End Time: 19/12/12 17.44
      
      17:44:50,840 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40003 VDB Testmysql.1 is set to ACTIVE
      

       

      and all is fine and sun shines and also connecting from squirrel with teiid 8.2 client driver works... with user/user

       

      then i try the same for the other (jtds) datasource, "mssql-vdb.xml"

       

      <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
      <vdb name="TestMSsql" version="1">
          <description>Test MSSQL VDB</description>
          <property name="UseConnectorMetadata" value="true" />
           <model name="TestMSsql">
              <property name="importer.useFullSchemaName" value="false"/>
              <source name="sqlserver-connector" translator-name="sqlserver" connection-jndi-name="java:/magoDS"/>
          </model>
      </vdb>
      

       

      which seems to deploy "mssql-vdb.xml.deployed" is there in standalone/deployements

       

      but from the web admin console i see that the TestMSsql VDB is always LOADING and is marked not valid (X)

       

      and has errors:

       

      TEIID11006 Teiid runtime names, which are case insensitive, for the imported metadata are not unique.  If not already set, use the setting importer.useFullSchemaName to create Teiid names that include the source schema.
      

       

      btw the jtds datasource is (created from the web console, and yes the user "ro" has no password, atm)

       

      <datasource jta="false" jndi-name="java:/magoDS" pool-name="magoDS" enabled="true" use-ccm="false">
          <connection-url>jdbc:jtds:sqlserver://magonet/ApiMn</connection-url>
          <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
          <driver>jtds-1.3.0.jar</driver>
          <security>
              <user-name>ro</user-name>
          </security>
          <validation>
              <validate-on-match>false</validate-on-match>
              <background-validation>false</background-validation>
          </validation>
          <statement>
              <share-prepared-statements>false</share-prepared-statements>
          </statement>
      </datasource>
      

       

      the server.log says (until i undeploy it)

       

      18:04:11,840 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "mssql-vdb.xml"
      18:04:11,878 INFO  [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50029 VDB TestMSsql.1 model "TestMSsql" metadata is currently being loaded. Start Time: 19/12/12 18.04
      18:04:11,982 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "mssql-vdb.xml"
      18:04:12,496 WARN  [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID50036 VDB TestMSsql.1 model "TestMSsql" metadata failed to load. Reason:TEIID11006 Teiid runtime names, which are case insensitive, for the imported metadata are not unique.  If not already set, use the setting importer.useFullSchemaName to create Teiid names that include the source schema.
      18:06:37,157 INFO  [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50026 VDB "TestMSsql.1[TestMSsql{sqlserver-connector=sqlserver-connector, sqlserver, java:/magoDS}]" undeployed.
      18:06:37,166 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015877: Stopped deployment mssql-vdb.xml in 14ms
      18:06:37,255 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 1) JBAS018558: Undeployed "mssql-vdb.xml"
      

       

       

      and i'm stuck, again ? can't get a clue on what teiid/as7 is complaining  of? what are Teiid runtime names? and how can i check where is some  duplication of those names?

       

      iv're read this, it seems similar, https://bugzilla.redhat.com/show_bug.cgi?format=multiple&id=781065

      but didn''tget what can mean to me and my case

       

      Hope it's no newbie thing again,

       

      Thanks for any help,

      Marco

        • 1. Re: teiid 8.2 single datasource (jtds) dynamic vdb deploying gets error TEIID11006
          Steven Hawkins Master

          > but from the web admin console i see that the TestMSsql VDB is always LOADING and is marked not valid (X)

           

          it should be marked as a failed deployment.  we'll have to check to see if the console is reporting that appropriately or if something else is going on.

           

          > and i'm stuck, again ? can't get a clue on what teiid/as7 is complaining  of? what are Teiid runtime names? and how can i check where is some  duplication of those names?

           

          The runtime name is what the database object is called in Teiid.  The conversion from a source fully qualified name to a Teiid name involves a couple of considerations, which are mostly determined by translator settings - see the Reference for more on JDBC import properties.  The exception is telling you that with

           

          "<property name="importer.useFullSchemaName" value="false"/>"

           

          there are two tables that have the same base name being imported into the same model/schema in Teiid.  This is likely if you're import is pulling from multiple source schemas and you have tables like schema1.tbl and schema2.tbl, thus Teiid is trying to create model.tbl and then sees a conflict with the second table.  If you set useFullSchmeaName to true (or just remove the false setting since it defaults to true), then Teiid will import the tables as something like model.schema1.tbl and model.schema2.tbl so that the runtime names will not conflict.  In this case the runtime table name is effectively "shema1.tbl", but when there is no ambiguity, you are still allowed to resolve against it as tbl, so it is generally advisable to leave useFullSchemaName as true.

          • 2. Re: teiid 8.2 single datasource (jtds) dynamic vdb deploying gets error TEIID11006
            Marco Ardito Master

            Oh, Thanks, again.

            I will try setting that option to "true", i just was sticking to the example "portfolio-vdb.xml" example as much as possibile to learn step by step all the features

             

            The database i'm trying to access is mssql and is part of a commercial ERP application, and fof its DB i have no docs or info at all, but i can access it through MSSQL manager

            There I see that the ApiMn database, which the datasource is referring to, has over 400 tables and in security > schema it has about 14 different schemas.

            All the tables and views seems to be prepended by a "dbo." prefix which is also one of those schemas (eg: msaccess links those tables prepending "dbo_" to the linked table name)

             

            I know only a little about the rdbms and this db in particular, and i know this is not a mssql forum but, assuming that i wish to restrict the datasource to the tables of the "dbo" schema, is there any way to restrict the datasource to its tables?

             

            i will try with importer.useFullSchemaName ="true" anyway,

             

            Thx

            Marco

            • 3. Re: teiid 8.2 single datasource (jtds) dynamic vdb deploying gets error TEIID11006
              Marco Ardito Master

              i tried with importer.useFullSchemaName ="true", and it worked, as you said, i can connect from squirrel sql client with teiid client driver

               

              as for the "loading" issue... I tried also to hit the refresh button several times, after the TEIID11006 error appears in the server log

              bu it stays "loading"

               

              i attached a screenshot confirming this

               

              i have another minor GUI glitch, at least on my system, should i report it here i nanother post or better directly in the bug tracker (jira?)

               

              Thanks, Marco

              • 4. Re: teiid 8.2 single datasource (jtds) dynamic vdb deploying gets error TEIID11006
                Steven Hawkins Master

                Marco,

                 

                Thanks for the screenshoot.  I logged https://issues.jboss.org/browse/TEIID-2330 for the console showing LOADING.

                 

                > i have another minor GUI glitch, at least on my system, should i report it here i nanother post or better directly in the bug tracker (jira?)

                 

                If it's obviously an issue, then just log it.  Otherwise a post first could help clarify.

                 

                Steve