Each node can contain a log output. Such as: the rows of error, the wrong field names, as well as problems with wrong …
Well, I am not sure, is this a feature request ?
There are certain nodes/components which do exactly what you described - like UniversalDataReader or DBOutputTable - please check their documentation.
Also, let us know more details about it.
David.
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
<Node type=“DB_OUTPUT_TABLE” outputLog=“true” … />
----------------
Examples:
It looks like interesting idea. We will definitely look into it and try to implement something similar. But said that, I can’t promise when
Thank you for your response, if we can see how design can achieve together?