title: OpenERP pentaho report error : Failed at query
body: <p>I am getting an error while I try to generate a report from OpenERP.</p>
  
  <pre><code>  File "/home/target/projects/orthene/pentaho_reports/wizard/report_prompt.py", line 207, in _setup_parameters
      report_parameters = proxy.report.getParameterInfo(proxy_argument)
    File "/usr/lib/python2.7/xmlrpclib.py", line 1224, in __call__
      return self.__send(self.__name, args)
    File "/usr/lib/python2.7/xmlrpclib.py", line 1578, in __request
      verbose=self.__verbose
    File "/usr/lib/python2.7/xmlrpclib.py", line 1264, in request
      return self.single_request(host, handler, request_body, verbose)
    File "/usr/lib/python2.7/xmlrpclib.py", line 1297, in single_request
      return self.parse_response(response)
    File "/usr/lib/python2.7/xmlrpclib.py", line 1473, in parse_response
      return u.close()
    File "/usr/lib/python2.7/xmlrpclib.py", line 793, in close
      raise Fault(**self._stack[0])
  Fault: &lt;Fault 0: 'Failed to invoke method getParameterInfo in class com.willowit.reporting.PentahoRenderer: Failed at query: SELECT name FROM res_partner WHERE customer=True'&gt;
  </code></pre>
  
  <p>Here is how my pentaho report design looks like:
  <img src="https://i.stack.imgur.com/vjvgX.png" alt="version 5.0.1-Stable">
  The pentaho report designed version is 5.0.1-Stable</p>
  
  <ol>
  <li>It is a JDBC connection with my local postgres database connection, which is a successful connection in report designer.</li>
  <li>select_partner is a SQL query that fetches all the partner names to show in parameter.</li>
  </ol>
  
  <blockquote>
    <p>SELECT name FROM res_partner WHERE customer=True</p>
  </blockquote>
  
  <ol start="3">
  <li>PartnerQuery is a SQL query that fetches name,city,phone &amp; email of customers
  
  <blockquote>
    <p>SELECT name,city,phone,email FROM res_partner WHERE customer=True AND name=${partner} // ${partner} is a parameter defined</p>
  </blockquote></li>
  <li>partner parameter is containing drop down selection of partners when we generate a report, it includes <strong>2</strong> point partner_query(which lists down all the partners)
  ![enter image description here][2]
  Report is working fine in Pentaho report designed &amp; give output like this:<img src="https://i.stack.imgur.com/vjvgX.png" alt="enter image description here">
  But it is not working in OpenERP &amp; getting an error as described on the very top.</li>
  </ol>