June 2017 - teiid-designer-issues

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

by Barry LaFond (JIRA)

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

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3053) Issue with trying to perform Preview Data

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3053?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-3053. ------------------------------------ Resolution: Done 11.0.x : https://github.com/Teiid-Designer/teiid-designer/commit/baaae8d9a51a5a023... > Issue with trying to perform Preview Data > ----------------------------------------- > > Key: TEIIDDES-3053 > URL: https://issues.jboss.org/browse/TEIIDDES-3053 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Usability > Affects Versions: 11.0.1 > Reporter: Van Halbert > Assignee: Barry LaFond > Fix For: 11.0.2 > > > The issue occurs after doing the followiing: > - use Teiid Connection importer create source model > - create view model > - try data preview on view table > This issue is that your prompted with message: > "Required data source is not deployed to the server, do you want to do it?" > When a source model is created by Teiid Connection importer, that prompt should not occur, because the data source already exist. However, if it does exist, it should allow you to continue to try to execute preview. Right now its create data source or nothing. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3053) Issue with trying to perform Preview Data

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3053?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-3053: ----------------------------------- Fix Version/s: (was: 11.1) > Issue with trying to perform Preview Data > ----------------------------------------- > > Key: TEIIDDES-3053 > URL: https://issues.jboss.org/browse/TEIIDDES-3053 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Usability > Affects Versions: 11.0.1 > Reporter: Van Halbert > Assignee: Barry LaFond > Fix For: 11.0.2 > > > The issue occurs after doing the followiing: > - use Teiid Connection importer create source model > - create view model > - try data preview on view table > This issue is that your prompted with message: > "Required data source is not deployed to the server, do you want to do it?" > When a source model is created by Teiid Connection importer, that prompt should not occur, because the data source already exist. However, if it does exist, it should allow you to continue to try to execute preview. Right now its create data source or nothing. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2880) New preview not working with table that calls UDF function

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2880?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2880. ------------------------------------ Assignee: Barry LaFond Resolution: Done 11.0.x : https://github.com/Teiid-Designer/teiid-designer/commit/922a20e40e42cbbed... > New preview not working with table that calls UDF function > ----------------------------------------------------------- > > Key: TEIIDDES-2880 > URL: https://issues.jboss.org/browse/TEIIDDES-2880 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0.1 > Environment: MAC > Reporter: Matus Makovy > Assignee: Barry LaFond > Priority: Critical > Fix For: 11.1, 11.0.2 > > Attachments: view.xmi > > > I have a view model with UDF function defined as procedure and a table that uses this UDF procedure. Transformation SQL looks like this: > {code:SQL} > SELECT > udfConcatNull(hsqldbParts.PARTS.PART_NAME, hsqldbParts.PARTS.PART_WEIGHT) AS NAME_WEIGHT > FROM > hsqldbParts.PARTS > {code} > When I hit Preview Data on that table, the dynamic VDB that is generated looks like this: > {code:xml} > <?xml version="1.0" encoding="UTF-8" standalone="yes"?> > <vdb name="PREVIEW-fd6cadf2-4ae3-4d8f-9420-22f4882201e7" version="1"> > <description>Importer VDB</description> > <property name="UseConnectorMetadata" value="true" /> > <property name="deployment-name" value="PREVIEW-fd6cadf2-4ae3-4d8f-9420-22f4882201e7-vdb.xml" /> > <model name="view" type="VIRTUAL" visible="true"> > <metadata type="DDL"><![CDATA[ > CREATE VIEW tab ( > NAME_WEIGHT string > ) > AS > select udfConcatNull(hsqldbParts.PARTS.PART_NAME,hsqldbParts.PARTS.PART_WEIGHT) as NAME_WEIGHT from hsqldbParts.PARTS; > ]]></metadata> > </model> > <model name="hsqldbParts" type="PHYSICAL" visible="true"> > <source name="hsqldbParts" translator-name="oracle" connection-jndi-name="null" /> > <metadata type="DDL"><![CDATA[ > CREATE FOREIGN TABLE PARTS ( > PART_ID string(4) NOT NULL OPTIONS(NAMEINSOURCE '"PART_ID"', NATIVE_TYPE 'CHAR', FIXED_LENGTH 'TRUE'), > PART_NAME string(255) OPTIONS(NAMEINSOURCE '"PART_NAME"', NATIVE_TYPE 'VARCHAR2'), > PART_COLOR string(30) OPTIONS(NAMEINSOURCE '"PART_COLOR"', NATIVE_TYPE 'VARCHAR2'), > PART_WEIGHT string(255) OPTIONS(NAMEINSOURCE '"PART_WEIGHT"', NATIVE_TYPE 'VARCHAR2'), > CONSTRAINT PK_PARTS PRIMARY KEY(PART_ID) > ) OPTIONS(NAMEINSOURCE '"PARTSSUPPLIER"."PARTS"') > ]]></metadata> > </model> > </vdb> > {code} > If I see correctly, the UDF procedure is not in the dynamic VDB. > I know that the situation about dynamic VDBs and UDF functions in JAR files is complicated and I am not sure right now how this should be resolved. > But in my opinion the udf procedure should be in the dynamic VDB and there should be a warning that TD won't deploy the JAR to the server and if user wants to make a preview, the JAR should be deployed to the server manually. (If I remember correctly there is one when user is trying to generate dynamic VDB from static VDB with UDF function) > View model attached -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2880) New preview not working with table that calls UDF function

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2880?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2880: ----------------------------------- Fix Version/s: (was: 11.1) > New preview not working with table that calls UDF function > ----------------------------------------------------------- > > Key: TEIIDDES-2880 > URL: https://issues.jboss.org/browse/TEIIDDES-2880 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0.1 > Environment: MAC > Reporter: Matus Makovy > Assignee: Barry LaFond > Priority: Critical > Fix For: 11.0.2 > > Attachments: view.xmi > > > I have a view model with UDF function defined as procedure and a table that uses this UDF procedure. Transformation SQL looks like this: > {code:SQL} > SELECT > udfConcatNull(hsqldbParts.PARTS.PART_NAME, hsqldbParts.PARTS.PART_WEIGHT) AS NAME_WEIGHT > FROM > hsqldbParts.PARTS > {code} > When I hit Preview Data on that table, the dynamic VDB that is generated looks like this: > {code:xml} > <?xml version="1.0" encoding="UTF-8" standalone="yes"?> > <vdb name="PREVIEW-fd6cadf2-4ae3-4d8f-9420-22f4882201e7" version="1"> > <description>Importer VDB</description> > <property name="UseConnectorMetadata" value="true" /> > <property name="deployment-name" value="PREVIEW-fd6cadf2-4ae3-4d8f-9420-22f4882201e7-vdb.xml" /> > <model name="view" type="VIRTUAL" visible="true"> > <metadata type="DDL"><![CDATA[ > CREATE VIEW tab ( > NAME_WEIGHT string > ) > AS > select udfConcatNull(hsqldbParts.PARTS.PART_NAME,hsqldbParts.PARTS.PART_WEIGHT) as NAME_WEIGHT from hsqldbParts.PARTS; > ]]></metadata> > </model> > <model name="hsqldbParts" type="PHYSICAL" visible="true"> > <source name="hsqldbParts" translator-name="oracle" connection-jndi-name="null" /> > <metadata type="DDL"><![CDATA[ > CREATE FOREIGN TABLE PARTS ( > PART_ID string(4) NOT NULL OPTIONS(NAMEINSOURCE '"PART_ID"', NATIVE_TYPE 'CHAR', FIXED_LENGTH 'TRUE'), > PART_NAME string(255) OPTIONS(NAMEINSOURCE '"PART_NAME"', NATIVE_TYPE 'VARCHAR2'), > PART_COLOR string(30) OPTIONS(NAMEINSOURCE '"PART_COLOR"', NATIVE_TYPE 'VARCHAR2'), > PART_WEIGHT string(255) OPTIONS(NAMEINSOURCE '"PART_WEIGHT"', NATIVE_TYPE 'VARCHAR2'), > CONSTRAINT PK_PARTS PRIMARY KEY(PART_ID) > ) OPTIONS(NAMEINSOURCE '"PARTSSUPPLIER"."PARTS"') > ]]></metadata> > </model> > </vdb> > {code} > If I see correctly, the UDF procedure is not in the dynamic VDB. > I know that the situation about dynamic VDBs and UDF functions in JAR files is complicated and I am not sure right now how this should be resolved. > But in my opinion the udf procedure should be in the dynamic VDB and there should be a warning that TD won't deploy the JAR to the server and if user wants to make a preview, the JAR should be deployed to the server manually. (If I remember correctly there is one when user is trying to generate dynamic VDB from static VDB with UDF function) > View model attached -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3081) Change file importer logic to expose the file procedures

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3081?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-3081. ------------------------------------ Resolution: Done 11.0.x : https://github.com/Teiid-Designer/teiid-designer/commit/5b5d1e350b760b982... > Change file importer logic to expose the file procedures > -------------------------------------------------------- > > Key: TEIIDDES-3081 > URL: https://issues.jboss.org/browse/TEIIDDES-3081 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export > Affects Versions: 11.0.2 > Reporter: Van Halbert > Assignee: Barry LaFond > Fix For: 11.0.2 > > > Teiid added the feature [1] to the file translator, that also needs a change to teiid designer file importer to expose those file procedures. > [1] https://issues.jboss.org/browse/TEIID-4857 -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3025) Failed to determine if server supports teiid on Fuse on EAP 6.3

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3025?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-3025. ------------------------------------ Assignee: Barry LaFond Resolution: Done 11.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/922a20e40e42cbbed... > Failed to determine if server supports teiid on Fuse on EAP 6.3 > --------------------------------------------------------------- > > Key: TEIIDDES-3025 > URL: https://issues.jboss.org/browse/TEIIDDES-3025 > Project: Teiid Designer > Issue Type: Task > Affects Versions: 11.0.1 > Environment: Devstudio 10.2.0.GA > Teiid Designer 11.0.1.Final-v20170125-1702-B4135 > fuse-eap-6.3.0.R1 > Reporter: Andrej Podhradsky > Assignee: Barry LaFond > Priority: Critical > Fix For: 11.1, 11.0.2 > > Attachments: erroLog.txt > > > Failed to determine if server supports teiid on Fuse on EAP 6.3. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2959) Overriding translator isn't set automatically to source model in the VDB

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2959?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2959: ----------------------------------- Fix Version/s: 11.0.2 > Overriding translator isn't set automatically to source model in the VDB > ------------------------------------------------------------------------ > > Key: TEIIDDES-2959 > URL: https://issues.jboss.org/browse/TEIIDDES-2959 > Project: Teiid Designer > Issue Type: Feature Request > Affects Versions: 10.0.2 > Reporter: Matej Kralik > Fix For: 11.0.2 > > Attachments: screenshot1.png, screenshot2.png, screenshot3.png, screenshot4.png > > > I changed some parameters in the edit translator override window on the source model (screenshot1).I generated VDB, the overriding translator is created (screenshot2) but source model contains still default translator (screenshot3) and I have to manually set the overriding translator. I think that teiid designer should be automatically set override translator to the source model if was changed some properties in the edit translator override window.(screenshot4) -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3081) Change file importer logic to expose the file procedures

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3081?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-3081: ----------------------------------- Fix Version/s: 11.0.2 > Change file importer logic to expose the file procedures > -------------------------------------------------------- > > Key: TEIIDDES-3081 > URL: https://issues.jboss.org/browse/TEIIDDES-3081 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export > Affects Versions: 11.0.2 > Reporter: Van Halbert > Assignee: Barry LaFond > Fix For: 11.0.2 > > > Teiid added the feature [1] to the file translator, that also needs a change to teiid designer file importer to expose those file procedures. > [1] https://issues.jboss.org/browse/TEIID-4857 -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3081) Change file importer logic to expose the file procedures

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3081?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-3081: ---------------------------------------- The additional metadata being returned on the result set is: * lastModified - timestamp * created - timestamp * size - long > Change file importer logic to expose the file procedures > -------------------------------------------------------- > > Key: TEIIDDES-3081 > URL: https://issues.jboss.org/browse/TEIIDDES-3081 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export > Affects Versions: 11.0.2 > Reporter: Van Halbert > Assignee: Barry LaFond > > Teiid added the feature [1] to the file translator, that also needs a change to teiid designer file importer to expose those file procedures. > [1] https://issues.jboss.org/browse/TEIID-4857 -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 9 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 2017