SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSRS Subscription Failure


SSRS Subscription Failure

Author
Message
Kapaleeswar
Kapaleeswar
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 20
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
Tony Sweet
Tony Sweet
Valued Member
Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)

Group: General Forum Members
Points: 71 Visits: 66
What type of subscription are you trying to create? File system or Sharepoint?

How often does it run/error out?

- Tony Sweet
Kapaleeswar
Kapaleeswar
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 20
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.
Tony Sweet
Tony Sweet
Valued Member
Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)

Group: General Forum Members
Points: 71 Visits: 66
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
Kapaleeswar
Kapaleeswar
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 20
Thanks for the response. Let me try to workaround it in the alerting

Thanks
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search