Circular Relationships -- Unable to Calculate Project

[Kishore]

We are using Project Server 2003. When we are trying to open a project,
Project Professional says, it has a circular relationship on task 457..., and
unable to calculate. So, I did following:
1) Tried to find circular links in MSP_LINKS table...couldnt figure out, so
1) Deleted All links on Summary Tasks from MSP_LINKS table --- still same
issue
2) Delete all other links on that project -- still same issue

This project is a stand alone project, not a master project, not a sub
project, no cross project links.

Thanks in advance for all help.

 

[Gérard Ducouret]

Kishore,

Don't you have created DDE with Edit / Paste special / Paste Link
you can retreive such links via Edit / Links...

Hope this helps,

Gérard Ducouret

 

[Dale Howard [MVP]]

Kishore --

You might try this:

1. Navigate to the Gantt Chart view.
2. Click the Filter pick list and select the Summary Tasks filter.
3. Pull the split bar to the right so you can see the Predecessors column.

In the Predecessors column, do you see any summary tasks have have
dependencies set on them? If so, this is probably the source of the
cirucular reference error. To determine which dependency is the cause of
the error, delete the dependencies on summary tasks one at a time until the
project recalculates. Hope this helps.

 

[Kishore]

Hi Gerard,
I checked there are no Links... available, and this menu item is disabled.
However I want mention about some weird behavior: It shows the message that
there is a circular relationship on task 747....and opens the plan, but I
dont see any tasks in any of the view (Gantt View....)....


Then I wrote this and checked
Sub test()
Dim tsk As Task
Debug.Print (ActiveProject.Name)
For Each tsk In ActiveProject.Tasks
Debug.Print (tsk.ID & " - " & tsk.Name)
Next
Debug.Print ("Complete")
End Sub

it prints all the tasks. Any idea why its not showing the tasks also, when
I click F9 and then save as...still dont see the tasks in the new project....
any clue?

 

[Kishore]

Hi Dale,
Thank you for help.
1) When I open project, it shows the Circular Relationship error, and then
by clicking [OK], it opens the project, but I dont see any tasks in any of
the view Gantt view etc...any idea? what should I do to get the tasks?
-----
Then I wrote this and checked
Sub test()
Dim tsk As Task
Debug.Print (ActiveProject.Name)
For Each tsk In ActiveProject.Tasks
Debug.Print (tsk.ID & " - " & tsk.Name)
Next
Debug.Print ("Complete")
End Sub

it prints all the tasks. Any idea why its not showing the tasks also, when
I click F9 and then save as...still dont see the tasks in the new project....
any clue?

Thanks in advance for all your time and help...Appreciate it.

 

[Gérard Ducouret]

Kishore,

Try to disable the automatic calculation :
Tools / Options / Calculation / Calculation mode : Manual
After that, are you able to see the tasks?

Gérard Ducouret

 

[Deb Paulson]

I am getting a Circular Relationship error on a task in Microsoft Project 2003 and cannot see any tasks in my plan. I have tried all of the recommendations in the above replys and still cannot see any tasks...any recommendations?

Thanks,

Deb

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 

[John]

I am getting a Circular Relationship error on a task in Microsoft Project
2003 and cannot see any tasks in my plan. I have tried all of the
recommendations in the above replys and still cannot see any tasks...any
recommendations?

Thanks,

Deb

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Deb,
I don't know what you tried because no previous posts or replies appear
with this post. Did you try turning off automatic calculation? Are you
working with a master file with inserted subprojects? Do you have any
links on summary lines?

John
Project MVP