[JBoss JIRA] (TEIID-3663) ST_Transform only works in tests
by Johnathon Lee (JIRA)
[ https://issues.jboss.org/browse/TEIID-3663?page=com.atlassian.jira.plugin... ]
Johnathon Lee updated TEIID-3663:
---------------------------------
Fix Version/s: 8.7.2.6_2
> ST_Transform only works in tests
> --------------------------------
>
> Key: TEIID-3663
> URL: https://issues.jboss.org/browse/TEIID-3663
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.11
> Reporter: Tom Arnold
> Assignee: Steven Hawkins
> Fix For: 8.12, 8.11.3, 8.7.2.6_2
>
>
> From one of the tests; this fails against an actual server (JBoss kit).
> {code}
> select st_transform(st_geomfromtext('POINT(-118 34)',4326),3310);
> {code}
> {code}
> ERROR: TEIID30328 Unable to evaluate st_transform(?, 3310): TEIID30384 Error while evaluating function st_transform
> DETAIL: org.teiid.jdbc.TeiidSQLException: TEIID30328 Unable to evaluate st_transform(?, 3310): TEIID30384 Error while evaluating function st_transform
> {code}
> {code}
> 00:02:59,143 INFO [org.teiid.SECURITY] (Worker2_QueryProcessorQueue6) tF6aPUsmLmU/ TEIID40115 Local pass-through connection implicitly closing session tF6aPUsmLmU/ so that the connection can be used in a different security context.
> 00:02:59,144 WARN [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue6) tF6aPUsmLmU/ TEIID30020 Processing exception for request tF6aPUsmLmU/.4 'TEIID30328 Unable to evaluate st_transform(?, 3310): TEIID30384 Error while evaluating function st_transform'. Originally ExpressionEvaluationException 'Expected argument to be non-null but got null' ArgCheck.java:303.: org.teiid.api.exception.query.ExpressionEvaluationException: TEIID30328 Unable to evaluate st_transform(?, 3310): TEIID30384 Error while evaluating function st_transform
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:631) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.rewriter.QueryRewriter.evaluate(QueryRewriter.java:2122) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.rewriter.QueryRewriter.rewriteExpressionDirect(QueryRewriter.java:2112) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.rewriter.QueryRewriter.access$000(QueryRewriter.java:101) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.rewriter.QueryRewriter$3.replaceExpression(QueryRewriter.java:626) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.sql.visitor.ExpressionMappingVisitor.visit(ExpressionMappingVisitor.java:162) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.sql.symbol.ExpressionSymbol.acceptVisitor(ExpressionSymbol.java:63) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:54) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.postVisitVisitor(PreOrPostOrderNavigator.java:61) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:183) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.sql.symbol.ExpressionSymbol.acceptVisitor(ExpressionSymbol.java:63) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:63) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:76) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:342) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.sql.lang.Select.acceptVisitor(Select.java:168) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.sql.navigator.PostOrderNavigator.doVisit(PostOrderNavigator.java:40) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.rewriter.QueryRewriter.rewriteExpressions(QueryRewriter.java:633) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.rewriter.QueryRewriter.rewriteQuery(QueryRewriter.java:471) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.rewriter.QueryRewriter.rewriteCommand(QueryRewriter.java:222) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.rewriter.QueryRewriter.rewrite(QueryRewriter.java:167) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.rewriter.QueryRewriter.rewrite(QueryRewriter.java:171) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:413) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.Request.processRequest(Request.java:461) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:632) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:333) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:271) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_79]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_79]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_79]
> Caused by: org.teiid.api.exception.query.FunctionExecutionException: TEIID30384 Error while evaluating function st_transform
> at org.teiid.query.function.FunctionDescriptor.invokeFunction(FunctionDescriptor.java:295) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:1320) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:659) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:629) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> ... 32 more
> Caused by: org.teiid.api.exception.query.FunctionExecutionException: 38000 TEIID31163 Failed to lookup proj4 text.
> at org.teiid.query.function.GeometryTransformUtils.lookupProj4Text(GeometryTransformUtils.java:109) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.function.GeometryTransformUtils.transform(GeometryTransformUtils.java:78) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.function.GeometryTransformUtils.transform(GeometryTransformUtils.java:64) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.function.GeometryFunctionMethods.transform(GeometryFunctionMethods.java:253) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_79]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_79]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_79]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_79]
> at org.teiid.query.function.FunctionDescriptor.invokeFunction(FunctionDescriptor.java:281) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> ... 35 more
> Caused by: org.teiid.jdbc.TeiidSQLException: Expected argument to be non-null but got null
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) [teiid-client-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) [teiid-client-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:671) [teiid-client-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:535) [teiid-client-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) [teiid-client-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:73) [teiid-client-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.function.GeometryTransformUtils.lookupProj4Text(GeometryTransformUtils.java:103) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> ... 43 more
> Caused by: org.teiid.core.TeiidComponentException: Expected argument to be non-null but got null
> at org.teiid.client.util.ExceptionUtil.convertException(ExceptionUtil.java:65) [teiid-client-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:186) [teiid-runtime-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at com.sun.proxy.$Proxy18.executeRequest(Unknown Source)
> at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:669) [teiid-client-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> ... 47 more
> Caused by: java.lang.IllegalArgumentException: Expected argument to be non-null but got null
> at org.teiid.core.util.ArgCheck.isNotNull(ArgCheck.java:303) [teiid-common-core-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.core.util.ArgCheck.isNotNull(ArgCheck.java:289) [teiid-common-core-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.services.SessionServiceImpl.createSession(SessionServiceImpl.java:150) [teiid-runtime-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.transport.LogonImpl.logon(LogonImpl.java:137) [teiid-runtime-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.transport.LogonImpl.logon(LogonImpl.java:121) [teiid-runtime-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_79]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_79]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_79]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_79]
> at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:180) [teiid-runtime-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_79]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:260) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:178) [teiid-runtime-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at com.sun.proxy.$Proxy48.logon(Unknown Source)
> at org.teiid.transport.LocalServerConnection.authenticate(LocalServerConnection.java:142) [teiid-runtime-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:174) [teiid-runtime-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> ... 49 more
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 12 months
[JBoss JIRA] (TEIID-3663) ST_Transform only works in tests
by Johnathon Lee (JIRA)
[ https://issues.jboss.org/browse/TEIID-3663?page=com.atlassian.jira.plugin... ]
Johnathon Lee reopened TEIID-3663:
----------------------------------
> ST_Transform only works in tests
> --------------------------------
>
> Key: TEIID-3663
> URL: https://issues.jboss.org/browse/TEIID-3663
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.11
> Reporter: Tom Arnold
> Assignee: Steven Hawkins
> Fix For: 8.12, 8.11.3
>
>
> From one of the tests; this fails against an actual server (JBoss kit).
> {code}
> select st_transform(st_geomfromtext('POINT(-118 34)',4326),3310);
> {code}
> {code}
> ERROR: TEIID30328 Unable to evaluate st_transform(?, 3310): TEIID30384 Error while evaluating function st_transform
> DETAIL: org.teiid.jdbc.TeiidSQLException: TEIID30328 Unable to evaluate st_transform(?, 3310): TEIID30384 Error while evaluating function st_transform
> {code}
> {code}
> 00:02:59,143 INFO [org.teiid.SECURITY] (Worker2_QueryProcessorQueue6) tF6aPUsmLmU/ TEIID40115 Local pass-through connection implicitly closing session tF6aPUsmLmU/ so that the connection can be used in a different security context.
> 00:02:59,144 WARN [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue6) tF6aPUsmLmU/ TEIID30020 Processing exception for request tF6aPUsmLmU/.4 'TEIID30328 Unable to evaluate st_transform(?, 3310): TEIID30384 Error while evaluating function st_transform'. Originally ExpressionEvaluationException 'Expected argument to be non-null but got null' ArgCheck.java:303.: org.teiid.api.exception.query.ExpressionEvaluationException: TEIID30328 Unable to evaluate st_transform(?, 3310): TEIID30384 Error while evaluating function st_transform
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:631) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.rewriter.QueryRewriter.evaluate(QueryRewriter.java:2122) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.rewriter.QueryRewriter.rewriteExpressionDirect(QueryRewriter.java:2112) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.rewriter.QueryRewriter.access$000(QueryRewriter.java:101) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.rewriter.QueryRewriter$3.replaceExpression(QueryRewriter.java:626) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.sql.visitor.ExpressionMappingVisitor.visit(ExpressionMappingVisitor.java:162) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.sql.symbol.ExpressionSymbol.acceptVisitor(ExpressionSymbol.java:63) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:54) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.postVisitVisitor(PreOrPostOrderNavigator.java:61) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:183) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.sql.symbol.ExpressionSymbol.acceptVisitor(ExpressionSymbol.java:63) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:63) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:76) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:342) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.sql.lang.Select.acceptVisitor(Select.java:168) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.sql.navigator.PostOrderNavigator.doVisit(PostOrderNavigator.java:40) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.rewriter.QueryRewriter.rewriteExpressions(QueryRewriter.java:633) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.rewriter.QueryRewriter.rewriteQuery(QueryRewriter.java:471) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.rewriter.QueryRewriter.rewriteCommand(QueryRewriter.java:222) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.rewriter.QueryRewriter.rewrite(QueryRewriter.java:167) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.rewriter.QueryRewriter.rewrite(QueryRewriter.java:171) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:413) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.Request.processRequest(Request.java:461) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:632) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:333) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:271) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_79]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_79]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_79]
> Caused by: org.teiid.api.exception.query.FunctionExecutionException: TEIID30384 Error while evaluating function st_transform
> at org.teiid.query.function.FunctionDescriptor.invokeFunction(FunctionDescriptor.java:295) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:1320) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:659) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:629) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> ... 32 more
> Caused by: org.teiid.api.exception.query.FunctionExecutionException: 38000 TEIID31163 Failed to lookup proj4 text.
> at org.teiid.query.function.GeometryTransformUtils.lookupProj4Text(GeometryTransformUtils.java:109) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.function.GeometryTransformUtils.transform(GeometryTransformUtils.java:78) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.function.GeometryTransformUtils.transform(GeometryTransformUtils.java:64) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.function.GeometryFunctionMethods.transform(GeometryFunctionMethods.java:253) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_79]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_79]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_79]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_79]
> at org.teiid.query.function.FunctionDescriptor.invokeFunction(FunctionDescriptor.java:281) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> ... 35 more
> Caused by: org.teiid.jdbc.TeiidSQLException: Expected argument to be non-null but got null
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) [teiid-client-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) [teiid-client-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:671) [teiid-client-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:535) [teiid-client-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) [teiid-client-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:73) [teiid-client-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.query.function.GeometryTransformUtils.lookupProj4Text(GeometryTransformUtils.java:103) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> ... 43 more
> Caused by: org.teiid.core.TeiidComponentException: Expected argument to be non-null but got null
> at org.teiid.client.util.ExceptionUtil.convertException(ExceptionUtil.java:65) [teiid-client-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:186) [teiid-runtime-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at com.sun.proxy.$Proxy18.executeRequest(Unknown Source)
> at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:669) [teiid-client-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> ... 47 more
> Caused by: java.lang.IllegalArgumentException: Expected argument to be non-null but got null
> at org.teiid.core.util.ArgCheck.isNotNull(ArgCheck.java:303) [teiid-common-core-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.core.util.ArgCheck.isNotNull(ArgCheck.java:289) [teiid-common-core-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.services.SessionServiceImpl.createSession(SessionServiceImpl.java:150) [teiid-runtime-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.transport.LogonImpl.logon(LogonImpl.java:137) [teiid-runtime-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.transport.LogonImpl.logon(LogonImpl.java:121) [teiid-runtime-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_79]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_79]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_79]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_79]
> at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:180) [teiid-runtime-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_79]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:260) [teiid-engine-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:178) [teiid-runtime-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at com.sun.proxy.$Proxy48.logon(Unknown Source)
> at org.teiid.transport.LocalServerConnection.authenticate(LocalServerConnection.java:142) [teiid-runtime-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:174) [teiid-runtime-8.12.0.Beta2-SNAPSHOT.jar:8.12.0.Beta2-SNAPSHOT]
> ... 49 more
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 12 months
[JBoss JIRA] (TEIID-3869) Enable Teiid to be exposed as a GIS compliant data source
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3869?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3869:
---------------------------------------
Added an initial commit for 9.0 that will backport cleanly. The functions added are:
ST_SIMPLIFY
ST_FORCE_2D (currently just a dummy function)
ST_ENVELOPE
ST_WITHIN
ST_DWITHIN
ST_EXTENT (aggregate function)
ST_HASARC (currently just a dummy function)
&& (operator that we only support with geometry arguments)
ST_GEOMFROMEWKT
ST_ASEWKB
ST_GEOMFROMEWKB
To run with Geoserver you can setup a postgis instance - http://docs.geoserver.org/stable/en/user/gettingstarted/postgis-quickstar...
The instructions are a little out of date, you may just use psql to add the postgis extensions - http://postgis.net/docs/postgis_installation.html
Run Teiid and add that postgresl/postgis instance as a source:
For example in embedded:
ModelMetaData mmd = new ModelMetaData();
mmd.setName("public");
mmd.setModelType(Model.Type.PHYSICAL);
mmd.addSourceMapping("pg", "pg", "pg");
mmd.addProperty("importer.useQualifiedName", "false");
mmd.addProperty("importer.schemaPattern", "public");
mmd.addProperty("importer.excludeTables", "geometry_columns");
es.deployVDB("nyc", mmd);
Note that useQualifiedNames is off and we specifically exclude geometry_columns from the source - this is because Geoserver makes unqualified queries that reference geometry_columns and we need it to resolve against our system table, rather that being ambiguous. You'll also need the pg/ODBC transport to be enabled:
EmbeddedConfiguration ec = new EmbeddedConfiguration();
SocketConfiguration sc = new SocketConfiguration();
sc.setProtocol(WireProtocol.pg);
sc.setPortNumber(5433);
ec.addTransport(sc);
>From there just follow the instructions from the rest of http://docs.geoserver.org/stable/en/user/gettingstarted/postgis-quickstar... but point it to the Teiid port instead of postgresl.
> Enable Teiid to be exposed as a GIS compliant data source
> ---------------------------------------------------------
>
> Key: TEIID-3869
> URL: https://issues.jboss.org/browse/TEIID-3869
> Project: Teiid
> Issue Type: Feature Request
> Components: JDBC Driver, OData, ODBC
> Reporter: Van Halbert
> Assignee: Steven Hawkins
>
> See
> http://www.esri.com/~/media/Files/Pdfs/library/whitepapers/pdfs/supported...
> WMS - http://www.opengeospatial.org/standards/wms
> WFS - http://www.opengeospatial.org/standards/wfs
> Using MapViewer to show maps based on WMS services. The WMS services are provided by a GeoServer like ArcGIS or GeoServer.
> OData has also some capabilities in the Geo space especially on the .Net libraries side.
> See http://www.odata.org/libraries/ for Microsoft.Spatial (OData v4) and System.Spatial (OData v1-3)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 12 months
[JBoss JIRA] (TEIID-3902) Update doc links
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3902:
-------------------------------------
Summary: Update doc links
Key: TEIID-3902
URL: https://issues.jboss.org/browse/TEIID-3902
Project: Teiid
Issue Type: Sub-task
Components: Documentation
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Documentation links on the community site, the root README.md, from confluence to the new docs, etc. will need to be updated with this conversion.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 12 months
[JBoss JIRA] (TEIID-3871) moving documentation from confluence to gitbook
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3871?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3871:
---------------------------------------
And to make sure this is from the latest / 9.0 confluence correct?
> moving documentation from confluence to gitbook
> -------------------------------------------------
>
> Key: TEIID-3871
> URL: https://issues.jboss.org/browse/TEIID-3871
> Project: Teiid
> Issue Type: Task
> Components: Documentation
> Affects Versions: 9.x
> Reporter: Kylin Soong
> Assignee: Kylin Soong
> Fix For: 9.x
>
>
> From Teiid DV 7 F2F Notes,
> " In the Teiid 9.x timeframe we should look toward moving everything to gitbook / markdown. We should start by migrating the documentation and solicit help with the website if possible."
> This issue will address this.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 12 months
[JBoss JIRA] (TEIID-3871) moving documentation from confluence to gitbook
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-3871?page=com.atlassian.jira.plugin... ]
Kylin Soong edited comment on TEIID-3871 at 1/13/16 6:17 AM:
-------------------------------------------------------------
h2.Document Migration Status
||Name||Status||link||
|Embedded Guide |Done |[https://www.gitbook.com/book/teiid/embedded-guide/details] |
|Security Guide |Pending |[https://www.gitbook.com/book/teiid/security-guide/details] |
|Caching Guide |Pending |- |
|Administrator's Guide |Pending |- |
|Client Developer's Guide |Scheduled |- |
|Developer's Guide |Scheduled |- |
|Reference Guide |Scheduled |- |
{color:#d04437}Note that{color}: Once a doc in '*Done*' status, please update doc via submit to Github, rather than edit Conference pages.
was (Author: kylin):
h2.Document Migration Status
||Name||Status||link||
|Embedded Guide |Done |[https://www.gitbook.com/book/teiid/embedded-guide/details] |
|Security Guide |Pending |- |
|Caching Guide |Pending |- |
|Administrator's Guide |Pending |- |
|Client Developer's Guide |Scheduled |- |
|Developer's Guide |Scheduled |- |
|Reference Guide |Scheduled |- |
{color:#d04437}Note that{color}: Once a doc in '*Done*' status, please update doc via submit to Github, rather than edit Conference pages.
> moving documentation from confluence to gitbook
> -------------------------------------------------
>
> Key: TEIID-3871
> URL: https://issues.jboss.org/browse/TEIID-3871
> Project: Teiid
> Issue Type: Task
> Components: Documentation
> Affects Versions: 9.x
> Reporter: Kylin Soong
> Assignee: Kylin Soong
> Fix For: 9.x
>
>
> From Teiid DV 7 F2F Notes,
> " In the Teiid 9.x timeframe we should look toward moving everything to gitbook / markdown. We should start by migrating the documentation and solicit help with the website if possible."
> This issue will address this.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 12 months
[JBoss JIRA] (TEIID-3871) moving documentation from confluence to gitbook
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-3871?page=com.atlassian.jira.plugin... ]
Kylin Soong edited comment on TEIID-3871 at 1/13/16 4:51 AM:
-------------------------------------------------------------
h2.Document Migration Status
||Name||Status||link||
|Embedded Guide |Done |[https://www.gitbook.com/book/teiid/embedded-guide/details] |
|Security Guide |Pending |- |
|Caching Guide |Pending |- |
|Administrator's Guide |Pending |- |
|Client Developer's Guide |Scheduled |- |
|Developer's Guide |Scheduled |- |
|Reference Guide |Scheduled |- |
{color:#d04437}Note that{color}: Once a doc in '*Done*' status, please update doc via submit to Github, rather than edit Conference pages.
was (Author: kylin):
h2.Document Migration Status
||Name||Status||link||
|Embedded Guide|Done|https://www.gitbook.com/book/teiid/embedded-guide/details|
|Security Guide|Pending|-|
|Caching Guide|Pending|-|
|Administrator's Guide|Pending|-|
|Client Developer's Guide|Scheduled|-|
|Developer's Guide|Scheduled|-|
|Reference Guide|Scheduled|-|
> moving documentation from confluence to gitbook
> -------------------------------------------------
>
> Key: TEIID-3871
> URL: https://issues.jboss.org/browse/TEIID-3871
> Project: Teiid
> Issue Type: Task
> Components: Documentation
> Affects Versions: 9.x
> Reporter: Kylin Soong
> Assignee: Kylin Soong
> Fix For: 9.x
>
>
> From Teiid DV 7 F2F Notes,
> " In the Teiid 9.x timeframe we should look toward moving everything to gitbook / markdown. We should start by migrating the documentation and solicit help with the website if possible."
> This issue will address this.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 12 months