Rule Set Does Not Start the Second Rule of the Rule Set if the First Rule Takes Longer Than 1 Hour [ID 989185.1]

---

 

 

Applies to:

Hyperion Planning - Version: 11.1.1.2.00 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms

Business Rule set stops if one or more Business Rules exceed 1 hour.

Calcmgrserver.log error
------------------------ 
Find this error message in the calcmgrserver log file 
2009-10-14 12:04:46,030 WARN TP-Processor3 org.apache.commons.httpclient.HttpMethodBase - Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended. 
2009-10-14 12:04:46,045 INFO TP-Processor3 com.hyperion.calcmgr.common.GenericLogger - Product URL for application 'OBITRN01': http://WDE000L90000110:8300/HyperionPlanning/servlet/HspAppManagerServlet?appname=OBITRN01 
2009-10-14 12:05:17,529 WARN TP-Processor3 com.hyperion.calcmgr.database.DBConnectionManager - Bei der Verbindung ist eine Zeit�berschreitung aufgetreten. Es wurden 29999 Millisekunden gewartet und die Zeit�berschreitungsperiode von 15000 wurde �berschritten 
2009-10-14 12:05:17,529 WARN TP-Processor3 com.hyperion.calcmgr.database.DBConnectionManager - 

 

 

Cause

There is a timeout in the JDBC connection between Calc Manager and the Database.  

Solution

Increase the Planning web session timeout to a number larger than the time it takes to execute the rules in the sequence.

The planning web session timeout is controlled by the entry "60" in the web.xml available under WEB-INF folder where planning is deployed.

To change the session timeout setting: 

1. Open the timeout setting file for your Web application server. 
For example, in Apache Tomcat 5.0.28, open the web.xml file in the driveletter:\Tomcat 
\conf directory.

2. Modify the timeout setting for the Web application server, and save your changes. 
For example, for Apache Tomcat 5.0.28, change the number 60 in the session-timeout setting 
to the number of minutes to use. 
To modify timeout settings, see the documentation for your Web application server.