Project Server 2007 Queue Not Processing

[William Busby]

I have a fresh install of Project Server 2007. The install finished cleanly
and everything came up first time (kudo's to MS for getting the install
process improvements done). When I looked at the queue there were 8 jobs that
appear to be run as a result of the install. I created a project proposal and
activity plan which added three jobs each. None of the jobs have completed in
the past 8 hrs. I've restarted them (well... nothing said the restarted but I
did punch the button). Haven't canceled them cause I'd rather see them work
even though the've far exceeded the retry intervals with no status update
saying they failed. Looks like the queue is just stitting there. Is there any
way to kickstart the queue? I can't find a corresponding service to restart.

 

[Ray McCoppin]

You should check and verfiy that the Microsoft Project Server Queuing service
is runing on your application server. If it is not running you should start
it. If it is running you should try to restart it.

Hope this helps.

 

[William Busby]

The odd thing is that I have no services called 'Microsoft Project *'
installed. Could someone send me a list of the services and the associated
executables so I can validate what's missing?

 

[Ray McCoppin]

There should be two executables running on your app server.
Microsoft.Ofiice.Project.Server.Eventing.exe
Microsoft.Office.Project.Server.Queuing.exe

It should be in the path C:\Program Files\Microsoft Office Servers\12.0\Bin

Hope this helps.

 

[William Busby]

Can you (or anyone) send me a regedit dump of the services installed below. I
have the binaries on my server but no services were defined for either of
them. I attempted to recreate the service entries but they fail to start with
an error that dependencies are missing.

 

[William Busby]

Ok... made some progress on this but not enough. I found out how to install
the missing services using the 'installutil.exe <executable>' command in the
..Net Framework. The eventing service installed and started without a problem.
The queue service claimed to install but isn't listed in the services list.
When I attempted to reinstall it threw an exception because the services was
already installed. I can see the service in regedit, this is the export of
the service entry...
Key Name: HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\MSPSQS
Class Name: <NO CLASS>
Last Write Time: 8/25/2006 - 2:03 PM
Value 0
Name: Type
Type: REG_DWORD
Data: 0x10

Value 1
Name: Start
Type: REG_DWORD
Data: 0x3

Value 2
Name: ErrorControl
Type: REG_DWORD
Data: 0x1

Value 3
Name: ImagePath
Type: REG_EXPAND_SZ
Data: "D:\Program Files\Microsoft Office
Servers\12.0\Bin\Microsoft.Office.Project.Server.Queuing.exe"

Value 4
Name: ObjectName
Type: REG_SZ
Data: acslan\wb3


Key Name:
HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\MSPSQS\Security
Class Name: <NO CLASS>
Last Write Time: 8/25/2006 - 2:03 PM
Value 0
Name: Security
Type: REG_BINARY
Data:
00000000 01 00 14 80 b8 00 00 00 - c4 00 00 00 14 00 00 00 ....¸...Ä.......
00000010 30 00 00 00 02 00 1c 00 - 01 00 00 00 02 80 14 00 0...............
00000020 ff 01 0f 00 01 01 00 00 - 00 00 00 01 00 00 00 00 ÿ...............
00000030 02 00 88 00 06 00 00 00 - 00 00 14 00 fd 01 02 00 ............ý...
00000040 01 01 00 00 00 00 00 05 - 12 00 00 00 00 00 18 00 ................
00000050 ff 01 0f 00 01 02 00 00 - 00 00 00 05 20 00 00 00 ÿ........... ...
00000060 20 02 00 00 00 00 14 00 - 8d 01 02 00 01 01 00 00 ...............
00000070 00 00 00 05 04 00 00 00 - 00 00 14 00 8d 01 02 00 ................
00000080 01 01 00 00 00 00 00 05 - 06 00 00 00 00 00 14 00 ................
00000090 00 01 00 00 01 01 00 00 - 00 00 00 05 0b 00 00 00 ................
000000a0 00 00 18 00 fd 01 02 00 - 01 02 00 00 00 00 00 05 ....ý...........
000000b0 20 00 00 00 23 02 00 00 - 01 01 00 00 00 00 00 05 ...#...........
000000c0 12 00 00 00 01 01 00 00 - 00 00 00 05 12 00 00 00 ................

And the install log for the service

Installing assembly 'D:\Program Files\Microsoft Office
Servers\12.0\Bin\Microsoft.Office.Project.Server.Queuing.exe'.
Affected parameters are:
logtoconsole =
assemblypath = D:\Program Files\Microsoft Office
Servers\12.0\Bin\Microsoft.Office.Project.Server.Queuing.exe
logfile = D:\Program Files\Microsoft Office
Servers\12.0\Bin\Microsoft.Office.Project.Server.Queuing.InstallLog
Installing service MSPSQS...
Service MSPSQS has been successfully installed.
Creating EventLog source MSPSQS in log Application...
Committing assembly 'D:\Program Files\Microsoft Office
Servers\12.0\Bin\Microsoft.Office.Project.Server.Queuing.exe'.
Affected parameters are:
logtoconsole =
assemblypath = D:\Program Files\Microsoft Office
Servers\12.0\Bin\Microsoft.Office.Project.Server.Queuing.exe
logfile = D:\Program Files\Microsoft Office
Servers\12.0\Bin\Microsoft.Office.Project.Server.Queuing.InstallLog

Any ideas on how to get this service to show and start?

 

[William Busby]

More info, I found the MSPSQS service and gave it a display name which made
it appear in the list of services. When I start the service it immediately
dies with the following events in event viewer

8/25/2006 3:10:42 PM Office SharePoint Server Error 1096
6566 N/A ACAT0513 No sites defined. Service shutting down.
8/25/2006 3:10:42 PM Office SharePoint Server Error Project Server Queue
6564 N/A ACAT0513 Invalid SSP: UID: 00000000-0000-0000-0000-000000000000
8/25/2006 3:10:41 PM MSPSQS Information None 0 N/A ACAT0513 Service started
successfully.


I'm feeling like a hunting dog on a hot trail here but I've no idea where
it's leading. I can't find info on TechNet but I'm continue to research. If
anyone else has input I'd be glad to hear it.

 

[Ray McCoppin]

you might want to try to reinstall Project Server 2007. Hopefully it will
repair the installation. But from my experence with this beta you might want
to start all over with a fresh install of the OS. This is a beta product.

 

[William Busby]

Generally good advise... unfortunately this is my sixth install (I'm either
masochistic or a slow learner, depends on who you ask). I've used three
different servers (4 were fresh rebuilds including OS) and the last two were
done after I redownloaded the image just in case I had a media problem. In
each case the result was exactly the same. I expect to have issues with beta
software, but this is the first time I've gotten such a consistent (and
debilatating) issue and found I appear to be alone on this one. I appreciate
the feedback, I honestly do. It's much better than posting in the blind even
if we haven't gotten it resolved.

 

[Dave]

I'm right there with you. We are having the exact same problem with
the queuing service dying and we have not yet found a resolution to the
issue.