SQL Reporting Services subscription works for one owner but not another

Question

A colleague has created a data-driven subscription which continually errors with "The value provided for the report parameter 'ParameterName' is not valid for its type.

However if I create an equivalent subscription (same data driven query, same parameters, etc.) it works without issue. The only difference I can see is the owner of the subscription.

I've reviewed the ExecutionLog and can see that the same ItemPath entries are returned with the same number of rows - up to the point where the error is reported. SQL Profiler doesn't report any errors and if I run the individual data sources manually, identical data is being returned.

Is there a reason that seemingly identical subscriptions have different outcomes? Also / alternatively, is there a way to get the "invalid" value of the report parameter to see if I can debug it that way?

Thanks.

Answer 1

Hi @Peter Bishop

What is the data type of your parameter? This kind of problem usually happens in the date parameter, the date format does not match. You can refer to this link: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d126f21b-59e0-48f7-8c9f-b5211fc5d317/ssrs-subscription-strange-quotreport-parameter-is-not-a-valid-valuequot-problem?forum=sqlreportingservices.

Please check that the value of the parameter corresponds to the value in the source table. Check that the parameter data type matches the data type in the database.

Best regards,

Aniya