Re: SQL Error...Duplicate in Unique Key Crashes the project file
anonymous_at_discussions.microsoft.com
Date: 06/18/04
- Next message: Sumit: "Re: Stoplight Charts / Brian"
- Previous message: Sumit: "RE: Min SQL version for MS Project Server 2003 ?"
- In reply to: Gary L. Chefetz \(MVP\): "Re: SQL Error...Duplicate in Unique Key Crashes the project file"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 18 Jun 2004 04:52:29 -0700
DO NOT USE CUT & PASTE ON A ROW.
This is what is causing it.
>-----Original Message-----
>Larry:
>
>What's happening is that your PM is copying an entire
row, rather than just
>the task name and duration, to duplicate or move a task
in Project. This is
>a no, no. This actually duplicates the task record,
including the UID and
>all it's links. To reposition tasks in the plan,
highlight the row and click
>and drag it into the new positon or use cut and paste.
To duplicate a task
>name and duration within the same plan, copy only the
necessary information.
>
>--
>
>Gary L. Chefetz, MVP
>"We wrote the book on Project Server
>http://www.msprojectexperts
>
>-
>"Larry" <Larry@discussions.microsoft.com> wrote in
message
>news:A7992082-580A-48F4-8139-
7E51F406205A@microsoft.com...
>> Gary,
>>
>> As this has happened again, I will give you what I
have.
>> Project Server 2003 has had some hot fixes applied but
I need our IT group
>to get that information for me. I am working on those
issues. Project
>Professional 2003 (11.0.2003.0816.15).
>>
>> My project manager inserted a single task with no
resources that caused
>the latest incident. The exact SQL error
was "[Microsoft][ODBC SQL Server
>Driver][SQL Server]Cannot insert duplicate key row in
object 'MSP_TASKS'
>with unique index 'I_MSP_TASKS'.
>>
>> We saved the file as an MPP to back it up. The
remnant file on Project
>Server is now corrupt as was the case on the previous
occurrence.
>>
>> Thanks in advance,
>>
>> Larry Seale
>>
>>
>> "Gary L. Chefetz (MVP)" wrote:
>>
>> > Larry:
>> >
>> > To take this conversation further, you really need
to specify which
>version
>> > of Project Server you're using. There are known
vulnerabilities in both
>2002
>> > and 2003, however they're different between the two
versions. Be sure to
>> > specify what hotfix patches you've applied to the
system.
>> >
>> > --
>> >
>> > Gary L. Chefetz, MVP
>> > "We wrote the book on Project Server
>> > http://www.msprojectexperts
>> >
>> > -
>> > "Larry" <larry.seale@frco.com> wrote in message
>> > news:511E3D7E-2969-435D-BCFA-
7CB4D127DBC7@microsoft.com...
>> > > We have had an instance where our PM was editing
an enterprise proejct
>and
>> > recievied a rather genereic sql error regarding a
unique key duplicate.
>Our
>> > only option at that point was to save to an MPP
file. The original file
>now
>> > reports an error... No calcaulations can be perform
now and a Circular
>> > Relationship error and a task ID pointer. The
problem is the task in
>> > question is a summary task and we cannot find the
error in the server
>file.
>> > Outline codes are really large and out of order.
Information stored in
>the
>> > Eneterprise Custom Fields does not open. The
proeject appears to be,
>for
>> > lack of a better term, corrupt.
>> > >
>> > > As this system interfaces to an external time
keeping systems, I am
>quite
>> > concerned about data interety. I am not sure what a
user can do to
>proeject
>> > that could create a duplicate key in the
database...or perhaps it is a
>> > Project Issue.
>> > >
>> > > Thanks in advance
>> > >
>> > > Larry
>> > >
>> > >
>> >
>> >
>> >
>
>
>.
>
- Next message: Sumit: "Re: Stoplight Charts / Brian"
- Previous message: Sumit: "RE: Min SQL version for MS Project Server 2003 ?"
- In reply to: Gary L. Chefetz \(MVP\): "Re: SQL Error...Duplicate in Unique Key Crashes the project file"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
