That should be on the engine side, I'll take a look. ----- Original Message ----- From: "Paul Nittel" <pnittel(a)redhat.com&gt; To: "Barry Lafond" <blafond(a)redhat.com&gt; Cc: "teiid-designer-dev" <teiid-designer-dev(a)lists.jboss.org&gt; Sent: Wednesday, June 10, 2009 4:39:10 PM GMT -06:00 US/Canada Central Subject: Re: [teiid-designer-dev] Release 6.1 Update Minor incident... I was running the Update Virtual Group through a Web Service test and while the insert operation succeeded, the delete op coughed up this: Error 2009-06-10 16:25:33.261 Error processing query com.metamatrix.jdbc.MMSQLException: Error Code:ERR.015.006.0033 Message:Unable to evaluate VARIABLES.IN_ID: No value was available 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:433) at com.metamatrix.jdbc.MMStatement.execute(MMStatement.java:328) 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: [MetaMatrixComponentException] ERR.015.006.0033: Error Code:ERR.015.006.0033 Message:Unable to evaluate VARIABLES.IN_ID: No value was available at com.metamatrix.query.util.CommandContext.getFromContext(CommandContext.java:446) at com.metamatrix.query.eval.Evaluator.internalEvaluate(Evaluator.java:539) at com.metamatrix.query.eval.Evaluator.internalEvaluate(Evaluator.java:554) at com.metamatrix.query.eval.Evaluator.evaluate(Evaluator.java:514) at com.metamatrix.query.sql.visitor.EvaluateExpressionVisitor.replaceExpression(EvaluateExpressionVisitor.java:84) at com.metamatrix.query.sql.visitor.ExpressionMappingVisitor.visit(ExpressionMappingVisitor.java:163) at com.metamatrix.query.sql.lang.CompareCriteria.acceptVisitor(CompareCriteria.java:118) at com.metamatrix.query.sql.navigator.AbstractNavigator.visitVisitor(AbstractNavigator.java:52) at com.metamatrix.query.sql.navigator.PreOrPostOrderNavigator.postVisitVisitor(PreOrPostOrderNavigator.java:119) at com.metamatrix.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:188) at com.metamatrix.query.sql.lang.CompareCriteria.acceptVisitor(CompareCriteria.java:118) at com.metamatrix.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:61) at com.metamatrix.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:361) at com.metamatrix.query.sql.lang.Query.acceptVisitor(Query.java:287) at com.metamatrix.query.sql.navigator.DeepPostOrderNavigator.doVisit(DeepPostOrderNavigator.java:69) at com.metamatrix.query.sql.visitor.EvaluateExpressionVisitor.replaceExpressions(EvaluateExpressionVisitor.java:117) at com.metamatrix.query.processor.relational.AccessNode.prepareCommand(AccessNode.java:118) at com.metamatrix.query.processor.relational.AccessNode.prepareNextCommand(AccessNode.java:111) at com.metamatrix.query.processor.relational.AccessNode.open(AccessNode.java:95) at com.metamatrix.query.processor.relational.RelationalPlan.open(RelationalPlan.java:101) at com.metamatrix.query.processor.QueryProcessor.initialize(QueryProcessor.java:113) at com.metamatrix.query.processor.QueryProcessor.process(QueryProcessor.java:153) at com.metamatrix.query.processor.proc.ProcedurePlan.getResults(ProcedurePlan.java:318) at com.metamatrix.query.processor.proc.ProcedurePlan.executePlan(ProcedurePlan.java:465) at com.metamatrix.query.processor.proc.AbstractAssignmentInstruction.process(AbstractAssignmentInstruction.java:78) at com.metamatrix.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:297) at com.metamatrix.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:236) at com.metamatrix.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:106) at com.metamatrix.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:257) at com.metamatrix.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:166) at com.metamatrix.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:257) at com.metamatrix.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:110) at com.metamatrix.query.processor.QueryProcessor.process(QueryProcessor.java:160) at com.metamatrix.query.processor.proc.ProcedurePlan.getResults(ProcedurePlan.java:318) at com.metamatrix.query.processor.proc.ProcedurePlan.executePlan(ProcedurePlan.java:465) at com.metamatrix.query.processor.proc.AbstractAssignmentInstruction.process(AbstractAssignmentInstruction.java:78) at com.metamatrix.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:297) at com.metamatrix.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:236) at com.metamatrix.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:106) at com.metamatrix.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:257) at com.metamatrix.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:166) at com.metamatrix.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:257) at com.metamatrix.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:110) at com.metamatrix.query.processor.QueryProcessor.process(QueryProcessor.java:160) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:264) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:210) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:44) at com.metamatrix.common.queue.WorkerPoolFactory$StatsCapturingSharedThreadPoolExecutor$1.run(WorkerPoolFactory.java:211) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Perhaps it didn't think a value was available, but I gave it one. The query is: EXEC ProductsWebSvc.ProdInterface.DeleteProduct('<?xml version="1.0" encoding="UTF-8"?> <InstrIdInput xmlns="http://www.metamatrix.com/UpdateProduct_Output"> <ID>XXX12346</ID> </InstrIdInput> ') The project is attached if anyone wants to take a peek. ------- Paul Nittel Sr. Quality Assurance Engineer Red Hat, Inc. 314-336-2907 (81-62907) ------- Looking to carve out IT costs? www.redhat.com/carveoutcosts/ ----- Original Message ----- From: "Barry Lafond" <blafond(a)redhat.com&gt; To: "teiid-designer-dev" <teiid-designer-dev(a)lists.jboss.org&gt; Sent: Wednesday, June 10, 2009 2:54:18 PM GMT -06:00 US/Canada Central Subject: [teiid-designer-dev] Release 6.1 Update I've got Teiid 6.1 release candidate integrated locally. We're going to do some spot-check tests and if "everything goes well", we'll be able to release with Teiid tomorrow. Barry _______________________________________________ teiid-designer-dev mailing list teiid-designer-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/teiid-designer-dev _______________________________________________ teiid-designer-dev mailing list teiid-designer-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/teiid-designer-dev