Post reply

SSRS 2005 - Cannot read the next data row for the data set.

  • June 20, 2015 at 8:22 pm

    #398626

    Hi,

    I'm working on SSRS 2005 and new to reports, I have developed a report and deployed in one of our environment. For the few days we are able to see the report without any issues but suddenly I'm getting the following exception in the reports,

    [font="Courier New"]An error has occurred during report processing. (rsProcessingAborted) Get Online Help

    Cannot read the next data row for the data set "MYDATASETNAME". (rsErrorReadingNextDataRow) Get Online Help

    For more information about this error navigate to the report server on the local server machine, or enable remote errors[/font]

    Report doesn't have any parameters in it & SP which used in the report also doesn't have any parameters.

    Please guide me on this issues.

    ___
    Known Is An Drop,Unknown Is An Ocean....
    Njoy Programming     🙂

  • June 21, 2015 at 11:16 pm

    #1806930

    The ReportServer logs should be able to give you a more verbose error description. When I get this error the most common reason is the query is hitting a deadlock.

  • June 22, 2015 at 12:14 pm

    #1807144

    Thanks Doug.Brown, But I'm using NOLOCK in my select query.

    ___
    Known Is An Drop,Unknown Is An Ocean....
    Njoy Programming     🙂

  • June 22, 2015 at 1:23 pm

    #1807171

    That is why the Report Server logs are so important. One can guess that it is a deadlock issue but that is only a guess. The logs will have have more detailed information.

    Joie Andrew
    "Since 1982"

  • June 23, 2015 at 3:00 pm

    #1807570

    Thanks a lot Doug.Brown & Joie Andrew, I Fixed this issue by going through log file.

    Root Cause : I have missed the "GO" between my SP Script & GRANT EXECUTE Script. :crazy:

    ___
    Known Is An Drop,Unknown Is An Ocean....
    Njoy Programming     🙂

  • November 9, 2016 at 3:20 am

    #1911357

    Thanks windows_mss

    Your reply helped me.

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

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