July 2016 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2868) texttable parsing error

by Tom Johnston (JIRA)

Tom Johnston created TEIIDDES-2868: -------------------------------------- Summary: texttable parsing error Key: TEIIDDES-2868 URL: https://issues.jboss.org/browse/TEIIDDES-2868 Project: Teiid Designer Issue Type: Bug Environment: Teiid Designer 10.0.0.Final-v20160413-1817-B4094 org.teiid.designer.feature.feature.group JBoss by Red Hat Reporter: Tom Johnston I successfully created a physical table and view using texttable. I can query it. I then manually created another view to a different file and it kept failing with a very ambiguous error when I tried validating. ERROR: Error in parsing of sql - null I then created another view with a diff name of the 1st view using the same copy/pasted transformation.. it too resulting with the same error: The auto-generated view verbiage that was created and that I re-used was: SELECT A.OldWAC, A.NewWAC FROM (EXEC SourceModel.getTextFiles('wac.txt')) AS f, TEXTTABLE(f.file COLUMNS OldWAC string, NewWAC string DELIMITER '|') AS A -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2867) Importing from Sybase JDBC uses default double-quoted name in source values

by Barry LaFond (JIRA)

Barry LaFond created TEIIDDES-2867: -------------------------------------- Summary: Importing from Sybase JDBC uses default double-quoted name in source values Key: TEIIDDES-2867 URL: https://issues.jboss.org/browse/TEIIDDES-2867 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 9.0.7, 10.0 Reporter: Barry LaFond Assignee: Barry LaFond Priority: Critical Fix For: 10.0.1 The Sybase JDBC DB does fails to support Name In Source values with double-quoted segments. Current importer will define a table as "mySchema"."myCatalog".".myTable" and a column NIS as "column_1" The d-quotes need to get customized on import to remove the d-quotes See TEIIDDES-2458 for further discussions. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2458) Wrong "name-in-source" property value for imported tables in Source model (JDBC importer, Sybase 15 Database)

