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

SSRS Subscription Failure Expand / Collapse
Author
Message
Posted Friday, April 18, 2014 9:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 22, 2014 3:29 PM
Points: 3, Visits: 13
Hi

In the Report subscription, am getting the error as “Failure Writing file: An Error has occurred during report processing” . However the same subscription getting completed after 20 minutes.
Can you please help me to fix why this intermediate error message being updated in the status when report actually running it in background ?

Actually I have created data alerting on the failures, hence it sending out the fake alerts after getting the error message.

Thanks in advance.

Thanks
Jey
Post #1563078
Posted Friday, April 18, 2014 12:58 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 30, 2014 6:38 AM
Points: 33, Visits: 65
What type of subscription are you trying to create? File system or Sharepoint?

How often does it run/error out?


- Tony Sweet
Post #1563142
Posted Friday, April 18, 2014 1:19 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 22, 2014 3:29 PM
Points: 3, Visits: 13
I am getting in both types (File System and sharepoint). Initially was getting this with file system, thought it was some access issue due to network hiccups but when i try it with Sharpoint also getting the error.

Its not always having issues may be out of my 6 runs i got it for 2 times.
Post #1563151
Posted Friday, April 18, 2014 1:23 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 30, 2014 6:38 AM
Points: 33, Visits: 65
SSRS Is hard to debug because the errors are pretty cryptic. From my experience, I have seen similar issues with file system subscriptions and it was network related. We still get them from time to time, so have change our alerting to only alert if there are two errors in a row.

- Tony Sweet
Post #1563154
Posted Friday, April 18, 2014 1:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 22, 2014 3:29 PM
Points: 3, Visits: 13
Thanks for the response. Let me try to workaround it in the alerting

Thanks
Post #1563165
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse