Cannot create new datasource on MR3 (gateway "libcogudaor")

[masrudyn]

Hi,

I've just installed Cognos ReportNet MR3 on IBM AIX. I am using Oracle 10G as my datamart and for my Content Manager.

I can create a new Content Manager and Cognos has created all its system tables upon started. However, when I try to create a new Datasource via Cognos Connection, it fails with the error messages in crnserver.log (see end of this message).


I've tried setting CRN_ROOT, COGNOS_HOME to /cognos/crn but it does not work.

I've set LIBPATH=$ORACLE_HOME/lib:/cognos/crn/bin as well as LIBPATH=$ORACLE_HOME/lib but it still fails.

Can someone help me, please? Thanks. (error messages are found below)

Original Error: QE-DEF-0285 Logon failure.^M
QE-DEF-0325 The cause of the logon failure is:^M
QE-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
testDataSourceConnection
^M
UDA-SQL-0432 Unable to locate the gateway "libcogudaor".^M
Trace back:^M
WPBIBusMethod.cpp(198): QSException: CCL_CAUGHT: WPBIBusMethod::runRequest^M
Source/CQEConnection.cpp(304): QSException: CCL_RETHROW: CQECommon^M
Source/CQEConnection.cpp(303): QSException: CCL_CAUGHT: CQECommon^M
Source/QE_QsApi.cpp(2963): QSException: CCL_RETHROW: QE^M
Source/QESqlServer.cpp(3064): QSException: CCL_THROW: QE
10.54.4.39:9300 1568982 2007-05-30 10:43:39.73 +8 2828 RSVP 4086 1 Audit.RTUsage.RSVP StartService ReportService
Success
10.54.4.39:9300 1585362 2007-05-30 10:43:40.257 +8 010:631440aa-1dd2-11b2-aa76-a33f5560bf8e:2003181085 48w489CG2w9jGq9qqM9w9CqG8jvhqCvqwjvy4jdy 1
Thread-21 DISP 1279 1 Audit.Other.DISP.com.cognos.pogo.handlers.engine.ServiceLookupHandler Request Failure <messages><message><messageSt
ring>Client Error</messageString></message><message><messageString>QE-DEF-0285 Logon failure.</messageString></message><message><messageString>QE-DEF-0325 The cause of the l
ogon failure is:</messageString></message><message><messageString>QE-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
&#10; testDataSourceConnection&#10;</messageString></message><message><messageString>UDA-SQL-0432 Unable to locate the gateway &quot;libcogudaor&quot;.</messageString></m
essage><message><messageString>Trace back:</messageString></message><message><messageString>WPBIBusMethod.cpp(198): QSException: CCL_CAUGHT: WPBIBusMethod::runRequest</messa
geString></message><message><messageString>Source/CQEConnection.cpp(304): QSException: CCL_RETHROW: CQECommon</messageString></message><message><messageString>Source/CQEConn
ection.cpp(303): QSException: CCL_CAUGHT: CQECommon</messageString></message><message><messageString>Source/QE_QsApi.cpp(2963): QSException: CCL_RETHROW: QE</messageString><
/message><message><messageString>Source/QESqlServer.cpp(3064): QSException: CCL_THROW: QE</messageString></message></messages> <trace>reportService.server</trace>

 

[masrudyn]

Hi guys,

I managed to solve it. Cognos is 32bit application while the Oracle client was 64bit so I had to use the 32bit Oracle libraries. Once I set LIBPATH=$ORACLE_HOME/lib32, everything worked fine.