Error when running "Current Port Assets (Customizable): All" report in Jaspersoft

Products

• CA Spectrum

Issue/Introduction

We are trying to run the report "Current Port Assets (Customizable): All" from Jaspersoft and we are receiving this error after 10 seconds of running this report.

 

Error Message

 

net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: UPPER (LEFT($F{port_type}, 1)) +MID($F{port_type},2,(LEN($F{port_type})-1))

Environment

Release : 10.4.x

Component : Jaspersoft for CA Spectrum

Cause

In the Reporting database the "Port Type" field should always be populated and not left blank.  

Resolution

The Reporting database had the "port_type" field with empty values and this was causing the report to fail. We can update the empty port_type with this command from mysql while logged into the Reporting Database.

update interfacemodel set port_type= "Port" where port_type = "";

 

Afterwards you should be able to run the report successfully.