job_test 0 / - 2020/07/31 14:05:50.845 - 2020/07/31 14:05:50.845 input_db_ip 172.17.0.1 input_db_port 27017 out_db_ip 172.17.0.1 out_db_name ry out_db_port 3306 out_db_pwd sckjadmin out_db_username root ID_JOB Y ID_JOB CHANNEL_ID Y CHANNEL_ID JOBNAME Y JOBNAME STATUS Y STATUS LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS STARTDATE Y STARTDATE ENDDATE Y ENDDATE LOGDATE Y LOGDATE DEPDATE Y DEPDATE REPLAYDATE Y REPLAYDATE LOG_FIELD Y LOG_FIELD EXECUTING_SERVER N EXECUTING_SERVER EXECUTING_USER N EXECUTING_USER START_JOB_ENTRY N START_JOB_ENTRY CLIENT N CLIENT ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE JOBNAME Y TRANSNAME JOBENTRYNAME Y STEPNAME LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS RESULT Y RESULT NR_RESULT_ROWS Y NR_RESULT_ROWS NR_RESULT_FILES Y NR_RESULT_FILES LOG_FIELD N LOG_FIELD COPY_NR N COPY_NR ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE LOGGING_OBJECT_TYPE Y LOGGING_OBJECT_TYPE OBJECT_NAME Y OBJECT_NAME OBJECT_COPY Y OBJECT_COPY REPOSITORY_DIRECTORY Y REPOSITORY_DIRECTORY FILENAME Y FILENAME OBJECT_ID Y OBJECT_ID OBJECT_REVISION Y OBJECT_REVISION PARENT_CHANNEL_ID Y PARENT_CHANNEL_ID ROOT_CHANNEL_ID Y ROOT_CHANNEL_ID N Start SPECIAL Y N N 0 0 30 12 0 1 1 N Y 0 64 80 user TRANS filename ${Internal.Entry.Current.Directory}/clq/user.ktr N N N N N N /strong/kettle/log/ktrlog txt Y Y Basic N N Y N N N Pentaho local N Y N Y 0 736 512 info_message TRANS filename ${Internal.Entry.Current.Directory}/clq/info_message.ktr N N N N N N /strong/kettle/log/ktrlog txt Y Y Basic N N Y N N N Pentaho local N Y N Y 0 592 512 value TRANS filename ${Internal.Entry.Current.Directory}/clq/value.ktr N N N N N N /strong/kettle/log/ktrlog txt Y Y Basic N N Y N N N Pentaho local N Y N Y 0 880 512 dept_base TRANS filename ${Internal.Entry.Current.Directory}/clq/dept_base.ktr N N N N N N /strong/kettle/log/ktrlog txt Y Y Basic N N Y N N N Pentaho local N Y N Y 0 272 304 ability TRANS filename ${Internal.Entry.Current.Directory}/clq/dept_ability.ktr N N N N N N /strong/kettle/log/ktrlog txt Y Y Basic N N Y N N N Pentaho local N Y N Y 0 1376 512 demand TRANS filename ${Internal.Entry.Current.Directory}/clq/dept_demand.ktr N N N N N N /strong/kettle/log/ktrlog txt Y Y Basic N N Y N N N Pentaho local N Y N Y 0 720 304 oldType TRANS filename ${Internal.Entry.Current.Directory}/clq/dept_oldType.ktr N N N N N N /strong/kettle/log/ktrlog txt Y Y Basic N N Y N N N Pentaho local N Y N Y 0 432 304 regularsInfo TRANS filename ${Internal.Entry.Current.Directory}/clq/dept_regularsInfo.ktr N N N N N N /strong/kettle/log/ktrlog txt Y Y Basic N N Y N N N Pentaho local N Y N Y 0 1056 304 sourceOfIncome TRANS filename ${Internal.Entry.Current.Directory}/clq/dept_sourceOfIncome.ktr N N N N N N /strong/kettle/log/ktrlog txt Y Y Basic N N Y N N N Pentaho local N Y N Y 0 1216 512 health TRANS filename ${Internal.Entry.Current.Directory}/clq/health.ktr N N N N N N /strong/kettle/log/ktrlog txt Y Y Basic N N Y N N N Pentaho local N Y N Y 0 1040 512 oldType_level5 TRANS filename ${Internal.Entry.Current.Directory}/clq/oldType_level5.ktr N N N N N N /strong/kettle/log/ktrlog txt Y Y Basic N N Y N N N Pentaho local N Y N Y 0 576 304 demand_level5 TRANS filename ${Internal.Entry.Current.Directory}/clq/demand_level5.ktr N N N N N N /strong/kettle/log/ktrlog txt Y Y Basic N N Y N N N Pentaho local N Y N Y 0 896 304 regularsInfo_level5 TRANS filename ${Internal.Entry.Current.Directory}/clq/regularInfoLevel5.ktr N N N N N N /strong/kettle/log/ktrlog txt Y Y Basic N N Y N N N Pentaho local N Y N Y 0 1376 304 regularsInfo_level4 TRANS filename ${Internal.Entry.Current.Directory}/clq/regularInfoLevel4.ktr N N N N N N /strong/kettle/log/ktrlog txt Y Y Basic N N Y N N N Pentaho local N Y N Y 0 1216 304 info TRANS filename ${Internal.Entry.Current.Directory}/wq/info.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 352 80 child TRANS filename ${Internal.Entry.Current.Directory}/wq/child.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 480 80 avg TRANS filename ${Internal.Entry.Current.Directory}/wq/avg.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 624 80 visit TRANS filename ${Internal.Entry.Current.Directory}/wq/visit.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 208 80 log TRANS filename ${Internal.Entry.Current.Directory}/clq/log.ktr N N N N N N /strong/kettle/log/ktrlog txt Y Y Basic N N Y N N N Pentaho local N Y N Y 0 432 512 loginuser TRANS filename ${Internal.Entry.Current.Directory}/wq/loginuser.ktr N N N N N N /strong/kettle/log/ktrlog txt Y Y Basic N N Y N N N Pentaho local N Y N Y 0 272 512 dept_base oldType 0 0 Y Y N oldType oldType_level5 0 0 Y Y N oldType_level5 demand 0 0 Y Y N demand demand_level5 0 0 Y Y N demand_level5 regularsInfo 0 0 Y Y N regularsInfo_level5 ability 0 0 Y Y N ability sourceOfIncome 0 0 Y Y N sourceOfIncome health 0 0 Y Y N health value 0 0 Y N Y value user 0 0 Y N Y user info_message 0 0 Y N Y regularsInfo regularsInfo_level4 0 0 Y Y N regularsInfo_level4 regularsInfo_level5 0 0 Y Y N Start visit 0 0 Y Y Y visit info 0 0 Y N Y info child 0 0 Y N Y child avg 0 0 Y N Y avg dept_base 0 0 Y N Y info_message log 0 0 Y N Y log loginuser 0 0 Y N Y