Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » SQL Server Stored procedure call from BIRT(BIRT Stored Procedure)
SQL Server Stored procedure call from BIRT [message #1556714] Sat, 10 January 2015 13:55 Go to next message
Priya Mohan is currently offline Priya MohanFriend
Messages: 5
Registered: January 2015
Junior Member
Hi - I am new to BIRT reporting and trying to access ssql server stored procedure using BIRT. I have define dataset as

{call dbo.uspGetEmployeeManagers(?,1)}

parameters defined for this SP are
@RETURN_VALUE(int,Return_value)
@EmployeeID(int,input)

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

please see below exception from error log for more details....


org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.
at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.doRun(DatasetPreviewTask.java:318)
at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.runDataset(DatasetPreviewTask.java:280)
at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.execute(DatasetPreviewTask.java:91)
at org.eclipse.birt.report.designer.data.ui.dataset.DataSetPreviewer.preview(DataSetPreviewer.java:68)
at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage$5.run(ResultSetPreviewPage.java:366)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)
Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot get the result set metadata.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:Procedure or function uspGetEmployeeManagers has too many arguments specified.
;
com.microsoft.sqlserver.jdbc.SQLServerException: Procedure or function uspGetEmployeeManagers has too many arguments specified.
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:52)
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:108)
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:84)
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getRuntimeMetaData(PreparedStatement.java:414)
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getProjectedColumns(PreparedStatement.java:377)
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.doGetMetaData(PreparedStatement.java:347)
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.execute(PreparedStatement.java:563)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.execute(DataSourceQuery.java:970)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:503)
at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1222)
at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:233)
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:178)
at org.eclipse.birt.data.engine.impl.QueryResults.getResultMetaData(QueryResults.java:132)
at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.extractQuery(DatasetPreviewTask.java:352)
at org.eclipse.birt.report.engine.api.impl.DatasetPreviewTask.doRun(DatasetPreviewTask.java:309)
... 5 more
Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:Procedure or function uspGetEmployeeManagers has too many arguments specified.
;
com.microsoft.sqlserver.jdbc.SQLServerException: Procedure or function uspGetEmployeeManagers has too many arguments specified.
at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery(Statement.java:481)
at org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaUsingDefaultPolicy(Statement.java:388)
at org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaData(Statement.java:330)
at org.eclipse.birt.report.data.oda.jdbc.bidi.BidiStatement.getMetaData(BidiStatement.java:56)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.doGetMetaData(OdaQuery.java:423)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.getMetaData(OdaQuery.java:390)
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getRuntimeMetaData(PreparedStatement.java:407)
... 16 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Procedure or function uspGetEmployeeManagers has too many arguments specified.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)
at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery(Statement.java:477)
... 22 more

[Updated on: Mon, 12 January 2015 18:55]

Report message to a moderator

Re: SQL Server Stored procedure call from BIRT [message #1560676 is a reply to message #1556714] Mon, 12 January 2015 18:59 Go to previous messageGo to next message
Priya Mohan is currently offline Priya MohanFriend
Messages: 5
Registered: January 2015
Junior Member
Can anyone please let me know how I can call the sql server Stored procedure from BIRT with parameters? I am using jdbc.ssqlserverDriver(v4.0)

[Updated on: Mon, 12 January 2015 19:58]

Report message to a moderator

Re: SQL Server Stored procedure call from BIRT [message #1566046 is a reply to message #1560676] Thu, 15 January 2015 16:44 Go to previous messageGo to next message
Priya Mohan is currently offline Priya MohanFriend
Messages: 5
Registered: January 2015
Junior Member



[Updated on: Thu, 15 January 2015 16:46]

Report message to a moderator

Re: SQL Server Stored procedure call from BIRT [message #1566047 is a reply to message #1560676] Thu, 15 January 2015 16:45 Go to previous message
Priya Mohan is currently offline Priya MohanFriend
Messages: 5
Registered: January 2015
Junior Member
I found out that I need to set the data set type as stored procedure. but I am trying to call a stored procedure that has one input parameter that needs to be given as datetime. Please geive me an exmaple of calling stored procedure with datetime. Thanks



Previous Topic:Daylight Savings Time issue in BIRT
Next Topic:Duplicate
Goto Forum:
  


Current Time: Sat Jul 20 13:16:29 GMT 2024

Powered by FUDForum. Page generated in 0.03278 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top