文章发表人是: xinhao2008

大家好，我建了一个Workflow，实现功能：把数据文件加载入表中。执行后数据不能加载，请高手帮忙，多谢！

日志如下：
Severity Timestamp Node Thread Message Code Message
INFO 2010-8-31 11:05:02 node01_dt-sd-12 DIRECTOR TM_6228 Writing session output to log file [/home/infa85/ECRoot/SessLogs/s_fm_ccy_rate_fil2Tab.log].
INFO 2010-8-31 11:05:02 node01_dt-sd-12 DIRECTOR TM_6014 Initializing session [s_fm_ccy_rate_fil2Tab] at [Tue Aug 31 11:05:02 2010].
INFO 2010-8-31 11:05:02 node01_dt-sd-12 DIRECTOR TM_6683 Repository Name: [ecetlrepprd]
INFO 2010-8-31 11:05:02 node01_dt-sd-12 DIRECTOR TM_6684 Server Name: [ecetlintdev]
INFO 2010-8-31 11:05:02 node01_dt-sd-12 DIRECTOR TM_6686 Folder: [CDB_ECICAAP]
INFO 2010-8-31 11:05:02 node01_dt-sd-12 DIRECTOR TM_6685 Workflow: [WL_fm_ccy_rate_Fil2Tab] Run Instance Name: [] Run Id: [62]
INFO 2010-8-31 11:05:02 node01_dt-sd-12 DIRECTOR TM_6101 Mapping name: fm_ccy_rate_fil2Tab [version CheckedOut]
INFO 2010-8-31 11:05:02 node01_dt-sd-12 DIRECTOR TM_6964 Date format for the Session is [MM/DD/YYYY HH24:MI:SS.US]
INFO 2010-8-31 11:05:02 node01_dt-sd-12 DIRECTOR TM_6703 Session [s_fm_ccy_rate_fil2Tab] is run by 64-bit Integration Service [node01_dt-sd-12], version [8.5.1], build [1207].
INFO 2010-8-31 11:05:02 node01_dt-sd-12 MANAGER PETL_24058 Running Partition Group [1].
INFO 2010-8-31 11:05:02 node01_dt-sd-12 MANAGER PETL_24000 Parallel Pipeline Engine initializing.
INFO 2010-8-31 11:05:02 node01_dt-sd-12 MANAGER PETL_24001 Parallel Pipeline Engine running.
INFO 2010-8-31 11:05:02 node01_dt-sd-12 MANAGER PETL_24003 Initializing session run.
INFO 2010-8-31 11:05:02 node01_dt-sd-12 MAPPING CMN_1569 Server Mode: [UNICODE]
INFO 2010-8-31 11:05:02 node01_dt-sd-12 MAPPING CMN_1570 Server Code page: [MS Windows Simplified Chinese, superset of GB 2312-80, EUC encoding]
INFO 2010-8-31 11:05:02 node01_dt-sd-12 MAPPING TM_6151 Session Sort Order: [Binary]
INFO 2010-8-31 11:05:02 node01_dt-sd-12 MAPPING TM_6156 Using LOW precision decimal arithmetic
INFO 2010-8-31 11:05:02 node01_dt-sd-12 MAPPING TM_6180 Deadlock retry logic will not be implemented.
INFO 2010-8-31 11:05:02 node01_dt-sd-12 MAPPING TM_6307 DTM Error Log Disabled.
INFO 2010-8-31 11:05:02 node01_dt-sd-12 MAPPING TE_7022 TShmWriter: Initialized
INFO 2010-8-31 11:05:02 node01_dt-sd-12 MAPPING TM_6007 DTM initialized successfully for session [s_fm_ccy_rate_fil2Tab]
INFO 2010-8-31 11:05:02 node01_dt-sd-12 DIRECTOR PETL_24033 All DTM Connection Info: [<NONE>].
INFO 2010-8-31 11:05:02 node01_dt-sd-12 MANAGER PETL_24004 PETL_24004 Starting pre-session tasks. : (Tue Aug 31 11:05:02 2010)
INFO 2010-8-31 11:05:02 node01_dt-sd-12 MANAGER PETL_24027 PETL_24027 Pre-session task completed successfully. : (Tue Aug 31 11:05:02 2010)
INFO 2010-8-31 11:05:02 node01_dt-sd-12 DIRECTOR PETL_24006 Starting data movement.
INFO 2010-8-31 11:05:03 node01_dt-sd-12 MAPPING TM_6660 Total Buffer Pool size is 1219648 bytes and Block size is 65536 bytes.
INFO 2010-8-31 11:05:03 node01_dt-sd-12 READER_1_1_1 DBG_21437 Reader: Source is a file-based source.
INFO 2010-8-31 11:05:03 node01_dt-sd-12 READER_1_1_1 FR_3118 source [SQ_fm_ccy_rate] code page: [MS Windows Simplified Chinese, superset of GB 2312-80, EUC encoding]
INFO 2010-8-31 11:05:03 node01_dt-sd-12 READER_1_1_1 FR_3071 Maximum Line sequential buffer length is 1026.
INFO 2010-8-31 11:05:03 node01_dt-sd-12 READER_1_1_1 BLKR_16003 Initialization completed successfully.
INFO 2010-8-31 11:05:03 node01_dt-sd-12 WRITER_1_*_1 WRT_8146 Writer: Target is database [ECICAAP], user [ECUSER], bulk mode [ON]
INFO 2010-8-31 11:05:03 node01_dt-sd-12 WRITER_1_*_1 WRT_8106 Warning! Bulk Mode session - recovery is not guaranteed.
INFO 2010-8-31 11:05:03 node01_dt-sd-12 WRITER_1_*_1 WRT_8221 Target database connection [ECICAAP] code page: [MS Windows Simplified Chinese, superset of GB 2312-80, EUC encoding]
INFO 2010-8-31 11:05:03 node01_dt-sd-12 WRITER_1_*_1 WRT_8124 Target Table FM_CCY_RATE :SQL INSERT statement:
INSERT INTO FM_CCY_RATE(MONEYTYPE,CNRATE,EFFIDATE) VALUES ( ?, ?, ?)
INFO 2010-8-31 11:05:03 node01_dt-sd-12 WRITER_1_*_1 WRT_8124 Target Table FM_CCY_RATE :SQL UPDATE statement:
UPDATE FM_CCY_RATE SET CNRATE = ?, EFFIDATE = ? WHERE MONEYTYPE = ?
INFO 2010-8-31 11:05:03 node01_dt-sd-12 WRITER_1_*_1 WRT_8124 Target Table FM_CCY_RATE :SQL DELETE statement:
DELETE FROM FM_CCY_RATE WHERE MONEYTYPE = ?
INFO 2010-8-31 11:05:03 node01_dt-sd-12 WRITER_1_*_1 WRT_8270 Target connection group #1 consists of target(s) [FM_CCY_RATE]
INFO 2010-8-31 11:05:03 node01_dt-sd-12 WRITER_1_*_1 WRT_8003 Writer initialization complete.
INFO 2010-8-31 11:05:03 node01_dt-sd-12 READER_1_1_1 BLKR_16007 Reader run started.
INFO 2010-8-31 11:05:03 node01_dt-sd-12 READER_1_1_1 DBG_21430 DBG_21430 Reading data from input source file [/home/infa85/ECRoot/SrcFiles/fm_ccy_rate.dat] : (Tue Aug 31 11:05:03 2010)
INFO 2010-8-31 11:05:03 node01_dt-sd-12 WRITER_1_*_1 WRT_8005 Writer run started.
INFO 2010-8-31 11:05:03 node01_dt-sd-12 WRITER_1_*_1 WRT_8158

