February 2018 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5258) TEIID30151 Error building Source for context item

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5258?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5258. ----------------------------------- Resolution: Duplicate Issue Duplicate of TEIID-5242 > TEIID30151 Error building Source for context item > ------------------------------------------------- > > Key: TEIID-5258 > URL: https://issues.jboss.org/browse/TEIID-5258 > Project: Teiid > Issue Type: Bug > Components: XML Connector > Affects Versions: 10.1 > Environment: teiid-10.1.0 on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final) > Reporter: dalex dalex > Assignee: Steven Hawkins > Attachments: failed.json > > > When running the following script: > {code:sql} > Begin > with t As ( > Select campaign_id, email_address, activity > From ( > call files.getFiles(pathAndPattern => 'failed.json') > ) f > Cross Join > XmlTable ( > '/root/emails' > Passing JsonToXml('root', f.file) > Columns > campaign_id string, > list_id string, > list_is_active boolean, > email_id string, > email_address string, > activity xml > ) x > Where activity Is Not Null > ) > Select * > From t Cross Join XmlTable ( > '/root/activity' > Passing XmlElement(root, t.activity) > Columns > action string, > "timestamp" timestamp, > url string, > ip string > ) a; > End; > {code} > teiid throws out the following error: > {code:noformat} > 2018-02-13 17:55:47,054 WARN [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue7) /okCCfP2/yjh TEIID30020 Processing exception for request /okCCfP2/yjh.0 'TEIID30151 Error building > Source for context item.'. Originally TeiidProcessingException StaxToEventBridge.java:325.: org.teiid.core.TeiidProcessingException: TEIID30151 Error building Source for context item > . > at org.teiid.query.xquery.saxon.XQueryEvaluator.evaluateXQuery(XQueryEvaluator.java:163) > at org.teiid.query.processor.relational.XMLTableNode$1.run(XMLTableNode.java:265) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206) > 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: nu.xom.ParsingException > at nu.xom.Builder.build(Unknown Source) > at nu.xom.Builder.build(Unknown Source) > at org.teiid.query.xquery.saxon.XQueryEvaluator.evaluateXQuery(XQueryEvaluator.java:157) > ... 7 more > Caused by: java.lang.NullPointerException > at net.sf.saxon.evpull.StaxToEventBridge.getSystemId(StaxToEventBridge.java:325) > at net.sf.saxon.evpull.StaxToEventBridge.getSystemId(StaxToEventBridge.java:385) > at net.sf.saxon.event.ContentHandlerProxyLocator.getSystemId(ContentHandlerProxyLocator.java:72) > at nu.xom.XOMHandler.startElement(Unknown Source) > at net.sf.saxon.event.ContentHandlerProxy.startContent(ContentHandlerProxy.java:373) > at org.teiid.query.xquery.saxon.ContentHandlerProxyReceiver.startContent(StreamingUtils.java:291) > at net.sf.saxon.event.ProxyReceiver.startContent(ProxyReceiver.java:177) > at org.teiid.query.xquery.saxon.PathMapFilter.startContent(PathMapFilter.java:226) > at net.sf.saxon.event.TreeReceiver.startContent(TreeReceiver.java:220) > at net.sf.saxon.evpull.EventIteratorToReceiver.copy(EventIteratorToReceiver.java:78) > at net.sf.saxon.event.Sender.sendPullEventSource(Sender.java:559) > at net.sf.saxon.event.Sender.send(Sender.java:132) > at net.sf.saxon.Configuration.buildDocument(Configuration.java:3361) > at net.sf.saxon.Configuration.buildDocument(Configuration.java:3303) > at org.teiid.query.xquery.saxon.SaxonReader.parse(StreamingUtils.java:175) > ... 10 more > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5261) Add support for Teiid Spring vs VDB

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-5261?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-5261: ------------------------------------- [~arvindo] why spring boot? What are you trying to gain by it? You could always use Teiid embedded in any JVM that is Spring Boot app or not. > Add support for Teiid Spring vs VDB > ----------------------------------- > > Key: TEIID-5261 > URL: https://issues.jboss.org/browse/TEIID-5261 > Project: Teiid > Issue Type: Feature Request > Reporter: Arvind Gopinath > Assignee: Steven Hawkins > Priority: Minor > > The virtual View construction happens with Annotations using Teiid Spring Boot. > Without annotations, it will be value added if Teiid Spring Boot supports VDB. > Referring below example to implement the same using Spring Boot - > https://github.com/teiid/wildfly-swarm-teiid-examples/tree/master/vdb-dat... -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5261) Add support for Teiid Spring vs VDB

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5261?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5261: --------------------------------------- Most of the intent of the Spring Boot integration is to bring the vdb development work as close to the code as possible. This would look more like the traditional deployment model - are you thinking less in terms of mapping to pojos and more just providing jdbc/odbc/odata access? > Add support for Teiid Spring vs VDB > ----------------------------------- > > Key: TEIID-5261 > URL: https://issues.jboss.org/browse/TEIID-5261 > Project: Teiid > Issue Type: Feature Request > Reporter: Arvind Gopinath > Assignee: Steven Hawkins > Priority: Minor > > The virtual View construction happens with Annotations using Teiid Spring Boot. > Without annotations, it will be value added if Teiid Spring Boot supports VDB. > Referring below example to implement the same using Spring Boot - > https://github.com/teiid/wildfly-swarm-teiid-examples/tree/master/vdb-dat... -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5255) Assertion failed in MergeJoinStrategy.setProcessingSortRight

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5255?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5255. ----------------------------------- Fix Version/s: 10.1.1 10.0.4 10.2 Resolution: Done This could happen more with 10+ due to TEIID-4208. The change is to not allow the sort operation to throw a blockedexception - which results in the source state being marked as open prematurely. > Assertion failed in MergeJoinStrategy.setProcessingSortRight > ------------------------------------------------------------ > > Key: TEIID-5255 > URL: https://issues.jboss.org/browse/TEIID-5255 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 10.1 > Reporter: Bram Gadeyne > Assignee: Steven Hawkins > Fix For: 10.1.1, 10.0.4, 10.2 > > > 2018-02-12 09:10:44,905 ERROR [org.teiid.PROCESSOR] (Worker35_QueryProcessorQueue538707) Jtb6gbxGtFZG TEIID30019 Unexpected exception for request Jtb6gbxGtFZG.42: java.lang.AssertionError: Assertion failed. > at org.teiid.core.util.Assertion.failed(Assertion.java:69) > at org.teiid.core.util.Assertion.assertTrue(Assertion.java:64) > at org.teiid.core.util.Assertion.assertTrue(Assertion.java:56) > at org.teiid.query.processor.relational.MergeJoinStrategy.setProcessingSortRight(MergeJoinStrategy.java:381) > ... > In the code for this I see this comment: > //it is possible that a delayed open will be called after the parent open > //for now we'll just throw an assertion > The exception occurs while executing this query: > {code:sql} > insert into rep38_results(admissionid, vargroup, vartype, vartime, varenttime, varstrvalue, vardoublevalue, vartimevalue,validated) > select patientid, Labogroep, v.name, sampletime, entertime, stringvalue, varvalue,null,false > from ( > select lc.patientid, lm.Labogroep, lm.name, lc.sampletime, lc.entertime, lc.stringvalue, lc.varvalue, > lc.resultid, lc.ResultNo, > row_number() over(partition by lc.patientid, lc.variableid_nieuw, lc.SampleTime order by lc.ResultID, lc.ResultNo desc) as rang > from rep38_cohort coh > join izisprod.P_GeneralData gd on > gd.PatientID = cast(coh.admissionid as integer) and > gd.Status >= 4 and gd.status <> 5 > join izisprod.U_PV_LabCorrectValues lc on > lc.PatientID = gd.patientid and > BITAND(lc.status, 8) = 8 and > BITAND(lc.status, 2) <> 2 and > lc.sampletime > PARSETIMESTAMP('2013-01-01','yyyy-MM-dd') and > lc.sampletime between coh.studystart and coh.studyend > join izisprod.U_P_LabMapping lm on > lm.labogroep in ('WBC-b','INR','crp-s','Thrombocyten','Lactaat-s') and > lm.VariableID = lc.variableid_oud > UNION ALL > select lc.patientid, lm.Labogroep, lm.name, lc.sampletime, lc.entertime, lc.stringvalue, lc.varvalue, > lc.resultid, lc.ResultNo, > row_number() over(partition by lc.patientid, lc.variableid_nieuw, lc.SampleTime order by lc.ResultID, lc.ResultNo desc) as rang > from rep38_cohort coh > join iziswh.P_GeneralData gd on gd.PatientID = cast(coh.admissionid as integer) > join iziswh.U_PV_LabCorrectValues lc on > lc.PatientID = gd.patientid and > BITAND(lc.status, 8) = 8 and > BITAND(lc.status, 2) <> 2 and > lc.sampletime > PARSETIMESTAMP('2013-01-01','yyyy-MM-dd') and > lc.sampletime between coh.studystart and coh.studyend > join izisprod.U_P_LabMapping lm on > lm.labogroep in ('WBC-b','INR','crp-s','Thrombocyten','Lactaat-s') and > lm.VariableID = lc.variableid_oud > ) v > where v.rang = 1 > order by patientid, Labogroep, SampleTime; > {code} > While writing down this issue, I restarted our server and the issue is now gone so I can't reproduce it at this time. I was also planning on retrieving the SHOWPLAN contents... -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5255) Assertion failed in MergeJoinStrategy.setProcessingSortRight

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5255?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5255: --------------------------------------- I can induce this issue when a specific exception is thrown during the opening of the dependentaccessnode. That is likely what is occurring here - as it can effectively be a timing issue as to whether it is thrown which would make things seem inconsistent. > Assertion failed in MergeJoinStrategy.setProcessingSortRight > ------------------------------------------------------------ > > Key: TEIID-5255 > URL: https://issues.jboss.org/browse/TEIID-5255 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 10.1 > Reporter: Bram Gadeyne > Assignee: Steven Hawkins > > 2018-02-12 09:10:44,905 ERROR [org.teiid.PROCESSOR] (Worker35_QueryProcessorQueue538707) Jtb6gbxGtFZG TEIID30019 Unexpected exception for request Jtb6gbxGtFZG.42: java.lang.AssertionError: Assertion failed. > at org.teiid.core.util.Assertion.failed(Assertion.java:69) > at org.teiid.core.util.Assertion.assertTrue(Assertion.java:64) > at org.teiid.core.util.Assertion.assertTrue(Assertion.java:56) > at org.teiid.query.processor.relational.MergeJoinStrategy.setProcessingSortRight(MergeJoinStrategy.java:381) > ... > In the code for this I see this comment: > //it is possible that a delayed open will be called after the parent open > //for now we'll just throw an assertion > The exception occurs while executing this query: > {code:sql} > insert into rep38_results(admissionid, vargroup, vartype, vartime, varenttime, varstrvalue, vardoublevalue, vartimevalue,validated) > select patientid, Labogroep, v.name, sampletime, entertime, stringvalue, varvalue,null,false > from ( > select lc.patientid, lm.Labogroep, lm.name, lc.sampletime, lc.entertime, lc.stringvalue, lc.varvalue, > lc.resultid, lc.ResultNo, > row_number() over(partition by lc.patientid, lc.variableid_nieuw, lc.SampleTime order by lc.ResultID, lc.ResultNo desc) as rang > from rep38_cohort coh > join izisprod.P_GeneralData gd on > gd.PatientID = cast(coh.admissionid as integer) and > gd.Status >= 4 and gd.status <> 5 > join izisprod.U_PV_LabCorrectValues lc on > lc.PatientID = gd.patientid and > BITAND(lc.status, 8) = 8 and > BITAND(lc.status, 2) <> 2 and > lc.sampletime > PARSETIMESTAMP('2013-01-01','yyyy-MM-dd') and > lc.sampletime between coh.studystart and coh.studyend > join izisprod.U_P_LabMapping lm on > lm.labogroep in ('WBC-b','INR','crp-s','Thrombocyten','Lactaat-s') and > lm.VariableID = lc.variableid_oud > UNION ALL > select lc.patientid, lm.Labogroep, lm.name, lc.sampletime, lc.entertime, lc.stringvalue, lc.varvalue, > lc.resultid, lc.ResultNo, > row_number() over(partition by lc.patientid, lc.variableid_nieuw, lc.SampleTime order by lc.ResultID, lc.ResultNo desc) as rang > from rep38_cohort coh > join iziswh.P_GeneralData gd on gd.PatientID = cast(coh.admissionid as integer) > join iziswh.U_PV_LabCorrectValues lc on > lc.PatientID = gd.patientid and > BITAND(lc.status, 8) = 8 and > BITAND(lc.status, 2) <> 2 and > lc.sampletime > PARSETIMESTAMP('2013-01-01','yyyy-MM-dd') and > lc.sampletime between coh.studystart and coh.studyend > join izisprod.U_P_LabMapping lm on > lm.labogroep in ('WBC-b','INR','crp-s','Thrombocyten','Lactaat-s') and > lm.VariableID = lc.variableid_oud > ) v > where v.rang = 1 > order by patientid, Labogroep, SampleTime; > {code} > While writing down this issue, I restarted our server and the issue is now gone so I can't reproduce it at this time. I was also planning on retrieving the SHOWPLAN contents... -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5255) Assertion failed in MergeJoinStrategy.setProcessingSortRight

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5255?page=com.atlassian.jira.plugin... ] Work on TEIID-5255 started by Steven Hawkins. --------------------------------------------- > Assertion failed in MergeJoinStrategy.setProcessingSortRight > ------------------------------------------------------------ > > Key: TEIID-5255 > URL: https://issues.jboss.org/browse/TEIID-5255 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 10.1 > Reporter: Bram Gadeyne > Assignee: Steven Hawkins > > 2018-02-12 09:10:44,905 ERROR [org.teiid.PROCESSOR] (Worker35_QueryProcessorQueue538707) Jtb6gbxGtFZG TEIID30019 Unexpected exception for request Jtb6gbxGtFZG.42: java.lang.AssertionError: Assertion failed. > at org.teiid.core.util.Assertion.failed(Assertion.java:69) > at org.teiid.core.util.Assertion.assertTrue(Assertion.java:64) > at org.teiid.core.util.Assertion.assertTrue(Assertion.java:56) > at org.teiid.query.processor.relational.MergeJoinStrategy.setProcessingSortRight(MergeJoinStrategy.java:381) > ... > In the code for this I see this comment: > //it is possible that a delayed open will be called after the parent open > //for now we'll just throw an assertion > The exception occurs while executing this query: > {code:sql} > insert into rep38_results(admissionid, vargroup, vartype, vartime, varenttime, varstrvalue, vardoublevalue, vartimevalue,validated) > select patientid, Labogroep, v.name, sampletime, entertime, stringvalue, varvalue,null,false > from ( > select lc.patientid, lm.Labogroep, lm.name, lc.sampletime, lc.entertime, lc.stringvalue, lc.varvalue, > lc.resultid, lc.ResultNo, > row_number() over(partition by lc.patientid, lc.variableid_nieuw, lc.SampleTime order by lc.ResultID, lc.ResultNo desc) as rang > from rep38_cohort coh > join izisprod.P_GeneralData gd on > gd.PatientID = cast(coh.admissionid as integer) and > gd.Status >= 4 and gd.status <> 5 > join izisprod.U_PV_LabCorrectValues lc on > lc.PatientID = gd.patientid and > BITAND(lc.status, 8) = 8 and > BITAND(lc.status, 2) <> 2 and > lc.sampletime > PARSETIMESTAMP('2013-01-01','yyyy-MM-dd') and > lc.sampletime between coh.studystart and coh.studyend > join izisprod.U_P_LabMapping lm on > lm.labogroep in ('WBC-b','INR','crp-s','Thrombocyten','Lactaat-s') and > lm.VariableID = lc.variableid_oud > UNION ALL > select lc.patientid, lm.Labogroep, lm.name, lc.sampletime, lc.entertime, lc.stringvalue, lc.varvalue, > lc.resultid, lc.ResultNo, > row_number() over(partition by lc.patientid, lc.variableid_nieuw, lc.SampleTime order by lc.ResultID, lc.ResultNo desc) as rang > from rep38_cohort coh > join iziswh.P_GeneralData gd on gd.PatientID = cast(coh.admissionid as integer) > join iziswh.U_PV_LabCorrectValues lc on > lc.PatientID = gd.patientid and > BITAND(lc.status, 8) = 8 and > BITAND(lc.status, 2) <> 2 and > lc.sampletime > PARSETIMESTAMP('2013-01-01','yyyy-MM-dd') and > lc.sampletime between coh.studystart and coh.studyend > join izisprod.U_P_LabMapping lm on > lm.labogroep in ('WBC-b','INR','crp-s','Thrombocyten','Lactaat-s') and > lm.VariableID = lc.variableid_oud > ) v > where v.rang = 1 > order by patientid, Labogroep, SampleTime; > {code} > While writing down this issue, I restarted our server and the issue is now gone so I can't reproduce it at this time. I was also planning on retrieving the SHOWPLAN contents... -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5259) Add the ability to override the teiid-alias-naming-cache

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-5259?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-5259: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1545834 Bugzilla Update: Perform > Add the ability to override the teiid-alias-naming-cache > -------------------------------------------------------- > > Key: TEIID-5259 > URL: https://issues.jboss.org/browse/TEIID-5259 > Project: Teiid > Issue Type: Enhancement > Components: JDG Connector > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 10.2 > > > Add the ability to override the teiid-alias-naming-cache that is preset in the logic. This is needed because of the bash rules for not allowing dashes in variable names. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5259) Add the ability to override the teiid-alias-naming-cache

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5259?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5259. ----------------------------------- Fix Version/s: 10.2 Resolution: Done Added org.teiid.aliasCacheName to override the default. > Add the ability to override the teiid-alias-naming-cache > -------------------------------------------------------- > > Key: TEIID-5259 > URL: https://issues.jboss.org/browse/TEIID-5259 > Project: Teiid > Issue Type: Enhancement > Components: JDG Connector > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 10.2 > > > Add the ability to override the teiid-alias-naming-cache that is preset in the logic. This is needed because of the bash rules for not allowing dashes in variable names. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5259) Add the ability to override the teiid-alias-naming-cache

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5259?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5259: ---------------------------------- Git Pull Request: https://github.com/teiid/teiid/pull/1064 [~van.halbert] have a look at the pull request. I can add a doc note if that looks good. > Add the ability to override the teiid-alias-naming-cache > -------------------------------------------------------- > > Key: TEIID-5259 > URL: https://issues.jboss.org/browse/TEIID-5259 > Project: Teiid > Issue Type: Enhancement > Components: JDG Connector > Reporter: Van Halbert > Assignee: Steven Hawkins > > Add the ability to override the teiid-alias-naming-cache that is preset in the logic. This is needed because of the bash rules for not allowing dashes in variable names. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5247) SQL Server translator should support coalesce

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-5247?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-5247: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1545681 Bugzilla Update: Perform > SQL Server translator should support coalesce > --------------------------------------------- > > Key: TEIID-5247 > URL: https://issues.jboss.org/browse/TEIID-5247 > Project: Teiid > Issue Type: Quality Risk > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.0.3, 10.1.1, 10.2 > > > The SQL Server translator is missing support for coalesce. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 1 month

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues February 2018