Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Notes data missing from Tasks in Project Pro 2007
4 views
Skip to first unread message
brantleyd
Oct 10, 2007, 11:48:02 AM10/10/07
to
I currently have 42 project managers utilizing Project Server 2007 and
Project Professional 2007 to manage enterprise projects. It was noted this
morning that all 742 projects tasks notes are now missing. I have assigned a
DBA to verify the data is still present in the SQL table. I was successful
in creating a note against a task this morning, after a save/publish and it
stuck (But for how long?). My worst fear is the data has been corrupted, but
How/Why? We have recently made (1) modification to create an Enterprise
Custom field that has a formula that calculates the status of a project based
on the finish date. This field was created over 10 days ago and the timing
does not seem to correlate with the symptoms we are experiencing today. I
have searched several discussion boards with not results; any help would be
much appreciated.
Project Professional 2007 to manage enterprise projects. It was noted this
morning that all 742 projects tasks notes are now missing. I have assigned a
DBA to verify the data is still present in the SQL table. I was successful
in creating a note against a task this morning, after a save/publish and it
stuck (But for how long?). My worst fear is the data has been corrupted, but
How/Why? We have recently made (1) modification to create an Enterprise
Custom field that has a formula that calculates the status of a project based
on the finish date. This field was created over 10 days ago and the timing
does not seem to correlate with the symptoms we are experiencing today. I
have searched several discussion boards with not results; any help would be
much appreciated.
-Brantley Daughtry
brantleyd
Oct 10, 2007, 1:11:02 PM10/10/07
to
I have verified that data is missing from the dbo.MSP_TASKS, TASK_NOTES field
in the SQL Database. We do have some data out there, but it appears to have
been recreantly created (within the past 48 hours).
in the SQL Database. We do have some data out there, but it appears to have
been recreantly created (within the past 48 hours).
-Brantley Daughtry
Vadim Gerya, PMP
Oct 10, 2007, 2:50:32 PM10/10/07
to
Dear Brantleyd !
If you create Flag type custom field with formula - be sure all task notes
would dissapear.
I had the same problem and investigated this behaviour. Why it happens - ask
Microsoft.
At present, please do not use (utill SP1 will be available) Flag type
enterprise field with ANY formula assigned . Try to design the same
functionality using Number -type field.
If you create Flag type custom field with formula - be sure all task notes
would dissapear.
I had the same problem and investigated this behaviour. Why it happens - ask
Microsoft.
At present, please do not use (utill SP1 will be available) Flag type
enterprise field with ANY formula assigned . Try to design the same
functionality using Number -type field.
Hope this help :-) !
--
Vadim Gerya, PMP
brantleyd
Oct 11, 2007, 1:04:02 PM10/11/07
to
I have opened a case with Mocrosoft Project Server Support Team and will post
their feedback once obtained.
their feedback once obtained.
Vadim Gerya, PMP
Oct 11, 2007, 7:27:00 PM10/11/07
to
Many thanks for opening case !!
I do not have such support level here in Ukraine. It costs too much..
Thanks once again.
I do not have such support level here in Ukraine. It costs too much..
Thanks once again.
Jean-Paul
Nov 1, 2007, 2:59:00 PM11/1/07
to
Hi Brantley,
Did you get any feedback from Microsoft on that issue?
we have the same problem...
Thanks!
--
Jean-Paul
Ran @Comverse
Dec 10, 2007, 2:43:01 AM12/10/07
to
Thanks All...
You really helped me with it too..!!!
0 new messages