April 2016 - 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 closed TEIIDDES-2550. ---------------------------------- Resolution: Done re-closing after target version changes > 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 > Labels: verified_jbdsis-9.0.0.Beta > Fix For: 10.0, 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

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2558) Unable to import attached DDL, invalid cardinality

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2558?page=com.atlassian.jira.plu... ] Barry LaFond closed TEIIDDES-2558. ---------------------------------- Resolution: Done re-closing after target version changes > Unable to import attached DDL, invalid cardinality > -------------------------------------------------- > > Key: TEIIDDES-2558 > URL: https://issues.jboss.org/browse/TEIIDDES-2558 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Patch Release, Teiid Integration > Affects Versions: 9.1 > Reporter: Van Halbert > Assignee: Dan Florian > Labels: release_notes, verified_jbdsis-9.0.0.Beta > Fix For: 10.0, 9.2.1 > > Attachments: fixed-postgres-vdb.xml > > > Trying to import DDL using the attached file. The wizard stops and indicates the CARDINALITY 6000000000 is invalid. If I remove "CARDINALITY 6000000000", then it succeeds. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2610) Add some default values to importer properties in Teiid Connection Importer

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2610?page=com.atlassian.jira.plu... ] Barry LaFond closed TEIIDDES-2610. ---------------------------------- Resolution: Done re-closing after target version changes > Add some default values to importer properties in Teiid Connection Importer > --------------------------------------------------------------------------- > > Key: TEIIDDES-2610 > URL: https://issues.jboss.org/browse/TEIIDDES-2610 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export, Patch Release > Affects Versions: 9.1 > Reporter: Barry LaFond > Assignee: Barry LaFond > Labels: release_notes, verified_jbdsis-9.0.0.Beta > Fix For: 10.0, 9.2.1 > > Attachments: SelectTranslatorPage.patch, TeiidPropertyDefinition.patch > > > Importing JDBC sources via Teiid Connection importer can be streamlined by providing/setting certain default import property values. > 2 such properties are: > *Table Types* > *TABLE* > *use Qualified Name* > *false* > This will help in the most common use-case to reduce the number of steps to importer and improve the experience of first-time users. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2711) WS Create Operation - Wrong Label Name For Output Message

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2711?page=com.atlassian.jira.plu... ] Barry LaFond closed TEIIDDES-2711. ---------------------------------- Resolution: Done re-closing after target version changes > WS Create Operation - Wrong Label Name For Output Message > --------------------------------------------------------- > > Key: TEIIDDES-2711 > URL: https://issues.jboss.org/browse/TEIIDDES-2711 > Project: Teiid Designer > Issue Type: Bug > Components: Web Services Support > Affects Versions: 9.0.4 > Reporter: Matus Makovy > Assignee: Matus Makovy > Priority: Minor > Labels: release_notes, verified_jbdsis-9.0.0.Beta > Fix For: 10.0, 9.2.1 > > Attachments: Selection_030.png > > > Coppied from BZ: > Description of problem: > "Input Message" label is used for both input message and output message > Version-Release number of selected component (if applicable): > Teiid Designer 9.0.3.Final-v205 (latest on the customer portal) > How reproducible: > Steps to Reproduce: > 1. Open a webservice model, > 2. Select one of the interfaces, right click on it and choose create operation from the menu > See attached screenshot -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2738) REST procedure not imported correctly from dynamic VDB

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2738?page=com.atlassian.jira.plu... ] Barry LaFond closed TEIIDDES-2738. ---------------------------------- Resolution: Done re-closing after target version changes > REST procedure not imported correctly from dynamic VDB > ------------------------------------------------------- > > Key: TEIIDDES-2738 > URL: https://issues.jboss.org/browse/TEIIDDES-2738 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Patch Release, VDB & Execution > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Labels: release_notes, verified_jbdsis-9.0.0.Beta > Fix For: 10.0, 9.2.1 > > > When importing a dynamic VDB with REST procedure, the created procedure does not have the REST options set. > {code:xml} > <?xml version="1.0" encoding="UTF-8" standalone="no"?> > <vdb name="RestProcedureVdbDynamic" version="1"> > <description /> > <property name="{http://teiid.org/rest}auto-generate" value="true" /> > <model name="ProcedureModel" type="VIRTUAL"> > <metadata type="DDL"><![CDATA[ > SET NAMESPACE 'http://teiid.org/rest' AS REST; > CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) RETURNS TABLE (xml_out xml) OPTIONS ("REST:METHOD" 'GET', "REST:URI" 'test/{p1}') > AS > BEGIN > SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out; > END; > ]]></metadata> > </model> > </vdb> > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2719) DDL for UDF in exported dynamic VDB contains RETURN parameter

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2719?page=com.atlassian.jira.plu... ] Barry LaFond closed TEIIDDES-2719. ---------------------------------- Resolution: Done re-closing after target version changes > DDL for UDF in exported dynamic VDB contains RETURN parameter > ------------------------------------------------------------- > > Key: TEIIDDES-2719 > URL: https://issues.jboss.org/browse/TEIIDDES-2719 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs, Import/Export, Patch Release > Affects Versions: 9.2 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Labels: release_notes, verified_jbdsis-9.0.0.Beta > Fix For: 10.0, 9.2.1 > > Attachments: UdfProject.zip > > > When exporting VDB with a UDF, the resulting DDL contains the RETURN parameter in the parameters list. According to the [Teiid docs|https://docs.jboss.org/author/display/teiid87final/Support+for+User-...], the return parameter should not be specified. > Generated DDL: > {code:sql} > CREATE VIRTUAL FUNCTION concatNull (stringLeft string(4000), stringRight string(4000), result string(4000)) RETURNS string > ) OPTIONS("FUNCTION-CATEGORY" 'MY_TESTING_FUNCTION_CATEGORY', JAVA_CLASS 'userdefinedfunctions.MyConcatNull', JAVA_METHOD 'myConcatNull') > {code} > Expected DDL: > {code:sql} > CREATE VIRTUAL FUNCTION concatNull (stringLeft string(4000), stringRight string(4000)) RETURNS string > OPTIONS("FUNCTION-CATEGORY" 'MY_TESTING_FUNCTION_CATEGORY', JAVA_CLASS 'userdefinedfunctions.MyConcatNull', JAVA_METHOD 'myConcatNull') > {code} > (note that the generated DDL also contains an unrelated syntax error due to TEIIDDES-2697) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2600) DDL Importer does not yet support GLOBAL or LOCAL TEMP TABLE

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2600?page=com.atlassian.jira.plu... ] Barry LaFond closed TEIIDDES-2600. ---------------------------------- Resolution: Done re-closing after target version changes > DDL Importer does not yet support GLOBAL or LOCAL TEMP TABLE > ------------------------------------------------------------ > > Key: TEIIDDES-2600 > URL: https://issues.jboss.org/browse/TEIIDDES-2600 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, ModeShape Integration, Patch Release > Reporter: Barry LaFond > Assignee: Barry LaFond > Labels: release_notes, verified_jbdsis-9.0.0.Beta > Fix For: 10.0, 9.2.1 > > > Trying to import the following DDL into a View model (see: TEIIDDES-1794) the resulting Table has the Global Temp Table value set to *false*. > I don't think the TeiidDdlImporter is handling these particular cases. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2414) Large transformation SQL is not exported to INDEX file.

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2414?page=com.atlassian.jira.plu... ] Barry LaFond closed TEIIDDES-2414. ---------------------------------- Resolution: Done re-closing after target version changes > Large transformation SQL is not exported to INDEX file. > ------------------------------------------------------- > > Key: TEIIDDES-2414 > URL: https://issues.jboss.org/browse/TEIIDDES-2414 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Patch Release > Affects Versions: 8.3.4 > Reporter: Hisanobu Okuda > Assignee: Paul Richardson > Labels: release_notes, verified_jbdsis-9.0.0.Beta > Fix For: 10.0, 9.2.1 > > Attachments: reosurce-problem-marker.png, test.csv > > > A large transformation SQL of a view model is not exported to INDEX file. > I have a large transformation SQL > 8192 bytes in my view model. TDesigner fails to convert the xmi to XXXXXXXXXX.INDEX file. There is no transformation SQL in the INDEX file, therefore, deploying my vdb fails and the vdb is inactivated. When you deploy the vdb, you can see the following message in a log file:- > {code} > 17:16:11,632 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31079 View ViewModel.new_table is not defined by a query expression. > 17:16:11,636 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID40073 The metadata for the VDB test.1 is loaded, however it is not valid. Check models for errors. Correct the metadata and re-deploy. > 17:16:11,637 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID40003 VDB test.1 is set to FAILED > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2751) Add ability to import Oracle Packages via JDBC Import

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2751?page=com.atlassian.jira.plu... ] Barry LaFond closed TEIIDDES-2751. ---------------------------------- Resolution: Done re-closing after target version changes > Add ability to import Oracle Packages via JDBC Import > ----------------------------------------------------- > > Key: TEIIDDES-2751 > URL: https://issues.jboss.org/browse/TEIIDDES-2751 > Project: Teiid Designer > Issue Type: Feature Request > Components: Import/Export, Patch Release > Affects Versions: 9.0.2 > Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3, > JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157 > 64-bit Windows 7 environment > Reporter: Steve Tran > Assignee: Barry LaFond > Priority: Blocker > Labels: release_notes, verified_jbdsis-8.0.5 > Fix For: 10.0, 9.0.5, 9.2.1 > > > When using the JDBC importer with an Oracle datasource, Oracle Packages are not available to be selected. I am only allowed to select Tables, Views, and Procedures. There should be an option to select Packages, which in my case contains stored procedures. > A ticket was submitted on the TEIID side to support this functionality. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2785) Open transformation editor through diagram will display wrong editor

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2785?page=com.atlassian.jira.plu... ] Barry LaFond closed TEIIDDES-2785. ---------------------------------- Resolution: Done re-closing after target version changes > Open transformation editor through diagram will display wrong editor > -------------------------------------------------------------------- > > Key: TEIIDDES-2785 > URL: https://issues.jboss.org/browse/TEIIDDES-2785 > Project: Teiid Designer > Issue Type: Bug > Components: Editors > Affects Versions: 10.0.1 > Environment: Windows 10 Pro N > Fedora 23 > Reporter: Matej Kralik > Assignee: Barry LaFond > Priority: Minor > Labels: verified_jbdsis-9.0.0.Beta > Fix For: 10.0 > > Attachments: Recursive.zip > > > When I try open transformation editor again (double click to the arrow icon with "T" in the diagram), editor kicks me out to the packaging editor. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

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