Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-564

Preview from Procedure fails: number of bound values '0' does not match number of parameters '1' in prepared statement.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 7.1
    • Fix Version/s: 7.1
    • Component/s: Teiid Integration
    • Labels:
      None
    • Environment:

      TeiidDesigner 7.1M2, Teiid 7.1 Final

      Description

      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.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                blafond Barry LaFond
                Reporter:
                pnittel Paul Nittel
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: