question

don 2 avatar image
don 2 asked

SSRS Subscriptions

Hello, I’m in the process of teaching myself SSRS with SS2K5 SP3 and currently having a problem with setting up a subscription. The problem is I can’t find my report after the subscription runs, so I’m assuming something is not configured properly. Here’s what I have in my subscription…

Delivery by: Windows File Share

File Name: Report1

Path: [ a valid UNC path, folder is shared, EVERYONE has full control]

After I put in all of my subscription information a SQL Server Agent job is created. I right click and start the job and the job status ends with Success. So given that everything seems to work properly I go to the share specified in the subscription but there is no report. Given that I’m not getting any errors anywhere and everything seems to run properly I’m stumped.

Any help anyone can provide will be appreciated.

Regards, Stumped

ssrssubscriptions
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Pavel Pawlowski avatar image
Pavel Pawlowski answered

Take a look on the SSRS log for details. The job for the subscription mostly runs without errors as the only thing the job is doing is adding a record into the notifications table in the SSRS database. Then upon the notification record, SSRS service is processing the reports and delivers them based on the subscription details.

In the SSRS log file you will see any exceptions which could occur during report processing and delivery. As Rob Farley said here, the status of last subscription run you will see in the Subscription status in the SSRS manager. But details you will find in the log file on the SSRS server.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

dave ballantyne avatar image
dave ballantyne answered

Are you 100% sure you have executed the correct job ? Give that they have UUID names , it can be hard to tell , what is the job status in "My Subscriptions"

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Rob Farley avatar image
Rob Farley answered

Go to the report that the subscription is on, and look at the Subscriptions tab there. It should tell you the status of the last time it ran.

The job status may be success, but the subscription itself may have reported an error. SSRS isn't designed to make you look at the Agent Jobs to see how the subscriptions ran.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

don 2 avatar image
don 2 answered

Thanks to everyone who have offered advice.

As recommended I checked the subscription status, it says… “Failure writing file Report1 : The report server has encountered a configuration error. See the report server log files for more information.”

When I checked the "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__01_06_2010_09_48_21.log" file it didn’t show anything relevant, and actually didn’t seem to have been updated by the failed subscription process as the ‘Date Modified’ stamp was several minutes before I reran the subscription. Makes me wonder if I’m looking at the right log file!

I am running “SQL Server Reporting Services (MSSQLSERVER)” with a local account created specifically for starting SSRS, I have added it to the Administrators group so account privilege shouldn’t be the problem. Everything is on a single machine so again I don’t think that account privileges is the root cause of my problem.

I am running the subscription by starting the SQL Server Agent job; I know this is executing the subscription because the subscription Last Run date/time changes appropriately.

Again, any and all advice will be appreciated.

2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Pavel Pawlowski avatar image Pavel Pawlowski commented ·
You should look to log files starting ReportServerService__ In this log files you will see details about the failure and exceptions thrown during a report processing. Subscriptions normally start without any problems as I wrote in my original answer, as the job only inserts a record in the notifications table and SSRS processes the notifications.
0 Likes 0 ·
don 2 avatar image don 2 commented ·
Pavel, thank you so much. As you suggested I checked the ReportServerService__ log file and found this error "service account doesn't have rights to check domain user SIDs." I changed the service login account to a domain account, restored the encryption keys, and voila! everything works like it was meant to. Regards, Don
0 Likes 0 ·
Xeon avatar image
Xeon answered

Here is a fact that took us a while to figure out. The user you are using to write to the destination UNC must have Log On rights to both the Report Server machine and the machine of the destination path that you are writing the report to. This is in addtion to giving that same userID Read/Write permissions to the destination folder.

We just created a service account for SSRS and use that account for all our subsriptions.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.