Cognos (connection trouble, i need help!!!)

[Flyer Fighter]

OS Solaris 9 - Cognos Service 8.3
OS Solaris - Web server (Apache 2.2.8)
OS Windows XP - Framework

I have a problem with connection to ORACLE 10 on the portal:
UDA-SQL-0432 Unable to locate the gateway "libcogudaor"

I don't have this problem from the framework(test data store is OK)

Code Select Expand

10.100.60.10:9300 21408 2008-03-12 14:16:27.772 +3 Termination_SESS Termination_REQ main CM 888 1 Audit.cms.CM StopService ContentManagerService Success CM-SYS-5094 Content Manager stopped.; Build=8.3.888.0
10.100.60.10:9300 21408 2008-03-12 14:16:27.795 +3 stopper-monitorService MS 718 1 Audit.ms.MS StopService MonitorService Success
10.100.60.10:9300 21408 2008-03-12 14:16:27.789 +3 shutdown na na 0 main DISP 727 1 Audit.Other.dispatcher.DISP.com.cognos.pogo.services.DispatcherServices StopService CPS Producer Registration Service Success
10.100.60.10:9300 21408 2008-03-12 14:16:27.796 +3 stopper-deliveryService DLS 694 1 Audit.ds.DLS StopService DeliveryService Success
10.100.60.10:9300 21408 2008-03-12 14:16:29.804 +3 stopper-eventManagementService EMS 718 1 Audit.ems.EMS StopService EventService Success
10.100.60.10:9300 21408 2008-03-12 14:16:29.814 +3 shutdown na na 0 main DISP 727 1 Audit.Other.dispatcher.DISP.com.cognos.pogo.services.DispatcherServices StopService ReportService Success
10.100.60.10:9300 21408 2008-03-12 14:16:29.810 +3 shutdown na na 0 main DISP 727 1 Audit.Other.dispatcher.DISP.com.cognos.pogo.services.DispatcherServices StopService BatchReportService Success
10.100.60.10:9300 21408 2008-03-12 14:16:29.810 +3 shutdown na na 0 main DISP 727 1 Audit.Other.dispatcher.DISP.com.cognos.pogo.services.DispatcherServices StopService SystemService Success
10.100.60.10:9300 21408 2008-03-12 14:16:29.805 +3 stopper-jobService JS 652 1 Audit.js.JS StopService JobService Success
10.100.60.10:9300 21408 2008-03-12 14:16:29.822 +3 Thread-468 xts 665 1 Audit.ps.xts StopService PresentationService Success
10.100.60.10:9300 21408 2008-03-12 14:16:29.806 +3 stopper-agentService ASV 698 1 Audit.as.ASV StopService AgentService Success
10.100.60.10:9300 21408 2008-03-12 14:16:29.817 +3 shutdown na na 0 main DISP 727 1 Audit.Other.dispatcher.DISP.com.cognos.pogo.services.DispatcherServices StopService ReportDataService Success
10.100.60.10:9300 21408 2008-03-12 14:16:29.830 +3 stopper-logService LOGSV 643 1 server.Audit.IPF StopService LogService Success <parameters><item name="Port"><![CDATA[9362]]></item><item name="Mode"><![CDATA[UDP]]></item><item name="Secure"><![CDATA[FALSE]]></item></parameters>
10.100.60.10:9300 22317 2008-03-12 14:17:42.946 +3 main LOGSV 643 1 server.Audit.IPF StartService LogService Success <parameters><item name="Port"><![CDATA[9362]]></item><item name="Mode"><![CDATA[UDP]]></item><item name="Secure"><![CDATA[FALSE]]></item></parameters>
10.100.60.10:9300 21543 2008-03-12 14:17:48.399 +3 1 RSVP 816 1 Audit.RTUsage.RSVP StopService ReportService Success
10.100.60.10:9300 22317 2008-03-12 14:17:51.753 +3 Initialization_SESS Initialization_REQ Thread-15 CM 888 1 Audit.cms.CM StartService ContentManagerService Success CM-SYS-5090 Content Manager build 8.3.888.0 started (schema version 4.0066).
10.100.60.10:9300 22317 2008-03-12 14:17:51.754 +3 Initialization_SESS Initialization_REQ Thread-15 CM 888 1 Audit.cms.CM StartService ContentManagerService Info CM-SYS-5159 Content Manager is running in active mode.
10.100.60.10:9300 22317 2008-03-12 14:17:53.840 +3 BootstrapConfigurePublish na 0 BootstrapConfigurePublish-thread DISP 727 1 Audit.Other.dispatcher.DISP.com.cognos.pogo.contentmanager.coordinator.CMBootstrap StartService dispatcherBootstrap Info DPR-DPR-1002 Successfully registered the dispatcher http://10.100.60.10:9300/p2pd in Content Manager.
10.100.60.10:9300 22317 2008-03-12 14:18:01.568 +3 BootstrapConfigurePublish-thread xts 665 1 Audit.ps.xts StartService PresentationService Success
10.100.60.10:9300 22317 2008-03-12 14:18:01.835 +3 BootstrapConfigurePublish na 0 BootstrapConfigurePublish-thread DISP 727 1 Audit.Other.dispatcher.DISP.com.cognos.pogo.services.DispatcherServices StartService SystemService Success
10.100.60.10:9300 22317 2008-03-12 14:18:01.569 +3 BootstrapConfigurePublish na 0 BootstrapConfigurePublish-thread DISP 727 1 Audit.Other.dispatcher.DISP.com.cognos.pogo.services.DispatcherServices StartService ReportDataService Success
10.100.60.10:9300 22317 2008-03-12 14:18:01.598 +3 BootstrapConfigurePublish na 0 BootstrapConfigurePublish-thread DISP 727 1 Audit.Other.dispatcher.DISP.com.cognos.pogo.services.DispatcherServices StartService ReportService Success
10.100.60.10:9300 22317 2008-03-12 14:18:01.849 +3 BootstrapConfigurePublish-thread JS 652 1 Audit.js.JS StartService JobService Success
10.100.60.10:9300 22317 2008-03-12 14:18:02.112 +3 BootstrapConfigurePublish-thread DLS 694 1 Audit.ds.DLS StartService DeliveryService Success
10.100.60.10:9300 22317 2008-03-12 14:18:02.113 +3 BootstrapConfigurePublish-thread MS 718 1 Audit.ms.MS StartService MonitorService Success
10.100.60.10:9300 22317 2008-03-12 14:18:01.835 +3 BootstrapConfigurePublish na 0 BootstrapConfigurePublish-thread DISP 727 1 Audit.Other.dispatcher.DISP.com.cognos.pogo.services.DispatcherServices StartService BatchReportService Success
10.100.60.10:9300 22317 2008-03-12 14:18:02.057 +3 BootstrapConfigurePublish-thread EMS 718 1 Audit.ems.EMS StartService EventService Success
10.100.60.10:9300 22317 2008-03-12 14:18:01.845 +3 BootstrapConfigurePublish-thread ASV 698 1 Audit.as.ASV StartService AgentService Success
10.100.60.10:9300 22317 2008-03-12 14:18:03.944 +3 BootstrapConfigurePublish na 0 BootstrapConfigurePublish-thread DISP 727 1 Audit.Other.dispatcher.DISP.com.cognos.pogo.services.DispatcherServices StartService CPS Producer Registration Service Success
10.100.60.10:9300 22401 2008-03-12 14:21:43.348 +3 5 RSVP 816 1 Audit.RTUsage.RSVP StartService ReportService Success
10.100.60.10:9300 22401 2008-03-12 14:21:45.212 +3 99A86EDF3D09DFF15244B59D20D7B0A29C3F51C0 vjdjGsvG8CMCv2G4jCwddCvGjC49GM8qhMy4CG8j vjdjGsvG8CMCv2G4jCwddCvGjC49GM8qhMy4CG8j 5 RSVP 816 1 Audit.RTUsage.RSVP Response ReportService Failure 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:
    testDataSourceConnection
UDA-SQL-0432 Unable to locate the gateway "libcogudaor".
10.100.60.10:9300 22401 2008-03-12 14:23:23.398 +3 99A86EDF3D09DFF15244B59D20D7B0A29C3F51C0 GvqGsCwMvlM8G9MhCl4vGvdq49vyG4hG2wCGdq8y GvqGsCwMvlM8G9MhCl4vGvdq49vyG4hG2wCGdq8y 5 RSVP 816 1 Audit.RTUsage.RSVP Response ReportService Failure 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:
    testDataSourceConnection
UDA-SQL-0432 Unable to locate the gateway "libcogudaor".
10.100.60.10:9300 22401 2008-03-12 15:48:13.244 +3 C49D62B0899A83319A677CCF05F678E40A3C77A5 lqwd9hhs8lGwh9sCCjdCy494jdsdqhddw4GjqhCh lqwd9hhs8lGwh9sCCjdCy494jdsdqhddw4GjqhCh 5 RSVP 816 1 Audit.RTUsage.RSVP Response ReportService Failure 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:
    testDataSourceConnection
UDA-SQL-0432 Unable to locate the gateway "libcogudaor".
10.100.60.10:9300 22401 2008-03-12 16:41:17.662 +3 BEF2D066B8B32D1762E8C1A1FE5DFABF52E365E5 vjy4hM9vs9j8lvyGhdlCs2q4l99C98G9y9w2w9vs vjy4hM9vs9j8lvyGhdlCs2q4l99C98G9y9w2w9vs 5 RSVP 816 1 Audit.RTUsage.RSVP Response ReportService Failure 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:
    testDataSourceConnection
