Queue problem

[Mocha]

I have a queue problem.
It has been more than 5 days left and the queue process hasn't been finished
yet (since 14 Desember until now). The progress still in 40%
I have tried to cancel this jobs but nothing happen.
I haven't restarted the Queue service yet cause there is few pending jobs
that waiting to be processed.
This porblem make the project manager could not publish the project file so
he couldnt deliver assignment to his resource.

Do you have any suggestion?
Tengkyu

 

[Kurt Verhaegen]

Hi,
You can restart the Queue services. THe pending jobs are registered in the
SQL server DB and will be picked up by the queue services.
Grtz, Kurt

 

[Gary L. Chefetz [MVP]]

It sounds like the failed job is blocking others, so you need to clear it
one way or the other. If restarting the queue is the only answer... then do
it, but make note of the other jobs that you might loose, so you can
recreate the data if necessary.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[Kurt Verhaegen]

Gary,
To my knowledge the queue process has multiple threads, so if none of the
jobs get processed, and all 4 (default) threads are blocked, then you have
this case. On the other hand it could be that the timesheet queue process or
queue service is in a hang/blocking state.
I'm not aware that you loose data, as long as you don't delete/cancel the
jobs or dig into the database, since the jobs are recorded in the database.
If you cancel a job then yes you can loose data not only from that job but
also consequtive jobs for the same correlation ID.
Or I'm I missing information when you say '...make note of the other jobs'.
Grtz, Kurt

 

[Zheng zard zhun]

Dear Gary

I have a similar problem, there is one job was held in queue for a while,
the job state is "Getting Queeud", and the type is "Project Save from Project
Professional". It occured when i tried to publish this project from
Professional 2007 to server 2007, and suddently the professional 2007 shut
down....
I tried cancel the job, but not work, and even restarted Queue Service did
not work. What can i do?

 

[Gary L. Chefetz [MVP]]

Kurt:

Your statement is how it is supposed to work. Your experience may vary. I
know that mine has.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[Mocha]

Finally i restarted my queue service.
Then my queue start to queue another process.
Is there anyway to icrease the performance of queue service? Im using
project server 2007.(instead from manage queue configuration)

Thank you...

 

[Zheng zard zhun]

Anyway the queue seems a little bit more sensitive....but in my opinion, next
time you met the queue problem--no matter what type it is, you can cancel the
job by select "Cancel jobs getting enqueued"---from "Server Setting-->Manage
Queue Jobs-->Adcanced Options-->Cancel jobs getting enqueued".