Invalid parameter number

Getting the below error msg in WebI and Infoview:

BO XI R3 SP 2, Stored Procedure universe.
What can cause this issue? . :hb:

Thanks in advance.


pl80 (BOB member since 2012-09-18)

Well, thanks for all the answers :slight_smile:


pl80 (BOB member since 2012-09-18)

I presume the stored procedure runs fine with those supplied parameters in its native environment (i.e. in SSMS if it’s a SQL Server database, Toad if it’s Oracle, etc.)?

That is correct, the stored procedure runs fine in Management Studio.


pl80 (BOB member since 2012-09-18)

Okay, this could be a variety of things. Firstly, double check that the odbc connection for BO is set up correctly, i.e. that you’ve specified the correct database in the connection. I’ve known stored procedure universes to be fussy about this in the past - even if you call database1.dbo.sp_myproc, it still expects the database in the odbc to be database1 rather than the default of master.