nick.stanmore

You can close this question as the users are happy with the Meter Interval settings described above.

Jasperserver 7.9 I am familiar with creating drilldown reports and passing all the parameters via hyperlink to the called report. Is there a way to only pass some parameters and prompt the user to enter the rest? Currently the called report runs immediately with the missing parameters taking their default values. "No data" is shown (which is expected) and the user has to bring up the input control popup to enter the missing parameters.

I used the "Chart Plot" window (from Meter's Properties window. It takes a while for the option to appear). I set colours in the Meter Intervals - green for 1st 90% (need to use fixed values), red for the last 10%. It means you need to specify a fixed "Data Range High Expression".

Try setting the tick interval to higher than the "Date Range High Expression". Then the meter is smaller than 1 tick and they do not show. This works on Jasper 7.9.2.

Jasper server 7.9.2, Jasper Studio 7.9.0 Is there a way to change the colour of a meter chart depending on the value displayed e.g. >90% then red? I applied a style but it only affects the title of the chart

The Windows locale/region was set differently on the 2 servers. The server.log showed different values for "user.country" on startup. I explicity set the value in report-server.conf.bat to keep consistency set "JAVA_OPTS=%JAVA_OPTS% -Duser.country=GB" After that all ok

It turns out that when the good Jasper connects to the db the NLS_TERRITORY = "AMERICA" (week start = Sunday) while the bad server gets "UNITED KINGDOM" (week start = Monday). Now got to find out why they are different.

Jasperserver 7.9 with Oracle 12.1 We have 2 Jasper servers (WS2019) pointing to the same database. Both servers have same timezone and locale (Windows and Jasper). Each server returns a different value for the same date using trunc ( sysdate, 'D') to get the date of the Sunday of this week. Also trunc ( sysdate - 7, 'D') for the previous Sunday. Good server shows 2023-09-17 07:00:00.0 and 2023-09-24 07:00:00.0 Bad server shows 2023-09-18 07:00:00.0 and 2023-09-25 07:00:00.0 07:00:00 as query adds (7/24) for 0700 (start of work day). Alternative SQL like "TRUNC(NEXT_DAY(SYSDATE - 7, 'SUNDAY')) + INTERVAL '7' HOUR" works on both good and bad server. I'd like to understand why this is happening in case other reports are affected.

Think I have figured it out. We use a home made utility to put and get reports to/from the Jasper server. Apparently the utility removes certain input controls from the report when it gets it from Jasper so if you upload it again you end up with a missing input control. I have expanded the zip file that the utility creates and the input control is missing as suspected.

We've upgraded our Jasper 5.5 db (Oracle 12.1) to Jasper 7.9 using the scripts from jasperreports-server-pro-7.9.0-bin/buildomatic/install_resources/sql/oracle. I installed Jasper Studio Professional 7.9 to make some bug fixes and have a problem drilling down to see some reports. When I click on some folders, expecting to see "Main jrxml, sub-reports, input controls, etc; I get a popup and stack trace. java.lang.NullPointerException at com.jaspersoft.studio.server.protocol.restv2.WsTypes.toSoapType(WsTypes.java:246) at com.jaspersoft.studio.server.protocol.restv2.Rest2Soap.getRD(Rest2Soap.java:104) at com.jaspersoft.studio.server.protocol.restv2.Rest2Soap.getRDContainer(Rest2Soap.java:73) at com.jaspersoft.studio.server.protocol.restv2.Rest2Soap.getReportUnit(Rest2Soap.java:381) at com.jaspersoft.studio.server.protocol.restv2.Rest2Soap.getRD(Rest2Soap.java:155) at com.jaspersoft.studio.server.protocol.restv2.Rest2Soap.getRD(Rest2Soap.java:67) at com.jaspersoft.studio.server.protocol.restv2.RestV2ConnectionJersey.get(RestV2ConnectionJersey.java:489) at com.jaspersoft.studio.server.protocol.ProxyConnection.get(ProxyConnection.java:194) at com.jaspersoft.studio.server.protocol.ProxyConnection.get(ProxyConnection.java:220) at com.jaspersoft.studio.server.WSClientHelper.refreshResource(WSClientHelper.java:394) at com.jaspersoft.studio.server.ServerProvider.lazyLoadResource(ServerProvider.java:390) at com.jaspersoft.studio.server.ServerProvider$2.run(ServerProvider.java:376) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63) One of the input controls references a "query" input control and all reports using that control have this problem. Other reports using other "query" controls seem alright although I haven't checked each one. When I run the report on the server I get this: (reduced stack trace) java.lang.NullPointerException at com.jaspersoft.jasperserver.api.metadata.common.domain.util.RefSets$4.apply(RefSets.java:121) at com.jaspersoft.jasperserver.api.metadata.common.domain.util.RefSets$4.apply(RefSets.java:118) at com.google.common.collect.Iterators$6.transform(Iterators.java:783) at com.google.common.collect.TransformedIterator.next(TransformedIterator.java:47) at com.google.common.collect.Iterators$5.computeNext(Iterators.java:636) at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:141) at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:136) at com.google.common.collect.Iterators.addAll(Iterators.java:355) at com.google.common.collect.Sets.newHashSet(Sets.java:274) at com.google.common.collect.Sets.newHashSet(Sets.java:257) at com.jaspersoft.jasperserver.api.metadata.common.domain.util.RefSets.newSet(RefSets.java:118) at com.jaspersoft.jasperserver.api.metadata.common.domain.util.MarkAllInputControlsResolved.normalizeReferences(MarkAllInputControlsResolved.java:39) at com.jaspersoft.jasperserver.api.metadata.common.domain.util.MarkAllInputControlsResolved.normalizeReferences(MarkAllInputControlsResolved.java:36) at com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.client.ReportUnitImpl.normalizeReferences(ReportUnitImpl.java:412) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.ReportLoadingService.getInputControlReferences(ReportLoadingService.java:345) at Does anyone have a similar experience or know what's wrong with the input control?

