是的,这个日志文件里的警告只有这一句,其他的都是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.
2019-06-15 16:17:55: UEUTIL(ueutil.c:149) [DEBUG]: Initializing User Exit Utils 2019-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.exe2019-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
2019-06-15 16:17:55: FILEWRITER(filewriter.c:1579) [INFO]: Writer dsvwriter: Fixed justify for Meta Column timestamp set to left 2019-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
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.
现在的情况是trail文件已经投递到了目标端了,但是目标端没有生成文本文件?那么问题就出在目标端的extract进程上了,看了它的配置,还有view report看下它的详细信息
EXTRACT ffwriter CUSEREXIT ./flatfilewriter.dll CUSEREXIT PASSTHRU INCLUDEUPDATEBEFORES,PARAMS "./dirprm/ffue.properties"
TABLE ogg.*;
是说少这个配置吗?之前加过,但是报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以上的就不需要配置了,所以就删了
#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
这个好像是从AdapterExamples/file-writer/目录下拷过来没改过的properties文件?默认不改应该是每问题的。要么还是看下report吧,你上面的贴图里,只有开始的一页,往后拉看看有没有什么报错
下面有more,肯定還有更多的~
2019-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.exe2019-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
2019-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
添加ffwriter extract的时候,exttrailsource指定对了吗? 是不是指定为了dirdat/st ?
ADD EXTRACT ffwriter, EXTTRAILSOURCE dirdat\st
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
楼主,这是我自己之前做11g adapter测试时候的步骤,供参考~
楼主,这是我自己之前做11g adapter测试时候的步骤,供参考~
感谢,现在导出csv可以了,然后用java同步时java进程又启动不了了总是提示这个错,您遇到过吗?