[JBoss JIRA] (TEIIDDES-2509) Import from REST doesn't create View model
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2509?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2509:
----------------------------------------
I verified this works in my IDE, however, in an installation if fails. Looks like a SAXON jar version issue:
Caused by: java.lang.ClassNotFoundException: net.sf.saxon.expr.PathMap$PathMapNode cannot be found by org.teiid.runtime.client_9.0.2.Beta1-v20150429-1449-B949
{code}
java.lang.NoClassDefFoundError: net/sf/saxon/expr/PathMap$PathMapNode
at org.teiid.query.sql.lang.XMLTable.compileXqueryExpression(XMLTable.java:124)
at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:398)
at org.teiid.query.sql.lang.XMLTable.acceptVisitor(XMLTable.java:183)
at org.teiid.query.sql.lang.SimpleNode.acceptVisitor(SimpleNode.java:1)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:69)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:82)
at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:335)
at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:661)
at org.teiid.query.sql.lang.From.acceptVisitor(From.java:119)
at org.teiid.query.sql.lang.SimpleNode.acceptVisitor(SimpleNode.java:1)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:69)
at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:277)
at org.teiid.query.resolver.command.SimpleQueryResolver.resolveCommand(SimpleQueryResolver.java:121)
{code}
> Import from REST doesn't create View model
> ------------------------------------------
>
> Key: TEIIDDES-2509
> URL: https://issues.jboss.org/browse/TEIIDDES-2509
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 9.0.2 Beta1
> Environment: OSX, Fedora 20, Windows 7
> Reporter: Matus Makovy
> Assignee: Barry LaFond
> Priority: Blocker
> Fix For: 9.1, 9.0.2
>
> Attachments: Screen Shot 2015-05-06 at 12.19.49 PM.png
>
>
> Import from REST WS (both JSON and XML) doesn't create View model, only Source model is created
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2500) Problems with model created via import from Salesforce when using JOIN query
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2500?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2500:
-----------------------------------
Fix Version/s: 9.1
9.0.2
> Problems with model created via import from Salesforce when using JOIN query
> ----------------------------------------------------------------------------
>
> Key: TEIIDDES-2500
> URL: https://issues.jboss.org/browse/TEIIDDES-2500
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.1
> Reporter: Matus Makovy
> Assignee: Mark Drilling
> Fix For: 9.1, 9.0.2, 8.6.2
>
> Attachments: log, salesdynamic-vdb.xml, SalesforceTD.zip
>
>
> Discovered this issue when trying to verify TEIID-3112
> I am trying to execute this query on VDB created via import from SalesForce in Teiid Designer.
> {quote}
> select distinct YEAR("Opportunity"."CloseDate") as "Opportunity_CloseDate1" from "SalesForceSource".salesforce.Campaign AS "Campaign" LEFT OUTER JOIN "SalesForceSource".salesforce.Opportunity AS "Opportunity" ON Campaign."Id" = Opportunity."CampaignId" order by YEAR("Opportunity"."CloseDate") ASC LIMIT 0 , 32
> {quote}
> And I get this exception:
> {quote}
> org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidException: Invalid QName in mapping: sf:INVALID_TYPE
> {quote}
> Log attached
> With dynamic VDB created manually or with import using Teiid Connection Importer via Designer everything works.
> Project from Designer + dynamic VDB attached
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2500) Problems with model created via import from Salesforce when using JOIN query
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2500?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2500:
-----------------------------------
Fix Version/s: 8.6.2
> Problems with model created via import from Salesforce when using JOIN query
> ----------------------------------------------------------------------------
>
> Key: TEIIDDES-2500
> URL: https://issues.jboss.org/browse/TEIIDDES-2500
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.1
> Reporter: Matus Makovy
> Assignee: Mark Drilling
> Fix For: 9.1, 9.0.2, 8.6.2
>
> Attachments: log, salesdynamic-vdb.xml, SalesforceTD.zip
>
>
> Discovered this issue when trying to verify TEIID-3112
> I am trying to execute this query on VDB created via import from SalesForce in Teiid Designer.
> {quote}
> select distinct YEAR("Opportunity"."CloseDate") as "Opportunity_CloseDate1" from "SalesForceSource".salesforce.Campaign AS "Campaign" LEFT OUTER JOIN "SalesForceSource".salesforce.Opportunity AS "Opportunity" ON Campaign."Id" = Opportunity."CampaignId" order by YEAR("Opportunity"."CloseDate") ASC LIMIT 0 , 32
> {quote}
> And I get this exception:
> {quote}
> org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidException: Invalid QName in mapping: sf:INVALID_TYPE
> {quote}
> Log attached
> With dynamic VDB created manually or with import using Teiid Connection Importer via Designer everything works.
> Project from Designer + dynamic VDB attached
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2500) Problems with model created via import from Salesforce when using JOIN query
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2500?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2500:
--------------------------------------
Assignee: Mark Drilling
> Problems with model created via import from Salesforce when using JOIN query
> ----------------------------------------------------------------------------
>
> Key: TEIIDDES-2500
> URL: https://issues.jboss.org/browse/TEIIDDES-2500
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.1
> Reporter: Matus Makovy
> Assignee: Mark Drilling
> Attachments: log, salesdynamic-vdb.xml, SalesforceTD.zip
>
>
> Discovered this issue when trying to verify TEIID-3112
> I am trying to execute this query on VDB created via import from SalesForce in Teiid Designer.
> {quote}
> select distinct YEAR("Opportunity"."CloseDate") as "Opportunity_CloseDate1" from "SalesForceSource".salesforce.Campaign AS "Campaign" LEFT OUTER JOIN "SalesForceSource".salesforce.Opportunity AS "Opportunity" ON Campaign."Id" = Opportunity."CampaignId" order by YEAR("Opportunity"."CloseDate") ASC LIMIT 0 , 32
> {quote}
> And I get this exception:
> {quote}
> org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidException: Invalid QName in mapping: sf:INVALID_TYPE
> {quote}
> Log attached
> With dynamic VDB created manually or with import using Teiid Connection Importer via Designer everything works.
> Project from Designer + dynamic VDB attached
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2506) NPE when attempting to finish REST import
by Marc Shirley (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2506?page=com.atlassian.jira.plu... ]
Marc Shirley commented on TEIIDDES-2506:
----------------------------------------
No, haven't been able to replicate it here and the environment that produced the issue was discarded. They are not currently using JBDS for modeling/VDB needs.
> NPE when attempting to finish REST import
> -----------------------------------------
>
> Key: TEIIDDES-2506
> URL: https://issues.jboss.org/browse/TEIIDDES-2506
> Project: Teiid Designer
> Issue Type: Bug
> Components: Web Services Support
> Affects Versions: 9.0
> Environment: Mac
> JBDS Version: 8.0.0.GA
> Build id: GA-v20141020-1042-B317
> Teiid Designer version: 9.0.1.Final-v20150211-1407-B643
> Reporter: Marc Shirley
> Assignee: Ted Jones
> Fix For: 9.1, 9.0.2
>
>
> Popup dialog when finishing REST import wizard with content:
> "Error creating view model ViewModel.xmi" with error text "Failed to execute runnable (org.eclipse.swt.SWTException: Failed to execute runnable (java.lang.NullPointerException))"
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2511) Import from SOAP WS problems with View model
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2511?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2511:
--------------------------------------
Assignee: Barry LaFond (was: Ted Jones)
> Import from SOAP WS problems with View model
> --------------------------------------------
>
> Key: TEIIDDES-2511
> URL: https://issues.jboss.org/browse/TEIIDDES-2511
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 9.0.2 Beta1
> Reporter: Matus Makovy
> Assignee: Barry LaFond
> Priority: Blocker
> Fix For: 9.1, 9.0.2
>
> Attachments: screen.png
>
>
> After finishing import from SOAP WS, View model reports problem.
> Some SWTException -> See attachment
> Also, I am importing two procedures "FullCountryInfo()" and "FullCountryInfoAllCountries()" and I see only one procedure in the View model.
> Lastly, I think that there is one part missing. For example after import of procedure "FullCountryInfo" I should have in the view model 3 procedures: "FullCountryInfo_request" , "FullCountryInfo_response" and "FullCountryInfo" and there are only 2 of them. See screenshot
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2511) Import from SOAP WS problems with View model
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2511?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2511:
--------------------------------------
Assignee: Ted Jones
> Import from SOAP WS problems with View model
> --------------------------------------------
>
> Key: TEIIDDES-2511
> URL: https://issues.jboss.org/browse/TEIIDDES-2511
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 9.0.2 Beta1
> Reporter: Matus Makovy
> Assignee: Ted Jones
> Priority: Blocker
> Fix For: 9.1, 9.0.2
>
> Attachments: screen.png
>
>
> After finishing import from SOAP WS, View model reports problem.
> Some SWTException -> See attachment
> Also, I am importing two procedures "FullCountryInfo()" and "FullCountryInfoAllCountries()" and I see only one procedure in the View model.
> Lastly, I think that there is one part missing. For example after import of procedure "FullCountryInfo" I should have in the view model 3 procedures: "FullCountryInfo_request" , "FullCountryInfo_response" and "FullCountryInfo" and there are only 2 of them. See screenshot
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months