[JBoss JIRA] (TEIID-5063) Issues with bigdecimal values and odata
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5063?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-5063:
----------------------------------
Affects Version/s: 9.1
> Issues with bigdecimal values and odata
> ---------------------------------------
>
> Key: TEIID-5063
> URL: https://issues.jboss.org/browse/TEIID-5063
> Project: Teiid
> Issue Type: Bug
> Components: OData
> Affects Versions: 9.1, 8.12.x-6.4
> Reporter: Andrej Šmigala
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 10.0, 8.12.x-6.4, 9.2.6, 9.3.4
>
>
> Usage of bigdecimal literals in odata4 translator literals or procedure parameters results in an exception about the facet not being satisfied.
> We are also with TEIID-4269 we were allowing more than just trailing 0s to be trimmed from the numeric values. This results in situations where you could return an entity with a value, but could not look it up by that value (as it would no longer be equal). We should instead let the facet fail if we can't just trim zeros.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 6 months
[JBoss JIRA] (TEIID-5058) Infinispan Hotrod VDB needs to be redeployed after JDG restart
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-5058?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-5058:
-------------------------------------
[~jstastny] How did you configure your JDG? Can you post the JDG config for this? My local instance is wiping the cache every time I restart the JDG. Also, how did you start the JDG?
> Infinispan Hotrod VDB needs to be redeployed after JDG restart
> --------------------------------------------------------------
>
> Key: TEIID-5058
> URL: https://issues.jboss.org/browse/TEIID-5058
> Project: Teiid
> Issue Type: Bug
> Components: JDG Connector, Misc. Connectors
> Affects Versions: 8.12.x-6.4
> Reporter: Jan Stastny
> Assignee: Ramesh Reddy
> Priority: Critical
>
> When using Infinispan hotrod translator, user defines DDL metadata in source model and let Teiid generate the protobuf and marshaller.
> When JDG is restarted after the VDB is deployed, then the VDB needs to be redeployed because otherwise there is not a Message descriptor registered on the JDG side.
> {code:xml|title=source model}
> <model name="Source" type="PHYSICAL" visible="true">
> <source name="jdg7-source" translator-name="infinispan-hotrod" connection-jndi-name="java:/jdg71HotrodDS" />
> <metadata type="DDL"><![CDATA[
> CREATE FOREIGN TABLE SmallA (
> StringKey string PRIMARY KEY,
> IntKey integer
> ) OPTIONS(UPDATABLE true, "teiid_ispn:cache" 'cache_name');
> ]]>
> </metadata>
> <metadata type = "NATIVE"/>
> </model>
> {code}
> Query performed repeatedly:
> {code:sql|title=query}
> SELECT * FROM SMallA
> {code}
> When query is performed after vdb is deployed, it runs fine.
> When JDG is restarted after the VDB was deployed, the query consecutively fails with:
> {code:title=error}
> 15:49:56,459 WARN [org.infinispan.client.hotrod.impl.protocol.Codec21] (Worker0_QueryProcessorQueue66) ISPN004005: Error received from the server: java.lang.IllegalArgumentException: Message descriptor not found : Source.SmallA
> 15:49:56,460 ERROR [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue66) Connector worker process failed for atomic-request=yxRm19e5AqTO.1.0.8: org.infinispan.client.hotrod.exceptions.HotRodClientException:Request for messageId=30 returned server error (status=0x85): java.lang.IllegalArgumentException: Message descriptor not found : Source.SmallA
> at org.infinispan.client.hotrod.impl.protocol.Codec20.checkForErrorsInResponseStatus(Codec20.java:363) [infinispan-client-hotrod-8.4.0.Final-redhat-2.jar:8.4.0.Final-redhat-2]
> at org.infinispan.client.hotrod.impl.protocol.Codec20.readPartialHeader(Codec20.java:152) [infinispan-client-hotrod-8.4.0.Final-redhat-2.jar:8.4.0.Final-redhat-2]
> at org.infinispan.client.hotrod.impl.protocol.Codec20.readHeader(Codec20.java:138) [infinispan-client-hotrod-8.4.0.Final-redhat-2.jar:8.4.0.Final-redhat-2]
> at org.infinispan.client.hotrod.impl.operations.HotRodOperation.readHeaderAndValidate(HotRodOperation.java:60) [infinispan-client-hotrod-8.4.0.Final-redhat-2.jar:8.4.0.Final-redhat-2]
> at org.infinispan.client.hotrod.impl.operations.QueryOperation.executeOperation(QueryOperation.java:68) [infinispan-client-hotrod-8.4.0.Final-redhat-2.jar:8.4.0.Final-redhat-2]
> at org.infinispan.client.hotrod.impl.operations.QueryOperation.executeOperation(QueryOperation.java:30) [infinispan-client-hotrod-8.4.0.Final-redhat-2.jar:8.4.0.Final-redhat-2]
> at org.infinispan.client.hotrod.impl.operations.RetryOnFailureOperation.execute(RetryOnFailureOperation.java:56) [infinispan-client-hotrod-8.4.0.Final-redhat-2.jar:8.4.0.Final-redhat-2]
> at org.infinispan.client.hotrod.impl.query.RemoteQuery.executeQuery(RemoteQuery.java:68) [infinispan-client-hotrod-8.4.0.Final-redhat-2.jar:8.4.0.Final-redhat-2]
> at org.infinispan.client.hotrod.impl.query.RemoteQuery.list(RemoteQuery.java:53) [infinispan-client-hotrod-8.4.0.Final-redhat-2.jar:8.4.0.Final-redhat-2]
> at org.teiid.translator.infinispan.hotrod.InfinispanResponse.fetchNextBatch(InfinispanResponse.java:74) [translator-infinispan-hotrod-8.12.11.6_4-redhat-6.jar:8.12.11.6_4-redhat-6]
> at org.teiid.translator.infinispan.hotrod.InfinispanResponse.getNextRow(InfinispanResponse.java:90) [translator-infinispan-hotrod-8.12.11.6_4-redhat-6.jar:8.12.11.6_4-redhat-6]
> at org.teiid.translator.infinispan.hotrod.InfinispanQueryExecution.next(InfinispanQueryExecution.java:136) [translator-infinispan-hotrod-8.12.11.6_4-redhat-6.jar:8.12.11.6_4-redhat-6]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:433) [teiid-engine-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:236) [teiid-engine-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_121]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_121]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_121]
> at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_121]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at com.sun.proxy.$Proxy79.more(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309) [teiid-engine-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_121]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280) [teiid-engine-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_121]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_121]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_121]
> 15:49:56,473 WARN [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue67) TEIID30020 Processing exception for request yxRm19e5AqTO.1 'TEIID30504 jdg7-source-1: java.lang.IllegalArgumentException: Message descriptor not found : Source.SmallA'. Originally TeiidProcessingException Codec20.java:363. Enable more detailed logging to see the entire stacktrace.
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 6 months
[JBoss JIRA] (TEIID-4888) Support for SetQueryLimit
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4888?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-4888.
-----------------------------------
Resolution: Done
Added a new capability supportsSetQueryLimitOffset to handle this issue. This may still not exactly match openedge as it appears that cursor operations must be restricted to a top level select with other restrictions. This change will only prevent the placement directly on a set query, but if views are supported or the limit is pushed further it could still be placed in nested selects.
> Support for SetQueryLimit
> -------------------------
>
> Key: TEIID-4888
> URL: https://issues.jboss.org/browse/TEIID-4888
> Project: Teiid
> Issue Type: Feature Request
> Components: JDBC Connector
> Reporter: German Tejero
> Assignee: Steven Hawkins
> Priority: Minor
> Fix For: 10.0
>
>
> OpenEdge RDBMS not support fetch/offset in a set query. For example, the generated SQL:
> SELECT
> g_1.ejer AS c_0
> FROM PUB.modpre AS g_1
> UNION ALL
> SELECT
> g_0.ejer AS c_0
> FROM PUB.modesp AS g_0
> FETCH NEXT 100 ROWS ONLY
> For the view:
> CREATE VIEW Modificaciones(
> ejercicio INTEGER
> )AS SELECT T.ejercicio
> FROM(
> SELECT M.ejercicio,
> FROM sipbas.modesp AS M
> UNION ALL
> SELECT M.ejercicio
> FROM sipbas.modpre AS M) AS T;
> It is necessary to be able to indicate SetQueryLimit in the same way as with SetQueryOrderBy.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 6 months
[JBoss JIRA] (TEIID-5063) Issues with bigdecimal values and odata
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5063?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-5063:
----------------------------------
Description:
Usage of bigdecimal literals in odata4 translator literals or procedure parameters results in an exception about the facet not being satisfied.
We are also with TEIID-4269 we were allowing more than just trailing 0s to be trimmed from the numeric values. This results in situations where you could return an entity with a value, but could not look it up by that value (as it would no longer be equal). We should instead let the facet fail if we can't just trim zeros.
was:
When querying a view with bigdecimal column thourgh odata, the following error is shown:
{noformat}
16:29:33,079 ERROR [org.teiid.ODATA] (http-0.0.0.0:8080-1) TEIID16050 Unable to process odata request due to: org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value '5.12' does not match the facets' constraints. with cause The value '5.12' does not match the facets' constraints.: org.apache.olingo.server.api.ODataApplicationException: org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value '5.12' does not match the facets' constraints.
at org.teiid.olingo.service.TeiidServiceHandler.read(TeiidServiceHandler.java:173) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
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:67)
at org.teiid.olingo.web.ODataServlet.service(ODataServlet.java:43) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
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.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
at org.teiid.olingo.web.ODataFilter.internalDoFilter(ODataFilter.java:231) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
at org.teiid.olingo.web.ODataFilter.doFilter(ODataFilter.java:100) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
at org.teiid.olingo.web.CorsFilter.doFilter(CorsFilter.java:80) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:512) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.5.16.Final-redhat-1.jar:7.5.16.Final-redhat-1]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:151) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:656) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_131]
Caused by: java.sql.SQLException: org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value '5.12' does not match the facets' constraints.
at org.teiid.olingo.service.EntityCollectionResponse.createEntity(EntityCollectionResponse.java:229) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
at org.teiid.olingo.service.EntityCollectionResponse.createEntity(EntityCollectionResponse.java:148) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
at org.teiid.olingo.service.EntityCollectionResponse.addRow(EntityCollectionResponse.java:99) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
at org.teiid.olingo.service.LocalClient.executeSQL(LocalClient.java:298) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
at org.teiid.olingo.service.TeiidServiceHandler.executeQuery(TeiidServiceHandler.java:348) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
at org.teiid.olingo.service.TeiidServiceHandler.read(TeiidServiceHandler.java:171) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
... 28 more
Caused by: org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value '5.12' does not match the facets' constraints.
at org.apache.olingo.commons.core.edm.primitivetype.EdmDecimal.internalValueToString(EdmDecimal.java:185)
at org.apache.olingo.commons.core.edm.primitivetype.AbstractPrimitiveType.valueToString(AbstractPrimitiveType.java:86)
at org.apache.olingo.server.core.responses.EntityResponse.buildLocation(EntityResponse.java:219)
at org.teiid.olingo.service.EntityCollectionResponse.createEntity(EntityCollectionResponse.java:201) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
... 33 more
{noformat}
Fix Version/s: 10.0
8.12.x-6.4
9.3.4
9.2.6
Steps to Reproduce: (was: # deploy the following VDB:
{code:xml}
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<vdb name="teiid-4446" version="1">
<model name="views" type="VIRTUAL">
<metadata type="DDL">
<![CDATA[
CREATE VIEW vv1 (id bigdecimal PRIMARY KEY) AS (SELECT 5.12 AS id);
CREATE VIEW vv2 (id bigdecimal(3,2) PRIMARY KEY) AS (SELECT 5.12 AS id);
CREATE VIEW vv3 (id bigdecimal(3) PRIMARY KEY) AS (SELECT 5.12 AS id);
]]>
</metadata>
</model>
</vdb>
{code}
# go to http://localhost:8080/odata4/teiid-4446.1/views/vv1)
Summary: Issues with bigdecimal values and odata (was: Error when querying bigdecimal value through odata)
> Issues with bigdecimal values and odata
> ---------------------------------------
>
> Key: TEIID-5063
> URL: https://issues.jboss.org/browse/TEIID-5063
> Project: Teiid
> Issue Type: Bug
> Components: OData
> Affects Versions: 8.12.x-6.4
> Reporter: Andrej Šmigala
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 10.0, 8.12.x-6.4, 9.2.6, 9.3.4
>
>
> Usage of bigdecimal literals in odata4 translator literals or procedure parameters results in an exception about the facet not being satisfied.
> We are also with TEIID-4269 we were allowing more than just trailing 0s to be trimmed from the numeric values. This results in situations where you could return an entity with a value, but could not look it up by that value (as it would no longer be equal). We should instead let the facet fail if we can't just trim zeros.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 6 months
[JBoss JIRA] (TEIID-5063) Error when querying bigdecimal value through odata
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5063?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5063:
---------------------------------------
> We also introduce an issue with an comparisons when we truncate/round anything other than trailing zeros, that at least needs to be documented.
It looks like the best idea is to restrict the conversion to just trim trailing 0s.
> Other insert/update values
It appears that the parsing logic at least for olingo should be tolerant of extra 0s, so we don't necessarily need to make changes there yet.
I'll update this JIRA accordingly.
> Error when querying bigdecimal value through odata
> --------------------------------------------------
>
> Key: TEIID-5063
> URL: https://issues.jboss.org/browse/TEIID-5063
> Project: Teiid
> Issue Type: Bug
> Components: OData
> Affects Versions: 8.12.x-6.4
> Reporter: Andrej Šmigala
> Assignee: Steven Hawkins
> Priority: Blocker
>
> When querying a view with bigdecimal column thourgh odata, the following error is shown:
> {noformat}
> 16:29:33,079 ERROR [org.teiid.ODATA] (http-0.0.0.0:8080-1) TEIID16050 Unable to process odata request due to: org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value '5.12' does not match the facets' constraints. with cause The value '5.12' does not match the facets' constraints.: org.apache.olingo.server.api.ODataApplicationException: org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value '5.12' does not match the facets' constraints.
> at org.teiid.olingo.service.TeiidServiceHandler.read(TeiidServiceHandler.java:173) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> 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:67)
> at org.teiid.olingo.web.ODataServlet.service(ODataServlet.java:43) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> 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.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.teiid.olingo.web.ODataFilter.internalDoFilter(ODataFilter.java:231) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.olingo.web.ODataFilter.doFilter(ODataFilter.java:100) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.teiid.olingo.web.CorsFilter.doFilter(CorsFilter.java:80) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:512) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.5.16.Final-redhat-1.jar:7.5.16.Final-redhat-1]
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:151) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:656) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_131]
> Caused by: java.sql.SQLException: org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value '5.12' does not match the facets' constraints.
> at org.teiid.olingo.service.EntityCollectionResponse.createEntity(EntityCollectionResponse.java:229) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.olingo.service.EntityCollectionResponse.createEntity(EntityCollectionResponse.java:148) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.olingo.service.EntityCollectionResponse.addRow(EntityCollectionResponse.java:99) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.olingo.service.LocalClient.executeSQL(LocalClient.java:298) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.olingo.service.TeiidServiceHandler.executeQuery(TeiidServiceHandler.java:348) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.olingo.service.TeiidServiceHandler.read(TeiidServiceHandler.java:171) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> ... 28 more
> Caused by: org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value '5.12' does not match the facets' constraints.
> at org.apache.olingo.commons.core.edm.primitivetype.EdmDecimal.internalValueToString(EdmDecimal.java:185)
> at org.apache.olingo.commons.core.edm.primitivetype.AbstractPrimitiveType.valueToString(AbstractPrimitiveType.java:86)
> at org.apache.olingo.server.core.responses.EntityResponse.buildLocation(EntityResponse.java:219)
> at org.teiid.olingo.service.EntityCollectionResponse.createEntity(EntityCollectionResponse.java:201) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> ... 33 more
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 6 months
[JBoss JIRA] (TEIID-5063) Error when querying bigdecimal value through odata
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5063?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5063:
---------------------------------------
The issues I see are:
visitation logic is not correct in ODataFilterVisitor wrt expression type handling
usage of ODataTypeManager.convertToODataURIValue doesn't convert bigdecimal values to type constraints
Other insert/update values
We also introduce an issue with an comparisons when we truncate/round anything other than trailing zeros, that at least needs to be documented.
> Error when querying bigdecimal value through odata
> --------------------------------------------------
>
> Key: TEIID-5063
> URL: https://issues.jboss.org/browse/TEIID-5063
> Project: Teiid
> Issue Type: Bug
> Components: OData
> Affects Versions: 8.12.x-6.4
> Reporter: Andrej Šmigala
> Assignee: Steven Hawkins
> Priority: Blocker
>
> When querying a view with bigdecimal column thourgh odata, the following error is shown:
> {noformat}
> 16:29:33,079 ERROR [org.teiid.ODATA] (http-0.0.0.0:8080-1) TEIID16050 Unable to process odata request due to: org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value '5.12' does not match the facets' constraints. with cause The value '5.12' does not match the facets' constraints.: org.apache.olingo.server.api.ODataApplicationException: org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value '5.12' does not match the facets' constraints.
> at org.teiid.olingo.service.TeiidServiceHandler.read(TeiidServiceHandler.java:173) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> 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:67)
> at org.teiid.olingo.web.ODataServlet.service(ODataServlet.java:43) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> 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.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.teiid.olingo.web.ODataFilter.internalDoFilter(ODataFilter.java:231) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.olingo.web.ODataFilter.doFilter(ODataFilter.java:100) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.teiid.olingo.web.CorsFilter.doFilter(CorsFilter.java:80) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:512) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.5.16.Final-redhat-1.jar:7.5.16.Final-redhat-1]
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:151) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:656) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_131]
> Caused by: java.sql.SQLException: org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value '5.12' does not match the facets' constraints.
> at org.teiid.olingo.service.EntityCollectionResponse.createEntity(EntityCollectionResponse.java:229) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.olingo.service.EntityCollectionResponse.createEntity(EntityCollectionResponse.java:148) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.olingo.service.EntityCollectionResponse.addRow(EntityCollectionResponse.java:99) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.olingo.service.LocalClient.executeSQL(LocalClient.java:298) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.olingo.service.TeiidServiceHandler.executeQuery(TeiidServiceHandler.java:348) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.olingo.service.TeiidServiceHandler.read(TeiidServiceHandler.java:171) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> ... 28 more
> Caused by: org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value '5.12' does not match the facets' constraints.
> at org.apache.olingo.commons.core.edm.primitivetype.EdmDecimal.internalValueToString(EdmDecimal.java:185)
> at org.apache.olingo.commons.core.edm.primitivetype.AbstractPrimitiveType.valueToString(AbstractPrimitiveType.java:86)
> at org.apache.olingo.server.core.responses.EntityResponse.buildLocation(EntityResponse.java:219)
> at org.teiid.olingo.service.EntityCollectionResponse.createEntity(EntityCollectionResponse.java:201) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> ... 33 more
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 6 months
[JBoss JIRA] (TEIID-5060) Infinispan Hotrod Translator UPDATE on primary key column
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5060?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5060:
---------------------------------------
later releases are more strict with comparisons - TEIID-3722
> Infinispan Hotrod Translator UPDATE on primary key column
> ---------------------------------------------------------
>
> Key: TEIID-5060
> URL: https://issues.jboss.org/browse/TEIID-5060
> Project: Teiid
> Issue Type: Bug
> Components: JDG Connector, Misc. Connectors
> Reporter: Jan Stastny
> Assignee: Ramesh Reddy
> Priority: Blocker
> Fix For: 10.0
>
>
> UPDATE query where the PRIMARY KEY of the table is being changed succeeds, returns update count of corresponding rows, but the changes don't get promoted to actual cache.
> Consider
> {code:sql|title=UPDATE query}
> UPDATE SmallA SET StringKey = 100 WHERE IntKey > 25
> {code}
> where StringKey is set as PRIMARY KEY and 6 rows fulfill the filter on IntKey>25.
> When this UPDATE is performed, returned number of rows update is 6, but the contents of the cache don't change.
> There are several applicable resolutions:
> # There should be error thrown by Teiid, that this is not allowed operation
> # There should be update count 0 returned
> # There should be change in JDG cache, effectively squashing the 6 rows into single one
> # There should be error thrown by Teiid, that there is duplicate PK value (this is not something Teiid usually enforces)
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 6 months
[JBoss JIRA] (TEIID-5060) Infinispan Hotrod Translator UPDATE on primary key column
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-5060?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-5060:
-------------------------------------
You are comparing the StringKey with an integer value. The latest master code fails with a resolution error which is correct. I would think any implicit conversions will be done before it reaches the translator layer. May be this check is not there in 6.4. [~shawkins] should know.
{code}
11:48:18,677 WARN [org.teiid.PROCESSOR] (Worker8_QueryProcessorQueue66) TmA7S72KI8PR TEIID30020 Processing exception for request TmA7S72KI8PR.11 'TEIID31172 Could not resolve expressions being compared to a common type excluding character conversions: CRUD.SmallA.StringNum > 30'. Originally QueryResolverException ResolverVisitor.java:1041.: org.teiid.api.exception.query.QueryResolverException: TEIID31172 Could not resolve expressions being compared to a common type excluding character conversions: CRUD.SmallA.StringNum > 30
at org.teiid.query.resolver.util.ResolverVisitor.resolveCompareCriteria(ResolverVisitor.java:1041)
at org.teiid.query.resolver.util.ResolverVisitor.visit(ResolverVisitor.java:245)
at org.teiid.query.sql.lang.CompareCriteria.acceptVisitor(CompareCriteria.java:126)
at org.teiid.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:50)
at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.postVisitVisitor(PreOrPostOrderNavigator.java:57)
at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.postVisitVisitor(SimpleQueryResolver.java:219)
at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:131)
at org.teiid.query.sql.lang.CompareCriteria.acceptVisitor(CompareCriteria.java:126)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:59)
at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:234)
at org.teiid.query.resolver.command.SimpleQueryResolver.resolveCommand(SimpleQueryResolver.java:66)
at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:282)
at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:128)
at org.teiid.dqp.internal.process.Request.resolveCommand(Request.java:278)
at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:414)
at org.teiid.dqp.internal.process.Request.processRequest(Request.java:482)
at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:655)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:334)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:47)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:271)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
{code}
> Infinispan Hotrod Translator UPDATE on primary key column
> ---------------------------------------------------------
>
> Key: TEIID-5060
> URL: https://issues.jboss.org/browse/TEIID-5060
> Project: Teiid
> Issue Type: Bug
> Components: JDG Connector, Misc. Connectors
> Reporter: Jan Stastny
> Assignee: Ramesh Reddy
> Priority: Blocker
> Fix For: 10.0
>
>
> UPDATE query where the PRIMARY KEY of the table is being changed succeeds, returns update count of corresponding rows, but the changes don't get promoted to actual cache.
> Consider
> {code:sql|title=UPDATE query}
> UPDATE SmallA SET StringKey = 100 WHERE IntKey > 25
> {code}
> where StringKey is set as PRIMARY KEY and 6 rows fulfill the filter on IntKey>25.
> When this UPDATE is performed, returned number of rows update is 6, but the contents of the cache don't change.
> There are several applicable resolutions:
> # There should be error thrown by Teiid, that this is not allowed operation
> # There should be update count 0 returned
> # There should be change in JDG cache, effectively squashing the 6 rows into single one
> # There should be error thrown by Teiid, that there is duplicate PK value (this is not something Teiid usually enforces)
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 6 months
[JBoss JIRA] (TEIID-5046) DuplicateRecordException when adding some tables with dots in columns
by dalex dalex (JIRA)
[ https://issues.jboss.org/browse/TEIID-5046?page=com.atlassian.jira.plugin... ]
dalex dalex commented on TEIID-5046:
------------------------------------
Thx a lot [~shawkins] !
> DuplicateRecordException when adding some tables with dots in columns
> ---------------------------------------------------------------------
>
> Key: TEIID-5046
> URL: https://issues.jboss.org/browse/TEIID-5046
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector, Query Engine
> Affects Versions: 9.3.1
> Environment: teiid-9.3.1 on WildFly Full 10.0.0.Final (WildFly Core 2.0.10.Final)
> Reporter: dalex dalex
> Assignee: Steven Hawkins
> Fix For: 10.0
>
>
> when adding such table:
> {code:sql}
> create table t1 (
> "a.b" int,
> "a_b" int
> );
> {code}
> we will get the following stacktrace:
> {noformat}
> 2017-08-31 15:21:34,121 WARN [org.teiid.RUNTIME] (Worker1_async-teiid-threads1) TEIID50036 VDB test.1 model "test_pg" metadata failed to load. Reason:TEIID60016 Duplicate Column te
> st_pg.t1.a_b: org.teiid.metadata.DuplicateRecordException: TEIID60016 Duplicate Column test_pg.t1.a_b
> at org.teiid.metadata.MetadataFactory.addColumn(MetadataFactory.java:198)
> at org.teiid.translator.jdbc.JDBCMetdataProcessor.addColumn(JDBCMetdataProcessor.java:449)
> at org.teiid.translator.jdbc.JDBCMetdataProcessor.processColumns(JDBCMetdataProcessor.java:410)
> at org.teiid.translator.jdbc.JDBCMetdataProcessor.getColumns(JDBCMetdataProcessor.java:385)
> at org.teiid.translator.jdbc.JDBCMetdataProcessor.getTables(JDBCMetdataProcessor.java:336)
> at org.teiid.translator.jdbc.JDBCMetdataProcessor.getConnectorMetadata(JDBCMetdataProcessor.java:166)
> at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:306)
> at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:69)
> at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:96)
> at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:62)
> at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
> at org.teiid.jboss.VDBService$6.run(VDBService.java:341)
> at org.teiid.jboss.VDBService$7.run(VDBService.java:392)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:284)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> {noformat}
> I suppose the problem related to auto replacement of dots on underscores which was fixed in TEIID-4913 issue. Maybe it's worth to introduce some kind of indexes in column names if there is already a column with the same name instead of throwing out DuplicateRecordException. Or maybe there is an another solution.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 6 months
[JBoss JIRA] (TEIID-5063) Error when querying bigdecimal value through odata
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5063?page=com.atlassian.jira.plugin... ]
Steven Hawkins reopened TEIID-5063:
-----------------------------------
There are still changes on the Teiid side to accommodate this - ODataTypeManager method used by the odata translator and we may need to handle the string max length differently.
> Error when querying bigdecimal value through odata
> --------------------------------------------------
>
> Key: TEIID-5063
> URL: https://issues.jboss.org/browse/TEIID-5063
> Project: Teiid
> Issue Type: Bug
> Components: OData
> Affects Versions: 8.12.x-6.4
> Reporter: Andrej Šmigala
> Assignee: Steven Hawkins
> Priority: Blocker
>
> When querying a view with bigdecimal column thourgh odata, the following error is shown:
> {noformat}
> 16:29:33,079 ERROR [org.teiid.ODATA] (http-0.0.0.0:8080-1) TEIID16050 Unable to process odata request due to: org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value '5.12' does not match the facets' constraints. with cause The value '5.12' does not match the facets' constraints.: org.apache.olingo.server.api.ODataApplicationException: org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value '5.12' does not match the facets' constraints.
> at org.teiid.olingo.service.TeiidServiceHandler.read(TeiidServiceHandler.java:173) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> 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:67)
> at org.teiid.olingo.web.ODataServlet.service(ODataServlet.java:43) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> 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.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.teiid.olingo.web.ODataFilter.internalDoFilter(ODataFilter.java:231) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.olingo.web.ODataFilter.doFilter(ODataFilter.java:100) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.teiid.olingo.web.CorsFilter.doFilter(CorsFilter.java:80) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:512) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.5.16.Final-redhat-1.jar:7.5.16.Final-redhat-1]
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:151) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:656) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.5.23.Final-redhat-1.jar:7.5.23.Final-redhat-1]
> at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_131]
> Caused by: java.sql.SQLException: org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value '5.12' does not match the facets' constraints.
> at org.teiid.olingo.service.EntityCollectionResponse.createEntity(EntityCollectionResponse.java:229) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.olingo.service.EntityCollectionResponse.createEntity(EntityCollectionResponse.java:148) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.olingo.service.EntityCollectionResponse.addRow(EntityCollectionResponse.java:99) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.olingo.service.LocalClient.executeSQL(LocalClient.java:298) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.olingo.service.TeiidServiceHandler.executeQuery(TeiidServiceHandler.java:348) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> at org.teiid.olingo.service.TeiidServiceHandler.read(TeiidServiceHandler.java:171) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> ... 28 more
> Caused by: org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value '5.12' does not match the facets' constraints.
> at org.apache.olingo.commons.core.edm.primitivetype.EdmDecimal.internalValueToString(EdmDecimal.java:185)
> at org.apache.olingo.commons.core.edm.primitivetype.AbstractPrimitiveType.valueToString(AbstractPrimitiveType.java:86)
> at org.apache.olingo.server.core.responses.EntityResponse.buildLocation(EntityResponse.java:219)
> at org.teiid.olingo.service.EntityCollectionResponse.createEntity(EntityCollectionResponse.java:201) [teiid-olingo-8.12.11.6_4-redhat-64-6.jar:8.12.11.6_4-redhat-64-6]
> ... 33 more
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 6 months