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 128 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 704 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 leadtime po to received TRANS filename /home/stephan/transformation-job-bi/import_leadtime_po_to_received.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 704 256 import leadtime so to send TRANS filename /home/stephan/transformation-job-bi/import_leadtime_so_send.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 leadtime detail po to received TRANS filename /home/stephan/transformation-job-bi/import_leadtime_po_to_received_detail.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 176 256 import leadtime detail so to send TRANS filename /home/stephan/transformation-job-bi/import_leadtime_so_send_detail.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 176 416 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 416 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 704 416 import brand TRANS filename /home/stephan/transformation-job-bi/import_brand.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 928 416 import pricelist TRANS filename /home/stephan/transformation-job-bi/import_pricelist.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 1152 416 import product TRANS filename /home/stephan/transformation-job-bi/import_product_product.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 1152 560 import purchase order TRANS filename /home/stephan/transformation-job-bi/import_purchase_order.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 928 560 import purchase pricelist TRANS filename /home/stephan/transformation-job-bi/import_purchase_pricelist.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 704 560 import price group TRANS filename /home/stephan/transformation-job-bi/import_price_group.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 480 560 Start data so accurate 0 0 Y Y Y data so accurate data so adempiere 0 0 Y Y N data so adempiere data so odoo 0 0 Y Y N data so odoo refresh_materialized_view 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 Delete files import leadtime po to received 0 0 Y Y N import leadtime po to received import leadtime so to send 0 0 Y Y N import leadtime so to send import leadtime detail po to received 0 0 Y Y N import leadtime detail po to received import leadtime detail so to send 0 0 Y Y N import leadtime detail so to send import margin 0 0 Y Y N import margin import sale order 0 0 Y Y N import sale order import brand 0 0 Y Y N import brand import pricelist 0 0 Y Y N import pricelist import product 0 0 Y Y N import product import purchase order 0 0 Y Y N import purchase order import purchase pricelist 0 0 Y Y N import purchase pricelist import price group 0 0 Y Y N