*****START LOAD SESSION*****

Load Start Time: Tue Aug 31 11:05:03 2010

Target tables:

FM_CCY_RATE

ERROR 2010-8-31 11:05:03 node01_dt-sd-12 READER_1_1_1 FR_3065 Row [1], field [FIELD2]: Invalid number: [CNRATE]. The row will be skipped.
ERROR 2010-8-31 11:05:03 node01_dt-sd-12 READER_1_1_1 FR_3067 Row [1], field [FIELD3]: Invalid date: [EFFIDATE]. The row will be skipped.
ERROR 2010-8-31 11:05:03 node01_dt-sd-12 READER_1_1_1 FR_3067 Row [2], field [FIELD3]: Invalid date: [2010-4-13]. The row will be skipped.
ERROR 2010-8-31 11:05:03 node01_dt-sd-12 READER_1_1_1 FR_3067 Row [3], field [FIELD3]: Invalid date: [2010/4/13]. The row will be skipped.
ERROR 2010-8-31 11:05:03 node01_dt-sd-12 READER_1_1_1 FR_3067 Row [4], field [FIELD3]: Invalid date: [2010-4-13]. The row will be skipped.
ERROR 2010-8-31 11:05:03 node01_dt-sd-12 READER_1_1_1 FR_3067 Row [5], field [FIELD3]: Invalid date: [20100413]. The row will be skipped.
INFO 2010-8-31 11:05:03 node01_dt-sd-12 READER_1_1_1 BLKR_16019 Read [0] rows, read [5] error rows for source table [fm_ccy_rate] instance name [fm_ccy_rate]
INFO 2010-8-31 11:05:03 node01_dt-sd-12 READER_1_1_1 BLKR_16008 Reader run completed.
ERROR 2010-8-31 11:05:03 node01_dt-sd-12 TRANSF_1_1_1 DBG_21090 SQ_fm_ccy_rate: Data overflow/conversion error for [FIELD2]
INFO 2010-8-31 11:05:03 node01_dt-sd-12 TRANSF_1_1_1 CMN_1053 : Rowdata: ( RowType=-4(error) Src Rowid=1 Targ Rowid=1
FIELD1 (MONEYTYPE:UniChar.3:): "(NULL)"
FIELD2 (CNRATE:Double:): "(NULL)"
FIELD3 (EFFIDATE:Date:): "(NULL)"
)

