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 176 128 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 320 128 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 480 32 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 768 128 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 928 128 Delete files DELETE_FILES N N /home/superman/data .+\.xls /home/superman/data .+\.xlsx N Y 0 928 256 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 1152 128 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 1152 256 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 480 256 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 480 400 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 1344 48 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 1440 176 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 1408 400 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 1344 544 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 1008 544 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 608 400 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 736 400 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 736 480 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 736 576 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 736 656 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