SSRS Report Subscription Fails Due to Subscription contains parameter values that are not valid RRS feed

  • Question

  • Hi,

    I have configured a report in which 4 text data type parameters get values from a dataset query.

    The 4 datasets have been configured to pick avg value of a column between the default start date and end date  and the average gets calculated alright and is stored at run time in the 4 respective parameters.

    However, after subscribing this report for auto-mail, we observed that the mail is not being received to the respective recipients.

    So, we went into it & checked the last run status which indicated "The Subscription contains parameter values that are not valid" & the status was of the subscription was automatically disabled.

    We would like to hear from you the possible root cause and its best solution to overcome this issue ASAP.

    Note*: The values in the average column are always present with a frequency of every minutes.

    Attached is the snapshot for your reference.

    Please help!!!

    Thanks for your support & understanding!


    Afshaan Shaikh

    Friday, July 31, 2020 6:06 AM