COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: Mahendra on 25 Aug 2011 05:30:05 AM

Title: Error on Creating new Data Source
Post by: Mahendra on 25 Aug 2011 05:30:05 AM
Hi Gurus'

When I am creating a new Data Source from Cognos connection its giving the below error m
message can any body suggest on this.

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


UDA-SQL-0432 Unable to locate the gateway "cogudaor".
RSV-SRV-0042 Trace back.


Its Urgent please help me.

Thanks in Advance.
Mahi




Title: Re: Error on Creating new Data Source
Post by: MFGF on 25 Aug 2011 06:51:30 AM
Hi,

I assume this is a connection to Oracle?

This might be a good place to start:

https://www-304.ibm.com/support/docview.wss?uid=swg21341734

Regards,

MF.
Title: Re: Error on Creating new Data Source
Post by: Mahendra on 25 Aug 2011 08:37:09 AM
Hi MFGF,

Thx for ur quick responce,

I forgot to say that we are newly installed cognos in a new server, which is 64 bit
and the Oracle data base is also installed in 64 Bit, is this causes any problem.

here we are getting the above problem.

Thanks
Mahi
Title: Re: Error on Creating new Data Source
Post by: navissar on 25 Aug 2011 08:46:21 AM
Cognos requires 32-bit client libraries to connect to Oracle as datasource. This means you need to have an Oracle 32-bit client *of the same version as the database server* installed on the Cognos machine to get it to connect.
Title: Re: Error on Creating new Data Source
Post by: MFGF on 25 Aug 2011 08:47:27 AM
You will need to use the 32 bit Oracle client libraries to be able to connect from Cognos 8.

Regards,

MF.

Edit - I have been beaten to it!! :-) 
Title: Re: Error on Creating new Data Source
Post by: navissar on 25 Aug 2011 09:02:11 AM
Jinx! :)
Title: Re: Error on Creating new Data Source
Post by: MFGF on 25 Aug 2011 11:04:29 AM
You were quick on the draw there! :-) Beat me to it fair and square! :-D
Title: Re: Error on Creating new Data Source
Post by: Mahendra on 26 Aug 2011 08:09:56 AM
Hi All,

Thanks for ur help,

Still we are facing problem we Uninstalled the Oracle which is installed
in 64 Bit, and reinstalled into 32-Bit

Other things,Conecction and all working fine,Except the creation of DateSource Connection from
from Cognos Connection.

Thanks
Mahi
Title: Re: Error on Creating new Data Source
Post by: MFGF on 26 Aug 2011 10:52:39 AM
Did you work through all the steps in the document link I sent to you?  They are usually pretty good at helping you to troubleshoot these kinds of problems.

Regards,

MF.
Title: Re: Error on Creating new Data Source
Post by: sir_jeroen on 31 Aug 2011 02:32:09 PM
are the tnsnames.ora accessible? What happens if you do a tnsping?
Title: Re: Error on Creating new Data Source
Post by: SGD on 02 Sep 2011 01:00:38 AM
I had similar problem with datasource connection and following below steps it resolve. I have documented this for future use.

CAN NOT CREATE DATASOURCE CONNECTION IN COGNOS 8.4.1 WITH ORACLE 11G DATABASE SERVER:
• Cognos 8.4.1 displays below error message when database connection is not established between Cognos 8.4.1 server and Oracle 11g database Server.
• Cognos Server (64 bit) is not able to connect with Oracle 11g (64 bit) database server though both the applications are compatible with each other.
• IBM Cognos supports 64-bit data sources via 32-bit connectivity. Hence, IBM Cognos 8.4.1 requires 10g Oracle 32-bit database client to connect with Oracle 11g 64-bit database application.
• Please refer below IBM sites for more clarification:
http://download.boulder.ibm.com/ibmdl/pub/software/data/cognos/support/en/products/Cognos84_64-bit_Jan2009.pdf (http://download.boulder.ibm.com/ibmdl/pub/software/data/cognos/support/en/products/Cognos84_64-bit_Jan2009.pdf)
http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14472653 (http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14472653)
http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14608083 (http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14608083)

• Cognos 8.4.1 displays below error message after installation of Oracle 10g 32-bit client on Cognos Server machine.
• Because installed Oracle 10g client is 'instant' client also with '10.2.0.1' version.
• To resolve this issue Oracle 10g 'Full' client has to be installed instead of 'Instant'.
• In addition to Oracle 10g Full client version should be 10.2.0.3 and above since Cognos Server is installed on Win 2003 SP2 Enterprise Edition 64-bit Operating System.
• Please refer below IBM sites for more clarification:
https://www-304.ibm.com/support/docview.wss?uid=swg21340273 (https://www-304.ibm.com/support/docview.wss?uid=swg21340273)
http://www.ibm.com/developerworks/forums/thread.jspa?threadID=323540 (http://www.ibm.com/developerworks/forums/thread.jspa?threadID=323540)

• Thus, need to install Oracle 10g R2 (10.2.0.3/10.2.0.4) client on Cognos server and which can be downloaded from here http://www.oracle.com/technetwork/database/10203vista-087538.html (http://www.oracle.com/technetwork/database/10203vista-087538.html)

• User has to copy and paste 'ojdbc14.jar' file from '...\oracle\product\10.2.0\client_1\jdbc\lib' folder path to '...\Program Files (x86)\cognos\c8\webapps\p2pd\WEB-INF\lib' folder path after installation of Oracle client 10g v10.2.0.3.
[/list]