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 Subscriptions Failing Expand / Collapse
Author
Message
Posted Thursday, October 10, 2013 2:06 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 1:46 AM
Points: 24, Visits: 334
I have several subscriptions that fail intermittently - some days they work, others they don't. I have looked through the SSRS log files but it is as though the subscription doesn't even start? There are no errors.

The status in the Subscriptions table simply says "Pending" or "The delivery extension for this subscription could not be loaded."

Has anyone come across this before?

I am running SQL 2008 R2 SSRS via Scaled-Out deployment across a cluster.
Post #1503402
Posted Thursday, October 10, 2013 12:50 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 3:59 PM
Points: 179, Visits: 7,392
We had a similar issue at our workplace and it was tracked down to the two cluster servers not having the same configuration. See if your clustered servers are on the same Windows version and if the settings and permissions are the same on both.
Post #1503747
Posted Thursday, October 10, 2013 2:16 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 6:57 AM
Points: 21, Visits: 306
Pleases Keep in mind SSRS is not cluster aware. For Example time of Subscription Node1 failover to Node 2 then your subscription don't work. You need to failover Node 1 back to Node 1
Post #1503796
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse