"Pending" status for Data-driven Subscription

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
Did you find a solution for this? I'm having the same issue.|||I didn't find any solution yet. If you find any, do share the same .
|||

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

|||

Any help on this issue?

|||

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<