?
Solved

Cognos8 error message

Posted on 2007-11-19
4
Medium Priority
?
1,122 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 2000 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

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.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Suggested Courses
Course of the Month10 days, 23 hours left to enroll

770 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