|
|
How to find a reject number.
09-08-2011
WRT_8036 Target: AAA (Instance Name: [AAA])
WRT_8038 Inserted rows - Requested: 10000 Applied: 10000 Rejected: 0 Affected: 10000
WRITER_1_*_1> WRT_8161
TARGET BASED COMMIT POINT Fri Aug 26 18:19:23 2011
WRT_8036 Target: AAA (Instance Name: [AAA])
WRT_8038 Inserted rows - Requested: 20000 Applied: 20000 Rejected: 1 Affected: 20000
READER_1_1_1> BLKR_16019 Read [23638] rows, read [0] error rows for source table [BBB] instance name [BBB]
READER_1_1_1> BLKR_16008 Reader run completed.
WRITER_1_*_1> WRT_8168 End loading table [AAA] at: Fri Aug 26 18:19:23 2011
WRITER_1_*_1> WRT_8141
Commit on end-of-data Fri Aug 26 18:19:23 2011
WRT_8036 Target: AAA (Instance Name: [AAA])
WRT_8038 Inserted rows - Requested: 23638 Applied: 23638 Rejected: 0 Affected: 23638
WRITER_1_*_1> WRT_8035 Load complete time: Fri Aug 26 18:19:23 2011
LOAD SUMMARY
============
WRT_8036 Target: AAA (Instance Name: [AAA])
WRT_8038 Inserted rows - Requested: 23638 Applied: 23638 Rejected: 0 Affected: 23638
WRITER_1_*_1> WRT_8043 *****END LOAD SESSION*****
WRITER_1_*_1> WRT_8006 Writer run completed.
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_BBB] has completed.
Total Run Time = [4.448632] secs
Total Idle Time = [0.000000] secs
Busy Percentage = [100.000000]
Thread [TRANSF_1_1_1] created for [the transformation stage] of partition point [SQ_BBB] has completed.
Total Run Time = [4.401562] secs
Total Idle Time = [4.118804] secs
Busy Percentage = [6.424027]
Transformation-specific statistics for this thread were not accurate enough to report.
Thread [WRITER_1_*_1] created for [the write stage] of partition point [AAA] has completed.
Total Run Time = [4.422019] secs
Total Idle Time = [2.934487] secs
Busy Percentage = [33.639196]
MANAGER> PETL_24005 Starting post-session tasks. : (Fri Aug 26 18:19:24 2011)
MANAGER> PETL_24029 Post-session task completed successfully. : (Fri Aug 26 18:19:24 2011)
MAPPING> TM_6018 The session completed with [0] row transformation errors.
MANAGER> PETL_24002 Parallel Pipeline Engine finished.
DIRECTOR> PETL_24012 Session run completed successfully.
DIRECTOR> TM_6022
SESSION LOAD SUMMARY
================================================
DIRECTOR> TM_6252 Source Load Summary.
DIRECTOR> CMN_1740 Table: [SQ_BBB] (Instance Name: [SQ_BBB])
Output Rows [23638], Affected Rows [23638], Applied Rows [23638], Rejected Rows [0]
DIRECTOR> TM_6253 Target Load Summary.
DIRECTOR> CMN_1740 Table: [AAA] (Instance Name: [AAA])
Output Rows [23638], Affected Rows [23638], Applied Rows [23638], Rejected Rows [1]
DIRECTOR> TM_6023
===================================================
DIRECTOR> TM_6020 Session [CCC] completed at [Fri Aug 26 18:19:24 2011].
09-08-2011
|
|