locked
Timesheets waiting to be processed (queue) - project server 2007 RRS feed

  • Question

  • We are working on project server 2007, we have setup the timesheet (periods, administrative time etc.) this job remains in the queue waiting to be processed and does not end never (0%). Not generate an error.

    Thanks for your help!
    Tuesday, January 28, 2014 3:12 PM

All replies

  • Hi,

    try to restart Project server queue and event services .

    execute this commads shell in order.

    echo stop Queue..
    
    net stop ProjectQueueService
    
    echo stop Event..
    
    net stop ProjectEventService
    
    echo IIS reset...
    
    iisreset
    
    echo start Event..
    
    net start ProjectEventService
    
    echo start Queue..
    
    net Start ProjectQueueService
    
    ECHO it's Ok...

    Hope this help you.


    Jalal Blali MCTS, MCITP

    Tuesday, January 28, 2014 4:16 PM
  • Hi Jalal

    We restarted the services on the server directly but not through shell. jobs continue waiting in queue (0%)

    ¿Any other solution?

    Tks,

    Tuesday, January 28, 2014 8:12 PM
  • Hi,

    Do you see any related error in the Application log. I would suggest you to dig out the ULS log to find out the cause of the issue?

    What is the Position number of the timesheet jobs those are waiting to be processed in the Queue? Any other jobs which is stopping to complete the timesheets jobs?


    Warm Regards Badal Ratra

    Wednesday, January 29, 2014 2:15 AM
  • Hi, 

    Can you save or publish any project ? if yes that's mean it's not queue problem. if not may be another job is blocking and timesheet job is just queued.

    anyway, try to recompile project stored procedures.

    Execute this sql script (DBCC FreeProcCache).




    Jalal Blali MCTS, MCITP

    Wednesday, January 29, 2014 10:27 AM
  • Hi Badal

    some log messages:

    01/28/2014 00:00:21.23  OWSTIMER.EXE (0x1634)                    0x167C Project Server                 Project Server Queue           8the Medium   PWA:http://psproyectos/PWA, SSP:SSP_Personalsoft, User:PERSONALSOFT\adminproject, PSI:   [QUEUE] [SENDER] TimesheetQ: BeginMessageGroup(63edd7aa-1e2d-4623-b004-0fde52d6d554,f230525b-834b-48d5-a093-ae4d13c9d0e9,ArchiveGlobalProject,StandardPriority): JobUID: 23e4aa21-ac5c-4a6c-83e9-1d7a873acf11
    01/28/2014 00:00:21.23  OWSTIMER.EXE (0x1634)                    0x167C Project Server                 Project Server Queue           8thf Medium   PWA:http://psproyectos/PWA, SSP:SSP_Personalsoft, User:PERSONALSOFT\adminproject, PSI:   [QUEUE] [SENDER] TimesheetQ: Send( Microsoft.Office.Project.Server.BusinessLayer.QueueMsg.ArchiveGlobalProjectMessage ): ID: 1 GroupUID: 63edd7aa-1e2d-4623-b004-0fde52d6d554
    01/28/2014 00:00:21.23  OWSTIMER.EXE (0x1634)                    0x167C Project Server                 Project Server Queue           8thg Medium   PWA:http://psproyectos/PWA, SSP:SSP_Personalsoft, User:PERSONALSOFT\adminproject, PSI:   [QUEUE] [SENDER] TimesheetQ: EndMessageGroup(): GroupUID: 63edd7aa-1e2d-4623-b004-0fde52d6d554
    01/28/2014 00:00:06.48  Microsoft.Office.Project.Server (0x1AF8) 0x1B00 Project Server                 Project Server Queue           8the Medium   PWA:http://psproyectos/PWA, SSP:SSP_Personalsoft, User:PERSONALSOFT\adminproject, PSI:   [QUEUE] [SENDER] TimesheetQ: BeginMessageGroup(5e7e46ba-81aa-46a7-b7dc-dc562d719386,6c86d1df-b1e1-4e96-9ea6-ebab6cbff374,QueueCleanup,StandardPriority): JobUID: a9740bef-b854-4576-bb1a-db6ce408b07b
    01/28/2014 00:00:06.49  Microsoft.Office.Project.Server (0x1AF8) 0x1B00 Project Server                 Project Server Queue           8thf Medium   PWA:http://psproyectos/PWA, SSP:SSP_Personalsoft, User:PERSONALSOFT\adminproject, PSI:   [QUEUE] [SENDER] TimesheetQ: Send( Microsoft.Office.Project.Server.BusinessLayer.QueueMsg.QueueCleanupMessage2 ): ID: 1 GroupUID: 5e7e46ba-81aa-46a7-b7dc-dc562d719386
    01/28/2014 00:00:06.49  Microsoft.Office.Project.Server (0x1AF8) 0x1B00 Project Server                 Project Server Queue           8thg Medium   PWA:http://psproyectos/PWA, SSP:SSP_Personalsoft, User:PERSONALSOFT\adminproject, PSI:   [QUEUE] [SENDER] TimesheetQ: EndMessageGroup(): GroupUID: 5e7e46ba-81aa-46a7-b7dc-dc562d719386
    01/28/2014 00:00:06.51  Microsoft.Office.Project.Server (0x1AF8) 0x23EC Project Server                 Project Server Queue           7h52 Medium   PWA:http://psproyectos/PWA, SSP:SSP_Personalsoft, User:PERSONALSOFT\adminproject, PSI:   [QUEUE] ProjectQ: Starting group 2d95bccb-4caf-41b0-b191-45caf9c8b0bc type = QueueCleanup priority = StandardPriority
    01/28/2014 00:00:06.51  Microsoft.Office.Project.Server (0x1AF8) 0x1B00 Project Server                 Project Server Queue           8the Medium   PWA:http://psproyectos/PWA, SSP:SSP_Personalsoft, User:PERSONALSOFT\adminproject, PSI:   [QUEUE] [SENDER] TimesheetQ: BeginMessageGroup(28893ecf-11c9-4072-9b56-0a7321412c1c,6c86d1df-b1e1-4e96-9ea6-ebab6cbff374,QueueCleanup,StandardPriority): JobUID: 892ca1c4-2437-4c1e-a8f3-1046d4068614
    01/28/2014 00:04:14.60  w3wp.exe (0x1340)                        0x119C Project Server                 Project Server Queue           8thf Medium   PWA:https://project.personalsoft.com/PWA, SSP:SSP_Personalsoft, User:PERSONALSOFT\raalvarez, PSI: Admin.UpdateReportingPeriods  [QUEUE] [SENDER] TimesheetQ: Send( Microsoft.Office.Project.Server.BusinessLayer.QueueMsg.ReportTimesheetPeriodSyncMessageEx ): ID: 1 GroupUID: b84b7934-d2b8-4885-a6ac-d6b6b488f3d0
    01/28/2014 00:04:14.85  w3wp.exe (0x1340)                        0x119C Project Server                 Project Server Queue           8thg Medium   PWA:https://project.personalsoft.com/PWA, SSP:SSP_Personalsoft, User:PERSONALSOFT\raalvarez, PSI: Admin.UpdateReportingPeriods  [QUEUE] [SENDER] TimesheetQ: EndMessageGroup(): GroupUID: b84b7934-d2b8-4885-a6ac-d6b6b488f3d0
    01/28/2014 00:04:15.23  w3wp.exe (0x1340)                        0x119C Project Server                 Project Server Queue           8the Medium   PWA:https://project.personalsoft.com/PWA, SSP:SSP_Personalsoft, User:PERSONALSOFT\raalvarez, PSI: Admin.UpdateReportingPeriods  [QUEUE] [SENDER] TimesheetQ: BeginMessageGroup(0dbf848e-b89a-409b-a5f8-d1903ab5c02e,353c4476-7a2e-4e23-9bd7-ada4e7b0293e,ReportingTimesheetPeriodSync,MediumLowPriority): JobUID: ec49add9-025f-4ca2-828d-2cc1dc5d647b
    01/28/2014 00:04:15.43  w3wp.exe (0x1340)                        0x119C Project Server                 Project Server Queue           8thf Medium   PWA:https://project.personalsoft.com/PWA, SSP:SSP_Personalsoft, User:PERSONALSOFT\raalvarez, PSI: Admin.UpdateReportingPeriods  [QUEUE] [SENDER] TimesheetQ: Send( Microsoft.Office.Project.Server.BusinessLayer.QueueMsg.ReportTimesheetPeriodSyncMessageEx ): ID: 1 GroupUID: 0dbf848e-b89a-409b-a5f8-d1903ab5c02e
    01/28/2014 00:04:15.69  w3wp.exe (0x1340)                        0x119C Project Server                 Project Server Queue           8thg Medium   PWA:https://project.personalsoft.com/PWA, SSP:SSP_Personalsoft, User:PERSONALSOFT\raalvarez, PSI: Admin.UpdateReportingPeriods  [QUEUE] [SENDER] TimesheetQ: EndMessageGroup(): GroupUID: 0dbf848e-b89a-409b-a5f8-d1903ab5c02e

    Wednesday, January 29, 2014 7:40 PM
  • Hi Jalal,

    I can save and publish the project without any problem. Only happens with timesheets.

    Wednesday, January 29, 2014 7:50 PM
  • Jalal,

    What database the script is run?

    Wednesday, January 29, 2014 7:51 PM
  • Hi,

    choosing database is not necessary for this script.


    Jalal Blali MCTS, MCITP

    Wednesday, January 29, 2014 9:28 PM