I am having a problem with a crosstab query and am wondering if anyone else has had this issue.
The query was built several years ago and had been executed manually by one of our data analyst. I offered to schedule the query in Data Point.
I created the automation and tested it and it ran fine. There were no errors and the result set was correct. So, I set the query on a schedule in the job manager. However, when I tested the query by running from the job manager the aggregated results all returned zeros.
I have tried rebuilding the schedule several times and have the same result each time - the results are good if I run the automation in data point but not when I execute from the job manager.
I have tried with both versions 3.5 and 3.6
I do have other crosstab queries that do not have this issue and the one difference is that the query that will not return the correct result from the scheduled results uses a DB link to connect from our plan instance of Oracle to our source instance. Other than that I can find no difference.
Has anyone had a similar issue or any ideas what could be causing this type of behaviour?