run_all_import_data_bi_indoteknik / - 2023/03/08 11:02:31.082 - 2023/03/08 11:02:31.082 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 60 12 0 1 1 N Y 0 80 96 data so accurate TRANS filename /home/stephan/transformation-job-bi/import_accurate_to_data_warehouse.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 224 96 data so adempiere TRANS filename /home/stephan/transformation-job-bi/import_adempiere_to_data_warehouse.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 384 96 data so odoo TRANS filename /home/stephan/transformation-job-bi/import_odoo_14_to_data_warehouse.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 1184 192 refresh_materialized_view TRANS filename /home/stephan/transformation-job-bi/refresh_materialized_view.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 1008 192 Delete files DELETE_FILES N N /home/superman/data .+\.xls /home/superman/data .+\.xlsx N Y 0 656 192 import fixco TRANS filename /home/stephan/transformation-job-bi/import_accurate_fixco_to_data_warehouse.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 848 192 refresh mv fixco TRANS filename /home/stephan/transformation-job-bi/refresh_materialized_view_fixco.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 752 192 import margin TRANS filename /home/stephan/transformation-job-bi/import_margin.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 512 192 import sale order TRANS filename /home/stephan/transformation-job-bi/import_sale_order.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 368 192 import account move TRANS filename /home/stephan/transformation-job-bi/import_account_move.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 576 96 import account move line TRANS filename /home/stephan/transformation-job-bi/import_account_move_line.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 736 96 import partner TRANS filename /home/stephan/transformation-job-bi/import_partner.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 896 96 import industry TRANS filename /home/stephan/transformation-job-bi/import_industry.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 1024 96 import user TRANS filename /home/stephan/transformation-job-bi/import_user.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 1184 96 refresh margin TRANS filename /home/stephan/transformation-job-bi/refresh_margin_sales_order.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 240 192 import state TRANS filename /home/stephan/transformation-job-bi/import_state.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 80 192 import_kota TRANS filename /home/stephan/transformation-job-bi/import_kota.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 80 320 import kecamatan TRANS filename /home/stephan/transformation-job-bi/import_kecamatan.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 240 320 import kelurahan TRANS filename /home/stephan/transformation-job-bi/import_kelurahan.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 384 320 import invoice margin TRANS filename /home/stephan/transformation-job-bi/calculate_margin_invoice.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 528 320 import property TRANS filename /home/stephan/transformation-job-bi/import_property.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 656 320 import payment term TRANS filename /home/stephan/transformation-job-bi/import_payment_term.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 784 320 import payment reconciled TRANS filename /home/stephan/transformation-job-bi/import_payment_reconciled.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 1008 320 import bank statement TRANS filename /home/stephan/transformation-job-bi/import_bank_account_statement.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 1184 320 update nonactive promotion program line TRANS filename /home/stephan/transformation-job-bi/update_nonactive_promotion_product.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 1184 416 Start data so accurate 0 0 Y Y Y data so accurate data so adempiere 0 0 Y Y N refresh_materialized_view import fixco 0 0 Y Y N import fixco refresh mv fixco 0 0 Y Y N refresh mv fixco Delete files 0 0 Y Y N import margin import sale order 0 0 Y Y N import account move import account move line 0 0 Y Y N import account move line import partner 0 0 Y Y N import partner import industry 0 0 Y Y N import industry import user 0 0 Y Y N data so adempiere import account move 0 0 Y Y N import user data so odoo 0 0 Y Y N data so odoo refresh_materialized_view 0 0 Y Y N Delete files import margin 0 0 Y Y N import sale order refresh margin 0 0 Y Y N refresh margin import state 0 0 Y Y N import state import_kota 0 0 Y Y N import_kota import kecamatan 0 0 Y Y N import kecamatan import kelurahan 0 0 Y Y N import kelurahan import invoice margin 0 0 Y Y N import invoice margin import property 0 0 Y Y N import property import payment term 0 0 Y Y N import payment term import payment reconciled 0 0 Y Y N import payment reconciled import bank statement 0 0 Y Y N import bank statement update nonactive promotion program line 0 0 Y Y N