<div>Hi - I am new to BIRT reporting and trying to access ssql server stored procedure using BIRT. I have define dataset as</div>
<div> </div>
<div>{call dbo.uspGetEmployeeManagers(?,1)}</div>
<div> </div>
<div>parameters defined for this SP are</div>
<div>
@RETURN_VALUE(int,Return_value)</div>
<div>
@EmployeeID(int,input)</div>
<div> </div>
<div>It seems like I called the SP thru BIRT correctly . but I receive " uspGetEmployeeManagers has too many arguments specified." error please help me rectify this error</div>
<div> </div>
<div>please see below exception from error log for more details....</div>
<div> </div>
<div> </div>
<div>org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.</div>
<div>at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.doRun(DatasetPreviewTask.java:318)</div>
<div>at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.runDataset(DatasetPreviewTask.java:280)</div>
<div>at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.execute(DatasetPreviewTask.java:91)</div>
<div>at org.eclipse.birt.report.designer.data.ui.dataset.DataSetPreviewer.preview(DataSetPreviewer.java:68)</div>
<div>at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage$5.run(ResultSetPreviewPage.java:366)</div>
<div>at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)</div>
<div>Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot get the result set metadata.</div>
<div> org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.</div>
<div>SQL error #1:Procedure or function uspGetEmployeeManagers has too many arguments specified.</div>
<div> ;</div>
<div> com.microsoft.sqlserver.jdbc.SQLServerException: Procedure or function uspGetEmployeeManagers has too many arguments specified.</div>
<div>at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:52)</div>
<div>at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:108)</div>
<div>at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:84)</div>
<div>at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getRuntimeMetaData(PreparedStatement.java:414)</div>
<div>at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getProjectedColumns(PreparedStatement.java:377)</div>
<div>at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.doGetMetaData(PreparedStatement.java:347)</div>
<div>at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.execute(PreparedStatement.java:563)</div>
<div>at org.eclipse.birt.data.engine.executor.DataSourceQuery.execute(DataSourceQuery.java:970)</div>
<div>at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:503)</div>
<div>at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1222)</div>
<div>at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)</div>
<div>at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:178)</div>
<div>at org.eclipse.birt.data.engine.impl.QueryResults.getResultMetaData(QueryResults.java:132)</div>
<div>at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.extractQuery(DatasetPreviewTask.java:352)</div>
<div>at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.doRun(DatasetPreviewTask.java:309)</div>
<div>... 5 more</div>
<div>Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.</div>
<div>SQL error #1:Procedure or function uspGetEmployeeManagers has too many arguments specified.</div>
<div> ;</div>
<div> com.microsoft.sqlserver.jdbc.SQLServerException: Procedure or function uspGetEmployeeManagers has too many arguments specified.</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery(Statement.java:481)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaUsingDefaultPolicy(Statement.java:388)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaData(Statement.java:330)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.bidi.BidiStatement.getMetaData(BidiStatement.java:56)</div>
<div>at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.doGetMetaData(OdaQuery.java:423)</div>
<div>at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.getMetaData(OdaQuery.java:390)</div>
<div>at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getRuntimeMetaData(PreparedStatement.java:407)</div>
<div>... 16 more</div>
<div>Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Procedure or function uspGetEmployeeManagers has too many arguments specified.</div>
<div>at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)</div>
<div>at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)</div>
<div>at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)</div>
<div>at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)</div>
<div>at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)</div>
<div>at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)</div>
<div>at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)</div>
<div>at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)</div>
<div>at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery(Statement.java:477)</div>
<div>... 22 more</div>
<div> </div>
