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