MS SQL Server :: SQL Reporting And Delivery

SQL Reporting Services Delivery Extensions For Email. Not Working, Please Help.

Jan 10, 2007

In Sql Reporting Services 2005 (This is bolded because this same error is all over the web for Sql Reporting Services 2000 and thats not where my problem lies) I schedule a report to be emailed. However when the delivery extensions Deliver method is called I get the following error

Failure sending mail: The report server has encountered a configuration
error. See the report server log files for more information.

In the log it shows the following

ReportingServicesService!emailextension!4!01/10/2007-12:21:01:: Error sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The report server has encountered a configuration error. See the report server log files for more information. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information. at Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid) at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName) at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken) at Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation) at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc) at Microsoft.ReportingServices.Library.RSService._GetReportParameters(ClientRequest session, String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials) at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters) at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute() at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() --- End of inner exception stack trace --- at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) at Microsoft.ReportingServices.Library.ReportImpl.Render(String renderFormat, String deviceInfo) at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data) at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification) at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)

So it seems to be failing at GetAuthzContextForUser

I've set up my smtp as out domain email smtp, given the accounts all the permissions I could (Even going to far as to give Everyone permissions everywhere)
Currently my IIS, SQL 2005 and reporting Services 2005 as well as my local SMTP is running on the local machine account.

I cannot seem to get it to work, or even give me a different error.

Could anybody please tell me what needs permission where and what settings I need to have set up for this not to happen.

Some extra information

I'm using Windows XP to develop on however the server where this will eventually run is Windows Server 2003

I'm using ASP.NET 2 and SQL Reporting Services 2005 and SQL 2005 with sp1 loaded

Any help would be appreciated

View 1 Replies View Related

Reporting Services E-mail Delivery Extension Error

Jan 24, 2007

Hi guys!

I am having a problem with the e-mail delivery extension in MS SQL Reporting Services 2005. I have some reports that use an Oracle data source. When running the reports through Report Manager the data source works fine and the reports display properly. But when running an automatic e-mail delivery of the reports through a subscription I get the following error message (in the ReportServerService log file):

System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

Doesn't this seem strange when the reports run in Report Manager but not when I send the reports through e-mail? I have Oracle Instant client v. 10.2.0.3 installed on the machine. I am wondering if the e-mail delivery extension has an account that needs privilegies to the oracle client home directory or something like that. Any ideas?

Thanks!

/Stefan

View 4 Replies View Related

Reporting Services :: Split Report Into Multiple PDFs During Windows Fileshare Delivery

Jun 3, 2015

I have a report that groups a particular dataset by customer, with a page break between each customer. If print this report, it looks great - one page per customer.

What I would like to do is have the report deployed on schedule to a windows file share, one .pdf file per customer. How to parse the output into individual .pdfs (one per customer) instead of a single .pdf containing all customers? I get it if this is not possible.

My current (painful) workaround would be to replicate the report for each potential customer, and set a schedule for each report to deploy sequentially. (Customer 1 at 9:00, Customer 2 at 9:01, etc).

Currently on SQL Server/Visual Studio 2008.

View 2 Replies View Related

Reporting Services :: Interface Code Compatibility Between Custom Delivery Extension Of SSRS 2008R2 And SSRS 2012?

Sep 3, 2015

Currently we are using Custom Delivery Extension for SSRS 2008R2 We are planning to move it SSRS2012

My Question is: Whether we can use the same Code used for SSRS2008R2 to SSRS2012?

if not what code changes we should do?

View 3 Replies View Related

BCP Delivery The: � Character

Dec 8, 2004

Using the BCP utility ->

With a degree character in the flat data file, can anyone deliver this to a table without SQL Server changing it to stacked bar: �

CREATE TABLE "dbo"."F_conv"
(
"col1" VARCHAR(21) NOT NULL
)
;

myformat.fmt

8.0
1
1SQLCHAR030"
"1col1""

mydata.dat file

1332 NS 4� Tall 32 oz

bcp command

bcp "MY_DB"."dbo"."F_conv" in "mydata.dat"
-q -S<server> -Usa -Psa -f"myformat.fmt"

View 3 Replies View Related

Report Delivery

Mar 27, 2007

hi all,
I have created a report using sql server 2005 RS.Ive deployed it in the server(localhost)also.In the subsription section of the report manager ive mentioned a emailid to whom ive to send the report.Ive selected the report server email delivery method from the dropdown list.After entering the emailid and scheduling the report and when i click ok i find that the report was not delivered.Im getting this error.

Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.

I culdnt find enything in the log files.

Can any1 help me as how to accomplish this?

Balaji

View 2 Replies View Related

FTP Guaranteed Delivery

May 4, 2006

Hi,

I'm new to SSIS but have been using BizTalk for a while. My question is, if the FTP task in SSIS ensures guranteed delivery of the files transferred. I know that in BTS, potnetially you can start processing incomplete files (unless you set the staging, temp folder). Can this be a problem in SSIS FTP transfer? I'll be dealing with very large files (5 gigs in some cases) transfers via FTP, on an unreliable network in my project, which means that the file can be partially transferred when the connection breaks down.

I need to know, if in SSIS

(1) FTP task supports partial transfers, and then resuming the download/ upload of these files from point of failure, when the network is again available (Regets, Reputs)?

(2) If EOF is received, before the rest of data is received, especially in the case if 1) is supported, then does FTP task believe that whole file is received or will it wait for the rest of content, before task completion?

I'll appreciate if someone can answer these and can also send me the details of FTP implementation in SSIS

Thanks,

Ali Shahzad

View 1 Replies View Related

Email Delivery

Apr 11, 2007

I'm using the web service to run reports from an application. However, I don't want to wait for a report to complete; I would like to just have the report emailed to the user when it is complete. I've only found email delivery through subscriptions. Is there another way to deliver reports via email?

If I have to use subscriptions I would like to set them to run "immediately". I've found that setting the start date to sometime in the past does not seem to run the report. Is there some way to set a schedule to run immediately. I've thought of setting the time to the near future, but I seem to have the problem of getting the proper timestamp. Can I get this through the web service some how?

Thanks,

Sam

View 1 Replies View Related

Report Delivery -- HELP

Mar 16, 2007

Is SSRS limited to delivering reports to recipients inside your domain (active directory)? I'm using an SMTP server for report delivery an have set the SendMailToUserAlias to False and still can only send reports to e-mails with my domain (user@mycompany.com). I need to send reports to recipients outside my company -- is SSRS capable? If so, how do I configure it to do so?

View 1 Replies View Related

Xp_Sendmail And Delivery Receipts

May 21, 2008

I am trying to send an email out, from an SQL Server with Microsoft Office 2000 Premium (Professional also available) (could have option for Office
2003 also) installed on it (only outlook is installed, however we can change
that) It's Windows 2k3 running Microsoft SQL 2000 server SP 4.

I need to be able to, via SQL (or a stored procedure) automate sending of emails out via xp_sendmail or some other system, with delivery receipts attached to them, so that when they hit the client's server we know it. I can get it to send a delivery receipt when remoting into outlook and sending an email through outlook automatically, however it does not attach one to the ones going out with xp_sendmail. I know there's a way to do it via ASP.Net, but I'd much prefer to have a job that goes out and finds which emails need sent, and have the database server auto make the email, and sent it out on our behalf, instead of requiring someone to go in and click sends, and such via ASP.Net.

Any help will be greatly appreciated.

View 2 Replies View Related

Once Only Delivery (high Availibiltity) ?

Jul 27, 2006

Hi There

I was wondering if someone could elaborate (or provide a link) on how the once only delivery works for servcie broker.

For example you have DB1 that sends messages to DB2. DB1 has corruption at 1pm, you retore the database to 12:30pm, this will have all the messages that were in this instance at 12:30 , however between 12:30 AND 1PM several successful messages were sent. These messages are in the restored DB1 queue, they get sent again?

How does service borker ensure that these messages are not processed again. The only thing i can think of is that the inititator or target keep a complete history of messages processed. But surely this "table" would get huge and slow down servcie broker if it had to check this tale every time a message is sent or received.

I cannot find much in BOL on this topic, or maybe i cannot find the topic.

Thanx

View 1 Replies View Related

What Is The Best Solution For Delivery Of The Big Tables?

Aug 31, 2006

Hi!

Well..

I've several big tables which take part in the merge replication (web synchronization is used)

Is there any *painless* solution to delivery these tables to the subscribers?

Otherwise I've the snapshot with dozens of Mb..

Yes, the Parameterized Row Filters can be used, but sometimes it's necessary to get the whole table

Thanks

Paul

