December 2017 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-3136) PK's are not imported from JDBC source when import FK's is turned off

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3136?page=com.atlassian.jira.plu... ] Matej Kralik closed TEIIDDES-3136. ---------------------------------- > PK's are not imported from JDBC source when import FK's is turned off > ---------------------------------------------------------------------- > > Key: TEIIDDES-3136 > URL: https://issues.jboss.org/browse/TEIIDDES-3136 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 11.1 > Reporter: Barry LaFond > Assignee: Barry LaFond > Fix For: 11.1.1 > > > If Import FK's is turned OFF (unchecked) then PK's are not imported as part of the table schema. > RelationalModelProcessorImpl.createPrimaryKey() method is checking for includeFKs & includeInexes options and returning if both are false. Need to remove this check and let PK's be imported either way. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2660) Add support in Designer for foreign keys cross models

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2660?page=com.atlassian.jira.plu... ] Matej Kralik closed TEIIDDES-2660. ---------------------------------- > Add support in Designer for foreign keys cross models > ----------------------------------------------------- > > Key: TEIIDDES-2660 > URL: https://issues.jboss.org/browse/TEIIDDES-2660 > Project: Teiid Designer > Issue Type: Bug > Components: Modeling > Reporter: Van Halbert > Assignee: Barry LaFond > Fix For: 11.1 > > Attachments: foreignKey.zip > > > Add support in Designer for foreign keys cross models. > In Designer you cannot have a FK cross models. That is not a limitation with DDL metadata in Teiid. It's a misstatement to relate that to optimization. If the PK/FK is present we'll use that information just as we would in a single source - we do not however enforce the FK. That can be done through the use of an update procedure though. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3072) "JDBC Connection uses SSL" checkbox will not save on the Teiid Instance tab of Server configuration

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3072?page=com.atlassian.jira.plu... ] Matej Kralik closed TEIIDDES-3072. ---------------------------------- > "JDBC Connection uses SSL" checkbox will not save on the Teiid Instance tab of Server configuration > --------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-3072 > URL: https://issues.jboss.org/browse/TEIIDDES-3072 > Project: Teiid Designer > Issue Type: Bug > Components: Teiid Integration > Affects Versions: 9.0.7, 10.0.2, 11.0.1 > Reporter: Debbie Steigner > Assignee: Barry LaFond > Fix For: 11.1 > > > I tested this in all my current Teiid Designer instances and it doesn't work in any of them. Open the server > teiid Instance tab and check the box for "JDBC Connection uses SSL" then Save it. Notice the checkmark goes away. There is no way to have it to be set, so hence if you have SSL configured on your teiid jdbc transport you cannot test your connection. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3071) SQL transformation editor rewrites TRIM() function incorrectly most of the time

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3071?page=com.atlassian.jira.plu... ] Matej Kralik closed TEIIDDES-3071. ---------------------------------- > SQL transformation editor rewrites TRIM() function incorrectly most of the time > ------------------------------------------------------------------------------- > > Key: TEIIDDES-3071 > URL: https://issues.jboss.org/browse/TEIIDDES-3071 > Project: Teiid Designer > Issue Type: Bug > Components: Transformations > Affects Versions: 11.0.1 > Reporter: Debbie Steigner > Assignee: Barry LaFond > Fix For: 11.1 > > > Paste the below SQL in the transformation editor to create a view table: > SELECT > trim(INTKEY),trim(STRINGKEY),trim(INTNUM),trim(STRINGNUM),trim(FLOATNUM),trim(LONGNUM),trim(DOUBLENUM),trim(BYTENUM),trim(DATEVALUE),trim(TIMESTAMPVALUE), trim(BOOLEANVALUE),trim(CHARVALUE),trim(SHORTVALUE),trim(BIGINTEGERVALUE),trim(BIGDECIMALVALUE),trim(OBJECTVALUE) > FROM > bqtora.LARGEB > Once you save it, it gets rewritten with the defaults, but it leaves the column name out most of the time: > SELECT > trim(' ' FROM ), trim(' ' FROM bqtora.LARGEB.STRINGKEY), trim(' ' FROM ), trim(' ' FROM bqtora.LARGEB.STRINGNUM), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM bqtora.LARGEB.OBJECTVALUE) > FROM > bqtora.LARGEB > So obviously you receive a validation parsing error: > ERROR: Error in parsing of sql - Encountered " ")" ") "" at line 2, column 31. > Was expecting one of: > "char" ... > "date" ... > "time" ... > "timestamp" ... > "cast" ... > "convert" ... > "any" ... > "array_agg" ... > "case" ... > "exists" ... > "false" ... > "hour" ... > "insert" ... > "left" ... > "minute" ... > "month" ... > "not" ... > "null" ... > "right" ... > "second" ... > "some" ... > "translate" ... > "true" ... > "unknown" ... > "user" ... > "year" ... > "xmlagg" ... > "xmlcast" ... > "xmlconcat" ... > "xmlcomment" ... > "xmlelement" ... > "xmlexists" ... > "xmlforest" ... > "xmlparse" ... > "xmlpi" ... > "xmlquery" ... > "xmlserialize" ... > "xmltext" ... > "instead" ... > "enabled" ... > "disabled" ... > "view" ... > "key" ... > "serial" ... > "textagg" ... > "count" ... > "row_number" ... > "rank" ... > "dense_rank" ... > "sum" ... > "avg" ... > "min" ... > "max" ... > "every" ... > "stddev_pop" ... > "stddev_samp" ... > "var_samp" ... > "var_pop" ... > "document" ... > "content" ... > "trim" ... > "empty" ... > "ordinality" ... > "path" ... > "first" ... > "last" ... > "next" ... > "substring" ... > "extract" ... > "to_chars" ... > "to_bytes" ... > "timestampadd" ... > "timestampdiff" ... > "querystring" ... > "namespace" ... > "result" ... > "index" ... > "accesspattern" ... > "auto_increment" ... > "wellformed" ... > "sql_tsi_frac_second" ... > "sql_tsi_second" ... > "sql_tsi_minute" ... > "sql_tsi_hour" ... > "sql_tsi_day" ... > "sql_tsi_week" ... > "sql_tsi_month" ... > "sql_tsi_quarter" ... > "sql_tsi_year" ... > "texttable" ... > "arraytable" ... > "selector" ... > "skip" ... > "width" ... > "passing" ... > "name" ... > "encoding" ... > "columns" ... > "delimiter" ... > "quote" ... > "header" ... > "nulls" ... > "objecttable" ... > "version" ... > "including" ... > "excluding" ... > "xmldeclaration" ... > "variadic" ... > "exception" ... > "raise" ... > "chain" ... > "jsonarray_agg" ... > "jsonobject" ... > "preserve" ... > <ID> ... > <ESCAPEDFUNCTION> ... > <ESCAPEDTYPE> ... > <DECIMALVAL> ... > <FLOATVAL> ... > <STRINGVAL> ... > <UNSIGNEDINTEGER> ... > <BINARYSTRINGVAL> ... > "(" ... > "+" ... > "-" ... > "?" ... > "$" ... > -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3166) Name of remote WSDL is not shown in the import wizard

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3166?page=com.atlassian.jira.plu... ] Matej Kralik commented on TEIIDDES-3166: ---------------------------------------- [~blafond] I didn't noticed that it is HTML document in my example, my mistake.However, I am able to reproduce it on WSDL which is in [TEIIDDES-3129|https://issues.jboss.org/browse/TEIIDDES-3129] with the digest authentication. Your's examples work. > Name of remote WSDL is not shown in the import wizard > ----------------------------------------------------- > > Key: TEIIDDES-3166 > URL: https://issues.jboss.org/browse/TEIIDDES-3166 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 11.1.1 > Environment: Fedora 27 > Reporter: Matej Kralik > Attachments: screenshot.png > > > When I chose URL where WSDL is, the name of WSDL file or any identification is missing but the file is highlighted (screenshot). I am able to continue in creating source model from WSDL. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3087) There isn't a way to set the Connection type on a VDB in the Designer

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3087?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-3087: ---------------------------------------- [~mkralik] found and fixed the issue. thx. master: https://github.com/Teiid-Designer/teiid-designer/commit/d02df3299a94b8d07... > There isn't a way to set the Connection type on a VDB in the Designer > --------------------------------------------------------------------- > > Key: TEIIDDES-3087 > URL: https://issues.jboss.org/browse/TEIIDDES-3087 > Project: Teiid Designer > Issue Type: Bug > Components: VDB & Execution > Affects Versions: 11.0.1 > Reporter: Debbie Steigner > Assignee: Barry LaFond > Fix For: 11.1 > > > Because of https://issues.jboss.org/browse/TEIID-4957 a customer would need to be able to set the Connection Type on a VDB in the Designer before deploying it. There currently is not a way to do that. You cannot use the User Properties because it writes to the vdb.xml as <property name="connection-type" value="NONE"/> and it needs to be <connection-type>NONE</connection-type> -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3166) Name of remote WSDL is not shown in the import wizard

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3166?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-3166: ---------------------------------------- [~mkralik] I replicated the issue using your URL. However, the URL is for an HTML page, the file name doesn't show, but I'm not able to do a Next>>. I did convert the HTML to a WSDL (minus the HEADER element) and the file name shows but Next >> ends up with to errors that didn't like the *fault* element. Note that you can test with the following URLs and create models... (or there's more at http://www.webservicex.net) so the importer does work http://www.webservicex.net/stockquote.asmx?WSDL http://www.webservicex.net/country.asmx?WSDL http://www.webservicex.net/periodictable.asmx?WSDL > Name of remote WSDL is not shown in the import wizard > ----------------------------------------------------- > > Key: TEIIDDES-3166 > URL: https://issues.jboss.org/browse/TEIIDDES-3166 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 11.1.1 > Environment: Fedora 27 > Reporter: Matej Kralik > Attachments: screenshot.png > > > When I chose URL where WSDL is, the name of WSDL file or any identification is missing but the file is highlighted (screenshot). I am able to continue in creating source model from WSDL. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3087) There isn't a way to set the Connection type on a VDB in the Designer

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3087?page=com.atlassian.jira.plu... ] Matej Kralik reopened TEIIDDES-3087: ------------------------------------ When I generate .vdb, vdb.xml in the META-INF doesn't contain any connection-type element. I must change connection-type in vdbEditor (vdbEditor.png) and after that, the vdb.xml in the .vdb contains this element. So if I wont to set NONE which is predefined, I must change the connection type to something else and back to NONE and save vdb. And dynamic vdb (save vdb as XML file) doesn't contain this element either. > There isn't a way to set the Connection type on a VDB in the Designer > --------------------------------------------------------------------- > > Key: TEIIDDES-3087 > URL: https://issues.jboss.org/browse/TEIIDDES-3087 > Project: Teiid Designer > Issue Type: Bug > Components: VDB & Execution > Affects Versions: 11.0.1 > Reporter: Debbie Steigner > Assignee: Barry LaFond > Fix For: 11.1 > > > Because of https://issues.jboss.org/browse/TEIID-4957 a customer would need to be able to set the Connection Type on a VDB in the Designer before deploying it. There currently is not a way to do that. You cannot use the User Properties because it writes to the vdb.xml as <property name="connection-type" value="NONE"/> and it needs to be <connection-type>NONE</connection-type> -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3163) Translator override properties can not be updated after re-generating a dynamic vdb

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3163?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-3163: ---------------------------------------- master: https://github.com/Teiid-Designer/teiid-designer/commit/991ac81bc572ed85b... > Translator override properties can not be updated after re-generating a dynamic vdb > ----------------------------------------------------------------------------------- > > Key: TEIIDDES-3163 > URL: https://issues.jboss.org/browse/TEIIDDES-3163 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs > Affects Versions: 11.1.1 > Environment: Devstudio 11.1.0 CR1 (Teiid Desinger 11.1.1) > Reporter: Hiroki Daicho > Assignee: Barry LaFond > Fix For: 11.1.1 > > Attachments: reproducer_project.zip > > > If dynamic vdb has already generated, Translator override properties can not be modified by regenerate dynamic vdb. > 1. Add Translator override property to vdb (testvdb.vdb). e.g. prop1 -> 100 > 2. generate dynamic vdb (testvdb-vdb.xml). > {code} > <property name="prop1" value="100"/> > {code} > 3. Modify the propery in vdb (testvdb.vdb). e.g. prop1 -> 199 > 4. generate dynamic vdb (testvdb-vdb.xml). > 5. the property is not updated to 199 in the dynamic vdb xml. > {code} > <property name="prop1" value="100"/> > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2965) translator override gets overwritten on synchronize all

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2965?page=com.atlassian.jira.plu... ] Matej Kralik closed TEIIDDES-2965. ---------------------------------- I am not able to reproduce it. In 11.1.1 I have VDB with source model which has overridden translator. I changed something and click on "synchronize all" button in the vdb. Overriding translator for source model stays unchanged in the VDB. So I closed this issue. > translator override gets overwritten on synchronize all > ------------------------------------------------------- > > Key: TEIIDDES-2965 > URL: https://issues.jboss.org/browse/TEIIDDES-2965 > Project: Teiid Designer > Issue Type: Bug > Reporter: Omar Khan > Assignee: Barry LaFond > Fix For: 11.1 > > > The latest 10.1 seems to override the translators set in the VDB when synchronizing all or individual. > Please refer to this thread for more details: > https://developer.jboss.org/thread/272835 -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues December 2017