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

Products

• CA Spectrum

Issue/Introduction

We are unable to run reports, using the Spanish locale with CABI (JasperSERVER) 6.3 and Spectrum 10.2 or 10.3.   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>

 

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.

Environment

JasperSERVER 6.3 Spectrum 10.2 or 10.3

Resolution

The issue can be fixed in /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