Reporting DB out of Synch with Publish DB

[BruceFFIC]

Sorry to be such a pest today, but does anyone know what issues or
conditions can cause the Reporting DB to get out of synch with the
Publish DB?

Running PS07 SP2 with Aug09 MS CU


Thanks,

 

[Jack Dahlgren MVP]

Is there anything stuck in the queue?

-Jack

 

[Gary L. Chefetz]

Not only jobs stuck in the queue, as Jack points out, but RDB update
failures can cause this as well.

Try forcing a rebuild of the RDB by doing an administrative backup of your
custom Enterprise Fields and then restore them. Watch the queue for a while
an look for error on the many jobs you will see spawned by this action. If
you post back, try to be specific about the data that is out of synch as
different types of data problems can have different causes.

 

[BruceFFIC]

Not only jobs stuck in the queue, as Jack points out, but RDB update
failures can cause this as well.

Try forcing a rebuild of the RDB by doing an administrative backup of your
custom Enterprise Fields and then restore them. Watch the queue for a while
an look for error on the many jobs you will see spawned by this action. If
you post back, try to be specific about the data that is out of synch as
different types of data problems can have different causes.

--
Gary L. Chefetz, MVP, MCT, MCTIP
Business:http://www.msprojectexperts.com
FAQs:http://www.projectserverexperts.com
BLOG:http://www.projectserverhelp.com








- Show quoted text -

Gary, we did this and it got worse. We opened a problem with MS [REG:
110050384614421], and worked with Mohit Sharma of MS. He told us not
to rebuild the Reporting DB because it causes the SRS report that use
Custom Fields to fail. The reports need to rebuild and relinked.
Mohit stated that his group (I think he said Team Foundation) has told
the the ohter group who replies to fixes not to keep telling users to
do this fix.

 

[Gary L. Chefetz]

Bruce:

Thanks for letting us know about this. I'll point out this possible conflict
to the support team and see what they have to say about it.

--
Gary L. Chefetz, MVP, MCT, MCTIP
Business: http://www.msprojectexperts.com
FAQs: http://www.projectserverexperts.com
BLOG: http://www.projectserverhelp.com

Not only jobs stuck in the queue, as Jack points out, but RDB update
failures can cause this as well.

Try forcing a rebuild of the RDB by doing an administrative backup of
your
custom Enterprise Fields and then restore them. Watch the queue for a
while
an look for error on the many jobs you will see spawned by this action.
If
you post back, try to be specific about the data that is out of synch as
different types of data problems can have different causes.

--
Gary L. Chefetz, MVP, MCT, MCTIP
Business:http://www.msprojectexperts.com
FAQs:http://www.projectserverexperts.com
BLOG:http://www.projectserverhelp.com








- Show quoted text -

Gary, we did this and it got worse. We opened a problem with MS [REG:
110050384614421], and worked with Mohit Sharma of MS. He told us not
to rebuild the Reporting DB because it causes the SRS report that use
Custom Fields to fail. The reports need to rebuild and relinked.
Mohit stated that his group (I think he said Team Foundation) has told
the the ohter group who replies to fixes not to keep telling users to
do this fix.

 

[Barbara Henhapl]

Thanks Gary, please let us know what they say!

Regards
Barbara

Bruce:

Thanks for letting us know about this. I'll point out this possible
conflict to the support team and see what they have to say about it.

--
Gary L. Chefetz, MVP, MCT, MCTIP
Business: http://www.msprojectexperts.com
FAQs: http://www.projectserverexperts.com
BLOG: http://www.projectserverhelp.com

Not only jobs stuck in the queue, as Jack points out, but RDB update
failures can cause this as well.

Try forcing a rebuild of the RDB by doing an administrative backup of
your
custom Enterprise Fields and then restore them. Watch the queue for a
while
an look for error on the many jobs you will see spawned by this action.
If
you post back, try to be specific about the data that is out of synch as
different types of data problems can have different causes.

--
Gary L. Chefetz, MVP, MCT, MCTIP
Business:http://www.msprojectexperts.com
FAQs:http://www.projectserverexperts.com
BLOG:http://www.projectserverhelp.com





Sorry to be such a pest today, but does anyone know what issues or
conditions can cause the Reporting DB to get out of synch with the
Publish DB?

Running PS07 SP2 with Aug09 MS CU

Thanks,- Hide quoted text -

- Show quoted text -

Gary, we did this and it got worse. We opened a problem with MS [REG:
110050384614421], and worked with Mohit Sharma of MS. He told us not
to rebuild the Reporting DB because it causes the SRS report that use
Custom Fields to fail. The reports need to rebuild and relinked.
Mohit stated that his group (I think he said Team Foundation) has told
the the ohter group who replies to fixes not to keep telling users to
do this fix.