none
Project not getting opened up 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:09 AM

Answers

  • Hi Anuj,

    Once you will execute select query it will show you some line for which Res_uid will be '0' and this is causing issue.

    then you need to execute delete query it will delete all the entry form draft and publish db.

    then try to open project it will open normally like other projects.

    you run

    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 Thursday, May 2, 2013 4:36 AM
    • Marked as answer by anuj astro Thursday, May 2, 2013 4:46 AM
    Thursday, May 2, 2013 4:35 AM

All replies

  • Hi Anuj,

    Please go through FAQ No 43 from following article "http://project.mvps.org/faqs.htm".

    Which is for handling and fixing project corruption issue.

    Hope it will help you.

    Thanks

    Sachin


    Sachin Vashishth MCTS

    Monday, April 29, 2013 10:25 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.


    kirtesh

    • Proposed as answer by Kirteshtiw Tuesday, April 30, 2013 4:46 PM
    Tuesday, April 30, 2013 4:46 PM
  • Hi Anuj,

    If you are getting difficulty to find out the correct Res_Uid

    Please run these queries

    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='Corrupted Project Uid'

     in both draft and publish database.



    kirtesh

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

    Thanx for your Response,after performing the steps mentioned by you,how will i able to open that Project in MSP from server,query you mentioned will delete that project from server

    Thursday, May 2, 2013 4:28 AM
  • Hi Anuj,

    Once you will execute select query it will show you some line for which Res_uid will be '0' and this is causing issue.

    then you need to execute delete query it will delete all the entry form draft and publish db.

    then try to open project it will open normally like other projects.

    you run

    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 Thursday, May 2, 2013 4:36 AM
    • Marked as answer by anuj astro Thursday, May 2, 2013 4:46 AM
    Thursday, May 2, 2013 4:35 AM
  • Hi kritesh

    Thanks for your Response

    right now i have restored the last back up of project,it is working fine as of now,but thanks for your reply

    Thursday, May 2, 2013 4:48 AM
  • Hi anuj,

    this query works for the issue but not supported by microsoft.


    kirtesh

    Thursday, May 2, 2013 4:57 AM
  • hi kritesh

    i am facing one more issue,there is one project in server which is neither getting publish,neither getting save,neither i can check in that project,it always get enter in waiting to be processed state,can you tell why it is happening

    Thursday, May 2, 2013 6:03 AM