Error when saving - "cannot insert duplicate key row"

P

Pat

One of our project managers made changes to their project and tried to
save. A message box appeared that said [Microsoft][ODBC SQL Server
Driver][SQL Server]Cannot insert duplicate key row in object
'MSP_TASK_BASELINES' with unique index 'I_MSP_TASK_BASELINES'.
Can anyone tell me what caused this error?
 
B

Beth

While researching what is fixed using SP1 I came across this:

"Cannot insert duplicate key row in object 'MSP_ASSIGNMENT_BASELINES' with
unique index 'I_MSP_ASSIGNMENT_BASELINES'" error message when you save a
project


When you save a project to Project Server 2003 that contains baseline
information, you may receive the following error message:
[Microsoft]{ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key
row in object 'MSP_ASSIGNMENT_BASELINES' with unique index
'I_MSP_ASSIGNMENT_BASELINES'.
This issue may occur if you save the project immediately after you delete a
previously saved project that contains the same baseline information. In this
situation, the stored procedure that deletes information from the
MSP_ASSIGNMENT_BASELINES table in SQL Server incorrectly processes the delete
operation.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error msg" Cannot insert duplicate key in object'MSP_TASK_BASELINES" 2
Unique Index error on saving... 1
Can not insert duplicate key row in object TASK_BASELINES 3
SQL Duplicate Key error with TASK_BASELINES 0
Cannot insert duplicate key row in object 'MSP_CALENDARS' 5
Cannot insert duplicate key row in object MSP_CALENDARS 2
Error message when saving a project to proj server 1
Project 2002 publishing Cannot insert duplicate key row in object MSP Calendars 1

Top