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 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 976 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 800 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 560 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 288 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 560 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 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 32 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 32 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 176 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 336 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 800 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 import account account TRANS filename /home/stephan/transformation-job-bi/import_account_account.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 account financial report TRANS filename /home/stephan/transformation-job-bi/import_account_financial_report.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 calculate financial report TRANS filename /home/stephan/transformation-job-bi/calculate_financial_report.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 calculate profit loss TRANS filename /home/stephan/transformation-job-bi/calculate_profit_loss.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 320 416 account payment TRANS filename /home/stephan/transformation-job-bi/import_account_payment.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 160 416 match payment invoice TRANS filename /home/stephan/transformation-job-bi/import_match_payment_invoice.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 160 528 logbook sj TRANS filename /home/stephan/transformation-job-bi/import_logbook_sj.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 352 528 purchase order v2 TRANS filename /home/stephan/transformation-job-bi/import_purchase_order_v2.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 496 528 import sale order v2 TRANS filename /home/stephan/transformation-job-bi/import_sale_order_v2.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 432 192 po sale match TRANS filename /home/stephan/transformation-job-bi/import_purchase_order_sales_match.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 656 528 delivery carrier TRANS filename /home/stephan/transformation-job-bi/import_delivery_carrier.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 800 528 calculate_lob_category TRANS filename /home/stephan/transformation-job-bi/calculate_lob_category_v2.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 960 528 calculate_lob_category append TRANS filename /home/stephan/transformation-job-bi/calculate_lob_category_v2_append.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 1184 528 calculate margin v3 TRANS filename /home/stephan/transformation-job-bi/calculate_margin_invoice_v3.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 1184 640 Success SUCCESS N Y 0 384 640 new current customer TRANS filename /home/stephan/transformation-job-bi/calculate_new_current_customer.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 960 640 calculate sales 3 years TRANS filename /home/stephan/transformation-job-bi/calculate_sales_3_years.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 752 640 update aging info TRANS filename /home/stephan/transformation-job-bi/update_aging_info.ktr N N N N N N N N Basic N N Y N N N Pentaho local N Y N Y 0 544 640 Start data so accurate 0 0 Y Y Y data so accurate data so adempiere 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 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 Delete files import margin 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 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 update nonactive promotion program line import account account 0 0 Y Y N import account account import account financial report 0 0 Y Y N import account financial report calculate financial report 0 0 Y Y N calculate financial report calculate profit loss 0 0 Y Y N calculate profit loss account payment 0 0 Y Y N account payment match payment invoice 0 0 Y Y N match payment invoice logbook sj 0 0 Y Y N logbook sj purchase order v2 0 0 Y Y N import margin import sale order v2 0 0 Y Y N import sale order v2 import sale order 0 0 Y Y N purchase order v2 po sale match 0 0 Y Y N data so odoo import fixco 0 0 Y Y N po sale match delivery carrier 0 0 Y Y N calculate_lob_category calculate_lob_category append 0 0 Y Y N import sale order import state 0 0 Y Y N calculate_lob_category append calculate margin v3 0 0 Y Y N delivery carrier calculate_lob_category 0 0 Y Y N calculate margin v3 new current customer 0 0 Y Y N new current customer calculate sales 3 years 0 0 Y Y N calculate sales 3 years update aging info 0 0 Y Y N update aging info Success 0 0 Y Y N import kelurahan import property 0 0 Y Y N