by Tom Johnston (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2458?page=com.atlassian.jira.plu... ] Tom Johnston edited comment on TEIIDDES-2458 at 7/6/16 11:53 AM: ----------------------------------------------------------------- I am experiencing the same issue *with regards to the Name In Source for the table name incorrectly contaiing double quotes (") around each predicate (database/catalog name, schema, and table/view/object name)* at this time with JBDS 9.1.0.GA and TeiiD Designer 10.0.0.Final. I should clarify that this is against the following version of Sybase: Adaptive Server Enterprise/12.5.2/EBF 11798/P/NT (IX86)/OS 4.0/ase1252/1831/32-bit/OPT/Fri Apr 09 04:15:03 2004 Using Jconn4 version: jConnect (TM) for JDBC(TM)/16.0 SP02 PL02 (Build 27276)/P/EBF25374/JDK 1.6.0/jdbcmain/OPT/Fri Oct 9 05:31:52 PDT 2015 I have also tested using jtds (1.3.1): "jTDS Type 4 JDBC Driver for MS SQL Server and Sybase" with same results. was (Author: virtualdatabase): I am experiencing the same issue at this time with JBDS 9.1.0.GA and TeiiD Designer 10.0.0.Final. I should clarify that this is against the following version of Sybase: Adaptive Server Enterprise/12.5.2/EBF 11798/P/NT (IX86)/OS 4.0/ase1252/1831/32-bit/OPT/Fri Apr 09 04:15:03 2004 Using Jconn4 version: jConnect (TM) for JDBC(TM)/16.0 SP02 PL02 (Build 27276)/P/EBF25374/JDK 1.6.0/jdbcmain/OPT/Fri Oct 9 05:31:52 PDT 2015 I have also tested using jtds (1.3.1): "jTDS Type 4 JDBC Driver for MS SQL Server and Sybase" with same results. > Wrong "name-in-source" property value for imported tables in Source model (JDBC importer, Sybase 15 Database) > ------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2458 > URL: https://issues.jboss.org/browse/TEIIDDES-2458 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.1, 10.0 > Environment: JBDS: 8.0.2GA > TD: 9.0.1.Final > OS: Fedora 20 > java: oracle 1.7 > JDBC driver: jconn4-26502 - jConnect (TM) for JDBC(TM)/7.00(Build 26502) > Sybase DB: ASE 15.0.3/EBF > Reporter: Juraj Duráni > Assignee: Andrej Šmigala > Fix For: 9.2 > > Attachments: parts_sql_catalog_in_name_in_source.png, parts_sql_include_catalog_in_name.png, parts_sql_schema_tree.png, pic1.png, pic2.png, pic3.png, sybase_bqt2_datatools_tree.png > > > I am trying to import a Source model from Sybase database. But imported tables have wrong "name-in-source" property values. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2458) Wrong "name-in-source" property value for imported tables in Source model (JDBC importer, Sybase 15 Database)

by Tom Johnston (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2458?page=com.atlassian.jira.plu... ] Tom Johnston edited comment on TEIIDDES-2458 at 7/6/16 11:17 AM: ----------------------------------------------------------------- I am experiencing the same issue at this time with JBDS 9.1.0.GA and TeiiD Designer 10.0.0.Final. I should clarify that this is against the following version of Sybase: Adaptive Server Enterprise/12.5.2/EBF 11798/P/NT (IX86)/OS 4.0/ase1252/1831/32-bit/OPT/Fri Apr 09 04:15:03 2004 Using Jconn4 version: jConnect (TM) for JDBC(TM)/16.0 SP02 PL02 (Build 27276)/P/EBF25374/JDK 1.6.0/jdbcmain/OPT/Fri Oct 9 05:31:52 PDT 2015 I have also tested using jtds (1.3.1): "jTDS Type 4 JDBC Driver for MS SQL Server and Sybase" with same results. was (Author: virtualdatabase): I am experiencing the same issue at this time with JBDS 9.1.0.GA and TeiiD Designer 10.0.0.Final. I should clarify that this is against the following version of Sybase: Adaptive Server Enterprise/12.5.2/EBF 11798/P/NT (IX86)/OS 4.0/ase1252/1831/32-bit/OPT/Fri Apr 09 04:15:03 2004 Using Jconn4 version: jConnect (TM) for JDBC(TM)/16.0 SP02 PL02 (Build 27276)/P/EBF25374/JDK 1.6.0/jdbcmain/OPT/Fri Oct 9 05:31:52 PDT 2015 > Wrong "name-in-source" property value for imported tables in Source model (JDBC importer, Sybase 15 Database) > ------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2458 > URL: https://issues.jboss.org/browse/TEIIDDES-2458 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.1, 10.0 > Environment: JBDS: 8.0.2GA > TD: 9.0.1.Final > OS: Fedora 20 > java: oracle 1.7 > JDBC driver: jconn4-26502 - jConnect (TM) for JDBC(TM)/7.00(Build 26502) > Sybase DB: ASE 15.0.3/EBF > Reporter: Juraj Duráni > Assignee: Andrej Šmigala > Fix For: 9.2 > > Attachments: parts_sql_catalog_in_name_in_source.png, parts_sql_include_catalog_in_name.png, parts_sql_schema_tree.png, pic1.png, pic2.png, pic3.png, sybase_bqt2_datatools_tree.png > > > I am trying to import a Source model from Sybase database. But imported tables have wrong "name-in-source" property values. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2458) Wrong "name-in-source" property value for imported tables in Source model (JDBC importer, Sybase 15 Database)

by Tom Johnston (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2458?page=com.atlassian.jira.plu... ] Tom Johnston edited comment on TEIIDDES-2458 at 7/6/16 11:07 AM: ----------------------------------------------------------------- I am experiencing the same issue at this time with JBDS 9.1.0.GA and TeiiD Designer 10.0.0.Final. I should clarify that this is against the following version of Sybase: Adaptive Server Enterprise/12.5.2/EBF 11798/P/NT (IX86)/OS 4.0/ase1252/1831/32-bit/OPT/Fri Apr 09 04:15:03 2004 Using Jconn4 version: jConnect (TM) for JDBC(TM)/16.0 SP02 PL02 (Build 27276)/P/EBF25374/JDK 1.6.0/jdbcmain/OPT/Fri Oct 9 05:31:52 PDT 2015 was (Author: virtualdatabase): I am experiencing the same issue at this time with JBDS 9.1.0.GA and TeiiD Designer 10.0.0.Final. I should clarify that this is against the following version of Sybase: Adaptive Server Enterprise/12.5.2/EBF 11798/P/NT (IX86)/OS 4.0/ase1252/1831/32-bit/OPT/Fri Apr 09 04:15:03 2004 Using Jconn4: > Wrong "name-in-source" property value for imported tables in Source model (JDBC importer, Sybase 15 Database) > ------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2458 > URL: https://issues.jboss.org/browse/TEIIDDES-2458 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.1, 10.0 > Environment: JBDS: 8.0.2GA > TD: 9.0.1.Final > OS: Fedora 20 > java: oracle 1.7 > JDBC driver: jconn4-26502 - jConnect (TM) for JDBC(TM)/7.00(Build 26502) > Sybase DB: ASE 15.0.3/EBF > Reporter: Juraj Duráni > Assignee: Andrej Šmigala > Fix For: 9.2 > > Attachments: parts_sql_catalog_in_name_in_source.png, parts_sql_include_catalog_in_name.png, parts_sql_schema_tree.png, pic1.png, pic2.png, pic3.png, sybase_bqt2_datatools_tree.png > > > I am trying to import a Source model from Sybase database. But imported tables have wrong "name-in-source" property values. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2458) Wrong "name-in-source" property value for imported tables in Source model (JDBC importer, Sybase 15 Database)

by Tom Johnston (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2458?page=com.atlassian.jira.plu... ] Tom Johnston edited comment on TEIIDDES-2458 at 7/6/16 11:06 AM: ----------------------------------------------------------------- I am experiencing the same issue at this time with JBDS 9.1.0.GA and TeiiD Designer 10.0.0.Final. I should clarify that this is against the following version of Sybase: Adaptive Server Enterprise/12.5.2/EBF 11798/P/NT (IX86)/OS 4.0/ase1252/1831/32-bit/OPT/Fri Apr 09 04:15:03 2004 Using Jconn4: was (Author: virtualdatabase): I am experiencing the same issue at this time with JBDS 9.1.0.GA and TeiiD Designer 10.0.0.Final > Wrong "name-in-source" property value for imported tables in Source model (JDBC importer, Sybase 15 Database) > ------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2458 > URL: https://issues.jboss.org/browse/TEIIDDES-2458 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.1, 10.0 > Environment: JBDS: 8.0.2GA > TD: 9.0.1.Final > OS: Fedora 20 > java: oracle 1.7 > JDBC driver: jconn4-26502 - jConnect (TM) for JDBC(TM)/7.00(Build 26502) > Sybase DB: ASE 15.0.3/EBF > Reporter: Juraj Duráni > Assignee: Andrej Šmigala > Fix For: 9.2 > > Attachments: parts_sql_catalog_in_name_in_source.png, parts_sql_include_catalog_in_name.png, parts_sql_schema_tree.png, pic1.png, pic2.png, pic3.png, sybase_bqt2_datatools_tree.png > > > I am trying to import a Source model from Sybase database. But imported tables have wrong "name-in-source" property values. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2458) Wrong "name-in-source" property value for imported tables in Source model (JDBC importer, Sybase 15 Database)

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2458?page=com.atlassian.jira.plu... ] Van Halbert updated TEIIDDES-2458: ---------------------------------- Affects Version/s: 10.0 > Wrong "name-in-source" property value for imported tables in Source model (JDBC importer, Sybase 15 Database) > ------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2458 > URL: https://issues.jboss.org/browse/TEIIDDES-2458 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.1, 10.0 > Environment: JBDS: 8.0.2GA > TD: 9.0.1.Final > OS: Fedora 20 > java: oracle 1.7 > JDBC driver: jconn4-26502 - jConnect (TM) for JDBC(TM)/7.00(Build 26502) > Sybase DB: ASE 15.0.3/EBF > Reporter: Juraj Duráni > Assignee: Andrej Šmigala > Fix For: 9.2 > > Attachments: parts_sql_catalog_in_name_in_source.png, parts_sql_include_catalog_in_name.png, parts_sql_schema_tree.png, pic1.png, pic2.png, pic3.png, sybase_bqt2_datatools_tree.png > > > I am trying to import a Source model from Sybase database. But imported tables have wrong "name-in-source" property values. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2458) Wrong "name-in-source" property value for imported tables in Source model (JDBC importer, Sybase 15 Database)

