none
Microsoft Project 2007 Professional SP2 - Local Project Cache RRS feed

  • Question

  • Hi,

    Is there any option from which we can disable the local project cache, which mean when a project is opened from the project server, the project  should not be saved in the local cache of the machine.

    We are using MS Project 2007 Professional SP2.

    Regards,

    Rahul Palkar

     

    Monday, September 5, 2011 5:05 PM

Answers

All replies

  • Hi Rahul,

    It is not possible to disable the cache, it is key to how project functions with Project Server.

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com
    Monday, September 5, 2011 5:26 PM
    Moderator
  • Rahul,

    I have to agree with Paul. But you do not mention why. Are you having problems when opening projects ? If you realy need to clean out the cache you could prolly build a .BAT file that cleans out the cache directory once a day or something.

    If you have problems let us know, maybe we could help.

     

    Andre


    http://av-epm.blogspot.com
    Tuesday, September 6, 2011 4:57 AM
  • Hi Rahul, Andre,

    Please do not create a batch file to delete the cache on a daily basis, this might cause data loss / plan corruption. As Andre said, what issues are you having with the cache? With SP2 for Project 2007 you shouldn't see any cache issues.

    Many thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com
    Tuesday, September 6, 2011 6:20 AM
    Moderator
  • Hi Paul,

    Thanks for the warning. I would just like to know why corruption or data loss could occur. The only way i see that happening, is if a user is really working offline and a shecdule is checked out. In his case (And its only my assumption) that he is having issues already, so hence me suggesting that. We did that once very long ago on 2007 but Pre - SP2 and fortunatly we did not have any issues, Maybe we were just lucky.

    But thanks anyway for the heads up on that :-)

     

    Andre


    http://av-epm.blogspot.com
    Tuesday, September 6, 2011 6:28 AM
  • Hi Andre,

    If the cache has not finished synching with the PSI or even commited to the database correctly, then you delete the cache you will lose those changes. The cache can be very useful and is core to the functionality of Project Server 2007 / 2010.

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com
    Tuesday, September 6, 2011 6:35 AM
    Moderator
  • Hi Paul,

    For my own sanity i went to check up what you have said, and i have come across this :http://technet.microsoft.com/en-us/library/cc197466(office.12).aspx. Close to the bottom it confirms what you have said. You were right :-)

    At the same time i wonder why other MVP's have suggested to people to clean their cache directly by deleting the files and folder ?

    Andre


    http://av-epm.blogspot.com
    Tuesday, September 6, 2011 6:51 AM
  • Hi Andre,

    I have also recommended it is the past but only when the Project client was pre SP2, my first recommendation would always be to install SP2 plus a later CU for MSP 2007 then, if that doesn't help then test on another machine (only if roaming profiles is not used on the network) to see if the issue exists there before touching the cache.

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com
    Tuesday, September 6, 2011 7:01 AM
    Moderator
  • Thanks Paul and Andre for your quick response.

    The main problem which we are facing is with the "Project Information" option, what is happening here is if we dont clean up the cache and open the projects by clicking the "Retrive the list of all projects from the project server" the date fields in the project information option flips to 03-01-1984.

    If we clean the local cache and open the projects the date fields in the project information tabs are displayed correctly.

    Regards,

    Rahul Palkar

     


    Rahul Palkar
    Tuesday, September 6, 2011 8:02 AM
  • Hi Rahul,

    I would look at testing with a later cumulative update for Project Professional 2007, there is a mention of a potential fix here:

    http://support.microsoft.com/kb/981732

    Thanks

    Paul

     


    Paul Mather | Twitter | http://pwmather.wordpress.com
    Tuesday, September 6, 2011 8:18 AM
    Moderator
  • Hi Paul.

    I tried doing this(981732), but its is not working.

     

    Regards,

    Rahul Palkar

     


    Rahul Palkar
    Tuesday, September 6, 2011 8:33 AM
  • Hi Rahul,

    Please can you advise what is not working? The update wont install or you still have the same issue?

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com
    Tuesday, September 6, 2011 8:35 AM
    Moderator
  • Hi Paul,

    We have the same issues, this are also happening with the enterprise templates as well.

    Regards,

    Rahul Palkar


    Rahul Palkar
    Tuesday, September 6, 2011 8:40 AM
  • Hi Rahul,

    Is this happening for all users? At what point does this revert to 1984? On open? after accepting updates?

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com
    Tuesday, September 6, 2011 8:45 AM
    Moderator
  • Hi Paul,

    Yes this is happening for all users.

    If we open the projects from the "Enterprise projects" and if this particular project is already in the cache the dates flip to 1984, if we clear the cache and open the project it work absolutely fine.

    And for the templates in the project information tab the dates get flipped to 03-01-1984.

    Regards,

    Rahul Palkar


    Rahul Palkar
    Tuesday, September 6, 2011 8:58 AM
  • Hi Rahul,

    Please can you advise the version number of the client with the April 2010 CU installed just to confirm this has installed correctly? To get the version number, launch Project Professional and client help > about.

    Many thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com
    Tuesday, September 6, 2011 9:00 AM
    Moderator
  • Hi Paul,

    The version no is:

    Microsoft Office Project 2007 (12.0.6536.5000) SP2 MSO (12.0.6425.1000)

    Regards,

    Rahul Palkar


    Rahul Palkar
    Tuesday, September 6, 2011 9:05 AM
  • Hi Rahul,

    It might be worth testing on 1 test machine with the August 2011 CU for Project 2007 to see if you can replicate it then:

    http://support.microsoft.com/kb/2553105

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com
    Tuesday, September 6, 2011 9:19 AM
    Moderator
  • Hi Paul,

    Tried installing this, but the problem remians.

     

    We have set up MSPS 2007 on our Citrix Servers.  We have now installed SP2.  We are experiencing problems in our Production environment after extensive testing in sandbox & not seeing this then.

    We have Custom Fields set up to activate milestone indicators (red/yellow/green – circles & squares) for certain key milestone tasks.  These then report in MSP & PWA.

    e.g. Agreement Signed is one task and will show Red / yellow / green as per how late, on-time, somewhat late, on-time etc. 

    The indicators are set to work on the variance between Current Baseline (0) and the planned dates.  We save Baseline 10 just for archive of original BL.

     

    We have created a simple project plan and saved it as an ENTERPRISE TEMPLATE.

    When we save the template, the Project Info. shows correctly:

     

    Custom Field Name                            Value

    Agreement Signed (indicator)         Not Baselined

    (A)   (actual date)                           NA

    (B)   (Baseline ‘0’)                           NA

    (C)   (current Start/Finish)          Mon 01/09/11

    (OB) (Baseline 10)                         NA

     

    The next day when we open the same Template (from Enterprise Templates) – Nothing has been updated or changed by the user

    We see the following in Project Info.:

     

     Custom Field Name                           Value

    Agreement Signed (Indicator)        FINISHED ON TIME

    (A)   (actual date)                          Tue 03/01/84

    (B)   (Baseline ‘0’)                          Tue 03/01/84

    (C)   (current Start/Finish)          Mon 01/09/11

    (OB) (Baseline 10)                        Tue 03/01/84

     

    There are no Actual dates, no baseline and this is a template so no changes would have been made to it - and yet the dates flip.

     

    This did happen (dates flipping to ‘1984’ in Project Info.) with the saved project files as well.  We installed SP2 and then found that only with clearing the cache it seemed to be a w/around (as per the issue discussed earlier).

    However, now with SP2 & clearing the cache – the templates in ‘Enterprise Templates’ are still flipping to ‘1984’.  So not sure how stable the project files will be down the line – and if infact SP2 made any difference at all.

     

    Is there a way to solve this ‘1984’ issue at a root/system level so it does not keep popping up 

     

    Thanks.

     


    Rahul Palkar
    Tuesday, September 6, 2011 11:17 AM
  • Hi Rahul,

    I have never come across this issue before, does this happen with all enterprise templates? If this only happens consistently with one Enterprise template for all users, can you test creating a new version from scratch with an SP2 Project 2007 client then see if you can replicate this behaviour?

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com
    Tuesday, September 6, 2011 11:29 AM
    Moderator
  • Thanks Paul,

    This is happening for Projects and Templates as well.

    For projects if we clear the local cache it works fine, is there any registry key which can disable local cache.

    We tried creating fresh templates but the date still flip backs to 1984.

    Regards,

    Rahul Palkar


    Rahul Palkar
    Tuesday, September 6, 2011 11:37 AM
  • Hi Rahul,

    Unfortunately as mentioned before you cannot disable the cache functionality in Project. If you insert the Project Summary row into the plan, do you see the same dates for those fields? What is the formula you are using?

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com
    Tuesday, September 6, 2011 11:44 AM
    Moderator
  •  

    Custom Field

    Formula

    Formula

    Agreement Signed

    IIf([Agreement Signed (A)]-0=4294967295,[PI1-1],[PI1-2])

    IIf([Agreement Signed (C)]-[Agreement Signed (B)]<=-1000,"Not Baselined",IIf([Agreement Signed (C)]-[Agreement Signed (B)]<=0,"On Time",IIf([Agreement Signed (C)]-[Agreement Signed (B)]<=30,"Somewhat Late","Late")))

     

    IIf([Agreement Signed (A)]-[Agreement Signed (B)]<=0,"Finished OnTime",IIf([Agreement Signed (A)]-[Agreement Signed (B)]<=30,"Finished Somewhat Late",IIf([Agreement Signed (A)]-[Agreement Signed (B)]<=10000,"Finished Late",0)))

    Agreement Signed (A)

    [TTM-A1]

    IIf([Actual Finish]-0=4294967295,"NA",IIf([TM]=1,[Actual Finish],"NA"))

    Agreement Signed (B)

    [TTM-B1]

    IIf([Baseline Finish]-0=4294967295,"NA",IIf([TM]=1,[Baseline Finish],"NA"))

    Agreement Signed (C)

    [TTM-C1]

    IIf([TM]=1,[Finish],[Project Start])

    Agreement Signed (OB)

    [TTM-OB1]

    IIf([Baseline10 Finish]-0=4294967295,"NA",IIf([TM]=1,[Baseline10 Finish],"NA"))


    Rahul Palkar
    Tuesday, September 6, 2011 1:26 PM
  • I would seriously suggest opening a support incident with Microsoft Rahul.  You have been given great advice here - you cannot disable the cache - nor can you force the client to load from the server if it finds a cached version - and you really should avoid deleting the cache for the reasons given above.  I will take a look at your formulae and see if I can reproduce the behavior in my 2007 server.

    Best regards,

    Brian.


    Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Tuesday, September 6, 2011 8:38 PM
    Owner
  • And do you have a definition for [TM] used in your formulae Rahul?
    Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Tuesday, September 6, 2011 9:09 PM
    Owner
  • Brian Hi,

    [TM] - Tracking Milestone

    In a project file having many task - we want to flag specific 5 tasks as Milestones that we would like to track. TM is a custom field having look-up table with 5 values [1,2,3,4,5]. Against a task say ID no 35, we could select [TM] = 1. This would mean it is the first milestone (Agreement Signed) ...another task say having ID no. 77, we could select [TM] = 2. This signifies that this task is our second milestone and so on.

     

    Deshwal

    Wednesday, September 7, 2011 9:56 AM
  • Brian Hi - am a colleague of Rahul ..

    a little more on our configuration - out of many milestones in our project file we want to assign 5 of them as tracking milestones (Task/Date Custom Field used is [TM]). Eg TM=1 is first tracking milestone. Now we are collecting dates for this milestone (Current, Baseline, Original Baseline (Baseline 10) and Actual) through Task/Date/Formula Custom Filed TTM-C1, TTM-B1, TTM-OB1, TTM-A1. These four are then picked up at the project level using custom fields Agreement Signed (C), Agreement Signed (B), Agreement Signed (OB), Agreement Signed (A).

    It is this project level custom fields (Agreement Signed ....) that flip from NA to 3/1/84 when we view them in Project Information and also are published to the Project Sever database.

    We updated our MPP to SP2 .. the problem seems to have been resolved ..but only if the project is not the cache... so every time we work with the project .. we first need to clear cash .. then retrieve project from project server .. else all NA dates flip to 3/1/84.

    Hope the above is helpful in understanding our issue.

    Deshwal

     

    Wednesday, September 7, 2011 10:23 AM
  • Hi Brian,

    Any findings on this.

    Regards,

    Rahul Palkar


    Rahul Palkar
    Monday, September 12, 2011 8:56 AM
  • Hi Rahul,

    I think the problem is in the formulas and not in the cache.

    1. For me, when I try to enter with "NA" in a date field it returns "#ERROR". When Project does not understand a value in a date field it fills with #ERROR or 1/3/1984 which is the beginning of the times for the Project (actually 1/1/84). Use instead "ProjDateValue(0)" to return a "NA" value.
    2. I suppose that you are trying to check if a date field is empty when you write for instance "[Actual Finish]-0 = 4294967295", which is not the best way, but it is not wrong. It could be written as "[Actual Finish] > 55000". This cabalistic number comes from the end of the times for Project that is 12/31/2049 12:59:59 PM (against to the beliefs of 2012) which is equals to serial # 54789.

    You can notice the value of (C) does not fail in your template and in the saved project because you are not entering with "NA" in the field.

    I hope this helps.


    Best regards, Ricardo Segawa - Segawas Projetos / Microsoft Partner
    Tuesday, September 13, 2011 5:38 AM
  • Thanks Ricardo,

    We will try changing the formulae.

    But why is that when we clean up the cache "NA" is displayed correctly.

    We have writte a macro which will clean up the cache when we open any new projects.

     

    Regards,

    Rahul Palkar


    Rahul Palkar
    Tuesday, September 13, 2011 3:40 PM
  • Let us know how this goes Rahul - you should certainly not need to clear the cache to get this working.

    Best regards,

    Brian.


    Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Tuesday, September 13, 2011 4:35 PM
    Owner