Report Center delete_jobs_on_completion

From a previous post, it looks like if this variable was left to default, the workflow data is kept around until RC processes it.

From my recent experience, this is not true. I should have workflow data going back to 6/01/07, but for some odd reason, it only goes back to 7/22/07.

Any idea why this is ?

Find more posts tagged with

Comments

pdasarat

No this setting doesn't affect your RC. RC process it's data from the eventsubsystem database and also from it's own RC database (which you would have configured during setup). Make sure TeamSite was writting it's data onto Eventsubsystem prior to the data you mentioned (Check messages table).

Pradeep

Migrateduser

Rob,
When u say data going back to 7/22/07 only, is that in the RC database? What is the backend for eventsubsystem. If it is an RDBMS, can you check in the messages table and see what the earliest timestamp in the messages table is?

John742

No this setting doesn't affect your RC. RC process it's data from the eventsubsystem database and also from it's own RC database (which you would have configured during setup). Make sure TeamSite was writting it's data onto Eventsubsystem prior to the data you mentioned (Check messages table).

Pradeep

This is not entirely correct. It is true that reporting if registered with Eventsubsystem will pick up it's messages_handles from ES and deserialize the blob, then populate it's reporting DB. But for workflow events it will also query the worflow object(like iwgetwfobj) for more information. And if not found will throw an error in tsreport.log.
I believe that the default iw.cfg is :
delete_jobs_on_completion=true
and when using report center should be configed to:
delete_jobs_on_completion=false
This tells the workflow store not to purge workflow objects until reporting has consumed the information it needs. Setting this to true and not having report center configured or running would create issues for the workflow store.

pdasarat

This is not entirely correct. It is true that reporting if registered with Eventsubsystem will pick up it's messages_handles from ES and deserialize the blob, then populate it's reporting DB. But for workflow events it will also query the worflow object(like iwgetwfobj) for more information. And if not found will throw an error in tsreport.log.
I believe that the default iw.cfg is :
delete_jobs_on_completion=true
and when using report center should be configed to:
delete_jobs_on_completion=false
This tells the workflow store not to purge workflow objects until reporting has consumed the information it needs. Setting this to true and not having report center configured or running would create issues for the workflow store.

Thanks John for the information.

Pradeep