none
Project Server 2010 -> Open in Project Web App for Editing -> Change something -> Save -> GeneralUnhandledException RRS feed

  • Question

  • Hello,

    has someone an idea?

    We use Project Server 2010. Since a Microsoft Windows and Office (Sharepoint/Project Server) Update, we get when saving the Project Detail Pages of a project:

    GeneralUnhandledException

    Thanks and kind regards


    Murol

    Thursday, June 11, 2015 1:29 PM

Answers

  • The solution with very good support by Microsoft in our environment is the following. Don't use this solution in other environments without testing on a test system!

    in ULSlogs appeared The EXECUTE permission was denied on the object  MSP_ReadLocalAndEnterpriseLookupTableInfoByUIDs', database 'PS_ProdFarm01_ProjectServer_Published'

    The error came probably with CU March 2015 and should be removed according to Microsoft Support with import of CU in June 2015. The stored procedure 'MSP_ReadLocalAndEnterpriseLookupTableInfoByUIDs' is new and looks like

    The workaround is in Microsoft Management Studio à Databases à Published DB for PWA à Programmability à Stored Procedures à MSP_Read_CustomFieldsDependingOnLookupTables à Properties à to grant execute for ProjctServerRole and looks like


    Murol


    • Marked as answer by Murol Friday, June 12, 2015 1:01 PM
    • Edited by Murol Friday, June 12, 2015 1:04 PM
    Friday, June 12, 2015 1:00 PM

All replies

  • Hi Murol,

    Has the SharePoint Configuration wizard been run following the updates installation? It may be a case of just running the configuration wizard.

    I am thinking that this may fix your other issue as well.

    Hope this helps

    Thursday, June 11, 2015 8:26 PM
  • Hello Paul,

    thank you, yes it has run on all SP servers.

    Kind regards


    Murol

    Friday, June 12, 2015 6:09 AM
  • The solution with very good support by Microsoft in our environment is the following. Don't use this solution in other environments without testing on a test system!

    in ULSlogs appeared The EXECUTE permission was denied on the object  MSP_ReadLocalAndEnterpriseLookupTableInfoByUIDs', database 'PS_ProdFarm01_ProjectServer_Published'

    The error came probably with CU March 2015 and should be removed according to Microsoft Support with import of CU in June 2015. The stored procedure 'MSP_ReadLocalAndEnterpriseLookupTableInfoByUIDs' is new and looks like

    The workaround is in Microsoft Management Studio à Databases à Published DB for PWA à Programmability à Stored Procedures à MSP_Read_CustomFieldsDependingOnLookupTables à Properties à to grant execute for ProjctServerRole and looks like


    Murol


    • Marked as answer by Murol Friday, June 12, 2015 1:01 PM
    • Edited by Murol Friday, June 12, 2015 1:04 PM
    Friday, June 12, 2015 1:00 PM