1. View report repxxx
MAP resolved (entry user1.table1):
map user1.table1, target user11.table1;
Using following columns in default map by name:
SUB_ID, ORG_MOB_TYPE, ....
Using the following key columns for target table user11.table1: SUB_ID, SEGMENT_ID.
Source Context :
SourceModule : [ggstd.conv.endian]
SourceID : [/home/ecloud/workspace/Build_FBO_OpenSys_r11.1.1.0.0_078_[34085]/perforce/src/gglib/ggstd/lecnv.c]
SourceFunction : [convCompSQL]
SourceLine : [589]
2011-10-27 15:05:23 ERROR OGG-01163 Bad column length (4) specified for column MOB_TYPE in table user1.table1, maximum allowable length is 3.
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
Reading /u03/gg/dirdat/p1001633, current RBA 118046018, 270 records
2. View record error
2.1. Vào logdump
bash-3.00$ logdump
Oracle GoldenGate Log File Dump Utility
Version 11.1.1.0.0 Build 078
Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.
2.2. Mở file trail (lấy tham số từ report)
Logdump 33 >open /u03/gg/dirdat/p1001633
Current LogTrail is /u03/gg/dirdat/p1001633
2.3. Tìm đến vị trí bản ghi
Logdump 35 >pos 118046018
Reading forward from RBA 118046018
Logdump 36 >detail on
Logdump 37 >n
2011/10/25 03:24:09.066.039 FieldComp Len 112 RBA 118046018
Name: user1.table1
After Image: Partition 4 G m
0000 000a 0000 0000 0000 045f e210 0002 0008 0000 | ..........._........
0004 4643 5056 0004 0013 0000 000f 3435 3230 3132 | ..FCPV........452012
3130 3235 3030 3030 3200 0800 0a00 0000 0000 0000 | 102500002...........
0000 0100 0900 1500 0032 3031 312d 3031 2d31 383a | .........2011-01-18:
3030 3a30 303a 3030 000e 0006 0000 0002 3030 0010 | 00:00:00........00..
000a 0000 0000 0000 0000 0000 | ............
Column 0 (x0000), Len 10 (x000a)
Column 2 (x0002), Len 8 (x0008)
Column 4 (x0004), Len 19 (x0013)
Column 8 (x0008), Len 10 (x000a)
Column 9 (x0009), Len 21 (x0015)
Column 14 (x000e), Len 6 (x0006)
Column 16 (x0010), Len 10 (x000a)