Report Parameter Validation Failure

Generally, Data Warehouse reports do not mask bad data. If you see the following text when running a report, "Parameter validation failed. It is not possible to provide valid values for all parameters. (rsParameterError)", it is most likely caused by data errors in the Data Warehouse. Check for NULL values in the Data Warehouse and fix the data for the reports to be successful.

To make the reports appear with some bad data, follow these steps:

  1. In the Report Manager, click Show Details.

  2. Click the Edit button for the report.

  3. Click Parameters in the left pane.

  4. Override the defaults for the parameters.

This overrides the defaults parameters that are queried from the database. This will mask problems with the data that the parameters are using, for example: Date_Registered Field is null in the RegisteredUser table.

See Also

Other Resources

Commerce Server 2009 R2 Troubleshooting