ERROR 2010-8-31 11:05:03 node01_dt-sd-12 TRANSF_1_1_1 DBG_21090 SQ_fm_ccy_rate: Data overflow/conversion error for [FIELD3]
INFO 2010-8-31 11:05:03 node01_dt-sd-12 TRANSF_1_1_1 CMN_1053 : Rowdata: ( RowType=-4(error) Src Rowid=2 Targ Rowid=2
FIELD1 (MONEYTYPE:UniChar.3:): "(NULL)"
FIELD2 (CNRATE:Double:): "(NULL)"
FIELD3 (EFFIDATE:Date:): "(NULL)"
)

ERROR 2010-8-31 11:05:03 node01_dt-sd-12 TRANSF_1_1_1 DBG_21090 SQ_fm_ccy_rate: Data overflow/conversion error for [FIELD3]
INFO 2010-8-31 11:05:03 node01_dt-sd-12 TRANSF_1_1_1 CMN_1053 : Rowdata: ( RowType=-4(error) Src Rowid=3 Targ Rowid=3
FIELD1 (MONEYTYPE:UniChar.3:): "(NULL)"
FIELD2 (CNRATE:Double:): "(NULL)"
FIELD3 (EFFIDATE:Date:): "(NULL)"
)

ERROR 2010-8-31 11:05:03 node01_dt-sd-12 TRANSF_1_1_1 DBG_21090 SQ_fm_ccy_rate: Data overflow/conversion error for [FIELD3]
INFO 2010-8-31 11:05:03 node01_dt-sd-12 TRANSF_1_1_1 CMN_1053 : Rowdata: ( RowType=-4(error) Src Rowid=4 Targ Rowid=4
FIELD1 (MONEYTYPE:UniChar.3:): "(NULL)"
FIELD2 (CNRATE:Double:): "(NULL)"
FIELD3 (EFFIDATE:Date:): "(NULL)"
)

ERROR 2010-8-31 11:05:03 node01_dt-sd-12 TRANSF_1_1_1 DBG_21090 SQ_fm_ccy_rate: Data overflow/conversion error for [FIELD3]
INFO 2010-8-31 11:05:03 node01_dt-sd-12 TRANSF_1_1_1 CMN_1053 : Rowdata: ( RowType=-4(error) Src Rowid=5 Targ Rowid=5
FIELD1 (MONEYTYPE:UniChar.3:): "(NULL)"
FIELD2 (CNRATE:Double:): "(NULL)"
FIELD3 (EFFIDATE:Date:): "(NULL)"
)

