April 2017 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-3073) Bad imported Name In Source from SapIQ datasource

by Mario Majernik (JIRA)

Mario Majernik created TEIIDDES-3073: ---------------------------------------- Summary: Bad imported Name In Source from SapIQ datasource Key: TEIIDDES-3073 URL: https://issues.jboss.org/browse/TEIIDDES-3073 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 11.0.1 Reporter: Mario Majernik Attachments: SapIQ.png After importing tables "SmallA" and "SmallB" from SapIQ datasource are values of Name In Source bad. Should be "SmallA" for table SmallA but there is value "bqt-server.SmallA" (SapIQ.png). The same for table "SmallB". [Values for SapIQ|https://mojo.redhat.com/docs/DOC-1125539] -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3060) Duplicate UUID on VDB generated from Teiid Designer

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3060?page=com.atlassian.jira.plu... ] Matus Makovy commented on TEIIDDES-3060: ---------------------------------------- I cannot deploy the VDB because it is missing the JAR file. When I look in the XMI files I cannot find the duplicate UUID. Maybe the issue is on my side - can you supply the line numbers or so? > Duplicate UUID on VDB generated from Teiid Designer > --------------------------------------------------- > > Key: TEIIDDES-3060 > URL: https://issues.jboss.org/browse/TEIIDDES-3060 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs > Affects Versions: 9.1 > Reporter: Abraham Arellano Tavara > Priority: Critical > Attachments: BoGeschVorgangLesenDataM.xmi, Negativmerkmal.xmi, PersonTyp.xmi, Regeldaten.xmi, RegeldatenFedView_lean.vdb, SvzEintragM.xmi, error_trace.txt, utilView.xmi > > > The error of duplicated UUID is thrown when a VDB generated by the Teiid Designer is deployed. There are 2 return object from 2 different functions which have the same UUID. > The exception is: (The full trace is attached "error_trace.txt") > java.lang.AssertionError: duplicate uid object result > In more detail the following views / functions have the same UUID: > + SvzEintragM / dvkSvz_liesEintragAusSvz > + BoGeschVorgangLesenDataM / dvkVorgang_liesVorgang -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1732) Stream line steps to implement all the steps around materialization

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1732?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-1732. ---------------------------------- > Stream line steps to implement all the steps around materialization > -------------------------------------------------------------------- > > Key: TEIIDDES-1732 > URL: https://issues.jboss.org/browse/TEIIDDES-1732 > Project: Teiid Designer > Issue Type: Feature Request > Components: Modeling > Affects Versions: 8.2 > Reporter: Van Halbert > Assignee: Barry LaFond > Fix For: 11.0.1 > > > Would like to stream line the steps to putting materialization to work. Example: > - Right mouse click on view, select materialization > - present wizard to walk thru the following options: > - create physical table based on selected view/table (export/import of ddl is supported, but would like the table automatically created) > - put name of mat table into the selected table/view to be materialized > - [optional] export DDL (file system or clipboard) > - [optional] create procedure that has the "select into" for refreshing > Having the procedure provides the immediate ability to call to refresh, without having to remember what tables. Also, with the feature of native queries, could add the truncate call to clear the table. > Once thru this wizard, (I think) everything is in place to do materialization for the specified table. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 1 month

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 Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3072?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-3072. ------------------------------------ Resolution: Done 11.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/e4757c48fb0443698... > "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.0.2 > > > 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.2.3#72005)

7 years, 1 month

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 Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3072?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-3072: ----------------------------------- Fix Version/s: 11.0.2 > "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.0.2 > > > 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.2.3#72005)

7 years, 1 month

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 Debbie Steigner (JIRA)

Debbie Steigner created TEIIDDES-3072: ----------------------------------------- Summary: "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: 11.0.1, 10.0.2, 9.0.7 Reporter: Debbie Steigner Assignee: Barry LaFond 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.2.3#72005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2394) Add UI support for TEXTTABLE Custom Line Separator

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2394?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-2394. ---------------------------------- > Add UI support for TEXTTABLE Custom Line Separator > --------------------------------------------------- > > Key: TEIIDDES-2394 > URL: https://issues.jboss.org/browse/TEIIDDES-2394 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export, Patch Release, Teiid Integration > Reporter: Shiveeta Mattoo > Assignee: Barry LaFond > Labels: FileConnector, TEXTTABLE > Fix For: 11.0.1 > > Attachments: Screen Shot 2017-02-13 at 14.02.50.png > > > Add UI support for TEXTTABLE capability to support a Custom Line Separator . See https://docs.jboss.org/author/display/TEIID/FROM+Clause with the ROW DELIMITER char option. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3012) Update JBoss TP to 4.4.1

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3012?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-3012. ---------------------------------- > Update JBoss TP to 4.4.1 > ------------------------ > > Key: TEIIDDES-3012 > URL: https://issues.jboss.org/browse/TEIIDDES-3012 > Project: Teiid Designer > Issue Type: Task > Components: Build > Reporter: Barry LaFond > Assignee: Barry LaFond > Fix For: 11.0.1 > > > Next JBDSIS release: 10.1.0 - Neon is using JBoss TP 4.4.1 > Upgrade 11.0.1 to use this TP -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 1 month

1
0
0 / 0

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

by Debbie Steigner (JIRA)

Debbie Steigner created TEIIDDES-3071: ----------------------------------------- Summary: 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 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.2.3#72005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3046) Unable to preview data of file-based data source when the JNDI name already exist on the server runtime

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3046?page=com.atlassian.jira.plu... ] Ramesh Reddy commented on TEIIDDES-3046: ---------------------------------------- [~blafond] If you do not treat your JNDI name as the identifier, then above scenario should work in Admin API. I believe as I said the pool-name and RA's id are considered same in Teiid Admin API, nothing about JNDI name. In your code once you get the datasource object, need to look for JNDI name. But your access should be limited to deployment name aka identifier. > Unable to preview data of file-based data source when the JNDI name already exist on the server runtime > ------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-3046 > URL: https://issues.jboss.org/browse/TEIIDDES-3046 > Project: Teiid Designer > Issue Type: Bug > Components: Data Preview > Affects Versions: 10.0.2 > Environment: MacOS > Red Hat JBoss Developer Studio 10.3.0.GA with JBoss Developer Studio Integration Stack 10.0.2 installed > Reporter: Cojan van Ballegooijen > Assignee: Barry LaFond > Fix For: 11.0.2 > > Attachments: Screen Shot 2017-03-01 at 10.16.26.png, Screen Shot 2017-03-01 at 10.16.46.png > > > If a data source is already created on the JDV server runtime unable to preview data on the models. > Workaround is to add these models into a VDB, deploy/execute VDB but Preview data should work despite the fact that the datasource JNDI names already exists on the server side. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 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 April 2017