none
Report Database is LOCK when I create or update a Custom Field RRS feed

  • Question

  • Hi All

    I'm using Project Server 2010 and recently I start seeing a strange behavior when I modify or create a Custom Field. The process takes a lot of time to complete and also sometimes gets locks, and stay there Processing 0%. And also I not able to execute querys over the reporting database. Please check the images below.

    I have installed [December 9, 2014 Cumulative Update for Project Server 2010 package].

    I really appreciate your help. Thanks.

    The message in the Job Type column is:

    Reporting (Entity User View Refresh)


    Javier Perez | VP | Sr. Technical Architect | MCPD:Enterprise, MCPD:Web, MCITP:Database Dev, MCAD, MCTS:SharePoint | Monterrey, Mexico.




    Tuesday, June 2, 2015 4:38 PM

All replies

  • Project Server gave me the following error after 3 hours:

    Let me know your comments, Thanks.


    Javier Perez | VP | Sr. Technical Architect | MCPD:Enterprise, MCPD:Web, MCITP:Database Dev, MCAD, MCTS:SharePoint | Monterrey, Mexico.

    Tuesday, June 2, 2015 6:08 PM
  • And these are the details about the error, let me know your comments.


    Javier Perez | VP | Sr. Technical Architect | MCPD:Enterprise, MCPD:Web, MCITP:Database Dev, MCAD, MCTS:SharePoint | Monterrey, Mexico.

    Tuesday, June 2, 2015 6:09 PM