Skip to Content
author's profile photo Former Member
0
Former Member

Reports Server - dynamic reconfiguration needed for long-running reports

Posted on May 04, 2011 at 06:06 PM 9 Views

We have a need to permit users to submit large reports via scheduler from the hours of 8 pm to 2 am.

These reports currently fail due to the daytime configuration limits on the row count and the elapsed time.

I guess effectively we need to stop, change the config, and restart the reporting servers to expand the day-time row and elapsed time limits that are imposed.

Can this be done thru the CMC API or is there a better way to accomodate this need via Powerscript or some other mechanism ?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Sebastian Wiefett
    Sebastian Wiefett
    Posted on May 05, 2011 at 08:39 AM
    0

    Hi,

    you could create a Servergroup and add new Report Servers to this Group. Configure the Servers as you wish and assign this Group to your scheduled Reports.

    Regards

    -Seb.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Sebastian Wiefett
      May 05, 2011 at 01:43 PM

      I've read about the CMC and it's SDK....is that the way to go ?

      Or can this be scripted by simply turning off each server process, swapping a new configuration file, and restart the processes ?

      There's got to be a way to do this....I find it hard to believe no one else has this need.

      It just makes sense: you want to prevent long-running queries during the day to keep response time low, and then let them rip overnight when interactive users are few.

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.