December 2011 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-1202) Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries

by Barry LaFond (Updated) (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1202?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-1202: ----------------------------------- Fix Version/s: 7.7 > Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries > -------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-1202 > URL: https://issues.jboss.org/browse/TEIIDDES-1202 > Project: Teiid Designer > Issue Type: Feature Request > Components: Datatools Integration > Affects Versions: 7.1.1 > Reporter: Paul Nittel > Fix For: 7.7 > > Attachments: TeiidDBConfiguration.java.patch > > > When a series of SELECT statements are sent to the server via Execute All, the server should execute the SQL statements in appropriate fashion (as when the queries are directed to other RDBMSes, such as Oracle). > At present, no exceptions are thrown, but the queries fail to execute. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1203) Synchronizing a VDB takes too long in 7.4.2

by Johnathon Lee (Created) (JIRA)

Synchronizing a VDB takes too long in 7.4.2 ------------------------------------------- Key: TEIIDDES-1203 URL: https://issues.jboss.org/browse/TEIIDDES-1203 Project: Teiid Designer Issue Type: Bug Components: Validation, VDB & Execution Affects Versions: 7.4.2 Reporter: Johnathon Lee Assignee: Barry LaFond Fix For: 7.7, 7.6.1 Attachments: org.teiid.designer.core.patch, org.teiid.designer.dqp.patch, org.teiid.designer.vdb.patch, org.teiid.designer.vdb.test.patch, org.teiid.designer.vdb.ui.patch, TEIIDDES-1200-7.4.2-Patch-A.zip, TEIIDDES_1200.zip, UdfManager.java.patch, UdfUiPlugin.java.patch, VdbUtil.java.patch Synchronizing a big VDB in version 7.4.2 (JBDS 4.1.1) takes 30 minutes versus 2 minutes in 7.1.1 (JBDS 4.1.0) Investigating/debug noted 2 areas. 1) New UdfManager is not caching a FunctionLibrary and each SQL validation is creating a new instance. (needs a fix) 2) Synchronizing a VDB is hammering the ChecksumUtil.computeChecksum() during the VDB's resource build processing 3) PreviewManager is using a new Vdb() object to determine if "preview = true" and version #. However, it's heavy weight and currently the Vdb() is registering for events, but is not being Unregistered. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years

2
1
0 / 0

[JBoss JIRA] (TEIIDDES-1202) Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries

by Steven Hawkins (Commented) (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1202?page=com.atlassian.jira.plu... ] Steven Hawkins commented on TEIIDDES-1202: ------------------------------------------ I should add that it is unknown when TEIID-1377 will be addressed on the Teiid side, so this fix should still be considered for Designer. > Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries > -------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-1202 > URL: https://issues.jboss.org/browse/TEIIDDES-1202 > Project: Teiid Designer > Issue Type: Feature Request > Components: Datatools Integration > Affects Versions: 7.1.1 > Reporter: Paul Nittel > Attachments: TeiidDBConfiguration.java.patch > > > When a series of SELECT statements are sent to the server via Execute All, the server should execute the SQL statements in appropriate fashion (as when the queries are directed to other RDBMSes, such as Oracle). > At present, no exceptions are thrown, but the queries fail to execute. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1202) Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries

by Steven Hawkins (Updated) (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1202?page=com.atlassian.jira.plu... ] Steven Hawkins updated TEIIDDES-1202: ------------------------------------- Attachment: TeiidDBConfiguration.java.patch Patch to add executeAll support using the ; terminator. It seems like there was a DTP change so that configurations no longer have default parsers, which in turns means that they no longer split values. > Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries > -------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-1202 > URL: https://issues.jboss.org/browse/TEIIDDES-1202 > Project: Teiid Designer > Issue Type: Feature Request > Components: Datatools Integration > Affects Versions: 7.1.1 > Reporter: Paul Nittel > Attachments: TeiidDBConfiguration.java.patch > > > When a series of SELECT statements are sent to the server via Execute All, the server should execute the SQL statements in appropriate fashion (as when the queries are directed to other RDBMSes, such as Oracle). > At present, no exceptions are thrown, but the queries fail to execute. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1202) CLONE - Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries

by Steven Hawkins (Moved) (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1202?page=com.atlassian.jira.plu... ] Steven Hawkins moved TEIID-1877 to TEIIDDES-1202: ------------------------------------------------- Project: Teiid Designer (was: Teiid) Key: TEIIDDES-1202 (was: TEIID-1877) Affects Version/s: 7.1.1 (was: 7.1.1) Component/s: Datatools Integration (was: Query Engine) Fix Version/s: (was: 8.0) > CLONE - Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries > ---------------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-1202 > URL: https://issues.jboss.org/browse/TEIIDDES-1202 > Project: Teiid Designer > Issue Type: Feature Request > Components: Datatools Integration > Affects Versions: 7.1.1 > Reporter: Paul Nittel > Assignee: Steven Hawkins > > When a series of SELECT statements are sent to the server via Execute All, the server should execute the SQL statements in appropriate fashion (as when the queries are directed to other RDBMSes, such as Oracle). > At present, no exceptions are thrown, but the queries fail to execute. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1202) Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries

by Steven Hawkins (Updated) (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1202?page=com.atlassian.jira.plu... ] Steven Hawkins updated TEIIDDES-1202: ------------------------------------- Summary: Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries (was: CLONE - Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries) Assignee: (was: Steven Hawkins) > Teiid Designer (DTP) Execute All sends all queries at once to Server - Server should handle these bulk queries > -------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-1202 > URL: https://issues.jboss.org/browse/TEIIDDES-1202 > Project: Teiid Designer > Issue Type: Feature Request > Components: Datatools Integration > Affects Versions: 7.1.1 > Reporter: Paul Nittel > > When a series of SELECT statements are sent to the server via Execute All, the server should execute the SQL statements in appropriate fashion (as when the queries are directed to other RDBMSes, such as Oracle). > At present, no exceptions are thrown, but the queries fail to execute. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1201) CLONE - Synchronizing a VDB takes too long in JBDS 4.1.1

by Debbie Steigner (Created) (JIRA)

CLONE - Synchronizing a VDB takes too long in JBDS 4.1.1 -------------------------------------------------------- Key: TEIIDDES-1201 URL: https://issues.jboss.org/browse/TEIIDDES-1201 Project: Teiid Designer Issue Type: Bug Components: Validation, VDB & Execution Affects Versions: 7.4.2 Reporter: Debbie Steigner Assignee: Barry LaFond Fix For: 7.7, 7.6.1 Attachments: org.teiid.designer.core.patch, org.teiid.designer.dqp.patch, org.teiid.designer.vdb.patch, org.teiid.designer.vdb.test.patch, org.teiid.designer.vdb.ui.patch, TEIIDDES-1200-7.4.2-Patch-A.zip, TEIIDDES_1200.zip, UdfManager.java.patch, UdfUiPlugin.java.patch, VdbUtil.java.patch Synchronizing a big VDB in version 7.4.2 (JBDS 4.1.1) takes 30 minutes versus 2 minutes in 7.1.1 (JBDS 4.1.0) Investigating/debug noted 2 areas. 1) New UdfManager is not caching a FunctionLibrary and each SQL validation is creating a new instance. (needs a fix) 2) Synchronizing a VDB is hammering the ChecksumUtil.computeChecksum() during the VDB's resource build processing 3) PreviewManager is using a new Vdb() object to determine if "preview = true" and version #. However, it's heavy weight and currently the Vdb() is registering for events, but is not being Unregistered. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years

1
0
0 / 0

[JBoss JIRA] Created: (TEIIDDES-1068) Import of Salesforce model does not map the BusinessHours table columns correctly

by Mark Drilling (JIRA)

Import of Salesforce model does not map the BusinessHours table columns correctly --------------------------------------------------------------------------------- Key: TEIIDDES-1068 URL: https://issues.jboss.org/browse/TEIIDDES-1068 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 7.4 Reporter: Mark Drilling Assignee: Mark Drilling Fix For: 7.6 Import from salesforce instance does appear to be mapping the BusinessHours column types correctly. The SundayStart,SundayEnd,MondayStart,MondayEnd,etc types should map to a time based datatype. It either does not get mapped or it maps to a string. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years

4
5
0 / 0

[JBoss JIRA] (TEIIDDES-1198) Add support for creating partitioned views

by Steven Hawkins (Created) (JIRA)

Add support for creating partitioned views ------------------------------------------ Key: TEIIDDES-1198 URL: https://issues.jboss.org/browse/TEIIDDES-1198 Project: Teiid Designer Issue Type: Feature Request Components: Modeling Reporter: Steven Hawkins As an alternative to multi-source models, Teiid supports updatable views defined as union alls that serve the same purpose. It would be good if there was something that could guide the user in creating a partitioned view layer. For example after source A and source B have been imported (of course there could be more than two sources) there could be a modeling option in the new model wizard that creates a view layer not from a single source, but multiple sources. The views would be defined as select ... from sourceA.tbl union all select ... from sourceB.tbl. Obviously without a reconciliation step we would expect tables and column names to match exactly. Procedures are a special case and don't quite fit cleanly in this approach (or in mulit-source logic either). -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years

2
1
0 / 0

[JBoss JIRA] (TEIIDDES-321) Expression Builder in the Transformation Editor does not allow negative numeric constant values

by Barry LaFond (Resolved) (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-321?page=com.atlassian.jira.plug... ] Barry LaFond resolved TEIIDDES-321. ----------------------------------- Resolution: Done Done. Thx Steve. > Expression Builder in the Transformation Editor does not allow negative numeric constant values > ----------------------------------------------------------------------------------------------- > > Key: TEIIDDES-321 > URL: https://issues.jboss.org/browse/TEIIDDES-321 > Project: Teiid Designer > Issue Type: Bug > Components: Transformations > Affects Versions: 7.6 > Reporter: Marc Shirley > Assignee: Barry LaFond > Fix For: 7.7 > > Attachments: TEIIDDES-321.patch > > > Unable to input negative constant values into the expression editor. no errors or warnings occur when attempting. When pressing the hyphen key to input a negative, nothing is entered as a value. This affects TIMESTAMPADD() as an example. Without being able to enter a negative number, there is not a way to subtract from a date/time/timestamp value. > Workaround is to manually enter the negative value into the transformation SQL. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues December 2011