-
Feature Request
-
Resolution: Won't Do
-
Major
-
None
-
8.13.3
-
Issue was discovered using Windows Server 2012 OS and Teiid 8.13.3
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