Total Hours on Timesheets not Showing Correct Calculations

book

Article ID: 197307

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

After a user enters a total of 30 hours, the timesheet calculates that he has entered a different total of 41.

Cause

This can occur if the resource has a duplicate team record on one of the investments that they have on their timesheet. 

The following query can be used to determine if duplicate team records exist: 

SELECT t.prresourceid as prresourceid, t.prprojectid as prprojectid
FROM prteam t, srm_resources s, prj_resources p
WHERE t.prresourceid=s.id AND t.prresourceid=p.prid AND p.prisrole=0
GROUP BY t.prresourceid, t.prprojectid
HAVING COUNT(*)>1

Environment

Release : 15.7.1

Component : CA PPM SAAS TIME MANAGEMENT

Resolution

Please contact Broadcom support for assistance with removing the duplicate team records contributing to the unexpected total timesheet hours.