September 2013 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2642) Wrong forum URL on homepage

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2642?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2642. --------------------------------- > Wrong forum URL on homepage > --------------------------- > > Key: TEIID-2642 > URL: https://issues.jboss.org/browse/TEIID-2642 > Project: Teiid > Issue Type: Bug > Components: Documentation > Reporter: Mark Addleman > Assignee: Steven Hawkins > > With the change in the JBoss community website, the URL for the Teiid user community is wrong on teiid.org homepage -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2655) Minimize the reporting of erroneous illegalstateexceptions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2655?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2655. --------------------------------- > Minimize the reporting of erroneous illegalstateexceptions > ---------------------------------------------------------- > > Key: TEIID-2655 > URL: https://issues.jboss.org/browse/TEIID-2655 > Project: Teiid > Issue Type: Quality Risk > Components: Server > Affects Versions: 8.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4.1, 8.5 > > > Service injector illegalstateexceptions can be seen as errors in the logs with asynch metadata load when the vdb has already failed for another reason. We should ensure that these are not reported as additional errors. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2636) Stream corruption errors when doing big query

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2636?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2636. --------------------------------- > Stream corruption errors when doing big query > --------------------------------------------- > > Key: TEIID-2636 > URL: https://issues.jboss.org/browse/TEIID-2636 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.4 > Environment: Teiid 8.5 Beta2 Running in JBoss EAP 6.1 on RHEL6 > Java 7 openjdk > Reporter: Graeme Gillies > Assignee: Steven Hawkins > Fix For: 8.4.1, 8.5 > > Attachments: server.log > > > Hi, > When performing the following big query against a virtual db we have setup in this environment, we get an error > The query is > {noformat} > SELECT > bugs.bug_id, classification.name, bugs.cf_internal_whiteboard, > dev_cond_nak_grouped."value", partner_grouped."value", > bugs.cf_last_closed, bugs.bug_severity, bugs.cf_qa_whiteboard, > bugs.short_desc, qe_cond_nak_grouped."value", bugs.priority, > bugs.version, bugs.cf_pm_score, bugs.bug_status, product.name, > blocks_grouped.blocked, qa_contact.login_name, reporter.login_name, > component.name, flag_grouped.flag_full, bugs.delta_ts, > dependson_grouped.dependson, verified_grouped."value", > bugs.creation_ts, bugs.cf_devel_whiteboard, keyword_grouped.name, > target_release_grouped."value", bugs.target_milestone, assigned_to.login_name, > bugs.resolution > FROM Bugzilla_raw.bugs > LEFT JOIN Bugzilla_raw.products ON products.id = bugs.product_id > LEFT JOIN Bugzilla_raw.classifications classification ON classification.id = products.classification_id > LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(dev_cond_nak."value")) AS "value" FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.bug_cf_conditional_nak dev_cond_nak ON dev_cond_nak.bug_id = bugs.bug_id GROUP BY bugs.bug_id) dev_cond_nak_grouped ON bugs.bug_id = dev_cond_nak_grouped.bug_id > LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(partner."value")) AS "value" FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.bug_cf_partner partner ON partner.bug_id = bugs.bug_id GROUP BY bugs.bug_id) partner_grouped ON bugs.bug_id = partner_grouped.bug_id > LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(qe_cond_nak."value")) AS "value" FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.bug_cf_qe_conditional_nak qe_cond_nak ON qe_cond_nak.bug_id = bugs.bug_id GROUP BY bugs.bug_id) qe_cond_nak_grouped ON bugs.bug_id = qe_cond_nak_grouped.bug_id > LEFT JOIN Bugzilla_raw.products product ON product.id = bugs.product_id LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(blocks.blocked)) AS blocked FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.dependencies blocks ON blocks.dependson = bugs.bug_id GROUP BY bugs.bug_id) blocks_grouped ON bugs.bug_id = blocks_grouped.bug_id > LEFT JOIN Bugzilla_raw.profiles qa_contact ON qa_contact.userid = bugs.qa_contact LEFT JOIN Bugzilla_raw.profiles reporter ON reporter.userid = bugs.reporter LEFT JOIN Bugzilla_raw.components component ON component.id = bugs.component_id LEFT JOIN ( SELECT flags.bug_id, TEXTAGG(FOR(concat(ft.name, flags.status))) AS flag_full FROM Bugzilla_raw.flags > LEFT JOIN Bugzilla_raw.flagtypes ft ON ft.id = flags.type_id GROUP BY flags.bug_id) flag_grouped ON bugs.bug_id = flag_grouped.bug_id > LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(dependson.dependson)) AS dependson FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.dependencies dependson ON dependson.blocked = bugs.bug_id GROUP BY bugs.bug_id) dependson_grouped ON bugs.bug_id = dependson_grouped.bug_id > LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(verified."value")) AS "value" FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.bug_cf_verified verified ON verified.bug_id = bugs.bug_id GROUP BY bugs.bug_id) verified_grouped ON bugs.bug_id = verified_grouped.bug_id > LEFT JOIN ( SELECT keywords.bug_id, TEXTAGG(FOR(kw.name)) AS name FROM Bugzilla_raw.keywords LEFT JOIN Bugzilla_raw.keyworddefs kw ON kw.id = keywords.keywordid GROUP BY keywords.bug_id) keyword_grouped ON bugs.bug_id = keyword_grouped.bug_id > LEFT JOIN (SELECT bugs.bug_id, TEXTAGG(FOR(target_release."value")) AS "value" FROM Bugzilla_raw.bugs JOIN Bugzilla_raw.bugs_release target_release ON target_release.bug_id = bugs.bug_id GROUP BY bugs.bug_id) target_release_grouped ON bugs.bug_id = target_release_grouped.bug_id > LEFT JOIN Bugzilla_raw.profiles assigned_to ON assigned_to.userid = bugs.assigned_to > WHERE bugs.bug_id > 990410 OR bugs.delta_ts > parseTimestamp('2013-07-31 06:57:31 +0000', 'yyyy-MM-dd HH:mm:ss z') > LIMIT 0,1000000 > {noformat} > The error the client sees is > ERROR: TEIID30048 Error reading 24,668 > DETAIL: org.teiid.jdbc.TeiidSQLException: TEIID30048 Error reading 24,668 > This is using the Postgresql ODBC interface or the JDBC interface > The errors in the log file are quite long so I will attach the whole log file. > Regards, > Graeme -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2574) HiveMetadata procesor typo in importer property name

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2574?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2574. --------------------------------- > HiveMetadata procesor typo in importer property name > ---------------------------------------------------- > > Key: TEIID-2574 > URL: https://issues.jboss.org/browse/TEIID-2574 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.4 > Reporter: Filip Nguyen > Assignee: Ramesh Reddy > Priority: Minor > Fix For: 8.4.1, 8.5 > > > HiveMetadatProcessor's method setTrimColumNames should be named setTrimColumnNames > Unfortunately, when the documentation is without typo so when user sets the importer property according to docs, the property is silently not set. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2635) Block exit does not reset the temptablestore

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2635?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2635. --------------------------------- > Block exit does not reset the temptablestore > -------------------------------------------- > > Key: TEIID-2635 > URL: https://issues.jboss.org/browse/TEIID-2635 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.6 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 8.4.1, 8.5 > > > Once a block has completed the proper temp table context is not established until another block is pushed. This can result in odd behavior such as not finding a temporary table that should obviously exist. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2639) Internally generated and user submitted anonymous blocks can't access temp tables from the surrounding scope

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2639?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2639. --------------------------------- > Internally generated and user submitted anonymous blocks can't access temp tables from the surrounding scope > ------------------------------------------------------------------------------------------------------------ > > Key: TEIID-2639 > URL: https://issues.jboss.org/browse/TEIID-2639 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4.1, 8.5 > > > While the blocks are resolved against the surrounding scope, when executed the procedure plan shields them from seeing the higher level scopes just as when a real procedure is executed. This results in temporary table 'temp' not found exceptions, for example with a non-simple view v and the delete: > delete from v where e2 = (select max(e2) from temp as z where e3 = z.e3) -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2631) Issues with multiple returnable statements in a procedure

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2631?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2631. --------------------------------- > Issues with multiple returnable statements in a procedure > --------------------------------------------------------- > > Key: TEIID-2631 > URL: https://issues.jboss.org/browse/TEIID-2631 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.2 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4.1, 8.5 > > > A regression was introduced by TEIID-2226 where any subsequent execution of a returnable statement in a procedure is effectively ignored: > begin > select ... > select ... > end > would not issue the second select unless all prior statements do not have result sets or are marked as without return. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2628) StackOverflowError Running Query Against REST Service

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2628?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2628. --------------------------------- > StackOverflowError Running Query Against REST Service > ----------------------------------------------------- > > Key: TEIID-2628 > URL: https://issues.jboss.org/browse/TEIID-2628 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.4 > Reporter: Ted Jones > Assignee: Steven Hawkins > Priority: Critical > Fix For: 8.4.1, 8.5 > > Attachments: flight-service-ds.xml, flight.vdb, flight.zip > > > When executing a query against https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/Fligh..., I get the following exception (with query plan included): https://gist.github.com/tejones/6250290 -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2654) CXF Logging Configuration Example - Missing Entry?

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2654?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2654. --------------------------------- > CXF Logging Configuration Example - Missing Entry? > -------------------------------------------------- > > Key: TEIID-2654 > URL: https://issues.jboss.org/browse/TEIID-2654 > Project: Teiid > Issue Type: Bug > Components: Documentation > Reporter: B Long > Assignee: Steven Hawkins > Fix For: 8.5 > > > Should the example CXF config file given for Logging configuration with Web Services contain the following line: > <bean class="org.apache.cxf.feature.LoggingFeature"/> > Refer to documentation at https://docs.jboss.org/author/display/TEIID/Web+Service+Data+Sources -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2620) Add support for array/list indexing in teiid script

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2620?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2620. --------------------------------- > Add support for array/list indexing in teiid script > --------------------------------------------------- > > Key: TEIID-2620 > URL: https://issues.jboss.org/browse/TEIID-2620 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4.1, 8.5 > > > With Teiid script (the default for objecttable) you currently have to hand array processing over to arraytable rather than directly using arrays in the script. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 3 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues September 2013