none
Project not opening in Microsoft Project 2010? RRS feed

  • Question

  • Hi everyone

    Suddenly my project is not getting opened up in Microsoft Project 2010,It is getting opened up in server,but is is not opening in Microsoft Project 2010,as soon as i try to open it,a message displays closing file 'projectname',all other projects are opening,only this one is giving problem

    If anyone has any idea ,plz lemme know

    any help will be greatly appreciated

    Thanks

    Anuj

    Monday, April 29, 2013 9:08 AM

All replies

  • Hi Anuj,

    Under your following similar thread "http://social.technet.microsoft.com/Forums/en-US/projectserver2010general/thread/ee808c1a-5acb-4a3f-b115-05f3bd376b49", I have given you some suggestion or pointer to fix the same issue.

    Please try those and let us know.

    Thanks

    Sachin


    Sachin Vashishth MCTS

    Monday, April 29, 2013 10:28 AM
  • Hi Anuj,

    This type of issue occur because of project corruption.

    You need to delete bad entries from the draft and publish database

    select * from MSP_PROJECT_RESOURCES
    where RES_UID = 'Some RES_UID'
    and RES_WINPROJ_UNIQUE_ID = '0'

    and proj_uid='your project UID'

    And then you can just use:

    delete from MSP_PROJECT_RESOURCES
    where RES_UID = 'Some RES_UID'
    and RES_WINPROJ_UNIQUE_ID = '0'

    and proj_uid='your project UID'

    After this you try to open the project from server in MPP. It will solve your problem.



    kirtesh

    • Proposed as answer by Kirteshtiw Tuesday, April 30, 2013 4:47 PM
    Tuesday, April 30, 2013 4:46 PM
  • If you don't know the resource uid then please use

    select * from MSP_PROJECT_RESOURCES   where     RES_WINPROJ_UNIQUE_ID = '0'   and proj_uid='Corrupted Project Uid"

     in both draft and publish database.

    then Run

    delete from MSP_PROJECT_RESOURCES
    RES_WINPROJ_UNIQUE_ID = '0'

    and proj_uid='your project UID'

     in both draft and publish database.


    kirtesh

    • Proposed as answer by Kirteshtiw Wednesday, May 1, 2013 5:50 PM
    Wednesday, May 1, 2013 5:50 PM