Issue while executing SSRS report

  • jagtap.shreyas

    SSC Enthusiast

    Points: 115

    Hello,

    I am getting following error when trying to execute an SSRS report.

    Error -

    An error occurred within the report server database. this may be due to a connection failure, timeout or low disk condition within the database (rsReportServerDatabaseError). Transaction Count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0

    Query executes in less than 10 secs when tried through report builder.

    Please suggest what could be cause of this and what could be fix.

  • Sue_H

    SSC Guru

    Points: 90011

    jagtap.shreyas (10/17/2016)


    Hello,

    I am getting following error when trying to execute an SSRS report.

    Error -

    An error occurred within the report server database. this may be due to a connection failure, timeout or low disk condition within the database (rsReportServerDatabaseError). Transaction Count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0

    Query executes in less than 10 secs when tried through report builder.

    Please suggest what could be cause of this and what could be fix.

    Most likely something in the code used for the report. But without seeing that, it's just wild guesses.

    Sue

Viewing 2 posts - 1 through 2 (of 2 total)

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