[JBoss JIRA] (TEIID-3665) Undeployable dynamic vdb if its runtime name does not have extension ".xml"
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3665?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration updated TEIID-3665:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1257901
Bugzilla Update: Perform
> Undeployable dynamic vdb if its runtime name does not have extension ".xml"
> ---------------------------------------------------------------------------
>
> Key: TEIID-3665
> URL: https://issues.jboss.org/browse/TEIID-3665
> Project: Teiid
> Issue Type: Bug
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Priority: Minor
>
> If the runtime name of a dynamic VDB (*-vdb.xml) does not contain ".xml" extension, then it is undeployable \[3\]. If the runtime name does not contain ".xml", EAP tries to load it as zip \[2\].
> Management api commands \[1\]. I suggest to add at least note to the documentation.
> \[1\]
> - *fail:* /deployment=myvdb:add(runtime-name=myvdbrn,enabled=true,content=\[\{archive=false,path=/path/to/my-vdb.xml\}\])
> - *fail:* deploy /path/to/my-vdb.xml --name=myvdb --runtime-name=myvdbrn
> - *ok:* /deployment=myvdb:add(runtime-name=myvdbrn,enabled=+false+,content=\[\{archive=false,path=/path/to/my-vdb.xml\}\])
> *fail:* /deployment=myvdb:deploy
> \[2\]
> org.jboss.as:jboss-as-server:7.5.0.Final-redhat-21
> org.jboss.as.server.deployment.module.DeploymentRootMountProcessor#deploy(DeploymentPhaseContext)
> if(mountExploded) \{
> type = MountType.EXPANDED;
> \} else if (deploymentName.endsWith(".xml")) \{
> type = MountType.REAL;
> \} else \{
> type = MountType.ZIP;
> \}
> \[3\]
> ERROR [org.jboss.msc.service.fail] (MSC service thread 1-6) MSC000001: Failed to start service jboss.deployment.unit.newvdbxmlrn.STRUCTURE: org.jboss.msc.service.StartException in service jboss.deployment.unit.newvdbxmlrn.STRUCTURE: JBAS018733: Failed to process phase STRUCTURE of deployment "newvdbxmlrn"
> at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:166) [jboss-as-server-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
> at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1980) [jboss-msc-1.1.5.Final-redhat-1.jar:1.1.5.Final-redhat-1]
> at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1913) [jboss-msc-1.1.5.Final-redhat-1.jar:1.1.5.Final-redhat-1]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_40]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_40]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_40]
> Caused by: org.jboss.as.server.deployment.DeploymentUnitProcessingException: JBAS018740: Failed to mount deployment content
> at org.jboss.as.server.deployment.module.DeploymentRootMountProcessor.deploy(DeploymentRootMountProcessor.java:97) [jboss-as-server-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
> at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:159) [jboss-as-server-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
> ... 5 more
> Caused by: java.util.zip.ZipException: error in opening zip file
> at java.util.zip.ZipFile.open(Native Method) [rt.jar:1.8.0_40]
> at java.util.zip.ZipFile.<init>(ZipFile.java:220) [rt.jar:1.8.0_40]
> at java.util.zip.ZipFile.<init>(ZipFile.java:150) [rt.jar:1.8.0_40]
> at java.util.jar.JarFile.<init>(JarFile.java:166) [rt.jar:1.8.0_40]
> at java.util.jar.JarFile.<init>(JarFile.java:130) [rt.jar:1.8.0_40]
> at org.jboss.vfs.spi.JavaZipFileSystem.<init>(JavaZipFileSystem.java:90) [jboss-vfs-3.2.9.Final-redhat-1.jar:3.2.9.Final-redhat-1]
> at org.jboss.vfs.spi.JavaZipFileSystem.<init>(JavaZipFileSystem.java:77) [jboss-vfs-3.2.9.Final-redhat-1.jar:3.2.9.Final-redhat-1]
> at org.jboss.vfs.VFS.mountZip(VFS.java:386) [jboss-vfs-3.2.9.Final-redhat-1.jar:3.2.9.Final-redhat-1]
> at org.jboss.vfs.VFS.mountZip(VFS.java:410) [jboss-vfs-3.2.9.Final-redhat-1.jar:3.2.9.Final-redhat-1]
> at org.jboss.as.server.deployment.DeploymentMountProvider$Factory$ServerDeploymentRepositoryImpl.mountDeploymentContent(DeploymentMountProvider.java:105) [jboss-as-server-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
> at org.jboss.as.server.deployment.module.DeploymentRootMountProcessor.deploy(DeploymentRootMountProcessor.java:93) [jboss-as-server-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
> ... 6 more
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 3 months
[JBoss JIRA] (TEIID-3665) Undeployable dynamic vdb if its runtime name does not have extension ".xml"
by Juraj Duráni (JIRA)
[ https://issues.jboss.org/browse/TEIID-3665?page=com.atlassian.jira.plugin... ]
Juraj Duráni updated TEIID-3665:
--------------------------------
Summary: Undeployable dynamic vdb if its runtime name does not have extension ".xml" (was: Undeployeble dynamic vdb if its runtime name does not have extension ".xml")
> Undeployable dynamic vdb if its runtime name does not have extension ".xml"
> ---------------------------------------------------------------------------
>
> Key: TEIID-3665
> URL: https://issues.jboss.org/browse/TEIID-3665
> Project: Teiid
> Issue Type: Bug
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Priority: Minor
>
> If the runtime name of a dynamic VDB (*-vdb.xml) does not contain ".xml" extension, then it is undeployable \[3\]. If the runtime name does not contain ".xml", EAP tries to load it as zip \[2\].
> Management api commands \[1\]. I suggest to add at least note to the documentation.
> \[1\]
> - *fail:* /deployment=myvdb:add(runtime-name=myvdbrn,enabled=true,content=\[\{archive=false,path=/path/to/my-vdb.xml\}\])
> - *fail:* deploy /path/to/my-vdb.xml --name=myvdb --runtime-name=myvdbrn
> - *ok:* /deployment=myvdb:add(runtime-name=myvdbrn,enabled=+false+,content=\[\{archive=false,path=/path/to/my-vdb.xml\}\])
> *fail:* /deployment=myvdb:deploy
> \[2\]
> org.jboss.as:jboss-as-server:7.5.0.Final-redhat-21
> org.jboss.as.server.deployment.module.DeploymentRootMountProcessor#deploy(DeploymentPhaseContext)
> if(mountExploded) \{
> type = MountType.EXPANDED;
> \} else if (deploymentName.endsWith(".xml")) \{
> type = MountType.REAL;
> \} else \{
> type = MountType.ZIP;
> \}
> \[3\]
> ERROR [org.jboss.msc.service.fail] (MSC service thread 1-6) MSC000001: Failed to start service jboss.deployment.unit.newvdbxmlrn.STRUCTURE: org.jboss.msc.service.StartException in service jboss.deployment.unit.newvdbxmlrn.STRUCTURE: JBAS018733: Failed to process phase STRUCTURE of deployment "newvdbxmlrn"
> at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:166) [jboss-as-server-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
> at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1980) [jboss-msc-1.1.5.Final-redhat-1.jar:1.1.5.Final-redhat-1]
> at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1913) [jboss-msc-1.1.5.Final-redhat-1.jar:1.1.5.Final-redhat-1]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_40]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_40]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_40]
> Caused by: org.jboss.as.server.deployment.DeploymentUnitProcessingException: JBAS018740: Failed to mount deployment content
> at org.jboss.as.server.deployment.module.DeploymentRootMountProcessor.deploy(DeploymentRootMountProcessor.java:97) [jboss-as-server-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
> at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:159) [jboss-as-server-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
> ... 5 more
> Caused by: java.util.zip.ZipException: error in opening zip file
> at java.util.zip.ZipFile.open(Native Method) [rt.jar:1.8.0_40]
> at java.util.zip.ZipFile.<init>(ZipFile.java:220) [rt.jar:1.8.0_40]
> at java.util.zip.ZipFile.<init>(ZipFile.java:150) [rt.jar:1.8.0_40]
> at java.util.jar.JarFile.<init>(JarFile.java:166) [rt.jar:1.8.0_40]
> at java.util.jar.JarFile.<init>(JarFile.java:130) [rt.jar:1.8.0_40]
> at org.jboss.vfs.spi.JavaZipFileSystem.<init>(JavaZipFileSystem.java:90) [jboss-vfs-3.2.9.Final-redhat-1.jar:3.2.9.Final-redhat-1]
> at org.jboss.vfs.spi.JavaZipFileSystem.<init>(JavaZipFileSystem.java:77) [jboss-vfs-3.2.9.Final-redhat-1.jar:3.2.9.Final-redhat-1]
> at org.jboss.vfs.VFS.mountZip(VFS.java:386) [jboss-vfs-3.2.9.Final-redhat-1.jar:3.2.9.Final-redhat-1]
> at org.jboss.vfs.VFS.mountZip(VFS.java:410) [jboss-vfs-3.2.9.Final-redhat-1.jar:3.2.9.Final-redhat-1]
> at org.jboss.as.server.deployment.DeploymentMountProvider$Factory$ServerDeploymentRepositoryImpl.mountDeploymentContent(DeploymentMountProvider.java:105) [jboss-as-server-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
> at org.jboss.as.server.deployment.module.DeploymentRootMountProcessor.deploy(DeploymentRootMountProcessor.java:93) [jboss-as-server-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
> ... 6 more
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 3 months
[JBoss JIRA] (TEIID-3665) Undeployeble dynamic vdb if its runtime name does not have extension ".xml"
by Juraj Duráni (JIRA)
Juraj Duráni created TEIID-3665:
-----------------------------------
Summary: Undeployeble dynamic vdb if its runtime name does not have extension ".xml"
Key: TEIID-3665
URL: https://issues.jboss.org/browse/TEIID-3665
Project: Teiid
Issue Type: Bug
Reporter: Juraj Duráni
Assignee: Steven Hawkins
Priority: Minor
If the runtime name of a dynamic VDB (*-vdb.xml) does not contain ".xml" extension, then it is undeployable \[3\]. If the runtime name does not contain ".xml", EAP tries to load it as zip \[2\].
Management api commands \[1\]. I suggest to add at least note to the documentation.
\[1\]
- *fail:* /deployment=myvdb:add(runtime-name=myvdbrn,enabled=true,content=\[\{archive=false,path=/path/to/my-vdb.xml\}\])
- *fail:* deploy /path/to/my-vdb.xml --name=myvdb --runtime-name=myvdbrn
- *ok:* /deployment=myvdb:add(runtime-name=myvdbrn,enabled=+false+,content=\[\{archive=false,path=/path/to/my-vdb.xml\}\])
*fail:* /deployment=myvdb:deploy
\[2\]
org.jboss.as:jboss-as-server:7.5.0.Final-redhat-21
org.jboss.as.server.deployment.module.DeploymentRootMountProcessor#deploy(DeploymentPhaseContext)
if(mountExploded) \{
type = MountType.EXPANDED;
\} else if (deploymentName.endsWith(".xml")) \{
type = MountType.REAL;
\} else \{
type = MountType.ZIP;
\}
\[3\]
ERROR [org.jboss.msc.service.fail] (MSC service thread 1-6) MSC000001: Failed to start service jboss.deployment.unit.newvdbxmlrn.STRUCTURE: org.jboss.msc.service.StartException in service jboss.deployment.unit.newvdbxmlrn.STRUCTURE: JBAS018733: Failed to process phase STRUCTURE of deployment "newvdbxmlrn"
at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:166) [jboss-as-server-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1980) [jboss-msc-1.1.5.Final-redhat-1.jar:1.1.5.Final-redhat-1]
at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1913) [jboss-msc-1.1.5.Final-redhat-1.jar:1.1.5.Final-redhat-1]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_40]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_40]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_40]
Caused by: org.jboss.as.server.deployment.DeploymentUnitProcessingException: JBAS018740: Failed to mount deployment content
at org.jboss.as.server.deployment.module.DeploymentRootMountProcessor.deploy(DeploymentRootMountProcessor.java:97) [jboss-as-server-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:159) [jboss-as-server-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
... 5 more
Caused by: java.util.zip.ZipException: error in opening zip file
at java.util.zip.ZipFile.open(Native Method) [rt.jar:1.8.0_40]
at java.util.zip.ZipFile.<init>(ZipFile.java:220) [rt.jar:1.8.0_40]
at java.util.zip.ZipFile.<init>(ZipFile.java:150) [rt.jar:1.8.0_40]
at java.util.jar.JarFile.<init>(JarFile.java:166) [rt.jar:1.8.0_40]
at java.util.jar.JarFile.<init>(JarFile.java:130) [rt.jar:1.8.0_40]
at org.jboss.vfs.spi.JavaZipFileSystem.<init>(JavaZipFileSystem.java:90) [jboss-vfs-3.2.9.Final-redhat-1.jar:3.2.9.Final-redhat-1]
at org.jboss.vfs.spi.JavaZipFileSystem.<init>(JavaZipFileSystem.java:77) [jboss-vfs-3.2.9.Final-redhat-1.jar:3.2.9.Final-redhat-1]
at org.jboss.vfs.VFS.mountZip(VFS.java:386) [jboss-vfs-3.2.9.Final-redhat-1.jar:3.2.9.Final-redhat-1]
at org.jboss.vfs.VFS.mountZip(VFS.java:410) [jboss-vfs-3.2.9.Final-redhat-1.jar:3.2.9.Final-redhat-1]
at org.jboss.as.server.deployment.DeploymentMountProvider$Factory$ServerDeploymentRepositoryImpl.mountDeploymentContent(DeploymentMountProvider.java:105) [jboss-as-server-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
at org.jboss.as.server.deployment.module.DeploymentRootMountProcessor.deploy(DeploymentRootMountProcessor.java:93) [jboss-as-server-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
... 6 more
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 3 months
[JBoss JIRA] (TEIID-3664) Only JDK 1.7 can build Teiid code base success
by Kylin Soong (JIRA)
Kylin Soong created TEIID-3664:
----------------------------------
Summary: Only JDK 1.7 can build Teiid code base success
Key: TEIID-3664
URL: https://issues.jboss.org/browse/TEIID-3664
Project: Teiid
Issue Type: Quality Risk
Components: Build/Kits
Affects Versions: 8.12
Reporter: Kylin Soong
Assignee: Steven Hawkins
Fix For: 8.12
The following depiction exist in README.md
{code}
install JDK 1.7 or higher
{code}
But the build commands
{code}
$ mvn clean install -P release -s settings.xml
{code}
will execute failed if use JDK 1.8
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 3 months
[JBoss JIRA] (TEIID-3656) Maven assembly plugin moduleSet includeDependencies set to true scope too large
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-3656?page=com.atlassian.jira.plugin... ]
Kylin Soong commented on TEIID-3656:
------------------------------------
If add another module in future like
{code}
<moduleSet>
<includes>
<include>org.jboss.teiid:{future-add}</include>
</includes>
<binaries>
<includeDependencies>true</includeDependencies>
{code}
teiid-jboss-integration socpe including it, all new module's dependency will be copy to teiid-jboss-integration.
In other wards, one dist.xml file only allow one module with including dependencies to true.
> Maven assembly plugin moduleSet includeDependencies set to true scope too large
> -------------------------------------------------------------------------------
>
> Key: TEIID-3656
> URL: https://issues.jboss.org/browse/TEIID-3656
> Project: Teiid
> Issue Type: Quality Risk
> Components: Build/Kits
> Affects Versions: 8.12
> Reporter: Kylin Soong
>
> The assembly plugin moduleSet includeDependencies configuration under "build/assembly/jboss-as7/dist.xml":
> {code}
> <moduleSet>
> <includeSubModules>true</includeSubModules>
> <useAllReactorProjects>true</useAllReactorProjects>
> <includes>
> <include>org.jboss.teiid:teiid-jboss-integration</include>
> </includes>
> <binaries>
> <includeDependencies>true</includeDependencies>
> {code}
> the scope of this setting(includeDependencies is true,) is to large, it scope to all modules.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 3 months
[JBoss JIRA] (TEIID-3663) ST_Transform only works in tests
by Tom Arnold (JIRA)
[ https://issues.jboss.org/browse/TEIID-3663?page=com.atlassian.jira.plugin... ]
Tom Arnold edited comment on TEIID-3663 at 8/28/15 1:05 AM:
------------------------------------------------------------
Some debugging...
{{lookupProj4Text()}} creates local connection to lookup values in {{SPATIAL_REF_SYS}}. This appears to be failing for a couple of reasons.
In {{SessionServiceImpl.createSession()}} there is a not-null assertion on app name, but the command context never sets app name when making a local connection. I modified command context to set these:
{code}
@Override
public TeiidConnection getConnection() throws TeiidSQLException {
...
info.put(BaseDataSource.VDB_NAME, getVdbName());
info.put(BaseDataSource.VDB_VERSION, getVdbVersion());
info.put(TeiidURL.CONNECTION.APP_NAME, getDQPWorkContext().getAppName());
info.put(TeiidURL.CONNECTION.PASSTHROUGH_AUTHENTICATION, "true");
...
}
{code}
That got me a little further, but I was running into errors validating the session for the new local connection. After stepping through with the debugger a few times I was seeing that the first connection (from ODBC) was getting a session into {{sessionCache}} and the second connection (from local connection) had the same session ID but the session was missing from the session cache. Confused because I couldn't catch anyone actually removing sessions, I added a {{println(this)}} to {{validateSession}} and saw this in the log:
{code}
00:43:50,933 INFO [stdout] (New I/O worker #17) 7IuADb8ehDqI org.teiid.services.SessionServiceImpl@5c445dca
00:43:50,944 INFO [stdout] (Worker7_QueryProcessorQueue33) 7IuADb8ehDqI org.teiid.services.SessionServiceImpl@55ccc0a2
{code}
So there's two instances of the session service. Is this right? I changed the session cache to be a static field and now my original query works, but this is probably the wrong solution.
was (Author: tom9729):
Some debugging...
{{lookupProj4Text()}} creates local connection to lookup values in {{SPATIAL_REF_SYS}}. This appears to be failing for a couple of reasons.
In {{SessionServiceImpl.createSession()}} there is a not-null assertion on app name, but the command context never sets app name when making a local connection. I modified command context to set these:
{code}
@Override
public TeiidConnection getConnection() throws TeiidSQLException {
...
info.put(BaseDataSource.VDB_NAME, getVdbName());
info.put(BaseDataSource.VDB_VERSION, getVdbVersion());
info.put(TeiidURL.CONNECTION.APP_NAME, getDQPWorkContext().getAppName());
info.put(TeiidURL.CONNECTION.APP_NAME, getDQPWorkContext().getAppName());
info.put(TeiidURL.CONNECTION.PASSTHROUGH_AUTHENTICATION, "true");
...
}
{code}
That got me a little further, but I was running into errors validating the session for the new local connection. After stepping through with the debugger a few times I was seeing that the first connection (from ODBC) was getting a session into {{sessionCache}} and the second connection (from local connection) had the same session ID but the session was missing from the session cache. Confused because I couldn't catch anyone actually removing sessions, I added a {{println(this)}} to {{validateSession}} and saw this in the log:
{code}
00:43:50,933 INFO [stdout] (New I/O worker #17) 7IuADb8ehDqI org.teiid.services.SessionServiceImpl@5c445dca
00:43:50,944 INFO [stdout] (Worker7_QueryProcessorQueue33) 7IuADb8ehDqI org.teiid.services.SessionServiceImpl@55ccc0a2
{code}
So there's two instances of the session service. Is this right? I changed the session cache to be a static field and now my original query works, but this is probably the wrong solution.
> 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.12
> Reporter: Tom Arnold
> Assignee: Steven Hawkins
>
> 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.3.15#6346)
10 years, 3 months
[JBoss JIRA] (TEIID-3663) ST_Transform only works in tests
by Tom Arnold (JIRA)
Tom Arnold created TEIID-3663:
---------------------------------
Summary: 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.12
Reporter: Tom Arnold
Assignee: Steven Hawkins
>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}
----------------
Some debugging...
{{lookupProj4Text()}} creates local connection to lookup values in {{SPATIAL_REF_SYS}}. This appears to be failing for a couple of reasons.
In {{SessionServiceImpl.createSession()}} there is a not-null assertion on app name, but the command context never sets app name when making a local connection. I modified command context to set these:
{code}
@Override
public TeiidConnection getConnection() throws TeiidSQLException {
...
info.put(BaseDataSource.VDB_NAME, getVdbName());
info.put(BaseDataSource.VDB_VERSION, getVdbVersion());
info.put(TeiidURL.CONNECTION.APP_NAME, getDQPWorkContext().getAppName());
info.put(TeiidURL.CONNECTION.APP_NAME, getDQPWorkContext().getAppName());
info.put(TeiidURL.CONNECTION.PASSTHROUGH_AUTHENTICATION, "true");
...
}
{code}
That got me a little further, but I was running into errors validating the session for the new local connection. After stepping through with the debugger a few times I was seeing that the first connection (from ODBC) was getting a session into {{sessionCache}} and the second connection (from local connection) had the same session ID but the session was missing from the session cache. Confused because I couldn't catch anyone actually removing sessions, I added a {{println(this)}} to {{validateSession}} and saw this in the log:
{code}
00:43:50,933 INFO [stdout] (New I/O worker #17) 7IuADb8ehDqI org.teiid.services.SessionServiceImpl@5c445dca
00:43:50,944 INFO [stdout] (Worker7_QueryProcessorQueue33) 7IuADb8ehDqI org.teiid.services.SessionServiceImpl@55ccc0a2
{code}
So there's two instances of the session service. Is this right? I changed the session cache to be a static field and now my original query works, but this is probably the wrong solution.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 3 months
[JBoss JIRA] (TEIID-3663) ST_Transform only works in tests
by Tom Arnold (JIRA)
[ https://issues.jboss.org/browse/TEIID-3663?page=com.atlassian.jira.plugin... ]
Tom Arnold updated TEIID-3663:
------------------------------
Description:
>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}
----------------
was:
>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}
----------------
Some debugging...
{{lookupProj4Text()}} creates local connection to lookup values in {{SPATIAL_REF_SYS}}. This appears to be failing for a couple of reasons.
In {{SessionServiceImpl.createSession()}} there is a not-null assertion on app name, but the command context never sets app name when making a local connection. I modified command context to set these:
{code}
@Override
public TeiidConnection getConnection() throws TeiidSQLException {
...
info.put(BaseDataSource.VDB_NAME, getVdbName());
info.put(BaseDataSource.VDB_VERSION, getVdbVersion());
info.put(TeiidURL.CONNECTION.APP_NAME, getDQPWorkContext().getAppName());
info.put(TeiidURL.CONNECTION.APP_NAME, getDQPWorkContext().getAppName());
info.put(TeiidURL.CONNECTION.PASSTHROUGH_AUTHENTICATION, "true");
...
}
{code}
That got me a little further, but I was running into errors validating the session for the new local connection. After stepping through with the debugger a few times I was seeing that the first connection (from ODBC) was getting a session into {{sessionCache}} and the second connection (from local connection) had the same session ID but the session was missing from the session cache. Confused because I couldn't catch anyone actually removing sessions, I added a {{println(this)}} to {{validateSession}} and saw this in the log:
{code}
00:43:50,933 INFO [stdout] (New I/O worker #17) 7IuADb8ehDqI org.teiid.services.SessionServiceImpl@5c445dca
00:43:50,944 INFO [stdout] (Worker7_QueryProcessorQueue33) 7IuADb8ehDqI org.teiid.services.SessionServiceImpl@55ccc0a2
{code}
So there's two instances of the session service. Is this right? I changed the session cache to be a static field and now my original query works, but this is probably the wrong solution.
> 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.12
> Reporter: Tom Arnold
> Assignee: Steven Hawkins
>
> 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.3.15#6346)
10 years, 3 months
[JBoss JIRA] (TEIID-3663) ST_Transform only works in tests
by Tom Arnold (JIRA)
[ https://issues.jboss.org/browse/TEIID-3663?page=com.atlassian.jira.plugin... ]
Tom Arnold commented on TEIID-3663:
-----------------------------------
Some debugging...
{{lookupProj4Text()}} creates local connection to lookup values in {{SPATIAL_REF_SYS}}. This appears to be failing for a couple of reasons.
In {{SessionServiceImpl.createSession()}} there is a not-null assertion on app name, but the command context never sets app name when making a local connection. I modified command context to set these:
{code}
@Override
public TeiidConnection getConnection() throws TeiidSQLException {
...
info.put(BaseDataSource.VDB_NAME, getVdbName());
info.put(BaseDataSource.VDB_VERSION, getVdbVersion());
info.put(TeiidURL.CONNECTION.APP_NAME, getDQPWorkContext().getAppName());
info.put(TeiidURL.CONNECTION.APP_NAME, getDQPWorkContext().getAppName());
info.put(TeiidURL.CONNECTION.PASSTHROUGH_AUTHENTICATION, "true");
...
}
{code}
That got me a little further, but I was running into errors validating the session for the new local connection. After stepping through with the debugger a few times I was seeing that the first connection (from ODBC) was getting a session into {{sessionCache}} and the second connection (from local connection) had the same session ID but the session was missing from the session cache. Confused because I couldn't catch anyone actually removing sessions, I added a {{println(this)}} to {{validateSession}} and saw this in the log:
{code}
00:43:50,933 INFO [stdout] (New I/O worker #17) 7IuADb8ehDqI org.teiid.services.SessionServiceImpl@5c445dca
00:43:50,944 INFO [stdout] (Worker7_QueryProcessorQueue33) 7IuADb8ehDqI org.teiid.services.SessionServiceImpl@55ccc0a2
{code}
So there's two instances of the session service. Is this right? I changed the session cache to be a static field and now my original query works, but this is probably the wrong solution.
> 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.12
> Reporter: Tom Arnold
> Assignee: Steven Hawkins
>
> 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.3.15#6346)
10 years, 3 months
[JBoss JIRA] (TEIID-3663) ST_Transform only works in tests
by Tom Arnold (JIRA)
[ https://issues.jboss.org/browse/TEIID-3663?page=com.atlassian.jira.plugin... ]
Tom Arnold updated TEIID-3663:
------------------------------
Description:
>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}
was:
>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}
----------------
> 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.12
> Reporter: Tom Arnold
> Assignee: Steven Hawkins
>
> 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.3.15#6346)
10 years, 3 months