COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: bi4u2 on 04 Apr 2012 04:01:42 PM

Title: Reconcile Job Cancels Repeatedly
Post by: bi4u2 on 04 Apr 2012 04:01:42 PM
I have a planning application (8.4.1) which has 1200 eList items. The GTP completes, but the reconcile job cancels repeatedly. When it cancels, I hit GTP again to pick up the reconciliation where it left off. It eventually completes, but not after cancelling 5 times. Could this be an issue with the job server not having enough memory?
Title: Re: Reconcile Job Cancels Repeatedly
Post by: jeffowentn on 05 Apr 2012 09:34:51 AM
What does the planningerrorlog.csv show under the service account's profile? 

How much virtual memory do you have configured on each job server?  Also, how many processes are you allowing on each job server?  Both of these get at whether or not enough resources are being allocated to each individual job to allow it to completed before starting another job.
Title: Re: Reconcile Job Cancels Repeatedly
Post by: StuartS on 18 Apr 2012 09:34:46 AM
How many job server threads and what sort of error messages, bulk load failure? dead lock resources?

Stuart
Title: Re: Reconcile Job Cancels Repeatedly
Post by: bi4u2 on 20 Apr 2012 07:47:00 AM
Thank you for the replies, I've determined it is due to the fact that the client does not have a dedicated job server. There is one server which hosts Planning as well as Cognos 8 reporting. The processor gets to 100%. They need an additional server.
Title: Re: Reconcile Job Cancels Repeatedly
Post by: ericlfg on 20 Apr 2012 07:55:14 AM
I don't know if this will help or not, but a Planning Job server is designed to use 100% CPU utilization.

Ex:
4 CPU job server = ~25% utilization for each processor
8 CPU job server = ~ 12.5% utilization for each processor

etc..

I can definitely agree with you that they should have a separate job server.  I just wanted to make sure you were aware of how a job server has been designed.