COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: hrk551 on 25 Jul 2011 10:07:49 AM

Title: Data source connection failure- but connect succeds in cognos connection----URGE
Post by: hrk551 on 25 Jul 2011 10:07:49 AM
Hello,

I have a data source connection issue in framework manager, but when i test the connection in cognos connection it says succeeded. I am getting following error

QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
WAREHOUSE

UDA-SQL-0031 Unable to access the "WAREHOUSE" database.
UDA-SQL-0107 A general exception has occurred during the operation "attach".
ORA-12638: Credential retrieval failed

can someone help me out its very urgent.

Thanks in adv
HRK
Title: Re: Data source connection failure- but connect succeds in cognos connection----URGE
Post by: Lynn on 25 Jul 2011 11:44:32 AM
I think you can find other posts on how to solve this.

I believe the issue is that Cognos Connection is using the database client software resident on the Cognos server while Framework Manager is relying on the database client software installed on whatever machine FM is installed on.
Title: Re: Data source connection failure- but connect succeds in cognos connection----URGE
Post by: hrk551 on 25 Jul 2011 03:13:01 PM
resolved this issue. Issue is with sql net. Changed it to none.

Thank you Lynn for your time.

HRK
Title: Re: Data source connection failure- but connect succeds in cognos connection----URGE
Post by: bioCam on 26 Jul 2011 12:42:16 PM
Hi hrk551, could you please provide details on how you changed sql net. to none.  i am having the same issue?  thank you.