Business Intelligence Development Studio (BIDS) Error – Passing Variables to Stored Procedures, Part II

leaston

By Garth Jones
As promised in yesterday’s blog post, here are a couple more BIDS error messages that I come across from time-to-time with quick ways to fix them.
Error Message #3
This error message is about having too many variables passed to the stored procedure. The solution to this problem: adjust the query to pass all the variables required and then refresh the field list.
Could not generate a list of fields for the query.
Check the query syntax, or click Refresh Fields on the query toolbar.
Procedure or function WIR3_RBA_WarPCsbyUser has too many arguments specified. (Microsoft SQL Server, Error: 8144)
BIDS Error 3 – Passing Variables to Stored Procedures
Error Message #4
This error message is also about having too many variables passed to the stored procedure. The subtle difference, however, between Error # 3 and Error #4 is that in this case no variables are expected to be passed to the stored procedure and at least one was passed. The solution to this problem: adjust the query so that NO variables are passed to the stored procedure and then refresh the field list.
Could not generate a list of fields for the query.
Check the query syntax, or click Refresh Fields on the query toolbar.
Procedure WIR3_UserNameFilter_RV has no parameters and arguments were supplied. (Microsoft SQL Server, Error: 8146)
BIDS Error 4 – Passing Variables to Stored Procedures

Leave a Comment