Re: Circular Reference - cannot locate

In article <C994F9D9-F24D-4C9E-84D3-02D655B2A265@xxxxxxxxxxxxx>,
Steve Scott <SteveScott@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hi, didnt work unfoutunately - is there any other way/tool to "audit" the
file to find the problem areas? It is a 2000 file non-server based.

thanks

Steve

Steve,
You are definitely having more fun than the average Project user -
unfortunately. I assume this is still with your master file, correct?
Can you open the file at all? Does the message tell you anything about
which task is involved in the circular relationship? Did you try
re-building the master? Will each of the individual subprojects open
without a problem (auto-calculation on)?

Depending on the answers to the above, we may or may not be able to help
guide you to a solution.

John
Project MVP


"Microsoft Project" wrote:

Steve,

Is this problem occuring with Project 2000 - 2003 or 2007? Also, is it
occuring with an MPP based project or one opened from a server? If an
earlier version, then if the task in question has no successors, it's
likely
the outline structure (internally in the project) is messed up.

You can fix this by doing the following:

1. Open the project.
2. Save As to a database format such as Access or MPD.
3. In the database, go to the MSP_PROJECTS table and for the given project,
set the PROJ_EXT_EDITED field = true. For example, set it to either a 1 or
a -1 depending on the database system.
4. Open the project in Project.
5. Save As back to the MPP format.

At this point, if the task in question still says it has problems, try
manipulating it by indenting and outdenting it.

If your project is stored on Project Server, then perform steps 3 and 4
above. Then, Save Offline (from the File menu), Save Online and then work
with the project.

Regards,

Adrian Jenkins
Microsoft Project
"Steve Scott" <SteveScott@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E97E744B-03E7-4471-8571-D3C604F84D31@xxxxxxxxxxxxxxxx
I have a Circular Reference being reported on the last task in my plan,
the
task has no successors so I cannot see how it is leading back to itself
in
a
chain? Is there something significant about the last task in a plan and
circular references? How can I best locate the offending links?


.

Relevant Pages

  • RE: Project Server 2003
    ... when I got to the run script step, I ran the script from the copied database ... I was also wondering about the create database ... For example, type Project Server, and then click OK. ... In the left pane of SQL Server Management Studio, expand Databases, ...
    (microsoft.public.windows.server.sbs)
  • Re: Non-Project Time (Issues with extra tasks being displayed)
    ... Yes I have please run the following against your project server database using query analyzer: ... > Unfortunately it's not an option now as your client has gone 3 months down ... >> We are working on an issue for a client, and so far Microsoft has been ...
    (microsoft.public.project.pro_and_server)
  • RE: Project Server 2003
    ... Start SQL Server Management Studio. ... In the Connect to Server dialog box, click Database Engine in the Server ... For example, type Project Server, and then click OK. ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: Report risks and issues
    ... So we know how you want to publish the report and the tool you ... Now you need to setup some ODBC connections to the ... project server database and the sharepoint database. ... In my environment I only have access to our project server SQL server db so ...
    (microsoft.public.project.pro_and_server)
  • Re: Strange error when publishing projects
    ... The error indicates key duplication in the database. ... it from Project Server and reimporting it using the import wizard. ...
    (microsoft.public.project.pro_and_server)
Quantcast