some timesheets not being processed

Dec 8, 2009 at 1:10 PM

Hello,

We are using the Timesheet Tied-Mode Service/Event handler, and for the most part it is working well, however I have a handful of timesheets that are not being processed (they show up with a null dateProcessed in the tsAutoStatus table).  A lot of the timesheets are for the same user.  From what I can tell, some timesheets for the users have processed fine, and the timesheets include a variety of projects and tasks (not necessarily the same project/task on every problematic timesheet).  I have picked a user and tried deleting their timesheet and recreating it one line at a time to see if a specific project was causing the problem, but the timesheet still didn't process. 

Here is a snippet from a recent ULS log (I changed the real domain\username value):

(Watson Reporting Cancelled) System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.     at System.Data.SqlClient.TdsParser.ReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj)     at System.Data.SqlClient.SqlDataReader.ReadColumnData()     at System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean setTimeout)     at System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i)     at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i)     at Microsoft.Office.Project.Server.DataAccessLayer.ProjectDal.GetChangeData(SqlDataReader reader, Int32 column)     at Microsoft.Office.Project.Server.DataAccessLayer.ProjectDal.ReadAssignmentChanges(Guid assignmentUID)     at Microsoft.Office.Project.DataEdit.Dal.DalDat...    2b747319-6255-4ecc-b414-7e447c404cb8
12/08/2009 05:50:26.74*    w3wp.exe (0x17EC)                           0x1E60    Project Server                    Project Server - General          0    Exception    ...aAccess.GetChangeLog(Guid docGuid, Int32 entityID, Guid guid)     at Microsoft.Office.Project.DataEdit.Assignments.AssnCntr.FindAssnNode(Guid guid)     at Microsoft.Office.Project.DataEdit.Document.SvrDoc.GetDataForAssignment(Guid guidAssn)     at Microsoft.Office.Project.Server.BusinessLayer.Statusing.ImportTimesheet(Guid periodUID)     at Microsoft.Office.Project.Server.WebService.Statusing.ImportTimesheet(Guid periodUID)    2b747319-6255-4ecc-b414-7e447c404cb8
12/08/2009 05:50:26.74     w3wp.exe (0x17EC)                           0x1E60    Project Server                    Project Server - General          0    Medium      PWA:http://projectserver/PWA, SSP:SharedServices1, User:mydomain/username, PSI: Statusing.ImportTimesheet  Undefined Attributes: PSError: GeneralUnhandledException  Undefined attributes list: System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.     at System.Data.SqlClient.TdsParser.ReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj)     at System.Data.SqlClient.SqlDataReader.ReadColumnData()     at System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean setTimeout)     at System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i)     at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i)     at Microsoft.Office.Project.Server.DataAccessLayer.ProjectDal.GetChangeData(SqlDataReader reader, Int32 co...    2b747319-6255-4ecc-b414-7e447c404cb8
12/08/2009 05:50:26.74*    w3wp.exe (0x17EC)                           0x1E60    Project Server                    Project Server - General          0    Medium      ...lumn)     at Microsoft.Office.Project.Server.DataAccessLayer.ProjectDal.ReadAssignmentChanges(Guid assignmentUID)     at Microsoft.Office.Project.DataEdit.Dal.DalDataAccess.GetChangeLog(Guid docGuid, Int32 entityID, Guid guid)     at Microsoft.Office.Project.DataEdit.Assignments.AssnCntr.FindAssnNode(Guid guid)     at Microsoft.Office.Project.DataEdit.Document.SvrDoc.GetDataForAssignment(Guid guidAssn)     at Microsoft.Office.Project.Server.BusinessLayer.Statusing.ImportTimesheet(Guid periodUID)     at Microsoft.Office.Project.Server.WebService.Statusing.ImportTimesheet(Guid periodUID)    2b747319-6255-4ecc-b414-7e447c404cb8
12/08/2009 05:50:26.72     w3wp.exe (0x17EC)                           0x1E60    Office Server                     Office Server General             900n    Critical    A runtime exception was detected. Details follow.  Message: Exception of type 'System.OutOfMemoryException' was thrown.  Techinal Details: System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.     at System.Data.SqlClient.TdsParser.ReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj)     at System.Data.SqlClient.SqlDataReader.ReadColumnData()     at System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean setTimeout)     at System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i)     at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i)     at Microsoft.Office.Project.Server.DataAccessLayer.ProjectDal.GetChangeData(SqlDataReader reader, Int32 column)     at Microsoft.Office.Project.Server.DataAccess...    2b747319-6255-4ecc-b414-7e447c404cb8
12/08/2009 05:50:26.72*    w3wp.exe (0x17EC)                           0x1E60    Office Server                     Office Server General             900n    Critical    ...Layer.ProjectDal.ReadAssignmentChanges(Guid assignmentUID)     at Microsoft.Office.Project.DataEdit.Dal.DalDataAccess.GetChangeLog(Guid docGuid, Int32 entityID, Guid guid)     at Microsoft.Office.Project.DataEdit.Assignment    2b747319-6255-4ecc-b414-7e447c404cb8

 

and another snippet from the tied mode log (i changed the real username):

5:50:26 AM: STEP 1 - Initialize Web Service urls
5:50:26 AM: STEP 2 - Start event override for timesheet UID: 70b75dee-3e37-43d1-a371-96daffd61200
5:50:26 AM: STEP 3 - Statusing Impersonation for RES_UID: cda8286f-886e-4021-bc0e-0f7e8b51f3a9
5:50:26 AM: FAILED due to an exception: ==============================
Error:

System.Web.Services.Protocols.SoapException: ProjectServerError(s) LastError=GeneralUnhandledException Instructions: Pass this into PSClientError constructor to access all error information
   at Microsoft.Office.Project.Server.WebService.Statusing.ImportTimesheet(Guid periodUID)
==============================
PSCLientError Output:
 
GeneralUnhandledException

============================
5:50:26 AM: SubmitStatus: True; timesheet URL: http://projectserver/PWA/_vti_bin/psi/timesheet.asmx; statusing URL: http://projectserver:56737/SharedServices1/psi/statusing.asmx
5:50:26 AM: Timesheet: My Timesheet; Resource: username; Creator: username, Period: 22cea720-b4e4-4ce1-b18b-6c76bde8f8d4
5:50:26 AM: Total execution time: 0.35 seconds; SubmitStatus: 0.00 seconds

Any ideas or things to look at would be greatly appreciated.

Thanks

Feb 25, 2010 at 2:24 PM

Hey JHCook - did you ever find a resolution for this?  I'm having the exact same errors with just a few users timesheets, while the majority of them work great.

Thanks!

Feb 25, 2010 at 8:30 PM

I was able to find a resolution to this!  See the link below for more info, but the basics of it is some of the tasks in the users timesheet were assigned a different Assignment Owner.  The Assignment Owner needs to be the same as the user who's timesheet it is.

http://blogs.msdn.com/brismith/archive/2008/05/16/project-server-2007-have-you-ever-got-stuck-in-the-timesheet-import-page.aspx?CommentPosted=true#commentmessage

Feb 25, 2010 at 9:21 PM

Hi Tasita,

Thanks for the reply!  I'll take a look at the link - hopefully that will solve my issue as well.

Thanks

Feb 25, 2010 at 9:33 PM

Tasita,

Did you run a SQL query to determine which tasks had a different assignment owner, or did you just look at the tasks in Project?

Thanks

 

Feb 25, 2010 at 10:32 PM

We just manually looked at all the tasks that the user's had assigned to them.