Project Pro File will not SYNC to PWA Actuals

[ljsexton]

Lost all of the PWA time in the project file when opened in Project Pro. All
the PWA Actuals entered by Resources are visible from PWA. From Project Pro
selected Tools Tracking and Sync to Actuals - does not work - no errors -
just does not do anything. Have used this "feature" in the past with other
projects "sparingly" - never had this problem before. Any suggestions would
be greatly appreciated.
thanks,
Jackie

 

[/pd]

Jackie

did you accept the updates ? MSP normally indicates that Team members have
updated tasks and if you wish to apply these updates prior to Project being
opened in MSP07.
/pd

 

[ljsexton]

All updates were already processed over a long period of time. The actual
Work was already updated as a result of the resources PWA submitted time. All
was fine with this project until the circular reference error. I was able to
recover the tasks in the project, but Now all of the Actual PwA Time that WAS
there is now gone. I have had this happen sporatically with other projects
for a task and used the Sync with Actuals to bring the data back into the
project Plan. This time the action of Sync with Actuals is Not working. No
errors , just does nothing.

 

[/pd]

ok stupid qus fr my end.. can you verify that you are opening the prj gets
opened WITHOUT the [ READ ONLY] status ??

and can you clarify what you mean when you say "until the circular reference
error." ? what err ??

/pd

 

[ljsexton]

thanks for your reply. Hopefully the below will help.
1. Opening the project in normal read write mode. Not read only. double
checked this again to be sure. Tried numerous times.....
2. The event(s) that caused the data to disappear: connection to project
server DB was lost due to transaction file filling up during a "Process PWA
Time" update session. Initial symptom after dB was 'fixed' was that when the
projec was opened no tasks were visible from Project Pro. Ok in PwA views ,
except the PwA Protected Actuals were now Zeros - all had data before the
"crash"....found info in this discuss group regarding recovery from the
circular reference error and got the tasks back in Project Pro. Everything
looks good except this one last problem is to fix the missing PWA Protected
Actuals - hence the desire to do Sync with Actuals but it will not work for
this project. Need to pull the real actuals from the resources timesheet
entries. ***Note: we are using EPS2003
Not sure what to do next.
Thanks.
Jackie

ok stupid qus fr my end.. can you verify that you are opening the prj gets
opened WITHOUT the [ READ ONLY] status ??

and can you clarify what you mean when you say "until the circular reference
error." ? what err ??

/pd

All updates were already processed over a long period of time. The actual
Work was already updated as a result of the resources PWA submitted time. All
was fine with this project until the circular reference error. I was able to
recover the tasks in the project, but Now all of the Actual PwA Time that WAS
there is now gone. I have had this happen sporatically with other projects
for a task and used the Sync with Actuals to bring the data back into the
project Plan. This time the action of Sync with Actuals is Not working. No
errors , just does nothing.

 

[Gary L. Chefetz [MVP]]

Jackie:

How did you recover the project plan?

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

thanks for your reply. Hopefully the below will help.
1. Opening the project in normal read write mode. Not read only. double
checked this again to be sure. Tried numerous times.....
2. The event(s) that caused the data to disappear: connection to project
server DB was lost due to transaction file filling up during a "Process
PWA
Time" update session. Initial symptom after dB was 'fixed' was that when
the
projec was opened no tasks were visible from Project Pro. Ok in PwA views
,
except the PwA Protected Actuals were now Zeros - all had data before the
"crash"....found info in this discuss group regarding recovery from the
circular reference error and got the tasks back in Project Pro. Everything
looks good except this one last problem is to fix the missing PWA
Protected
Actuals - hence the desire to do Sync with Actuals but it will not work
for
this project. Need to pull the real actuals from the resources timesheet
entries. ***Note: we are using EPS2003
Not sure what to do next.
Thanks.
Jackie

ok stupid qus fr my end.. can you verify that you are opening the prj
gets
opened WITHOUT the [ READ ONLY] status ??

and can you clarify what you mean when you say "until the circular
reference
error." ? what err ??

/pd

All updates were already processed over a long period of time. The
actual
Work was already updated as a result of the resources PWA submitted
time. All
was fine with this project until the circular reference error. I was
able to
recover the tasks in the project, but Now all of the Actual PwA Time
that WAS
there is now gone. I have had this happen sporatically with other
projects
for a task and used the Sync with Actuals to bring the data back into
the
project Plan. This time the action of Sync with Actuals is Not working.
No
errors , just does nothing.

:

Jackie

did you accept the updates ? MSP normally indicates that Team
members have
updated tasks and if you wish to apply these updates prior to Project
being
opened in MSP07.
/pd

:

Lost all of the PWA time in the project file when opened in Project
Pro. All
the PWA Actuals entered by Resources are visible from PWA. From
Project Pro
selected Tools Tracking and Sync to Actuals - does not work - no
errors -
just does not do anything. Have used this "feature" in the past
with other
projects "sparingly" - never had this problem before. Any
suggestions would
be greatly appreciated.
thanks,
Jackie

 

[ljsexton]

Hello Gary,
thanks for your reply.
See below....worked great!
Jackie

From Discussion Group: Microsoft Project Server
Subject: RE: Circular Reference Error when opening Projects
Date: 9/19/2005 4:13 PM PST
From: 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

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

Jackie:

How did you recover the project plan?

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

thanks for your reply. Hopefully the below will help.
1. Opening the project in normal read write mode. Not read only. double
checked this again to be sure. Tried numerous times.....
2. The event(s) that caused the data to disappear: connection to project
server DB was lost due to transaction file filling up during a "Process
PWA
Time" update session. Initial symptom after dB was 'fixed' was that when
the
projec was opened no tasks were visible from Project Pro. Ok in PwA views
,
except the PwA Protected Actuals were now Zeros - all had data before the
"crash"....found info in this discuss group regarding recovery from the
circular reference error and got the tasks back in Project Pro. Everything
looks good except this one last problem is to fix the missing PWA
Protected
Actuals - hence the desire to do Sync with Actuals but it will not work
for
this project. Need to pull the real actuals from the resources timesheet
entries. ***Note: we are using EPS2003
Not sure what to do next.
Thanks.
Jackie

ok stupid qus fr my end.. can you verify that you are opening the prj
gets
opened WITHOUT the [ READ ONLY] status ??

and can you clarify what you mean when you say "until the circular
reference
error." ? what err ??

/pd

:

All updates were already processed over a long period of time. The
actual
Work was already updated as a result of the resources PWA submitted
time. All
was fine with this project until the circular reference error. I was
able to
recover the tasks in the project, but Now all of the Actual PwA Time
that WAS
there is now gone. I have had this happen sporatically with other
projects
for a task and used the Sync with Actuals to bring the data back into
the
project Plan. This time the action of Sync with Actuals is Not working.
No
errors , just does nothing.

:

Jackie

did you accept the updates ? MSP normally indicates that Team
members have
updated tasks and if you wish to apply these updates prior to Project
being
opened in MSP07.
/pd

:

Lost all of the PWA time in the project file when opened in Project
Pro. All
the PWA Actuals entered by Resources are visible from PWA. From
Project Pro
selected Tools Tracking and Sync to Actuals - does not work - no
errors -
just does not do anything. Have used this "feature" in the past
with other
projects "sparingly" - never had this problem before. Any
suggestions would
be greatly appreciated.
thanks,
Jackie