Error creating a new resource

[Claudia]

Hello,
I have upgraded my Project Server to SP1 and very soon after that when
I try to create a new resource from Project Professional I get this
SQLServer error message and the resource pool file results
checked-out, the error is the following:

[Microsoft][ODBC SQL Server Driver][SQL Server]The attempted insert or
update failed because the target view either specifies WITH CHECK
OPTION or spans a view that specifies WITH CHECK OPTION and one or
more rows resulting from the operation did not qualify under the CHECK
OPTION constraint.

I tried to create a new resource from PWA and I get the following
message:
VBScript: Microsoft Office Project Web Access 2003: An error occurred
while completing the operation.

Does anyone have experienced something similar? Can anyone help?

Thanks,

Claudia

 

[Veroniq]

Hallo Claudia,
have you apllied a SP1 on SQL server (and STS) too?
The service packs can be found at
http://support.microsoft.com/?kbid=830240.
Hope this helps.

Veroniq

 

[Claudia]

Actually we discovered what happened: we have manually deleted the Non
Project Working Time coming from the previous version Project 2002
manually on the MSP_Web_PRojects, MSP_Web_Assignments, MSP_Web_Work.
Well we discovered that the MSP_WEB_PROJECTS record needs to stay
there.

Hope this help if someone is looking for a way to get rid of the non
project time, but as a general suggestion: never ever do these type of
actions without having a fresh backup of your ProjectServer DB!

Regards
Claudia