I am getting following error when trying to execute an SSRS report.
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.