[JBoss JIRA] (TEIID-4867) Loosen up OData4 URL validation or parsing
by Steve Tran (JIRA)
Steve Tran created TEIID-4867:
---------------------------------
Summary: Loosen up OData4 URL validation or parsing
Key: TEIID-4867
URL: https://issues.jboss.org/browse/TEIID-4867
Project: Teiid
Issue Type: Bug
Components: OData
Affects Versions: 8.12.8.6_3
Environment: JDV 6.3.2
Windows 7
Reporter: Steve Tran
Assignee: Steven Hawkins
I'm accessing my JDV table via OData4 through Salesforce's UI builder. The salesforce engine itself is creating the OData calls, and whenever a $filter is needed with multiple columns, it looks like salesforce pads the column name with a space in front and behind. That'll make the URL look like ...$filter={color:red}%20{color}ColumnA{color:red}%20{color}eq%20123%20and{color:red}%20{color}ColumnB{color:red}%20{color}eq...
The first space right after the $filter= throws off the JDV engine as it thinks it's a malformed URL - which I guess it is. The thing is when I tested it via the OData2 interface, it accepted it just fine. I'm not sure if the OData4 specifications explicitly state in terms of the URL, so it could be anybody's bug. Perhaps we could make JDV a little more forgiving and trim the spaces after un-URL-encoding the URI.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months
[JBoss JIRA] (TEIID-4817) Infinispan DSL Resource Adapter: can't query after JDG restart
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4817?page=com.atlassian.jira.plugin... ]
Van Halbert closed TEIID-4817.
------------------------------
Resolution: Done
> Infinispan DSL Resource Adapter: can't query after JDG restart
> --------------------------------------------------------------
>
> Key: TEIID-4817
> URL: https://issues.jboss.org/browse/TEIID-4817
> Project: Teiid
> Issue Type: Bug
> Components: JDG Connector
> Affects Versions: 8.12.10.6_3
> Reporter: Jan Stastny
> Assignee: Van Halbert
> Priority: Blocker
> Fix For: 9.3, 8.12.10.6_3, 8.12.x-6.4
>
>
> There is an issue with Infinispan DSL connector when accessing JDG after it has been restarted.
> When I have a vdb accessing JDG only as datasource and I do following:
> 1. Start JDV and JDG
> 2. Configure JDV to use JDG as datasource (no materialization needed)
> 3. Deploy a vdb accessing the JDG instance using a pojo.
> 4. Query the vdb with no issues.
> 5. Restart JDG (call reload using DMR/CLI)
> 6. Wait for JDG to come up.
> 7. Query the vdb again
> Then in step 7 I get:
> {code:plain|title="WARN in server log"}
> 12:32:32,749 WARN [org.infinispan.client.hotrod.impl.protocol.Codec21] (Worker1_QueryProcessorQueue5) ISPN004005: Error received from the server: java.lang.IllegalStateException: Unknown entity name org.jboss.qe.jdg.remote.protobuf.SmallA
> {code}
> {code:plain|title="full stacktrace"}
> 12:32:32,749 WARN [org.infinispan.client.hotrod.impl.protocol.Codec21] (Worker1_QueryProcessorQueue5) ISPN004005: Error received from the server: java.lang.IllegalStateException: Unknown entity name org.jboss.qe.jdg.remote.protobuf.SmallA
> 12:32:32,753 WARN [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue5) Connector worker process failed for atomic-request=jUZx1bBd0k4L.0.3.1: org.teiid.translator.TranslatorException: java.lang.IllegalStateException: Unknown entity name org.jboss.qe.jdg.remote.protobuf.SmallA
> at org.teiid.translator.object.ObjectExecution.execute(ObjectExecution.java:275) [translator-object-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:363) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_121]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_121]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_121]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_121]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at com.sun.proxy.$Proxy89.execute(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_121]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_121]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_121]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_121]
> Caused by: org.infinispan.client.hotrod.exceptions.HotRodClientException:Request for message id[9] returned server error (status=0x85): java.lang.IllegalStateException: Unknown entity name org.jboss.qe.jdg.remote.protobuf.SmallA
> at org.infinispan.client.hotrod.impl.protocol.Codec20.checkForErrorsInResponseStatus(Codec20.java:343)
> at org.infinispan.client.hotrod.impl.protocol.Codec20.readPartialHeader(Codec20.java:133)
> at org.infinispan.client.hotrod.impl.protocol.Codec20.readHeader(Codec20.java:119)
> at org.infinispan.client.hotrod.impl.operations.HotRodOperation.readHeaderAndValidate(HotRodOperation.java:56)
> at org.infinispan.client.hotrod.impl.operations.QueryOperation.executeOperation(QueryOperation.java:62)
> at org.infinispan.client.hotrod.impl.operations.QueryOperation.executeOperation(QueryOperation.java:28)
> at org.infinispan.client.hotrod.impl.operations.RetryOnFailureOperation.execute(RetryOnFailureOperation.java:56)
> at org.infinispan.client.hotrod.impl.query.RemoteQuery.executeQuery(RemoteQuery.java:61)
> at org.infinispan.client.hotrod.impl.query.RemoteQuery.list(RemoteQuery.java:51)
> at org.teiid.resource.adapter.infinispan.dsl.DSLSearch.performSearch(DSLSearch.java:196)
> at org.teiid.resource.adapter.infinispan.dsl.DSLSearch.performSearch(DSLSearch.java:149)
> at org.teiid.translator.object.ObjectExecution.execute(ObjectExecution.java:261) [translator-object-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> ... 18 more
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months
[JBoss JIRA] (TEIID-4817) Infinispan DSL Resource Adapter: can't query after JDG restart
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4817?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-4817:
------------------------------------
As part of the upstream commit for 9.3, the changes where included in the commit: https://github.com/teiid/jdg/commit/5ad2081394741e6ce152a9d3841c21a98b23d49e
This should complete this jira.
> Infinispan DSL Resource Adapter: can't query after JDG restart
> --------------------------------------------------------------
>
> Key: TEIID-4817
> URL: https://issues.jboss.org/browse/TEIID-4817
> Project: Teiid
> Issue Type: Bug
> Components: JDG Connector
> Affects Versions: 8.12.10.6_3
> Reporter: Jan Stastny
> Assignee: Van Halbert
> Priority: Blocker
> Fix For: 9.3, 8.12.10.6_3, 8.12.x-6.4
>
>
> There is an issue with Infinispan DSL connector when accessing JDG after it has been restarted.
> When I have a vdb accessing JDG only as datasource and I do following:
> 1. Start JDV and JDG
> 2. Configure JDV to use JDG as datasource (no materialization needed)
> 3. Deploy a vdb accessing the JDG instance using a pojo.
> 4. Query the vdb with no issues.
> 5. Restart JDG (call reload using DMR/CLI)
> 6. Wait for JDG to come up.
> 7. Query the vdb again
> Then in step 7 I get:
> {code:plain|title="WARN in server log"}
> 12:32:32,749 WARN [org.infinispan.client.hotrod.impl.protocol.Codec21] (Worker1_QueryProcessorQueue5) ISPN004005: Error received from the server: java.lang.IllegalStateException: Unknown entity name org.jboss.qe.jdg.remote.protobuf.SmallA
> {code}
> {code:plain|title="full stacktrace"}
> 12:32:32,749 WARN [org.infinispan.client.hotrod.impl.protocol.Codec21] (Worker1_QueryProcessorQueue5) ISPN004005: Error received from the server: java.lang.IllegalStateException: Unknown entity name org.jboss.qe.jdg.remote.protobuf.SmallA
> 12:32:32,753 WARN [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue5) Connector worker process failed for atomic-request=jUZx1bBd0k4L.0.3.1: org.teiid.translator.TranslatorException: java.lang.IllegalStateException: Unknown entity name org.jboss.qe.jdg.remote.protobuf.SmallA
> at org.teiid.translator.object.ObjectExecution.execute(ObjectExecution.java:275) [translator-object-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:363) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_121]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_121]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_121]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_121]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at com.sun.proxy.$Proxy89.execute(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_121]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_121]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_121]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_121]
> Caused by: org.infinispan.client.hotrod.exceptions.HotRodClientException:Request for message id[9] returned server error (status=0x85): java.lang.IllegalStateException: Unknown entity name org.jboss.qe.jdg.remote.protobuf.SmallA
> at org.infinispan.client.hotrod.impl.protocol.Codec20.checkForErrorsInResponseStatus(Codec20.java:343)
> at org.infinispan.client.hotrod.impl.protocol.Codec20.readPartialHeader(Codec20.java:133)
> at org.infinispan.client.hotrod.impl.protocol.Codec20.readHeader(Codec20.java:119)
> at org.infinispan.client.hotrod.impl.operations.HotRodOperation.readHeaderAndValidate(HotRodOperation.java:56)
> at org.infinispan.client.hotrod.impl.operations.QueryOperation.executeOperation(QueryOperation.java:62)
> at org.infinispan.client.hotrod.impl.operations.QueryOperation.executeOperation(QueryOperation.java:28)
> at org.infinispan.client.hotrod.impl.operations.RetryOnFailureOperation.execute(RetryOnFailureOperation.java:56)
> at org.infinispan.client.hotrod.impl.query.RemoteQuery.executeQuery(RemoteQuery.java:61)
> at org.infinispan.client.hotrod.impl.query.RemoteQuery.list(RemoteQuery.java:51)
> at org.teiid.resource.adapter.infinispan.dsl.DSLSearch.performSearch(DSLSearch.java:196)
> at org.teiid.resource.adapter.infinispan.dsl.DSLSearch.performSearch(DSLSearch.java:149)
> at org.teiid.translator.object.ObjectExecution.execute(ObjectExecution.java:261) [translator-object-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> ... 18 more
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months
[JBoss JIRA] (TEIID-4808) Infinispan Cache Resource Adapter: NullPointerException
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4808?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-4808:
-------------------------------
Fix Version/s: 9.3
> Infinispan Cache Resource Adapter: NullPointerException
> -------------------------------------------------------
>
> Key: TEIID-4808
> URL: https://issues.jboss.org/browse/TEIID-4808
> Project: Teiid
> Issue Type: Bug
> Components: JDG Connector
> Affects Versions: 8.12.10.6_3
> Reporter: Jan Stastny
> Assignee: Van Halbert
> Fix For: 9.3, 8.12.x-6.4
>
>
> There is a NPE when trying to query a local cache via Infinispan Cache translator.
> {code}
> [31m10:27:43,186 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) Connector worker process failed for atomic-request=6chGAXrxul8Z.0.3.0: java.lang.NullPointerException
> at org.teiid.resource.adapter.infinispan.InfinispanCacheWrapper.getClassRegistry(InfinispanCacheWrapper.java:128)
> at org.teiid.resource.adapter.infinispan.InfinispanCacheRAConnection.getClassRegistry(InfinispanCacheRAConnection.java:137)
> at org.teiid.translator.object.ObjectExecution.<init>(ObjectExecution.java:195) [translator-object-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.translator.infinispan.cache.InfinispanCacheExecutionFactory$1.<init>(InfinispanCacheExecutionFactory.java:93) [translator-infinispan-cache-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.translator.infinispan.cache.InfinispanCacheExecutionFactory.createResultSetExecution(InfinispanCacheExecutionFactory.java:93) [translator-infinispan-cache-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.translator.infinispan.cache.InfinispanCacheExecutionFactory.createResultSetExecution(InfinispanCacheExecutionFactory.java:51) [translator-infinispan-cache-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:316) [teiid-api-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:354) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_111]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_111]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_111]
> at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_111]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at com.sun.proxy.$Proxy103.execute(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_111]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_111]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_111]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_111]
> {code}
> POJO's module.xml:
> {code:xml}
> <module xmlns="urn:jboss:module:1.1" name="org.jboss.qe.jdg.pojos">
> <resources>
> <resource-root path="jdg-pojos-1.2.jar"/>
> <!-- Insert resources here -->
> </resources>
> <dependencies>
> <!-- local -->
> <module name="org.jboss.teiid.resource-adapter.infinispan" slot="6" />
> <!--remote-->
> <module name="org.infinispan.client.hotrod" slot="jdg-6.4" optional="true" export="true" />
> <module name="org.infinispan.protostream" slot="jdg-6.4" optional="true" export="true" />
> <module name="org.infinispan.client.hotrod" slot="jdg-6.5" optional="true" export="true" />
> <module name="org.infinispan.protostream" slot="jdg-6.5" optional="true" export="true" />
> <module name="org.infinispan.client.hotrod" slot="jdg-6.6" optional="true" export="true" />
> <module name="org.infinispan.protostream" slot="jdg-6.6" optional="true" export="true" />
> </dependencies>
> </module>
> {code}
> Resource-adapter configuration:
> {code:xml}
> <resource-adapter id="jdg-ra-ds">
> <module slot="6" id="org.jboss.teiid.resource-adapter.infinispan"/>
> <transaction-support>LocalTransaction</transaction-support>
> <connection-definitions>
> <connection-definition class-name="org.teiid.resource.adapter.infinispan.InfinispanManagedConnectionFactory" jndi-name="java:/infinispanTest" enabled="true" use-java-context="true" pool-name="jdg-ra-ds">
> <config-property name="CacheJndiName">
> java:jboss/infinispan/container/teiid-infinispan-quickstart
> </config-property>
> <config-property name="Module">
> org.jboss.qe.jdg.pojos
> </config-property>
> <config-property name="CacheTypeMap">
> local-quickstart-cache:org.jboss.qe.jdg.pojo.SmallA;intKey
> </config-property>
> </connection-definition>
> </connection-definitions>
> </resource-adapter>
> {code}
> Translator:
> {code:xml}
> <translator name="infinispan-cache" module="org.jboss.teiid.translator.infinispan.cache"/>
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months
[JBoss JIRA] (TEIID-4808) Infinispan Cache Resource Adapter: NullPointerException
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4808?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-4808:
-------------------------------
Git Pull Request: https://github.com/teiid/teiid/pull/940
> Infinispan Cache Resource Adapter: NullPointerException
> -------------------------------------------------------
>
> Key: TEIID-4808
> URL: https://issues.jboss.org/browse/TEIID-4808
> Project: Teiid
> Issue Type: Bug
> Components: JDG Connector
> Affects Versions: 8.12.10.6_3
> Reporter: Jan Stastny
> Assignee: Van Halbert
> Fix For: 8.12.x-6.4
>
>
> There is a NPE when trying to query a local cache via Infinispan Cache translator.
> {code}
> [31m10:27:43,186 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) Connector worker process failed for atomic-request=6chGAXrxul8Z.0.3.0: java.lang.NullPointerException
> at org.teiid.resource.adapter.infinispan.InfinispanCacheWrapper.getClassRegistry(InfinispanCacheWrapper.java:128)
> at org.teiid.resource.adapter.infinispan.InfinispanCacheRAConnection.getClassRegistry(InfinispanCacheRAConnection.java:137)
> at org.teiid.translator.object.ObjectExecution.<init>(ObjectExecution.java:195) [translator-object-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.translator.infinispan.cache.InfinispanCacheExecutionFactory$1.<init>(InfinispanCacheExecutionFactory.java:93) [translator-infinispan-cache-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.translator.infinispan.cache.InfinispanCacheExecutionFactory.createResultSetExecution(InfinispanCacheExecutionFactory.java:93) [translator-infinispan-cache-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.translator.infinispan.cache.InfinispanCacheExecutionFactory.createResultSetExecution(InfinispanCacheExecutionFactory.java:51) [translator-infinispan-cache-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:316) [teiid-api-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:354) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_111]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_111]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_111]
> at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_111]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at com.sun.proxy.$Proxy103.execute(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_111]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_111]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_111]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_111]
> {code}
> POJO's module.xml:
> {code:xml}
> <module xmlns="urn:jboss:module:1.1" name="org.jboss.qe.jdg.pojos">
> <resources>
> <resource-root path="jdg-pojos-1.2.jar"/>
> <!-- Insert resources here -->
> </resources>
> <dependencies>
> <!-- local -->
> <module name="org.jboss.teiid.resource-adapter.infinispan" slot="6" />
> <!--remote-->
> <module name="org.infinispan.client.hotrod" slot="jdg-6.4" optional="true" export="true" />
> <module name="org.infinispan.protostream" slot="jdg-6.4" optional="true" export="true" />
> <module name="org.infinispan.client.hotrod" slot="jdg-6.5" optional="true" export="true" />
> <module name="org.infinispan.protostream" slot="jdg-6.5" optional="true" export="true" />
> <module name="org.infinispan.client.hotrod" slot="jdg-6.6" optional="true" export="true" />
> <module name="org.infinispan.protostream" slot="jdg-6.6" optional="true" export="true" />
> </dependencies>
> </module>
> {code}
> Resource-adapter configuration:
> {code:xml}
> <resource-adapter id="jdg-ra-ds">
> <module slot="6" id="org.jboss.teiid.resource-adapter.infinispan"/>
> <transaction-support>LocalTransaction</transaction-support>
> <connection-definitions>
> <connection-definition class-name="org.teiid.resource.adapter.infinispan.InfinispanManagedConnectionFactory" jndi-name="java:/infinispanTest" enabled="true" use-java-context="true" pool-name="jdg-ra-ds">
> <config-property name="CacheJndiName">
> java:jboss/infinispan/container/teiid-infinispan-quickstart
> </config-property>
> <config-property name="Module">
> org.jboss.qe.jdg.pojos
> </config-property>
> <config-property name="CacheTypeMap">
> local-quickstart-cache:org.jboss.qe.jdg.pojo.SmallA;intKey
> </config-property>
> </connection-definition>
> </connection-definitions>
> </resource-adapter>
> {code}
> Translator:
> {code:xml}
> <translator name="infinispan-cache" module="org.jboss.teiid.translator.infinispan.cache"/>
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months
[JBoss JIRA] (TEIID-4854) Google translator fails to update timestamp value reformatted after update
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4854?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4854:
---------------------------------------
There are 3 resolutions here:
1. document that insert/update/delete is not allowed for non-string values when the spreadsheet is in a non-english locale
2. Require that the user provides the locale as a property to the resource adapter
3. Upgrade to the v4 apis to automatically determine the locale - this is a fairly substantial undertaking
There is a related issue with date/time values. The spreadsheet also has a timezone value that is being ignored - all values are treated as essentially timezone free and read in to the locale timezone of Teiid.
There is another related issue if the user is using custom formats - while we can obtain the pattern from the metadata, it is not an exact match for Java formatting. So we cannot reliable perform insert/update/delete if custom formats are used.
Given all the issues and the scope of 3, it seems like the full resolution may need to be delayed.
> Google translator fails to update timestamp value reformatted after update
> --------------------------------------------------------------------------
>
> Key: TEIID-4854
> URL: https://issues.jboss.org/browse/TEIID-4854
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 9.3, 8.12.10.6_3
> Reporter: Lucie Fabrikova
> Assignee: Steven Hawkins
> Fix For: 9.3
>
> Attachments: gs-reformatted-timestamp.log
>
>
> Cell of type timestamp is reformatted after an update. Data inserted from teiid are in format "yyyy-mm-dd hh:mm:ss[.fffffffff]", which is reformatted to "dd/mm/yyyy hh:mm:ss[.fffffffff]". Subsequent update of such row throws exception "Could not convert source column Source.smalla.timestampvalue to the expected runtime type timestamp".
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months
[JBoss JIRA] (TEIID-4864) Excel translator does not update document
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4864?page=com.atlassian.jira.plugin... ]
Steven Hawkins reassigned TEIID-4864:
-------------------------------------
Fix Version/s: Open To Community
10.x
Assignee: (was: Steven Hawkins)
> Excel translator does not update document
> -----------------------------------------
>
> Key: TEIID-4864
> URL: https://issues.jboss.org/browse/TEIID-4864
> Project: Teiid
> Issue Type: Enhancement
> Components: Misc. Connectors
> Affects Versions: 8.12.9.6_3
> Environment: JDV 6.3.4
> Reporter: Michael Echevarria
> Fix For: Open To Community, 10.x
>
> Attachments: colors.xlsx, error.log
>
>
> *Changed to enhancement*
> When attempting to update a row that is in an excel source, an Unsupported Execution createUpdateExecution is thrown.
> Source file and log attached
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months
[JBoss JIRA] (TEIID-4860) OData4 swallowing exception message
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4860?page=com.atlassian.jira.plugin... ]
Steven Hawkins reassigned TEIID-4860:
-------------------------------------
Fix Version/s: 9.3
Assignee: Ramesh Reddy (was: Steven Hawkins)
> OData4 swallowing exception message
> -----------------------------------
>
> Key: TEIID-4860
> URL: https://issues.jboss.org/browse/TEIID-4860
> Project: Teiid
> Issue Type: Bug
> Components: OData
> Affects Versions: 8.12.6.6_3
> Environment: JDV 6.3.2
> Windows 7
> Reporter: Steve Tran
> Assignee: Ramesh Reddy
> Fix For: 9.3
>
> Attachments: odata2_error_msg.png, odata4_error_msg.png
>
>
> The error message is being swallowed when accessing an endpoint via OData4. A much more useful message get displayed when accessing the same table via the OData2 interface. I'm assuming the same error message (or better) should be displayed via the version 4 interface.
> Here's the stacktrace when reproducing the error for OData4
> {code}
> 17:59:03,779 ERROR [org.teiid.ODATA] (http-0.0.0.0:8080-2) TEIID16052 Unable to process odata request due to: OData Library: An exception without message text was thrown.: org.apache.olingo.server.api.ODataApplicationException
> at org.teiid.olingo.service.TeiidServiceHandler.read(TeiidServiceHandler.java:174) [teiid-olingo-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1]
> at org.apache.olingo.server.core.requests.DataRequest$EntityRequest.execute(DataRequest.java:332)
> at org.apache.olingo.server.core.requests.DataRequest.execute(DataRequest.java:255)
> at org.apache.olingo.server.core.ServiceDispatcher.internalExecute(ServiceDispatcher.java:160)
> at org.apache.olingo.server.core.ServiceDispatcher.execute(ServiceDispatcher.java:98)
> at org.apache.olingo.server.core.OData4HttpHandler.process(OData4HttpHandler.java:66)
> at org.teiid.olingo.web.ODataServlet.service(ODataServlet.java:43) [teiid-olingo-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-2.jar:1.0.2.Final-redhat-2]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]
> at org.teiid.olingo.web.ODataFilter.internalDoFilter(ODataFilter.java:231) [teiid-olingo-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1]
> at org.teiid.olingo.web.ODataFilter.doFilter(ODataFilter.java:100) [teiid-olingo-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]
> at org.teiid.olingo.web.CorsFilter.doFilter(CorsFilter.java:80) [teiid-olingo-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]
> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:512) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]
> at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.5.9.Final-redhat-2.jar:7.5.9.Final-redhat-2]
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:654) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_121]
> Caused by: java.lang.NullPointerException
> at org.teiid.olingo.service.EntityCollectionResponse.isSameRow(EntityCollectionResponse.java:180) [teiid-olingo-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1]
> at org.teiid.olingo.service.EntityCollectionResponse.isSameEntity(EntityCollectionResponse.java:154) [teiid-olingo-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1]
> at org.teiid.olingo.service.LocalClient.executeSQL(LocalClient.java:280) [teiid-olingo-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1]
> at org.teiid.olingo.service.TeiidServiceHandler.executeQuery(TeiidServiceHandler.java:349) [teiid-olingo-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1]
> at org.teiid.olingo.service.TeiidServiceHandler.read(TeiidServiceHandler.java:172) [teiid-olingo-8.12.7.6_3-redhat-1.jar:8.12.7.6_3-redhat-1]
> ... 28 more
> {code}
> And here's the stack trace when reproduced from the OData 2 interface.
> {code}
> 18:01:20,885 WARN [org.teiid.ODATA] (http-0.0.0.0:8080-2) TEIID16012 Could not produce a successful OData response. Returning status ServerErrorException with message Complex key values cannot be null.
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months
[JBoss JIRA] (TEIID-4865) DISTINCT not pushed down to multisource sources
by Harold Campbell (JIRA)
[ https://issues.jboss.org/browse/TEIID-4865?page=com.atlassian.jira.plugin... ]
Harold Campbell commented on TEIID-4865:
----------------------------------------
The workaround does indeed work. Thanks!
> DISTINCT not pushed down to multisource sources
> -----------------------------------------------
>
> Key: TEIID-4865
> URL: https://issues.jboss.org/browse/TEIID-4865
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Affects Versions: 9.2.2
> Reporter: Harold Campbell
> Assignee: Steven Hawkins
> Attachments: DEBUG_LOG
>
>
> Simple DISTINCT queries do not push down DISTINCT to the underlying sources (SQL Server, in this case) of a multisource schema. Instead, all values are selected, and the sorting out is done in teiid.
> {noformat}
> select distinct bic_status
> from account;
> {noformat}
> Debug plan attached.
> This is an enhancement request to support partial distinct pushdown in the multi-source case.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 8 months