CODEWITHSUNDEEP
reporting-servicessubscription
Usman
Usman

Reputation: 101

SSRS Subscription fails "Thread Being Aborted"

I have a huge report which works fine when I browse through report viewer. I have created a subscription so I can run this in the background. The subscription works if it's the only subscription running. If I run 2 subscriptions starting at the same time and pointing to the same report, the thread is aborted for one subscription and the other one works.

I have tried all suggestions with the configuration keys in rsreportserver.config, but no luck.

Upvotes: 8

Views: 11158

Answers (2)

SherlockSpreadsheets
SherlockSpreadsheets

Reputation: 2370

The issue for me was a timeout setting. In the report portal in the Report Properties management page the default settings is "Use the system default setting". I changed this to "Allow report to run for 3600 seconds before timing out", and then the report completed successfully. I believe the default setting is 1800 seconds(30 minutes) so changing to 3600 seconds (60 minutes) give the report enough time to complete.

Upvotes: 0

Usman
Usman

Reputation: 101

Yes, it was the resources issue. it's to do with the RAM. If it takes up to 90% then SSRS restarts, hence losing the thread.

Upvotes: 2

Related Questions