Preview from Procedure fails: number of bound values '0' does not match number of parameters '1' in prepared statement. ----------------------------------------------------------------------------------------------------------------------- Key: TEIIDDES-564 URL: https://jira.jboss.org/browse/TEIIDDES-564 Project: Teiid Designer Issue Type: Bug Components: Teiid Integration Affects Versions: 7.1 Environment: TeiidDesigner 7.1M2, Teiid 7.1 Final Reporter: Paul Nittel Attachments: ProcedureParameters.zip I created a small procedure which requires a single input parameter. When previewed, I receive the error noted in the title. If I deploy the VDB to the Teiid server, the same procedure executes OK. (Hence my logging it against the Designer.) Here is the exception from the server.log: [QueryResolverException]The number of bound values '0' does not match the number of parameters '1' in the prepared statement. at org.teiid.dqp.internal.process.PreparedStatementRequest.resolveParameterValues(PreparedStatementRequest.java:262) at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:167) at org.teiid.dqp.internal.process.Request.processRequest(Request.java:437) at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:352) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:174) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290) 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) Here is the transformation SQL: CREATE VIRTUAL PROCEDURE BEGIN SELECT * FROM Parts_Oracle.PARTS WHERE VPARTS.NEWPROCEDURE.colorIN LIKE Parts_Oracle.PARTS.PART_COLOR; END I queried using the color 'Red'. Model Project Set will be attached. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira