Cube build on Linux

[bakchr]

We have been unable to get a cube to build on our new Linux installation. We have Transformer 8.4 installed on the Linux server with Oracle 64 bit 10.0.2 client with 32bit libraries. We have the LD_LIBRARY_PATH pointed to the 32 bit libraries. The cube builds successfully on the windows machine. I wondered about the error: UDA-SQL-0432 Unable to locate the gateway "libcogudaor" because I noticed that there is not a libcogudaor.so file in the c8/bin directory, but there is a libcogudaor9.so, libcogudaor10.so and libcogudaor11.so files. Are these related to the version of the Oracle client, and is there something that we need to do to get Cognos to chose the correct gateway. Just taking shots in the dark right now. Can't find anything in the KB and support has had it for a few weeks with no ideas. Anyone have any suggestions?

Mon 26 Jan 2009 01:38:17 PM     4       00032561        Reading source data.
Mon 26 Jan 2009 01:38:31 PM     2       00032561        QE-DEF-0285 The logon failed.
Mon 26 Jan 2009 01:38:31 PM     2       00032561        QE-DEF-0325 The logon failed for the following reason:
Mon 26 Jan 2009 01:38:31 PM     2       00032561        RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
Mon 26 Jan 2009 01:38:31 PM     2       00032561            shARCFIN
Mon 26 Jan 2009 01:38:31 PM     2       00032561
Mon 26 Jan 2009 01:38:31 PM     2       00032561        UDA-SQL-0432 Unable to locate the gateway "libcogudaor".
Mon 26 Jan 2009 01:38:31 PM     4       00032561        End processing 0 records from data source 'AIZENT'.
Mon 26 Jan 2009 01:38:31 PM     4       00032561        Timing, READ DATA SOURCE,00:00:14
Mon 26 Jan 2009 01:38:32 PM     4       00032561        End cube update.

[woowoo]

We are having a very similar issue with C8.4 on AIX 5.3 connecting to Oracle 10g, except this is with Cognos Connection. I have not even tried a cube yet. Everything points to 32-bit vs 64-bit issue. The strange part is that I previously had C8.3 installed and it worked fine. Plus our CRN 1.1 install on the same box, installed as a different user with a different profile and environment, is also working just fine.

Support has been no help for 4 days now.

If you find out something please post, and I will do the same.

[kolonell]

This just an issue with your env variables. Compare the output of the env command for both accounts. You will find that the c8/bin will be missing from either PATH or LD_LIBRARY_PATH. Or SHLIBPATH on aix

[woowoo]

here is a dump of my path and libpath env vars:
PATH=/opt/oracle/redbrick/rb63/bin:/opt/cognos/c8/bin:/opt/cognos/c8/cgi-bin:/usr/java5/jre/bin:/var/ebi/apps/c8/trigger:/usr/bin:/usr/ccs/bin:/usr/ucb:/etc:.::/opt/oracle/product/10.2.0/bin:/opt/db2inst1/sqllib/bin:/opt/db2inst1/sqllib/adm:/opt/db2inst1/sqllib/misc:/usr/sbin:/sfw/bin:.:

LIBPATH=/opt/oracle/product/10.2.0/lib32:/usr/lib:/opt/cognos/c8/bin:/opt/cognos/c8/cgi-bin::/opt/db2inst1/sqllib/lib:/opt/oracle/redbrick/rb63/lib32:/opt/oracle/redbrick/rb63/lib

I had c83 installed prior and everything worked just fine, connections to Oracle, DB2 and RedBrick DBs. Once I installed C8.4, Oracle connection works fine for connecting to the content store (via JDBC), but when setting up reporting DB connections to Oracle in Congos Connection, I get the UDA-SQL-0432 error.

[kolonell]

hmm .. that looks fine

what output do you get if you do an ldd on the libcogudaor.so ?  ( not sure about the filename but is in the C8 bin folder)

are the Environment variables you posted the ones for the account that starts c8 ? probably is but you never know ;-)

[woowoo]

Yeah,

I start up C8 using the c8apps account that has all of the env vars set.

ldd looks good too, but I am not an expert...

c8apps@napdci140:/opt/cognos/c8/bin>ldd libcogudaor.so
libcogudaor.so needs:
         /opt/cognos/c8/bin/libCCLCFGAPI.so
         /opt/cognos/c8/bin/libCAM_Crypto_Interface.so
         /opt/cognos/c8/bin/libcogudasql.so
         /opt/cognos/c8/bin/libCCLCore.so
         /opt/cognos/c8/bin/libQEGeneral.so
         /opt/cognos/c8/bin/libCCLIDOM.so
         /opt/cognos/c8/bin/libxerces-c.a
         /opt/oracle/product/10.2.0/lib32/libclntsh.so
         /usr/lib/libC.a(shr.o)
         /usr/lib/libC.a(shr2.o)
         /usr/lib/libC.a(shr3.o)
         /usr/lib/libC.a(ansi_32.o)
         /usr/lib/libc_r.a(shr.o)
         /usr/lib/libC_r.a(ansi_32.o)
         /opt/cognos/c8/bin/libIBJStreamsDLL.so
         /opt/cognos/c8/bin/libcogipf2.so
         /opt/cognos/c8/bin/coglog4ccl.so
         /opt/cognos/c8/bin/libz.so
         /opt/cognos/c8/bin/libCCLHttptools.so
         /usr/lib/libpthreads.a(shr_xpg5.o)
         /opt/cognos/c8/bin/libQEUtility.so
         /opt/cognos/c8/bin/libUTUtilities.so
         /opt/cognos/c8/bin/libQEExpression.so
         /opt/cognos/c8/bin/libicucogi18n.a(libicucogi18n36.0.so)
         /opt/cognos/c8/bin/libicucoguc.a(libicucoguc36.0.so)
         /opt/cognos/c8/bin/libwasptransport.so
         /opt/cognos/c8/bin/librci.so
         /opt/cognos/c8/bin/libwasp.so
         /opt/cognos/c8/bin/libzbstore.so
         /opt/cognos/c8/bin/libQEMetadata.so
         /usr/lib/libc.a(shr.o)
         /usr/lib/libdl.a(shr.o)
         /usr/lib/libodm.a(shr.o)
         /usr/lib/libperfstat.a(shr.o)
         /usr/lib/libC.a(ansicore_32.o)
         /usr/lib/libC.a(shrcore.o)
         /unix
         /usr/lib/libcrypt.a(shr.o)
         /usr/lib/libpthreads.a(shr_comm.o)
         /opt/cognos/c8/bin/libMfwFramework.so
         /opt/cognos/c8/bin/libMfwResources.so
         /opt/cognos/c8/bin/libMfwUtilities.so
         /opt/cognos/c8/bin/libicucoguc36.a(libicucoguc36.0.so)
         /opt/cognos/c8/bin/libicucogdata36.a(libicucogdata36.0.so)
         /usr/lib/libpthread.a(shr_xpg5.o)
         /opt/cognos/c8/bin/libBIBusTK.so
         /opt/cognos/c8/bin/libBmtCommon.so
         /opt/cognos/c8/bin/libBmtRuntimeGateway.so
         /usr/lib/libcfg.a(shr.o)
         /usr/lib/liblvm.a(shr.o)
         /opt/cognos/c8/bin/mfwlibxpathparser.so
         /opt/cognos/c8/bin/libBMTUtil.so
         /opt/cognos/c8/bin/libBMTApplication.so
         /opt/cognos/c8/bin/libIBJHelpers.so
         /opt/cognos/c8/bin/libBmtResources.so

[kolonell]

You're right that looks correct ... do you get similar results for 'ldd libcogudaor10' ?

How about the ulimits ? maybe compare those with the user account where C8 / crn does work.
    ulimit -d
    ulimit - m

[woowoo]

c8apps@napdci140:/opt/cognos/c8/bin>ulimit -d
unlimited
c8apps@napdci140:/opt/cognos/c8/bin>ulimit -m
unlimited
c8apps@napdci140:/opt/cognos/c8/bin>ulimit -n
1024
c8apps@napdci140:/opt/cognos/c8/bin>ulimit -s
81612

and this is set up the same as our CRN installation that is working correctly.

[kolonell]

maybe try and do an truss on the BIBusTKServerMain executable. That should trace the system calls in that process.

open another shell and attach truss to the BIBusTKServerMain (truss -f /path/to/BIBusTKServerMain ) not sure about the syntax so check the man page to attach to a file (or PID)
or use trcrpt if truss isn't available.

redo the testing the DB connection and maybe that 'll help in finding the cause

[Silvern]

Hi, tomw

I am now faced with the same issue wiht you.
We deployed Cognos 8.4 on AIX 5.3, Oracle 10.2.0.1. Installation is okay, but when we tried to connect the ORA db, the following Error Message:

    QE-DEF-0285 Logon failure.
    QE-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".

I tried the ldd command, there is no libcogudaor.so file but libcogudaor9.so,libcogudaor10so,libcogudaor11.so.
Would you please check ldd on libcogudaor10.so?

Appreciate and please update me with the support's reply to you. 

apothecary_wang@hotmail.com

Thanks.

[woowoo]

I made a copy of libcogudaor10.so and named it libcogudaor.so, thinking that was the problem. ldd on libcogudaor10.so returns the same result:

