[JBoss JIRA] (TEIIDDES-2357) TeiidClientException when trying to query VDB that was created for REST consuption
by Ted Jones (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2357?page=com.atlassian.jira.plu... ]
Ted Jones resolved TEIIDDES-2357.
---------------------------------
Resolution: Done
> 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: 8.6.1, 9.0
>
>
> 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.1#6329)
9 years, 6 months
[JBoss JIRA] (TEIIDDES-2284) Preview Error for REST Web Service Source
by Ted Jones (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2284?page=com.atlassian.jira.plu... ]
Ted Jones commented on TEIIDDES-2284:
-------------------------------------
The correct transformation is: BEGIN
DECLARE STRING VARIABLES.qp = QUERYSTRING('http://www.google.com/complete/search', ViewModel_1.test1.q AS q, ViewModel_1.test1."output" AS "output");
SELECT A.data AS data FROM (EXEC SourceModel_1.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
Preview works when a CP is assigned to the source model.
> Preview Error for REST Web Service Source
> -----------------------------------------
>
> Key: TEIIDDES-2284
> URL: https://issues.jboss.org/browse/TEIIDDES-2284
> Project: Teiid Designer
> Issue Type: Bug
> Components: Data Preview
> Affects Versions: 8.6
> Reporter: Ted Jones
> Assignee: Ted Jones
> Priority: Blocker
> Fix For: 8.6.1, 9.0
>
>
> 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.
> GOOGLE SEARCH URL: http://www.google.com/complete/search
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
9 years, 6 months
[JBoss JIRA] (TEIIDDES-2284) Preview Error for REST Web Service Source
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2284?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2284:
----------------------------------------
Here is the Generated SQL for the google search WS REST use-case....
{code}
BEGIN
DECLARE STRING VARIABLES.qp = QUERYSTRING('http://www.google.com/complete/search', ViewModel.google.q AS q, ViewModel.google."output" AS "output");
SELECT A.suggestion AS suggestion FROM (EXEC SourceModel.invokeHttp('GET', null, VARIABLES.qp, 'TRUE')) AS f,
XMLTABLE('/toplevel' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS suggestion string PATH 'CompleteSuggestion/suggestion/text()') AS A;
END
{code}
Here is the current exception trying to execute the VDB:
org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: *TEIID30151 Error building Source for context item.*
[~shawkins] Any idea why this SQL isnt' working?
> Preview Error for REST Web Service Source
> -----------------------------------------
>
> Key: TEIIDDES-2284
> URL: https://issues.jboss.org/browse/TEIIDDES-2284
> Project: Teiid Designer
> Issue Type: Bug
> Components: Data Preview
> Affects Versions: 8.6
> Reporter: Ted Jones
> Assignee: Ted Jones
> Priority: Blocker
> Fix For: 8.6.1, 9.0
>
>
> 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.
> GOOGLE SEARCH URL: http://www.google.com/complete/search
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
9 years, 6 months
[JBoss JIRA] (TEIIDDES-2284) Preview Error for REST Web Service Source
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2284?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2284:
-----------------------------------
Description:
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.
GOOGLE SEARCH URL: http://www.google.com/complete/search
was:
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.
> Preview Error for REST Web Service Source
> -----------------------------------------
>
> Key: TEIIDDES-2284
> URL: https://issues.jboss.org/browse/TEIIDDES-2284
> Project: Teiid Designer
> Issue Type: Bug
> Components: Data Preview
> Affects Versions: 8.6
> Reporter: Ted Jones
> Assignee: Ted Jones
> Priority: Blocker
> Fix For: 8.6.1, 9.0
>
>
> 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.
> GOOGLE SEARCH URL: http://www.google.com/complete/search
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
9 years, 6 months
[JBoss JIRA] (TEIIDDES-2357) TeiidClientException when trying to query VDB that was created for REST consuption
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2357?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration commented on TEIIDDES-2357:
---------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1146952|https://bugzilla.redhat.com/show_bug.cgi?id=1146952] from ASSIGNED to CLOSED
> 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: 8.6.1, 9.0
>
>
> 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.1#6329)
9 years, 6 months
[JBoss JIRA] (TEIIDDES-2377) Merge various fixes from master into 8.3.5
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2377?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2377:
-----------------------------------
Description:
*Candidates*
* TEIIDDES-2165
* TEIIDDES-2376
*Completed Upstream*
* TEIIDDES-2224 web service returns 500 when concurrent access
*Merged*
* NONE
was:
*Candidates*
* TEIIDDES-2165
* TEIIDDES-2376
*Completed Upstream*
* NONE
*Merged*
* NONE
> Merge various fixes from master into 8.3.5
> ------------------------------------------
>
> Key: TEIIDDES-2377
> URL: https://issues.jboss.org/browse/TEIIDDES-2377
> Project: Teiid Designer
> Issue Type: Task
> Components: Patch Release
> Reporter: Barry LaFond
> Assignee: Johnathon Lee
> Priority: Blocker
>
> *Candidates*
> * TEIIDDES-2165
> * TEIIDDES-2376
> *Completed Upstream*
> * TEIIDDES-2224 web service returns 500 when concurrent access
> *Merged*
> * NONE
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
9 years, 6 months