Hi,

Hope someone can help me out with this!

The report data marts are refreshed daily through control M scheduled jobs. The report runs fine everyday but sometime i see huge numbers on the report which is almost double the original value, not sure of the root cause or what is happening in the back end. Most of the reports are distributed through automated emails.Once we re-submit the job the report results with the correct data. Could some one help me in finding the root cause for this issue? Has anyone faced a similar issue?

This message has been edited. Last edited by: <Kathryn Henning>,

One suggestion is to look at when the report is running and getting wrong data.

I guess it isn't running during the refresh ?

Since the job runs through control we don't get to track the code. Through a manual refresh we don't get to see this issue.

Is it to do with the temporary files or intermediate hold files that gets created during the refresh session?

As I am not familiar with your processes and focexecs, I cannot say.