Re: SQL Error...Duplicate in Unique Key Crashes the project file

anonymous_at_discussions.microsoft.com
Date: 06/15/04 

Date: Tue, 15 Jun 2004 12:53:37 -0700

Gary -

I am having the exact same issue as Larry. My errors
started once when the plan was checked out and the server
went down partially through the save. (Or it was a
fabulous coincidence)

I saved my project as a .MPP, removed the corrupt project
from ther server, and republished. I still have the error.

Is there any solution? Perhaps a way to remove the
corrupt tasks if I can find them?

Sarah
>-----Original Message-----
>Larry:
>
>The strategy you're using eliminates the duplicate if
it's an assignment,
>because in taking the action to save as an mpp and then
importing it back
>in, forces you to recreate all the assignments.
>
>--
>
>Gary L. Chefetz, MVP
>"We wrote the book on Project Server
>http://www.msprojectexperts
>
>-
>"Larry" <Larry@discussions.microsoft.com> wrote in message
>news:C3830252-4C46-4E6C-90BD-56DECAB36191@microsoft.com...
>> Gary,
>>
>> Today the PM inserted a single new task and manually
populated the record.
>I also experimented and in a dozen copy/paste and the UID
incremented each
>time. I also tested against records that had Actual Work
Protected and did
>not see an issue.
>>
>> I can instruct my PM group to only cut visible text but
that will drive
>our workload crazy. I can create a table and view to
expose all used input
>fields to help but I am skeptical.
>>
>> When this error occurs, my instructions to the PMs are
to save the file as
>an MPP. They select to save "currently loaded global
items". We then do a
>save as back to the project server using a new name.
Since we are using
>only enterprise resources, we see the duplicate resource
name error and
>answer "yes to replace all" which resolve the enterprise
resource mapping.
>The required Enterprise fields are already cached and we
are only using one
>calendar. This file has saved correctly now on both
occasions including the
>UIDs. We change the project pointer on our time keeping
system to the new
>project file and re-publish the assignments and
everything links back up
>correctly. We then have a job on the time keeping system
to resubmit any
>pending time updates and we are back in business.
>>
>> The reason for the long rambling explanation is that if
we have a
>duplicate UID, would it propagate into the MPP file? Are
there issues with
>our recovery strategy? The Time Keeping system uses the
UID to track tasks
>and assignments so it is imperative that I be able to
recreate the project
>with that in tact. Is there a rollback journal to be
able or "undo" the
>partial save that appears to be occurring resulting in
corrupt project?
>>
>> Thoughts?
>>
>> Larry
>>
>>
>> "Gary L. Chefetz (MVP)" wrote:
>>
>> > 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
>> > > > >
>> > > > >
>> > > >
>> > > >
>> > > >
>> >
>> >
>> >
>
>
>.
>

Relevant Pages

  • Cannot publish assignments
    ... I can save and publish project plans to the server, but I cannot publish assignments. ... All of the resources are enterprise resources that use Windows authentication. ...
    (microsoft.public.project.pro_and_server)
  • Re: Task Queues
    ... > piece is how do the resources presently view tasks and get their ... Are you using Project Server, Project Central, Workgroup ... > have MS Project installed on their workstations or do they view the plan on ... > names or individual task assignments to substitute themselves for the ...
    (microsoft.public.project)
  • RE: Can not view network neighborhood
    ... I am interested in accessing the resources on the ... I need to access SQL server, and a "file share" which are on ... Do I still need to VPN directly to the SBS? ...
    (microsoft.public.windows.server.sbs)
  • Re: [Xen-devel] Re: [ANNOUNCE] Xen high-performance x86 virtualization
    ... >> that each virtual machine only gets the resources that its sponsor ... This allows companies providing virtual servers to ... Ensim's 'private virtual server' product is the most complete ... even in the buffer cache. ...
    (Linux-Kernel)
  • Re: [opensuse] OOo - my docs are read only?
    ... I'm having troubles with office docs that live on a SAMBA share. ... Managing from your end means you have to have the same UID and GID on ... Allowing the samba server to manage it means that your login to that ...
    (SuSE)