oracle oci 允许错误。

初级会员 注册时间: 2008-11-22 09:20:13 文章: 4 离线

Attempting to Cleanup after ABORT raised in stage orc_test..Transformer_2

比较简单的一个表往文本上导出数据，采用ODBC接口没有问题。而采用 oracle oci出现上述错误，是否有什么参数没有设置正确导致？

请帖出详细日志。包括出问题日志前面及后面的日志。

初级会员 注册时间: 2008-11-22 09:20:13 文章: 4 离线

不好意思，初学找不到日志的目录只能截图。

初级会员 注册时间: 2008-11-22 09:20:13 文章: 4 离线

Item #: 31
Event ID: 30
Timestamp: 2010-07-20 22:28:12
Type: Control
User Name: HOMELAND|Administrator
Message: Starting Job test2.
$LIBPATH = I:\oracle\ora92\lib

Item #: 32
Event ID: 31
Timestamp: 2010-07-20 22:28:12
Type: Info
User Name: HOMELAND|Administrator
Message: Environment variable settings:
ALLUSERSPROFILE=C:\Documents and Settings\All Users
BELL=^G
ClusterLog=C:\WINDOWS\Cluster\cluster.log
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=HOMELAND
ComSpec=C:\WINDOWS\system32\cmd.exe
DSPackagePath=e:\Ascential\DataStage\Package
DS_ENABLE_RESERVED_CHAR_CONVERT=0
DS_TDM_PIPE_OPEN_TIMEOUT=720
DS_TDM_TRACE_SUBROUTINE_CALLS=0
FLAVOR=-1
FP_NO_HOST_CHECK=NO
JSERV=i:\oracle\ora92/Apache/Jserv/conf
LIBPATH=I:\oracle\ora92\lib
NUMBER_OF_PROCESSORS=1
OS=Windows_NT
Path=i:\oracle\ora92\jre\1.4.2\bin\client;i:\oracle\ora92\jre\1.4.2\bin;i:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Common Files\Thunder Network\KanKan\Codecs;E:\Program Files\pb9\Shared\PowerBuilder;H:\Program Files\Sybase\Shared;
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PE_HOME=e:\PROGRA~1\Mercury\LOADRU~1
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 13 Stepping 8, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0d08
ProgramFiles=C:\Program Files
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=z:\TEMP
TMP=z:\TEMP
UNIVERSE_CONTROLLING_TERM=1
UNIVERSE_PARENT_PROCESS=3332
USER=HOMELAND\Administrator
USERPROFILE=C:\Documents and Settings\Default User
WHO=home
windir=C:\WINDOWS
WV_GATEWAY_CFG=i:\oracle\ora92\Apache\modplsql\cfg\wdbsvr.app
TERM=console
DS_USERNO=-3500

Item #: 33
Event ID: 32
Timestamp: 2010-07-20 22:28:12
Type: Info
User Name: HOMELAND|Administrator
Message: test2: Set NLS locale to CN-CHINESE,CN-CHINESE,CN-CHINESE,CN-CHINESE,CN-CHINESE

Item #: 34
Event ID: 33
Timestamp: 2010-07-20 22:28:13
Type: Info
User Name: HOMELAND|Administrator
Message: test2..Sequential_File_1.IDENT1: DSD.StageRun Active stage starting, tracemode = 0.

Item #: 35
Event ID: 34
Timestamp: 2010-07-20 22:28:13
Type: Info
User Name: HOMELAND|Administrator
Message: test2..Sequential_File_1.IDENT1: Set NLS locale to CN-CHINESE,CN-CHINESE,CN-CHINESE,CN-CHINESE,CN-CHINESE

Item #: 36
Event ID: 35
Timestamp: 2010-07-20 22:28:13
Type: Info
User Name: HOMELAND|Administrator
Message: test2..Oracle_OCI_0: Using NLS map MS936

Item #: 37
Event ID: 36
Timestamp: 2010-07-20 22:28:13
Type: Info
User Name: HOMELAND|Administrator
Message: test2..Oracle_OCI_0: SELECT

AC_ENTITY.ENTITYID,

AC_ENTITY.APPID,

AC_ENTITY.ENTITYNAME,

AC_ENTITY.TABLENAME,

AC_ENTITY.ENTITYDESC,

AC_ENTITY.DISPLAYORDER,

AC_ENTITY.ENTITYTYPE,

AC_ENTITY.ISADD,

AC_ENTITY.ISDEL,

AC_ENTITY.ISMODIFY,

AC_ENTITY.ISVIEW,

AC_ENTITY.ISPAGE,

AC_ENTITY.PAGELEN,

AC_ENTITY.CHECK_REF

FROM

EOSAPP.AC_ENTITY AC_ENTITY

Item #: 38
Event ID: 37
Timestamp: 2010-07-20 22:28:13
Type: Info
User Name: HOMELAND|Administrator
Message: test2..Sequential_File_1: Using project default NLS map MS936

Item #: 39
Event ID: 38
Timestamp: 2010-07-20 22:28:13
Type: Warning
User Name: HOMELAND|Administrator
Message: Attempting to Cleanup after ABORT raised in stage test2..Sequential_File_1.IDENT1

Item #: 40
Event ID: 39
Timestamp: 2010-07-20 22:28:19
Type: Control
User Name: HOMELAND|Administrator
Message: Job test2 aborted.

server job ？是不是有REAL or FLOAT 类型的数据？

最好用Oracle enterprise stage （或Oracle OCI stage）吧。

初级会员 注册时间: 2008-11-22 09:20:13 文章: 4 离线

用的就是Oracle oci才有问题，用ODBC没有问题。
没有float