November 2014 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-1037) Data types inported from flat file partially implemented in wizard

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1037?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-1037: --------------------------------------------------- asmigala(a)redhat.com changed the Status of [bug 1093210|https://bugzilla.redhat.com/show_bug.cgi?id=1093210] from ON_QA to ASSIGNED > Data types inported from flat file partially implemented in wizard > ------------------------------------------------------------------ > > Key: TEIIDDES-1037 > URL: https://issues.jboss.org/browse/TEIIDDES-1037 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Patch Release > Affects Versions: 7.5 > Reporter: Paul Nittel > Assignee: Barry LaFond > Fix For: 8.6.1, 9.0 > > Attachments: FlatFileDataTypes_NOT.png > > > The new Flat File metadata importer is great! Not having to write the TEXTTABLE function is a fine example of usability improvement. > I noticed, during import, a dialog option that indicated datatypes can be the second line in the data file (column names being the first). That, and its associated help, are the only reference to this possibility (see attached screenshot). Without the actual functionality, it's confusing. > Later in the wizardly process, the column names row number is captured. I suspect the types row--if present, and its use desired by the user--should also be determined at that point. > The ability of importing the datatypes from the flat file would, IMHO, really enhance what is already a superb importer! (Yeah, I _do_ like it!) -- This message was sent by Atlassian JIRA (v6.3.8#6338)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2107) Virtual documents in XML view model build from XSD have incorrect namespaces

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2107?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-2107: --------------------------------------------------- asmigala(a)redhat.com changed the Status of [bug 1086107|https://bugzilla.redhat.com/show_bug.cgi?id=1086107] from ON_QA to VERIFIED > Virtual documents in XML view model build from XSD have incorrect namespaces > ---------------------------------------------------------------------------- > > Key: TEIIDDES-2107 > URL: https://issues.jboss.org/browse/TEIIDDES-2107 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 8.3.1 > Reporter: Lucie Fabrikova > Assignee: Lucie Fabrikova > Fix For: 8.5 > > Attachments: UpdatesSchema.xsd, xmlviewNS.png > > > When creating new metadata model (XML, View model, Build XML documents from XML schema), namespaces are set correctly only for one of the virtual documents. If you choose multiple virtual documents from schema root elements table, the others would have namespace set to null. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2198) Virtual procedure transformation not revalidated after changing parameter datatype

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2198?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-2198: --------------------------------------------------- asmigala(a)redhat.com changed the Status of [bug 1105117|https://bugzilla.redhat.com/show_bug.cgi?id=1105117] from ON_QA to VERIFIED > Virtual procedure transformation not revalidated after changing parameter datatype > ---------------------------------------------------------------------------------- > > Key: TEIIDDES-2198 > URL: https://issues.jboss.org/browse/TEIIDDES-2198 > Project: Teiid Designer > Issue Type: Bug > Components: Transformations, Validation > Affects Versions: 8.3.2 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Fix For: 8.5.1, 8.6 > > > Changing the datatype of a virtual procedure parameter does not trigger revalidation. This means that errors caused by trying to convert the parameter to an incompatible datatype in the transformation do not disappear after fixing the datatype, and conversely, changing the datatype does not trigger validation errors when the new datatype is incompatible. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2294) Issues with inputs in Create Relational View Procedure dialog on Windows

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2294?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-2294: --------------------------------------------------- asmigala(a)redhat.com changed the Status of [bug 1131181|https://bugzilla.redhat.com/show_bug.cgi?id=1131181] from ON_QA to VERIFIED > Issues with inputs in Create Relational View Procedure dialog on Windows > ------------------------------------------------------------------------ > > Key: TEIIDDES-2294 > URL: https://issues.jboss.org/browse/TEIIDDES-2294 > Project: Teiid Designer > Issue Type: Bug > Components: Dialogs > Affects Versions: 8.3.3 > Environment: JBDS 7.1.1 > Designer 8.3.3 > Windows 7, Windows 8.1 > Reporter: Andrej Šmigala > Assignee: Mark Drilling > Fix For: 8.5.1, 8.3.4, 8.6 > > > On Parameters and Result Set tabs in this dialog, it is impossible to edit values in the table unless the appropriate row is selected first by clicking on the value in the first column. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2295) Issues with inputs in Create Relational View Table dialog on Windows

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2295?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-2295: --------------------------------------------------- asmigala(a)redhat.com changed the Status of [bug 1131184|https://bugzilla.redhat.com/show_bug.cgi?id=1131184] from ON_QA to VERIFIED > Issues with inputs in Create Relational View Table dialog on Windows > -------------------------------------------------------------------- > > Key: TEIIDDES-2295 > URL: https://issues.jboss.org/browse/TEIIDDES-2295 > Project: Teiid Designer > Issue Type: Bug > Components: Dialogs > Affects Versions: 8.3.3 > Environment: JBDS 7.1.1 > Designer 8.3.3 > Windows 7, Windows 8.1 > Reporter: Andrej Šmigala > Assignee: Mark Drilling > Fix For: 8.5.1, 8.3.4, 8.6 > > > On Columns tab in this dialog, it is impossible to edit values in the table unless the appropriate row is selected first by clicking on the value in the first column. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2298) Wrong message in LDAP import dialog

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2298?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-2298: --------------------------------------------------- asmigala(a)redhat.com changed the Status of [bug 1131431|https://bugzilla.redhat.com/show_bug.cgi?id=1131431] from ON_QA to VERIFIED > Wrong message in LDAP import dialog > ----------------------------------- > > Key: TEIIDDES-2298 > URL: https://issues.jboss.org/browse/TEIIDDES-2298 > Project: Teiid Designer > Issue Type: Bug > Components: Dialogs > Affects Versions: 8.3.3 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Priority: Minor > Fix For: 8.5.1, 8.3.4, 8.6 > > Attachments: ldapimport.png > > > The dialog for metadata import from LDAP service has a message on top that says {quote}Source model LdapModel does not exist and will be created and contain the required invoke() web service procedure.{quote} Seems like a message intended for the Web Service import dialog is being reused. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2302) Issue with Model list in VDB editor on Windows

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2302?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-2302: --------------------------------------------------- asmigala(a)redhat.com changed the Status of [bug 1131904|https://bugzilla.redhat.com/show_bug.cgi?id=1131904] from ON_QA to VERIFIED > Issue with Model list in VDB editor on Windows > ---------------------------------------------- > > Key: TEIIDDES-2302 > URL: https://issues.jboss.org/browse/TEIIDDES-2302 > Project: Teiid Designer > Issue Type: Bug > Components: Editors > Affects Versions: 8.3.3 > Environment: Windows 7 > Reporter: Andrej Šmigala > Assignee: Mark Drilling > Fix For: 8.6 > > > In the model list in VDB editor (the table in the upper left corner), the checkboxes for synchronization and for toggling visibility can only be checked when the corresponding row is selected first (similar to TEIIDDES-2295, TEIIDDES-2294 and TEIIDDES-2293). -- This message was sent by Atlassian JIRA (v6.3.8#6338)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2303) Visibility checkbox not updated in Model list in VDB editor on Windows

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2303?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-2303: --------------------------------------------------- asmigala(a)redhat.com changed the Status of [bug 1131906|https://bugzilla.redhat.com/show_bug.cgi?id=1131906] from ON_QA to VERIFIED > Visibility checkbox not updated in Model list in VDB editor on Windows > ---------------------------------------------------------------------- > > Key: TEIIDDES-2303 > URL: https://issues.jboss.org/browse/TEIIDDES-2303 > Project: Teiid Designer > Issue Type: Bug > Components: Editors > Affects Versions: 8.3.3 > Environment: Windows 7 > Reporter: Andrej Šmigala > Assignee: Mark Drilling > Fix For: 8.6.1 > > > The visibility checkbox in Model list in VDB editor often does not change its state after clicking, only after either the VDB is saved or the table view is resized (by resizing the editor pane or the whole JBDS window). -- This message was sent by Atlassian JIRA (v6.3.8#6338)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2309) Issues with inputs in Import From Flat File Source dialog on Windows

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2309?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-2309: --------------------------------------------------- asmigala(a)redhat.com changed the Status of [bug 1132538|https://bugzilla.redhat.com/show_bug.cgi?id=1132538] from ON_QA to VERIFIED > Issues with inputs in Import From Flat File Source dialog on Windows > -------------------------------------------------------------------- > > Key: TEIIDDES-2309 > URL: https://issues.jboss.org/browse/TEIIDDES-2309 > Project: Teiid Designer > Issue Type: Bug > Components: Dialogs > Affects Versions: 8.3.3 > Environment: Windows 7 > Reporter: Andrej Šmigala > Assignee: Mark Drilling > Fix For: 8.3.4, 8.6 > > > Another case of TEIIDDES-2295 and related issues in Flat File import dialog. The table where this happens is the Column Information table in steps Flat File Fixed Columns Width Parser Settings and Flat File Delimited Columns Parser Settings. -- This message was sent by Atlassian JIRA (v6.3.8#6338)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2316) Excel import creates wrong datatype for ROW_ID column

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2316?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-2316: --------------------------------------------------- asmigala(a)redhat.com changed the Status of [bug 1134006|https://bugzilla.redhat.com/show_bug.cgi?id=1134006] from ON_QA to VERIFIED > Excel import creates wrong datatype for ROW_ID column > ----------------------------------------------------- > > Key: TEIIDDES-2316 > URL: https://issues.jboss.org/browse/TEIIDDES-2316 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Modeling, Teiid Integration > Affects Versions: 8.6 > Environment: Teiid Designer 8.6.0.Alpha1 > Teiid 8.7.1 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Fix For: 8.6 > > > Following https://community.jboss.org/wiki/MicrosoftExcelDocumentIntoRelationalTable (Option 1 using Teiid Designer), the imported model has the ROW_ID column modeled with datatype "integer", which results in BigInteger runtime datatype. After adding this model to a vdb and deploying, the following queries work ok: > {code:sql} > SELECT * FROM Sheet1 > SELECT * FROM Sheet1 WHERE row_id > 2 > {code} > but the following query fails: > {code:sql} > SELECT * FROM Sheet1 WHERE row_id = 2 > {code} > The error is > bq. org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidException: java.math.BigInteger cannot be cast to java.lang.Integer > After changing the datatype to "int : xs:long" and redeploying, the above query works as expected. > However, if I copy the generated dynamic vdb (attached) and deploy it on the server (without using Designer), running the query against that works. > The DDL for import is > {code:sql} > SET NAMESPACE 'http://www.teiid.org/translator/excel/2014' AS teiid_excel; > CREATE FOREIGN TABLE Sheet1 ( > ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_excel:CELL_NUMBER" 'ROW_ID'), > FirstName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'), > LastName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'), > Age double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'), > CONSTRAINT PK0 PRIMARY KEY(ROW_ID) > ) OPTIONS ("teiid_excel:FILE" 'names.xlsx', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2'); > {code} -- This message was sent by Atlassian JIRA (v6.3.8#6338)

10 years, 1 month

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues November 2014