UDA-SQL-0432 Unable to locate the gateway "libcogudaor".
10.100.60.10:9300 22401 2008-03-13 10:38:25.969 +3 1CF745DB777E01596052663AD5D48919F1698B8A 4hsy4vGw4dy84y8hqyd8dGsGwyC2lhydhys8j9l2 4hsy4vGw4dy84y8hqyd8dGsGwyC2lhydhys8j9l2 5 RSVP 816 1 Audit.RTUsage.RSVP Response ReportService Failure 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:
    testDataSourceConnection
UDA-SQL-0432 Unable to locate the gateway "libcogudaor".

[Ty Clabbers]

Do you have the oracle bin directory added to your windows variabele path?

[Flyer Fighter]

YES
and connect from SQL PLUS IS OK

[ducthcogtechie]

Did you install the oracle client on the XP machine with the "administrator" option to make sure all is included (especially oraoledb10.dll)

[swordfish]

This issue of libcoguador is something for which even Cognos does not provide a definitive answer because the reasons that cause this issue could be anything from your LD_LIBRARY_PATH,  .profile, TNS Entries, oracle libraries, fully qualified domain names in TNS entries, etc etc.

According to my experience (may not be 100% solution), Cognos does not end the connections to database even after a report execution is completed. Too many connections from Cognos to your db could be the issue. Restarting your cognos server should solve it (but not a permanent solution). Restart closes all connections to database.

I am still researching, somewhere in cognos you can set the timeout for db connections. I have to try this option before I can suggest you.

[TheWatcher]

I've just encountered this issue as well.
I've resolved it here by locating ALL tnsnames.ora files on my system and making sure that they all contain the same information. (I had 2 of them)
Not sure why the original was being used some of the time, and the short one the rest of the time, but once they were the same and I restarted the Cognos service, the issue went away.
This should work for both Window and Linux.
Hope that helps someone down the line.
-D.

[ashishjimmy]

Looks like  a Dispatcher problem in Connections
I diod the following things and it worked

Routing rule was defined for windows dispatcher
Without it it will be hit or miss (will work whenever you happen to get routed to windows - will fail when you are routed to Unix)

[CognosWade]

Thanks DaveHull for that advice.  Clearing the other tnsnames.ora and restarting the Cognos service did the trick for me