Post reply

SSRS Subscription Failure

  • April 18, 2014 at 9:33 am

    #284680

    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

  • April 18, 2014 at 12:58 pm

    #1707163

    What type of subscription are you trying to create? File system or Sharepoint?

    How often does it run/error out?

    - Tony Sweet

  • April 18, 2014 at 1:19 pm

    #1707171

    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.

  • April 18, 2014 at 1:24 pm

    #1707173

    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

  • April 18, 2014 at 1:49 pm

    #1707181

    Thanks for the response. Let me try to workaround it in the alerting

    Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply