Circular Reference Error when opening Projects

[Walter Weber]

I am running Projects Pro. Someone saved the Admin project. Now when I try
to open it I get the following error:

No calculation can be performed now.

There is a circular relationship in 537 UGOC 2005 Conference of
"Non-Allocable.Published". The
successor of this task refers back to this task or its predecessors, causing
a circular reference.

When I choose okay the project opens but all of the task are missing, there
should be around 150 task.

To move the link that is causing the circular reference, select the two
tasks that are causing the circular link, then click Unlink Tasks on the
standard toolbar. Any suggestions on how to fix this would be appreaciated.

Walter

 

[Flora Seymour]

Hi Walter
We are having pretty much the same issue. I have opened a call with MS
Support but have gotten no answer yet. We do know that if we change the
calculations to manual we do not get the circular reference error but the
project tasks are all still missing when we open the project. Also We CAN see
the task in Web Access. If I find out any more I will let know.

In the meantime any new info thru this channel would be great.

 

[Flora Seymour]

Hi Walter,

It was suggested to us to try the following. This did indeed work for us. We
had a few bad dates that needed to be cleaned up but other than that the data
looked fine.

""Set the PROJ_EXT_EDITED field to 1 in the MSP_PROJECT table for the
project in question. And see if it opens and see if you can see the data. If
so you can try to copy the data out. Save it out to mpp and/or xml format and
see if you can get to your data""

 

[Walter Weber]

Hi Flora,

Thanks for the suggestioned work arounds, I will try them this week end and
update the thread here.

Walter

 

[Walter Weber]

Thanks,

This took care of the issue. I appreaciate the advise.

Walter

 

[Kedar]

hi

I am experiencing a similar problem and your experiments give me hope that i
can retrieve my file for the key deadline tomorrow.
I was unable to make out where the field " PROJ_EXT_EDITED" can be accesed
as a user of Project2000?
Please help me with specific instructions to get there...

Thanks in anticipation,
Kedar

 

[Jack]

MSP_PROJECT is a table in the database instance called ProjectServer. The
PROJ_EXT_EDITED field is within the tens of database fields inside that
MSP_PROJECT table.

To update it, you'll need database administrative access to run the query
below (replace the "unique_part_of_project_name" with parts of your project
name) within the ProjectServer instance.

UPDATE MSP_PROJECTS SET PROJ_EXT_EDITED = 1 WHERE PROJ_ID IN
(SELECT PROJ_ID
FROM MSP_PROJECTS
WHERE (PROJ_NAME LIKE '%unique_part_of_project_name%'))


-Jack Chan

 

[Barbara - Austria]

Worked also great fur us. Thanks for posting that solutin!

Barbara