joseng62

You have to add some more info. No way someone can help you. What did you try to import? Was it from previous version Jasper Server ? What the error you getting?

Which Jasper Server version are you running? And on which tomcat server you running? You running on Linux of Windows ? Seems to be a memory issue. Check you memory and java path: I use setenv.bat to set my memory for tomcat. Jasperpathapache-tomcatbin Example of java properties set JAVA_HOME=C:Program FilesJavajdk1.7.0_21set JAVA_OPTS=%JAVA_OPTS% -Xms2048m -Xmx4096m -XX:PermSize=128mset JAVA_OPTS=%JAVA_OPTS% -XX:MaxPermSize=512m -Xss20m -XX:+UseConcMarkSweepGCset JAVA_OPTS=%JAVA_OPTS% -XX:+CMSClassUnloadingEnabled

Time function only works if your data type is String: Time('StringExpression')Casting function that takes a String expression in the format 'HH:mm:ss.SSS' and converts it to a Time data type.The String can be any expression that returns a valid String, including a field value or an attribute retrievedwith the Attribute() function.Example:Time('17:12:33:147') This seems to be an alternative, but I believe it depends on datatype: To reference a date with time data only (hh:mm:ss), use t followed by single quotes (') —t'01:30:00'Do you have access to the domain. When creating the fields for the domainyou can set the propoerty and change the Dataformat. So you can create an addtional field with same data value and change the dataformat. You can also format the fields in your query you used in the domain.

Hi Stephen, Ad hoc report does change my suggestions a bit. I acutally had issue with Ad hoc report as well. Are you using a securty file in the domain setup? I realise when using the securty file, Jasper does not apply the filter based on the security file. Jasper first collect all the data and then applies filter based on security file. So in my case then data returned from DB was a lot, but it only displayed the filtered data. Also jasper allocated spesific memory to ad hoc reports. You need to allocate more memory to ad hoc report if caching a lot of data. - So you can go edit ..apache-tomcatwebappsjasperserver-proWEB-INFadhoc-ehcache.xml <ehcache name="adhocCache" maxBytesLocalHeap="4G" maxBytesLocalDisk="8G"> maxBytesLocalHeap is recommened to be half your memory allocated to Jasper, but this just depend on your data size in ad hoc and user use. maxBytesLocalDisk is recommened to be double maxBytesLocalHeap - Then you could set the cache timing as well. You can set time that best suits your situation. You can read up more about this in jasper manual. You can even disable cache as well. <cache name="adhocCache" timeToIdleSeconds="180" timeToLiveSeconds="30" overflowToDisk="false" diskPersistent="false" statistics="true" > - Also make sure cache sharing is enable if users are going to use same datasets. You can aslo find this in jasper manual. File: ..apache-tomcatwebappsjasperserver-proWEB-INFapplicationContext-datarator.xml So here are answers on your questions: Is the JasperStudio test not relevant for ad hoc reports? Yes, jasperstudio will not be relevent for ad hoc reports.I don’t think there is a cross tab in the report Ad hoc reports give user the options to display data in table, crosstab or chart format.I will try some different GC settings, thanks for the suggestion PleasureI do have the Diagnostic option so I’ll have a look through the settings - not quite sure what to look for in there though! This is just to confirm your settings are applied correclty. Example your memory settings. Also when you get use to the report, it become helpfull due to other data being display as well.I think it idles heap-wise. There are a few GC logs while it is starting up, but then they stop. Edd checked this with jconsole before, but I have not been able to connect it. In my experience, Perm wise should, not to be more than 512 MB. Heap, if idle then you can generate the report, see the load on the cache. Then based on ad hoc cache settings the cache should clear in time selected. Aslo you can manually clear the cahce via jasper serve as admin. Under "Manage" and then "Ad hoc Cache" You can also use Ad hoc Settings to improve ad hoc. See japser manual. You can also enable Enable View Query in Ad Hoc Editor, So you do not need to get query from log, you can view it in ad hoc report.Sometimes I do get errors, but not sure if they are related - my JMeter script sometimes generates 404 errors because something that it recorded has disappeared. Pinpoint a scenarion where you get error every time, then recreate same error, check log, clear & restart tomcat(jasper). Recreate same error, check logs agian. You should be getting same error, other wise you might have underlying errors that are causing a lot of issues.I tried to run a test again to get an OutOfMemoryError but it didn’t happen - it just got into a loop of continual full GC and not reclaiming anything. I’ll try again later after a few other tests Jasper should eventually give you a headspace error. It does take some time after the heap is used up. After the error, jasper will be responsive but very slow, and your heap memory will still be max out. Give it 5 to 10 minutes after you see heap memory is full.

mmmm? this is strange behavior. You are running a custom build report in jasperstudio. jrxml? and not in ad hoc reports? Reason I am asking is because standard jrxml should not be taking up so much memory. 3GB or even 10Gb for one report's data returned is definitely not right. Based on my experience Ad hoc reports from Pro uses a lot of cache due to loading the data in memory for manipulation and standard jrxml do not use up a lot of cache. It usually uses disk/file based memory due to filling up the pages one by one. 1) So have you test this report in JasperStudio on same data set with same parameters? There might be a loop that just keeps on generating pages based on your db rows size or parameters selected for SQL query. If that when generating the report in studio the pages just keep on piling on until studio runs out of memory. 2) Are you using a crosstab in your report? Might be an issue with the bucket list size. 3) Try different Garbage collecting settings. example XX:+UseConcMarkSweepGC 4) Also have a look at the Diagnostic report under Public to confirm properties set. ( I am not sure if community has this thou) 5) When Starting up jasper server with your jvm linked up is it idling memory wise. When I run my memory tests I always made sure in the scenario I am testing, is isolated from any other resources on jasper. Just to ensure there are no underlying issues. So the memory Heap and Perm should be idling just after 5 minutes when starting up jasper. Then when you run the report you can immediately see the memory being utilized. (I suspect you are doing this, just confirming) 6) Also use development tool in the browser, there might be an error popping up. Even have a look at the http requests with their payloads. You should be able to identify the parameters being sent and also the values being returned. 7) In your jasperserver.log what is the heap space error being logged? There might be an indication of what the issues is. After all of this, all I could say is. I know how you feel. I had memory caching issues and spend almost 2 months on/off trying to figure it out. Hooking up JVM, using different JAVA_OPTS settings, Looking for logs errors, using jmeter etc.

Seems that the grey loading mask is generated by highcharts and not Jasper. You can edit the loading text via "highchart api http://api.highcharts.com/highcharts#lang.loading" use this a proprty in you chart. We could not figure out how to replace the loading mask. Instead we implemented our own loading mask. Our loading masks check for the report execution is done and then the mask is set to hide. Only work around we could figure.

Hi edd , sorry for the late reply. Yes change the amount to 20m. I aslo had issue when set to 2m. Memory issues when large dataset where being generated. Setting mine to 20m solve the problem.

Sorry running js-import.bat --help , you can see that there are no delete function. Only way I would suggest is via REST_v2 http://community.jaspersoft.com/documentation/jasperreports-server-web-services-guide/v56/deleting-resources

Hard to pin point the issue. Need more info. What are the server memory settings you are running? I'll give you an example. I uses the setenv.bat or setenv.sh to set my java memory allocation to apache tomcat. set JAVA_OPTS=%JAVA_OPTS% -Xms2048m -Xmx4096m -XX:PermSize=128m set JAVA_OPTS=%JAVA_OPTS% -XX:MaxPermSize=512m -Xss20m -XX:+UseConcMarkSweepGC set JAVA_OPTS=%JAVA_OPTS% -XX:+CMSClassUnloadingEnabled You have different type of GarbageC settings you can set depending on your envirn. Also I noticed in some threads there are recommendations to set -Xss to 2m, This is not enough and causes memory issues. So I set mine to 20m and no issues so far. We generate millions of records in ad hoc reports. Another issue might be the report.jrxml has a design error and might be looping the data. When you run this report in jasperstudio do you also get so many pages?(Need to test against same datasource) Does it seems that the data is recurring? You might have a SQL query issue in this regard. Are you running the report in jasperserver or are you making a call via REST services. I have experience issue with reports when requested via REST and then the user moves to another pages. Then the report cancellation is not sent. One should send a report cancellation request when user decide to move to another page, report etc. Also you could hook up the jvm stats like jstats to jasper and then monitor the memory usage via jv monitoring. This helps me to find and test memory issues. Also set the logging of relevant log class names to debug and then review the jasperserver.log for any issues. Hope this helps

Hi, all users when create are assigned the roll "ROLE_USER" and this is a default role that sould not be removed. So you have 2 options. If you want only spesific user to see report/resource. (Example user name UserT) Then you go to resource, right click and select permissions. In pop up you need to set the Role :ROLE_USER to no access and then apply. Then select the User tab in pop up and set UserT permission to what you want and then apply. Now only User T can admin user can access resource. If you want Role_base access then. Then you go to resource, right click and select permissions. In pop up you need to set the Role :ROLE_USER to no access and then apply. Select the Role you create and select permission level, then apply. Now all users with the given role can access the resource. Hope it makes sense. Kind Regards Josia

Hi Jan, this is a tough one to assist with. Need more information. Do you have any input values? Maybe using parameters in your query? If your not using the detials part, which part are you using? You mention that if you use the detailed part the a lot of page will be generated. Based on what I see, you should use the detailed part, just limit the query or add a where clause with some parameters to limit the return of data. So less page will be generated. Also are both datasources the same? The one you use in jasperstudio and the othe rone setup on jasperserver.

Hi kprashant In the Dashboard Designer you need to select the "Show filter manager dialog" in the menu bar. Then you make the link between parameters and dashlets. Example I created a manual filter = Filter1 I have 3 dashlets; Dash 1, Dash 2, Dash 3 They share a common filter/parameter = ShareParam. So you create 1 manual filter then select the given dashboard then select the common parameter "ShareParam" Then add next dashlet with same parameter and then add next dashlet with same param. So you are linking all dashlets to one common parameter. This should work then change filter value.

Yip I have noticed this as well. Was wondering how to fix this as well.

Ok so, Just check and confirm the jasperadmin has these 2 roles assigned ROLE_ADMINISTATOR and ROLE_USER Permission could easily have been changed. The when you sign in as superuser or jasperadmim Can you confirm the permission set for the given role and jasperadmin user to the temp folder. ROLE_ADMIN… should be administer ROLE_USER should be either administer or one of the write options. User jasperadmin should be default no access, but if so, just change to administer and test and see if any difference. Same goes for the given domain or topic you created. Also requires privileges. Regarding this “I restarted the server but the problem persists. I read something about clearing the temp folder and restarting tomcat. I'll try that.” You could clear the work folder tomcat install directoryapache-tomcatwork. Ensure tomcat is shutdown when doing so. And then also clear the temp folder tomcat install directoryapache-tomcattemp. Another issue might be that someone might have manually created the temp folder after deleting it in backend. Which means the ownership, group and file permission might be incorrect. Check for this and confirm its same permission. Own, grp as apachetomcatbin. Also have you tried to troubleshoot regarding different situations? Did you try to sign in as another user and create ad hoc report? Do you get to the point where the report completed to load and you can drag and drop fields or measures? Or does it give error before that? Or does it give error when you try to save the ad hoc report? Maybe create another role, assign to a new user and give that role and user full access to temp folder and domain. Or give full access to parent folder organization, child folder permission are inherited from parent. If it works, then you know its permissions issue. On the other AWS instance you have, where its working, maybe cross check the permissions settings, file permissions, role / user setup etc. Also the error you are retrieving from the UI screen. Always try and check the jaspers log file as more exceptions might be thrown that is not displaying on screen. “….apache-tomcatwebappsjasperserver-proWEB-INFlogs” Could also check the tomcat log files and see of any severe, error or wars are being generated. “…apache-tomcatlogs” Also when you sign in as superuser, you can set the log level for log4j properties. This might help to trouble shoot the issue. There might be another underlying issue. “Are reports created in the temp folder?” – Yes as I understand it Jasper uses the temp folder for just this purpose to temporally store data/report in this folder. “With the Ad Hoc View the workaround atm is to save them as topics to another folder “ – Topic are new set of data query you created and save from given domain. So topic receive own permission and when you save topic you create default permission. So yes seem to be that the issue is around permissions. Hope this helps

Hi Max, So default the only roles that can view temp folder is <property name="rolesToSeeTempFiles"> <list> <value>ROLE_SUPERUSER</value> <value>ROLE_ADMINISTRATOR</value> </list> </property>as per the file applicationContext-adhoc.xml Ensure you user is assigned ROLE_USER atleast. As per jasper manual ROLE_USER: Required to log in. This role is automatically assigned to everyJasperReports Server user. It's a special system-level role visible in everyorganization. Never delete this role, it's required to create users and allow them to log in. Then when signed in as superadmin check ther permission for ROLE_USER, you required at least Read access level. Then if you use other roles set permission to read and write. If user spesific then set per user. Then you also require correct permission to for the domain or topic you created. Hope this helps, if yoou have not already done it.

I have not worked on iRerpot for awhile now. I am using Jasperstudio. There should be a "When no data type" option in your report properties. (main report and subreports) Then select "No Pages". Also reduce your sub report high in the main report and ensure you detials band has no trailing space. (Meaning reduce detailed band so a sub report just fit on.) Also remember to get remove any band you are not using. I have not worked on iRerpot for a while now. I am using Jasperstudio. There should be a "When no data type" option in your report properties. (Main report and sub reports) Then select "No Pages". Also reduce your sub report high in the main report and ensure you details band has no trailing space. Some of my sub reports are 5 pixels high. (Meaning reduce the detailed band so a sub report just fit on.) Also remember to get remove any band you are not using. “When to print”, removes the visual aspect, but still occupies the space. When to print remove the visual aspect, but still occupies the space.

Displaying in server? I am assuming your accessing though browser, if your using jasperserver url in browser then you will connect to jasperserver. If you want client side to display only given report then you need to embed jasper into your client application. Either do a Rest api call or us visualize.js. PDF issue, is this when you generating a static report or ad hoc/dashboard reports. Its seem you are directly remote logging into jasper from client side, so the given action is correct. Then also which version JasperServer are you using?

Not sure if you linked the subreport parameters. You might need to pass over the parameter from the main report to the sub reports. Basicly right click on subreport then select show properties. Under subreport tab select parameters. From there link parameters. Aslo to test. Create fields equal the your given parameters and then drag the parameters onto your reports, to test and see if parameters value is correct.

I can confirm this issue. When fetching data from the DB the fetch time is quick = Execution time 0.971 secs Row amount = 87358 When opening ad hoc report with only 1 Measure and 2 fields selected with data set on sample the visualisation finish time on screen is 1.5 min When changing data set to Full then the report re generates and takes another 3.1 min. So fetching the data from DB is quick but visualizing on screen takes some time. When dropping or removing a field or measure, then again same time. Tested with cache enabled an cache disable, even tested with a staged (topic) and still same issue. Also when selecting a large data set then a lot of memory is being consumed. With my 87 358 and playing around with fields and measure my mem peak around 4G. That is for 1 user? @Hozawa : "There's also the problem with cache not being updated when underlying data changes but this is another issue. :-(" You can disable the cache, which in my experience works, but generates another error regarding ehcache Jasper V 6.1 Or you can reduce cache refresh time by editing this file: adhoc-ehcache.xml Edit the below option, which are time indication in seconds. <cache name="adhocCache" timeToIdleSeconds="180" timeToLiveSeconds="30" I implemented in one project a cache refresh of 10 and it works fine