Unable to run reports in Spanish with CABI (JasperServer) 6.3 and Spectrum 10.2

Document ID : KB000005835
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

We are unable to run reports, using the Spanish locale with CABI (JasperSERVER) 6.3 and Spectrum 10.2.   When we do, CABI hangs and never finishes processing.  We need to cancel the report, log out of CABI and change the locale to English, before logging back into JasperSERVER.   The following exception is thrown in the logs:

 

java.lang.IllegalArgumentException: Cannot format given Object as a Date

at java.text.DateFormat.format(Unknown Source)

at java.text.Format.format(Unknown Source)

at java.text.MessageFormat.subformat(Unknown Source)

at java.text.MessageFormat.format(Unknown Source)

at java.text.Format.format(Unknown Source)

at org.springframework.context.support.AbstractMessageSource.getMessageInternal(AbstractMessageSource.java:228)

at org.springframework.context.support.AbstractMessageSource.getMessage(AbstractMessageSource.java:147)</pre>

 

Environment:
JasperSERVER 6.3Spectrum 10.2
Cause:

There is a defect in a known issue JasperReports Server 6.3.0 which is specific to Spanish locale only.  There is an incorrect configuration in one of the locale bundle files which results in this error.

Resolution:

The issue can be fixed inin /WEB-INF/bundles/jasperserver_messages_es.properties file by deleting the following line:

jasper.report.view.data.snapshot.message=Donn\u00e9es actualis\u00e9es le {0,date} \u00e0 {0,time}

and replacing it with this

jasper.report.view.data.snapshot.message=Donn\u00e9es actualis\u00e9es le {0} \u00e0 {1}

Then save the file and restart the server.

Additional Information:

JasperSoft case reference Case #00069988

http://community.jaspersoft.com/wiki/reports-do-not-render-spanish-locale-tibco-jasperreports-server-v630