今天发现个LOADER很奇怪的问题

这篇文章被编辑了 3 次. 最近一次更新是在 2008-05-14 05:43:52

直接正题:
源和目标 Sybase IQ
系统 AIX
问题是
使用的是Sybase_IQ_External_Loader这种方式装载数据
部分SESSION正常部分却失败

详细见我的附件

失败的报:

WRT_8027 : Started [dbisqlc] external loader process [258068] in [Staged] mode for target [ODS_TS_RECORDDETAIL]
WRT_8168 : End loading table [ODS_TS_RECORDDETAIL] at: Wed May 14 19:23:40 2008
WRT_8027 : Started [dbisqlc] external loader process [168344] in [Staged] mode for target [ODS_TS_ORDERFORM]
WRT_8168 : End loading table [ODS_TS_ORDERFORM] at: Wed May 14 19:23:40 2008
WRT_8047 : Error: External loader process [168344] exited with error [1]
WRT_8047 : Error: External loader process [258068] exited with error [1]
WRT_8088 : Writer run terminated. [External loader error.]
WRT_8035 : Load complete time: Wed May 14 19:23:40 2008

然后找到对应的OUT CTL等文件

SET TEMPORARY OPTION ON_ERROR=EXIT;
SET TEMPORARY OPTION ISQL_LOG='/tmp/sybasedata/ods_ts_orderform1.out.ldrlog';
SET TEMPORARY OPTION DATE_ORDER='MDY';
LOAD TABLE ODS_TS_ORDERFORM
(
ORDER_ID ASCII( 10) NULL('* ') ,
ORDSTATUS_ID ASCII( 10) NULL('* ') ,
COMPANY_ID ASCII( 10) NULL('* ') ,
TSADMIN_ID ASCII( 10) NULL('* ') ,
DAY_DATE ASCII( 19) NULL('* ') ,
BALANCETYPE_ID ASCII( 10) NULL('* ') ,
CUST_ID ASCII( 10) NULL('* ') ,
ORDERTYPE_ID ASCII( 10) NULL('* ') ,
ORDERSRC_NUM ASCII( 32) NULL('* ') ,
INPUT_DATE ASCII( 19) NULL('* ') ,
IS_SALED ASCII( 1) NULL('*') ,
IS_INUSE ASCII( 1) NULL('*') ,
FILLER(1))
FROM '/tmp/sybasedata/ods_ts_orderform1.out'
WITH CHECKPOINT ON
BLOCK FACTOR 10000
NOTIFY 1000
ESCAPES OFF
QUOTES OFF
ON FILE ERROR ROLLBACK
/* End of generated Control File */

对应LOADER的日记是:

// Error: Error in file "/sybasedata/ods_ts_orderform1.out.ctl" at line 11
// File does not exist. File: /tmp/sybasedata/ods_ts_orderform1.out
-- (hos_ion.cxx 182)
//
// ( /sybasedata/ods_ts_orderform1.out.ctl )

奇怪的地方就在// File does not exist.?
明明存在的啊

怀疑路径不对也不可能的啊其余成功的SESSION生成的文件都在同一个FLODER啊

用户权限不对也不可能啊 LAODER都用的同一个啊

所有设置都一样的结果有的报错了

在WIN下是都成功的
只是在AIX下出现的很是奇怪

因为ods_ts_orderform1.out 这个文件没有被写到/sybasedata/目录下，而是被写到了 %INFORMATICA%\Server\TgtFiles 目录下了。

打开Workflow Manager, 选择 Connection -> Loader -> Sybase IQ External Loader -> <loadername> -> Edit
确认 Server Datafile Directory 和 Informatica Server target 目录一致。

这篇文章被编辑了 1 次. 最近一次更新是在 2008-05-14 20:45:54

．．．
由于ＩＱ和ＩＮＦＡ在不同的机器上
映射的磁盘被修改了　导致出错
那些有些成功的是因为以前就存在的历史．out文件
初步估计是这个问题

请参考：http://www.mydwbi.com/posts/list/113.page

Test Note 7: Bulk Loader workflows fail
Attempting to run a Bulk Loader workflow within Informatica fails to complete successfully and data is not loaded into IQ. The session log reports the following errors:
READER_1_1_1> BLKR_16008 Reader run completed.
WRITER_1_*_1> WRT_8167 Start loading table [test1target] at: Wed Sep 15 15:22:09 2004
WRITER_1_*_1> WRT_8027 Started [dbisql] external loader process [936] in [Staged] mode for target [test1target]
WRITER_1_*_1> WRT_8168 End loading table [test1target] at: Wed Sep 15 15:22:09 2004
WRITER_1_*_1> Wed Sep 15 15:22:19 2004
WRITER_1_*_1> WRT_8047 Error: External loader process [936] exited with error [5]
WRITER_1_*_1> Wed Sep 15 15:22:20 2004
WRITER_1_*_1> WRT_8088 Writer run terminated. [External loader error.]
WRITER_1_*_1> WRT_8035 Load complete time: Wed Sep 15 15:22:20 2004
The IQ log (asiqdemo.iqmsg) reports the following errors:
I. 09/15 15:22:18. 0000003177 Insert Started:
I. 09/15 15:22:18. 0000003177 test1target
I. 09/15 15:22:18. 0000003177 Exception Thrown from hos_ion.cxx:182, Err# 4, tid 128 origtid 128
I. 09/15 15:22:18. 0000003177 O/S Err#: 2, ErrID: 522 (hos_ioexception); SQLCode: -1006133, SQLState: 'QBB33', Severity: 14
I. 09/15 15:22:18. 0000003177 [20371]: File does not exist. File: D:\Sybase\ASIQ-12_6\win32\test1target1.out
-- (hos_ion.cxx 182)
I. 09/15 15:22:18. 0000003177 Cmt 1927
In the above case, the test1target1.out file is not being written to the above directory (D:\Sybase\ASIQ-12_6\win32\test1target1.out), but is being written to the %INFORMATICA%\Server\TgtFiles directory (where %INFORMATICA% represents the directory in which the Informatica software was installed).
Workaround: Launch the Workflow Manager, select Connection -> Loader -> Sybase IQ External Loader -> <loadername> -> Edit and verify that the Server Datafile Directory is defined as the Informatica Server target directory (ex: D:\Informatica PowerCenter 7.1\Server\TgtFiles). While this resolves the problem for Sybase IQ External Loader connections running on the same operating systems, in this case Windows, it does not resolve the problem for cross-platform loads. See Issue 2 for more information about problems using Sybase IQ External Loader connections across platforms.

谢谢回答~~
已经解决
就是因为磁盘映射改掉了因为有3台机器所以有点乱掉了之间的关系
这个得注意的