Solved

Cognos8 error message

Posted on 2007-11-19
4
1,119 Views
Last Modified: 2008-02-01
Hi

I have recently started using cognos8 and have some complexed reports scheduled to run at the begining of each month. the problem we are having is each month the schedules are failing due to the credentuals expiring, the error message is

CAM-AAA-0194 Authentication to the namespace 'ADS' failed. The provided credentials are invalid. Logon failure: unknown user name or bad password.

This is happening every month regardless of whether or not the users who own the schedules have changed there details or not.

I understand how to refresh the credentual in cognos but is there anyway of stopping them from expiring and having to refresh them so frequenly?

Thanks
0
Comment
Question by:ac_davis2002
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 12

Accepted Solution

by:
RWrigley earned 500 total points
ID: 20314048
You should only get that error if the user's password was changed on the Active Directory side.  There's no workaround for that, unfortuantely, becuase Cognos doesn't store the user's password, it only stores a credential.  Once the password changes in the underlying authentication source, the credential becomes invalid.  It'd be nice if it updated the credential automatically when the user logged in, but that's never been implemented.

The easiest solution is to create a user in the ADS specifically for running schedules, and make that user the owner of all the schedules.  Configure that account so that the password never expires.
0
 

Author Comment

by:ac_davis2002
ID: 20318917
Thanks RWrigley

Are you able to explain to me how to create a user in the ADS? Also I have been advised that due to a Cognos bug, the report will be email from who ever creates the schedule, so won't your suggestion mean that all the reports will be sent from the user I create to be responsible for the schedules?
0
 

Author Comment

by:ac_davis2002
ID: 20319057
Sorry RWrightley

I am being thick I know how to add a user to ADS (bit early for me!!) I have accpted yours as the solution and appreciate your help.

If you could give me your opion on my second point though... with regard to reports being sent from who ever creates the schedule that would be great!

Thanks again!
0
 
LVL 12

Expert Comment

by:RWrigley
ID: 20319448
Yes, you're right...if the scheduled report is being setn as an email, then they'll be sent by that one owner.  There's no real way around that unless you start looking into SDK solutions (custom programming) to pull the reprot out of Cognos 8 and email it seperatly.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Anyone pull off an 'Multi-Touch Attribution Analysis? ' 3 171
Adding date as variable in SSIS 20 79
web based reporting not a saas 9 63
CRM 2011 Modifying Reports/RDL based 11 58
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
How to increase the row limit in Jasper Server.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question