August 2014 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2287) Error Generating REST Transformation with Teiid Reserved Word

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2287?page=com.atlassian.jira.plu... ] Ted Jones updated TEIIDDES-2287: -------------------------------- Description: The following procedure transformation generated for a REST source is invalid due to using the OUTPUT Teiid reserved word as a column. BEGIN DECLARE STRING VARIABLES.qp = QUERYSTRING('http://www.google.com/complete/search', ViewModel.google."output" AS output, ViewModel.google.q AS q); SELECT A.data AS data FROM (EXEC SourceModel.invokeHttp('GET', null, VARIABLES.qp, 'TRUE')) AS f, XMLTABLE('/toplevel/CompleteSuggestion' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS data string PATH '/suggestion/@data') AS A; END The word output should be in double quotes: BEGIN DECLARE STRING VARIABLES.qp = QUERYSTRING('http://www.google.com/complete/search', ViewModel.google."output" AS "output", ViewModel.google.q AS q); SELECT A.data AS data FROM (EXEC SourceModel.invokeHttp('GET', null, VARIABLES.qp, 'TRUE')) AS f, XMLTABLE('/toplevel/CompleteSuggestion' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS data string PATH '/suggestion/@data') AS A; END was: The following procedure transformation generated for a REST source is invalid due to using the OUTPUT Teiid reserved word as a column. BEGIN DECLARE STRING VARIABLES.qp = QUERYSTRING('http://www.google.com/complete/search', ViewModel.google."output" AS output, ViewModel.google.q AS q); SELECT A.data AS data FROM (EXEC SourceModel.invokeHttp('GET', null, VARIABLES.qp, 'TRUE')) AS f, XMLTABLE('/toplevel/CompleteSuggestion' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS data string PATH '/suggestion/@data') AS A; END The word output should be in double-quotes: BEGIN DECLARE STRING VARIABLES.qp = QUERYSTRING('http://www.google.com/complete/search', ViewModel.google."output" AS "output", ViewModel.google.q AS q); SELECT A.data AS data FROM (EXEC SourceModel.invokeHttp('GET', null, VARIABLES.qp, 'TRUE')) AS f, XMLTABLE('/toplevel/CompleteSuggestion' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS data string PATH '/suggestion/@data') AS A; END > Error Generating REST Transformation with Teiid Reserved Word > ------------------------------------------------------------- > > Key: TEIIDDES-2287 > URL: https://issues.jboss.org/browse/TEIIDDES-2287 > Project: Teiid Designer > Issue Type: Feature Request > Security Level: Public(Everyone can see) > Components: Transformations > Affects Versions: 8.6 > Reporter: Ted Jones > Assignee: Ted Jones > Fix For: 8.6, 8.5.1 > > > The following procedure transformation generated for a REST source is invalid due to using the OUTPUT Teiid reserved word as a column. > BEGIN > DECLARE STRING VARIABLES.qp = QUERYSTRING('http://www.google.com/complete/search', ViewModel.google."output" AS output, ViewModel.google.q AS q); > SELECT A.data AS data FROM (EXEC SourceModel.invokeHttp('GET', null, VARIABLES.qp, 'TRUE')) AS f, XMLTABLE('/toplevel/CompleteSuggestion' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS data string PATH '/suggestion/@data') AS A; > END > The word output should be in double quotes: BEGIN > DECLARE STRING VARIABLES.qp = QUERYSTRING('http://www.google.com/complete/search', ViewModel.google."output" AS "output", ViewModel.google.q AS q); > SELECT A.data AS data FROM (EXEC SourceModel.invokeHttp('GET', null, VARIABLES.qp, 'TRUE')) AS f, XMLTABLE('/toplevel/CompleteSuggestion' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS data string PATH '/suggestion/@data') AS A; > END -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2287) Error Generating REST Transformation with Teiid Reserved Word

by Ted Jones (JIRA)

Ted Jones created TEIIDDES-2287: ----------------------------------- Summary: Error Generating REST Transformation with Teiid Reserved Word Key: TEIIDDES-2287 URL: https://issues.jboss.org/browse/TEIIDDES-2287 Project: Teiid Designer Issue Type: Feature Request Security Level: Public (Everyone can see) Components: Transformations Affects Versions: 8.6 Reporter: Ted Jones Assignee: Ted Jones Fix For: 8.6, 8.5.1 The following procedure transformation generated for a REST source is invalid due to using the OUTPUT Teiid reserved word as a column. BEGIN DECLARE STRING VARIABLES.qp = QUERYSTRING('http://www.google.com/complete/search', ViewModel.google."output" AS output, ViewModel.google.q AS q); SELECT A.data AS data FROM (EXEC SourceModel.invokeHttp('GET', null, VARIABLES.qp, 'TRUE')) AS f, XMLTABLE('/toplevel/CompleteSuggestion' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS data string PATH '/suggestion/@data') AS A; END The word output should be in double-quotes: BEGIN DECLARE STRING VARIABLES.qp = QUERYSTRING('http://www.google.com/complete/search', ViewModel.google."output" AS "output", ViewModel.google.q AS q); SELECT A.data AS data FROM (EXEC SourceModel.invokeHttp('GET', null, VARIABLES.qp, 'TRUE')) AS f, XMLTABLE('/toplevel/CompleteSuggestion' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS data string PATH '/suggestion/@data') AS A; END -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2286) Creating procedure and assigning results works different depending on steps taken

by Van Halbert (JIRA)

