[JBoss JIRA] (TEIIDDES-2656) Issue with importing from SOAP
by Matus Makovy (JIRA)
Matus Makovy created TEIIDDES-2656:
--------------------------------------
Summary: Issue with importing from SOAP
Key: TEIIDDES-2656
URL: https://issues.jboss.org/browse/TEIIDDES-2656
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 9.0.4
Environment: MAC OS X
Reporter: Matus Makovy
When you try to import from SOAP WS and create new connection profile to webservice in the same dialogue you get +WSDL Parse Error+. But when you hit "<Back" and "Next>" everything works.
It seems to occur only if you have no connection profiles defined and you are creating the first connection profile to SOAP WS.
See attached video.
Link to video: https://www.dropbox.com/s/k2r78zmz5ukd8ik/bugSOAP.mov?dl=0
(too big for JIRA)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 9 months
[JBoss JIRA] (TEIIDDES-2554) Import of REST service with columns set to 'integer' type results in "Expected biginteger, but was integer."
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2554?page=com.atlassian.jira.plu... ]
Matus Makovy closed TEIIDDES-2554.
----------------------------------
There is no option to selcet data type integer.
> Import of REST service with columns set to 'integer' type results in "Expected biginteger, but was integer."
> ------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2554
> URL: https://issues.jboss.org/browse/TEIIDDES-2554
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export, Web Services Support
> Affects Versions: 9.0.1
> Reporter: Marc Shirley
> Assignee: Ted Jones
> Labels: release_notes, verified_jbdsis-8.0.4.CR1
> Fix For: 9.0.4, 9.2
>
>
> Importing posts service from http://jsonplaceholder.typicode.com results in "Expected biginteger, but was integer." runtime error when previewing procedure. This appears to be an issue with the type assignments on the model as a dynamic VDB using the same invocation executes properly. Also seems similar to the issue described in TEIIDDES-2438.
> Full error is:
> org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.api.exception.query.QueryPlannerException: TEIID30492 TEIID31121 The expected result set of the procedure ViewModel.postById does not match the result set from returnable statement SELECT A.id AS id, A.userId AS userId, A.title AS title, A.body AS body FROM (EXEC SourceModel.invokeHttp(action => 'GET', endpoint => VARIABLES.qp, stream => 'TRUE')) AS f, XMLTABLE('/response' PASSING JSONTOXML('response', f.result) COLUMNS id integer PATH 'id/text()', userId integer PATH 'userId/text()', title string PATH 'title/text()', body string PATH 'body/text()') AS A; use WITHOUT RETURN to indicate the statement should not be returned - The definition for ViewModel.postById has the wrong type for column 1. Expected biginteger, but was integer.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 9 months
[JBoss JIRA] (TEIIDDES-2554) Import of REST service with columns set to 'integer' type results in "Expected biginteger, but was integer."
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2554?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2554:
-----------------------------------
Labels: release_notes verified_jbdsis-8.0.4.CR1 (was: )
> Import of REST service with columns set to 'integer' type results in "Expected biginteger, but was integer."
> ------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2554
> URL: https://issues.jboss.org/browse/TEIIDDES-2554
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export, Web Services Support
> Affects Versions: 9.0.1
> Reporter: Marc Shirley
> Assignee: Ted Jones
> Labels: release_notes, verified_jbdsis-8.0.4.CR1
> Fix For: 9.0.4, 9.2
>
>
> Importing posts service from http://jsonplaceholder.typicode.com results in "Expected biginteger, but was integer." runtime error when previewing procedure. This appears to be an issue with the type assignments on the model as a dynamic VDB using the same invocation executes properly. Also seems similar to the issue described in TEIIDDES-2438.
> Full error is:
> org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.api.exception.query.QueryPlannerException: TEIID30492 TEIID31121 The expected result set of the procedure ViewModel.postById does not match the result set from returnable statement SELECT A.id AS id, A.userId AS userId, A.title AS title, A.body AS body FROM (EXEC SourceModel.invokeHttp(action => 'GET', endpoint => VARIABLES.qp, stream => 'TRUE')) AS f, XMLTABLE('/response' PASSING JSONTOXML('response', f.result) COLUMNS id integer PATH 'id/text()', userId integer PATH 'userId/text()', title string PATH 'title/text()', body string PATH 'body/text()') AS A; use WITHOUT RETURN to indicate the statement should not be returned - The definition for ViewModel.postById has the wrong type for column 1. Expected biginteger, but was integer.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 9 months