AnsweredAssumed Answered

Error - Invalid Type for parameter used in IN clause

Question asked by mtognetti on Aug 11, 2017
Latest reply on May 30, 2018 by Awadhesh.D

I have an interesting error when running my JasperSoft Server Advanced Report. This report is in production and I am making an upgrade by adding additional subreports.  This upgrade has not happened yet as I have had to refresh my memory on Advanced Reporting (THANK YOU COMMUNITY!). 

 

I have downloaded the Jasper JRXML from production and have it in my TEST/DEV environment and loaded it up into CA PPM; with inputs linked (again, Thank you Community!). Now I receive the following error when I try to run the report:

 

Error – Invalid type java.math.Big.Decimal for parameter projectKey_1 used in IN clause: The value must be an array or a collection.

 

I have not changed any of the parameters (names or types) nor have I updated the SQL Query for this report (or any of its currently attached subreports).

 

The parameter is defined as:

 

                Name:  projectKey_1

                Class: java.util.collection

                Netsted Type Name: java.math.BigDecimal

 

In the Where clause of the query it is used in the following context:

 

                AND $X{IN, i.investment_key, projectKey_1}

 

The input control is defined as:   /ca_ppm/input_controls/common/projectKey_1

 

What is the error really trying to tell me? As I said, I haven’t changed anything related to the parameter and it does run in the production environment.

 

Thank you for your help in resolving this.

 

 

Michael Tognetti

Outcomes