Post reply

error with ssrs

  • December 15, 2016 at 1:19 pm

    #316789

    We have a developer that has powershell script that generate SSRS reports. Previously it is fine. But recently he got the below message:

    CreateReports Error: Exception calling "Refresh" with "0" argument(s): "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)"

    It seems to be occurring on reports that take a long time to generate.

    I checked there is no diskspace issue, the server runs fine. and no SQL error log related.

    Any people have the same experience before?

    THanks

  • December 15, 2016 at 2:49 pm

    #1918298

    sqlfriends (12/15/2016)

    We have a developer that has powershell script that generate SSRS reports. Previously it is fine. But recently he got the below message:

    CreateReports Error: Exception calling "Refresh" with "0" argument(s): "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)"

    It seems to be occurring on reports that take a long time to generate.

    I checked there is no diskspace issue, the server runs fine. and no SQL error log related.

    Any people have the same experience before?

    THanks

    Not sure what that script is doing, but it may be possible that a database connection is timing out, and that the report as generated has a data source where the connection timeout is being exceeded. Without a lot more details, however, that's just a guess.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • December 19, 2016 at 6:06 am

    #1918653

    In the web.config file is one parameters: httpRunTime ExecutionTimeout .

    In rsreportserver.config is the Parameter DatabaseQueryTimeout

    Check to see if these values are appropriately set for your Environment / Report.

  • December 19, 2016 at 8:51 am

    #1918700

    Thank you, let me check it

  • December 20, 2016 at 7:00 am

    #1918903

    sqlfriends (12/19/2016)

    Thank you, let me check it

    I forgot, both should ideally have the same value (in seconds) otherwise one could timeout before the second has finished.

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

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