So, I recently had this issue, where the “Publish” of a project was not syncing data with the Reporting Database. Upon investigation we found that the issue was with some of the resources, causing the sync errors.
Since this was reproducible on a few other projects, I decided to do a Reporting Database Refresh.
Before you do a RDB refresh, I suggest that you read this excellent article by Brian Smith, which explains the process in detail.
Anyway, when I triggered the RDB refresh, it kept failing with this error message, and subsequently not completing the whole refresh process.
General
- Queue:
- GeneralQueueJobFailed (26000) – ReportingWorkflowMetadataSync.ReportWorkflowMetadataSyncMessage. Details: id=’26000′ name=’GeneralQueueJobFailed’ uid=’7f19b75e-92d7-446c-8aaa-888d96a6d532′ JobUID=’be217dde-f303-4575-aeb6-38a43b7a5ed5′ ComputerName=’PS2010VPC’ GroupType=’ReportingWorkflowMetadataSync’ MessageType=’ReportWorkflowMetadataSyncMessage’ MessageId=’1′ Stage=”. For more details, check the ULS logs on machine PS2010VPC for entries with JobUID be217dde-f303-4575-aeb6-38a43b7a5ed5.
Sure enough, when I ran some queries on the Workflow Stages, Phases, Enterprise Project Types, (because these are the “Workflow Meta Data”) I could see that not all of the data came through.
So, if you run into this error, here is the resolution that worked for me.
- Navigate to PWA.
- Open each one of the Workflow Stages, make a small change and save. I made a small change to the description field.
- Open each one of the Workflow Phases, make a small change and save. made a small change to the description field.
- Open each of the Enterprise Project Types, make a small change and save. I made a small change to the description field.
This activity will “sync” and clear any mismatches between published database and Reporting Database.
Now retrigger the RDB refresh, and this time it should finish without any errors.
Hope it helps!
September 11, 2014 at 2:26 pm
Hi Prasanna,
We were facing the same issue as well. Another solution to this is to create a small test workflow that spans just 2 stages/phases, create a new project using this workflow. Once i checked the data base, this new project went through smoothly without any error. After this, we deleted the test workflows and the test project, associated the original workflow and republish all my projects and voila, no error and the DB reflects the values!
January 18, 2016 at 8:41 pm
Thanks .. This worked for me, saved my Day!!!