locked
Status of a report stays at "pending" RRS feed

  • Question

  • Hi,

    I have a report in SSRS 2008 and it has been working fine for months. Today I am having an issue with it where the status of the report is not changing from "Pending" in the Subscriptions table in the ReportServer database. The reports are being generated correctly. There is nothing in the logs that indicates why this is happening. There is no failures. I have restarted the SSRS service and rebooted the server but this problem is continuing. Even after the report is reset, the reports are generated again but the status remains at "Pending". Other reports are working fine on the same server.

    Any ideas about anything else I can investigate for this report?

    Many Thanks

    Saturday, August 13, 2011 7:44 PM

Answers

  • FYI

    Updating every record (owned by and last modified by) referring to the user who left two years ago resolved this issue. No idea why this became an issue. SQL Server SP2 was installed on the server ~ 7 days ago, which might be related but the reports were running fine for the past 6 days.

    • Marked as answer by Jones-London Friday, August 19, 2011 8:27 AM
    Monday, August 15, 2011 8:44 AM

All replies

  • Just noticed the following error in the logs:

    library!WindowsService_2!112c!08/14/2011-15:10:36:: e ERROR: Error processing data driven subscription: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'USER-ABC' is not recognized.
       at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
       at Microsoft.ReportingServices.Library.SubscriptionDB.SetProcedureParameters(InstrumentedSqlCommand command, SubscriptionImpl subscription)
       at Microsoft.ReportingServices.Library.SubscriptionDB.UpdateSubscription(SubscriptionImpl subscription)
       at Microsoft.ReportingServices.Library.DataDrivenSubscriptionHandler.DataDrivenSubscriptionWorker(Object o)

    USER-ABC has been gone from the company for over 2 years and is not the owner of the subscription that's failing. Report has been working fine since the user left until today.

    The user owns one subscription which isn't even in use. Will update that one to see if it makes a difference.

    Has anyone else come across this issue?

    Sunday, August 14, 2011 5:30 PM
  • FYI

    Updating every record (owned by and last modified by) referring to the user who left two years ago resolved this issue. No idea why this became an issue. SQL Server SP2 was installed on the server ~ 7 days ago, which might be related but the reports were running fine for the past 6 days.

    • Marked as answer by Jones-London Friday, August 19, 2011 8:27 AM
    Monday, August 15, 2011 8:44 AM
  • Hi Jones-London,

    It is a normal exception which can be caused by various reasons.

    ·         Data Driven and Normal subscriptions fail to send since moving to new Network Load
    Balanced Report Server environment. Data Driven subscriptions are left in a Pending
    status, and normal subscriptions sometimes give a user or group name is not
    recognized error. A Data Driven subscription can comprise of between 1 and 2000
    emails being sent internally and externally.

    ·         The owner of the subscription has gone.

    From your last posted information, we are ensured that it is caused by referring a non-existent user 'USER-ABC'. The Reporting Services stored users with users’ SID. When the subscription was triggered, the Reporting Services will use the method “LookupAccountName” in Windows API to get the user’s SID. the API can’t get the SID of the user, the Reporting Services will throw the exception.

    Thanks,
    Lola


    Please remember to mark the replies as answers if they help.
    Wednesday, August 17, 2011 2:13 AM