Our US office provides the Jasper install files and it turned out to be the wrong ojdbc jar file in server/*/lib (ojdbc5 instead of ojdbc7) which I think 1 of the answers mentions as well.

No errors or warnings in the logs until it gets the OutOfMemory errors. The leak starts immediately - jstat shows the "P" value increasing every few minutes. Not by much which is why it takes several hours to break. I'll try increasing the log level.

I have recently installed Jasper 5.5 on Linux 7.3 (Red Hat) with Oracle 12.1. There seems to be a slow memory leak in the area of com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery as after about 6 hours it will run out of heap space even though it's not in use at the moment. jstat -gccause shows like this: S0 S1 E O P YGC YGCT FGC FGCT GCT LGCC GCC 100.00 0.00 100.00 100.00 59.99 1817 14.684 29014 28142.642 28157.326 Allocation Failure Allocation Failure I used the MAT tool from Eclipse to see what was using the space and it highlighted the above arjuna class although on another heap dump it showed org.jboss.resource.adapter.jdbc.xa.XAManagedConnection. Java options: -Di=dxc1jas1> -Dngs.home=/usr/local/jboss51/jboss-eap-5.1/jboss-as/server/dxc1jas1 -Djava.net.preferIPv4Stack=true -server -Xms1024m -Xmx1024m -XX:PermSize=32m -XX:MaxPermSize=512m -Xss2m -XX:+UseConcMarkSweepGC -XX:+CMSClassUnloadingEnabled -Doracle.jdbc.defaultNChar=true -Djavax.xml.soap.MessageFactory=org.apache.axis.soap.MessageFactoryImpl -Djavax.xml.soap.SOAPConnectionFactory=org.apache.axis.soap.SOAPConnectionFactoryImpl -Djavax.xml.soap.SOAPFactory=org.apache.axis.soap.SOAPFactoryImpl -Djavax.xml.transform.TransformerFactory=org.apache.xalan.processor.TransformerFactoryImpl -server -Duser.timezone=Europe/London -Dprogram.name=run.sh -Djava.endorsed.dirs=/usr/local/jboss51/jboss-eap-5.1/jboss-as/lib/endorsed -classpath /usr/local/jboss51/jboss-eap-5.1/jboss-as/bin/run.jar:/usr/java/jdk1.7.0_45/lib/tools.jar org.jboss.Main Increasing the memory merely delays the OutOfMemory error so I'm restarting Jasper every 4 hours but I'd like to get a more permanent solution.

JasperServer 5.5 As a casual Jasper developer/supporter this stumped me for a few days so logging it for any in a similar position. Certain users would get an "access is denied" error when drilling down from a top level that showed a column graph. The roles on the folders and reports themselves should have allowed access. It wasn't until I clicked the Edit button to show the report resources that I realised the sub-report was accessing other folders for images and Input Controls. The folder holding the images only had 1 of the roles that it should have. Once I assigned the missing role the drill-down worked for all users.

UPDATE: It seems related to the number of records in Jiresource and Jicontentresource. 4000 seems to be the limit. Jiresource.resourcetype = 'com.jaspersoft.jasperserver.api.metadata.common.domain.ContentResource' and Jiresource.id = Jicontentresource.id

Jasper Reports 5.0.1, Windows Server 2008 R2. When editing a scheduled report Jasper hangs on the "Output" page, displaying a "Loading" message. Is the number of saved reports a factor, there are 20000+ saved pdf files?