Error - "Index on table MSP_PROJECTS.... does not exist"

[Doug]

I recieved the error that one or more indexes on MSP_PROJECTS table does not
exist while updateing task updates on two different projects. I processed
task updates on two other tasks stored in this same project database with no
such error. The error message does not provide the name(s) of the offending
index(es). Using SQL Enterprise manage I can see three indexes on
MSP_PROJECTS. I also see these same indexes on the "development" Project
server. I did not compare the properties of these indexes between Project
Project Server and the Development machine.

Any thoughts as to why this occurred... and more importantly how to prevent
re-occurance.

As I side note, I did have Crystal Reports open with a report that querries
the Production Project server... but that would not explain why the problem
is intermittent.

Thanks in advance.

 

[Gary L. Chefetz [MVP]]

Doug:

Do you see errors in the Server Application Event Log? Posting these might
help.

 

[Doug]

Here is the message from the application error log

Component: PjBusObj
File:
C:\Office\devsp\project\WebClient\source\server\pjbusobj\PjTaskBusObj.cpp
Line: 4902
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also included.]]></Description>

 

[Doug]

It seems that the permissions on the ViewDrop folder were inadequate.
Microsoft recommended granting very liberal access to the ViewDrop folder,
and the problem went away. The explanation was that the db connection was
timing out. When that happens a "timing service" takes over, and apparently
it had insufficient privs.on the "ViewDrop" folder.

Doug