July 2015 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2586) Cannot connect to remote TEIID 8.10.1 server

by Lukas Mro (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2586?page=com.atlassian.jira.plu... ] Lukas Mro edited comment on TEIIDDES-2586 at 7/28/15 4:07 AM: -------------------------------------------------------------- Hello Barry, thanks for fast reposnse. 1) I have two virtual machines for this purpose. Both are set on same phisical machne. Both are running Microsoft Server 2012 R2 Standard, and there is no other application on any of this VM. One is dedicated for Teiid Server and another for Designer. No other aps. Firewalls are off on both VMs as i was looking for this problem source. 2) frome one hand i can connect to teiid server from this second VM with no problems, pls see attached files. But from another hand i found something during the process. You have to check this on another pair of VM`s. While connecting via cli - input user name - press enter - start input password like few first letter - then start to deleting it like you want to start over with backspase key - then some errors go. Perhaps its normal? im not sure. Both screens attached. one with proper login with no attept to correct the password second one with errors while try to correct password during input plese note that i will have to try restore previouse configuration from backups soon, so this is good moment if you need some more intel. Or to find some workaround :) Thanks for help. You are doing amazing job here ! was (Author: lukaszmro): Hello Barry, thanks for fast reposnse. 1) I have two virtual machines for this purpose. Both are set on same phisical machne. Both are running Microsoft Server 2012 R2 Standard, and there is no other application on any of this VM. One is dedicated for Teiid Server and another for Designer. No other aps. Firewalls are off on both VMs as i was looking for this problem source. 2) frome one hand i can connect to teiid server from this second VM with no problems, pls see attached files. But from another hand i found something during the process. You have to check this on another pair of VM`s. While connecting via cli - input user name - press enter - start input password like few first letter - then start to deleting it like you want to start over with backspase key - then some errors go. Perhaps its normal? im not sure. Both screens attached. one with proper login with no attept to correct the password second one with errors while try to correct password during input > Cannot connect to remote TEIID 8.10.1 server > -------------------------------------------- > > Key: TEIIDDES-2586 > URL: https://issues.jboss.org/browse/TEIIDDES-2586 > Project: Teiid Designer > Issue Type: Bug > Components: Teiid Integration > Affects Versions: 9.1 > Environment: 2x windows server 2012 > Reporter: Lukas Mro > Attachments: 130.JPG, 140.JPG, logs.zip > > > Issue occure after update TEIID to 8.10.1 and Designer to 9.1. > I have working and properly set TEIID engine, and on another virtual machine i have teiid designer set. Both clean instalation. I can see and log to console to Teiid console from designer virtual machine but there is no way i can create a Teiid server in teiid designer. I tried everythin, teiid has ussers added, it boots on server external ip on all interfaces, it works as i can log into console. Version on TD is teiid-designer-9.1.0.Final-v20150709-2022-B3936, and it seems there is something wrong with it. > In properties in teiid section i can set only 8.9 version and there is no 8.10 or above (i mean 8.10.1). When i put 8.10.1 from keyboard i got information that this version is not supported. Teiid server is reachable by eclipse remote explorer (ftp only). And it also works. I will attache some logs later > -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2586) Cannot connect to remote TEIID 8.10.1 server

by Lukas Mro (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2586?page=com.atlassian.jira.plu... ] Lukas Mro updated TEIIDDES-2586: -------------------------------- Attachment: 130.JPG 140.JPG > Cannot connect to remote TEIID 8.10.1 server > -------------------------------------------- > > Key: TEIIDDES-2586 > URL: https://issues.jboss.org/browse/TEIIDDES-2586 > Project: Teiid Designer > Issue Type: Bug > Components: Teiid Integration > Affects Versions: 9.1 > Environment: 2x windows server 2012 > Reporter: Lukas Mro > Attachments: 130.JPG, 140.JPG, logs.zip > > > Issue occure after update TEIID to 8.10.1 and Designer to 9.1. > I have working and properly set TEIID engine, and on another virtual machine i have teiid designer set. Both clean instalation. I can see and log to console to Teiid console from designer virtual machine but there is no way i can create a Teiid server in teiid designer. I tried everythin, teiid has ussers added, it boots on server external ip on all interfaces, it works as i can log into console. Version on TD is teiid-designer-9.1.0.Final-v20150709-2022-B3936, and it seems there is something wrong with it. > In properties in teiid section i can set only 8.9 version and there is no 8.10 or above (i mean 8.10.1). When i put 8.10.1 from keyboard i got information that this version is not supported. Teiid server is reachable by eclipse remote explorer (ftp only). And it also works. I will attache some logs later > -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2586) Cannot connect to remote TEIID 8.10.1 server

