September 2014 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2354) Import -> Web Service Source >> Source and View Model(REST) is missing one quote in SQL

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2354?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2354. ------------------------------------ Resolution: Done https://github.com/Teiid-Designer/teiid-designer/commit/41fd050225645d848... > Import -> Web Service Source >> Source and View Model(REST) is missing one quote in SQL > --------------------------------------------------------------------------------------- > > Key: TEIIDDES-2354 > URL: https://issues.jboss.org/browse/TEIIDDES-2354 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Patch Release > Affects Versions: 8.6.1 > Environment: Windows 7 > Reporter: Matus Makovy > Assignee: Barry LaFond > Fix For: 8.7, 8.6.1 > > Attachments: screen1.png, screen2.png, screen3.png > > > When I am importing from from REST WS, using Import -> Web Service Source >> Source and View Model(REST) it creates non-functional SQL querry. It is missing one quote. > Screenshots attached -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2301) XML File importer - issues with SQL generation

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2301?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2301. ------------------------------------ Resolution: Done https://github.com/Teiid-Designer/teiid-designer/commit/d8f5ad6d60777863d... Merged into 8.6.x luna and kepler branches. > XML File importer - issues with SQL generation > ---------------------------------------------- > > Key: TEIIDDES-2301 > URL: https://issues.jboss.org/browse/TEIIDDES-2301 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Patch Release > Affects Versions: 8.5 > Reporter: Mark Drilling > Assignee: Barry LaFond > Fix For: 8.7, 8.6.1 > > Attachments: xmlImportSQLGeneration.png > > > In the course of working TEIIDDES-2276, I noticed that the SQL generation in the XML file import wizard is not working correctly. > Use the xml file that is attached to 2276 - notice the generated SQL displayed in the wizard is invalid. Attaching a screencap. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2301) XML File importer - issues with SQL generation

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2301?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2301: ----------------------------------- Component/s: Patch Release > XML File importer - issues with SQL generation > ---------------------------------------------- > > Key: TEIIDDES-2301 > URL: https://issues.jboss.org/browse/TEIIDDES-2301 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Patch Release > Affects Versions: 8.5 > Reporter: Mark Drilling > Assignee: Barry LaFond > Fix For: 8.7, 8.6.1 > > Attachments: xmlImportSQLGeneration.png > > > In the course of working TEIIDDES-2276, I noticed that the SQL generation in the XML file import wizard is not working correctly. > Use the xml file that is attached to 2276 - notice the generated SQL displayed in the wizard is invalid. Attaching a screencap. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2356) Import DDL file from workspace location does not work. File not found

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2356?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2356. ------------------------------------ Resolution: Done converted selected IFile to Java FILE before setting file path text field https://github.com/Teiid-Designer/teiid-designer/commit/9b3691eaf66931369... > Import DDL file from workspace location does not work. File not found > --------------------------------------------------------------------- > > Key: TEIIDDES-2356 > URL: https://issues.jboss.org/browse/TEIIDDES-2356 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Patch Release > Affects Versions: 8.6 > Reporter: Barry LaFond > Assignee: Barry LaFond > Fix For: 8.7, 8.6.1 > > > Trying to import a DDL file from a workspace location cannot find the designated file. > The workspace relative path is shown and stored in the DdlImporter and combo-box text, however, the importer expects an existing Java File location. > Need to convert the selected IResource/IFile to a file and use that path instead: > >>> final File realFile = choice.getLocation().toFile(); -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2356) Import DDL file from workspace location does not work. File not found

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2356?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2356: ----------------------------------- Component/s: Patch Release > Import DDL file from workspace location does not work. File not found > --------------------------------------------------------------------- > > Key: TEIIDDES-2356 > URL: https://issues.jboss.org/browse/TEIIDDES-2356 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Patch Release > Affects Versions: 8.6 > Reporter: Barry LaFond > Assignee: Barry LaFond > Fix For: 8.7, 8.6.1 > > > Trying to import a DDL file from a workspace location cannot find the designated file. > The workspace relative path is shown and stored in the DdlImporter and combo-box text, however, the importer expects an existing Java File location. > Need to convert the selected IResource/IFile to a file and use that path instead: > >>> final File realFile = choice.getLocation().toFile(); -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2347) Undeploying a Dynamic VDB results in TeiidAdminProcessing exception

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2347?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2347: ----------------------------------- Component/s: Patch Release > Undeploying a Dynamic VDB results in TeiidAdminProcessing exception > ------------------------------------------------------------------- > > Key: TEIIDDES-2347 > URL: https://issues.jboss.org/browse/TEIIDDES-2347 > Project: Teiid Designer > Issue Type: Bug > Components: Patch Release, Teiid Integration, VDB & Execution > Affects Versions: 8.6 > Reporter: Barry LaFond > Assignee: Barry LaFond > Fix For: 8.7, 8.6.1 > > > 1) Deploy a Dynamic VDB on a server > 2) Select in Designer Servier view and select "Undeploy VDB" > 3) Get following uncaught exception: > {code} > !ENTRY org.teiid.designer.dqp.ui 2 0 2014-09-22 15:53:57.594 > !MESSAGE Error undeploying VDB: Portfolio > !STACK 0 > org.teiid.adminapi.AdminProcessingException: {"JBAS014653: Composite operation failed and was rolled back. Steps that failed:" => {"Operation step-1" => "JBAS014807: Management resource '[(\"deployment\" => \"Portfolio.vdb\")]' not found"}} > at org.teiid.runtime.client.admin.v8.Admin8Factory$AdminImpl.execute(Admin8Factory.java:548) > at org.teiid.runtime.client.admin.v8.Admin8Factory$AdminImpl.undeploy(Admin8Factory.java:782) > at org.teiid.runtime.client.admin.v8.Admin8Spec.undeploy(Admin8Spec.java:73) > at org.teiid.runtime.client.admin.ExecutionAdmin.undeployVdb(ExecutionAdmin.java:773) > {code} > We're only catching "OperationFormatException" format exception. maybe we should catch this type too and display to user? -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2347) Undeploying a Dynamic VDB results in TeiidAdminProcessing exception

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2347?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2347. ------------------------------------ Assignee: Barry LaFond (was: Paul Richardson) Resolution: Done changed undeploy to use deployment-name property value instead of vdbName Done https://github.com/Teiid-Designer/teiid-designer/commit/5633d7de5a3dc55d6... > Undeploying a Dynamic VDB results in TeiidAdminProcessing exception > ------------------------------------------------------------------- > > Key: TEIIDDES-2347 > URL: https://issues.jboss.org/browse/TEIIDDES-2347 > Project: Teiid Designer > Issue Type: Bug > Components: Teiid Integration, VDB & Execution > Affects Versions: 8.6 > Reporter: Barry LaFond > Assignee: Barry LaFond > Fix For: 8.7, 8.6.1 > > > 1) Deploy a Dynamic VDB on a server > 2) Select in Designer Servier view and select "Undeploy VDB" > 3) Get following uncaught exception: > {code} > !ENTRY org.teiid.designer.dqp.ui 2 0 2014-09-22 15:53:57.594 > !MESSAGE Error undeploying VDB: Portfolio > !STACK 0 > org.teiid.adminapi.AdminProcessingException: {"JBAS014653: Composite operation failed and was rolled back. Steps that failed:" => {"Operation step-1" => "JBAS014807: Management resource '[(\"deployment\" => \"Portfolio.vdb\")]' not found"}} > at org.teiid.runtime.client.admin.v8.Admin8Factory$AdminImpl.execute(Admin8Factory.java:548) > at org.teiid.runtime.client.admin.v8.Admin8Factory$AdminImpl.undeploy(Admin8Factory.java:782) > at org.teiid.runtime.client.admin.v8.Admin8Spec.undeploy(Admin8Spec.java:73) > at org.teiid.runtime.client.admin.ExecutionAdmin.undeployVdb(ExecutionAdmin.java:773) > {code} > We're only catching "OperationFormatException" format exception. maybe we should catch this type too and display to user? -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2210) Using Teiid Connection importer doesn't completely import the DDL

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2210?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2210: ---------------------------------------- Added processing of OPTIONS for FKs: https://github.com/Teiid-Designer/teiid-designer/commit/87aa824885227808f... > Using Teiid Connection importer doesn't completely import the DDL > ----------------------------------------------------------------- > > Key: TEIIDDES-2210 > URL: https://issues.jboss.org/browse/TEIIDDES-2210 > Project: Teiid Designer > Issue Type: Bug > Components: Teiid Integration > Affects Versions: 8.5 > Reporter: Van Halbert > Assignee: Barry LaFond > Fix For: 8.6.1 > > > When using Teiid connection importer, there's a couple of issues importing the ddl: > 1. this property isn't being loaded: "teiid_infinispan:entity_class" 'org.jboss.as.quickstarts.datagrid.hotrod.query.domain.Person' > 2. NIS for Foreign key isn't being set: CONSTRAINT FK_PERSON FOREIGN KEY(Id) REFERENCES Person (Id) OPTIONS (NAMEINSOURCE 'phones') > Example DDL: > CREATE FOREIGN TABLE Person ( > PersonObject object OPTIONS (NAMEINSOURCE 'this', SEARCHABLE 'Unsearchable', NATIVE_TYPE 'java.lang.Object'), > name string OPTIONS (SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'), > id integer OPTIONS (SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.Integer'), > email string OPTIONS (SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'), > CONSTRAINT PK_ID PRIMARY KEY(id) > ) OPTIONS (NAMEINSOURCE 'PersonsCache', "teiid_infinispan:entity_class" 'org.jboss.as.quickstarts.datagrid.hotrod.query.domain.Person'); > CREATE FOREIGN TABLE PhoneNumber ( > number string OPTIONS (NAMEINSOURCE 'phone.number', SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'), > type string OPTIONS (NAMEINSOURCE 'phone.type', SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'), > Id integer NOT NULL OPTIONS (SELECTABLE FALSE, SEARCHABLE 'Unsearchable', NATIVE_TYPE 'int'), > CONSTRAINT FK_PERSON FOREIGN KEY(Id) REFERENCES Person (Id) OPTIONS (NAMEINSOURCE 'phones') > ) OPTIONS (NAMEINSOURCE 'PersonsCache', "teiid_infinispan:entity_class" 'org.jboss.as.quickstarts.datagrid.hotrod.query.domain.PhoneNumber'); -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2356) Import DDL file from workspace location does not work. File not found

