Solved

Cognos8 error message

Posted on 2007-11-19
4
1,113 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
  • 2
  • 2
4 Comments
 
LVL 12

Accepted Solution

by:
RWrigley earned 500 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now