nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

BIRT Enginge somehow "kills" tomcat server

Max Bo

Hi, I have experienced the following issuem here: <ul class='bbcol decimal'><li>Apache Tomcat 7 boots up </li><li>BIRT reporting engine boots also </li><li>All reports are perfectly accessible via web browser and URL </li><li>After some time, the reports are no longer available, only the process bar "Processing, please wait ..." appears</li></ul>When I check the Tomcat server status, it shows many 'old' services and I am not sure, why they are still there (see attachment). Thanks for any advice on how to avoid this situation or to resolve it other than restarting the Tomcat server. Max

Find more posts tagged with

Comments

CBR

Are you using the JDBC Query Builder within your BIRT reports?Looks like a deadlock to me.

Max Bo

No, I am using the 'SQL Select query'

Max Bo

Could it be related to a timeout of a session? I had several people here just running the report and after the 30 minute session timeout, the system started to produce the POST entries.

CBR

What's your BIRT version? Are you using the OSGI runtime or the non osgi runtime? Could you increase heap size? Ive seen that it just runs using 500MB heap. I usually run BIRT using 2GB of heap and i m also increasing permGen if i m using the osgi runtime. This is not to be a general suggestion like: Always set server heap to 2GB if you want to run BIRT on it. The value to be set depends on number of concurrent users, concrete reports (are you doing a lot of heavy data manipulation tasks in BIRT) and many other factors!

Max Bo

I have found the reason: your first idea was right, it is a deadlock of two queries. I am using Pentaho Kettle in the background for pre-calculation and for some reason, it is a producing a deadlock in conjunction with the queries run by BIRT. Guess I'll have to investigate that the coming days ... But one more question: you mentioned to increase the memory values. Could you please point me to the place where to change it? Is it in the configuration console of the Apache Tomcat?

CBR

Hi Max, glad that you could solve your problem! Problems like that are really hard to find. Regarding your question:Yes this is a configuration value for the tomcat. How do you run your tomcat? Windows service or do you simply start it "manually" by executing the bat or sh file?

Max Bo

Hi, I am executing Tomcat as a service and usually use the Tomcat Monitoring for setup (see attachment).

CBR

The heap can be configured using the fields Initial memory pool and maximum memory pool.The Java virtual machine that is executing the server and therefore your BIRT webapp has two parameters the can configure the heap size:initial heap size and maximum heap size. Initial heap size is the amount of memory the jvm allocates at startup, maximum heap size is the amount of memory you want the jvm to use at max. If you change the values you have to restart the server.