2023-03-15 05:49:14,332 INFO  [stdout] (default task-6) user id 45
2023-03-15 05:49:14,332 INFO  [stdout] (default task-6) real cfg /opt/jboss/wildfly/standalone/deployments/atm.war/WEB-INF/config_cms.ini
2023-03-15 05:49:14,333 INFO  [stdout] (default task-6)  db serv ******8.10.20 usr ****gres pas ****1234 nam ***_cms dbp **08
2023-03-15 05:49:14,344 INFO  [stdout] (default task-6) =================================================== checkActivity ==1
2023-03-15 05:49:14,344 INFO  [stdout] (default task-6) real cfg /opt/jboss/wildfly/standalone/deployments/atm.war/WEB-INF/config_cms.ini
2023-03-15 05:49:14,344 INFO  [stdout] (default task-6)  db serv ******8.10.20 usr ****gres pas ****1234 nam ***_cms dbp **08
2023-03-15 05:49:14,352 INFO  [stdout] (default task-6) real cfg /opt/jboss/wildfly/standalone/deployments/atm.war/WEB-INF/config_cms.ini
2023-03-15 05:49:14,352 INFO  [stdout] (default task-6)  db serv ******8.10.20 usr ****gres pas ****1234 nam ***_cms dbp **08
2023-03-15 05:49:14,372 INFO  [stdout] (default task-6) real cfg /opt/jboss/wildfly/standalone/deployments/atm.war/WEB-INF/config_cms.ini
2023-03-15 05:49:14,372 INFO  [stdout] (default task-6)  db serv ******8.10.20 usr ****gres pas ****1234 nam ***_cms dbp **08
2023-03-15 05:49:14,374 INFO  [stdout] (default task-6) real cfg /opt/jboss/wildfly/standalone/deployments/atm.war/WEB-INF/config_cms.ini
2023-03-15 05:49:14,374 INFO  [stdout] (default task-6)  db serv ******8.10.20 usr ****gres pas ****1234 nam ***_cms dbp **08
2023-03-15 05:49:14,380 INFO  [stdout] (default task-6) sqlcommand  SELECT bpr_cabang.nama, acc_card.active_date, card_production.kode_cabang,create_date, convert_from(decrypt( decode( card_no, 'hex' ), 'C@pPucC1n0'::bytea, 'aes' ),'UTF8') AS card_no, convert_from(decrypt( decode( account_no, 'hex' ), 'C@pPucC1n0'::bytea, 'aes' ),'UTF8') AS account_no  ,  name, description,     convert_from(decrypt( decode( customer_name, 'hex' ), 'C@pPucC1n0'::bytea, 'aes' ), 'UTF8') as customer_name , case when card_log.blocking_category=0 then 'Kartu Hilang'  when card_log.blocking_category=1 then 'Kartu Tertelan'  when card_log.blocking_category=2 then 'Kartu Rusak'  when card_log.blocking_category=3 then 'Hasil Investigasi'  when card_log.blocking_category=4 then 'Alasan Lain'   end as blocking_category  FROM card_log left join account on account.account_id = card_log.account_id  left join card_production on card_production.card_id = card_log.card_id left join users_web on users_web.userid = card_log.csuserid left join bpr_cabang on bpr_cabang.kode_cabang = card_production.kode_cabang left join acc_card on acc_card.account_id = card_log.account_id   inner join customer on customer.customer_id  = account.customer_id  WHERE (1=1) and status_id = 3 AND account.kode_cabang = ?
2023-03-15 05:49:14,380 INFO  [stdout] (default task-6) fields_values {1=string|0350}
2023-03-15 05:49:14,380 INFO  [stdout] (default task-6) Key [1]
2023-03-15 05:49:14,380 INFO  [stdout] (default task-6) split0() string
2023-03-15 05:49:14,380 INFO  [stdout] (default task-6) split1() 0350
2023-03-15 05:49:14,380 INFO  [stdout] (default task-6) pstmt  SELECT bpr_cabang.nama, acc_card.active_date, card_production.kode_cabang,create_date, convert_from(decrypt( decode( card_no, 'hex' ), 'C@pPucC1n0'::bytea, 'aes' ),'UTF8') AS card_no, convert_from(decrypt( decode( account_no, 'hex' ), 'C@pPucC1n0'::bytea, 'aes' ),'UTF8') AS account_no  ,  name, description,  convert_from(decrypt( decode( customer_name, 'hex' ), 'C@pPucC1n0'::bytea, 'aes' ), 'UTF8') as customer_name , case when card_log.blocking_category=0 then 'Kartu Hilang'  when card_log.blocking_category=1 then 'Kartu Tertelan'  when card_log.blocking_category=2 then 'Kartu Rusak'  when card_log.blocking_category=3 then 'Hasil Investigasi'  when card_log.blocking_category=4 then 'Alasan Lain'   end as blocking_category  FROM card_log left join account on account.account_id = card_log.account_id  left join card_production on card_production.card_id = card_log.card_id left join users_web on users_web.userid = card_log.csuserid left join bpr_cabang on bpr_cabang.kode_cabang = card_production.kode_cabang left join acc_card on acc_card.account_id = card_log.account_id   inner join customer on customer.customer_id  = account.customer_id  WHERE (1=1) and status_id = 3 AND account.kode_cabang = '0350'
2023-03-15 05:49:14,395 INFO  [stdout] (default task-6) filename: /opt/jboss/wildfly/standalone/deployments/atm.war/assets/files/export_report//Laporan_Pemblokiran_Kartu_15-03-2023.xls
2023-03-15 05:49:14,396 ERROR [stderr] (default task-6) Warning:  Sheet name Laporan_Pemblokiran_Kartu_15-03-2023 too long - truncating
2023-03-15 05:49:14,396 INFO  [stdout] (default task-6) real cfg /opt/jboss/wildfly/standalone/deployments/atm.war/WEB-INF/config_cms.ini
2023-03-15 05:49:14,396 INFO  [stdout] (default task-6)  db serv ******8.10.20 usr ****gres pas ****1234 nam ***_cms dbp **08
2023-03-15 05:49:14,402 INFO  [stdout] (default task-6) sqlcommand  SELECT bpr_cabang.nama, acc_card.active_date, create_date, convert_from(decrypt( decode( card_no, 'hex' ), 'C@pPucC1n0'::bytea, 'aes' ),'UTF8') AS card_no, convert_from(decrypt( decode( account_no, 'hex' ), 'C@pPucC1n0'::bytea, 'aes' ),'UTF8') AS account_no  , bpr_cabang.kode_cabang as kode_cabang ,  name, description,     convert_from(decrypt( decode( customer_name, 'hex' ), 'C@pPucC1n0'::bytea, 'aes' ), 'UTF8') as customer_name , case when card_log.blocking_category=0 then 'Penutupan Kartu'  when card_log.blocking_category=1 then 'Kartu Hilang'  when card_log.blocking_category=2 then 'Reject'  when card_log.blocking_category=3 then 'Alasan Lain'   end as blocking_category  FROM card_log left join account on account.account_id = card_log.account_id  left join card_production on card_production.card_id = card_log.card_id left join users_web on users_web.userid = card_log.csuserid left join bpr_cabang on bpr_cabang.kode_cabang = card_production.kode_cabang left join acc_card on acc_card.account_id = card_log.account_id   inner join customer on customer.customer_id  = account.customer_id  WHERE (1=1) and status_id = 3 AND account.kode_cabang = ?
2023-03-15 05:49:14,402 INFO  [stdout] (default task-6) fields_values {1=string|0350}
2023-03-15 05:49:14,402 INFO  [stdout] (default task-6) Key [1]
2023-03-15 05:49:14,402 INFO  [stdout] (default task-6) split0() string
2023-03-15 05:49:14,402 INFO  [stdout] (default task-6) split1() 0350
2023-03-15 05:49:14,402 INFO  [stdout] (default task-6) pstmt  SELECT bpr_cabang.nama, acc_card.active_date, create_date, convert_from(decrypt( decode( card_no, 'hex' ), 'C@pPucC1n0'::bytea, 'aes' ),'UTF8') AS card_no, convert_from(decrypt( decode( account_no, 'hex' ), 'C@pPucC1n0'::bytea, 'aes' ),'UTF8') AS account_no  , bpr_cabang.kode_cabang as kode_cabang ,  name, description,     convert_from(decrypt( decode( customer_name, 'hex' ), 'C@pPucC1n0'::bytea, 'aes' ), 'UTF8') as customer_name , case when card_log.blocking_category=0 then 'Penutupan Kartu'  when card_log.blocking_category=1 then 'Kartu Hilang'  when card_log.blocking_category=2 then 'Reject'  when card_log.blocking_category=3 then 'Alasan Lain'   end as blocking_category  FROM card_log left join account on account.account_id = card_log.account_id  left join card_production on card_production.card_id = card_log.card_id left join users_web on users_web.userid = card_log.csuserid left join bpr_cabang on bpr_cabang.kode_cabang = card_production.kode_cabang left join acc_card on acc_card.account_id = card_log.account_id   inner join customer on customer.customer_id  = account.customer_id  WHERE (1=1) and status_id = 3 AND account.kode_cabang = '0350'
2023-03-15 05:49:14,416 INFO  [stdout] (default task-6) [{"nama":"Kantor Pusat Operasional","card_no":"5079941100003227","kode_cabang":"0001","name":"Friska Natalia","active_date":"2023-02-01 13:43:45","description":"Kartu hilang entah kemana","blocking_category":"Kartu Hilang","customer_name":"SHELLA PUTRIANA","create_date":"2023-03-04 09:24:06","account_no":"0350221000181"},{"nama":"Kantor Cabang Kalasan","card_no":"5079941100003425","kode_cabang":"0352","name":"Friska Natalia","active_date":"2023-02-14 11:36:37","description":"","blocking_category":"Kartu Hilang","customer_name":"DIAN CANDRA DEWI","create_date":"2023-02-10 11:28:51","account_no":"3501515121"},{"nama":"Kantor Pusat Operasional","card_no":"5079941100003409","kode_cabang":"0001","name":"Fahrul Rizky","active_date":"2023-02-14 11:36:37","description":"Kartu Hilang","blocking_category":"Penutupan Kartu","customer_name":"DIAN CANDRA DEWI","create_date":"2023-03-14 11:25:12","account_no":"3501515121"},{"nama":"Kantor Pusat Operasional","card_no":"5079941100003342","kode_cabang":"0001","name":"Fahrul Rizky","active_date":null,"description":"Investigasi","blocking_category":"Alasan Lain","customer_name":"SITA PARAMITA DEWI,SE","create_date":"2023-03-14 11:27:27","account_no":"3501214474"},{"nama":"Kantor Cabang Utama","card_no":"5079941100003110","kode_cabang":"0350","name":"Support BBW","active_date":null,"description":"kartu ancurrrrrr","blocking_category":"Reject","customer_name":"SOGIYEM","create_date":"2023-03-14 12:56:52","account_no":"0350221000482"},{"nama":"Kantor Pusat Operasional","card_no":"5079941100003268","kode_cabang":"0001","name":"Friska Natalia","active_date":"2023-02-01 10:57:00","description":"test blokir doubleeee","blocking_category":"Reject","customer_name":"RUCHANIHADI, S.PD.DR","create_date":"2023-03-14 13:13:08","account_no":"0352221002882"},{"nama":"Kantor Pusat Operasional","card_no":"5079941100003268","kode_cabang":"0001","name":"Friska Natalia","active_date":"2023-02-01 10:57:00","description":"tertelan bumi","blocking_category":"Kartu Hilang","customer_name":"RUCHANIHADI, S.PD.DR","create_date":"2023-03-14 08:02:23","account_no":"0352221002882"},{"nama":"Kantor Pusat Operasional","card_no":"5079941100003268","kode_cabang":"0001","name":"Friska Natalia","active_date":"2023-02-01 10:57:00","description":"tertelan bumi","blocking_category":"Kartu Hilang","customer_name":"RUCHANIHADI, S.PD.DR","create_date":"2023-03-14 08:02:23","account_no":"0352221002882"},{"nama":"Kantor Cabang Utama","card_no":"5079941100003060","kode_cabang":"0350","name":"Friska Natalia","active_date":"2022-05-17 16:07:56","description":"hilang ditelan bumiiii","blocking_category":"Kartu Hilang","customer_name":"ROYANA PURBA","create_date":"2023-03-15 05:44:25","account_no":"0350221000443"},{"nama":"Kantor Cabang Kalasan","card_no":"5079941200020808","kode_cabang":"0352","name":"BPR Sleman","active_date":null,"description":"dd","blocking_category":"Kartu Hilang","customer_name":"RETNO AMBARWATI","create_date":"2023-03-10 07:39:55","account_no":"0350221000917"},{"nama":"Kantor Pusat Operasional","card_no":"5079941100003375","kode_cabang":"0001","name":"BPR Sleman","active_date":"2023-02-07 14:53:41","description":"Test unblock nanti\r\n","blocking_category":"Kartu Hilang","customer_name":"WILLY PURWANI WULANDARI","create_date":"2023-03-13 08:08:01","account_no":"0350221000169"},{"nama":"Kantor Pusat Operasional","card_no":"5079941100003375","kode_cabang":"0001","name":"Friska Natalia","active_date":"2023-02-07 14:53:41","description":"ATM Tertelan","blocking_category":"Alasan Lain","customer_name":"WILLY PURWANI WULANDARI","create_date":"2023-02-07 15:03:29","account_no":"0350221000169"},{"nama":"Kantor Cabang Kalasan","card_no":"5079941100003425","kode_cabang":"0352","name":"Friska Natalia","active_date":"2023-02-10 16:49:15","description":"","blocking_category":"Kartu Hilang","customer_name":"DIAN CANDRA DEWI","create_date":"2023-02-10 11:28:51","account_no":"3501515121"},{"nama":"Kantor Pusat Operasional","card_no":"5079941100003409","kode_cabang":"0001","name":"Fahrul Rizky","active_date":"2023-02-10 16:49:15","description":"Kartu Hilang","blocking_category":"Penutupan Kartu","customer_name":"DIAN CANDRA DEWI","create_date":"2023-03-14 11:25:12","account_no":"3501515121"},{"nama":"Kantor Pusat Operasional","card_no":"5079941100003391","kode_cabang":"0001","name":"Friska Natalia","active_date":"2023-02-08 10:21:46","description":"","blocking_category":"Kartu Hilang","customer_name":"SUPIYO PURNOMO","create_date":"2023-02-08 10:24:18","account_no":"3501118084"},{"nama":"Kantor Pusat Operasional","card_no":"5079941100003359","kode_cabang":"0001","name":"BPR Sleman","active_date":"2023-02-07 13:18:03","description":"Test double report","blocking_category":"Alasan Lain","customer_name":"NUR ROCHMAD KURNIA WIJAYA,S.STP","create_date":"2023-03-14 05:14:44","account_no":"0350221000014"},{"nama":"Kantor Pusat Operasional","card_no":"5079941100003359","kode_cabang":"0001","name":"Support BBW","active_date":"2023-02-07 13:18:03","description":"kartu ancurrrrrrrrrr","blocking_category":"Reject","customer_name":"NUR ROCHMAD KURNIA WIJAYA,S.STP","create_date":"2023-03-14 13:10:28","account_no":"0350221000014"},{"nama":"Kantor Cabang Kalasan","card_no":"5079941100003417","kode_cabang":"0352","name":"BPR Sleman","active_date":"2023-02-14 12:01:02","description":"kehilangan dirimu\r\n","blocking_category":"Penutupan Kartu","customer_name":"ATNA HANDARINI","create_date":"2023-03-15 05:08:54","account_no":"0350221000820"},{"nama":"Kantor Cabang Kalasan","card_no":"5079941100003417","kode_cabang":"0352","name":"Fahrul Rizky","active_date":"2023-02-14 12:01:02","description":"investigasi","blocking_category":"Alasan Lain","customer_name":"ATNA HANDARINI","create_date":"2023-03-14 11:31:06","account_no":"0350221000820"},{"nama":"Kantor Pusat Operasional","card_no":"5079941100003367","kode_cabang":"0001","name":"Nur Fitriana Lestari","active_date":"2023-02-07 13:33:13","description":"KARTU TERTELAN","blocking_category":"Alasan Lain","customer_name":"ENDAH SETYAWATI","create_date":"2023-02-13 15:23:48","account_no":"0350221000054"},{"nama":"Kantor Pusat Operasional","card_no":"5079941100003367","kode_cabang":"0001","name":"Support BBW","active_date":"2023-02-07 13:33:13","description":"tutup kartu","blocking_category":"Penutupan Kartu","customer_name":"ENDAH SETYAWATI","create_date":"2023-03-07 04:09:07","account_no":"0350221000054"},{"nama":"Kantor Pusat Operasional","card_no":"5079941100003367","kode_cabang":"0001","name":"Friska Natalia","active_date":"2023-02-07 13:33:13","description":"penipuan","blocking_category":"Alasan Lain","customer_name":"ENDAH SETYAWATI","create_date":"2023-03-15 05:48:55","account_no":"0350221000054"},{"nama":"Kantor Pusat Operasional","card_no":"5079941100003656","kode_cabang":"0001","name":"Friska Natalia","active_date":null,"description":"test","blocking_category":"Reject","customer_name":"GILANG JALU ASMORO","create_date":"2023-03-01 07:06:01","account_no":"0350221000159"},{"nama":"Kantor Pusat Operasional","card_no":"5079941100003375","kode_cabang":"0001","name":"BPR Sleman","active_date":"2023-02-07 15:27:16","description":"Test unblock nanti\r\n","blocking_category":"Kartu Hilang","customer_name":"WILLY PURWANI WULANDARI","create_date":"2023-03-13 08:08:01","account_no":"0350221000169"},{"nama":"Kantor Pusat Operasional","card_no":"5079941100003375","kode_cabang":"0001","name":"Friska Natalia","active_date":"2023-02-07 15:27:16","description":"ATM Tertelan","blocking_category":"Alasan Lain","customer_name":"WILLY PURWANI WULANDARI","create_date":"2023-02-07 15:03:29","account_no":"0350221000169"},{"nama":"Kantor Pusat Operasional","card_no":"5079941100003391","kode_cabang":"0001","name":"Friska Natalia","active_date":"2023-02-13 16:26:36","description":"","blocking_category":"Kartu Hilang","customer_name":"SUPIYO PURNOMO","create_date":"2023-02-08 10:24:18","account_no":"3501118084"}]