none
"Pending" status for Data-driven Subscription

    Question

  • An issue with the 'Status' column of the 'Subscription' tab in the Report Manager.
    I created Data-driven Subscriptions for some of the reports, and I scheduled the reports using shared schedule. The scheduling is working fine and all the reports are getting generated daily.
    The issue is with the status of the report subscriptions under subscription tab, it shows as PENDING even after the report is generated.
    I restarted the ReportServer database, it didn't served my purpose. The status never changes .

    When do the subscription status changes to PENDING?
    What needs to be done to change the PENDING status?
    Is this the bug with the Report Manager?

    Appreciate your timely help. TIA
    Thursday, May 10, 2007 3:26 PM

All replies

  • Did you find a solution for this? I'm having the same issue.
    Thursday, June 07, 2007 4:01 PM
  • I didn't find any solution yet. If you find any, do share the same .
    Thursday, June 07, 2007 4:21 PM
  • There seems to be a SOAP Solution, But I've never used SOAP (Except in the Shower..LOL..sorry lame joke) , I'm having a hard time getting the MSDN Example to work. I can't get vb to recognize the ReportingService2005 class. heres the link if you want to take a look.  http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.listsubscriptions(SQL.90).aspx

     

    Code Snippet

    Dim rs As New ReportingService2005()
            rs.Credentials = System.Net.CredentialCache.DefaultCredentials

            Dim extSettings As ExtensionSettings
            Dim desc As String
            Dim active As ActiveState
            Dim status As String
            Dim eventType As String
            Dim matchData As String
            Dim values As ParameterValue() = Nothing
            Dim subscriptions As Subscription() = Nothing
            Dim extensionParams As ParameterValueOrFieldReference() = Nothing

            Try
                subscriptions = rs.ListSubscriptions("/SampleReports/Employee Sales Summary", "myDomain\myUserName")

                If Not (subscriptions Is Nothing) Then
                    ' Retrieve properties for the first subscription in the list.
                    rs.GetSubscriptionProperties(subscriptions(0).SubscriptionID, extSettings, desc, active, status, eventType, matchData, values)

                    Console.WriteLine("Description: {0}", desc)
                    Console.WriteLine("Status: {0}", status)
                    Console.WriteLine("EventType: {0}", eventType)
                    Console.WriteLine("matchData: {0}", matchData)
                    Console.WriteLine("Extension: {0}", extSettings.Extension)

                    extensionParams = extSettings.ParameterValues

                    If Not (extensionParams Is Nothing) Then
                        Dim extensionParam As ParameterValueOrFieldReference
                        For Each extensionParam In extensionParams
                            Console.WriteLine((CType(extensionParam, ParameterValue).Name + ": " + CType(extensionParam, ParameterValue).Value))
                        Next extensionParam
                    End If

                    If Not (values Is Nothing) Then
                        Dim pv As ParameterValue
                        For Each pv In values
                            Console.WriteLine("Name: {0}", pv.Name)
                            Console.WriteLine("Value: {0}", pv.Value)
                        Next pv
                    End If
                End If

            Catch e As SoapException
                Console.WriteLine(e.Detail.OuterXml)
            End Try

     

     

    Thursday, June 07, 2007 4:31 PM
  • Any help on this issue?

    Monday, August 27, 2007 10:10 AM
  • Are you sure that this isn't a client-side caching issue in your browser?  That would potentially out-last restarting the reportserver database. 

     

    IAC if you are seeing "Pending" In your browser, whether it is browser-cached or webapp-cached this would not have much to do with restarting the database.  Even server-side it could be the ReportManager webapp that is caching the value.  IOW, if it is a server-side cache, and if you restart the RS instance (rather than the database) you would see the change.

     

    >L<

     

    Monday, August 27, 2007 3:39 PM