Overdue Timesheet Polling Service Installation
Use registry editor to create Event Log if it doesn’t already exist. HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog. .
Make sure that the Overdue Timesheet Users list exists (it should).
Open a command prompt window in C:\applications\SFCGoverdueTimesheetPolling and type:
You may have to restart IIS. //Cdel IT: not necessary
Go to the 14 hive
(C:\Program Files\Common Files\Microsoft Shared\web server extensions\14\bin). Verify that the OWSTIMER.EXE.config file has the following settings:
o Set SFCGConnectionString
o Set SFCGSiteURL app setting.
o Set OverdueTimesheetListURL app setting
o Set employeeNameColumnName app setting.
o Set payPeriodEndingColumnName app setting
Save the file
Go to Central Admin->Monitoring->Scheduled Jobs. Look for entries of SFCG Timesheet Polling.
Confirmed that new entries are created and that the status is Succeeded.
1) Check if the following list contains updated data: https://sharepoint.sfcg.org/Lists/Overdue%20Timesheet%20Users/Allitemsg.aspx
2) Test Overtime timesheet module
To check the Overdue Timesheet Report, you need to go to https://sharepoint.sfcg.org/Applications/Timesheets.aspx while logged in as a Timesheet Admin. Currently, I believe only four accounts have this access: Terpsys is one of them.
When logged in as an admin, there are six options in a blue bar just below the regular menu. 'Generate Reports' is the 2nd.
After selecting that, it will give you a drop down box of reports to select. Select 'Overdue Timesheet Report' and it will refresh the screen and allow you to enter a Pay Period to run the report for. Choose and enter the latest final date for a pay period. Right now that is 11/15/2013 (Our pay period ends on the 15th and the last day of the month). Click the check boxes next to both full and part time employment status and select 'Generate Report'.
A correct response will be an excel list with the same names as are on the Overdue Timesheet List, with status of where they are in the process of filling out their timesheets.
An incorrect response (unless there are no overdue timesheets) is a red error message stating 'There are no records to display.'
1) Recordset was not closed properly and is blocking new connections.
Event Viewer: An error was encountered during the polling operation: There is already an open DataReader associated with this Command which must be closed first.
- Add to the database query string de C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN\OWSTIMER.exe.config:
- Restart the service “Sharepoint Timer” to use the new configuration