If you are unable to create a new account, please email support@bspsoftware.com

 

Scheduled reports fail, but run fine manually.

Started by aumdy, 19 Mar 2012 02:23:18 PM

Previous topic - Next topic

aumdy

Environment:

Originally Cognos BI was sitting on old server 03.
New instance of Cognos 10 BI installed on a single server (Server 14)
Existing reports and schedules were migrated from Server 03 to new Server 14.
Server 14 previously using access manager, (pointing to old Server 03)
Now uses active directory authentication


Issue:

After shutting down Server 03, all scheduled report jobs in Cognos fail.
We can run the reports manually, but the scheduler fails.
When we switch on the old server 03, the scheduled reports succeed.

Error:
"CNC-SDS-0413 There was a problem in executing the task. The user authentication failed. It may not be possible to rerun the task."
(see attachment)

Things I have done so far:

Checked the dispatcher settings in cognos configuration - They point to new server 14
Checked the services under the dispatcher in cognos connections portal> administration>Configuration>Dispatcher. They point to new server 14.

Questions:

Why can I run a report manually but not be able to schedule it when the old server is shut down?

What other settings need to be verified to make sure that the scheduling service is configured correctly, and not pointing to the old server?
Are there other configuration settings where I should be looking for the old server name?

The old access manager namespace is still in the cognos configuration, and is pointing to the old server 03. However, it is not being used. Could this be an authentication issue?

Since the common error is an authentication error, maybe the user name that is assigned to the dispatcher needs to be created in the Domains Active Directory to authenticate with it?

Any suggestions?

Thanks!

Grim

Going from Access Manager to AD...

Read this
http://www.ibm.com/developerworks/data/library/cognos/page402.html

Your going to have to reschedule everything or contact the SDK team through Cognos Support to remap your users to their new accounts.
"Honorary Master of IBM Links"- MFGF
Certified IBM C8 & C10 Admin, Gamer, Geek and all around nice guy.
<-Applaud if my rant helped! 8)