Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Data Driven Subscriptions Updated


Data Driven Subscriptions Updated

Author
Message
dguthrie_2010
dguthrie_2010
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 35
I tried using the entity references instead of the "less than" and "greater than" characters that surround an HTML tag, and that also works! See my post above where I changed the the original message to show the entity references instead of the "<" and ">" characters.

Does this mean maybe that our server uses a character setting that's different from others?

If anyone knows, I would appreciate hearing back. Thanks.
Matthew Lehn
Matthew Lehn
SSC Veteran
SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)

Group: General Forum Members
Points: 223 Visits: 783
This sounds like you are attempting to send HTML in a plain text email, hence why the discrepancies. What are you using to send the physical email once the report is generated?

Zycon - The Search Engine for Manufacturers. Helping Engineers and Technical Buyers Locate Aluminum Extrusions, Metal Stampers, Plastic Fabricators, Valves, and More.
dguthrie_2010
dguthrie_2010
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 35
From within the SSRS Configuration Tool we specified an SMTP server and an email account to send the email.

This probably is a plain text email; and we're trying to use html tags to create the paragraph spacing. So that may be the problem.
dguthrie_2010
dguthrie_2010
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 35
We just moved the entire report/email process from a development/test server to a production server.

Now, neither the embedded html line break tag(s) nor the CHAR[13]+CHAR[10] method creates the desired crlf result.

But, using the entity references does work, so the problem we were having may have something to do with the character set settings on the server itself.
Luis Salgado
Luis Salgado
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 20
Hi, I can't get to work any of the 3 versions of this procedure.
With the first presented here (http://www.sqlservercentral.com/articles/Development/2824/) by Jason Selburg:

Exec [data_driven_subscription] .........

Returned the error:
1 “The subscription contains parameter values that are not valid”


The first version from Matt (http://spilich.blogspot.com/2007/11/using-data-driven-subscriptions-in.html) and his second version on page 5 from this forum both return the same error:

exec  [Custom_data_driven_subscription] --(or exec [CustomDataDrivenSubscription] )
@SubscriptionID = '83A4FDAB-A41B-440F-89DA-C4E9DFE6FEB6',
@parameterNameLIST = 'STARTDATE|ENDDATE|PARAM_INT',
@parameterValueLIST = '1/2/2012|2/2/2012|100',
@ExtensionSettingNameLIST = 'TO|Subject',
@ExtensionSettingValueLIST = 'blablabla@blablabla.com|@ReportName was executed at @ExecutionTime',
@exitCode = @ResultID out,
@exitMessage = @ResultMsg out

Returned the error:
-2 “The subscription does not exist.”


I've tried everything, even new reports and new subscriptions but nothing works. Any help please?
Matthew Lehn
Matthew Lehn
SSC Veteran
SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)

Group: General Forum Members
Points: 223 Visits: 783
Luis Salgado (2/3/2012)
Returned the error:
1 “The subscription contains parameter values that are not valid”

Returned the error:
-2 “The subscription does not exist.”

I've tried everything, even new reports and new subscriptions but nothing works. Any help please?


Usually when I had this problem, the solution was to create a new subscription from within SSRS, but you said you've already tried this (?).

Zycon - The Search Engine for Manufacturers. Helping Engineers and Technical Buyers Locate Aluminum Extrusions, Metal Stampers, Plastic Fabricators, Valves, and More.
Luis Salgado
Luis Salgado
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 20
Yes, I did try that, but still the same result.
Matthew Lehn
Matthew Lehn
SSC Veteran
SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)

Group: General Forum Members
Points: 223 Visits: 783
Did you change the GUID (Subscription ID) in the calling procedure when you recreated the SSRS subscription?

Zycon - The Search Engine for Manufacturers. Helping Engineers and Technical Buyers Locate Aluminum Extrusions, Metal Stampers, Plastic Fabricators, Valves, and More.
Luis Salgado
Luis Salgado
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 20
:-) Yes, I've changed it every time. I'm pretty sure the GUID it's correct and that it exists, since I copy directly from the job name for the subscription.
Matthew Lehn
Matthew Lehn
SSC Veteran
SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)SSC Veteran (223 reputation)

Group: General Forum Members
Points: 223 Visits: 783
Unfortunately, I cannot figure out what may be causing your issues. Are you getting the "subscription" not found error, or "invalid parameter values" error?

I am currently not using DD subscriptions actively. In fact, I no longer had the SP, function, and table in the SQLDB. To try and track down the problem, I created the SP (from page 5 in this forum), including the fn_split UDF and CustomSubscriptionHistory table. I went to my development Report Server and then created a subscription. I then ran some sample code to change the subscription parameters and save the customized report. Everything worked flawlessly. I changed the parameters and ran it a second time. There were no errors.

Keep in mind I ran this as a DBA (in SQL 2008 Standard Edition). It is possible you have a permissions issue in your DB, although I would expect a different error in that case. It is also possible the Subscription is being automatically deleted after it's run. When you create the new subscription, schedule it for the past and to not run automatically in the future. Hope this helps!

Zycon - The Search Engine for Manufacturers. Helping Engineers and Technical Buyers Locate Aluminum Extrusions, Metal Stampers, Plastic Fabricators, Valves, and More.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search