Reporting (Project publish)

Q

question

Hi,

I have Project server 2007 implementation done for my organization. These
days Project server queue is hanging with most of the reporting tasks (
publish , sync) with a status waiting to be processed.

Also, I feel the reporting database is not in sync with the published db, I
deleted some projects from PWA, they are not there in my published db, but
present in projectserver_reporting db.

Any help on this will be appreciated.

Thanks.
 
G

Gary L. Chefetz

If your reporting jobs are failing in the queue, you can expect your
reporting database to be out of synch. So, the next step is to determine why
your jobs are failing in the queue. Error messages and ULS log entries are
what you need to diagnose the issue.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reporting Database - Transaction Level 1
Reporting DB sync Project Server 2007 2
Reporting Synch jobs stuck in Waiting To be processed (Sleeping) 4
Deleted timesheet resists in Reporting DB 6
cannot publish 5
Deletion of records in Reporting DB ProjServer 2007 SP2 1
Reporting(Project Published) Failed But Not Blocking Correlation 2
Actual hours - moved from reporting database to publish database 5

Top