Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Report Times out after 10mins
shamo
<p>How do I increase report run time in Birt 4.2? Report times out anytime run time exceeds 10mins. most of my reports have charts in them and my data source is Maximo. Need advice seems like nothing is working for me.</p>
Find more posts tagged with
Comments
wwilliams
<p>What kind of performance do you see running your query in Toad or in your SQL Server Query tool?</p>
<p> </p>
<p> </p>
<p><a data-ipb='nomediaparse' href='
http://www-01.ibm.com/support/docview.wss?uid=swg21318463'>http://www-01.ibm.com/support/docview.wss?uid=swg21318463</a></p>
;
<p> </p>
<p><a data-ipb='nomediaparse' href='
http://www-01.ibm.com/support/docview.wss?uid=swg21450051'>http://www-01.ibm.com/support/docview.wss?uid=swg21450051</a></p>
;
<p> </p>
<p>note: <b>ServerIOTimeout</b></p>
micajblock
<p>I would question any report that takes that long. There are many ways to optimize report generation time, Here are some ideas:</p>
<p><a data-ipb='nomediaparse' href='
http://developer.actuate.com/community/forum/index.php?/files/file/979-designing-high-performance-birt-reports/'>http://developer.actuate.com/community/forum/index.php?/files/file/979-designing-high-performance-birt-reports/</a></p>
;
shamo
<p>Thanks a lot mblock for your information. First issue is not with table reports because most of the table reports are at most 5 pages. Those run fast. Issue is with reports that have to do with charts. Actually, user requirement dashboards are the kind that can be done with report designer and the least has 3 charts and a table. Most of them have charts and gadgets and for a running 12 months and these in table reports don't even run because for 40rows per page, it runs into 1000s of pages. These are the reports that don't go beyond 10mins. Anyway to increase run time for it to not get page count errors?</p>
micajblock
<p>That is a Maximo internal question, hopefully Me. Are the links Mr. Williams pointed to helpful? </p>
<p> </p>
<p>BTW, I still question what one does with a report of 1000s of pages.</p>
shamo
<p>The 1000s page report was for testing to see if the report runs but the main issue is converting them to a chart for a 12 months period for the purpose of comparison. I have checked his links but don't seem to locate the web server plugin under preferences in the designer. I am using 4.2 version</p>
micajblock
<p>Take out everything and put a simple table with the result set. How long does that take?</p>
shamo
<p>More than 10mins and times out after 10mins</p>
micajblock
<p>Then in my opinion something is wrong with your query. How long does your query take in your databases query tool?</p>
shamo
<p>I use the query builder in the designer which outputs 500 rows and that happens within 3sec</p>
micajblock
<p>So something is wrong with your report. My guess is that the script you are using to build the query with the Maximo classes is the culprit. If the query takes 3 seconds then the report with just the table should start generating after 3 seconds. That is how BIRT works.</p>
shamo
<p>Just run same report in web viewer and within 30sec had pulled up 100+ pages. total took 6mins to pull 48875 pages and when it got done, it hanged up that I couldn't move page to page. Run same in pdf and took 10mins to run and could see all pages.</p>
micajblock
<p>It might be a memory issue.In eclipse.ini increase XXMaxPermSize.</p>
wwilliams
<p>Program Files\IBM\HTTPServer\Plugins\config\webserver...</p>
<p> </p>
<p>plugin-cfg.xml</p>
<p> </p>
<p>Try upping the ServerIOTimeout value</p>
