We have recently upgraded the jaspersoft to 6.2.1 version with latest patch. After the upgrade, its taking 5 minutes to open repository. Earlier it was taking only 90second to open the repository. How we can fix this one
How to increase the tomcat JVM heap size in this new version. I couldn't locate parameter JAVA_OPTS in setclasspath file in tomcat bin.
Please help me to sort out this issue?
In Jaspersoft 6.2.1 we are keeping the JVM parameters under setenv.bat or setenv.sh
set JAVA_OPTS=%JAVA_OPTS% -Xms6144m -Xmx6144m -XX:MetaspaceSize=32mset JAVA_OPTS=%JAVA_OPTS% -Xss2m -XX:+UseConcMarkSweepGCset JAVA_OPTS=%JAVA_OPTS% -XX:+CMSClassUnloadingEnabled
Also run a browser trace using F12 to see where its taking longer?
I am able to change the tomcat JVM heap.
I have enabled browser trace and able to see the below link is taking 6 minutes to load.
and our production is still in lower jaspersoft version. for loading almost same data it take only 1.3 minutes.
Am attaching file content which was taken 6 minutes to load the data.
It would have been better if you had provided the HAR file, also try to gather database stats and see the performance. I think you should log a case to be looked into.
Also how many user folders you have created and what is the PPM patch level?
we have around 400+ custom folder and in CA PPM14.3 with patch 9
That could be one of the reason for it, can you share a screen shot of the Advance reporting home page. We had performance issues with many folders and hence we took off the feature to provide folders for every user.
Also I believe you are cleaning up the folders with the content.
Thanks for your quick response on this issue.
Here we are using this same setup of folders in production with patch 9 and jaspersoft version is 6.1.0. There it take only 1.3 minutes to load the repository.
While upgrading, we had used the export file (UI export) from Production and upgraded. Reports are working fine. But the repository is taking 6-8 minutes to load.
Am attaching a screen shot. Those are not user folders. We have created different folders to implement data level security in reports.
Did you manage to gather stats for Jaspersoft schema?
Waiting for DBA team to get the stats. I will update you, once i recieve the same.
Please find the response from DB team.
table space is used by jaspersoft schema ? PPM_Jaspersoftall privileges this schema have.CONNECTCREATE SESSIONQUERY REWRITERESOURCEUNLIMITED TABLESPACE
last stats gathered on tables on schema are of 15th and 16th .(most of them are on 15th and some are on 16th).
I see you raised a case and we will work with you via case.
Is it possible to take the trace of the Repository click action so that we can check where it is taking time to load.
Yes you can log in to Jaspersoft console as superuser and then under Manage --> Server Settings there are additional tracing you can do. I would recommend to trace under "SQL query executer". Also please check count of JIRESOURCEFOLDER
More the number of folders and the contents in that it will be slower and thats was the reason we took away folder creation after 14.3 patch 7
We will try taking trace. Also, the number of records in JIRESOURCEFOLDER table is 2569.
Thanks, did you apply the latest patch on 6.2.1?
Yes, latest patch has been applied for Jaspersoft 6.2.1.
The trace did not captured anything related to repository link. Only when reports are executed, the trace logs can been seen.
Could you please confirm the tomcat version to be used in Jasperserver 6.2.1? In jaspersoft community, its mentioned as tomcat 8. This leads to this confusion!
We have done it on apache tomcat 7.0.55.
Please go by what is mentioned in our document ie. Docops.ca.com