June 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4171) TEIID40088 Could not replicate object org.teiid.query.tempdata.GlobalTableStoreImpl message

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4171?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4171. --------------------------------- > TEIID40088 Could not replicate object org.teiid.query.tempdata.GlobalTableStoreImpl message > ------------------------------------------------------------------------------------------- > > Key: TEIID-4171 > URL: https://issues.jboss.org/browse/TEIID-4171 > Project: Teiid > Issue Type: Bug > Environment: Red Hat JBoss Data Virtualization 6.2.4 on EAP patched to version 6.4.6, on Oracle Linux 6 > JBoss Developer Studio 8.1.0GA with Teiid Designer 9.0.6.Final-v20160316-1409-B1242 org.teiid.designer.feature.feature.group JBoss by Red Hat, Inc. > 64-bit Windows 7 environment > Reporter: Steve Tran > Assignee: Steven Hawkins > > Getting an error while replacing an existing VDB with JDV 6.2.4. I think the logging level is inappropriate since the VDB has full functionality since I am able to connect and execute some queries. Could lead to something more serious though, so reporting it as a bug until proven innocent. > {code} > [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,954 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster > ="STEVE.1",protocol=UFCESC[0m > [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,955 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster > ="STEVE.1",protocol=GMSESC[0m > [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,957 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster > ="STEVE.1",protocol=STABLEESC[0m > [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,958 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster > ="STEVE.1",protocol=UNICAST2ESC[0m > [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,959 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster > ="STEVE.1",protocol=NAKACKESC[0m > [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,961 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster > ="STEVE.1",protocol=BARRIERESC[0m > [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,961 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster > ="STEVE.1",protocol=VERIFY_SUSPECTESC[0m > [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,962 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster > ="STEVE.1",protocol=FDESC[0m > [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,963 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster="STEVE.1",protocol=FD_SOCKESC[0m > [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,964 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster="STEVE.1",protocol=MERGE2ESC[0m > [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,964 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster="STEVE.1",protocol=TCPPINGESC[0m > [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,965 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=protocol,cluster="STEVE.1",protocol=TCPESC[0m > [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[33m22:08:39,968 WARN [org.jgroups.jmx.JmxConfigurator] (teiid-async-threads - 8) unregistering already registered MBean: jgroups:type=channel,cluster="STEVE.1"ESC[0m > [Server:cdtssoa126d-jdv-one] ESC[33mESC[0mESC[31m22:08:39,969 ERROR [org.teiid.RUNTIME] (teiid-async-threads - 8) TEIID40088 Could not replicate object org.teiid.query.tempdata.GlobalTableStoreImpl@6518dd87: java.lang.IllegalStateException: cluster 'STEVE.1' is already connected to singleton transport: [dummy-1461636444525, dummy-1461636519952, PHX_ODS_DMM_LEGACY.1, PHX_ODS_DBA.1, Odata_TEST.1, ProjectionsUSHSI.1, ImputationV1.1, GMR_SQLDB_TEST.1, UK_PBS_VDB.1, EDE_US.1, BDF_CorrectionsVDB_V1.1, ImputationV1_DEV.1, HSISIT.1, UKPROJECTION.1, Gossip.1, HCR_CADM_CR_PROC.1, HSIWIP.1, MyVDB.1, dummy-1460722343623, HSIRES.1, KnowledgeFactory_Job.1, HSITEST.1, HCR_CADM_SYNDICATED.1, COL_VDB.1, dummy-1460722100133, $TEIID_BM$, BDF_CorrectionsVDB_SIT.1, dummy-1460720870935, PROJECTIONTEMPVDB.1, UK_PBS_Project_VDB.1, PROJECTIONVDB.1, $TEIID_ED$, DeployVDB.1, GMR_SQLDB_DBA.1, teiid-cache, STEVE.1, dummy-1460722176622, HCR_CADM.1, HSI.1, dummy-1461636277237, DedupsVdb.1, IMPUTATION_FRANCE.1, dummy-1460720872393, MSTRTestVdb.1]ESC[0m > [Server:cdtssoa126d-jdv-one] ESC[31m at org.jgroups.stack.ProtocolStack.startStack(ProtocolStack.java:919) [jgroups-3.2.15.Final-redhat-1.jar:3.2.15.Final-redhat-1]ESC[0m > [Server:cdtssoa126d-jdv-one] ESC[31m at org.jgroups.JChannel.startStack(JChannel.java:827) [jgroups-3.2.15.Final-redhat-1.jar:3.2.15.Final-redhat-1]ESC[0m > [Server:cdtssoa126d-jdv-one] ESC[31m at org.jgroups.JChannel._preConnect(JChannel.java:525) [jgroups-3.2.15.Final-redhat-1.jar:3.2.15.Final-redhat-1]ESC[0m > [Server:cdtssoa126d-jdv-one] ESC[31m at org.jgroups.JChannel.connect(JChannel.java:277) [jgroups-3.2.15.Final-redhat-1.jar:3.2.15.Final-redhat-1]ESC[0m > [Server:cdtssoa126d-jdv-one] ESC[31m at org.jgroups.JChannel.connect(JChannel.java:268) [jgroups-3.2.15.Final-redhat-1.jar:3.2.15.Final-redhat-1]ESC[0m > [Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.replication.jgroups.JGroupsObjectReplicator.replicate(JGroupsObjectReplicator.java:564) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]ESC[0m > [Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.deployers.CompositeGlobalTableStore.createInstance(CompositeGlobalTableStore.java:57) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2] > ESC[0m > [Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.jboss.VDBService$1.finishedDeployment(VDBService.java:156) [teiid-jboss-integration-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]ESC[0m > [Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.deployers.VDBRepository.notifyFinished(VDBRepository.java:348) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]ESC[0m > [Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:304) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]ESC[0m > [Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:202) [teiid-runtime-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]ESC[0m > [Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.jboss.VDBService.access$1100(VDBService.java:85) [teiid-jboss-integration-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]ESC[0m > [Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.jboss.VDBService$6.run(VDBService.java:408) [teiid-jboss-integration-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]ESC[0m > [Server:cdtssoa126d-jdv-one] ESC[31m at org.teiid.jboss.VDBService$7.run(VDBService.java:439) [teiid-jboss-integration-8.7.5.6_2-redhat-2.jar:8.7.5.6_2-redhat-2]ESC[0m > [Server:cdtssoa126d-jdv-one] ESC[31m at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75]ESC[0m > [Server:cdtssoa126d-jdv-one] ESC[31m at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75]ESC[0m > [Server:cdtssoa126d-jdv-one] ESC[31m at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75]ESC[0m > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4179) Update the documentation of the ODBC with connection properties

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4179?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4179. --------------------------------- > Update the documentation of the ODBC with connection properties > ---------------------------------------------------------------- > > Key: TEIID-4179 > URL: https://issues.jboss.org/browse/TEIID-4179 > Project: Teiid > Issue Type: Task > Components: Documentation > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 9.0 > > > ConnSettings =SET resultSetCacheMode TO 'true' > That will set the connection property. Please this applies any connection property. If there are multiple, you delimit them by ; Similarly in Windows DSN wizard too. > In the vdb.xml, you can add a vdb level property like > <vdb name="..."> > <property name="connection.resultSetCacheMode" value="true"/> > ... > </vdb> -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4203) QueryResolverException thow in resolving loadMatView

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4203?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4203. --------------------------------- > QueryResolverException thow in resolving loadMatView > ----------------------------------------------------- > > Key: TEIID-4203 > URL: https://issues.jboss.org/browse/TEIID-4203 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 9.0 > Reporter: Kylin Soong > Assignee: Steven Hawkins > Fix For: 9.0 > > Attachments: server.log > > > The Change in 9.0.0.Beta2-SNAPSHOT cause loadMatView resolving failed > {code} > Caused by: org.teiid.api.exception.query.QueryResolverException: TEIID31172 Could not resolve expressions being compared to a common type excluding character conversions: VDBVersion = DVARS.vdbVersion > at org.teiid.query.resolver.util.ResolverVisitor.resolveCompareCriteria(ResolverVisitor.java:999) > at org.teiid.query.resolver.util.ResolverVisitor.visit(ResolverVisitor.java:249) > at org.teiid.query.sql.lang.CompareCriteria.acceptVisitor(CompareCriteria.java:130) > at org.teiid.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:54) > at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.postVisitVisitor(PreOrPostOrderNavigator.java:61) > at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.postVisitVisitor(SimpleQueryResolver.java:223) > at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:135) > at org.teiid.query.sql.lang.CompareCriteria.acceptVisitor(CompareCriteria.java:130) > at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:63) > at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:76) > at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:139) > at org.teiid.query.sql.lang.CompoundCriteria.acceptVisitor(CompoundCriteria.java:235) > at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:63) > at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:238) > at org.teiid.query.resolver.command.SimpleQueryResolver.resolveCommand(SimpleQueryResolver.java:70) > at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:273) > at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:127) > at org.teiid.query.processor.proc.ExecDynamicSqlInstruction.process(ExecDynamicSqlInstruction.java:171) > ... 22 more > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4138) Move teiid embedded example doc to gitbook

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4138?page=com.atlassian.jira.plugin... ] Steven Hawkins reopened TEIID-4138: ----------------------------------- > Move teiid embedded example doc to gitbook > ------------------------------------------ > > Key: TEIID-4138 > URL: https://issues.jboss.org/browse/TEIID-4138 > Project: Teiid > Issue Type: Sub-task > Components: Documentation > Affects Versions: 9.x > Reporter: Kylin Soong > Assignee: Kylin Soong > Fix For: 9.x > > > Moving the doc from https://docs.jboss.org/author/display/teiidexamples/Teiid+Embedded+Examples to gitbook -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3834) Error during (re) adding connection factory using CLI

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3834?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3834: ---------------------------------- Fix Version/s: (was: 9.0) > Error during (re) adding connection factory using CLI > ----------------------------------------------------- > > Key: TEIID-3834 > URL: https://issues.jboss.org/browse/TEIID-3834 > Project: Teiid > Issue Type: Sub-task > Components: Server > Affects Versions: 8.13 > Reporter: Kylin Soong > Assignee: Ramesh Reddy > > enable datasource command > {code} > /subsystem=datasources/data-source=h2:enable > {code} > seems redundant, cause datasource add already enable it, so if execute setup.cli > {code} > ./bin/jboss-cli.sh --connect --file=setup.cli > {code} > will cause a eror > {code} > { > "outcome" => "failed", > "failure-description" => "WFLYCTL0158: Operation handler failed: org.jboss.msc.service.DuplicateServiceException: Service jboss.data-source-config.h2 is already registered", > "rolled-back" => true > } > 14:35:55,436 ERROR [org.jboss.as.controller.management-operation] (management-handler-thread - 9) WFLYCTL0013: Operation ("enable") failed - address: ([ > ("subsystem" => "datasources"), > ("data-source" => "h2") > ]): org.jboss.msc.service.DuplicateServiceException: Service jboss.data-source-config.h2 is already registered > at org.jboss.msc.service.ServiceRegistrationImpl.setInstance(ServiceRegistrationImpl.java:158) > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2132) Teiid 8.0 API does not expose boundport in Mbean attribute for Teiid-JDBC

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2132?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2132: ---------------------------------- Fix Version/s: (was: 9.0) > Teiid 8.0 API does not expose boundport in Mbean attribute for Teiid-JDBC > ------------------------------------------------------------------------- > > Key: TEIID-2132 > URL: https://issues.jboss.org/browse/TEIID-2132 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.0 > Environment: jboss 7, teiid 8, windows 7 > Reporter: Akshay Harale > Assignee: Ramesh Reddy > Priority: Minor > Labels: jboss, teiid > > When offset is set for jboss from standalone.xml or standalone.conf.bat file, the bound port is not displyed in MBean server. > > For example, > > <socket-binding-group name="standard-sockets" default-interface="public" port-offset="${jboss.socket.binding.port-offset:25}"> > > In above line if I set the value as 25 then that should be added to the default socket port values and exposed as bound port value in MBean server. But in case of teiid the "teiid-jdbc" 's boundPort value is not exposed by the jboss. > > All other boundPorts values are correctly shown in Mbean, except teiid-jdbc -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4044) OData ignores entities with empty list of related entities if $filter is applied to expanded entities

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4044?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4044: ---------------------------------- Fix Version/s: 9.0 8.12.5 > OData ignores entities with empty list of related entities if $filter is applied to expanded entities > ----------------------------------------------------------------------------------------------------- > > Key: TEIID-4044 > URL: https://issues.jboss.org/browse/TEIID-4044 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > If user want to apply filter for related entities, OData service should return all entities, not only those with non-empty collection of related entities. > *Example:* > *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$expand=Order... > *Result:* OData returns only 2 customers (both have at least one order with place "town") > *Expectation:* OData should return all 4 customers (two of them should have empty list of orders) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4041) OData response does not contain header "allow"

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4041?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4041: ---------------------------------- Fix Version/s: 9.0 8.12.5 > OData response does not contain header "allow" > ---------------------------------------------- > > Key: TEIID-4041 > URL: https://issues.jboss.org/browse/TEIID-4041 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > If user sends request to URL with unsupported HTTP method, OData service should return allowed methods in header _allow_. > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/ > *Method:* DELETE > *Response headers:* date=Wed, 09 Mar 2016 08:21:17 GMT, server=Apache-Coyote/1.1, content-length=192, expires=Thu, 01 Jan 1970 00:00:00 GMT+00:00, content-type=application/xml, cache-control=no-cache, pragma=No-cache, odata-version=4.0 > See http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part1-pr... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4192) If a column is blank the TEXTAGG function excludes it from the output

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4192?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4192: ---------------------------------- Component/s: Query Engine > If a column is blank the TEXTAGG function excludes it from the output > ---------------------------------------------------------------------- > > Key: TEIID-4192 > URL: https://issues.jboss.org/browse/TEIID-4192 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.5.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5, 8.13.5 > > > If a column value is blank, it is excluding it in the result, causing incorrect output. > TEXTAGG(FOR Last_Name, > First_Name, > Middle_initial, > Currency_Code > DELIMITER '|' QUOTE '"' > ) > In the above example, if middle name is blank, then it should still show one empty column with "|" delimiter as shown below. > Steigner|Debbie||USD > But it returns output as excluding middle name since it is blank. > Steigner|Debbie|USD -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3268) Dependent values can exceed source settings

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3268?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3268. --------------------------------- > Dependent values can exceed source settings > ------------------------------------------- > > Key: TEIID-3268 > URL: https://issues.jboss.org/browse/TEIID-3268 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > If the number of dependent predicates does not evenly divide the number of needed predicates when there are more than 1 dependent expression, then we can end up putting more values in the source sql than intended. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues June 2016