Problems creating transformer cube o linux with oracle client

[ccguerios]

Hello, I'm having problems to create a Cube using transformer on Linux and my Cognos BI on Unix. The PMR is taking to long so solve (4 months).

Problem:

Thu 19 May 2011 10:52:01        2       000000B7        QE-DEF-0285 The logon failed.
Thu 19 May 2011 10:52:01        2       000000B7        QE-DEF-0325 The logon failed for the following reason:
Thu 19 May 2011 10:52:01        2       000000B7        RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
Thu 19 May 2011 10:52:01        2       000000B7            great_outdoors_sales


* The create works fine o BI (I also have cogtr on BI for testing)
* The create works fine o Windows (transformer cli)

SUSE Linux Enterprise Server 10 (x86_64)
VERSION = 10
PATCHLEVEL = 3

Business Intelligence Transformer version 8.4.6019.0 and Congos BI at same level.

Oracle
Server - 11.2.0.2
Client - 11.2.0.1

Env=>

ETPKIHOME=/opt/CA/SharedComponents/etpki/3.2.0/
LESSKEY=/etc/lesskey.bin
NNTPSERVER=news
INFODIR=/usr/local/info:/usr/share/info:/usr/info
MANPATH=/usr/local/man:/usr/share/man:/usr/X11R6/man:/opt/gnome/share/man
HOSTNAME=brldk326
GNOME2_PATH=/usr/local:/opt/gnome:/usr
XKEYSYMDB=/usr/X11R6/lib/X11/XKeysymDB
engine=orades10|/opt/oracle/product/11.2.0/home
COD=DCGP|orades10|/opt/oracle/product/11.2.0/home|11.2.0
HOST=brldk326
TERM=xterm
SHELL=/bin/bash
PROFILEREAD=true
HISTSIZE=1000
SSH_CLIENT=167.10.11.4 2711 22
MORE=-sl
OLDPWD=/aplic/TRDD1
SSH_TTY=/dev/pts/1
GROFF_NO_SGR=yes
JRE_HOME=/usr/lib64/jvm/jre
USER=cogtradm
LD_LIBRARY_PATH=/opt/cognos/c8/bin:/:/opt/cognos/c8:.
LS_COLORS=no=00:fi=00:di=01;34:ln=00;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=41;33;01:ex=00;32:*.cmd=00;32:*.exe=01;32:*.com=01;32:*.bat=01;32:*.btm=01;32:*.dll=01;32:*.tar=00;31:*.tbz=00;31:*.tgz=00;31:*.rpm=00;31:*.deb=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.zoo=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.tb2=00;31:*.tz2=00;31:*.tbz2=00;31:*.avi=01;35:*.bmp=01;35:*.fli=01;35:*.gif=01;35:*.jpg=01;35:*.jpeg=01;35:*.mng=01;35:*.mov=01;35:*.mpg=01;35:*.pcx=01;35:*.pbm=01;35:*.pgm=01;35:*.png=01;35:*.ppm=01;35:*.tga=01;35:*.tif=01;35:*.xbm=01;35:*.xpm=01;35:*.dl=01;35:*.gl=01;35:*.wmv=01;35:*.aiff=00;32:*.au=00;32:*.mid=00;32:*.mp3=00;32:*.ogg=00;32:*.voc=00;32:*.wav=00;32:
ORACLE_SID=orades10
ORACLE_RMAN=---
XNLSPATH=/usr/X11R6/lib/X11/nls
ENV=/etc/bash.bashrc
nLIBPATH=/opt/oracle/product/11.2.0/home/lib:/opt/cognos/c8/bin:.
ORACLE_BASE=/opt/oracle/product/11.2.0/
HOSTTYPE=x86_64
TMOUT=600
LIBPATH=/opt/oracle/product/11.2.0/home/lib:/opt/cognos/c8/bin:/opt/cognos/c8:.
FROM_HEADER=
PAGER=less
CSHEDIT=emacs
ORACLE_VERSION=11.2.0
XDG_CONFIG_DIRS=/usr/local/etc/xdg/:/etc/xdg/:/etc/opt/gnome/xdg/
ORACLE_SERVER=brldk326
MINICOM=-c on
TNS_ADMIN=/opt/oracle/product/11.2.0/home/network/admin
MAIL=/var/spool/mail/oracle
PATH=/opt/oracle/product/11.2.0/home/bin:/home/oracle/bin:/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/games:/opt/gnome/bin:/usr/lib/mit/bin:/usr/lib/mit/sbin:/opt/CA/SharedComponents/bin:/opt/CA/SharedComponents/ccs/cam/bin:/aplic/ORA/script:/aplic/ORA/script/utilit:/aplic/ORA/script:/aplic/ORA/script/utilit:/opt/cognos/c8/bin:/opt/cognos/c8:/usr/lib/jvm/java-1_5_0-ibm-1.5.0/jre/bin/
CA_CAILANGUAGE=enu
CPU=x86_64
JAVA_BINDIR=/usr/lib/jvm/java-1_5_0-ibm-1.5.0/jre/bin/
INPUTRC=/home/oracle/.inputrc
PWD=/aplic/TRDD1/bin
JAVA_HOME=/usr/lib/jvm/java-1_5_0-ibm-1.5.0/jre/
LANG=C
PYTHONSTARTUP=/etc/pythonstart
LINHA=:1:DCGP|orades10|/opt/oracle/product/11.2.0/home|11.2.0|brldk326|---|---|
export /opt/oracle/product/11.2.0/home/network/admin|---|N|
PS1=\u@\h:\w>
ORACLE_ARQ=32
TEXINPUTS=:/home/oracle/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX
SHLVL=1
HOME=/home/cogtradm
CANOLOG_flag=
LESS_ADVANCED_PREPROCESSOR=no
OSTYPE=linux
LS_OPTIONS=-N --color=tty -T 0
WINDOWMANAGER=
LESS=-M -I
MACHTYPE=x86_64-suse-linux
LOGNAME=oracle
CLASSPATH=/opt/oracle/product/11.2.0/home/jdbc/lib/ojdbc5.jar
XDG_DATA_DIRS=/usr/local/share/:/usr/share/:/etc/opt/kde3/share/:/opt/kde3/share/:/opt/gnome/share/
ACLOCAL_FLAGS=-I /opt/gnome/share/aclocal
SSH_CONNECTION=167.10.11.4 2711 167.2.52.5 22
PKG_CONFIG_PATH=/opt/gnome/lib64/pkgconfig:/opt/gnome/share/pkgconfig
LESSOPEN=lessopen.sh %s
CASHCOMP=/opt/CA/SharedComponents
CAI_MSQ=/opt/CA/SharedComponents/ccs/cam
INFOPATH=/usr/local/info:/usr/share/info:/usr/info:/opt/gnome/share/info
ORA_NLS33=/opt/oracle/product/11.2.0/home/ocommon/nls/admin/data
CABIN=/opt/CA/SharedComponents/bin
ORACLE_HOME=/opt/oracle/product/11.2.0/home
CALIB=/opt/CA/SharedComponents/lib
LESSCLOSE=lessclose.sh %s %s
ORACLE=/opt/oracle/product/11.2.0/home
G_BROKEN_FILENAMES=1
HISTFILE=/home/oracle/.bash_history
JAVA_ROOT=/usr/lib/jvm/java-1_5_0-ibm-1.5.0/jre/
COLORTERM=1
_=/usr/bin/env

Issue:

cogtradm@brldk326:/aplic/TRDD1/bin> ./cubo_go.sh
Business Intelligence Transformer version 8.4.6019.0
Transformer(Transformer)    Thu 19 May 2011 10:51:59
LogFileDirectory=/aplic/TRDD1/log/
ModelSaveDirectory=/aplic/TRDD1/Models/
DataSourceDirectory=/aplic/TRDD1/Data/
CubeSaveDirectory=/aplic/TRDD1/Cubes/
DataWorkDirectory=/aplic/TRDD1/temp
ModelWorkDirectory=/aplic/TRDD1/Models/
MaxTransactionNum=500000

Thu 19 May 2011 10:51:59        3       00000000        Command Line: ./cogtr -c -m go.mdl -r4 [->OK]
Thu 19 May 2011 10:51:59        3       00000000        Processing MDL file /aplic/TRDD1/Models/go.mdl
Thu 19 May 2011 10:51:59        3       00000000        Creating model file /aplic/TRDD1/Models/ppd14902.qyj
Thu 19 May 2011 10:52:00        3       000000B7        Completed processing of MDL file /aplic/TRDD1/Models/go.mdl
Thu 19 May 2011 10:52:00        4       000000B7        Start cube update.
Thu 19 May 2011 10:52:00        4       000000B7        Initializing categories.
Thu 19 May 2011 10:52:00        4       000000B7        Timing, INITIALIZING CATEGORIES,00:00:00
Thu 19 May 2011 10:52:00        4       000000B7        Start processing data source 'GO Sales'.
Thu 19 May 2011 10:52:00        4       000000B7        Reading source data.
Thu 19 May 2011 10:52:01        2       000000B7        QE-DEF-0285 The logon failed.
Thu 19 May 2011 10:52:01        2       000000B7        QE-DEF-0325 The logon failed for the following reason:
Thu 19 May 2011 10:52:01        2       000000B7        RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
Thu 19 May 2011 10:52:01        2       000000B7            great_outdoors_sales
Thu 19 May 2011 10:52:01        2       000000B7
Thu 19 May 2011 10:52:01        2       000000B7        UDA-SQL-0432 Unable to locate the gateway "libcogudaor".
Thu 19 May 2011 10:52:01        4       000000B7        End processing 0 records from data source 'GO Sales'.
Thu 19 May 2011 10:52:01        4       000000B7        Timing, READ DATA SOURCE,00:00:01
Thu 19 May 2011 10:52:02        4       000000B7        End cube update.
Thu 19 May 2011 10:52:02        4       000000B7        Timing, TOTAL TIME (CREATE CUBE),00:00:02
Thu 19 May 2011 10:52:02        4       000000B7        (TR0102) The process or action was cancelled at your request. [->OK]
Thu 19 May 2011 10:52:02        3       000000B7        Closing model file /aplic/TRDD1/Models/ppd14902.qyj
Thu 19 May 2011 10:52:02        3       000000B7        Transformer exiting - operation failed

[screwdrive]

I know its pretty late but I am facing exact issue in cognos 10.2.2. How did you get pass this one?

[MFGF]

I know its pretty late but I am facing exact issue in cognos 10.2.2. How did you get pass this one?

The key part of the message seems to be:

UDA-SQL-0432 Unable to locate the gateway "libcogudaor"

There's a good IBM document that walks through the most likely causes of that error:

http://www-01.ibm.com/support/docview.wss?uid=swg21341734

Cheers!

MF.