View 6 Replies View Related

Trigger A Delivery Directly

Aug 24, 2007

I have a delivery extension that prints to network printers.
Now I add a subscription like a few minutes in the future via web service for each report to print.

Is there a way I can trigger the delivery directly?

Thanks for ideas, guys.

Michael

View 3 Replies View Related

Question Abt Turning On Svc Brker For Msg Delivery

Apr 4, 2008

hello,

I am trying to enable service broker by issuing this command:

USE master ;
GO
ALTER DATABASE msdb SET ENABLE_BROKER ;
GO

It is taking a while to do that and I am wondering whether msdb needs to be in single user mode? Some smaller dbs completed right away. Going through Surface area config I got a message that I need a service broker endpoint and I looked at my other db and that has dbmail functioning and same message saying this instance needs an endpoint in surface config, what do you think is wrong?

View 1 Replies View Related

SSRS 2005 E-mail Delivery

Mar 14, 2007

I have a report server set with an smtp account with Alias set to False but will not allow me to send e-mail outside the network. E-mail report delivery works fine to any e-mail with @mycompany.com but to an e-mail like @hotmail.com it gets rejected saying e-mail not recognized. I tried all config possibilities know to this man but nothing works. If long into the smtp server itself I can send e-mails outside of company. I'm thinking it may require a password from SSRS config but there is no place to put one. Any one know how to config SSRS to deliver e-mails to any and all e-mails accounts?

View 1 Replies View Related

On Demand Push Delivery For The Reports

Jun 12, 2007

I have a report which is scheduled to run every monday morning and it generates PDF and writes it to a shared location. Shared location and schedule is defined through Subscription. All this is working fine so far. Now I need to provide a facility from the webpage to execute this scheduled task on demand. So there would be a button on the website which would actually run this scheduled task and update the PDF at the shared location. How do I run this scheduled task/subscription using the vb.net code. Is there anything in ReportService2005 or ReportExecution2005 webservice? Please advise.

Thanks

View 3 Replies View Related

Printer Delivery Sample Modified

Jan 3, 2008

I am trying to modify the Printer Delivery Sample (RS 2005).
The original sample works fine: there was no any problem with deployment and running it.

What I need to accomplish is saving each delivered report as a local XML file.

For now (to start with), I'm just trying to read the rendered report as XML, and write the string (whatever the report contains) into a text file.

I added the following code to the PrintReport(...) method in the PrinterDeliveryProvider.cs file:

deviceInfo = String.Format(
System.Globalization.CultureInfo.InvariantCulture,
@"<DeviceInfo><OutputFormat>{0}</OutputFormat></DeviceInfo>",
"xml");
RenderedOutputFile[] testFiles = notification.Report.Render("XML", deviceInfo);

using (FileStream fs = File.Create(@"C: est est.txt"))
{
using (StreamWriter sw = new StreamWriter(fs))
{
sw.WriteLine("******************");

try
{
Stream streamTemp = (Stream)testFiles[0].Data;
byte [] byteData = new byte[streamTemp.Length];
for (int i = 0; i < byteData.Length; i++)
{
byteData[ i ] = (byte)streamTemp.ReadByte();
}

using (MemoryStream ms = new MemoryStream(byteData))
{
string result = Convert.ToBase64String(ms.ToArray());
sw.WriteLine(result);
}
}
catch (Exception ex)
{
sw.WriteLine(ex.Message);
}

sw.Flush();
}
}

After I re-deploy the modified assembly and create a simple subscription, it fires, and there are no exceptions. But instead of some good-looking XML in the test.txt file, I get this:

******************
///////////////////////////////////////////////////////////////////////////////////////////////////////////////

[Actually, there are much more slashes, but I am showing just the beginning of the file - for brevity...]

When I run this report in ReportManager and export it as "XML file with report data", that XML exported file looks exactly as I expect it to. So, the data is there, in the report, but how do I extract it?

