Can not insert duplicate key row in object TASK_BASELINES

[David]

So here's the scope of the problem. I have a manager that is trying to
update a schedule through project professional. She is receiving the error
below.

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key
row in object 'MSP_TASK_BASELINES' with unique index 'I_MSP_TASK_BASELINES',

Sounds I'm having a similar problem as others but with TASK BASELINES.
I have a feeling that it is that there's a duplicate Task trying to be
updated.

I looked in the Unique Id column, and there are not repeated IDs.

Not sure where to find the dupped task.

David

 

[Sameer]

Dear David;

Did you install the Service Pack 1, This error has been recognized and fixed
by microsoft with their release of SP1.

Regards

 

[David]

Yes, I do have Service Pack 1 installed. I have service pack 1 on the server
and service pack 2 on the client (professional).

Still this problem exists.

Dear David;

Did you install the Service Pack 1, This error has been recognized and fixed
by microsoft with their release of SP1.

Regards

So here's the scope of the problem. I have a manager that is trying to
update a schedule through project professional. She is receiving the error
below.

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key
row in object 'MSP_TASK_BASELINES' with unique index 'I_MSP_TASK_BASELINES',

Sounds I'm having a similar problem as others but with TASK BASELINES.
I have a feeling that it is that there's a duplicate Task trying to be
updated.

I looked in the Unique Id column, and there are not repeated IDs.

Not sure where to find the dupped task.

David

 

[R Segawa]

Hi David,

This problem happens sometimes when you publish a schedule created
originally in Project 2002 and then published in Projet server 2003 using
Project Professional 2003.

If this project fits in the above situation, you will need to install
Project Pro 2002 in a different machine, install the SP1 of this version,
open and save this project and publish it again (you know that you cannot
overwrite a published project).

Another trick is to save this project in XML format, close de Project Pro
and open this XML file and publish it. I did not test this at that time, but
worth trying if the project does not have thousand of tasks.

Good luck.

R.Segawa

Yes, I do have Service Pack 1 installed. I have service pack 1 on the
server
and service pack 2 on the client (professional).

Still this problem exists.

Dear David;

Did you install the Service Pack 1, This error has been recognized and
fixed
by microsoft with their release of SP1.

Regards

So here's the scope of the problem. I have a manager that is trying to
update a schedule through project professional. She is receiving the
error
below.

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate
key
row in object 'MSP_TASK_BASELINES' with unique index
'I_MSP_TASK_BASELINES',

Sounds I'm having a similar problem as others but with TASK BASELINES.
I have a feeling that it is that there's a duplicate Task trying to be
updated.

I looked in the Unique Id column, and there are not repeated IDs.

Not sure where to find the dupped task.

David