[JBoss JIRA] (TEIID-4112) ORA-32039: recursive WITH clause must have column alias list
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-4112?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-4112:
------------------------------------------------
jolee(a)redhat.com changed the Status of [bug 1322935|https://bugzilla.redhat.com/show_bug.cgi?id=1322935] from NEW to MODIFIED
> ORA-32039: recursive WITH clause must have column alias list
> ------------------------------------------------------------
>
> Key: TEIID-4112
> URL: https://issues.jboss.org/browse/TEIID-4112
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector, Query Engine
> Affects Versions: 8.7.2.6_2
> Reporter: Debbie Steigner
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5, 8.7.6.6_2
>
>
> If running a WITH table AS(...) query to Oracle and the query schema name is the same as the subquery name i.e. EWI. you receive the Oracle error:
> ORA-32039: recursive WITH clause must have column alias list
> If you modify the query to
> WITH EWI1 AS ....
> then it works.
> f.ex:
> breaking: WITH tbl AS (
> where tbl = a common table name in the current schema and the common table definition as (...) references a view in that schema. Oracle will complain with this erroneous error.
> work-around: WITH tbl_1 AS(
> where tbl_1 does not exist as a current schema/table name.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4151) AssertionError: Delete failed
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4151?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4151:
----------------------------------
Fix Version/s: 8.12.5
> AssertionError: Delete failed
> -----------------------------
>
> Key: TEIID-4151
> URL: https://issues.jboss.org/browse/TEIID-4151
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.11.3
> Reporter: Bram Gadeyne
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5, 8.13.4
>
>
> When using a query like
> insert into #CaresequencesDaily
> some large select;
> delete
> from #CaresequencesDaily
> where datum < (select cast(startime as date) from #period);
> delete
> from #CaresequencesDaily
> where datum > (select cast(endtime as date) from #period);
> We get the following exception on the execution of the second delete query. It seems it does not matter in what order the delete queries are executed.
> Unexpected exception for request lMZm1kGe28/C.24: java.lang.AssertionError: Delete failed
> at org.teiid.query.tempdata.TempTable.deleteTuple(TempTable.java:801) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.tempdata.TempTable.access$500(TempTable.java:83) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.tempdata.TempTable$2.tuplePassed(TempTable.java:775) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.tempdata.TempTable$UpdateProcessor.process(TempTable.java:257) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.tempdata.TempTable.delete(TempTable.java:783) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.tempdata.TempTableDataManager$1.createTupleSource(TempTableDataManager.java:242) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.tempdata.TempTableDataManager$ProxyTupleSource.nextTuple(TempTableDataManager.java:109) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:457) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:339) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:267) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.11.3.jar:8.11.3]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.11.3.jar:8.11.3]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_60]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_60]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_60]
> I've tried to create a reproducable example but this doesn't throw the exception. It might be helpfull to understand what is goiing on.
> insert into #tmp_params
> select parsetimestamp('2016-04-01','yyyy-MM-dd') as starttime, parsetimestamp('2016-04-15','yyyy-MM-dd') as endtime;
> insert into #tmp_dates
> select cast(parsetimestamp('2016-03-20','yyyy-MM-dd') as date) as datum, 'somevalue' as somevalue
> UNION select cast(parsetimestamp('2016-04-02','yyyy-MM-dd') as date) as datum, 'somevalue' as somevalue
> UNION select cast(parsetimestamp('2016-04-20','yyyy-MM-dd') as date) as datum, 'somevalue' as somevalue;
> delete
> from #tmp_dates
> where datum > (select cast(endtime as date) from #tmp_params);
> --error is thrown when executing this second statement
> delete
> from #tmp_dates
> where datum < (select cast(starttime as date) from #tmp_params);
> select *
> from #tmp_dates
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4168) Odd resolving error with implicit temp groups
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4168?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4168:
----------------------------------
Fix Version/s: 8.12.5
> Odd resolving error with implicit temp groups
> ---------------------------------------------
>
> Key: TEIID-4168
> URL: https://issues.jboss.org/browse/TEIID-4168
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.7
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.12.5, 8.13.4
>
>
> If a query expression is used to insert into an implicit temporary table and no columns are specified the resolver will complain when the query column names do not match those defined on the implicit table. For example:
> insert into #tmp_dates ... defines the temp table ...
> insert into #tmp_dates select <some expression>
> Will complain that 'expr1' is not defined by #tmp_dates. Rather the column definitions should be assumed from the earlier statement.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-3557) Can't reload VDB in domain mode
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3557?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3557:
---------------------------------------
No the changes are there. So either there's another eap/jgroups change or this wasn't fully addressed.
> Can't reload VDB in domain mode
> -------------------------------
>
> Key: TEIID-3557
> URL: https://issues.jboss.org/browse/TEIID-3557
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 8.0
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Priority: Critical
> Fix For: 8.7.1.6_2, 8.12, 8.11.1
>
>
> Can't reload VDB in domain mode, get the following error:
> Server throws the following exception:
> [Server:server-one] 12:26:45,678 ERROR [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40088 Could not replicate object org.teiid.query.tempdata.GlobalTableStoreImpl@4e6c9a30: java.lang.IllegalStateException: cluster 'ModeShape.1' is already connected to singleton transport: [dummy-1435055090515, loopback.1, ModeShape.1, loopback-dynamic.1, $TEIID_BM$, dummy-1435055090188, dummy-1435055205654, $TEIID_ED$, teiid-cache, ddl2-vdb.1]
> [Server:server-one] at org.jgroups.stack.ProtocolStack.startStack(ProtocolStack.java:919) [jgroups-3.2.13.Final-redhat-1.jar:3.2.13.Final-redhat-1]
> [Server:server-one] at org.jgroups.JChannel.startStack(JChannel.java:827) [jgroups-3.2.13.Final-redhat-1.jar:3.2.13.Final-redhat-1]
> [Server:server-one] at org.jgroups.JChannel._preConnect(JChannel.java:525) [jgroups-3.2.13.Final-redhat-1.jar:3.2.13.Final-redhat-1]
> [Server:server-one] at org.jgroups.JChannel.connect(JChannel.java:277) [jgroups-3.2.13.Final-redhat-1.jar:3.2.13.Final-redhat-1]
> [Server:server-one] at org.jgroups.JChannel.connect(JChannel.java:268) [jgroups-3.2.13.Final-redhat-1.jar:3.2.13.Final-redhat-1]
> [Server:server-one] at org.teiid.replication.jgroups.JGroupsObjectReplicator.replicate(JGroupsObjectReplicator.java:563) [teiid-runtime-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> [Server:server-one] at org.teiid.deployers.CompositeGlobalTableStore.createInstance(CompositeGlobalTableStore.java:57) [teiid-runtime-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> [Server:server-one] at org.teiid.jboss.VDBService$1.finishedDeployment(VDBService.java:156) [teiid-jboss-integration-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> [Server:server-one] at org.teiid.deployers.VDBRepository.notifyFinished(VDBRepository.java:352) [teiid-runtime-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> [Server:server-one] at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:308) [teiid-runtime-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> [Server:server-one] at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:202) [teiid-runtime-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> [Server:server-one] at org.teiid.jboss.VDBService.access$1100(VDBService.java:85) [teiid-jboss-integration-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> [Server:server-one] at org.teiid.jboss.VDBService$6.run(VDBService.java:411) [teiid-jboss-integration-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> [Server:server-one] at org.teiid.jboss.VDBService$7.run(VDBService.java:442) [teiid-jboss-integration-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> [Server:server-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]
> [Server:server-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]
> [Server:server-one] at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
> [Server:server-one] at org.jboss.threads.JBossThread.run(JBossThread.java:122)
> VDB reload works fine in standalone mode.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-3557) Can't reload VDB in domain mode
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3557?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-3557:
-------------------------------------
So, we need to pull in the change to the respective branch here?
> Can't reload VDB in domain mode
> -------------------------------
>
> Key: TEIID-3557
> URL: https://issues.jboss.org/browse/TEIID-3557
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 8.0
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Priority: Critical
> Fix For: 8.7.1.6_2, 8.12, 8.11.1
>
>
> Can't reload VDB in domain mode, get the following error:
> Server throws the following exception:
> [Server:server-one] 12:26:45,678 ERROR [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40088 Could not replicate object org.teiid.query.tempdata.GlobalTableStoreImpl@4e6c9a30: java.lang.IllegalStateException: cluster 'ModeShape.1' is already connected to singleton transport: [dummy-1435055090515, loopback.1, ModeShape.1, loopback-dynamic.1, $TEIID_BM$, dummy-1435055090188, dummy-1435055205654, $TEIID_ED$, teiid-cache, ddl2-vdb.1]
> [Server:server-one] at org.jgroups.stack.ProtocolStack.startStack(ProtocolStack.java:919) [jgroups-3.2.13.Final-redhat-1.jar:3.2.13.Final-redhat-1]
> [Server:server-one] at org.jgroups.JChannel.startStack(JChannel.java:827) [jgroups-3.2.13.Final-redhat-1.jar:3.2.13.Final-redhat-1]
> [Server:server-one] at org.jgroups.JChannel._preConnect(JChannel.java:525) [jgroups-3.2.13.Final-redhat-1.jar:3.2.13.Final-redhat-1]
> [Server:server-one] at org.jgroups.JChannel.connect(JChannel.java:277) [jgroups-3.2.13.Final-redhat-1.jar:3.2.13.Final-redhat-1]
> [Server:server-one] at org.jgroups.JChannel.connect(JChannel.java:268) [jgroups-3.2.13.Final-redhat-1.jar:3.2.13.Final-redhat-1]
> [Server:server-one] at org.teiid.replication.jgroups.JGroupsObjectReplicator.replicate(JGroupsObjectReplicator.java:563) [teiid-runtime-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> [Server:server-one] at org.teiid.deployers.CompositeGlobalTableStore.createInstance(CompositeGlobalTableStore.java:57) [teiid-runtime-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> [Server:server-one] at org.teiid.jboss.VDBService$1.finishedDeployment(VDBService.java:156) [teiid-jboss-integration-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> [Server:server-one] at org.teiid.deployers.VDBRepository.notifyFinished(VDBRepository.java:352) [teiid-runtime-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> [Server:server-one] at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:308) [teiid-runtime-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> [Server:server-one] at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:202) [teiid-runtime-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> [Server:server-one] at org.teiid.jboss.VDBService.access$1100(VDBService.java:85) [teiid-jboss-integration-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> [Server:server-one] at org.teiid.jboss.VDBService$6.run(VDBService.java:411) [teiid-jboss-integration-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> [Server:server-one] at org.teiid.jboss.VDBService$7.run(VDBService.java:442) [teiid-jboss-integration-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> [Server:server-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]
> [Server:server-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]
> [Server:server-one] at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
> [Server:server-one] at org.jboss.threads.JBossThread.run(JBossThread.java:122)
> VDB reload works fine in standalone mode.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4173) Using PI JDBC Adapter, server does not start up using simple queries
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4173?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-4173.
-----------------------------------
Resolution: Rejected
varchar(max) is not a valid type declaration, as the error message is indicating. You can use an integer length or just use varchar/string as the type.
> Using PI JDBC Adapter, server does not start up using simple queries
> --------------------------------------------------------------------
>
> Key: TEIID-4173
> URL: https://issues.jboss.org/browse/TEIID-4173
> Project: Teiid
> Issue Type: Feature Request
> Components: JDBC Driver
> Affects Versions: 8.13.3
> Environment: Issue was discovered using Windows Server 2012 OS and Teiid 8.13.3
> Reporter: Al S
> Assignee: Steven Hawkins
> Labels: JDBC, PI
>
> 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
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4173) Using PI JDBC Adapter, server does not start up using simple queries
by Al S (JIRA)
Al S created TEIID-4173:
---------------------------
Summary: Using PI JDBC Adapter, server does not start up using simple queries
Key: TEIID-4173
URL: https://issues.jboss.org/browse/TEIID-4173
Project: Teiid
Issue Type: Feature Request
Components: JDBC Driver
Affects Versions: 8.13.3
Environment: Issue was discovered using Windows Server 2012 OS and Teiid 8.13.3
Reporter: Al S
Assignee: Steven Hawkins
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
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4168) Odd resolving error with implicit temp groups
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4168?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4168:
----------------------------------
Affects Version/s: 7.7
> Odd resolving error with implicit temp groups
> ---------------------------------------------
>
> Key: TEIID-4168
> URL: https://issues.jboss.org/browse/TEIID-4168
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.7
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 9.0, 8.13.4
>
>
> If a query expression is used to insert into an implicit temporary table and no columns are specified the resolver will complain when the query column names do not match those defined on the implicit table. For example:
> insert into #tmp_dates ... defines the temp table ...
> insert into #tmp_dates select <some expression>
> Will complain that 'expr1' is not defined by #tmp_dates. Rather the column definitions should be assumed from the earlier statement.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4165) HBase translator - time values are not translated correctly
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4165?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4165:
---------------------------------------
> I have tried it yesterday and it works.
So then we'll at least add a documentation note for this. Otherwise I'm not seeing a code change we should make yet here.
> HBase translator - time values are not translated correctly
> -----------------------------------------------------------
>
> Key: TEIID-4165
> URL: https://issues.jboss.org/browse/TEIID-4165
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.12.x
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
>
> HBase translator rewrites time values (e.g. \{t '15:00:00'\}) as _TIME '1970-01-01 15:00:00.0'_. But HBase stores time values with base date _1900-01-01..._.
> Updated source-specific commands returns correct result.
> {code:sql}
> SELECT g_0.intkey FROM smalla AS g_0 WHERE g_0.timevalue IN (TIME '1900-01-01 05:00:00.0', TIME '1900-01-01 15:00:00.0')
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years