v.apukov Posted August 23, 2016 Share Posted August 23, 2016 I have next problem:1) Report with sub-table2) 2 parameters, for example - period - 301, client - 10 000all work fine, same for period - 301, client - 900 ... all finethen I run same report with parameters - period - 301, client 901 or cilent - 10 001 and report start generate thousands of pages with high loading of database cpuboth parameters tested in native SQL - all values return proper result, no any issuesboth parameters - printed on report page, so I can see - it same with I use for SQL query would be helpfull for have any advice - what the problem could be, JasperStudio 6.3, tested with Studio, Server, Mac and Windows alltime issue sameBest regards, Vlad Link to comment Share on other sites More sharing options...
hozawa Posted August 23, 2016 Share Posted August 23, 2016 Is the content of "thousand pages" incorrect?The high CPU is probably because you're out of memory. Check memory usage and Java garbage collection. Solution is to add and allocate more memory to your application server. Link to comment Share on other sites More sharing options...
v.apukov Posted August 24, 2016 Author Share Posted August 24, 2016 Thousands pages - incorrect,CPU - on database serverfinally I check from database side and saw - I use same parameter in query twice, but SQL Server show me different value for the SQL query parameters ... Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now