Can Cognos Automatcially Terminate A Report After A Certain Time?

[TCM]

Is there a setting in Cognos that allows the termination of a report that has been running for a specified amount of time? For example, I had a report that ran for 2 hours due to an error (usually runs in minutes). I would like to set up something that monitors reports that are running and if they have been running for longer than say an hour, I would like it to be terminated so it doesn't hold up other reports from running.

Thank you!
-TCM

[MFGF]

Hi,

This can be done by altering the governor settings in Framework Manager, then republishing the package.

Regards,

MF.

[apontet]

I'm a DBA supporting a Report Net developer group (read newbie.)  Could you elaboate on the mechanism used to abort the query?  I know I can kill a session from withing Oracle but woulde rather use the tool's features as much as possible.

Thanks

[MFGF]

Hi,

To define the appropriate governor, launch Framework Manager, open the project file used for your reporting package, then from the menubar select Project --> Edit Governors.

Once you are in the Governors dialog, you can enter a Query Execution Time Limit (in seconds).

For the final step, expand the packages folder in the Project Viewer window, right-click your package, and republish it to your ReportNet server.

Any new reports written from this package will then inherit the governor you defined in Framework Manager.  For existing reports, you may need to open and save them in their originating studio (depending whether package versioning has been used).

Best regards,

MF.

[FatCat]

I heard somewhere that the Query Execution time is actually the wait time to receive a piece of data back from the database.  Not necessarily the entire wait time based on the end user.  This also may be split over the number of queries that are in a Report. 

In the administration portal there is a Query time limit that will be global for the system.

You can also do a double catch on Oracle to time out a DB connection based on CPU clock.



Just my thoughts.  Not 100% sure on the first part.

[TCM]

In my initial question, can you limit the time a report runs, I have found that you can do this easily in Cognos 8.1. Just go to Query Explorer and click on the query cube (Query1 for example). Then in the Query Properties (on the left hand side) under 'Query Hints' you'll see 'Maximum Execution Time' . Click on the ellipsis and select 'Value:', then type in the number of seconds you want as the maximum execution time. If the report doesn't complete withing the specified time, it fails with an error message like 'RQP-DEF-0112 Query execution time exceeds the 3600 second limit specified...'.

There was a similar feature in ReportNet under Query Explorer/Query1/Query Properties/Query Optimization. It's also called 'Maximum Execution Time', but I could never get it to work. No matter how long I specified as an execution time, the report would always execute past that time.

Hope this is helpful. Thanks to all how replied earlier!