Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««56789

Data Driven Subscriptions Updated Expand / Collapse
Author
Message
Posted Tuesday, November 29, 2011 1:46 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 08, 2011 4:42 PM
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.
Post #1213536
Posted Tuesday, November 29, 2011 2:55 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, April 14, 2014 6:59 AM
Points: 219, Visits: 629
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.
Post #1213586
Posted Tuesday, November 29, 2011 4:41 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 08, 2011 4:42 PM
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.
Post #1213611
Posted Wednesday, November 30, 2011 12:26 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 08, 2011 4:42 PM
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.
Post #1214177
Posted Friday, February 03, 2012 11:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 27, 2012 9:36 AM
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?
Post #1246664
Posted Friday, February 03, 2012 11:15 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, April 14, 2014 6:59 AM
Points: 219, Visits: 629
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.
Post #1246666
Posted Friday, February 03, 2012 11:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 27, 2012 9:36 AM
Points: 4, Visits: 20
Yes, I did try that, but still the same result.
Post #1246668
Posted Friday, February 03, 2012 11:28 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, April 14, 2014 6:59 AM
Points: 219, Visits: 629
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.
Post #1246675
Posted Saturday, February 04, 2012 2:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 27, 2012 9:36 AM
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.
Post #1246872
Posted Tuesday, February 07, 2012 1:23 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, April 14, 2014 6:59 AM
Points: 219, Visits: 629
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.
Post #1248480
« Prev Topic | Next Topic »

Add to briefcase «««56789

Permissions Expand / Collapse