COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Administration and Security => Topic started by: chiz on 19 Nov 2018 02:16:04 AM

Title: Scheduled reports does not route to dispatchers
Post by: chiz on 19 Nov 2018 02:16:04 AM
Hello guys!
I have 2 servers (2 dispatchers - A and B).
Both servers are connected to one Content Store.
I created a lot of schedule on reports.
BUT
all of this Scheduled reports works on 1st server (A). And no one on server B.

How can i route a part of Scheduled reports to server B?

Help, please)

Regards,
Alex
Title: Re: Scheduled reports does not route to dispatchers
Post by: sdf on 19 Nov 2018 06:27:47 AM
Since you don't have an external load balancer in place. Your system will use Cognos' default balancing scheme.
here's an article that might give you idea on dispatcher routing :
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cra.10.2.2.doc/c_specifyadvanceddispatcherrouting.html (https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cra.10.2.2.doc/c_specifyadvanceddispatcherrouting.html)
Title: Re: Scheduled reports does not route to dispatchers
Post by: chiz on 20 Nov 2018 12:51:33 AM
I have external balancer. It routes 1by1: 1 user to server A - 1 user to server B.
But it does not help with sheduled reports.
And no information in google about any solution of balance scheduled reports.
Title: Re: Scheduled reports does not route to dispatchers
Post by: chiz on 20 Nov 2018 01:14:01 AM
If I switch off Server A, then all scheduled reports execution at Server B.
Title: Re: Scheduled reports does not route to dispatchers
Post by: nagoole on 20 Nov 2018 04:50:54 AM
How many schedule reports are there ? did you check if you run the any reports and notice the request went to B server ?

Its there any routing rule setup done ?

Please share you config details so that we can try to identify the issue.

Thanks,
Naga
Title: Re: Scheduled reports does not route to dispatchers
Post by: MFGF on 20 Nov 2018 02:42:35 PM
You'll normally only see the inbuilt load balancing kick in if more than 50% of the available report service connections are utilised on the first server. In your case this will be 50% of the number of batch report services multiplied by the number of connections. If less than 50% of the total connections are in use, there's no need to load balance.

Cheers!

MF.