< Blog

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

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