Jasper report not runing.

Hi,

I am running a jasper report from my solution. the code I used is as follows.

var ds = forms.frm_application_program_allocate.foundset.getDataSource();
var d = ds.split(‘/’);
var myServer = d[1];
plugins.jasperPluginRMI.runReport(myServer,‘report2.jasper’,false,plugins.jasperPluginRMI.OUTPUT_FORMAT.VIEW, null);

I am running a test report therefore not parsing any parameters.

But it gives no output report or no exception at Servoy developer. Therefore I launched the solution through application server to see its logs catch up with something. It showed that exception is thrown when the report is running.

2012-11-14 20:01 RMI TCP Connection(3)-127.0.0.1 INFO com.servoy.j2db.util.Debug Compressing socket closed
2012-11-14 20:01 RMI TCP Connection(3)-127.0.0.1 INFO com.servoy.j2db.util.Debug Compressing socket closed
2012-11-14 20:01 RMI TCP Connection(3)-127.0.0.1 WARN com.servoy.j2db.util.Debug Got -1, compressing socket is closed
java.lang.RuntimeException: Got -1, compressing socket is closed
at com.servoy.j2db.rmi.compressing.CompressingInputStream.readIn(CompressingInputStream.java:105)
at com.servoy.j2db.rmi.compressing.CompressingInputStream.read(CompressingInputStream.java:85)
at java.io.FilterInputStream.read(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Can anyone please help me with this.
I am using Servoy 6.1.2 and jasperplugin version 4.0.0 b1.

Regards,
Buddhika

Have you ever gotten any report to run with the Jasper report plugin? Also, I assume you have the plugin installed for both your developer server AND the stand-alone application server? Does the report run okay from the preview window in iReport?

So you are using the 4.0.0 beta version of the plugin? If the report is working fine from the iReport preview window and nothing else appears to be wrong, maybe there is a problem with the plugin. Try using the 3.3.0 non-beta plugin. I use that one all the time and it works okay.

Usually if there is a problem with the report itself, an error will appear in the Servoy developer console or in the iReport console.

Do you have the jasper report directory setting filled in within the admin page server plugins properties?

Regards,
Andrei

Hi Jos, Larry and all,

Sorry for the delayed reply for your posts. I have done my work as you requested. I used the jasper plugin version 3.3.0. and i report 4.5.1 . After hard work and with some more modifications I was able to generate report, which does not take in any parameters and. Also, no fields were in the report except for static text fields.

When I add a text field to show a parameter or field value from query, again an exception is thrown.

java.lang.Exception: null

Also, servoy log shows this.

2012-11-18 20:16:06,168 ERROR [AWT-EventQueue-0] com.servoy.j2db.util.Debug - Throwable [E891857E-0404-4A69-B0A0-F8904181E13F wp_training]
net.sf.jasperreports.engine.JRException
at com.servoy.plugins.jasperreports.JasperReportRunner.getJasperPrint(JasperReportRunner.java:357)
at com.servoy.plugins.jasperreports.JasperReportsServer.getJasperPrint(JasperReportsServer.java:280)
at sun.reflect.GeneratedMethodAccessor146.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.servoy.j2db.util.AbstractRemoteInvocationHandler.invokeMethod(AbstractRemoteInvocationHandler.java:77)
at com.servoy.j2db.util.ThreadingRemoteInvocationHandler$1.run(ThreadingRemoteInvocationHandler.java:79)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Can anyone help me pls.

BR
Buddhika

Buddhika, please create a case concerning this; attach your report and a small sample solution with db creation sql if needed.

Also, as a reminder, it is not recommended to use the 3.3 version of the plugin with iReport 4.5.1, or greater than 4.0.0, (unless you manually modified the plugin) as it contains libs with a higher version that 3.3 was built against; also it might not fully work with Servoy 6.1.

Regards,
Andrei

Andrei,

Which version of the plugin are you suggesting Buddhika use? Is there a version of the Jasper report plugin that is greater than 3.3 and not beta? Last time I was on the jasper report servoy plugin page, the highest version appeared to be 4.0.0 beta. Perhaps I was not looking in the right spot?

Hi everyone,

Sorry for the late reply. I solved the issue. I used ireport 4.0.0 with servoy jasper plugin version 3.2.0. Then I had to change language of ireport to java (language = ‘java’) from groovy. (Or you can just remove the language).

Now the reports run fine. But my question is, why cant we modify the language of ireport from grroovy to java to take an output in servoy.

Thank you everyone for all the support given to me during hard times.

Thanks for all the
BR
Buddhika

dfrazier:
Andrei,

Which version of the plugin are you suggesting Buddhika use? Is there a version of the Jasper report plugin that is greater than 3.3 and not beta? Last time I was on the jasper report servoy plugin page, the highest version appeared to be 4.0.0 beta. Perhaps I was not looking in the right spot?

Hi,

We recommend using the plugin (version-wise) as noted in the third paragraph here. Currently the latest/highest version of the plugin is 4.0.0beta.

Regards,
Andrei

Buddhika_jayatissa:

I used ireport 4.0.0 with servoy jasper plugin version 3.2.0. Then I had to change language of ireport to java (language = ‘java’) from groovy. (Or you can just remove the language).

Now the reports run fine. But my question is, why cant we modify the language of ireport from grroovy to java to take an output in servoy.

Hi Buddhika,

The scripting language of reports set to Groovy can indeed cause problems; this was fixed in versions 3.3 and 4.0b1, in source code (see https://www.servoyforge.net/issues/416). There is no new (jar) build of the either version to reflect this on the files download page of the plugin. But you get build one yourself or wait for a new release of the plugin.

Also, regarding plugin versions and iReport, please refer to the post above as well.

Regards,
Andrei

Andrei Costache:
We recommend using the plugin (version-wise) as noted in the third paragraph here. Currently the latest/highest version of the plugin is 4.0.0beta.

Hi Andrei, the wiki isn’t too clear on what version of iReport is currently recommended on Servoy 5.2.x
Reading back through earlier releases it was iReport 4.0.0 is that still correct? A summary in the wiki for 3.3.1 plugin requirements would be very helpful.
(a renumbering of the plugins to align with the Servoy major versions would be wonderful :wink: )

Hi Tony,

A new section has been added to the main wiki page: https://www.servoyforge.net/projects/se … Guidelines.

Hope this helps,
Andrei