I've been trying to figure out why I am not getting the real content of the report in XML format.
Maybe, this line is wrong: RenderedOutputFile[] testFiles = notification.Report.Render("XML", deviceInfo);
AND/OR this line is wrong: deviceInfo = String.Format(................etc.
AND/OR I am using a wrong method for converting the Stream to a string.
...or, something else?

Could someone kindly help me figure out what I'm doing wrong, please?

View 3 Replies View Related

Schedule And Delivery Processor Errors

Jul 23, 2007

Hi all,

We're running into some random errors on our reporting server (Windows Server 2003, SQL Server 2000 Enterprise). In the application logs, we're seeing several Schedule and Delivery Processor errors (ID 108)...one for each processing extension (FileShare, Excel, HTML, etc.). In the security logs, at the same time of day, are several failure audits with the following info:

EventID: 680
User: NT AUTHORITYSYSTEM
Description: Logon attempt by: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0. Logon account: sqluser.

The odd thing is that the schedules that are failing run perfectly about 98% of the time. Once every few weeks we have a situation like this and all of our reports (approximately 200 of them...mostly Excel, all of them sent via E-Mail) fail.

Any ideas as to what might be causing this, and why it would only happen occasionally? Any help would be appreciated! Thanks!

-Brian

View 3 Replies View Related

E-Mail Subscription Non Delivery Problem

Mar 19, 2007

I am having a strange intermittent problem sending reports via e-mail subscription. The report will be delivered only 20-25% of the time. I have checked the SQL logs, SQL Agent logs, System, App and Secuirty logs and see nothing obvious.

I put a network monitor on the reporting box and looked at all SMTP traffic. What happens is the reporting server connects to the SMTP box, sends the From Address and gets an OK, sends the To Address and gets an Ok. Next the reporting server sends a RSET command to the SMTP and it closes the connection.

No e-mail sent, but reporting services/SQL agent indicate success. Here is a log of the

409 25.765625 10.1.70.23 10.1.70.133 SMTP SMTP: Rsp 220 Wake County Email - Authorized Use Only, 45 bytes
410 25.765625 10.1.70.133 10.1.70.23 SMTP SMTP: Cmd sqlrptr, 14 bytes
411 25.781250 10.1.70.23 10.1.70.133 SMTP SMTP: Rsp 250-xxxxxxxxx.xxxxxxxxxx Hello sqlrptr ([10.1.70.133]), pleased to meet you, 106 bytes
412 25.781250 10.1.70.133 10.1.70.23 SMTP SMTP: Cmd FROM: xxxxxxxxx@xxxxxxxxx.xxx, 40 bytes
413 25.781250 10.1.70.23 10.1.70.133 SMTP SMTP: Rsp 250 xxxxxxxxx@xxxxxxxxx.xxx... Sender OK, 44 bytes
414 25.781250 10.1.70.133 10.1.70.23 SMTP SMTP: Cmd TO: <xxxxxxxxx@xxxxxxxxx.xxx>, 40 bytes
415 25.781250 10.1.70.23 10.1.70.133 SMTP SMTP: Rsp 250 xxxxxxxxx@xxxxxxxxx.xxx... Recipient OK, 49 bytes
416 25.781250 10.1.70.133 10.1.70.23 SMTP SMTP: Cmd RSET, Resets mail connection, 6 bytes
417 25.781250 10.1.70.23 10.1.70.133 SMTP SMTP: Rsp 250 Reset state, 17 bytes

Any suggestions?

View 1 Replies View Related

File Share Delivery Failing

Aug 22, 2007

I'm trying to deliver a report via the included File Share Delivery method. Every time the subscription fires, the delivery fails with this error in the interface:

Failure writing file Test.pdf : A logon error occurred when attempting to access the file share. The user account or password is not valid.

An in ReportServerService<dateTime>.log, I find the following error:

ReportingServicesService!library!10!08/22/2007-16:17:08:: e ERROR: Throwing Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider+NetworkErrorException: A logon error occurred when attempting to access the file share. The user account or password is not valid., A logon error occurred when attempting to access the file share. The user account or password is not valid.;
Info: Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider+NetworkErrorException: A logon error occurred when attempting to access the file share. The user account or password is not valid. ---> System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.GetImpersonationToken(String userName, String domain, String userPwd)
--- End of inner exception stack trace ---
ReportingServicesService!subscription!10!08/22/2007-16:17:08:: Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider+NetworkErrorException: A logon error occurred when attempting to access the file share. The user account or password is not valid. ---> System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.GetImpersonationToken(String userName, String domain, String userPwd)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.GetImpersonationToken(String userName, String domain, String userPwd)
at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.SaveReport(Notification notification, SubscriptionData d)
ReportingServicesService!subscription!10!08/22/2007-16:17:08:: i INFO: Error writing file Test.pdf to path \mrhowellSYSjunkjosh

I have tried using the <domain><user> username syntax. I have tried sending to multiple different machines. The only deployment that succeeded was to \localhostc$ est with administrator credentials entered into the Subscription (unacceptable, of course).

I've seen this issue raised on this forum at least twice, and neither was met with any ideas or answers. Has anyone encountered and overcome this issue?

View 9 Replies View Related

Insert Multiple Delivery Stops Per Shopment

Oct 17, 2007

I want to have a form where a user enter delivery information. On some orders there will be up to 20 stops. On my form I plan to have a popup to enter the extra stops. When they enter the first extra stop the window will close and then they click extra stop button again to enter the 3rd stop and so on. I am not sure how to save the data. I am coding in Visual Basic using SQL Server with .NET 3.5 and AJAX.Here are my two tables that are simplifiedTable DeliveryInformationPKDeliveryID FKStopsTable StopsPKStops CityStateZipCode

View 6 Replies View Related

Printer Delivery Extension For Standard Subscriptions?

Sep 18, 2007

I have installed the printer delivery sample and made the changes to the config files as described in the documentation but can only see it available as an option in the data driven subscriptions section. Anyone know how I can get it to show up in the standard subscriptions option?

Cheers,

Martin

View 4 Replies View Related

Email Delivery In Ssrs Developer Edition

Sep 21, 2007

is subscription using E-mail delivery possible in SSRS developer edition? act in the option for "Delivered By" in "New Subscription", only "Windows file share" is coming....

View 1 Replies View Related

Scheduling Report Delivery For The First WORKING Day In The Month?

Sep 16, 2007

Has anyone figured out a good way of doing this?

The only suggestions I have seen along these lines involve scheduling the job every day and then manually editing the SQL Agent job that is created.

However the problem with this is that it completely removes the ability for non programmers to set the schedule themselves using the web interface.

Any ideas?

View 1 Replies View Related

2005 Transactional Replication Statement Delivery

Oct 3, 2006

Hi There

WHen creating publciations under 2005 i saw a very interesting option under stament delivery, for inserts , updates , deletes there is an option that simply says insert/update/delete statement.

I could find very little in BOL about this under "Article Properties", is this what it soudns like ? FOr example if you say :

update Table set Cloumn = 'whatever', this will not trigger the update sp for each row at the subscriber , will it actually deliver the update statements and literally do the update/insert/delete statement at the subscriber?

Thanx

View 9 Replies View Related

Disabling Scheduled Report Delivery Conditionally?

Sep 16, 2007

Hi,

I am currently planning on using Reporting Services for delivery of reports, some of which in turn are reliant on an import from FTP via SSIS.

In the event that the FTP fails I would like the delivery of just the dependant reports to be cancelled for just that day.

Any advice on the best way of achieving this?

Cheers,

Martin

View 3 Replies View Related

How Do Set Printer Delivery Extension In RS2005 For Report Subscription

Mar 14, 2007

Can anyone help on this topic...

i need to set Printer Delivery Extension, and create a subscription for report which will be sent to the printer automatically

View 1 Replies View Related

E-mail Delivery Report By Trigger Or User Solicitation.

Dec 15, 2006

It's possivel delivery a report after trigger execution ou user solicitation?

Thanks in advance, Rui Figueiredo

View 1 Replies View Related

Programmatically Creating And Executing Data Delivery Extensions In SSRS

Nov 15, 2006

Hi All,

I have been stuck with this problem since few days, need help regarding the same. I am enclosing the problem description and possible solutions that I have found.

Can anyone please help me out here?

Thanks and regards,
Virat

Problem Description:

I have a requirement for which I have created a data driven subscription in
SQL Server 2005, the whole thing works like this:

I have a report on Report Server which executes a stored procedure to get
its parameters; then it calls another stored procedure to get data for the
report; then it creates the report and copies it to a file share. This is
done using data driven subscription and the time set for repeating this
process is 5 minutes.

You can assume that following are working fine:

1. I have deployed the report on the Report Manager (Uploaded the report,
created a data source, linked the report to data source) - manually, the
report works fine.

2. Created a data driven subscription.

3. The data driven subscription calls a stored procedure, say
GetReportParameters which returns all the parameters required for the report
to execute.

4. The Report Manager executes the report by calling a stored procedure, say
GetReportData with the parameters provided by GetReportParameters stored
procedure; after it has generated the report file (PDF) is copied to a file
share.

For each row that GetReportParameters stored procedure returns a report (PDF
file) will be created and copied to file share.

Now, my question is

1. How to I get a notification that this file was successfully created
or an error occurred?
2. The only message that reporting service shows on 'Report Manager >
My Subscriptions' is something like "Done: 5 processed of 10 total; 2
errors."
How do I find out which record was processed successfully and which ones
resulted in an error?

Based on above results (success or failure), I have to perform further
operations.

Solutions or Work around that I have found:

1. Create a windows service which will monitor the file share folder
and look for the file name (each record has a unique file name) for the
reports that were picked up for PDF creation. If the file is not found, this
service will report an error. Now, there's a glitch there; if a report takes
very long time to execute it will also be reported as error (i.e. when this
service checks for the PDF file, the report was currently being generated).
So, I can't go with this solution.

2. I have also looked at following tables on ReportServer database:

a. Catalog - information regarding all the reports, folders, data
source information, etc.
b. Subscriptions - all the subscriptions information.
c. ExecutionLog - information regarding execution of the subscriptions
and the also manual execution of reports.
d. Notifications - information regarding the errors that occurred
during subscription execution.

For this solution, I was thinking of doing a windows service which will
monitor these tables and do further operations as required.

This looks like most feasible solution so far.

3. Third option is to look at DeliveryExtensions but in that case I
will have to manually call SSRS APIs and will have to manage report
invocation and subscription information. What is your opinion on this?

My environment details:

Windows XP SP2

SQL Server 2005

Reporting Services 2005

Please let me know if I am missing something somewhere...

View 9 Replies View Related

SSRS 2005 Web Farm Error : The Delivery Extension For This Subscription Could Not Be Loaded.

Jun 22, 2007

We are using RS2005 for a year now and never had any problems especially with mail subscriptions.

Since we transferred from single RS machine to web farm everything works ok except mail subscriptions. Subscription sometimes (?!?!?!?!) refuse to export report to a document of any kind. I repeat that this is a random thing which is more often with PDF and less with Web Archive or Excel. We are using shared schedules and on demand execution of AddEvent stored procedure by night batches to send mail to users. Also, original error from RS log says something that this kind of operation is not supported for server working in native mode. We don't have SharePoint so we never used it in any other way then native mode and it worked.

Any idea will be appreciated!

Thanks in advance.

Update 26.06.2007

It seems that problem is not loading dll used to export report to a file but loading email subscription extension (dll that needs to be loaded for execution of email subscription.)

Original error from RS Log:

w3wp!library!1!06/22/2007-11:06:43:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: The operation is not supported on a report server that runs in native mode., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: The operation is not supported on a report server that runs in native mode.
w3wp!extensionfactory!1!06/22/2007-11:06:43:: e ERROR: Exception caught instantiating Report Server DocumentLibrary report server extension: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Microsoft.ReportingServices.SharePoint.SharePointDeliveryExtension.DocumentLibraryProvider' threw an exception. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: The operation is not supported on a report server that runs in native mode.
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.CreateExtensionObject(Extension extConfig).

View 6 Replies View Related

Transact SQL :: How To Get Date Where Planned Delivery Date Key Is Less Than Getdate

Aug 13, 2015

How to get the date where planned delivery date key is less than getdate()

I want to make a view where I want put the condition :

select CONVERT(datetime, CAST(planned_delivery_date_key AS CHAR(8)), 101) < CONVERT(datetime,getdate(),101)
from qlk_fact_sales_back_order

View 2 Replies View Related

To Access Reporting Sevices (Report Manager, Reporting Web Services), Does One Has To Be An Admin On The Machine

Mar 12, 2007

Hi There,

Our DBA has installed reporting services on a server and now in order to access the report manager, one has to be an Admin on that Server. I am guessing that there is a mistake in the configuration of Reporting Services. Usually it should allow anybody who was added to the roles in the properties section of the Report Manager, right? I have also added the users to the DB..

Also I am using Windows Authentication to access Report Catalog items (Reporting Services is installed on Server2) from a web Application(deployed on Server1) and displaying the report using report viewer. For some reason, server1 has to be in an Admin role on Server2 to access the report catalog/report. This is kinda strange for me as I don't want everybody to be an Admin on Server2. Can anybody please point in the right direction?

Thanks.

View 3 Replies View Related