November 11, 2004 at 10:00 am
Hi there,
I am wondering if someone can help me decipher a problem I am having when running a data driven subscription.
I set up a parameterized report as a data-driven subscription that gets the parameters from a table query. I then set up the subscription on a schedule (timed subscription). The subscription runs but seems to randomly skip records. The log has this entry:
ReportingServicesService!library!2fe4!11/11/2004-16:41:25:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'pCustomers' is not a valid value., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'pCustomers' is not a valid value.
The table is fairly large and will continue to grow. Does anyone know of a good way to capture the "invalid" records? Is there any way to send them to a log (I mean the parameter value itself)? Any help is appreciated as always.
Thanks,
Robin
November 15, 2004 at 8:00 am
This was removed by the editor as SPAM
November 16, 2004 at 4:08 am
Hi there
It might be a better option to check the data quality on the source system, thus returning the rows that have data errors. Othere wise the cleaner way is going to be to create data quality reports which have to be OK before your next report runs...
HTH
Charl
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply