MSP_VIEW_SERVICE_FILE_DELETE_PENDING

[ivan80]

Hi

What is the purpose of this table?

It has a few hundred rows in it. Is it supposed to be full or should it
purge itself ?

Could this have anything to do with the Viewdrop folder problems? (xml files
not being removed automatically)?

We have Project Server 2003 SP2a + SQL 2000 SP3

thanks
Ivan

 

[ivan80]

Nobody knows I guess....

 

[Carl Paul]

Hi Ivan80

I believe this table is a work table used internally by Project Server
VWNotify service to co-ordinate the deletion of xml job files from the
ViewDrop directory once their jobs have been completed.


The VWNotify process actually has a fairly sophisticated dequeuing
algorithm. Picture a restaurant where the waiters write up orders on little
chits and add them to a pending list tree. Every once in a while the cook
looks at all the pending items and pulls off a couple of jobs that he would
like to work on concurrently. He takes the chits down and spreads them out on
the counter in the kitchen and starts cooking. Generally the
MSP_VIEW_SERVICE... tables orchestrate this type of de-queue processing.

I am NOT sure, but I suspect that the surplus of rows in this table is an
indication that these xml job files have been manually deleted from the
ViewDrop directory while they were being worked on by the VWNotify service.
They never could be deleted.