Post reply

Data Driven subscription Trouble shooting

  • September 4, 2014 at 1:22 pm

    #298983

    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

    #1743335

    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

    #1743350

    Hi,

    I used the solution suggested in the link below with few minor changes:

    http://www.sqlservercentral.com/blogs/data-adventures/2014/08/27/ssrs-report-multi-value-parameter-going-after-data-driven-subscription/

    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