[JBoss JIRA] (TEIID-4153) OLAPExecutionFactory Exception Unwrapping Results
by Ted Jones (JIRA)
[ https://issues.jboss.org/browse/TEIID-4153?page=com.atlassian.jira.plugin... ]
Ted Jones updated TEIID-4153:
-----------------------------
Attachment: query plan and stack trace 2.txt
Attached query plan and stack trace.
Here is the procedure that is executed:
SELECT
x.zcustid AS cust_id, x.zprdid AS prod_id, x.price AS price, x.quantity AS quantity
FROM
(EXEC sapbw.invokeMDX('SELECT
{[Measures].[058YFS98ML8W8QUZ11JQ6UHM1],[Measures].[058YFS98ML8W8QUZ11JQ6UNXL]} ON COLUMNS,
NON EMPTY CROSSJOIN({[ZCUSTID].LEVELS(01).MEMBERS},{[ZPRDID].LEVELS(01).MEMBERS}) ON ROWS
FROM [ZIC_TEST/Z_CUST_ORDER_LIST]')) AS w, ARRAYTABLE(w.tuple COLUMNS zcustid string, zprdid string, price decimal, quantity decimal) AS x
> OLAPExecutionFactory Exception Unwrapping Results
> -------------------------------------------------
>
> Key: TEIID-4153
> URL: https://issues.jboss.org/browse/TEIID-4153
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.13.3
> Reporter: Ted Jones
> Assignee: Steven Hawkins
> Attachments: query plan and stack trace 2.txt
>
>
> When executing an MDX query against SAP BW (a BEx query), the following exception occurs:
> 11:49:32,573 WARN [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) Connector worker process failed for atomic-request=9WKT1UuAq4j/.0.3.0: org.teiid.translator.TranslatorException: Not a wrapper for: org.olap4j.OlapWrapper
> at org.teiid.translator.olap.OlapExecutionFactory.unwrap(OlapExecutionFactory.java:77)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 11 months
[JBoss JIRA] (TEIID-4153) OLAPExecutionFactory Exception Unwrapping Results
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4153?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4153:
---------------------------------------
How is your data source configured?
> OLAPExecutionFactory Exception Unwrapping Results
> -------------------------------------------------
>
> Key: TEIID-4153
> URL: https://issues.jboss.org/browse/TEIID-4153
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.13.3
> Reporter: Ted Jones
> Assignee: Steven Hawkins
>
> When executing an MDX query against SAP BW (a BEx query), the following exception occurs:
> 11:49:32,573 WARN [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) Connector worker process failed for atomic-request=9WKT1UuAq4j/.0.3.0: org.teiid.translator.TranslatorException: Not a wrapper for: org.olap4j.OlapWrapper
> at org.teiid.translator.olap.OlapExecutionFactory.unwrap(OlapExecutionFactory.java:77)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 11 months
[JBoss JIRA] (TEIID-4153) OLAPExecutionFactory Exception Unwrapping Results
by Ted Jones (JIRA)
Ted Jones created TEIID-4153:
--------------------------------
Summary: OLAPExecutionFactory Exception Unwrapping Results
Key: TEIID-4153
URL: https://issues.jboss.org/browse/TEIID-4153
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 8.13.3
Reporter: Ted Jones
Assignee: Steven Hawkins
When executing an MDX query against SAP BW (a BEx query), the following exception occurs:
11:49:32,573 WARN [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) Connector worker process failed for atomic-request=9WKT1UuAq4j/.0.3.0: org.teiid.translator.TranslatorException: Not a wrapper for: org.olap4j.OlapWrapper
at org.teiid.translator.olap.OlapExecutionFactory.unwrap(OlapExecutionFactory.java:77)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 11 months
[JBoss JIRA] (TEIID-4152) Error: ASSERTION FAILED: expected reference to be not null
by Bram Gadeyne (JIRA)
[ https://issues.jboss.org/browse/TEIID-4152?page=com.atlassian.jira.plugin... ]
Bram Gadeyne commented on TEIID-4152:
-------------------------------------
Hi Steven,
The user query was
select loc.WardAbbr, inf.Patientid, inf.GivenAt, inf.MVGType, inf.pharmaid
from #medcontinf as inf
join MVGPatientLocations as loc on inf.patientid = loc.patientid and loc.datum = inf.GivenAt
join TV_Numbers as TV_1 ON TV_1.nr <= inf.aantal
join TV_Numbers as TV_2 ON TV_1.nr+TV_2.nr*10 <= inf.aantal
#medcontinf is an in memory table.
MVGPatientLocations is a foreign temporary table (located on a MySQL database server)
TV_Numbers is a view
This is the full stack trace:
java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
at org.teiid.core.util.Assertion.failed(Assertion.java:73) [teiid-common-core-8.11.3.jar:8.11.3]
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100) [teiid-common-core-8.11.3.jar:8.11.3]
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92) [teiid-common-core-8.11.3.jar:8.11.3]
at org.teiid.common.buffer.TupleBuffer.getBatch(TupleBuffer.java:286) [teiid-engine-8.11.3.jar:8.11.3]
at org.teiid.common.buffer.TupleBuffer$TupleBufferTupleSource.getBatch(TupleBuffer.java:74) [teiid-engine-8.11.3.jar:8.11.3]
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:62) [teiid-engine-8.11.3.jar:8.11.3]
at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) [teiid-engine-8.11.3.jar:8.11.3]
at org.teiid.query.processor.relational.MergeJoinStrategy.compareToPrevious(MergeJoinStrategy.java:279) [teiid-engine-8.11.3.jar:8.11.3]
at org.teiid.query.processor.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:237) [teiid-engine-8.11.3.jar:8.11.3]
at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.process(EnhancedSortMergeJoinStrategy.java:416) [teiid-engine-8.11.3.jar:8.11.3]
at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:227) [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.LimitNode.nextBatchDirect(LimitNode.java:102) [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.ProjectNode.nextBatchDirect(ProjectNode.java:148) [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]
> Error: ASSERTION FAILED: expected reference to be not null
> ----------------------------------------------------------
>
> Key: TEIID-4152
> URL: https://issues.jboss.org/browse/TEIID-4152
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.11.3
> Reporter: Bram Gadeyne
> Assignee: Steven Hawkins
> Attachments: queryplan.txt
>
>
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 11 months
[JBoss JIRA] (TEIID-3882) Unable to convert Geometry Collection to GeoJSON
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3882?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-3882:
------------------------------------------------
Andrej Smigala <asmigala(a)redhat.com> changed the Status of [bug 1296213|https://bugzilla.redhat.com/show_bug.cgi?id=1296213] from ON_QA to VERIFIED
> Unable to convert Geometry Collection to GeoJSON
> ------------------------------------------------
>
> Key: TEIID-3882
> URL: https://issues.jboss.org/browse/TEIID-3882
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.12.3
> Reporter: Andrej Šmigala
> Assignee: Steven Hawkins
> Fix For: 8.13, 8.12.4
>
>
> Running the following query results in the error below:
> {code:sql}
> select ST_AsGeoJson(ST_GeomFromText('GEOMETRYCOLLECTION(POINT(4 6),LINESTRING(4 6,7 10))')) as g{code}
> It appears that jts2geojson only supports converting geometry collections since version 0.6 (teiid uses version 0.4), compare https://github.com/bjornharrtell/jts2geojson/blob/v0.4.0/src/main/java/or... and https://github.com/bjornharrtell/jts2geojson/blob/0.6.0/src/main/java/org...
> {noformat}
> 16:38:00,967 WARN [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue7) TEIID30020 Processing exception for request SqO0xtySU9j7.0 'TEIID30328 Unable to evaluate ST_AsGeoJson(?): TEIID30384 Error while evaluating function st_asgeojson'. Originally ExpressionEvaluationException GeoJSONWriter.java:35.: org.teiid.api.exception.query.ExpressionEvaluationException: TEIID30328 Unable to evaluate ST_AsGeoJson(?): TEIID30384 Error while evaluating function st_asgeojson
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:695) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.query.rewriter.QueryRewriter.evaluate(QueryRewriter.java:2151) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.query.rewriter.QueryRewriter.rewriteExpressionDirect(QueryRewriter.java:2141) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.query.rewriter.QueryRewriter.access$000(QueryRewriter.java:101) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.query.rewriter.QueryRewriter$3.replaceExpression(QueryRewriter.java:640) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.query.sql.visitor.ExpressionMappingVisitor.visit(ExpressionMappingVisitor.java:157) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.query.sql.symbol.AliasSymbol.acceptVisitor(AliasSymbol.java:90) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:54) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.postVisitVisitor(PreOrPostOrderNavigator.java:61) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:80) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.query.sql.symbol.AliasSymbol.acceptVisitor(AliasSymbol.java:90) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:63) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:76) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:342) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.query.sql.lang.Select.acceptVisitor(Select.java:168) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.query.sql.navigator.PostOrderNavigator.doVisit(PostOrderNavigator.java:40) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.query.rewriter.QueryRewriter.rewriteExpressions(QueryRewriter.java:647) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.query.rewriter.QueryRewriter.rewriteQuery(QueryRewriter.java:484) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.query.rewriter.QueryRewriter.rewriteCommand(QueryRewriter.java:224) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.query.rewriter.QueryRewriter.rewrite(QueryRewriter.java:169) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.query.rewriter.QueryRewriter.rewrite(QueryRewriter.java:173) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:413) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.dqp.internal.process.Request.processRequest(Request.java:463) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:640) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:337) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_65]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_65]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_65]
> Caused by: org.teiid.api.exception.query.FunctionExecutionException: TEIID30384 Error while evaluating function st_asgeojson
> at org.teiid.query.function.FunctionDescriptor.invokeFunction(FunctionDescriptor.java:295) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:1384) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:723) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:693) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> ... 32 more
> Caused by: org.teiid.api.exception.query.FunctionExecutionException
> at org.teiid.query.function.GeometryUtils.geometryToGeoJson(GeometryUtils.java:118) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.query.function.GeometryFunctionMethods.asGeoJson(GeometryFunctionMethods.java:71) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_65]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_65]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_65]
> at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_65]
> at org.teiid.query.function.FunctionDescriptor.invokeFunction(FunctionDescriptor.java:281) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> ... 35 more
> Caused by: java.lang.UnsupportedOperationException
> at org.wololo.jts2geojson.GeoJSONWriter.write(GeoJSONWriter.java:35) [jts2geojson-0.4.0.jar:]
> at org.teiid.query.function.GeometryUtils.geometryToGeoJson(GeometryUtils.java:113) [teiid-engine-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> ... 41 more
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 11 months