[iReport / Filling Report never completes, 100% CPU]

The report fails to complete the fill when parsing row 16. Extract from Rows 15 and 16 of DB when running SQL on server:

 

vendsearchname total_cost total_revenue

FIRST ORDER DISCOUNT 0.000000 0.000000

GENERIC PRINT VENDOR USED FOR 0.000000 0.450000

GXXXXXXX XXXXXXXX LTD 294.000000 360.200000

 

Formula for Margin%

 

( $F{total_revenue}==0.0 ? 0.0 : 1-$F{total_cost}/$F{total_revenue} )

 

[using groovy]

 

This row is not at the bottom of a column though.

[iReport / Filling Report never completes, 100% CPU]

We have developed eight reports in iReport 1.3.0, and published successfully to JasperIntelligence using the plug-in.

 

Two reports fail to complete (jrxml attached) the "filling report" process; either through iReport or on JasperIntelligence. CPU rises close to 100% and memory creeps up.

 

Same problem occurs with different connections (JDTS, SunJDBC); and different output (HTML, PDF)

 

Same problem occurs if the report is built using the Wizard.

 

[sames SQL tests and completes in ~12 seconds on database server; though we notice that the connection stays open which suggests not all rows have been collected???]

 

Reports complete if we limit number of rows to less than 15 (there are 41 rows expected).

 

No special characters in rows.

 

---

 

I have seen a number of bugs/similar symptoms on the forum, but no conclusive answer yet.

 

----

 

iReport 1.3.0

JRE 1.5.0_11-b03

Windows Server 2003

Dual AMD, 4GB RAM

 

 

 

[file name=OCGVendorMTD.jrxml size=9864]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/OCGVendorMTD.jrxml[/file]

[JasperServer Access Configuration]

Tomcat error:

 

 

java.lang.NullPointerException

at org.exolab.castor.xml.UnmarshalHandler.endElement(UnmarshalHandler.java:757)

...

 

at org.apache.axis2.receivers.RawXMLINOutMessageReceiver.invokeBusinessLogic(RawXMLINOutMessageReceiver.java:100)

...

[iReport1.30 engross CPU100% ,Why?]

We've seen the same problem, particularly with other third party tools/such as messengers/VOIP products that are configured to use Port 80?

 

Also with slow VPN connections using jtds connections to database servers in a "Read Fields" operation...

 

Switch off any extraneous windows services on the desktop.... and restart fixed our problems.

[JasperServer Access Configuration]

We've changed the URL to

 

http://localhost:8080/jasperserver/services/repository

 

and now receive the following error:

 

An error occurred while getting the list of available data sources: null

 

We have configured a folder under [root] datasources

and created a data source???

 

Is there a problem with the web service?

[JasperServer Access Configuration]

We're trying to use IReport 1.3.0 with Plug-in to connect to Jasper Intelligence.

 

JasperIntelligence is running on 8080 (Tomcat)

 

Trying to add a connection to a JasperServer:

 

name: test

URL: http://localhost:8080/ji-pro/services/repository

username: jasperadmin

password: admin

 

and receive the following message:

 

an error occurred while getting the list of available data sources:

 

(404)/ji-pro/services/repository

 

What is the correct URL for JasperIntelligence?

 

Thanks