Van Halbert created TEIIDDES-2286: ------------------------------------- Summary: Creating procedure and assigning results works different depending on steps taken Key: TEIIDDES-2286 URL: https://issues.jboss.org/browse/TEIIDDES-2286 Project: Teiid Designer Issue Type: Bug Security Level: Public (Everyone can see) Components: Dialogs Affects Versions: 8.5.1 Reporter: Van Halbert Trying to create a relational view procedure. And in the wizard, if I do NOT enter a result set, and click OK, and then proceed to right click on procedure to add result set (but add no column), the result set ends up taking on the datatype that the procedure returns. However, if in the wizard, I add the name of the result set (same name used if right mouse clicking above) and do not add a column, it doesn't work the same. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2285) Unable to scroll wizard window when creating web service war

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2285?page=com.atlassian.jira.plu... ] Van Halbert commented on TEIIDDES-2285: --------------------------------------- Part of the problem here is we were working on remote workstations, where we limited on the size of screen. > Unable to scroll wizard window when creating web service war > ------------------------------------------------------------ > > Key: TEIIDDES-2285 > URL: https://issues.jboss.org/browse/TEIIDDES-2285 > Project: Teiid Designer > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Dialogs > Affects Versions: 8.5.1 > Reporter: Van Halbert > Assignee: Barry LaFond > Attachments: unabletoscroll.tiff > > > When trying to create the web service war file, the dialog window (see attachment) did not allow me to scroll down in order to complete the details. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2285) Unable to scroll wizard window when creating web service war

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2285?page=com.atlassian.jira.plu... ] Van Halbert updated TEIIDDES-2285: ---------------------------------- Attachment: unabletoscroll.tiff > Unable to scroll wizard window when creating web service war > ------------------------------------------------------------ > > Key: TEIIDDES-2285 > URL: https://issues.jboss.org/browse/TEIIDDES-2285 > Project: Teiid Designer > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Dialogs > Affects Versions: 8.5.1 > Reporter: Van Halbert > Assignee: Barry LaFond > Attachments: unabletoscroll.tiff > > > When trying to create the web service war file, the dialog window (see attachment) did not allow me to scroll down in order to complete the details. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2285) Unable to scroll wizard window when creating web service war

by Van Halbert (JIRA)

Van Halbert created TEIIDDES-2285: ------------------------------------- Summary: Unable to scroll wizard window when creating web service war Key: TEIIDDES-2285 URL: https://issues.jboss.org/browse/TEIIDDES-2285 Project: Teiid Designer Issue Type: Bug Security Level: Public (Everyone can see) Components: Dialogs Affects Versions: 8.5.1 Reporter: Van Halbert Assignee: Barry LaFond Attachments: unabletoscroll.tiff When trying to create the web service war file, the dialog window (see attachment) did not allow me to scroll down in order to complete the details. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2284) Preview Error for REST Web Service Source

by Ted Jones (JIRA)

Ted Jones created TEIIDDES-2284: ----------------------------------- Summary: Preview Error for REST Web Service Source Key: TEIIDDES-2284 URL: https://issues.jboss.org/browse/TEIIDDES-2284 Project: Teiid Designer Issue Type: Feature Request Security Level: Public (Everyone can see) Components: Data Preview Affects Versions: 8.6 Reporter: Ted Jones Assignee: Ted Jones Priority: Blocker Fix For: 8.6 When previewing a procedure that invokes a REST web service source, I get the following error: select * from ( exec "ViewModel"."google"('toolbar','reciever') ) AS X_X org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30152 Failed to evaluate XQuery expression; Please check the query and correct errors in syntax or usage. However, if I add the view procedure to a VDB and deploy, I am able to execute without error. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2282) Usability: need an auto-save option

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2282?page=com.atlassian.jira.plu... ] Van Halbert commented on TEIIDDES-2282: --------------------------------------- Usability: the ability to auto-save. Suggested options: - use a time preference - option to auto save on change of focus (i.e, changing models) > Usability: need an auto-save option > ------------------------------------ > > Key: TEIIDDES-2282 > URL: https://issues.jboss.org/browse/TEIIDDES-2282 > Project: Teiid Designer > Issue Type: Enhancement > Security Level: Public(Everyone can see) > Components: Editors > Affects Versions: 8.5.1 > Reporter: Van Halbert > Assignee: Barry LaFond > Priority: Minor > > Usability: need an auto-save preference so that it can be set to auto save based on preference. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2282) Usability: need an auto-save option

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2282?page=com.atlassian.jira.plu... ] Van Halbert updated TEIIDDES-2282: ---------------------------------- Summary: Usability: need an auto-save option (was: Usability: need an auto-save option to save every so often) > Usability: need an auto-save option > ------------------------------------ > > Key: TEIIDDES-2282 > URL: https://issues.jboss.org/browse/TEIIDDES-2282 > Project: Teiid Designer > Issue Type: Enhancement > Security Level: Public(Everyone can see) > Components: Editors > Affects Versions: 8.5.1 > Reporter: Van Halbert > Assignee: Barry LaFond > Priority: Minor > > Usability: need an auto-save preference so that it can be set to auto save based on preference. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2283) Usability: ability to use expression builder in/from the reconciler

by Van Halbert (JIRA)

Van Halbert created TEIIDDES-2283: ------------------------------------- Summary: Usability: ability to use expression builder in/from the reconciler Key: TEIIDDES-2283 URL: https://issues.jboss.org/browse/TEIIDDES-2283 Project: Teiid Designer Issue Type: Enhancement Security Level: Public (Everyone can see) Components: Transformations Affects Versions: 8.5.1 Reporter: Van Halbert Usability: the ability to use the expression building in the reconciler -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 8 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 August 2014