March 2016 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2772) Error during import from REST(JSON) with parameters and HTTP Basic authentication

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2772?page=com.atlassian.jira.plu... ] Matus Makovy updated TEIIDDES-2772: ----------------------------------- Attachment: (was: Screen Shot 2016-03-02 at 12.25.47.png) > Error during import from REST(JSON) with parameters and HTTP Basic authentication > --------------------------------------------------------------------------------- > > Key: TEIIDDES-2772 > URL: https://issues.jboss.org/browse/TEIIDDES-2772 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.5 > Environment: MAC > Reporter: Matus Makovy > > When I try to import from REST WS with response type JSON and using basic http authentication querying the resulting procedure fails with exception. > There are two different exceptions that occur when I submit a query like: > {code:sql} > exec procedureName(); > {code} > The first one is: > {code} > 09:24:29,984 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue5) TEIID30019 Unexpected exception for request VybxGbwVwPKO.0: java.lang.ArrayIndexOutOfBoundsException > at java.lang.System.arraycopy(Native Method) [rt.jar:1.8.0_71] > at java.io.PushbackInputStream.unread(PushbackInputStream.java:235) [rt.jar:1.8.0_71] > at org.teiid.query.function.source.XMLSystemFunctions.getJsonReader(XMLSystemFunctions.java:919) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.function.source.XMLSystemFunctions.jsonToXml(XMLSystemFunctions.java:909) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.eval.Evaluator.evaluateParameter(Evaluator.java:1079) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.eval.Evaluator.evaluateParameters(Evaluator.java:1055) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.XMLTableNode.evaluate(XMLTableNode.java:229) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.XMLTableNode.nextBatchDirect(XMLTableNode.java:179) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.NestedTableJoinStrategy.process(NestedTableJoinStrategy.java:119) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:211) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.ProcedurePlan.executePlan(ProcedurePlan.java:568) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.CreateCursorResultSetInstruction.process(CreateCursorResultSetInstruction.java:68) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:360) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:287) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:261) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_71] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_71] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_71] > {code} > and the second one: > {code} > 09:24:33,648 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue8) TEIID30019 Unexpected exception for request vuGT8dEIISNy.0: org.teiid.core.TeiidRuntimeException: Unexpected character (<) at position 0. > at org.teiid.query.function.source.XMLSystemFunctions$JsonToXmlContentHandler.next(XMLSystemFunctions.java:380) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.function.source.XMLSystemFunctions$JsonToXmlContentHandler.peek(XMLSystemFunctions.java:368) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at javax.xml.transform.stax.StAXSource.<init>(StAXSource.java:111) [rt.jar:1.8.0_71] > at org.teiid.query.function.source.XMLSystemFunctions.jsonToXml(XMLSystemFunctions.java:959) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.function.source.XMLSystemFunctions.jsonToXml(XMLSystemFunctions.java:910) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.eval.Evaluator.evaluateParameter(Evaluator.java:1079) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.eval.Evaluator.evaluateParameters(Evaluator.java:1055) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.XMLTableNode.evaluate(XMLTableNode.java:229) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.XMLTableNode.nextBatchDirect(XMLTableNode.java:179) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.NestedTableJoinStrategy.process(NestedTableJoinStrategy.java:119) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:211) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.ProcedurePlan.executePlan(ProcedurePlan.java:568) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.CreateCursorResultSetInstruction.process(CreateCursorResultSetInstruction.java:68) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:360) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:287) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:261) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_71] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_71] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_71] > Caused by: javax.xml.stream.XMLStreamException: Unexpected character (<) at position 0. > at org.teiid.query.function.source.XMLSystemFunctions$JsonToXmlContentHandler.nextEvent(XMLSystemFunctions.java:354) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.function.source.XMLSystemFunctions$JsonToXmlContentHandler.next(XMLSystemFunctions.java:378) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > ... 49 more > Caused by: Unexpected character (<) at position 0. > at org.teiid.json.simple.Yylex.yylex(Yylex.java:612) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.json.simple.JSONParser.nextToken(JSONParser.java:125) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.json.simple.JSONParser.parse(JSONParser.java:185) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.function.source.XMLSystemFunctions$JsonToXmlContentHandler.nextEvent(XMLSystemFunctions.java:350) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > ... 50 more > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2772) Error during import from REST(JSON) with parameters and HTTP Basic authentication

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2772?page=com.atlassian.jira.plu... ] Matus Makovy updated TEIIDDES-2772: ----------------------------------- Attachment: Screen Shot 2016-03-02 at 12.25.47.png > Error during import from REST(JSON) with parameters and HTTP Basic authentication > --------------------------------------------------------------------------------- > > Key: TEIIDDES-2772 > URL: https://issues.jboss.org/browse/TEIIDDES-2772 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.5 > Environment: MAC > Reporter: Matus Makovy > Attachments: Screen Shot 2016-03-02 at 12.25.47.png > > > When I try to import from REST WS with response type JSON and using basic http authentication querying the resulting procedure fails with exception. > There are two different exceptions that occur when I submit a query like: > {code:sql} > exec procedureName(); > {code} > The first one is: > {code} > 09:24:29,984 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue5) TEIID30019 Unexpected exception for request VybxGbwVwPKO.0: java.lang.ArrayIndexOutOfBoundsException > at java.lang.System.arraycopy(Native Method) [rt.jar:1.8.0_71] > at java.io.PushbackInputStream.unread(PushbackInputStream.java:235) [rt.jar:1.8.0_71] > at org.teiid.query.function.source.XMLSystemFunctions.getJsonReader(XMLSystemFunctions.java:919) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.function.source.XMLSystemFunctions.jsonToXml(XMLSystemFunctions.java:909) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.eval.Evaluator.evaluateParameter(Evaluator.java:1079) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.eval.Evaluator.evaluateParameters(Evaluator.java:1055) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.XMLTableNode.evaluate(XMLTableNode.java:229) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.XMLTableNode.nextBatchDirect(XMLTableNode.java:179) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.NestedTableJoinStrategy.process(NestedTableJoinStrategy.java:119) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:211) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.ProcedurePlan.executePlan(ProcedurePlan.java:568) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.CreateCursorResultSetInstruction.process(CreateCursorResultSetInstruction.java:68) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:360) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:287) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:261) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_71] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_71] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_71] > {code} > and the second one: > {code} > 09:24:33,648 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue8) TEIID30019 Unexpected exception for request vuGT8dEIISNy.0: org.teiid.core.TeiidRuntimeException: Unexpected character (<) at position 0. > at org.teiid.query.function.source.XMLSystemFunctions$JsonToXmlContentHandler.next(XMLSystemFunctions.java:380) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.function.source.XMLSystemFunctions$JsonToXmlContentHandler.peek(XMLSystemFunctions.java:368) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at javax.xml.transform.stax.StAXSource.<init>(StAXSource.java:111) [rt.jar:1.8.0_71] > at org.teiid.query.function.source.XMLSystemFunctions.jsonToXml(XMLSystemFunctions.java:959) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.function.source.XMLSystemFunctions.jsonToXml(XMLSystemFunctions.java:910) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.eval.Evaluator.evaluateParameter(Evaluator.java:1079) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.eval.Evaluator.evaluateParameters(Evaluator.java:1055) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.XMLTableNode.evaluate(XMLTableNode.java:229) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.XMLTableNode.nextBatchDirect(XMLTableNode.java:179) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.NestedTableJoinStrategy.process(NestedTableJoinStrategy.java:119) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:211) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.ProcedurePlan.executePlan(ProcedurePlan.java:568) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.CreateCursorResultSetInstruction.process(CreateCursorResultSetInstruction.java:68) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:360) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:287) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:261) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_71] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_71] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_71] > Caused by: javax.xml.stream.XMLStreamException: Unexpected character (<) at position 0. > at org.teiid.query.function.source.XMLSystemFunctions$JsonToXmlContentHandler.nextEvent(XMLSystemFunctions.java:354) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.function.source.XMLSystemFunctions$JsonToXmlContentHandler.next(XMLSystemFunctions.java:378) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > ... 49 more > Caused by: Unexpected character (<) at position 0. > at org.teiid.json.simple.Yylex.yylex(Yylex.java:612) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.json.simple.JSONParser.nextToken(JSONParser.java:125) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.json.simple.JSONParser.parse(JSONParser.java:185) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.function.source.XMLSystemFunctions$JsonToXmlContentHandler.nextEvent(XMLSystemFunctions.java:350) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > ... 50 more > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2772) Error during import from REST(JSON) with parameters and HTTP Basic authentication

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2772?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2772: ---------------------------------------- [~mmakovy] I think you're going to have to add some details on your REST source. The errors are from the server, so we need that info to reproduce. > Error during import from REST(JSON) with parameters and HTTP Basic authentication > --------------------------------------------------------------------------------- > > Key: TEIIDDES-2772 > URL: https://issues.jboss.org/browse/TEIIDDES-2772 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.5 > Environment: MAC > Reporter: Matus Makovy > > When I try to import from REST WS with response type JSON and using basic http authentication querying the resulting procedure fails with exception. > There are two different exceptions that occur when I submit a query like: > {code:sql} > exec procedureName(); > {code} > The first one is: > {code} > 09:24:29,984 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue5) TEIID30019 Unexpected exception for request VybxGbwVwPKO.0: java.lang.ArrayIndexOutOfBoundsException > at java.lang.System.arraycopy(Native Method) [rt.jar:1.8.0_71] > at java.io.PushbackInputStream.unread(PushbackInputStream.java:235) [rt.jar:1.8.0_71] > at org.teiid.query.function.source.XMLSystemFunctions.getJsonReader(XMLSystemFunctions.java:919) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.function.source.XMLSystemFunctions.jsonToXml(XMLSystemFunctions.java:909) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.eval.Evaluator.evaluateParameter(Evaluator.java:1079) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.eval.Evaluator.evaluateParameters(Evaluator.java:1055) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.XMLTableNode.evaluate(XMLTableNode.java:229) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.XMLTableNode.nextBatchDirect(XMLTableNode.java:179) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.NestedTableJoinStrategy.process(NestedTableJoinStrategy.java:119) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:211) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.ProcedurePlan.executePlan(ProcedurePlan.java:568) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.CreateCursorResultSetInstruction.process(CreateCursorResultSetInstruction.java:68) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:360) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:287) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:261) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_71] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_71] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_71] > {code} > and the second one: > {code} > 09:24:33,648 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue8) TEIID30019 Unexpected exception for request vuGT8dEIISNy.0: org.teiid.core.TeiidRuntimeException: Unexpected character (<) at position 0. > at org.teiid.query.function.source.XMLSystemFunctions$JsonToXmlContentHandler.next(XMLSystemFunctions.java:380) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.function.source.XMLSystemFunctions$JsonToXmlContentHandler.peek(XMLSystemFunctions.java:368) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at javax.xml.transform.stax.StAXSource.<init>(StAXSource.java:111) [rt.jar:1.8.0_71] > at org.teiid.query.function.source.XMLSystemFunctions.jsonToXml(XMLSystemFunctions.java:959) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.function.source.XMLSystemFunctions.jsonToXml(XMLSystemFunctions.java:910) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.eval.Evaluator.evaluateParameter(Evaluator.java:1079) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.eval.Evaluator.evaluateParameters(Evaluator.java:1055) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.XMLTableNode.evaluate(XMLTableNode.java:229) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.XMLTableNode.nextBatchDirect(XMLTableNode.java:179) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.NestedTableJoinStrategy.process(NestedTableJoinStrategy.java:119) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:211) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.ProcedurePlan.executePlan(ProcedurePlan.java:568) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.CreateCursorResultSetInstruction.process(CreateCursorResultSetInstruction.java:68) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:360) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:287) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:261) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_71] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_71] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_71] > Caused by: javax.xml.stream.XMLStreamException: Unexpected character (<) at position 0. > at org.teiid.query.function.source.XMLSystemFunctions$JsonToXmlContentHandler.nextEvent(XMLSystemFunctions.java:354) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.function.source.XMLSystemFunctions$JsonToXmlContentHandler.next(XMLSystemFunctions.java:378) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > ... 49 more > Caused by: Unexpected character (<) at position 0. > at org.teiid.json.simple.Yylex.yylex(Yylex.java:612) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.json.simple.JSONParser.nextToken(JSONParser.java:125) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.json.simple.JSONParser.parse(JSONParser.java:185) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > at org.teiid.query.function.source.XMLSystemFunctions$JsonToXmlContentHandler.nextEvent(XMLSystemFunctions.java:350) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6] > ... 50 more > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2797) relational:MATVIEW_TTL has wrong type

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2797?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2797: ---------------------------------------- initial check-in had boolean type instead of integer > relational:MATVIEW_TTL has wrong type > ------------------------------------- > > Key: TEIIDDES-2797 > URL: https://issues.jboss.org/browse/TEIIDDES-2797 > Project: Teiid Designer > Issue Type: Bug > Components: Extension Framework, Modeling > Affects Versions: 10.0 > Reporter: Matus Makovy > Assignee: Barry LaFond > Fix For: 10.0.1 > > > TD shows an error after using: "relational:MATVIEW_TTL" 2000 > {code} > Value "2000" is not an allowed value for property "relational:MATVIEW_TTL." Value was reset to be an empty value. > {code} > After investigation I discovered that TD allows only boolean values for this property. I don't think this is correct. According to Teiid documentation: > _teiid_rel:MATVIEW_TTL - time to live in milliseconds. Provide property or cache hint on view transformation - property takes precedence. _ > In https://github.com/Teiid-Designer/teiid-designer/blob/master/plugins/org.... there is: > {code:xml} > ... > <p:property advanced="false" index="true" masked="false" name="MATVIEW_TTL" required="false" type="boolean"> > <p:description locale="en_US">Time to live in milliseconds. Provide property or cache hint on view transformation - property takes precedence. </p:description> > <p:display locale="en_US">Time To Live (ms)</p:display> > </p:property> > ... > {code} > Type is set to boolean. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2797) relational:MATVIEW_TTL has wrong type

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2797?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2797. ------------------------------------ Resolution: Done master: https://github.com/Teiid-Designer/teiid-designer/commit/eae012c8e1948fdb9... Changed type to integer > relational:MATVIEW_TTL has wrong type > ------------------------------------- > > Key: TEIIDDES-2797 > URL: https://issues.jboss.org/browse/TEIIDDES-2797 > Project: Teiid Designer > Issue Type: Bug > Components: Extension Framework, Modeling > Affects Versions: 10.0 > Reporter: Matus Makovy > Assignee: Barry LaFond > Fix For: 10.0.1 > > > TD shows an error after using: "relational:MATVIEW_TTL" 2000 > {code} > Value "2000" is not an allowed value for property "relational:MATVIEW_TTL." Value was reset to be an empty value. > {code} > After investigation I discovered that TD allows only boolean values for this property. I don't think this is correct. According to Teiid documentation: > _teiid_rel:MATVIEW_TTL - time to live in milliseconds. Provide property or cache hint on view transformation - property takes precedence. _ > In https://github.com/Teiid-Designer/teiid-designer/blob/master/plugins/org.... there is: > {code:xml} > ... > <p:property advanced="false" index="true" masked="false" name="MATVIEW_TTL" required="false" type="boolean"> > <p:description locale="en_US">Time to live in milliseconds. Provide property or cache hint on view transformation - property takes precedence. </p:description> > <p:display locale="en_US">Time To Live (ms)</p:display> > </p:property> > ... > {code} > Type is set to boolean. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2797) relational:MATVIEW_TTL has wrong type

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2797?page=com.atlassian.jira.plu... ] Barry LaFond reassigned TEIIDDES-2797: -------------------------------------- Assignee: Barry LaFond > relational:MATVIEW_TTL has wrong type > ------------------------------------- > > Key: TEIIDDES-2797 > URL: https://issues.jboss.org/browse/TEIIDDES-2797 > Project: Teiid Designer > Issue Type: Bug > Components: Extension Framework, Modeling > Affects Versions: 10.0 > Reporter: Matus Makovy > Assignee: Barry LaFond > Fix For: 10.0.1 > > > TD shows an error after using: "relational:MATVIEW_TTL" 2000 > {code} > Value "2000" is not an allowed value for property "relational:MATVIEW_TTL." Value was reset to be an empty value. > {code} > After investigation I discovered that TD allows only boolean values for this property. I don't think this is correct. According to Teiid documentation: > _teiid_rel:MATVIEW_TTL - time to live in milliseconds. Provide property or cache hint on view transformation - property takes precedence. _ > In https://github.com/Teiid-Designer/teiid-designer/blob/master/plugins/org.... there is: > {code:xml} > ... > <p:property advanced="false" index="true" masked="false" name="MATVIEW_TTL" required="false" type="boolean"> > <p:description locale="en_US">Time to live in milliseconds. Provide property or cache hint on view transformation - property takes precedence. </p:description> > <p:display locale="en_US">Time To Live (ms)</p:display> > </p:property> > ... > {code} > Type is set to boolean. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2797) relational:MATVIEW_TTL has wrong type

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2797?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2797: ----------------------------------- Component/s: Extension Framework Modeling > relational:MATVIEW_TTL has wrong type > ------------------------------------- > > Key: TEIIDDES-2797 > URL: https://issues.jboss.org/browse/TEIIDDES-2797 > Project: Teiid Designer > Issue Type: Bug > Components: Extension Framework, Modeling > Affects Versions: 10.0 > Reporter: Matus Makovy > Fix For: 10.0.1 > > > TD shows an error after using: "relational:MATVIEW_TTL" 2000 > {code} > Value "2000" is not an allowed value for property "relational:MATVIEW_TTL." Value was reset to be an empty value. > {code} > After investigation I discovered that TD allows only boolean values for this property. I don't think this is correct. According to Teiid documentation: > _teiid_rel:MATVIEW_TTL - time to live in milliseconds. Provide property or cache hint on view transformation - property takes precedence. _ > In https://github.com/Teiid-Designer/teiid-designer/blob/master/plugins/org.... there is: > {code:xml} > ... > <p:property advanced="false" index="true" masked="false" name="MATVIEW_TTL" required="false" type="boolean"> > <p:description locale="en_US">Time to live in milliseconds. Provide property or cache hint on view transformation - property takes precedence. </p:description> > <p:display locale="en_US">Time To Live (ms)</p:display> > </p:property> > ... > {code} > Type is set to boolean. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2797) relational:MATVIEW_TTL has wrong type

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2797?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2797: ----------------------------------- Fix Version/s: 10.0.1 > relational:MATVIEW_TTL has wrong type > ------------------------------------- > > Key: TEIIDDES-2797 > URL: https://issues.jboss.org/browse/TEIIDDES-2797 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0 > Reporter: Matus Makovy > Fix For: 10.0.1 > > > TD shows an error after using: "relational:MATVIEW_TTL" 2000 > {code} > Value "2000" is not an allowed value for property "relational:MATVIEW_TTL." Value was reset to be an empty value. > {code} > After investigation I discovered that TD allows only boolean values for this property. I don't think this is correct. According to Teiid documentation: > _teiid_rel:MATVIEW_TTL - time to live in milliseconds. Provide property or cache hint on view transformation - property takes precedence. _ > In https://github.com/Teiid-Designer/teiid-designer/blob/master/plugins/org.... there is: > {code:xml} > ... > <p:property advanced="false" index="true" masked="false" name="MATVIEW_TTL" required="false" type="boolean"> > <p:description locale="en_US">Time to live in milliseconds. Provide property or cache hint on view transformation - property takes precedence. </p:description> > <p:display locale="en_US">Time To Live (ms)</p:display> > </p:property> > ... > {code} > Type is set to boolean. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2697) Virtual procedure in generated dynamic VDB does not return result set

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2697?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2697. ------------------------------------ Resolution: Done TEIIDDES-2798 was fixed. > Virtual procedure in generated dynamic VDB does not return result set > --------------------------------------------------------------------- > > Key: TEIIDDES-2697 > URL: https://issues.jboss.org/browse/TEIIDDES-2697 > Project: Teiid Designer > Issue Type: Bug > Components: VDB & Execution > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Fix For: 10.0.1, 9.2.1, 9.2 > > Attachments: DynamicProcedureProject.zip > > > When a VDB containing view model with a virtual procedure is exported as a dynamic VDB, the virtual procedure does not return any results. This is because the generated DDL does not contain the RETURNS clause. > Generated DDL: > {code:sql} > CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) > AS > BEGIN > SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out; > END; > {code} > Expected DDL: > {code:sql} > CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) RETURNS TABLE ( xml_out xml) > AS > BEGIN > SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out; > END; > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2798) Dynamic VDB can not be generated - view model with procedure

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2798?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2798. ------------------------------------ Resolution: Done master: https://github.com/Teiid-Designer/teiid-designer/commit/3720838ccb548b9fe... > Dynamic VDB can not be generated - view model with procedure > ------------------------------------------------------------ > > Key: TEIIDDES-2798 > URL: https://issues.jboss.org/browse/TEIIDDES-2798 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Patch Release > Affects Versions: 10.0 > Reporter: Matus Makovy > Assignee: Barry LaFond > Priority: Blocker > Fix For: 10.0.1 > > Attachments: DynamicProcedureProject.zip, Screen Shot 2016-03-01 at 15.33.04.png, Screen Shot 2016-03-01 at 15.34.09.png > > > VDB from project that is attached can not be exported to dynamic VDB. > This *doesn't work* with TD 10.0.0.*Beta3*, but it +worked+ with +Beta2+. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues March 2016