<p>Hello,</p>
<p> </p>
<p>I have the following and I am trying to add a report parameter (List Box with value on Application_Recommendation):</p>
<p> </p>
<div style="font-family:arial, sans-serif;font-size:13px;">SELECT </div>
<div style="font-family:arial, sans-serif;font-size:13px;"> A.APPLICATION_COMPONENT_ID,</div>
<div style="font-family:arial, sans-serif;font-size:13px;"> A.APPLICATION_COMPONENT_NAME,</div>
<div style="font-family:arial, sans-serif;font-size:13px;"> E.CATEGORY_COMPONENT_NAME,</div>
<div style="font-family:arial, sans-serif;font-size:13px;"> A.APPLICATION_DESCRIPTION,</div>
<div style="font-family:arial, sans-serif;font-size:13px;"> C.ORG_COMPONENT_NAME,</div>
<div style="font-family:arial, sans-serif;font-size:13px;"> A.APPLICATION_RECOMMENDATION</div>
<div style="font-family:arial, sans-serif;font-size:13px;"> </div>
<div style="font-family:arial, sans-serif;font-size:13px;">FROM TDM_FCT_APPLCTN A</div>
<div style="font-family:arial, sans-serif;font-size:13px;">LEFT JOIN</div>
<div style="font-family:arial, sans-serif;font-size:13px;"> EIM_RKT_ORG_OWNS_APP B</div>
<div style="font-family:arial, sans-serif;font-size:13px;">ON</div>
<div style="font-family:arial, sans-serif;font-size:13px;"> A.APPLICATION_COMPONENT_ID = B.APPLICATION_COMPONENT_ID</div>
<div style="font-family:arial, sans-serif;font-size:13px;">LEFT JOIN</div>
<div style="font-family:arial, sans-serif;font-size:13px;"> TDM_FACT_ORGANIZATION C</div>
<div style="font-family:arial, sans-serif;font-size:13px;">ON</div>
<div style="font-family:arial, sans-serif;font-size:13px;"> B.ORG_COMPONENT_ID = C.ORG_COMPONENT_ID </div>
<div style="font-family:arial, sans-serif;font-size:13px;">LEFT JOIN</div>
<div style="font-family:arial, sans-serif;font-size:13px;"> TDM_RKT_APP_MATRIX_BY_CATEGORY D</div>
<div style="font-family:arial, sans-serif;font-size:13px;">ON</div>
<div style="font-family:arial, sans-serif;font-size:13px;"> A.APPLICATION_COMPONENT_ID = D.APPLICATION_COMPONENT_ID</div>
<div style="font-family:arial, sans-serif;font-size:13px;">LEFT JOIN</div>
<div style="font-family:arial, sans-serif;font-size:13px;"> COSTCO_FACT_CATEGORY E</div>
<div style="font-family:arial, sans-serif;font-size:13px;">ON </div>
<div style="font-family:arial, sans-serif;font-size:13px;"> E.CATEGORY_COMPONENT_ID = D.APO_CAT_COMPONENT_ID</div>
<div style="font-family:arial, sans-serif;font-size:13px;">WHERE</div>
<div style="font-family:arial, sans-serif;font-size:13px;">A.APPLICATION_RECOMMENDATION = ?;</div>
<div style="font-family:arial, sans-serif;font-size:13px;"> </div>
<div style="font-family:arial, sans-serif;font-size:13px;">and I get the following error when I try to preview the report:</div>
<div style="font-family:arial, sans-serif;font-size:13px;"> </div>
<div style="font-family:arial, sans-serif;font-size:13px;">Cannot get the result set metadata.</div>
<div style="font-family:arial, sans-serif;font-size:13px;">org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.</div>
<div style="font-family:arial, sans-serif;font-size:13px;">SQL error #1: Missing IN or OUT parameter at index:: 1</div>
<div style="font-family:arial, sans-serif;font-size:13px;">;</div>
<div style="font-family:arial, sans-serif;font-size:13px;">java.sql.SQLException: Missing IN or OUT parameter at index:: 1</div>
<div style="font-family:arial, sans-serif;font-size:13px;"> </div>
<div style="font-family:arial, sans-serif;font-size:13px;">Reason:</div>
<div style="font-family:arial, sans-serif;font-size:13px;">A BIRT exception occurred.</div>
<div style="font-family:arial, sans-serif;font-size:13px;"> </div>
<div style="font-family:arial, sans-serif;font-size:13px;">Plug-in Provider: Eclipse.org</div>
<div style="font-family:arial, sans-serif;font-size:13px;">Plug-in Name: BIRT Data Engine</div>
<div style="font-family:arial, sans-serif;font-size:13px;">Plug-in ID: org.eclipse.birt.data</div>
<div style="font-family:arial, sans-serif;font-size:13px;">Version:2.6.1.v20100915</div>
<div style="font-family:arial, sans-serif;font-size:13px;">ErrorCode: odaconsumer.CannotGetREsultSetMetaData</div>
<div style="font-family:arial, sans-serif;font-size:13px;"> </div>
<div style="font-family:arial, sans-serif;font-size:13px;">Can someone point me to right direction to fix this error?</div>
<div style="font-family:arial, sans-serif;font-size:13px;"> </div>
<div style="font-family:arial, sans-serif;font-size:13px;">Thank you,</div>
<div style="font-family:arial, sans-serif;font-size:13px;"> </div>
<div style="font-family:arial, sans-serif;font-size:13px;">Jorge</div>