by Tom Johnston (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2458?page=com.atlassian.jira.plu... ] Tom Johnston reopened TEIIDDES-2458: ------------------------------------ I am experiencing the same issue at this time with JBDS 9.1.0.GA and TeiiD Designer 10.0.0.Final > Wrong "name-in-source" property value for imported tables in Source model (JDBC importer, Sybase 15 Database) > ------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2458 > URL: https://issues.jboss.org/browse/TEIIDDES-2458 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.1 > Environment: JBDS: 8.0.2GA > TD: 9.0.1.Final > OS: Fedora 20 > java: oracle 1.7 > JDBC driver: jconn4-26502 - jConnect (TM) for JDBC(TM)/7.00(Build 26502) > Sybase DB: ASE 15.0.3/EBF > Reporter: Juraj Duráni > Assignee: Andrej Šmigala > Fix For: 9.2 > > Attachments: parts_sql_catalog_in_name_in_source.png, parts_sql_include_catalog_in_name.png, parts_sql_schema_tree.png, pic1.png, pic2.png, pic3.png, sybase_bqt2_datatools_tree.png > > > I am trying to import a Source model from Sybase database. But imported tables have wrong "name-in-source" property values. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2866) Space in String in Transformation editor is replaced with <undefined> after Save/Validate SQL

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2866?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2866: ---------------------------------------- [~skaleta] I can't seem to reproduce this. I tested both a Designer 10.0.Final kit and my local 10.0.1 (Linux). > Space in String in Transformation editor is replaced with <undefined> after Save/Validate SQL > --------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2866 > URL: https://issues.jboss.org/browse/TEIIDDES-2866 > Project: Teiid Designer > Issue Type: Bug > Components: Editors, Transformations > Affects Versions: 10.0.1 > Reporter: stanislav kaleta > Fix For: 10.0.2 > > Attachments: after.png, before.png > > > Any space in string in Transformation Editor is replaced with <undefined> after Save/Validate SQL action. (see steps to reproduce and attachments) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2866) Space in String in Transformation editor is replaced with <undefined> after Save/Validate SQL

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2866?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2866: ----------------------------------- Fix Version/s: 10.0.2 > Space in String in Transformation editor is replaced with <undefined> after Save/Validate SQL > --------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2866 > URL: https://issues.jboss.org/browse/TEIIDDES-2866 > Project: Teiid Designer > Issue Type: Bug > Components: Editors, Transformations > Affects Versions: 10.0.1 > Reporter: stanislav kaleta > Fix For: 10.0.2 > > Attachments: after.png, before.png > > > Any space in string in Transformation Editor is replaced with <undefined> after Save/Validate SQL action. (see steps to reproduce and attachments) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 10 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues July 2016