在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
收起