Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4173

Using PI JDBC Adapter, server does not start up using simple queries

    Details

    • Type: Feature Request
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Rejected
    • Affects Version/s: 8.13.3
    • Fix Version/s: None
    • Component/s: JDBC Driver
    • Labels:
    • Environment:

      Issue was discovered using Windows Server 2012 OS and Teiid 8.13.3

      Description

      Using the following model along with the PI JDBC 2015 adapter, the error below was seen at startup of Wildfly.

      <vdb name="PIAF2" version="1">
      <description>OSIsoft PI AF</description>
      <model name="PIAF-Physical" type="PHYSICAL">
      <property name="importer.useFullSchemaName" value="false"/>
      <property name="importer.tableTypes" value="TABLE,VIEW"/>
      <source name="piaf-connector" translator-name="osisoft-pi" connection-jndi-name="java:/pi-ds"/>
      </model>
      <model name="PIAF-Virtual" type="VIRTUAL">
      <metadata type="DDL"><![CDATA[
      CREATE VIEW IceDataTwo (
      tag varchar(max)
      ) AS
      select tag from pipoint.pipoint where tag='sinusoid'
      ]]> </metadata>
      </model>
      </vdb>

      Error:
      21:26:59,420 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Po
      ol – 61) WFLYCLINF0002: Started resultset cache from teiid container
      21:26:59,514 WARN [org.teiid.RUNTIME] (Worker1_async-teiid-threads1) TEIID5003
      6 VDB PIAF2.1 model "PIAF-Virtual" metadata failed to load. Reason:TEIID30386 or
      g.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Enco
      untered "tag varchar([*]max[*]) )" at line 3, column 25.
      Was expecting: <UNSIGNEDINTEGER>: org.teiid.metadata.ParseException: TEIID30386
      org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: En
      countered "tag varchar([*]max[*]) )" at line 3, column 25.
      Was expecting: <UNSIGNEDINTEGER>
      at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:472)
      at org.teiid.metadata.MetadataFactory.parse(MetadataFactory.java:768)
      at org.teiid.query.metadata.DDLMetadataRepository.loadMetadata(DDLMetada
      taRepository.java:40)
      at org.teiid.runtime.AbstractVDBDeployer$MetadataRepositoryWrapper.loadM
      etadata(AbstractVDBDeployer.java:84)
      at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(Chai
      ningMetadataRepository.java:55)
      at org.teiid.jboss.VDBService$6.run(VDBService.java:395)
      at org.teiid.jboss.VDBService$7.run(VDBService.java:446)
      at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkCon
      text.java:276)
      at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.ru
      n(ThreadReuseExecutor.java:119)
      at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseE
      xecutor.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.api.exception.query.QueryParserException: TEIID31100 Parsin
      g error: Encountered "tag varchar([*]max[*]) )" at line 3, column 25.
      Was expecting: <UNSIGNEDINTEGER>
      at org.teiid.query.parser.QueryParser.convertParserException(QueryParser
      .java:214)
      ... 13 more

      21:26:59,514 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Po
      ol – 60) WFLYCLINF0002: Started resultset-repl cache from teiid container
      21:26:59,529 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Po
      ol – 62) WFLYCLINF0002: Started preparedplan cache from teiid container
      21:27:00,732 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50001 Teii
      d Engine 8.13.3 Started = Mon Apr 25 21:27:00 PDT 2016
      21:27:00,951 INFO [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50038 Teii
      d Embedded transport enabled. Bound to: teiid/queryengine/odata
      21:27:00,998 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50038 Teii
      d Embedded transport enabled. Bound to: teiid/queryengine/embedded
      21:27:01,748 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
      read Pool – 65) Deploying javax.ws.rs.core.Application: class org.teiid.odata.
      TeiidODataApplication
      21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
      read Pool – 65) Adding class resource org.odata4j.producer.resources.MetadataR
      esource from Application class org.teiid.odata.TeiidODataApplication
      21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
      read Pool – 65) Adding provider class org.odata4j.producer.resources.ODataBatc
      hProvider from Application class org.teiid.odata.TeiidODataApplication
      21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
      read Pool – 65) Adding provider class org.teiid.odata.TeiidProducerProvider fr
      om Application class org.teiid.odata.TeiidODataApplication
      21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
      read Pool – 65) Adding class resource org.odata4j.producer.resources.EntityReq
      uestResource from Application class org.teiid.odata.TeiidODataApplication
      21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
      read Pool – 65) Adding class resource org.odata4j.producer.resources.EntitiesR
      equestResource from Application class org.teiid.odata.TeiidODataApplication
      21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
      read Pool – 65) Adding provider class org.teiid.odata.ODataExceptionMappingPro
      vider from Application class org.teiid.odata.TeiidODataApplication
      21:27:01,764 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Th
      read Pool – 65) Adding class resource org.odata4j.producer.resources.ServiceDo
      cumentResource from Application class org.teiid.odata.TeiidODataApplication
      21:27:01,951 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50012 Teii
      d JDBC - Name = jdbc, Host = 127.0.0.1, Port = 31000, SSL = OFF, security-domai
      ns = teiid-security
      21:27:01,967 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50037 Teii
      d ODBC - Name = odbc, Host = 127.0.0.1, Port = 35432, SSL = OFF, security-domai
      ns = teiid-security
      21:27:02,076 INFO [org.hibernate.validator.internal.util.Version] (ServerServic
      e Thread Pool – 65) HV000001: Hibernate Validator 5.1.3.Final
      21:27:02,592 INFO [org.teiid.CONNECTOR] (Worker0_async-teiid-threads0) PIExecu
      tionFactory Commit=true;DatabaseProductName=PI SQL Data Access Server 1.4.1.403
      using PIOLEDB;DatabaseProductVersion=PIOLEDB: 3.3.1.2;DriverMajorVersion=1;Drive
      rMajorVersion=4;DriverName=com.osisoft.jdbc.Driver;DriverVersion=1.4.1.404;Isola
      tionLevel=0
      21:27:02,607 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -

      • 65) WFLYUT0021: Registered web context: /odata
        21:27:02,795 INFO [org.jboss.as.server] (ServerService Thread Pool – 35) WFLY
        SRV0010: Deployed "PIJDBCDriver.jar" (runtime-name : "PIJDBCDriver.jar")
        21:27:02,811 INFO [org.jboss.as.server] (ServerService Thread Pool – 35) WFLY
        SRV0010: Deployed "PIAF-vdb.xml" (runtime-name : "PIAF-vdb.xml")
        21:27:02,811 INFO [org.jboss.as.server] (ServerService Thread Pool – 55) WFLY
        SRV0010: Deployed "teiid-olingo-8.13.3-odata4.war" (runtime-name : "teiid-olingo
        -8.13.3-odata4.war")
        21:27:02,811 INFO [org.jboss.as.server] (ServerService Thread Pool – 55) WFLY
        SRV0010: Deployed "teiid-odata-8.13.3-odata2.war" (runtime-name : "teiid-odata-8
        .13.3-odata2.war")
        21:27:03,139 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0060: Http ma
        nagement interface listening on http://127.0.0.1:9990/management
        21:27:03,139 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0051: Admin c
        onsole listening on http://127.0.0.1:9990
        21:27:03,139 INFO [org.jboss.as] (Controller Boot Thread) WFLYSRV0025: WildFly
        Full 9.0.2.Final (WildFly Core 1.0.2.Final) started in 25094ms - Started 596 of
        836 services (305 services are lazy, passive or on-demand)
        21:27:03,920 WARN [org.teiid.RUNTIME] (Worker0_async-teiid-threads0) TEIID5003
        6 VDB PIAF2.1 model "PIAF-Physical" metadata failed to load. Reason:TEIID11010 j
        ava.sql.SQLException: java.lang.Integer cannot be cast to java.lang.Short: org.t
        eiid.translator.TranslatorException: TEIID11010 java.sql.SQLException: java.lang
        .Integer cannot be cast to java.lang.Short
        at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecut
        ionFactory.java:297)
        at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecut
        ionFactory.java:68)
        at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeM
        etadataRepository.java:92)
        at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(Native
        MetadataRepository.java:60)
        at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(Chai
        ningMetadataRepository.java:55)
        at org.teiid.jboss.VDBService$6.run(VDBService.java:395)
        at org.teiid.jboss.VDBService$7.run(VDBService.java:446)
        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkCon
        text.java:276)
        at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.ru
        n(ThreadReuseExecutor.java:119)
        at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseE
        xecutor.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: java.lang.Integer cannot be cast to java.lang.
        Short
        at com.osisoft.jdbc.ResultSetImpl.getShort(ResultSetImpl.java:544)
        at org.teiid.translator.jdbc.JDBCMetdataProcessor.getPrimaryKeys(JDBCMet
        dataProcessor.java:495)
        at org.teiid.translator.jdbc.JDBCMetdataProcessor.getConnectorMetadata(J
        DBCMetdataProcessor.java:162)
        at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecut
        ionFactory.java:295)
        ... 12 more

      21:41:41,551 INFO [org.jboss.as.repository] (ServerService Thread Pool – 63)
      WFLYDR0009: Content C:\apps\teiid-8.13.3\standalone\data\content\14\344c87647a15
      e57fe72a46b9754cd996f71dff is obsolete and will be removed
      21:41:41,551 INFO [org.jboss.as.repository] (ServerService Thread Pool – 63)
      WFLYDR0002: Content removed from location C:\apps\teiid-8.13.3\standalone\data\c
      ontent\14\344c87647a15e57fe72a46b9754cd996f71dff\content

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                asjboss1 Al S
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: