Each node can contain a log output. Such as: the rows of error, the wrong field names, as well as problems with wrong ...
-
Each node has the success or failure of the implementation of the time, so every node should be exporting its implementation of the state, such as the first few lines records, success or failure, why. If fault can be defined through this log for errors .
The output of each node is the log message should log with a unified format. Output but these should not be exported through the port log output, but should have a switch can be configured to choose whether or not to have this function. -
Log output formats:
rowId decimal(19,0) -- Rows of
nodeName varchar2(100) -- Node Type Name
outPortNumber varchar2(10) -- output Port Number
runStatus varchar2(50) -- run Status [succeed|failed]
outputMessage varchar2(200) -- Output Information
startTime varchar2(50) -- Starting time task
endTime varchar2(50) -- The termination of the mandate of time
runTime varchar2(50) --After a total mandate the use of the time
--------------------
Log default output to a specified location, such as cloveretl.log through log4j achieve.
log4j.rootLogger = INFO,CONSOLE,LOGDATABASE,LOGFILE
log4j.appender.LOGDATABASE.Sql=INSERT INTO logtable (rowId,nodeName,portNumber,runStatus,outputMessage,startTime,endTime,runTime ) values('%X{rowId}','%X{nodeName},'%X{portNumber}','%X{runStatus}','%X{outputMessage}','%X{startTime}','%X{endTime}','%X{runTime}' )
log4j.appender.LOGFILE.File=logfile.cloveretl
----------------
Each node has a outputLog Attribute ,default value false [true|false]
Log output is true,not output log is flase
-------------------
Property in the node configuration files defined in the output type, or file value is db
<Property id="GraphParameter0" name="logtype" value="db"/> <Property id="GraphParameter0" name="logtype" value="file"/>
<Node type="DB_OUTPUT_TABLE" outputLog="true" ... />
----------------
Examples:
<?xml version="1.0" encoding="utf-8"?>
<Graph name="hwTesting">
<Phase number="0">
<Edge id="TASK_EDGE_0" fromNode="DB_INPUT_TABLE_0:0" toNode="DB_OUTPUT_TABLE_0:0" metadata="abc_DB_OUTPUT_TABLE_0_0__MetaData" />
<Node id="DB_INPUT_TABLE_0" type="DB_INPUT_TABLE" dbConnection="testaccess" sqlQuery="select * from T2"/>
<Node id="DB_OUTPUT_TABLE_0" type="DB_OUTPUT_TABLE" dbTable="T1" dbFields="c1;c2;c3;c4" dbConnection="testaccess" outputLog="true" />
</Phase>
<Global name="hwTesting">
<Property id="GraphParameter0" name="logtype" value="db"/>
<Metadata id="test1_DB_OUTPUT_TABLE_0_0__MetaData" fileURL="c:/testclover/test1_DB_OUTPUT_TABLE_0_0__MetaData.fmt"/>
<Connection id="testaccess" dbConfig="c:/testclover/testaccess.conf" type="JDBC"/>
</Global>
</Graph>
Please sign in to leave a comment.
Comments 5