c8apps@napdci140:/opt/cognos/c8/bin>ldd libcogudaor10.so
libcogudaor10.so needs:
         /opt/cognos/c8/bin/libCCLCFGAPI.so
         /opt/cognos/c8/bin/libCAM_Crypto_Interface.so
         /opt/cognos/c8/bin/libcogudasql.so
         /opt/cognos/c8/bin/libCCLCore.so
         /opt/cognos/c8/bin/libQEGeneral.so
         /opt/cognos/c8/bin/libCCLIDOM.so
         /opt/cognos/c8/bin/libxerces-c.a
         /opt/oracle/product/10.2.0/lib32/libclntsh.so
         /usr/lib/libC.a(shr.o)
         /usr/lib/libC.a(shr2.o)
         /usr/lib/libC.a(shr3.o)
         /usr/lib/libC.a(ansi_32.o)
         /usr/lib/libc_r.a(shr.o)
         /usr/lib/libC_r.a(ansi_32.o)
         /opt/cognos/c8/bin/libIBJStreamsDLL.so
         /opt/cognos/c8/bin/libcogipf2.so
         /opt/cognos/c8/bin/coglog4ccl.so
         /opt/cognos/c8/bin/libz.so
         /opt/cognos/c8/bin/libCCLHttptools.so
         /usr/lib/libpthreads.a(shr_xpg5.o)
         /opt/cognos/c8/bin/libQEUtility.so
         /opt/cognos/c8/bin/libUTUtilities.so
         /opt/cognos/c8/bin/libQEExpression.so
         /opt/cognos/c8/bin/libicucogi18n.a(libicucogi18n36.0.so)
         /opt/cognos/c8/bin/libicucoguc.a(libicucoguc36.0.so)
         /opt/cognos/c8/bin/libwasptransport.so
         /opt/cognos/c8/bin/librci.so
         /opt/cognos/c8/bin/libwasp.so
         /opt/cognos/c8/bin/libzbstore.so
         /opt/cognos/c8/bin/libQEMetadata.so
         /usr/lib/libc.a(shr.o)
         /usr/lib/libdl.a(shr.o)
         /usr/lib/libodm.a(shr.o)
         /usr/lib/libperfstat.a(shr.o)
         /usr/lib/libC.a(ansicore_32.o)
         /usr/lib/libC.a(shrcore.o)
         /unix
         /usr/lib/libcrypt.a(shr.o)
         /usr/lib/libpthreads.a(shr_comm.o)
         /opt/cognos/c8/bin/libMfwFramework.so
         /opt/cognos/c8/bin/libMfwResources.so
         /opt/cognos/c8/bin/libMfwUtilities.so
         /opt/cognos/c8/bin/libicucoguc36.a(libicucoguc36.0.so)
         /opt/cognos/c8/bin/libicucogdata36.a(libicucogdata36.0.so)
         /usr/lib/libpthread.a(shr_xpg5.o)
         /opt/cognos/c8/bin/libBIBusTK.so
         /opt/cognos/c8/bin/libBmtCommon.so
         /opt/cognos/c8/bin/libBmtRuntimeGateway.so
         /usr/lib/libcfg.a(shr.o)
         /usr/lib/liblvm.a(shr.o)
         /opt/cognos/c8/bin/mfwlibxpathparser.so
         /opt/cognos/c8/bin/libBMTUtil.so
         /opt/cognos/c8/bin/libBMTApplication.so
         /opt/cognos/c8/bin/libIBJHelpers.so
         /opt/cognos/c8/bin/libBmtResources.so

[kolonell]

hmm, the only other things I can think of are :
- does the user that starts C8 have read permissions to the oracle /lib32 folder ?
- can you manually check if the libclntsh.so exists in the oracle /lib32 folder ?

[woowoo]

The file is there and so is the one it's linking to and all of the lib32 files are world read/execute...

c8apps@napdci140:/opt/cognos/c8> ls -al /opt/oracle/product/10.2.0/lib32/libclntsh.so
lrwxrwxrwx   1 oracle   dba              17 Jul 15 2008  /opt/oracle/product/10.2.0/lib32/libclntsh.so -> libclntsh.so.10.1
c8apps@napdci140:/opt/cognos/c8> ls -al /opt/oracle/product/10.2.0/lib32/libclntsh.so.10.1
-rwxr-xr-x   1 oracle   dba        21243154 Jul 16 2007  /opt/oracle/product/10.2.0/lib32/libclntsh.so.10.1

[kolonell]

the only other thing you can do is setting up the truss to see if something else is maybe messing up the LIBPATH at runtime ..

[Silvern]

Hi, tomw .

You said that it's fine when you used C8.3. So have you tried the libcogudaor10.so that time?

I install both c8.3 and c8.4 on my box, niether can connect to ORACLE.(they use different libcogudaor10.so)

I will post my ldd result later.

[woowoo]

the only other thing you can do is setting up the truss to see if something else is maybe messing up the LIBPATH at runtime ..

Can you explain the setup process?

[woowoo]

Hi, tomw .

You said that it's fine when you used C8.3. So have you tried the libcogudaor10.so that time?

I install both c8.3 and c8.4 on my box, niether can connect to ORACLE.(they use different libcogudaor10.so)

I will post my ldd result later.

I have c8.3 and c8.4 both on this server as well, running under different accounts with different .profiles, and C8.3 works just fine, where c8.4 does not. They both use the same Oracle 10.2.0.1.0 client software.