[teiid-designer-dev] Release 6.1 Update

[Paul Nittel]

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 at redhat.com>
To: "teiid-designer-dev" <teiid-designer-dev at lists.jboss.org>
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 at lists.jboss.org
https://lists.jboss.org/mailman/listinfo/teiid-designer-dev
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PaulsUpdateWebSvcTest.zip
Type: application/zip
Size: 60627 bytes
Desc: not available
Url : http://lists.jboss.org/pipermail/teiid-designer-dev/attachments/20090610/77bde552/attachment.zip