Hi,
I have updated RSVP.EXCEL.NUMBEREDSHEETNAMES setting to FALSE for Report Service, Batch Report Service and Report Data Service. We have three dispatchers. I have added this setting on all three servers.
This same setting is working in Cognos 10.2.1. But, not in 11.1.6
I did restart services after making this settings change. But, no luck. What else am I missing ? Did anyone see this issue ?
I have two dispatchers for this application. I have applied the same settings on both dispatchers and report is scheduled to run and email daily.
Report is not numbering the sheets for some consecutive days and it starts numbering for some consecutive days, though it is running on same dispatcher every day. This is same behavior on both dispatchers.
Any suggestions on how to debug this ?