none
Manager still see Administrative Time-Off Requests reminders after that as approve all of them RRS feed

  • Question

  •  Hi All,

    After some discussion in another related topic , I decided to create a new topic fоr my issue.

    So, what we get:

       Our manager see reminders, but when he open approval center he does not see any pending administrative time on Approval center page. We check that Filter section have "No filter" value. Also we approve any updates in Approval Center and after that - filter section becomes inactive as entire ribbon from this page. But when this manager follow home PWA page he still see reminder about administrative time-off requests.

    Can you please explain why this happens? And how to resolve this issue?

    Thursday, February 17, 2011 2:36 PM

Answers

  • Hi All,

     After work with premier support team we were able to solve this issue.

    You can use following script for finding broken timesheet administrative time-off requests (records) on Published database:

     

    declare @class_type int 
    declare @ts_status int
    select @class_type=3
    select @ts_status=4
    
    SELECT	
    		res_ts_mng.RES_NAME as 'Timesheet Manager Name',
    		res.RES_NAME as 'Resource name',
    		RepTSP.PeriodName--,
    	  --tsl.TS_LINE_ASSN_LAST_WORK		
    		
    FROM 
    		MSP_TIMESHEET_LINES tsl
    		INNER JOIN MSP_TIMESHEET_CLASSES tsc 
    		ON tsl.TS_LINE_CLASS_UID = tsc.TS_LINE_CLASS_UID
    		AND (@class_type = 4 OR (@class_type = 3 AND tsc.TS_LINE_CLASS_TYPE <> 0) OR tsc.TS_LINE_CLASS_TYPE = @class_type) 
    		INNER JOIN MSP_TIMESHEETS ts
    		ON ts.TS_UID = tsl.TS_UID
    		INNER JOIN ProjectServer_Reporting.dbo.MSP_TimesheetPeriod AS RepTSP ON ts.WPRD_UID = RepTSP.PeriodUID
    		INNER JOIN MSP_RESOURCES res
    		ON res.RES_UID = ts.RES_UID
    		LEFT JOIN MSP_RESOURCES res_ts_mng
    		ON res.RES_TIMESHEET_MGR_UID = res_ts_mng.RES_UID
    		WHERE tsl.TS_LINE_STATUS = @ts_status and tsl.TS_LINE_ASSN_LAST_WORK is null
    		order by res_ts_mng.RES_TIMESHEET_MGR_UID

    TS_LINE_ASSN_LAST_WORK - Key parameter which can help identify these broken records. Because normally it must be set with any value but not null. This seems like results of some bug, which i hope already resolved.

    After you identify timesheets by user names and timesheet period you can use Delegate method for these users and delete this timesheets or admin tasks in these timesheets. Then, when you did this - repeat script and you can see that records has gone. In addition, affected timesheet managers will not be seen any "bad" admin time-off requests.

    Hope this helps to others.

     

    Alexey

    • Marked as answer by Alexey Koval Monday, July 2, 2012 8:39 AM
    Monday, July 2, 2012 8:39 AM

All replies

  • I have the same symptoms.  The ribbon became disabled after the status manager added a new task to his timesheet and submitted tasks for approval (to himself). 
    Monday, February 21, 2011 6:45 PM
  • Hi All,

     After work with premier support team we were able to solve this issue.

    You can use following script for finding broken timesheet administrative time-off requests (records) on Published database:

     

    declare @class_type int 
    declare @ts_status int
    select @class_type=3
    select @ts_status=4
    
    SELECT	
    		res_ts_mng.RES_NAME as 'Timesheet Manager Name',
    		res.RES_NAME as 'Resource name',
    		RepTSP.PeriodName--,
    	  --tsl.TS_LINE_ASSN_LAST_WORK		
    		
    FROM 
    		MSP_TIMESHEET_LINES tsl
    		INNER JOIN MSP_TIMESHEET_CLASSES tsc 
    		ON tsl.TS_LINE_CLASS_UID = tsc.TS_LINE_CLASS_UID
    		AND (@class_type = 4 OR (@class_type = 3 AND tsc.TS_LINE_CLASS_TYPE <> 0) OR tsc.TS_LINE_CLASS_TYPE = @class_type) 
    		INNER JOIN MSP_TIMESHEETS ts
    		ON ts.TS_UID = tsl.TS_UID
    		INNER JOIN ProjectServer_Reporting.dbo.MSP_TimesheetPeriod AS RepTSP ON ts.WPRD_UID = RepTSP.PeriodUID
    		INNER JOIN MSP_RESOURCES res
    		ON res.RES_UID = ts.RES_UID
    		LEFT JOIN MSP_RESOURCES res_ts_mng
    		ON res.RES_TIMESHEET_MGR_UID = res_ts_mng.RES_UID
    		WHERE tsl.TS_LINE_STATUS = @ts_status and tsl.TS_LINE_ASSN_LAST_WORK is null
    		order by res_ts_mng.RES_TIMESHEET_MGR_UID

    TS_LINE_ASSN_LAST_WORK - Key parameter which can help identify these broken records. Because normally it must be set with any value but not null. This seems like results of some bug, which i hope already resolved.

    After you identify timesheets by user names and timesheet period you can use Delegate method for these users and delete this timesheets or admin tasks in these timesheets. Then, when you did this - repeat script and you can see that records has gone. In addition, affected timesheet managers will not be seen any "bad" admin time-off requests.

    Hope this helps to others.

     

    Alexey

    • Marked as answer by Alexey Koval Monday, July 2, 2012 8:39 AM
    Monday, July 2, 2012 8:39 AM