none
Project server related database problem RRS feed

  • Question

  • Hi

    project server 2007 is installed on windows 2008 enterprise edition with sql server 2008 and i have restored the pwa site 4 databases from one server(windows server 2003) and wss_content database on to this destination server , but the database are not getting modified if any changes are made in pwa site(i.e the mdf and ldf files related to these databases are not getting updated

    When i see the manage queue it says reporting(project publish)---------->waiting to be processed(sleeping)

    Could u please tell me the solution for this plzzz

    Friday, September 30, 2011 7:44 AM

All replies

  • Hi there,

    It seems that reporting database build job after restortaion is not completed. To resolve this issue, you can often simply force a rebuild of the Project Server 2007 reporting database following the instructions in the below article:
    http://www.projectserverexperts.com/ProjectServerFAQKnowledgeBase/forcerebuildofprojectserverreportingdatabase.aspx

    If the problem returns in a specific project, it may indicate that a persistent problem in the project file, itself, is the ultimate cause. If this is the case, forcing a rebuild of the project's binary object may be required to ultimately solve the problem.
    Check this out pls.
    http://social.technet.microsoft.com/Forums/en-US/projserv2010setup/thread/9d6808bb-722e-47ef-896a-3b15f1da3c7b/ 
    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    Friday, September 30, 2011 7:56 AM
  • Hi,

    Have you been able to succesfully update a schedule and publish it back into PWA. If so, is the change visible?  I am wondering if anything is processing in your queue at all, what does manage queue show around other items processing?

     


    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Saturday, October 1, 2011 2:32 AM
    Moderator
  • HY hai thanks for the reply

    I restarted the system and tried to open a project from a pwa site in project professional to edit ,later i am not able to save or publish from project professional  .

    When i see the manage queue in my pwa site all the task (i.e save,publish,check in .....)are telling Waiting to be processed(sleeping)

    Could u plz tell me what step to be taken to slove this problem plz .......

    Thanks in advance

    Saturday, October 1, 2011 5:24 AM
  • HY hai thanks for the reply

    I restarted the system and tried to open a project from a pwa site in project professional to edit ,later i am not able to save or publish from project professional  .

    When i see the manage queue in my pwa site all the task (i.e save,publish,check in .....)are telling Waiting to be processed(sleeping)

    Could u plz tell me what step to be taken to slove this problem plz .......

    Thanks in advance
    Saturday, October 1, 2011 5:24 AM
  • And also let me no what are the service account that is for login of anallysis service, reporting service, database engine....)

    Alll the steps information given will be really usefull form me

    Saturday, October 1, 2011 5:31 AM
  • I restarted the timer service and checked my pwa site then now i was able to check out  the project ,save ,publish from project professional,and check in

    But when i see the manage queue it says

    FOR PROJECT

    Job type:Reporting(project publish)

    Status:Waiting to be processed(sleeping)

    Resource

    And for one resource when she submits her time sheet

    Job Status:Reporting(resource sync)

    Status:Waiting to be processed


     

    Analysis service account is the active directory account which is same as the ssp account for that pwa site

    Database engine and reporting service are have the NETWORK SERVICE account

     

    Do send me the solution soon

    Thank u




    • Edited by ABzzzz Monday, October 3, 2011 5:58 AM
    Monday, October 3, 2011 5:28 AM
  • This may help

    http://blogs.msdn.com/b/brismith/archive/2011/09/15/1776163.aspx?PageIndex=3

     

    Kindly review the response from Scott Stumpf and Brian Smith

     

     

    Thanks,

    Hrishi

     

     

    Monday, October 3, 2011 3:48 PM
    Moderator