June 2017 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-3086) Issue when importing Flat files

by Madou Coulibaly (JIRA)

Madou Coulibaly created TEIIDDES-3086: ----------------------------------------- Summary: Issue when importing Flat files Key: TEIIDDES-3086 URL: https://issues.jboss.org/browse/TEIIDDES-3086 Project: Teiid Designer Issue Type: Bug Components: Editors Affects Versions: 11.0.1 Environment: Teiid Version 8.12.10 Reporter: Madou Coulibaly Attachments: editor1.png, editor2.png, execution.png, wizard.png Several issues when importing CSV file using Teiid Designer # Double quotes are added on the first fields of the file. (wizard.png) # When we remove these double quotes from the Transformation Editor, we got a mapping error. (editor1.png) # We are not able anymore to add double quotes (because of SQL validation and Auto-Syntax), we have to click on "Reconcile Transformation SQL with Target Columns" button and bind the missing field. This will have an alias with double quotes and add "ROW DELIMITER ';'" information. (editor2.png) # After removing the "ROW DELIMITER ';'" information, we execute the query and we got another error "org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30181 HEADER entry missing for column name airlinePartner in file:xxxx" # We have to replace "HEADER" to "SKIP 1" to get a result (execution.png) but we still need to keep the alias with double quotes for the first field in the projection area. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3084) Support modeling of a JDG 7.1 data source using new translator/connector

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3084?page=com.atlassian.jira.plu... ] Van Halbert commented on TEIIDDES-3084: --------------------------------------- If the logic can check for when translator is "infinispan-hotrod", then make the importvdb.xml change > Support modeling of a JDG 7.1 data source using new translator/connector > ------------------------------------------------------------------------ > > Key: TEIIDDES-3084 > URL: https://issues.jboss.org/browse/TEIIDDES-3084 > Project: Teiid Designer > Issue Type: Enhancement > Components: Modeling > Reporter: Van Halbert > Assignee: Barry LaFond > Fix For: 11.0.2 > > > Add the ability to model a JDG 7.1 data source using new Teiid connector/translator -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3084) Support modeling of a JDG 7.1 data source using new translator/connector

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3084?page=com.atlassian.jira.plu... ] Barry LaFond reassigned TEIIDDES-3084: -------------------------------------- Assignee: Barry LaFond > Support modeling of a JDG 7.1 data source using new translator/connector > ------------------------------------------------------------------------ > > Key: TEIIDDES-3084 > URL: https://issues.jboss.org/browse/TEIIDDES-3084 > Project: Teiid Designer > Issue Type: Enhancement > Components: Modeling > Reporter: Van Halbert > Assignee: Barry LaFond > Fix For: 11.0.2 > > > Add the ability to model a JDG 7.1 data source using new Teiid connector/translator -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3084) Support modeling of a JDG 7.1 data source using new translator/connector

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3084?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-3084: ----------------------------------- Fix Version/s: 11.0.2 > Support modeling of a JDG 7.1 data source using new translator/connector > ------------------------------------------------------------------------ > > Key: TEIIDDES-3084 > URL: https://issues.jboss.org/browse/TEIIDDES-3084 > Project: Teiid Designer > Issue Type: Enhancement > Components: Modeling > Reporter: Van Halbert > Fix For: 11.0.2 > > > Add the ability to model a JDG 7.1 data source using new Teiid connector/translator -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3084) Support modeling of a JDG 7.1 data source using new translator/connector

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3084?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-3084: ---------------------------------------- K.. so when we build the dynamic VDB for the import we need to check the JDG-related property values and inject NATIVE property (if applicable) since it's not an importer property supplied by the data source template. > Support modeling of a JDG 7.1 data source using new translator/connector > ------------------------------------------------------------------------ > > Key: TEIIDDES-3084 > URL: https://issues.jboss.org/browse/TEIIDDES-3084 > Project: Teiid Designer > Issue Type: Enhancement > Components: Modeling > Reporter: Van Halbert > Fix For: 11.0.2 > > > Add the ability to model a JDG 7.1 data source using new Teiid connector/translator -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3044) Add new Model Editor tab

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3044?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-3044: ----------------------------------- Attachment: new-designer-perspective.png > Add new Model Editor tab > ------------------------ > > Key: TEIIDDES-3044 > URL: https://issues.jboss.org/browse/TEIIDDES-3044 > Project: Teiid Designer > Issue Type: Feature Request > Components: Editors, Modeling > Affects Versions: 11.1 > Reporter: Barry LaFond > Priority: Critical > Fix For: 11.2 > > Attachments: Designer 11.1 New Features.pdf, create-data-service-action.png, create-data-service-dialog.png, new-designer-perspective.png > > > Teiid Designer is an Eclipse application. We've gotten lots of feedback that the workflow is based on a developer paradigm and not necessarily a data-source/data-service paradigm. > The Model Explorer/Tree view + Properties View + Description View paired up with the Diagram and Table Editor pages do not provide a coherent UI for editing models. Users are required to select an object in the tree or diagram in order to find out what actions are available for that object, whether a Model or a model child (table, view, column, etc.) > One solution is to create a Model Editor page/tab which provides a more model-centric approach to editing a model and providing such actions. > The attached screen cap shows an initial approach which displays a tree view of the model contents and associated Actions, Properties and Description editor tabs which allow managing the majority of the workflow actions and steps. > Prototype KIT is available at: http://download.jboss.org/teiid/designer/11.0/teiid-designer-neon-prototy... -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3044) Add new Model Editor tab

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3044?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-3044: ----------------------------------- Attachment: (was: new-model-editor-and-data-sources-view.png) > Add new Model Editor tab > ------------------------ > > Key: TEIIDDES-3044 > URL: https://issues.jboss.org/browse/TEIIDDES-3044 > Project: Teiid Designer > Issue Type: Feature Request > Components: Editors, Modeling > Affects Versions: 11.1 > Reporter: Barry LaFond > Priority: Critical > Fix For: 11.2 > > Attachments: Designer 11.1 New Features.pdf, create-data-service-action.png, create-data-service-dialog.png > > > Teiid Designer is an Eclipse application. We've gotten lots of feedback that the workflow is based on a developer paradigm and not necessarily a data-source/data-service paradigm. > The Model Explorer/Tree view + Properties View + Description View paired up with the Diagram and Table Editor pages do not provide a coherent UI for editing models. Users are required to select an object in the tree or diagram in order to find out what actions are available for that object, whether a Model or a model child (table, view, column, etc.) > One solution is to create a Model Editor page/tab which provides a more model-centric approach to editing a model and providing such actions. > The attached screen cap shows an initial approach which displays a tree view of the model contents and associated Actions, Properties and Description editor tabs which allow managing the majority of the workflow actions and steps. > Prototype KIT is available at: http://download.jboss.org/teiid/designer/11.0/teiid-designer-neon-prototy... -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3084) Support modeling of a JDG 7.1 data source using new translator/connector

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3084?page=com.atlassian.jira.plu... ] Ramesh Reddy commented on TEIIDDES-3084: ---------------------------------------- As message indicating one of those importer properties are required for the metadata import. I do not see that in the above VDB file. > Support modeling of a JDG 7.1 data source using new translator/connector > ------------------------------------------------------------------------ > > Key: TEIIDDES-3084 > URL: https://issues.jboss.org/browse/TEIIDDES-3084 > Project: Teiid Designer > Issue Type: Enhancement > Components: Modeling > Reporter: Van Halbert > > Add the ability to model a JDG 7.1 data source using new Teiid connector/translator -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3084) Support modeling of a JDG 7.1 data source using new translator/connector

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3084?page=com.atlassian.jira.plu... ] Van Halbert edited comment on TEIIDDES-3084 at 6/6/17 9:48 PM: --------------------------------------------------------------- Going thru the Teiid Connection importer, the Advanced tab shows: {code} <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <vdb name="importVDB" version="1"> <description>Importer VDB</description> <property name="UseConnectorMetadata" value="true" /> <property name="deployment-name" value="importVDB-vdb.xml" /> <model name="importVDBSrcModel" type="PHYSICAL" visible="true"> <source name="importVDBSrcModel" translator-name="infinispan-hotrod" connection-jndi-name="java:/infinispanDS" /> </model> </vdb> {code} The server log shows this message: 21:42:46,276 WARN [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50036 VDB importVDB.1 model "importVDBSrcModel" metadata failed to load. Reason:TEIID25011 There are three ways to import the metadata, 1) Define "importer.ProtoFilePath" to read from a local .proto file. 2) Define "importer.ProtobufName" property to define .proto file name, when reading the .proto file from the Infinispan Cache directly. 3) Define the schema using DDL, then use also the "NATIVE" metadata repository to convert DDL into .proto file was (Author: van.halbert): The server log shows this message: 21:42:46,276 WARN [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50036 VDB importVDB.1 model "importVDBSrcModel" metadata failed to load. Reason:TEIID25011 There are three ways to import the metadata, 1) Define "importer.ProtoFilePath" to read from a local .proto file. 2) Define "importer.ProtobufName" property to define .proto file name, when reading the .proto file from the Infinispan Cache directly. 3) Define the schema using DDL, then use also the "NATIVE" metadata repository to convert DDL into .proto file > Support modeling of a JDG 7.1 data source using new translator/connector > ------------------------------------------------------------------------ > > Key: TEIIDDES-3084 > URL: https://issues.jboss.org/browse/TEIIDDES-3084 > Project: Teiid Designer > Issue Type: Enhancement > Components: Modeling > Reporter: Van Halbert > > Add the ability to model a JDG 7.1 data source using new Teiid connector/translator -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3084) Support modeling of a JDG 7.1 data source using new translator/connector

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3084?page=com.atlassian.jira.plu... ] Van Halbert commented on TEIIDDES-3084: --------------------------------------- The server log shows this message: 21:42:46,276 WARN [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50036 VDB importVDB.1 model "importVDBSrcModel" metadata failed to load. Reason:TEIID25011 There are three ways to import the metadata, 1) Define "importer.ProtoFilePath" to read from a local .proto file. 2) Define "importer.ProtobufName" property to define .proto file name, when reading the .proto file from the Infinispan Cache directly. 3) Define the schema using DDL, then use also the "NATIVE" metadata repository to convert DDL into .proto file > Support modeling of a JDG 7.1 data source using new translator/connector > ------------------------------------------------------------------------ > > Key: TEIIDDES-3084 > URL: https://issues.jboss.org/browse/TEIIDDES-3084 > Project: Teiid Designer > Issue Type: Enhancement > Components: Modeling > Reporter: Van Halbert > > Add the ability to model a JDG 7.1 data source using new Teiid connector/translator -- This message was sent by Atlassian JIRA (v7.2.3#72005)

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