Welcome, Guest Login

Search for Common Ground's US offices are closed on Monday 19 January 2015 for Martin Luther King Jr. Day. Requests received during this time intended for US-based staffers will be answered on 20 January, unless urgent.

SFCG Help Center

Overdue Timesheet Poller - Issues Checklist

Last Updated: Aug 15, 2014 10:24AM EDT

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.


To Test:

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.'

Known Issues:

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

seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found