[teiid-designer-users] How to import a Web Service as Relational Source Model

[Davide Cerbo]

Hi all, I have an issue when I'm trying to import a Web Service as
Relational Source Model.
 I'm doing the following steps:
 1) Right click on Project and select "Import" from menu
 2) Then I choose "Web Service as Relational Source Model"
 3) After that I have pressed "Next", insert "Url" of WSDL, validate
it, choose "Model Name" and "Location"
 4) Finally I choose one method to import from web service then press finish.

 This operation create 3 tables in target model:
 - getAllTasksResponse
 - getAllTasksReturn
 - getAllTeasksRequest

 Are the above steps formerly correct?

 Then I add the model to a VDB and click on Execute button on VDB
editing screen.
 In SQLExplorer perspective I click on created tables and I generate
the following 3 SQL queries:
 1) select ResponseOut from
"Test"."Soap.FunctionPointsServiceService.getAllTasks.getAllTasksRequest"
 2) select ResponseIn, mmid from
"Test"."Soap.FunctionPointsServiceService.getAllTasks.getAllTasksResponse"
 3) select getAllTasksResponse_mmid, ResponseIn from
"Test"."Soap.FunctionPointsServiceService.getAllTasks.getAllTasksReturn"

 The first query runs without errors, but the resultset is empty.
 Second and third one give me this exception:

 com.metamatrix.jdbc.MMSQLException: Group has an access pattern which
 has not been met: group(s)
 [Test.Soap.FunctionPointsServiceService.getAllTasks.getAllTasksReturn];
 access pattern(s) [Access Pattern: Unsatisfied
 [Soap.FunctionPointsServiceService.getAllTasks.getAllTasksReturn.ResponseIn]
 History [[Soap.FunctionPointsServiceService.getAllTasks.getAllTasksReturn.ResponseIn]]]
        at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:82)
        at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:63)
        at com.metamatrix.jdbc.MMStatement.executeSql(MMStatement.java:424)
        at com.metamatrix.jdbc.MMStatement.execute(MMStatement.java:326)
        at net.sourceforge.sqlexplorer.sqlpanel.SqlExecProgress.processQuery(SqlExecProgress.java:192)
        at net.sourceforge.sqlexplorer.sqlpanel.SqlExecProgress.run(SqlExecProgress.java:121)
        at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
 Caused by: [QueryPlannerException]Group has an access pattern which
 has not been met: group(s)
 [Test.Soap.FunctionPointsServiceService.getAllTasks.getAllTasksReturn];
 access pattern(s) [Access Pattern: Unsatisfied
 [Soap.FunctionPointsServiceService.getAllTasks.getAllTasksReturn.ResponseIn]
 History [[Soap.FunctionPointsServiceService.getAllTasks.getAllTasksReturn.ResponseIn]]]
        at com.metamatrix.query.optimizer.relational.rules.RuleAccessPatternValidation.validateAccessPatterns(RuleAccessPatternValidation.java:120)
        at com.metamatrix.query.optimizer.relational.rules.RuleAccessPatternValidation.validateAccessPatterns(RuleAccessPatternValidation.java:76)
        at com.metamatrix.query.optimizer.relational.rules.RuleAccessPatternValidation.execute(RuleAccessPatternValidation.java:68)
        at com.metamatrix.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:400)
        at com.metamatrix.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:144)
        at com.metamatrix.query.optimizer.QueryOptimizer.optimize(QueryOptimizer.java:241)
        at com.metamatrix.query.optimizer.QueryOptimizer.recursiveOptimize(QueryOptimizer.java:215)
        at com.metamatrix.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:123)
        at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:534)
        at org.teiid.dqp.internal.process.Request.processRequest(Request.java:623)
        at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:373)
        at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:206)
        at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:44)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
        at java.lang.Thread.run(Thread.java:619)


 Have I make some mistakes? Have you experienced these kind of
problems? let me know
 Thanks in advance.

-- 
-- 
Davide Cerbo
-----------
http://davide.cerbo.born-to-co.de
http://jesty.it
-----------
http://www.pronetics.it
http://www.sourcesense.com
-----------