Corrupted Assignments?

[Mike]

Hi,
I'm seeing the following issue, where using the PSI, I submit time, but
when I call statusSvc.ReadStatusApprovalsSubmitted, I am getting no results
back. If I open up Project Professional, I get a message telling me there is
submitted time to be approved, but the grid shows no results. I do have the
status manager set correctly on these tasks, and have published the plan
prior.
Further, I notice the following. If I run the following query against the
reporting database, the assignments in question are in the returned resultset.


"SELECT MSP_PROJECTS.PROJ_NAME,
MSP_ASSIGNMENTS_SAVED.TASK_NAME,
MSP_RESOURCES.RES_NAME,
MSP_ASSIGNMENTS_SAVED.ASSN_UID,
MSP_ASSIGNMENTS_SAVED.PROJ_UID,
MSP_ASSIGNMENTS_SAVED.TASK_UID,
MSP_ASSIGNMENTS_SAVED.RES_UID
FROM MSP_ASSIGNMENTS_SAVED INNER JOIN
MSP_PROJECTS ON MSP_ASSIGNMENTS_SAVED.PROJ_UID =
MSP_PROJECTS.PROJ_UID INNER JOIN
MSP_RESOURCES ON MSP_ASSIGNMENTS_SAVED.RES_UID =
MSP_RESOURCES.RES_UID
WHERE (NOT EXISTS
(SELECT TASK_UID
FROM MSP_TASKS_SAVED
WHERE (TASK_UID = MSP_ASSIGNMENTS_SAVED.TASK_UID))) "

-- What causes this behavior? I cannto find a way to fix this issue without
deleting and readding the assignments.