June 2018 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2523) Add or Remove input variables for WS operation not working correctly

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2523?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2523. ------------------------------------ Fix Version/s: (was: 11.2) Resolution: Won't Fix > Add or Remove input variables for WS operation not working correctly > -------------------------------------------------------------------- > > Key: TEIIDDES-2523 > URL: https://issues.jboss.org/browse/TEIIDDES-2523 > Project: Teiid Designer > Issue Type: Bug > Components: Editors, Patch Release, Web Services Support > Affects Versions: 8.3.4, 9.0.1 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Priority: Minor > Attachments: WsVariablesProject.zip, WsVariablesProject_Fixed.zip > > > The variables are now shown after opening the model, however, clicking Add or Remove variables shows the Edit Input Variables editor with all the variables deselected. Selecting some of the variables adds them to the transformation, resulting in invalid SQL. > New steps to reproduce: > import the attached project > double click the OrderCheckingWs in model explorer, the model editor will open > click Add or Remove variables > notice all variables are deselected > select OrderDate, click OK > save the model, the following validation error is shown: > ERROR: Variable VARIABLES.IN_OrderDate was previously declared. > Note that as a user checks/unchecks variables, the SQL transformation is trying to keep pace with the selections and isn't staying in sync. You can end up with multiple/duplicates. Expanding the tree shows that 2 of the 3 variables show as checked. But OrderDate is Not. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2390) Transformation SQL formatting inserts extra characters

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2390?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2390: ----------------------------------- Fix Version/s: Future (was: 11.2) > Transformation SQL formatting inserts extra characters > ------------------------------------------------------ > > Key: TEIIDDES-2390 > URL: https://issues.jboss.org/browse/TEIIDDES-2390 > Project: Teiid Designer > Issue Type: Bug > Components: Patch Release, Transformations > Affects Versions: 8.3.4, 9.0.1 > Reporter: Andrej Šmigala > Assignee: Paul Richardson > Priority: Minor > Fix For: Future > > > Typing more than two newlines after a keyword in the transformation editor causes part of that keyword to be inserted into the transformation. > e. g. typing > {code:sql} > select <enter><enter><enter> > {code} > produces > {code:sql} > SEL > SELECT > > {code} > and > {code:sql} > select * from <enter><enter><enter><enter> > {code} > produces > {code:sql} > SELECT > * > FRO > FRO > FROM > > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3109) The Exported DDL show the DDL if for Oracle 8.1.6

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3109?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-3109. ------------------------------------ Fix Version/s: (was: 11.2) Resolution: Out of Date > The Exported DDL show the DDL if for Oracle 8.1.6 > ------------------------------------------------- > > Key: TEIIDDES-3109 > URL: https://issues.jboss.org/browse/TEIIDDES-3109 > Project: Teiid Designer > Issue Type: Quality Risk > Environment: JBDS 10.4 under JDV 6.3 > Reporter: Kylin Soong > > Once export the DDL, the file shows the DDL is for Oracle 8 > {code} > - Build Script > -- RDBMS : Oracle 8.1.6 > -- Generated With : > -- Generated On : 2017-09-18 10:55:51 > -- Generation Options > -- Generate Drop Statements : false > -- Convert Table Descriptions to COMMENT ON Statements : true > -- Convert Column Descriptions to COMMENT ON Statements : true > -- > -- Uncomment the following line for use of the logging facility (see last line also) > --spool .log > -- ---------------------------------------------------------------------------------------------------------------- > -- Generate From > -- Model : /PetroChinaTest/FederatedDataLayer/A1_EPDM_FBL.xmi > -- Model Type : Virtual > -- Metamodel : relational (http://www.metamatrix.com/metamodels/Relational) > -- Model UUID : mmuuid:d614916d-8573-47b1-933f-78d183716404 > -- ---------------------------------------------------------------------------------------------------------------- > -- (generated from CD_ACTIVITY) > CREATE TABLE CD_ACTIVITY > ( > ACTIVITY_ID VARCHAR2(32) NOT NULL, > PARENT_ID VARCHAR2(32), > {code} > Customer are confused whether this DDL is fine for exec against Oracle 11 -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3156) VDB "Test" did not create a connection profile automatically

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3156?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-3156. ------------------------------------ Resolution: Out of Date > VDB "Test" did not create a connection profile automatically > ------------------------------------------------------------ > > Key: TEIIDDES-3156 > URL: https://issues.jboss.org/browse/TEIIDDES-3156 > Project: Teiid Designer > Issue Type: Bug > Components: VDB & Execution > Affects Versions: 11.0 > Reporter: Ramesh Reddy > > Execute VDB action, as I remember used to create connection profile automatically such that user can click OK and execute. With the current version, it makes you enter all the values again including the VDB name. All the required information is available, so this should be automatically created. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3156) VDB "Test" did not create a connection profile automatically

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3156?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-3156: ----------------------------------- Fix Version/s: (was: 11.2) > VDB "Test" did not create a connection profile automatically > ------------------------------------------------------------ > > Key: TEIIDDES-3156 > URL: https://issues.jboss.org/browse/TEIIDDES-3156 > Project: Teiid Designer > Issue Type: Bug > Components: VDB & Execution > Affects Versions: 11.0 > Reporter: Ramesh Reddy > > Execute VDB action, as I remember used to create connection profile automatically such that user can click OK and execute. With the current version, it makes you enter all the values again including the VDB name. All the required information is available, so this should be automatically created. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3074) Driver for Mondrian cannot be deployed on server

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3074?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-3074. ------------------------------------ Fix Version/s: (was: 11.2) Resolution: Explained > Driver for Mondrian cannot be deployed on server > ------------------------------------------------ > > Key: TEIIDDES-3074 > URL: https://issues.jboss.org/browse/TEIIDDES-3074 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 11.0.1 > Reporter: Mario Majernik > Attachments: Mondrian-fail-add-driver.png > > > [Driver|http://dvqe11.mw.lab.eng.bos.redhat.com:8081/nexus/content/repositories/bqt-artifacts-testing/org/jboss/dv/qe/drivers/mondrian/mondrian/1.0-dv-63-SNAPSHOT/] > cannot be deployed. (Mondrian-fail-add-driver.png) -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3061) Add support for Teiid 9.2 runtime

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3061?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-3061: ----------------------------------- Fix Version/s: 11.3 (was: 11.2) > Add support for Teiid 9.2 runtime > --------------------------------- > > Key: TEIIDDES-3061 > URL: https://issues.jboss.org/browse/TEIIDDES-3061 > Project: Teiid Designer > Issue Type: Task > Components: Release Work, Teiid Integration > Reporter: Barry LaFond > Assignee: Barry LaFond > Fix For: 11.3 > > -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3020) Add new materialization properties

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3020?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-3020: ----------------------------------- Fix Version/s: 11.3 (was: 11.2) > Add new materialization properties > ---------------------------------- > > Key: TEIIDDES-3020 > URL: https://issues.jboss.org/browse/TEIIDDES-3020 > Project: Teiid Designer > Issue Type: Task > Components: Teiid Integration > Reporter: Steven Hawkins > Fix For: 11.3 > > > In the teiid_rel namespace several new properties for materialized views have been added: > MATVIEW_LOADNUMBER_COLUMN - references a column name on the materialization target table. Introduced with TEIID-4641 to offer more flexibility in refresh beyond swapping > MATVIEW_WRITE_THROUGH - a boolean to denote whether updates against the view should also write into materialization target as well. Introduced with TEIID-3952 > There may be more related to the status table and debezium integration. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3006) api-docs on Swagger UI error

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3006?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-3006: ----------------------------------- Fix Version/s: 11.3 (was: 11.2) > api-docs on Swagger UI error > ---------------------------- > > Key: TEIIDDES-3006 > URL: https://issues.jboss.org/browse/TEIIDDES-3006 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0.2 > Reporter: Debbie Steigner > Assignee: Ted Jones > Fix For: 11.3 > > Attachments: Screenshot-RestVDB VDB - Mozilla Firefox.png, screen-404.png, screen-api.png > > > The link on the Swagger UI for api-docs, shows Error - {"schemaValidationMessages":[{"level":"error","message":"Can't read from file http://127.0.0.1:8080/RestVDB/api-docs/Debbiev"}]} > But I can enter the URL and go to the api-doc - http://127.0.0.1:8080/RestVDB/api-docs/Debbiev > {"apiVersion":"2.0.0","swaggerVersion":"1.2","basePath":"/RestVDB","resourcePath":"/Debbiev","apis":[{"path":"/Debbiev/mytable","operations":[{"method":"POST","summary":"(XML) postmytable: null","notes":"","type":"java.io.InputStream","nickname":"postmytable","produces":["application/xml; charset=UTF-8"],"consumes":["application/xml"],"parameters":[{"name":"body","required":false,"type":"java.io.InputStream","paramType":"body","allowMultiple":false}]},{"method":"GET","summary":"(XML) getmytable: null","notes":"","type":"java.io.InputStream","nickname":"getmytable","produces":["application/xml; charset=UTF-8"],"parameters":[]}]},{"path":"/Debbiev/json/mytable","operations":[{"method":"GET","summary":"(JSON) getmytable: null","notes":"","type":"string","nickname":"getmytablejson","produces":["application/json; charset=UTF-8"],"parameters":[]},{"method":"POST","summary":"(JSON) postmytable: null","notes":"","type":"string","nickname":"postmytablejson","produces":["application/json; charset=UTF-8"],"consumes":["application/json"],"parameters":[{"name":"body","required":false,"type":"java.io.InputStream","paramType":"body","allowMultiple":false}]}]}]} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2968) Cannot create Teiid service adapter from OSE3 running server

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2968?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2968: ----------------------------------- Fix Version/s: Future (was: 11.2) > Cannot create Teiid service adapter from OSE3 running server > ------------------------------------------------------------ > > Key: TEIIDDES-2968 > URL: https://issues.jboss.org/browse/TEIIDDES-2968 > Project: Teiid Designer > Issue Type: Bug > Reporter: Jiri Pechanec > Assignee: Barry LaFond > Fix For: Future > > > If I create a server via OpenShift 3.x server adapter it is not recognized as an Teiid instance. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 10 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 June 2018