ETL9.2: Receive SQL Error When Loading Time And Labor Dashboard: NULL IS NOT VALID IN THE CONTEXT WHERE IT IS USED (Payable Time pagelet)

Last updated on JUNE 01, 2017

Applies to:

Symptoms

On: 9.2 version, Technical

Receive SQL Error when loading Time and Labor Dashboard

When loading the Time and Labor Dashboard in our DEMO environment we are getting the message a SQL error has occurred. Our DBA checked the error logs and found the following sql:


ERROR
-----------------------
DSNT408I SQLCODE = -206, ERROR: NULL IS NOT VALID IN THE CONTEXT WHERE
  IT IS USED

SELECT FILL.EMPLID, FILL.EMPL_RCD, FILL.DUR, FILL.TASKGROUP, FILL.
  TL_QUANTITY, FILL.EST_GROSS, FILL.LBR_DIST_AMT, FILL.
  DILUTED_GROSS, FILL.CURRENCY_CD, FILL.PAYABLE_STATUS, FILL.
  PROJECT_ID, FILL.TRC, FILL.TRC_SUM_CATEGORY, FILL.TRC_TYPE,
  FILL.FACTOR_MULT, FILL.TL_CHT_GROUP_DESCR
 FROM PS_TL_DSH_PTTRC_VW FILL
 Where EMPLID = ?
  and EMPL_RCD = ?
  and DUR between NULL and NULL
  and TRC_TYPE = 'H'
 order by EMPLID, EMPL_RCD, DUR
 FOR FETCH ONLY

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
 Manager Self Service->Time Management-> Time and Labor Dashboard  (Payable Time Pagelet)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot navigate to the dashboard without receiving a SQL error and can not view the date under (Payable Time Dashboard)

Cause