For example, if for any reason the oci.dll (located in the Oracle bin directory) is not available then the connection fails. But in the web server when i check connection i have an error: UDA-SQL-0432 Unable to locate the gateway "libcogudaor" Join this group 1Reply Best Answer 0 Mark this reply as Document information More support for: Cognos Business Intelligence Cognos Administration Software version: 8.4.1, 10.1, 10.1.1, 10.2, 10.2.1, 10.2.2 Operating system(s): Windows Software edition: Enterprise Reference #: 1614942 Modified date: 13 December So, it doesn't much matter if the Linux server is configured for the data source connection at this point. Source
PCMag Digital Group AdChoices unused Log In E-mail or User ID Password Keep me signed in Recover Password Create an Account Blogs Discussions CHOOSE A TOPIC Business Intelligence C Languages Oracle's SQLPlus allows connections based on unqualified aliases while IBM Cognos requires the exact alias name to make the appropriate connection. Remove references one by one, test datasources after change, finally remove the one which is causing the issue and leave others. Cross reference information Segment Product Component Platform Version Edition Business Analytics Cognos Business Intelligence Cognos Connection Windows 8.4 Document information More support for: Cognos Business Intelligence Cognos Connection Software version: 8.4, http://www-01.ibm.com/support/docview.wss?uid=swg21415557
Meredith Dart Never let a computer know you're in a hurry - Anonymous Top For discussions on Cognos Data Manager please visit the Cognos group. Setting these to the following is a good test: ulimit -d unlimited ulimit -m unlimited LDR_CNTRL=MAXDATA=0x80000000 11. SystemAdmin 110000D4XK 2012-08-27T10:12:39Z The Cognos server only supplies the connection details to FM, it does not actually make the connection when FM tries to retrieve the metadata. The 32-bit client libraries are required for establishing a connection with Cognos .
That is, other software or other oracle client installations can be identified in the system PATH environment variable, and are being sourced inappropriately for the Oracle libraries. Uda-sql-0432 Unable To Locate The Gateway Libcogudaor Logon to an Oracle database via SQl*Plus from Cognos Server, then you can see if the Oracle client is 64-bit Production or 32-bit Production; 2. Also Oracle might reject the attempt as unauthorized. check it out Resolving the problem Either remove references from system PATH variable to other dll library locations or copy unloaded libraries to Windows/System32 -folder. 1) Test all references to dll libraries in a
Click 'edit' and modify the TNS_ADMIN to include the correct path to the tnsnames.ora file and click 'OK'. For WebSphere, ensure that you define ORACLE_HOME, TNS_ADMIN, and the appropriate PATH variables within the Process Definition screen demonstrated in the following example: After setting the environment variables, make sure you Keep in mind that when FM is attempting to access a database, it does go to the Cognos server to get some information, but the local deskop is acting as a Can you successfully connect to the database with the driver on the FM system using other applications?
It is highly suggested that the Oracle client software version matches the Oracle database version for compatibility reasons. http://www-01.ibm.com/support/docview.wss?uid=swg21394002 In such cases, it might be necessary to update the copied tnsnames.ora entry to refer to the Oracle database server by using an IP address instead of the server name. 4. Uda-sql-0432 Unable To Locate The Gateway Cogudaor . Framework Manager In some cases, a server that is identified by name might not be resolvable on secondary systems (that is, if name resolution is not configured or the secondary system is in Rqp-def-0068 Unable To Connect To At Least One Database During A Multi-database Attach To 1 Database h.
Oracle 11g installed on machine 2. this contact form If you cannot restart the server, just restarting the Cognos service will suffice. We've installed and configured the Informix Connect software and also configured a DSN, so after much mucking about we can now successfully test the data source. Testing cogudaor.dll / cogudaif.dll with Dependency Walker and Process Explorer software showed libraries being loaded successfully. 3rd party software "CYGWIN" and "OpenSSH" installations on same machine are known to cause this Qe-def-0285 The Logon Failed Oracle
Sri asked Apr 5, 2007 | Replies (6) Hi, When I am trying to create a new data source in FM for Oracle 9 database, I am getting the following error. 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: CISCO_UCCX_Prod UDA-SQL-0432 QE-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database in: testDataSourceConnection UDA-SQL-0432 Unable to locate the gateway "cogudaor". have a peek here If a signon exists, click the Set Properties action for the signon and then click the Signon tab.
Dependency Walker can be attached to cogudaor.dll (located in the Cognos bin directory) to identify any inaccessible libraries required for establishing the connection. Framework Manager establishes its own connections to isolate resource consumption and prevent latencies on the IBM Cognos server due to long-running queries that might be run from Framework Manager during model There's very little in the support site about this error, and nothing previously posted in this forum.
In UNIX, the ldd command can be used to identify the dependencies of the libcogudaor library (located in the Cognos bin directory). SystemAdmin 110000D4XK 1959 Posts Re: Error Obtaining Metadata fro Informix Database.... 2012-08-28T02:48:20Z This is the accepted answer. Steps: 1. Any ideas?
Depending on the Oracle version, the message might also list "libcogudaor10" Cause Incomplete configuration of the Oracle client. Do you know if it has to be the Informix Connect tool installed locally, or will the odbc driver do? Also note that you will need the 32-bit version of the driver. http://globalcryptonews.com/unable-to/unable-to-access-service-at-url-framework-manager.html I think I also need to do another thing - the firewall would be blocking connections from my desktop - as it has only been configured to accept them from the
Attempt to use the Oracle client tools to establish a connection to the Oracle database. anisarkar replied Aug 1, 2011 I have the Oracle 9i server on the same machine. Join this group Popular White Paper On This Topic Top 10 Warning Signs of a Troubled Analytics Project 6Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this With the Oracle Client drivers installed, restart the system.
As a last resort, copy both the files
Do you know if it has to be the Informix Connect tool installed locally, or will the odbc driver do? mgibson 2700002RPC 215 Posts Re: Error Obtaining Metadata fro Informix Database.... 2012-08-28T06:01:53Z This is the accepted answer. Any ideas? Environment Windows, Cygwin Resolving the problem Remove the cygwin\bin entry from the PATH Variable.
Cause Dll libraries of other software installed on same Windows machine are interfering with database native clients' dll libraries used by Cognos for accessing datasources. In IBM Cognos , the client driver is required on both the IBM Cognos server and on any system that runs Framework Manager. nrh. Example: TNS_ADMIN:=oracle client install/product/product_version/Client_1/NETWORK/ADMIN Steps: 1.
dump -H libcogudaor.so -- AIX Using these trace utilities identify scenarios where the libraries are being sourced from a location other than the expected Oracle bin directory.