We have the same problem. The job is not really stuck, but it lasts for 20 minutes and the Queue uses 100% of one CPU during this time.
Status updates for other projects are completed in seconds and some time ago status updates for the now affected project worked in seconds, too. I am not aware of any significant change in that project.
I even made a copy of that project and made a status update and had the same effect. SO something seems to be special about that project, but what?
DavidF wrote:
Excellent - thanks for that Ben.
17-Jul-07
Excellent - thanks for that Ben. It appears to have fixed the security issue
- I have set myself up in the following groups (Administrators, Project
Managers & Resource Managers), and assigned the following categories with
full permissions (My Direct Reports, My Projects, My Resources and My Tasks)
However, approval processing for Task Updates still does not appear to work
- I have approved a timesheet for another resource
- I have logged on as that resource and imported the timesheet in My
Tasks, and submitted for approval
- I have then logged on again as myself, and approved the Task Updates
However, when I look at the job queue, it is again stuck on 40% complete in
a job state of "Processing". The same thing (approving a task update) from
yesterday ended overnight with a job state of cancelled (because I tried to
cancel it yesterday) - so I'm not sure if the associated error message is
still relevant (see following)
--------------------------------------------------------------
Error summary/areas
ProjectHasNoWriteLoc
ProjectHasNoWriteLoc
Queu
GeneralQueueJobFaile
Error details
<?xml version="1.0" encoding="utf-16"?
<errinfo
<general
<class name="ProjectHasNoWriteLock"
<error id="1042" name="ProjectHasNoWriteLock"
uid="a5f78181-66ba-4314-8a83-253a2c237314" /
</class
<class name="Queue"
<error id="26000" name="GeneralQueueJobFailed"
uid="8cd73b84-d748-47ce-ab98-e18ae4b967f8"
JobUID="82283daf-a875-4699-975a-03517db46d27" ComputerName="SGAPSYS011"
GroupType="StatusApproval"
MessageType="StatusApprovalReleaseProjectWriteLockMessage" MessageId="4"
Stage="" /
</class
</general
</errinfo
----------------------------------------------------------------
:
Previous Posts In This Thread:
PWA - Security Issue & Processing hung
I am currently running a pilot MS Project Server installation and have the
following problems
1. When I logon to PWA as an authenticated LAN user, I keep getting asked
to sign-on again when I try to perform certain tasks (eg. Approving task
updates). Note that I am set up as an administrator. Further, when I
re-enter my user password (or another valid administrator user/password), the
logon screen just keeps re-appearing, and I have to close the browser down.
However, if I change my user details to point to a local account on the
actual server (instead of my LAN account), I am able to logon and perform all
tasks in PWA
2. My second problem is that I have successfully accepted some task updates
(using a local server account), but the status update task appears to be
stuck in processing mode when I look at the queue in PWA. The job state says
"Processing" and it is 40% complete, and has been for several hours. There
is nothing else running in the queue. I have tried cancelling the job,
rebooting the server, and explicitly restarting the Project Server Queue
Service, but it won't budge
Can someone please offer some advice?
Re 1) - Are you assigned to the correct groups (its not enough just to be an
Re 1) - Are you assigned to the correct groups (its not enough just to be an
administrator, you need to be a member of the Project Manager group etc).
Make sure you logged on as the correct Windows Account. You should only need
to type in a username\password if you are using forms authentication.
Potentially it could be IE caching usernames and passwords, and these will
need to be cleared.
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/
:
Excellent - thanks for that Ben.
Excellent - thanks for that Ben. It appears to have fixed the security issue
- I have set myself up in the following groups (Administrators, Project
Managers & Resource Managers), and assigned the following categories with
full permissions (My Direct Reports, My Projects, My Resources and My Tasks).
However, approval processing for Task Updates still does not appear to work:
- I have approved a timesheet for another resource.
- I have logged on as that resource and imported the timesheet in My
Tasks, and submitted for approval.
- I have then logged on again as myself, and approved the Task Updates.
However, when I look at the job queue, it is again stuck on 40% complete in
a job state of "Processing". The same thing (approving a task update) from
yesterday ended overnight with a job state of cancelled (because I tried to
cancel it yesterday) - so I'm not sure if the associated error message is
still relevant (see following).
---------------------------------------------------------------
Error summary/areas:
ProjectHasNoWriteLock
ProjectHasNoWriteLock
Queue
GeneralQueueJobFailed
Error details:
<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="ProjectHasNoWriteLock">
<error id="1042" name="ProjectHasNoWriteLock"
uid="a5f78181-66ba-4314-8a83-253a2c237314" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="8cd73b84-d748-47ce-ab98-e18ae4b967f8"
JobUID="82283daf-a875-4699-975a-03517db46d27" ComputerName="SGAPSYS011"
GroupType="StatusApproval"
MessageType="StatusApprovalReleaseProjectWriteLockMessage" MessageId="4"
Stage="" />
</class>
</general>
</errinfo>
-----------------------------------------------------------------
:
Re: PWA - Security Issue & Processing hung
ProjectHasNoWriteLock sound like a DB error. Is everything OK with the
DB? Can you query without issue in the ProjectServer DB?
B.
I can successfully query the ProjectServer_Draft, ProjectServer_Published &
I can successfully query the ProjectServer_Draft, ProjectServer_Published &
ProjectServer_Reporting databases, and I tried adding a test row (with dummy
data) to the MSP_TASKS_SUBMITTED table in the ProjectServer_Published
database, which was successful (and then I deleted the row OK as well).
The MSP_TASKS_SUBMITTED table (in both the Published and Draft databases)
have zero rows - but from the name I thought there may have been at least one
row as I have submitted a task for approval (but I'm guessing at the way it
works).
Note that I am using SQL Server 2005 installed on the same machine as
Project Server 2007.
:
Re: PWA - Security Issue & Processing hung
Perhaps someone else can answer then. I am on PS 2003 with SQL Server
2000.
I say it still sounds like a DB error.
B.
OK, thanks for your thoughts Brian.
OK, thanks for your thoughts Brian.
I have tried cancelling this job in the queue, but it has no effect. Unless
someone else has a different suggestion, I am going to clean out the server
and reinstall all the software (SQL Server 2005 and MS Project Server 2007).
I will then set up my users & custom fields again, create a very simple
project, and try the same sequence :
Timesheet entry -> submit -> approve -> Task update - import Timesheet ->
submit for approval -> (try to) approve ....
:
Status Update Job stuck at 40%
We have the same problem. The job is not really stuck, but it lasts for 20 minutes and the Queue uses 100% of one CPU during this time.
Status updates for other projects are completed in seconds and some time ago status updates for the now affected project worked in seconds, too. I am not aware of any significant change in that project.
I even made a copy of that project and made a status update and had the same effect. SO something seems to be special about that project, but what?
Submitted via EggHeadCafe - Software Developer Portal of Choice
Featured Product / Service Review: TekPub
http://www.eggheadcafe.com/tutorial...2e-39384482c80e/featured-product--servic.aspx