Ash Burton

Mobile | Web | Data

Mobile Payments, Android, iOS, Mobile Web, HTML5, Multichannel Customer Service, Web Services, IVR, Business Intelligence, Telecoms, Radio, Photography, Running, Gaming

Quick Fix: Invalid Parameter Number (WIS 10901) in BOXIR3.1

I encountered this error whilst testing a Stored Procedure Universe in BO XI R3.1, given that it says "Invalid Parameter Number" you would naturally assume that it was something relating to the stored procedure itself, passing parameters from the front-end to the DB in SQL, etc. but in my case it was a classic red herring error message.

The issue turned out to be permissions problem, the user executing the stored procedure did not have permissions to execute it.  After running the following SQL statement everything ran perfectly...

GRANT EXECUTE ON my_dwh.dbo.usp_do_something_useful TO PUBLIC 

... though bear in mind that you may not want to grant permissions to everyone ('public'), I just use it as a simple example.