November 2015 - teiid-designer-issues

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

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2550?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2550: ----------------------------------- Component/s: Patch Release > 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, Patch Release, 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.1 > > Attachments: ParseTimestamp-Project.png, 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.4.11#64026)

10 years, 5 months

1
0
0 / 0

[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 updated TEIIDDES-2523: ----------------------------------- Component/s: Patch Release > 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 > Fix For: 9.2.1 > > 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 (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2481) Add support for recursive common table expressions

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2481?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2481: ----------------------------------- Component/s: Patch Release > Add support for recursive common table expressions > -------------------------------------------------- > > Key: TEIIDDES-2481 > URL: https://issues.jboss.org/browse/TEIIDDES-2481 > Project: Teiid Designer > Issue Type: Feature Request > Components: Modeling, Patch Release, Teiid Integration > Reporter: Steven Hawkins > Assignee: Paul Richardson > Fix For: 9.2.1 > > > Teiid 8.10 added support for recursive common table expressions. There is no new syntax, but more logic around resolving a special form of a common table expression. If the query expression is written as a union then the right hand side of the union is allowed to reference the common table group. See https://docs.jboss.org/author/display/TEIID/WITH+Clause -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2270) Add capability to import a project for migrations.

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2270?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2270: ----------------------------------- Fix Version/s: 10.1 (was: 9.2.1) > Add capability to import a project for migrations. > -------------------------------------------------- > > Key: TEIIDDES-2270 > URL: https://issues.jboss.org/browse/TEIIDDES-2270 > Project: Teiid Designer > Issue Type: Feature Request > Components: Import/Export > Affects Versions: 8.5 > Reporter: Hisanobu Okuda > Assignee: Barry LaFond > Fix For: 10.1 > > > This capability would allow a user to easily upgrade their Designer version without losing anything. The workspace export/import would bring along projects, preferences, connector bindings, extension jars, etc. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2487) Teidd Designer Import SOAP Relational Model Mapping No Columns defined

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2487?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2487: ----------------------------------- Component/s: Patch Release > Teidd Designer Import SOAP Relational Model Mapping No Columns defined > ---------------------------------------------------------------------- > > Key: TEIIDDES-2487 > URL: https://issues.jboss.org/browse/TEIIDDES-2487 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export, Patch Release > Affects Versions: 9.0 > Reporter: Kylin Soong > Assignee: Ted Jones > Fix For: 9.2.1 > > Attachments: StateService.jar, teiid-designer-ws-1.png, teiid-designer-ws-2.png, teiid-designer-ws-3.png, teiid-designer-ws-4.png > > > issue > ==== > Create Relational Model from SOAP service validation failed with "No Columns defined error" > Reproduce > ======== > 1. deploy attached StateService to JBoss DV 6.1(assume it DV run on localhost), WSDL File can be viewed via [2] > 2. Use attached 4 pics to import SOAP Web Service will reproduce the issue(teiid-designer-ws-3.png and teiid-designer-ws-4.png show validation errors) > Enhancement > ========== > 1. Simplify the import wizard - from a user's perspective, I think the main obstacle is the wizard is too complex, especially SOAP, federation related wizard, it's very difficult to operate without a step by step documents. > 2. Simplify XML document modeling related operation - current wizard not user-friendly, web should do some enhancement in request/response xml document modeling. > 3. Simplify vdb archive structure - the Designer generated vdb is more complexed compared with dynamic vdb, it have more definition files(sources.xmi, views.xmi, vdb.xml), there also some metamatrix link like [2] exist in .xmi, actually these links not really exist, if we remove these kinds of things, the designer wizard logic may be more easier. > [1] http://localhost:8080/StateService/stateService/StateServiceImpl?WSDL > [2] http://www.metamatrix.com/metamodels/SimpleDatatypes-instance#XMLLiteral -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2486) Changing Fields in Flat File Importer Column Editor Causes Designer to Hang

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2486?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2486: ----------------------------------- Component/s: Patch Release > Changing Fields in Flat File Importer Column Editor Causes Designer to Hang > --------------------------------------------------------------------------- > > Key: TEIIDDES-2486 > URL: https://issues.jboss.org/browse/TEIIDDES-2486 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Patch Release > Affects Versions: 8.3.4 > Reporter: Ted Jones > Assignee: Ted Jones > Fix For: 9.2.1 > > > In OSX, editing a column name and clicking on another column name hangs Designer. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2493) Check for spaces in the parent directory Flat File connection importer

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2493?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2493: ----------------------------------- Component/s: Patch Release > Check for spaces in the parent directory Flat File connection importer > ---------------------------------------------------------------------- > > Key: TEIIDDES-2493 > URL: https://issues.jboss.org/browse/TEIIDDES-2493 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export, Patch Release > Reporter: Ramesh Reddy > Assignee: Mark Drilling > Fix For: 9.2.1 > > > Add a check to make sure there are no spaces in the ParentDirectory or root directory path when Flat File Connection Profile is chosen. > ==================== > The problem is manifested on the server when attempting to query the datasource. On datasource creation, the resource adapter is written to the standalone.xml like this. > {code:java} > <config-property name="ParentDirectory"> > /home/mdrilling/My Dir/data > </config-property> > {code} > The embedded space in the ParentDirectory property value is problematic. > Need to determine whether to (1) disallow a path with spaces or (2) allow it, replacing the space with the appropriate control code ie {code:java} {code} - like this > {code:java} > <config-property name="ParentDirectory"> > /home/mdrilling/My Dir/data > </config-property> > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2496) Importing valid WSDL with web service import wizard fails to create model in designer

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2496?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2496: ----------------------------------- Component/s: Patch Release > Importing valid WSDL with web service import wizard fails to create model in designer > ------------------------------------------------------------------------------------- > > Key: TEIIDDES-2496 > URL: https://issues.jboss.org/browse/TEIIDDES-2496 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Patch Release > Affects Versions: 8.6.1, 9.0.1 > Reporter: Barry LaFond > Assignee: Ted Jones > Fix For: 9.2.1 > > Attachments: HotelWS.zip, modified_HotelWS.zip > > > wsdl and xsd for hotel web services in bpms travel agency demo > Attempts to create a teiid web service model with the attached wsdl and xsd fails with an invalid wsdl error. The wsdl is valid in eclipse, but the importer fails to create a model > This is the wsdl from the travel agency demo which is being used for a jdv-bpms integration for jbossdemocentral and summit. The wsdl from the github site imports, but no model is created. It just fails silently and generates an empty model. The wsdl attached is a modification of the wsdl at the github site, and it fails with wsdl validation errors. The wsdl is valid in eclipse, but not in the import wizard. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2664) Add Model Extension support for Procedure RESULTS OPTIONS

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2664?page=com.atlassian.jira.plu... ] Barry LaFond reassigned TEIIDDES-2664: -------------------------------------- Assignee: Barry LaFond > Add Model Extension support for Procedure RESULTS OPTIONS > --------------------------------------------------------- > > Key: TEIIDDES-2664 > URL: https://issues.jboss.org/browse/TEIIDDES-2664 > Project: Teiid Designer > Issue Type: Enhancement > Components: Teiid Integration > Reporter: Ramesh Reddy > Assignee: Barry LaFond > Fix For: 9.2.1 > > > Teiid DDL now supports options for procedure/functions returns clause parameters: > ... RETURNS (options ...) type > ... RETURNS (options ...) TABLE (...) > This was added to Teiid version 8.12 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2664) Add Model Extension support for Procedure RESULTS OPTIONS

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2664?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2664: ----------------------------------- Component/s: Patch Release > Add Model Extension support for Procedure RESULTS OPTIONS > --------------------------------------------------------- > > Key: TEIIDDES-2664 > URL: https://issues.jboss.org/browse/TEIIDDES-2664 > Project: Teiid Designer > Issue Type: Enhancement > Components: Patch Release, Teiid Integration > Reporter: Ramesh Reddy > Assignee: Barry LaFond > Fix For: 9.2.1 > > > Teiid DDL now supports options for procedure/functions returns clause parameters: > ... RETURNS (options ...) type > ... RETURNS (options ...) TABLE (...) > This was added to Teiid version 8.12 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 5 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 November 2015