Hi,
There are some ODS jobs (BI_PROCESS_ODSACTIVAT) which hang in the BI 7.0 system for a very long time.
Due to this, all other jobs cannot proceed forward.
And as soon as we cancel the hanging job, the other jobs proceed immediately.
Also, we observed one more peculiarity that these jobs are hanging mostly on the centrel instance, and we do not get this problem when the jobs are running on other application servers.
Please let me know why this is happening.
Also, is it possible to divert these jobs to any one application server?? I am aware that this can be done for a 'normal' job but as this is a BI job, all ODS activations will have same job name, so then all such jobs will go to a single server, which might cause overloading on that server.
Please advice.
Thanks & Regards,
Kunal.