aix 服务器刷新cube 报RQP-DEF-0068数据库连接错误

在windows下刷新成功,但是在aix下刷新不成功,aix中sqlplus能连接成功,并且oracle客户端是aix32位的。环境变量如下:export DISPLAY=10.7.134.15:0.0export JAVA_HOME=/usr/java5/jreexport LIBPATH=/cognos/app/transformer/ibm/cognos/c10/bin:/cognos/app/oracle/product/1...显示全部
在windows下刷新成功,但是在aix下刷新不成功,aix中sqlplus能连接成功,并且oracle客户端是aix32位的。环境变量如下:
export DISPLAY=10.7.134.15:0.0
export JAVA_HOME=/usr/java5/jre
export LIBPATH=/cognos/app/transformer/ibm/cognos/c10/bin:/cognos/app/oracle/product/11.2.0/client_1/lib
export ORACLE_SID=datacent
export ORACLE_BASE=/cognos/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/client_1
export LD_LIBRARY_PATH=/cognos/app/transformer/ibm/cognos/c10/bin:$ORACLE_HOME/lib
export PATH=$PATH:$ORACLE_HOME/bin:/usr/java5/jre
PATH=$PATH:/cognos/app/transformer/ibm/cognos/c10/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:.
export PATH
if [ -s "$MAIL" ]           # This is at Shell startup.  In normal
then echo "$MAILMSG"        # operation, the Shell checks
fi                          # periodically.


aix上刷新报错日志:
$ ./cogtr -c -m/cognos/RRS/MDL/cubetest1.mdl                                       
Business Intelligence Transformer version 10.1.6235.605
Transformer(Transformer)    Thu 26 Feb 2015 15:39:01   
LogFileDirectory=/cognos/app/transformer/ibm/cognos/c10/logs/
ModelSaveDirectory=/cognos/app/transformer/ibm/cognos/c10/temp/
DataSourceDirectory=/cognos/app/transformer/ibm/cognos/c10/data/
CubeSaveDirectory=/cognos/app/transformer/ibm/cognos/c10/temp/
DataWorkDirectory=/cognos/app/transformer/ibm/cognos/c10/temp
ModelWorkDirectory=/cognos/app/transformer/ibm/cognos/c10/temp/
Codepage: ISO_8859-1:1987
MaxTransactionNum=500000
Thu 26 Feb 2015 15:39:01        3       00000000        Command Line: ./cogtr -c -m/cognos/RRS/MDL/cubetest1.mdl [->OK]
Thu 26 Feb 2015 15:39:01        3       00000000        Processing MDL file /cognos/RRS/MDL/cubetest1.mdl
Thu 26 Feb 2015 15:39:01        3       00000000        Creating model file /cognos/app/transformer/ibm/cognos/c10/temp/ppd00162.qyj
Thu 26 Feb 2015 15:39:01        3       00000000        (TR0418) This model was built with a language setting that differs from the current setting. Some characters will be incorrectly displayed. Do you want to continue? [->Yes]
Thu 26 Feb 2015 15:39:02        3       0000043D        Completed processing of MDL file /cognos/RRS/MDL/cubetest1.mdl
Thu 26 Feb 2015 15:39:02        4       0000043D        Start cube update.
Thu 26 Feb 2015 15:39:02        4       0000043D        Initializing categories.
Thu 26 Feb 2015 15:39:02        4       0000043D        Timing, INITIALIZING CATEGORIES,00:00:00
Thu 26 Feb 2015 15:39:02        4       0000043D        Start processing data source 'RRS'.
Thu 26 Feb 2015 15:39:02        4       0000043D        Reading source data.
Thu 26 Feb 2015 15:39:04        2       0000043D        QE-DEF-0285 The logon failed.
Thu 26 Feb 2015 15:39:04        2       0000043D        QE-DEF-0325 The logon failed for the following reason:
Thu 26 Feb 2015 15:39:04        2       0000043D        RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
Thu 26 Feb 2015 15:39:04        2       0000043D            datacent
Thu 26 Feb 2015 15:39:04        2       0000043D        
Thu 26 Feb 2015 15:39:04        2       0000043D        UDA-SQL-0432 Unable to locate the gateway "libcogudaor".
Thu 26 Feb 2015 15:39:04        4       0000043D        End processing 0 records from data source 'RRS'.
Thu 26 Feb 2015 15:39:05        3       0000043D        Transformer exiting - operation failed
Thu 26 Feb 2015 15:39:04        4       0000043D        Timing, READ DATA SOURCE,00:00:02
Thu 26 Feb 2015 15:39:05        4       0000043D        End cube update.
Thu 26 Feb 2015 15:39:05        4       0000043D        Timing, TOTAL TIME (CREATE CUBE),00:00:03
Thu 26 Feb 2015 15:39:05        2       0000043D        (TR3703) The user ID or password is either missing or invalid. Please re-enter the credentials. [->OK]
Thu 26 Feb 2015 15:39:05        3       0000043D        Closing model file /cognos/app/transformer/ibm/cognos/c10/temp/ppd00162.qyj收起
参与21

查看其它 7 个回答kingwang的回答

kingwangkingwang商业智能工程师前景科技有限公司
回复 3# hygzwh

那就找到 cs7g.ini,10以后的版本是这个文件
医药 · 2015-02-26
浏览863

回答者

kingwang
商业智能工程师前景科技有限公司
擅长领域: 商业智能大数据cognos

kingwang 最近回答过的问题

回答状态

  • 发布时间:2015-02-26
  • 关注会员:1 人
  • 回答浏览:863
  • X社区推广