September 4, 2014 at 1:22 pm
Hi,
I have data driven subscription for a report where I select comma separated values for a multivalue parameter("a,b" ). With in my report, I am converting the comma separated values into multiple rows using the plsql code below.
et.column_desc IN (SELECT regexp_substr(:column_desc,'[^,]+',1,level) FROM DUAL CONNECT BY LEVEL <= LENGTH (REGEXP_REPLACE (:column_desc, '[^,]'))+1))
The subscription fails showing the last results as Done: 1 processed of 1 total; 1 errors and the subscription is never sent out.
There is no row entered in the Execution Log table. I am using Sharepoint Integrated mode and my ULS Logs do not show much in regards to the subscription failure. Below is what it shows from ULS Logs
Line 249: 09/04/2014 14:15:09.96 w3wp.exe (0x1330) 0x1B68SQL Server Reporting Services Report Server Catalog 00000Medium Handling data-driven subscription a4fd2104-113d-4e24-b49e-12461687b6a0 to report https://extranet.aaaaaa.com/Reports/xxxxxx Basic Load Info.rdl, owner: aaaaaa\pparpati, delivery extension: Report Server Email.
Line 431: 09/04/2014 14:15:22.11 w3wp.exe (0x1330) 0x11A0SQL Server Reporting Services Report Server Notification 00000Medium Notification 91adbfe0-3338-4e69-93c3-a669d97c87db completed. Success: False, Status: , DeliveryExtension: Report Server Email, Report: xxxxxx Basic Load Info.rdl, Attempt 0
Please suggest what could I do to debug and fix this.
Thank you,
Veena
September 4, 2014 at 1:41 pm
The error was with the parameter Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: , Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'column_desc' is not a valid value.;
The issue is that the comma separated values is not recognized as a valid value for that parameter.
Is there a way to send multiple values for a parameter in a data driven subscription? Please suggest.
September 4, 2014 at 2:39 pm
Hi,
I used the solution suggested in the link below with few minor changes:
Thank you,
Veena
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply