java.lang.IllegalArgumentException: Null 'key' argument.

[pcouas_1]

Hi,

 

JasperServer.log give me following error message "java.lang.IllegalArgumentException: Null 'key' argument."

But my complet query is running into SQLDevelopper !

The error is in subpart

($P{isGrpMoreTweleve} ? "(CASE TO_CHAR(trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1)   WHEN '1' THEN 'First Qtr'   WHEN '2' THEN 'Second Qtr'   WHEN '3' THEN 'Third Qtr'   WHEN '4' THEN 'Fourth Qtr'  end)" : "to_char(iv.inventory_date,'MON-YYYY')")

($P{isGrpMoreTweleve} is an boolean with defaultValue

 

Regards

jasperserver.log

query string: SELECT     (to_char(iv.inventory_date,'YYYY') || (trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1) ) AS tri,   (CASE TO_CHAR(trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1)  WHEN '1' THEN 'First Qtr'   WHEN '2' THEN 'Second Qtr'   WHEN '3' THEN'Third Qtr'   WHEN '4' THEN 'Fourth Qtr'  end) AS label,     NVL(SUM(va.QUANTITY_USED),0) AS value1,     va.VESSEL_UID,  ve.VESSEL_NAME,(to_char(iv.inventory_date,'YYYY')|| (trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1) )||':'||(CASETO_CHAR(trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1)   WHEN'1' THEN 'First Qtr'   WHEN '2' THEN 'Second Qtr'   WHEN '3' THEN 'ThirdQtr'   WHEN '4' THEN 'Fourth Qtr'  end) as trititleFROM     LO_VALUATION va,LO_VESSEL ve,lo_inventory ivWHERE va.VESSEL_UID=ve.VESSEL_UIDand va.month=iv.inventory_monthand ve.TEU_UID in (2,6,8,12)and iv.inventory_date BETWEEN to_date('20/09/2010','DD/MM//YYYY') AND to_date('01/10/2013','DD/MM//YYYY')GROUPBY (to_char(iv.inventory_date,'YYYY') ||(trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1) ), (CASETO_CHAR(trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1)   WHEN '1'THEN 'First Qtr'   WHEN '2' THEN 'Second Qtr'   WHEN '3' THEN 'ThirdQtr'   WHEN '4' THEN 'Fourth Qtr'  end),    va.VESSEL_UID,ve.VESSEL_NAME,(to_char(iv.inventory_date,'YYYY')|| (trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1) )||':'||(CASETO_CHAR(trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1)   WHEN'1' THEN 'First Qtr'   WHEN '2' THEN 'Second Qtr'   WHEN '3' THEN 'ThirdQtr'   WHEN '4' THEN 'Fourth Qtr'  end)ORDER BY(to_char(iv.inventory_date,'YYYY')|| (trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1) ), (CASETO_CHAR(trunc(to_number(to_char(va.modif_date, 'MM')) / 3)+1)   WHEN '1'THEN 'First Qtr'   WHEN '2' THEN 'Second Qtr'   WHEN '3' THEN 'ThirdQtr'   WHEN '4' THEN 'Fourth Qtr'  end),     va.VESSEL_UID ASC2016-03-10 19:20:31,351 ERROR AsyncJasperPrintAccessor,pool-4-thread-56:315 - Error during report executionjava.lang.IllegalArgumentException: Null 'key' argument.[/code]

[pcouas_1]

That's Ok with DECODE function