Timesheet error blocking all other jobs...

[Matteo]

Dear all,
I submit last week my timesheet and actually all the project server 2007
infrastructure is blocked, I tried to delete my last timesheet but the
message provided in the my timesheet page is:
This timesheet is being processed by the system and is unavailable. The data
shown above is that of the last successful save of the timesheet. Changes
have been sent to the server and will process in the order received.
If I check the server settings, manage settings I see a process with me as
owner with these description:
Queue Entry Time 24/09/2007 14.49
Queue Completed Time
Owner My Username
Project Name N/A
Job Type Status Update Rules (Auto-run Rules)
Job State Processing
% complete 0%
Queue Position 1
Queue Type Project
Error
Correlation ID 12b34390-fb75-4993-82eb-23ae328c760b
Correlation Priority Standard Priority
Job ID 992e1c12-12a3-436b-aeac-1490e5b2287b
JobGroup ID 1620f26e-d443-4479-8a0b-6a9a585cacc7
JobInfo ID 12b34390-fb75-4993-82eb-23ae328c760b
Last Admin Action None
Priority Standard Priority
Wait Time (secs) 0
Wakeup Time 24/09/2007 14.04

I tried to cancel it from the manage queue view but nothing happens, all
others jobs are waiting this one to finish, all the company employees
submitted themself timesheet without success because of my task waiting to
complete.

Any Idea? Acutally it's an hell here.

Thank you for any help.

Matteo

 

[Jonathan Sofer]

You need to restart the queue service on the front end server. The queue
will get stuck like this for any number of reasons and restarting the queue
service will allow all the jobs to be processed.

Jonathan

 

[Matteo]

Thank you Jonathan I did it but I have still some jobs appended that get
stuck the queue,
for example:

Many
queue type: Timesheet
job type: Notifications

Few but still in queue
queue type: Project
job type: Project Save from Project Professional and Project Checkin

What can I do? I am still blocking so many people.

I found that sometime IE shows a page saying that the connection to db
server is not available and to check if the server is up and running... it's
up!
Sincerely I don't know where is the problem...

Thank you all

Matteo

 

[Matteo]

Dear all,
now if I try to create an Olap Cube I am receiving this error in the queue:

Error summary/areas:
CBS message processor failed
CBSASConnectionFailure
Queue
GeneralQueueJobFailed
Error details:

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="CBS message processor failed">
<error id="17003" name="CBSASConnectionFailure"
uid="9df539ae-a201-4c6e-9d43-04aaf3880681" QueueMessageBody="Setting
UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=prjserver
ASDBName=progetti ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0
NextNum=1 NextUnit=0 FromDate=09/26/2007 11:27:02 ToDate=09/26/2007 11:27:02
HighPriority=True" Error="Analysis Services session failed with the following
error: Failed to connect to the Analysis Services server prjserver. Error:
Cannot connect to the repository.

Analysis server: prjserver

Error:
Impossibile usare "". File in use." />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="8fa168b2-c346-4d60-8f2f-5c31bea8fdbf"
JobUID="7812b89f-034b-460d-b146-8770d23102ff" ComputerName="SERVERNAME"
GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>

I don't really what is happening since monday morning.

Thank you all

Matteo

 

[Jonathan Sofer]

It sounds to me like there has been some changes made to your environment on
the servers or to the system accounts you are using to connect to your
servers. I would try and see what those changes might have been by looking
in the event logs on the servers and see what might have changed right
before the errors started occuring. Can you contact your IT group and see
if they changed anything?

Sorry for your troubles.

Jonathan