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

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

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Won't Do
    • Major
    • None
    • 8.13.3
    • JDBC Driver

    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

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            asjboss1 Al S (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: