Clarity: Missing Time report is not getting any data if the date mentioned in specific date field is last day on the time period

Document ID : KB000050209
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

When the 'Missing Time' report is executed with the specific last date in the time period entered into the report parameter, no data is generated for the report.

Steps to Reproduce:

  1. Created a Project, and a task. Assigned a resource (that is active, open for time entry, track mode set to clarity, availability set to 8, calendar set to base calendar, assigned to a resource OBS) to the task. NOTE: Ensure the timeslices are configured correctly to cover the date ranges of the timesheets you will submit for this project.

  2. Submitted time sheets for this resource.

  3. Ran the Time Slicing and Datamart Extraction Job.

  4. Reports and Jobs > Select Missing Time Report.

  5. Set the mandatory fields (such as Report Name, Resource OBS, Status, Group By, Resource Type and Time Period).

  6. Set the time period on specific date and give the date as last day of any period i.e if a time sheet period is 3/23/10 to 3/31/10 then give 3/31/10 in the specific date field.

  7. Click Submit to run the report. NOTE: Ensure that you select Specific Date for Time Period.

Expected Result: The report should be generated with records.
Actual Result: No records are displayed in report.

Solution:

WORKAROUND:
Run the report with start date or any date in between start and end date.

STATUS/RESOLUTION:
Resolved in Clarity 12.1.0

Keywords: CLARITYKB, CLRT-53337, clarity12resolved, clarity1210resolved, biar, bo.