源端ogg依此啟動
start mgr
start ext
start pump
啟動pump后，目標端會彈出如下提示框報錯
求高手指點！！！！！！
uj5u.com熱心網友回復：
uj5u.com熱心網友回復：
能看看投遞行程引數嗎uj5u.com熱心網友回復：
pump內容是：
uj5u.com熱心網友回復：
uj5u.com熱心網友回復：
目標端的ggserr.log有沒有什么線索？uj5u.com熱心網友回復：
日志里也沒有什么警告和error，dirbat目錄下可以同步到源上面的那些st000000檔案，但就是dirout目錄下啥都沒有uj5u.com熱心網友回復：
dirout同一級目錄下有個ggserr.loguj5u.com熱心網友回復：
是的，這個日志檔案里的警告只有這一句，其他的都是info資訊2019-06-11T16:54:10.280+0800 WARNING OGG-01880 Oracle GoldenGate Collector: ALLOWOUTPUTDIR D:\V979761-01\ is the same directory where this GoldenGate instance is installed.
uj5u.com熱心網友回復：
現在的現象是看著dirbat下面的那些st開頭的檔案都能正常從源機器上同步過來，但就是在sqlplus里插入表記錄后，在目標機的dirout目錄下還是沒有csv檔案uj5u.com熱心網友回復：
是用了ogg flatfile adapter？
uj5u.com熱心網友回復：
看樓主的現在的說明，看上去是想用adapter把資料庫的資料轉成文本？現在的情況是trail檔案已經投遞到了目標端了，但是目標端沒有生成文本檔案？那么問題就出在目標端的extract行程上了，看了它的配置，還有view report看下它的詳細資訊
uj5u.com熱心網友回復：
這個是目標機extract行程內容：EXTRACT ffwriter
CUSEREXIT ./flatfilewriter.dll CUSEREXIT PASSTHRU INCLUDEUPDATEBEFORES,PARAMS "./dirprm/ffue.properties"
TABLE ogg.*;
uj5u.com熱心網友回復：
uj5u.com熱心網友回復：
少了源端表的定義檔案配置？uj5u.com熱心網友回復：
SOURCEDEFS ./dirdef/ogg.def是說少這個配置嗎？之前加過，但是報2019-06-11T16:24:14.197+0800 WARNING OGG-02761 Oracle GoldenGate Capture, FFWRITER.prm: Source definitions file, ./dirdef/ogg.def, is ignored because trail file D:\V979761-01\dirdat/st000000 contains table definitions.
查了下說是ogg版本在12.2以上的就不需要配置了，所以就刪了。。。
uj5u.com熱心網友回復：
"./dirprm/ffue.properties"這個檔案的配置有檢查過嗎？uj5u.com熱心網友回復：
#------------------------#LOGGING OPTIONS
#------------------------
goldengate.log.logname=ffwriter
goldengate.log.level=DEBUG
goldengate.log.modules=LOGMALLOC
goldengate.log.level.LOGMALLOC=ERROR
goldengate.log.tostdout=false
goldengate.log.tofile=true
#------------------------
#FLAT FILE WRITER OPTIONS
#------------------------
goldengate.flatfilewriter.writers=dsvwriter
goldengate.userexit.chkptprefix=ffwriter_
#------------------------
# dsvwriter options
#------------------------
dsvwriter.mode=DSV
dsvwriter.rawchars=false
dsvwriter.includebefores=false
dsvwriter.includecolnames=true
dsvwriter.omitvalues=false
dsvwriter.diffsonly=false
dsvwriter.omitplaceholders=false
#dsvwriter.files.onepertable=true
dsvwriter.files.prefix=csv
dsvwriter.files.data.rootdir=./dirout
dsvwriter.files.data.ext=_data.dsv
dsvwriter.files.data.tmpext=_data.dsv.temp
dsvwriter.files.data.rollover.time=10
#dsvwriter.files.data.rollover.size=
dsvwriter.files.data.norecords.timeout=10
dsvwriter.files.control.use=true
dsvwriter.files.control.ext=_data.control
dsvwriter.files.control.rootdir=./dirout
dsvwriter.dsv.nullindicator.chars=<NULL>
dsvwriter.dsv.fielddelim.chars=|
dsvwriter.dsv.linedelim.chars=\n
dsvwriter.dsv.quotes.chars="
dsvwriter.dsv.quotes.escaped.chars=""
dsvwriter.metacols=position,txind,opcode,timestamp,schema,table
dsvwriter.metacols.txind.fixedlen=1
dsvwriter.metacols.txind.begin.chars=B
dsvwriter.metacols.txind.middle.chars=M
dsvwriter.metacols.txind.end.chars=E
dsvwriter.files.formatstring=pump_%s_%t_%d_%05n
#------------------------
# ldvwriter options
#------------------------
ldvwriter.mode=LDV
ldvwriter.rawchars=true
ldvwriter.includebefores=false
ldvwriter.includecolnames=false
ldvwriter.files.onepertable=false
ldvwriter.files.data.rootdir=./dirout
ldvwriter.files.data.ext=.data
ldvwriter.files.data.tmpext=.temp
ldvwriter.files.data.rollover.time=10
ldvwriter.files.data.norecords.timeout=10
ldvwriter.files.control.use=true
ldvwriter.files.control.ext=.ctrl
ldvwriter.files.control.rootdir=./dirout
ldvwriter.metacols=position,timestamp,@TOKEN-RBA,@TOKEN-POS,opcode,txind,schema,table
ldvwriter.metacols.TOKEN-RBA.fixedlen=10
ldvwriter.metacols.TOKEN-POS.fixedlen=10
ldvwriter.metacols.timestamp.fixedlen=26
ldvwriter.metacols.schema.fixedjustify=right
ldvwriter.metacols.schema.fixedpadchar.chars=Y
ldvwriter.metacols.opcode.fixedlen=1
ldvwriter.metacols.opcode.insert.chars=I
ldvwriter.metacols.opcode.update.chars=U
ldvwriter.metacols.opcode.delete.chars=D
ldvwriter.metacols.txind.fixedlen=1
ldvwriter.metacols.txind.begin.chars=B
ldvwriter.metacols.txind.middle.chars=M
ldvwriter.metacols.txind.end.chars=E
ldvwriter.metacols.txind.whole.chars=W
ldvwriter.ldv.vals.missing.chars=M
ldvwriter.ldv.vals.present.chars=P
ldvwriter.ldv.vals.null.chars=N
ldvwriter.ldv.lengths.record.mode=binary
ldvwriter.ldv.lengths.record.length=4
ldvwriter.ldv.lengths.field.mode=binary
ldvwriter.ldv.lengths.field.length=2
ldvwriter.files.rolloveronshutdown=false
ldvwriter.statistics.toreportfile=false
ldvwriter.statistics.period=onrollover
ldvwriter.statistics.tosummaryfile=true
ldvwriter.statistics.overall=true
ldvwriter.statistics.summary.fileformat=schema,table,schemaandtable,total,gctimestamp,ctimestamp
ldvwriter.statistics.summary.delimiter.chars=|
ldvwriter.statistics.summary.eol.chars=\n
ldvwriter.metacols.position.format=dec
ldvwriter.writebuffer.size=36863
uj5u.com熱心網友回復：
檢查了下沒看出什么問題
uj5u.com熱心網友回復：
這個好像是從AdapterExamples/file-writer/目錄下拷過來沒改過的properties檔案？默認不改應該是每問題的。
要么還是看下report吧，你上面的貼圖里，只有開始的一頁，往后拉看看有沒有什么報錯
uj5u.com熱心網友回復：
uj5u.com熱心網友回復：
看著好像一共這么多內容吧uj5u.com熱心網友回復：
下面有more，肯定還有更多的～
uj5u.com熱心網友回復：
uj5u.com熱心網友回復：
2019-06-15 16:17:55: UEUTIL(ueutil.c:149) [DEBUG]: Initializing User Exit Utils2019-06-15 16:17:55: UEUTIL(ueutil.c:108) [DEBUG]: Opening callback for: D:\V979761-01\extract.exe : ERCALLBACK
2019-06-15 16:17:55: FFUSEREXIT(flatfileuserexit.c:172) [INFO]:
***********************************************************************
Started Oracle GoldenGate Adapter for Flat Files
12.2.0.1.2 *** NOT FOR DISTRIBUTION ***
***********************************************************************
2019-06-15 16:17:55: UEUTIL(ueutil.c:191) [DEBUG]: Calling callback 25
2019-06-15 16:17:55: UEUTIL(ueutil.c:210) [DEBUG]: Callback completed with result code: 0
2019-06-15 16:17:55: FFUSEREXIT(flatfileuserexit.c:199) [DEBUG]: User exit: EXIT_CALL_START. Called from program: D:\V979761-01\extract.exe
2019-06-15 16:17:55: FFUSEREXIT(flatfileuserexit.c:202) [INFO]: Initializing the following writers: dsvwriter
2019-06-15 16:17:55: FFUSEREXIT(flatfileuserexit.c:221) [INFO]: Found 1 writers
2019-06-15 16:17:55: FFUSEREXIT(flatfileuserexit.c:226) [INFO]: Initializing writer: dsvwriter
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1765) [INFO]: Initializing File Writer: dsvwriter
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1783) [INFO]: NO TEMPLATE
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1807) [INFO]: Writer dsvwriter: Writer type is dsv
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1814) [INFO]: Writer dsvwriter: Data directory is ./dirout
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1834) [INFO]: Writer dsvwriter: Final data directory is ./dirout\
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1846) [INFO]: Writer dsvwriter: Rolled data file extension _data.dsv
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1857) [INFO]: Writer dsvwriter: Temp data file extension _data.dsv.temp
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1866) [INFO]: Writer dsvwriter: Data File BOM not used
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1878) [INFO]: Writer dsvwriter: Control file will be used
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1886) [INFO]: Writer dsvwriter: Control directory is ./dirout
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1906) [INFO]: Writer dsvwriter: Final Control directory is ./dirout\
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1917) [INFO]: Writer dsvwriter: Control file extension _data.control
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1924) [INFO]: Writer: dsvwriter Control Delimiter - , len 1
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1931) [INFO]: Writer: dsvwriter Control Eol -
len 2
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1962) [INFO]: Property dsvwriter.files.data.rollover.timetype is not specified, defaulting to System
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1996) [INFO]: Writer dsvwriter: Files will rollover after 10 seconds
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2018) [INFO]: Writer dsvwriter: Files will rollover after 10 seconds if no records
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2029) [INFO]: Writer dsvwriter: Before Images will not be captured
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2040) [INFO]: Writer dsvwriter: Column names will be output
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2053) [INFO]: Writer dsvwriter: All column values will be output
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2064) [INFO]: Writer dsvwriter: Place holders for missing columns will be output
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2075) [INFO]: Writer dsvwriter: Column values will be output
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2079) [WARN]: Setting for dsvwriter.rawchars is ignored, this property is deprecated.
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2084) [INFO]: Writer dsvwriter: Character data be captured as ascii
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2089) [INFO]: Property dsvwriter.files.onepertable is not specified, defaulting to true
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2096) [INFO]: Writer dsvwriter: Will output one file per table
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2101) [INFO]: Property dsvwriter.files.oneperopcode is not specified, defaulting to false
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2108) [INFO]: Writer dsvwriter: Will output all opcodes in one file
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2126) [INFO]: Property dsvwriter.groupcols is not specified, defaulting to false
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2132) [INFO]: Property dsvwriter.groupcols is set to false
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2137) [INFO]: Property dsvwriter.afterfirst is not specified, defaulting to false
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2143) [INFO]: Property dsvwriter.afterfirst is set to false
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1408) [INFO]: Num Meta Cols: 0
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1496) [INFO]: Writer dsvwriter: Meta Column 0 set to position
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1516) [DEBUG]: Writer dsvwriter: Getting property dsvwriter.metacols.position.column
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1533) [DEBUG]: Writer dsvwriter: Getting property dsvwriter.metacols.position.fixedlen 0000000000D3E120 0000000000000000
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1536) [DEBUG]: Writer dsvwriter: Got property dsvwriter.metacols.position.fixedlen 0000000000D3E120 0000000000000000
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1537) [DEBUG]: Got property: dsvwriter.metacols.position.fixedlen - NULL
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1548) [INFO]: Writer dsvwriter: Meta Column position has a variable length value
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1559) [INFO]: Writer dsvwriter: If Meta Column position not found value is: [NO VALUE]
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1567) [INFO]: Writer: dsvwriter Fixed padchar for Meta Column position - len 1
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1579) [INFO]: Writer dsvwriter: Fixed justify for Meta Column position set to left
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1591) [INFO]: Writer dsvwriter: Omit for Meta Column position set on
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1408) [INFO]: Num Meta Cols: 1
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1496) [INFO]: Writer dsvwriter: Meta Column 1 set to txind
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1516) [DEBUG]: Writer dsvwriter: Getting property dsvwriter.metacols.txind.column
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1533) [DEBUG]: Writer dsvwriter: Getting property dsvwriter.metacols.txind.fixedlen 0000000000D3E120 0000000000000000
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1536) [DEBUG]: Writer dsvwriter: Got property dsvwriter.metacols.txind.fixedlen 0000000000D3E120 00000000048B9800
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1537) [DEBUG]: Got property: dsvwriter.metacols.txind.fixedlen - 1
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1548) [INFO]: Writer dsvwriter: Meta Column txind has a fixed length value of 1
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1559) [INFO]: Writer dsvwriter: If Meta Column txind not found value is: [NO VALUE]
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1567) [INFO]: Writer: dsvwriter Fixed padchar for Meta Column txind - len 1
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1579) [INFO]: Writer dsvwriter: Fixed justify for Meta Column txind set to left
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1591) [INFO]: Writer dsvwriter: Omit for Meta Column txind set on
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1408) [INFO]: Num Meta Cols: 2
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1496) [INFO]: Writer dsvwriter: Meta Column 2 set to opcode
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1516) [DEBUG]: Writer dsvwriter: Getting property dsvwriter.metacols.opcode.column
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1533) [DEBUG]: Writer dsvwriter: Getting property dsvwriter.metacols.opcode.fixedlen 0000000000D3E120 0000000000000000
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1536) [DEBUG]: Writer dsvwriter: Got property dsvwriter.metacols.opcode.fixedlen 0000000000D3E120 0000000000000000
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1537) [DEBUG]: Got property: dsvwriter.metacols.opcode.fixedlen - NULL
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1548) [INFO]: Writer dsvwriter: Meta Column opcode has a variable length value
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1559) [INFO]: Writer dsvwriter: If Meta Column opcode not found value is: [NO VALUE]
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1567) [INFO]: Writer: dsvwriter Fixed padchar for Meta Column opcode - len 1
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1579) [INFO]: Writer dsvwriter: Fixed justify for Meta Column opcode set to left
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1591) [INFO]: Writer dsvwriter: Omit for Meta Column opcode set on
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1408) [INFO]: Num Meta Cols: 3
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1496) [INFO]: Writer dsvwriter: Meta Column 3 set to timestamp
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1516) [DEBUG]: Writer dsvwriter: Getting property dsvwriter.metacols.timestamp.column
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1533) [DEBUG]: Writer dsvwriter: Getting property dsvwriter.metacols.timestamp.fixedlen 0000000000D3E120 0000000000000000
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1536) [DEBUG]: Writer dsvwriter: Got property dsvwriter.metacols.timestamp.fixedlen 0000000000D3E120 0000000000000000
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1537) [DEBUG]: Got property: dsvwriter.metacols.timestamp.fixedlen - NULL
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1548) [INFO]: Writer dsvwriter: Meta Column timestamp has a variable length value
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1559) [INFO]: Writer dsvwriter: If Meta Column timestamp not found value is: [NO VALUE]
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1567) [INFO]: Writer: dsvwriter Fixed padchar for Meta Column timestamp - len 1
uj5u.com熱心網友回復：
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1579) [INFO]: Writer dsvwriter: Fixed justify for Meta Column timestamp set to left2019-06-15 16:17:55: FILEWRITER(filewriter.c:1591) [INFO]: Writer dsvwriter: Omit for Meta Column timestamp set on
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1408) [INFO]: Num Meta Cols: 4
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1496) [INFO]: Writer dsvwriter: Meta Column 4 set to schema
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1516) [DEBUG]: Writer dsvwriter: Getting property dsvwriter.metacols.schema.column
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1533) [DEBUG]: Writer dsvwriter: Getting property dsvwriter.metacols.schema.fixedlen 0000000000D3E120 0000000000000000
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1536) [DEBUG]: Writer dsvwriter: Got property dsvwriter.metacols.schema.fixedlen 0000000000D3E120 0000000000000000
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1537) [DEBUG]: Got property: dsvwriter.metacols.schema.fixedlen - NULL
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1548) [INFO]: Writer dsvwriter: Meta Column schema has a variable length value
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1559) [INFO]: Writer dsvwriter: If Meta Column schema not found value is: [NO VALUE]
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1567) [INFO]: Writer: dsvwriter Fixed padchar for Meta Column schema - len 1
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1579) [INFO]: Writer dsvwriter: Fixed justify for Meta Column schema set to left
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1591) [INFO]: Writer dsvwriter: Omit for Meta Column schema set on
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1408) [INFO]: Num Meta Cols: 5
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1496) [INFO]: Writer dsvwriter: Meta Column 5 set to table
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1516) [DEBUG]: Writer dsvwriter: Getting property dsvwriter.metacols.table.column
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1533) [DEBUG]: Writer dsvwriter: Getting property dsvwriter.metacols.table.fixedlen 0000000000D3E120 0000000000000000
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1536) [DEBUG]: Writer dsvwriter: Got property dsvwriter.metacols.table.fixedlen 0000000000D3E120 0000000000000000
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1537) [DEBUG]: Got property: dsvwriter.metacols.table.fixedlen - NULL
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1548) [INFO]: Writer dsvwriter: Meta Column table has a variable length value
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1559) [INFO]: Writer dsvwriter: If Meta Column table not found value is: [NO VALUE]
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1567) [INFO]: Writer: dsvwriter Fixed padchar for Meta Column table - len 1
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1579) [INFO]: Writer dsvwriter: Fixed justify for Meta Column table set to left
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1591) [INFO]: Writer dsvwriter: Omit for Meta Column table set on
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2161) [INFO]: Writer: dsvwriter Insert Indicator - I len 1
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2168) [INFO]: Writer: dsvwriter Update Indicator - U len 1
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2175) [INFO]: Writer: dsvwriter PK Update Indicator - K len 1
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2182) [INFO]: Writer: dsvwriter Delete Indicator - D len 1
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2189) [INFO]: Writer: dsvwriter TX Begin Indicator - B len 1
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2196) [INFO]: Writer: dsvwriter TX Middle Indicator - M len 1
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2203) [INFO]: Writer: dsvwriter TX End Indicator - E len 1
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2210) [INFO]: Writer: dsvwriter TX Whole Indicator - 3 len 1
2019-06-15 16:17:55: CSVFILEWRITER(csvfilewriter.c:52) [INFO]: Initializing CSV Writer: dsvwriter
2019-06-15 16:17:55: CSVFILEWRITER(csvfilewriter.c:61) [INFO]: CSV Writer: dsvwriter Null Indicator - <NULL> len 6
2019-06-15 16:17:55: CSVFILEWRITER(csvfilewriter.c:68) [INFO]: CSV Writer: dsvwriter Field Delimiter - | len 1
2019-06-15 16:17:55: CSVFILEWRITER(csvfilewriter.c:75) [INFO]: CSV Writer: dsvwriter Line Delimiter -
len 1
2019-06-15 16:17:55: CSVFILEWRITER(csvfilewriter.c:82) [INFO]: CSV Writer: dsvwriter Quote Char - " len 1
2019-06-15 16:17:55: CSVFILEWRITER(csvfilewriter.c:118) [INFO]: CSV Writer: dsvwriter Escaped Quote Char - "" len 2
2019-06-15 16:17:55: CSVFILEWRITER(csvfilewriter.c:123) [INFO]: Property dsvwriter.dsv.onecolperline is not specified, defaulting to false
2019-06-15 16:17:55: CSVFILEWRITER(csvfilewriter.c:130) [INFO]: Writer dsvwriter: Will output all columns on one line
2019-06-15 16:17:55: CSVFILEWRITER(csvfilewriter.c:134) [INFO]: Property dsvwriter.dsv.quotealways is not specified, defaulting to false
2019-06-15 16:17:55: FILEWRITER(filewriter.c:315) [DEBUG]: GET CURRENT TIME
2019-06-15 16:17:55: FILEWRITER(filewriter.c:320) [DEBUG]: END CURRENT TIME
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2239) [INFO]: Property dsvwriter.statistics.toreportfile is not specified, defaulting to false
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2248) [INFO]: Property dsvwriter.statistics.period is not specified, defaulting to onrollover
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2268) [INFO]: Property dsvwriter.statistics.time is not specified, defaulting to 60 secs
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2278) [INFO]: Property dsvwriter.statistics.overall is not specified, defaulting to false
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2286) [INFO]: Property dsvwriter.statistics.tosummaryfile is not specified, defaulting to false
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2293) [INFO]: Writer dsvwriter: Summary will not be output to stats file
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2358) [INFO]: Property dsvwriter.files.rolloveronshutdown is not specified, defaulting to false
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2363) [INFO]: Rollover on shutdown is: 0
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2367) [INFO]: Property dsvwriter.metacols.position.format is not specified, defaulting to hex
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2387) [INFO]: Using hex Position Format
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1258) [DEBUG]: Parsing format string pump_%s_%t_%d_%05n
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1262) [DEBUG]: Analysing char p [112]
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1262) [DEBUG]: Analysing char u [117]
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1262) [DEBUG]: Analysing char m [109]
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1262) [DEBUG]: Analysing char p [112]
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1262) [DEBUG]: Analysing char _ [95]
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1262) [DEBUG]: Analysing char % [37]
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1265) [DEBUG]: Found format string
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1274) [DEBUG]: Precision is
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1294) [DEBUG]: Found schema formatter
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1262) [DEBUG]: Analysing char s [115]
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1262) [DEBUG]: Analysing char _ [95]
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1262) [DEBUG]: Analysing char % [37]
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1265) [DEBUG]: Found format string
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1274) [DEBUG]: Precision is
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1306) [DEBUG]: Found table formatter
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1262) [DEBUG]: Analysing char s [115]
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1262) [DEBUG]: Analysing char _ [95]
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1262) [DEBUG]: Analysing char % [37]
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1265) [DEBUG]: Found format string
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1274) [DEBUG]: Precision is
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1328) [DEBUG]: Found datetime formatter
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1262) [DEBUG]: Analysing char s [115]
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1262) [DEBUG]: Analysing char _ [95]
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1262) [DEBUG]: Analysing char % [37]
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1265) [DEBUG]: Found format string
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1268) [DEBUG]: Saving precision value 0 [48}
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1268) [DEBUG]: Saving precision value 5 [53}
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1274) [DEBUG]: Precision is 05
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1320) [DEBUG]: Found sequence formatter
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1262) [DEBUG]: Analysing char s [115]
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1376) [DEBUG]: Display elem: 0 = 1, prec=
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1377) [DEBUG]: Display elem: 1 = 2, prec=
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1378) [DEBUG]: Display elem: 2 = 4, prec=
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1379) [DEBUG]: Display elem: 3 = 3, prec=
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1380) [DEBUG]: Display elem: 4 = 0, prec=
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1381) [DEBUG]: Display elem: 5 = 0, prec=
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1382) [DEBUG]: Display elem: 6 = 0, prec=
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1385) [DEBUG]: NUM ELEM: 4
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1388) [DEBUG]: FORMAT STRING: pump_%s_%s_%s_%05s
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2402) [INFO]: Property dsvwriter.files.formatstring set to pump_%s_%t_%d_%05n
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2408) [INFO]: Property dsvwriter.writebuffer.size is not specified, defaulting to 8k
2019-06-15 16:17:55: FILEWRITER(filewriter.c:2420) [INFO]: Property dsvwriter.files.rollover.multiple is not specified, defaulting to FALSE
uj5u.com熱心網友回復：
看這report也沒報錯，這就奇怪了……添加ffwriter extract的時候，exttrailsource指定對了嗎？ 是不是指定為了dirdat/st ？
uj5u.com熱心網友回復：
有什么方法能查看下這個是不是指定對了嗎uj5u.com熱心網友回復：
info命令
uj5u.com熱心網友回復：
uj5u.com熱心網友回復：
uj5u.com熱心網友回復：
這個exttrail source的目錄看著有點問題，“\”和“/”混用，不確定是否會造成trail檔案解讀不能，要么重建下extract試試？ADD EXTRACT ffwriter, EXTTRAILSOURCE dirdat\st
uj5u.com熱心網友回復：
參考這個看看。https://www.waitig.com/oggadapters%E5%AE%89%E8%A3%85%E9%83%A8%E7%BD%B2%E9%85%8D%E7%BD%AE%E6%96%87%E6%A1%A3.html
uj5u.com熱心網友回復：
源端和目標端用的ogg版本必須要一樣嗎？uj5u.com熱心網友回復：
一樣自然是最好的……
uj5u.com熱心網友回復：
發現個問題，就是用plsql插入資料后，源端和目標的行程日志都未發生任何變化。正常情況應該是每次更新資料后，日志中都會重新讀寫抽取資料給目標端吧？uj5u.com熱心網友回復：
沒有commit？提交的情況下，通常是很快就會同步資料的
uj5u.com熱心網友回復：
樓主，這是我自己之前做11g adapter測驗時候的步驟，供參考～
uj5u.com熱心網友回復：
感謝，現在匯出csv可以了，然后用java同步時java行程又啟動不了了。。。總是提示這個錯，您遇到過嗎？
uj5u.com熱心網友回復：
java我不熟嘞，不過看著像是LD_LIBRARY_PATH變數沒配置好的關系，或者可以缺少oracle db軟體里的包含的庫uj5u.com熱心網友回復：
這個LD_LIBRARY_PATH的變數是在哪里配呢？也沒說缺少哪個dll，所以也找不出來是到底少什么東西了。。。
uj5u.com熱心網友回復：
那個是環境變數
uj5u.com熱心網友回復：
樓主是怎么解決的 可以說一下嗎
我現在也遇到這個問題了
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/19554.html
標籤：基礎和管理