Cannot create new datasource on MR3 (Unable to locate the gateway "libcogudaor")

[pikachu]

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>
~

[pikachu]

Managed to solve it - My oracle client was 64bit but Cognos Reportnet is 32bit. Therefore I had to set my env variable LIBPATH to $ORACLE_HOME/lib32. Once that was set and the Cognos server restarted, everything worked fine.

[COGNOiSe administrator]

BIG Thanks for sharing the answer.  ;D Most people forget that we are here to learn from each other.

BTW, that would have been my suggestion, too.