AnsweredAssumed Answered

Jaspersoft Capacity vs Allocation by OBS report fail

Question asked by Lowell on Feb 1, 2018
Latest reply on Feb 2, 2018 by Suman Pramanik

I have a report that fails in our Oracle on-Premise environment.  I turned on debugging and found the query that fails has a WHERE condition that passes in a "FALSE = 1". This fails in Oracle.

 

I have Jaspersoft Studio and I cannot find this query in the report.  Is there a hidden tab or some super secret Jaspersoft hideaway for queries like this one?

 

SELECT r.resource_key AS resource_key,

r.resource_id AS resource_id,

r.resource_name AS resource_name

FROM dwh_res_resource r

WHERE ? = 1

AND r.is_role = 0

AND r.resource_type_key = 0

AND r.resource_manager_key IN (?)

AND r.resource_key IN (SELECT DISTINCT obsm.resource_key

FROM dwh_res_obs_mapping obsm

INNER JOIN dwh_cmn_obs_hierarchy obsh ON obsm.obs_unit_key = obsh.child_obs_unit_key

WHERE obsh.parent_obs_unit_key = PPM_DWH.dwh_null_number_fct(?,0))

AND (r.is_active = CASE WHEN ? = 1 THEN r.is_active ELSE 1 END)

AND EXISTS (SELECT 1

FROM dwh_res_security_v

WHERE user_uid = ?

AND resource_key = r.resource_key)

ORDER BY r.resource_name

2018-01-31 21:46:47,915 DEBUG JRJdbcQueryExecuter,http-apr-8080-exec-7:509 [cambia|r616330] - Parameter #1 (populateResource of type java.lang.Boolean): false

2018-01-31 21:46:47,916 DEBUG JRJdbcQueryExecuter,http-apr-8080-exec-7:576 [cambia|r616330] - Parameter #2 (resourceManagerKey_1[0] of type java.math.BigDecimal): 5.00432E+6

2018-01-31 21:46:47,917 DEBUG JRJdbcQueryExecuter,http-apr-8080-exec-7:509 [cambia|r616330] - Parameter #3 (resourceOBSUnitKeyRequired of type java.math.BigDecimal): 5166219

2018-01-31 21:46:47,918 DEBUG JRJdbcQueryExecuter,http-apr-8080-exec-7:509 [cambia|r616330] - Parameter #4 (includeInactiveResources of type java.lang.Boolean): false

2018-01-31 21:46:47,919 DEBUG JRJdbcQueryExecuter,http-apr-8080-exec-7:509 [cambia|r616330] - Parameter #5 (LoggedInUsername of type java.lang.String): r616330

Outcomes