[JBoss JIRA] (TEIIDDES-2287) Error Generating REST Transformation with Teiid Reserved Word
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2287?page=com.atlassian.jira.plu... ]
Matus Makovy closed TEIIDDES-2287.
----------------------------------
verified TD 8.6.1.CR1
> Error Generating REST Transformation with Teiid Reserved Word
> -------------------------------------------------------------
>
> Key: TEIIDDES-2287
> URL: https://issues.jboss.org/browse/TEIIDDES-2287
> Project: Teiid Designer
> Issue Type: Bug
> Components: Transformations
> Affects Versions: 8.6
> Reporter: Ted Jones
> Assignee: Ted Jones
> Fix For: 9.0, 8.6.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.3.11#6341)
11 years, 1 month
[JBoss JIRA] (TEIIDDES-2301) XML File importer - issues with SQL generation
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2301?page=com.atlassian.jira.plu... ]
Matus Makovy closed TEIIDDES-2301.
----------------------------------
verified TD 8.6.1.CR1
> 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: 9.0, 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.11#6341)
11 years, 1 month
[JBoss JIRA] (TEIIDDES-2357) TeiidClientException when trying to query VDB that was created for REST consuption
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2357?page=com.atlassian.jira.plu... ]
Matus Makovy closed TEIIDDES-2357.
----------------------------------
verified TD 8.6.1.CR1
> TeiidClientException when trying to query VDB that was created for REST consuption
> ----------------------------------------------------------------------------------
>
> Key: TEIIDDES-2357
> URL: https://issues.jboss.org/browse/TEIIDDES-2357
> Project: Teiid Designer
> Issue Type: Bug
> Components: Web Services Support
> Affects Versions: 8.6.1
> Reporter: Van Halbert
> Assignee: Ted Jones
> Fix For: 9.0, 8.6.1
>
>
> I am trying to run my new test script[1] for Teiid Designer that is testing REST (XML/JSON) webservice consuption. And when I try to query the VDB using "exec getProgrammes()" procedure, that TD created for me in View model. I am getting TeiidClientException. Server log attached. I believe it is a server issue not a Tooling issue...
> Exception from TD:
> org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 RestXMLSource: javax/ws/rs/client/ClientException
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 1 month
[JBoss JIRA] (TEIIDDES-2368) Property value issues using New Procedure wizard
by Andrej Šmigala (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2368?page=com.atlassian.jira.plu... ]
Andrej Šmigala closed TEIIDDES-2368.
------------------------------------
Verified in 9.0.1 and 8.6.1
> Property value issues using New Procedure wizard
> ------------------------------------------------
>
> Key: TEIIDDES-2368
> URL: https://issues.jboss.org/browse/TEIIDDES-2368
> Project: Teiid Designer
> Issue Type: Bug
> Components: Modeling
> Affects Versions: 8.6
> Reporter: Tom Johnston
> Assignee: Barry LaFond
> Fix For: 9.0, 8.6.1
>
>
> * Description is not getting saved to the model (EmfModelObjectExtensionAssistant is not checking for existing description before removing annotation for removed extensions)
> * Update Count property is not getting set on the procedure (missing a combo box listener)
> * RelationalModelFactory has a few redundant calls to add new view, procedure and index to the model contents. These are already called in the createXXXX() methods
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 1 month
[JBoss JIRA] (TEIIDDES-2449) Add a uttility in Teiid Client plugin to construct a VDB Manifest (xml)
by Barry LaFond (JIRA)
Barry LaFond created TEIIDDES-2449:
--------------------------------------
Summary: Add a uttility in Teiid Client plugin to construct a VDB Manifest (xml)
Key: TEIIDDES-2449
URL: https://issues.jboss.org/browse/TEIIDDES-2449
Project: Teiid Designer
Issue Type: Task
Components: Teiid Integration, VDB & Execution
Affects Versions: 9.1
Reporter: Barry LaFond
Assignee: Barry LaFond
Fix For: 9.1
In order to import full deployed VDBs on the server we'll need a mechanism to get Data Roles/Policies, Translator Overrides, etc. that are defined in a deployed VDB manifest. Unfortunately, Designer's ITeiidVdb is designed to be simple and the info is only available via Teiid's VDB interface, which isn't part of the Admin API.
Suggest creating a utility in the teiid.client plugin that can take a VDB and construct the basic Manifest, or -vdb.xml string down to the *<model/>* elements.
Then, by adding a *getManifest()* method to our ITeiidVdb interface, Designer can create a full DDL-based version of a deployed VDB using that method + the Teiid Server's getSchema() method.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 1 month
[JBoss JIRA] (TEIIDDES-2448) Failed to import SalesForce Metadata
by Ramesh Reddy (JIRA)
Ramesh Reddy created TEIIDDES-2448:
--------------------------------------
Summary: Failed to import SalesForce Metadata
Key: TEIIDDES-2448
URL: https://issues.jboss.org/browse/TEIIDDES-2448
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Reporter: Ramesh Reddy
Assignee: Barry LaFond
Priority: Critical
Attachments: sfddl (1).ddl
Using the Teiid Connection import, the attached DDL has been retrived from salesforce instance. However Designer fails to import it, and gives NO clue as to what is wrong.
1) The DDL should be successfully imported
2) When there is something wrong that Designer does not understand it needs to give a meaningful error, as per the location of the file and context
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 1 month