Error message when trying to access Proposals and Activities

[Mike]

My server is coming out with the following error message every time we try
to access the Proposals and Activities link. This is what the logs says:

10/26/2007 14:21:52.57 w3wp.exe (0x1D70) 0x13B8ProjectServer Project Server - General 0 Exception Exception
occurred in method PWA.ProjectReadActivityList
System.Data.StrongTypingException: The value for column
'PROJ_INFO_FINISH_DATE' in table 'Project' is DBNull. --->
System.InvalidCastException: Specified cast is not valid. at
Microsoft.Office.Project.Server.Schema.ProjectDataSet.ProjectRow.get_PROJ_INFO_FINISH_DATE()
--- End of inner exception stack trace --- at
Microsoft.Office.Project.Server.Schema.ProjectDataSet.ProjectRow.get_PROJ_INFO_FINISH_DATE()
at
Microsoft.Office.Project.Server.BusinessLayer.Project.GetProjectAdditionalInfo(Guid
projectUid, String& projState, DateTime& projStartDate, DateTime&
projFinishDate) at
Microsoft.Office.Project.Server.BusinessLayer.Project.ReadActivityList()
at Microsoft.Office.Project.Server.WebService.PWA.ProjectReadActiv...d7cecb63-b689-4e0f-8db8-04b41ec188fcAnyone seen this before?
Any fixes? Workarounds?
Should I escalate this to Produc Support Services?

 

[Jonathan Sofer]

Reads like there is some data issue in your database but just in case this
might help, are you receiving a 403 error page on the proposals or something
else?

There is a known issue with the proposals page comning up with the 403 error
page on a periodical basis and the workaround is to log onto the same page
with the system account (i.e. the account used to do the installation)

This is specifically an issue with the New Proposal / Activity or the
detailed Proposal / Activity page.

Jonathan

 

[Jonathan Sofer]

Mike,

I am not sure of the likelyhood of a PS2007 DB getting corrupted.

As for the defining of a Proposal/Activity finish date, this is not
something you define directly, it is caculated from start date and task
definitions. Just as in a true project schedule you would define from
Project Professional, you never set the finish date directly.

1) You set a project start date
2) You then build your schedule with activities and dependencies

Only after you have done steps 1 and 2 will you have a finish date that is
different than your start date.

I am confused as to what the real issue is you are having based on the first
message you posted and now the most recent one you just posted. Can you try
and clarify?

Jonathan