by Barry LaFond (JIRA)

Barry LaFond created TEIIDDES-2356: -------------------------------------- Summary: Import DDL file from workspace location does not work. File not found Key: TEIIDDES-2356 URL: https://issues.jboss.org/browse/TEIIDDES-2356 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 8.6 Reporter: Barry LaFond Assignee: Barry LaFond Fix For: 8.7, 8.6.1 Trying to import a DDL file from a workspace location cannot find the designated file. The workspace relative path is shown and stored in the DdlImporter and combo-box text, however, the importer expects an existing Java File location. Need to convert the selected IResource/IFile to a file and use that path instead: >>> final File realFile = choice.getLocation().toFile(); -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2301) XML File importer - issues with SQL generation

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2301?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2301: ---------------------------------------- Note: Work with Ted to develop a better approach > XML File importer - issues with SQL generation > ---------------------------------------------- > > Key: TEIIDDES-2301 > URL: https://issues.jboss.org/browse/TEIIDDES-2301 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 8.5 > Reporter: Mark Drilling > Assignee: Barry LaFond > Fix For: 8.7, 8.6.1 > > Attachments: xmlImportSQLGeneration.png > > > In the course of working TEIIDDES-2276, I noticed that the SQL generation in the XML file import wizard is not working correctly. > Use the xml file that is attached to 2276 - notice the generated SQL displayed in the wizard is invalid. Attaching a screencap. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 6 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 September 2014