by Lukas Mro (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2586?page=com.atlassian.jira.plu... ] Lukas Mro commented on TEIIDDES-2586: ------------------------------------- Hello Barry, thanks for fast reposnse. 1) I have two virtual machines for this purpose. Both are set on same phisical machne. Both are running Microsoft Server 2012 R2 Standard, and there is no other application on any of this VM. One is dedicated for Teiid Server and another for Designer. No other aps. Firewalls are off on both VMs as i was looking for this problem source. 2) frome one hand i can connect to teiid server from this second VM with no problems, pls see attached files. But from another hand i found something during the process. You have to check this on another pair of VM`s. While connecting via cli - input user name - press enter - start input password like few first letter - then start to deleting it like you want to start over with backspase key - then some errors go. Perhaps its normal? im not sure. Both screens attached. one with proper login with no attept to correct the password second one with errors while try to correct password during input > Cannot connect to remote TEIID 8.10.1 server > -------------------------------------------- > > Key: TEIIDDES-2586 > URL: https://issues.jboss.org/browse/TEIIDDES-2586 > Project: Teiid Designer > Issue Type: Bug > Components: Teiid Integration > Affects Versions: 9.1 > Environment: 2x windows server 2012 > Reporter: Lukas Mro > Attachments: logs.zip > > > Issue occure after update TEIID to 8.10.1 and Designer to 9.1. > I have working and properly set TEIID engine, and on another virtual machine i have teiid designer set. Both clean instalation. I can see and log to console to Teiid console from designer virtual machine but there is no way i can create a Teiid server in teiid designer. I tried everythin, teiid has ussers added, it boots on server external ip on all interfaces, it works as i can log into console. Version on TD is teiid-designer-9.1.0.Final-v20150709-2022-B3936, and it seems there is something wrong with it. > In properties in teiid section i can set only 8.9 version and there is no 8.10 or above (i mean 8.10.1). When i put 8.10.1 from keyboard i got information that this version is not supported. Teiid server is reachable by eclipse remote explorer (ftp only). And it also works. I will attache some logs later > -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2550) parseTimestamp function in Transformation Editor gives StringIndexOutOfBounds Exception

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2550?page=com.atlassian.jira.plu... ] Ramesh Reddy commented on TEIIDDES-2550: ---------------------------------------- Looks similar https://issues.jboss.org/browse/TEIIDDES-2585 > parseTimestamp function in Transformation Editor gives StringIndexOutOfBounds Exception > --------------------------------------------------------------------------------------- > > Key: TEIIDDES-2550 > URL: https://issues.jboss.org/browse/TEIIDDES-2550 > Project: Teiid Designer > Issue Type: Bug > Components: Modeling, Transformations > Affects Versions: 9.1 > Environment: Teiid 8.7.1.redhat-8 and Teiid Designer 9.1.0.Beta1 > Reporter: Daan Creemers > Assignee: Paul Richardson > Fix For: 9.2, 9.0.3 > > Attachments: TestParseTimestamp.tar.gz > > > When using the parseTimestamp function in the transformation editor while creating a relational view model, a StringIndexOutOfBoundsException is thrown. The query SELECT parseTimestamp('18:10:20', 'HH:mm:ss') is used in the transformation editor which gives 'String index out of range: 1'. I want to use the function with a column of my table but produces the same error. > When deploying a virtual database and executing exactly the same query on the database, the query finishes successfully and gives the result. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2550) parseTimestamp function in Transformation Editor gives StringIndexOutOfBounds Exception

by Daan Creemers (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2550?page=com.atlassian.jira.plu... ] Daan Creemers commented on TEIIDDES-2550: ----------------------------------------- Hi [~phantomjinx], I updated to Teiid Designer 9.1.0.Final and I imported your project. The String index out of range exception is no longer there, instead it shows 'ERROR: java.lang.IllegalArgumentException: character to be escaped is missing'. I have not yet been able to reproduce the String index out of range exception but I will notify you in that case. Thanks, Daan > parseTimestamp function in Transformation Editor gives StringIndexOutOfBounds Exception > --------------------------------------------------------------------------------------- > > Key: TEIIDDES-2550 > URL: https://issues.jboss.org/browse/TEIIDDES-2550 > Project: Teiid Designer > Issue Type: Bug > Components: Modeling, Transformations > Affects Versions: 9.1 > Environment: Teiid 8.7.1.redhat-8 and Teiid Designer 9.1.0.Beta1 > Reporter: Daan Creemers > Assignee: Paul Richardson > Fix For: 9.2, 9.0.3 > > Attachments: TestParseTimestamp.tar.gz > > > When using the parseTimestamp function in the transformation editor while creating a relational view model, a StringIndexOutOfBoundsException is thrown. The query SELECT parseTimestamp('18:10:20', 'HH:mm:ss') is used in the transformation editor which gives 'String index out of range: 1'. I want to use the function with a column of my table but produces the same error. > When deploying a virtual database and executing exactly the same query on the database, the query finishes successfully and gives the result. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2588) Need "Default Catalog filter" added to JDBC IMPORT

by Tom Johnston (JIRA)

Tom Johnston created TEIIDDES-2588: -------------------------------------- Summary: Need "Default Catalog filter" added to JDBC IMPORT Key: TEIIDDES-2588 URL: https://issues.jboss.org/browse/TEIIDDES-2588 Project: Teiid Designer Issue Type: Feature Request Reporter: Tom Johnston I am needing to import thousands of "DBF" files and they are separated by "directory structure".. thus the high level structure correlates to the "Catalog" -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2398) Inconsistent column datatypes when importing

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2398?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2398: ----------------------------------- Fix Version/s: Future (was: 8.6.2) (was: 9.2) (was: 9.0.3) > Inconsistent column datatypes when importing > -------------------------------------------- > > Key: TEIIDDES-2398 > URL: https://issues.jboss.org/browse/TEIIDDES-2398 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Modeling > Reporter: Andrej Šmigala > Assignee: Mark Drilling > Fix For: Future > > Attachments: datatypes.png, MySQL_BQT_DDL.ddl > > > There are multiple discrepancies in the column datatypes when importing using JDBC importer vs when using Teiid Connection importer. > Also some of the imported datatypes seem completely wrong (e.g. bigdecimal for almost all numeric datatypes in oracle) -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2398) Inconsistent column datatypes when importing

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2398?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2398: ---------------------------------------- Developing a datatype mapping framework is a substantial effort. Pushing for now Recommend that users use Teiid Connection importer, when concerned, which performs it's own mapping. Moving to Komodo and Teiid DDL dialect, there won't be a need for this type mapping because of the use of Teiid runtime types. > Inconsistent column datatypes when importing > -------------------------------------------- > > Key: TEIIDDES-2398 > URL: https://issues.jboss.org/browse/TEIIDDES-2398 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Modeling > Reporter: Andrej Šmigala > Assignee: Mark Drilling > Fix For: 8.6.2, 9.2, 9.0.3 > > Attachments: datatypes.png, MySQL_BQT_DDL.ddl > > > There are multiple discrepancies in the column datatypes when importing using JDBC importer vs when using Teiid Connection importer. > Also some of the imported datatypes seem completely wrong (e.g. bigdecimal for almost all numeric datatypes in oracle) -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2248) Teiid Connection import fails to parse DDL when table contains VARCHAR column with DEFAULT value

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2248?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2248. ------------------------------------ Resolution: Done Verified this works with latest 9.0.3 after MS jar update > Teiid Connection import fails to parse DDL when table contains VARCHAR column with DEFAULT value > ------------------------------------------------------------------------------------------------ > > Key: TEIIDDES-2248 > URL: https://issues.jboss.org/browse/TEIIDDES-2248 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Teiid Integration > Affects Versions: 8.3.3 > Environment: Teiid Designer 8.3.3 > Teiid 8.4.1-redhat-7 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Fix For: 9.2, 9.0.3 > > Attachments: screen-1.png > > > Create a table with > {code:sql} > CREATE TABLE t1 ( c1 VARCHAR(10) DEFAULT 'c1' ) > {code} > When trying to import it through Teiid Connection Importer, the importer DDL is shown as > {code:sql} > CREATE FOREIGN TABLE "dballo00.dbo.t1" ( > c1 string(10) DEFAULT '(''c1'')' OPTIONS (NAMEINSOURCE '"c1"', NATIVE_TYPE 'varchar') > ) OPTIONS (NAMEINSOURCE '"dballo00"."dbo"."t1"', UPDATABLE TRUE, CARDINALITY 0); > {code} > but on the next page, the following error is shown (see screenshot): > The DDL failed to parse with message: "Unparsable table body". -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2248) Teiid Connection import fails to parse DDL when table contains VARCHAR column with DEFAULT value

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2248?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-2248: --------------------------------------------------- Barry LaFond <blafond(a)redhat.com> changed the Status of [bug 1120073|https://bugzilla.redhat.com/show_bug.cgi?id=1120073] from NEW to MODIFIED > Teiid Connection import fails to parse DDL when table contains VARCHAR column with DEFAULT value > ------------------------------------------------------------------------------------------------ > > Key: TEIIDDES-2248 > URL: https://issues.jboss.org/browse/TEIIDDES-2248 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Teiid Integration > Affects Versions: 8.3.3 > Environment: Teiid Designer 8.3.3 > Teiid 8.4.1-redhat-7 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Fix For: 9.2, 9.0.3 > > Attachments: screen-1.png > > > Create a table with > {code:sql} > CREATE TABLE t1 ( c1 VARCHAR(10) DEFAULT 'c1' ) > {code} > When trying to import it through Teiid Connection Importer, the importer DDL is shown as > {code:sql} > CREATE FOREIGN TABLE "dballo00.dbo.t1" ( > c1 string(10) DEFAULT '(''c1'')' OPTIONS (NAMEINSOURCE '"c1"', NATIVE_TYPE 'varchar') > ) OPTIONS (NAMEINSOURCE '"dballo00"."dbo"."t1"', UPDATABLE TRUE, CARDINALITY 0); > {code} > but on the next page, the following error is shown (see screenshot): > The DDL failed to parse with message: "Unparsable table body". -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 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 2015