INFO 2010-8-31 11:05:03 node01_dt-sd-12 WRITER_1_*_1 WRT_8167 Start loading table [FM_CCY_RATE] at: Tue Aug 31 11:05:03 2010
INFO 2010-8-31 11:05:03 node01_dt-sd-12 WRITER_1_*_1 WRT_8168 End loading table [FM_CCY_RATE] at: Tue Aug 31 11:05:03 2010
INFO 2010-8-31 11:05:03 node01_dt-sd-12 WRITER_1_*_1 WRT_8035 Load complete time: Tue Aug 31 11:05:03 2010

LOAD SUMMARY
============

WRT_8036 Target: FM_CCY_RATE (Instance Name: [FM_CCY_RATE1])
WRT_8044 No data loaded for this target

INFO 2010-8-31 11:05:03 node01_dt-sd-12 WRITER_1_*_1 WRT_8043 *****END LOAD SESSION*****
INFO 2010-8-31 11:05:03 node01_dt-sd-12 WRITER_1_*_1 WRT_8006 Writer run completed.
INFO 2010-8-31 11:05:03 node01_dt-sd-12 MANAGER PETL_24031

***** RUN INFO FOR TGT LOAD ORDER GROUP [1], CONCURRENT SET [1] *****
Thread [READER_1_1_1] created for [the read stage] of partition point [SQ_fm_ccy_rate] has completed. The total run time was insufficient for any meaningful statistics.
Thread [TRANSF_1_1_1] created for [the transformation stage] of partition point [SQ_fm_ccy_rate] has completed. The total run time was insufficient for any meaningful statistics.
Thread [WRITER_1_*_1] created for [the write stage] of partition point [FM_CCY_RATE1] has completed. The total run time was insufficient for any meaningful statistics.

INFO 2010-8-31 11:05:03 node01_dt-sd-12 MANAGER PETL_24005 PETL_24005 Starting post-session tasks. : (Tue Aug 31 11:05:03 2010)
INFO 2010-8-31 11:05:03 node01_dt-sd-12 MANAGER PETL_24029 PETL_24029 Post-session task completed successfully. : (Tue Aug 31 11:05:03 2010)
INFO 2010-8-31 11:05:03 node01_dt-sd-12 MAPPING TM_6018 Session [s_fm_ccy_rate_fil2Tab] run completed with [5] row transformation errors.
INFO 2010-8-31 11:05:03 node01_dt-sd-12 MANAGER PETL_24002 Parallel Pipeline Engine finished.
INFO 2010-8-31 11:05:03 node01_dt-sd-12 DIRECTOR PETL_24012 Session run completed successfully.
INFO 2010-8-31 11:05:03 node01_dt-sd-12 DIRECTOR TM_6022

SESSION LOAD SUMMARY
================================================

INFO 2010-8-31 11:05:03 node01_dt-sd-12 DIRECTOR TM_6252 Source Load Summary.
INFO 2010-8-31 11:05:03 node01_dt-sd-12 DIRECTOR CMN_1740 Table: [SQ_fm_ccy_rate] (Instance Name: [SQ_fm_ccy_rate])
Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [5]
INFO 2010-8-31 11:05:03 node01_dt-sd-12 DIRECTOR TM_6253 Target Load Summary.
INFO 2010-8-31 11:05:03 node01_dt-sd-12 DIRECTOR CMN_1740 Table: [FM_CCY_RATE] (Instance Name: [FM_CCY_RATE1])
Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]
INFO 2010-8-31 11:05:03 node01_dt-sd-12 DIRECTOR TM_6023
===================================================

INFO 2010-8-31 11:05:03 node01_dt-sd-12 DIRECTOR TM_6020 Session [s_fm_ccy_rate_fil2Tab] completed at [Tue Aug 31 11:05:03 2010]

非常感谢!

非常感谢!

very good! thank you very much!

不能进入啊