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