log request registrasi

                Never    
Java
       
2023-03-20 10:19:33,250 INFO  [stdout] (default task-3) user id 2
2023-03-20 10:19:33,250 INFO  [stdout] (default task-3) real cfg /opt/jboss/wildfly/standalone/deployments/atm.war/WEB-INF/config_cms.ini
2023-03-20 10:19:33,251 INFO  [stdout] (default task-3)  db serv ******8.10.20 usr ****gres pas ****1234 nam ***_cms dbp **08
2023-03-20 10:19:33,261 INFO  [stdout] (default task-3) =================================================== checkActivity ==1
2023-03-20 10:19:34,805 INFO  [stdout] (default task-3) user id 2
2023-03-20 10:19:34,805 INFO  [stdout] (default task-3) real cfg /opt/jboss/wildfly/standalone/deployments/atm.war/WEB-INF/config_cms.ini
2023-03-20 10:19:34,806 INFO  [stdout] (default task-3)  db serv ******8.10.20 usr ****gres pas ****1234 nam ***_cms dbp **08
2023-03-20 10:19:34,815 INFO  [stdout] (default task-3) =================================================== checkActivity ==1
2023-03-20 10:19:34,815 INFO  [stdout] (default task-3) real cfg /opt/jboss/wildfly/standalone/deployments/atm.war/WEB-INF/config_cms.ini
2023-03-20 10:19:34,816 INFO  [stdout] (default task-3)  db serv ******8.10.20 usr ****gres pas ****1234 nam ***_cms dbp **08
2023-03-20 10:19:34,817 INFO  [stdout] (default task-3) real cfg /opt/jboss/wildfly/standalone/deployments/atm.war/WEB-INF/config_cms.ini
2023-03-20 10:19:34,817 INFO  [stdout] (default task-3)  db serv ******8.10.20 usr ****gres pas ****1234 nam ***_cms dbp **08
2023-03-20 10:19:34,817 ERROR [stderr] (default task-3) storedToken 925dc85dd427e46
2023-03-20 10:19:34,817 ERROR [stderr] (default task-3) token 925dc85dd427e46
2023-03-20 10:19:34,822 INFO  [stdout] (default task-3) sqlcommand  SELECT kode_cabang FROM account WHERE convert_from(decrypt( decode( account_no, 'hex' ), 'C@pPucC1n0'::bytea, 'aes' ),'UTF8') LIKE ?
2023-03-20 10:19:34,822 INFO  [stdout] (default task-3) fields_values {1=string|0350221000169}
2023-03-20 10:19:34,822 INFO  [stdout] (default task-3) Key [1]
2023-03-20 10:19:34,822 INFO  [stdout] (default task-3) split0() string
2023-03-20 10:19:34,822 INFO  [stdout] (default task-3) split1() 0350221000169
2023-03-20 10:19:34,822 INFO  [stdout] (default task-3) pstmt  SELECT kode_cabang FROM account WHERE convert_from(decrypt( decode( account_no, 'hex' ), 'C@pPucC1n0'::bytea, 'aes' ),'UTF8') LIKE '0350221000169'
2023-03-20 10:19:34,823 INFO  [stdout] (default task-3) real cfg /opt/jboss/wildfly/standalone/deployments/atm.war/WEB-INF/config_cms.ini
2023-03-20 10:19:34,823 INFO  [stdout] (default task-3)  db serv ******8.10.20 usr ****gres pas ****1234 nam ***_cms dbp **08
2023-03-20 10:19:34,837 INFO  [stdout] (default task-3) sqlcommand SELECT COUNT(0) from account where account_no = ?
2023-03-20 10:19:34,837 INFO  [stdout] (default task-3) fields_values {1=string|encode(encrypt('0350221000169'::bytea, 'C@pPucC1n0'::bytea, 'aes'),'hex')}
2023-03-20 10:19:34,837 INFO  [stdout] (default task-3) Key [1]
2023-03-20 10:19:34,837 INFO  [stdout] (default task-3) split0() string
2023-03-20 10:19:34,837 INFO  [stdout] (default task-3) split1() encode(encrypt('0350221000169'::bytea, 'C@pPucC1n0'::bytea, 'aes'),'hex')
2023-03-20 10:19:34,837 INFO  [stdout] (default task-3) pstmt SELECT COUNT(0) from account where account_no = 'encode(encrypt(''0350221000169''::bytea, ''C@pPucC1n0''::bytea, ''aes''),''hex'')'
2023-03-20 10:19:34,846 INFO  [stdout] (default task-3) MappingCardToAccount()
2023-03-20 10:19:34,846 INFO  [stdout] (default task-3) no_rekening:0350221000169
2023-03-20 10:19:34,846 INFO  [stdout] (default task-3) no_kartu:5079941100008135
2023-03-20 10:19:34,846 INFO  [stdout] (default task-3) kode_bpr:001
2023-03-20 10:19:34,846 INFO  [stdout] (default task-3) kode_cabang:0350
2023-03-20 10:19:34,846 INFO  [stdout] (default task-3) csuserid:2
2023-03-20 10:19:34,846 INFO  [stdout] (default task-3) nama_di_kartu:
2023-03-20 10:19:34,846 INFO  [stdout] (default task-3) is_print_nama:0
2023-03-20 10:19:34,846 INFO  [stdout] (default task-3) card_program_id:1
2023-03-20 10:19:34,846 INFO  [stdout] (default task-3) customer_category_id:2
2023-03-20 10:19:34,846 INFO  [stdout] (default task-3) card_type_id:1
2023-03-20 10:19:34,846 INFO  [stdout] (default task-3) real cfg /opt/jboss/wildfly/standalone/deployments/atm.war/WEB-INF/config_cms.ini
2023-03-20 10:19:34,846 INFO  [stdout] (default task-3)  db serv ******8.10.20 usr ****gres pas ****1234 nam ***_cms dbp **08
2023-03-20 10:19:34,854 INFO  [stdout] (default task-3) ---->>>>>> SELECT kode_cabang FROM account WHERE convert_from(decrypt( decode( account_no, 'hex' ), 'C@pPucC1n0'::bytea, 'aes' ),'UTF8') LIKE '0350221000169'
2023-03-20 10:19:34,863 INFO  [stdout] (default task-3) query = SELECT COUNT(0) AS numrow,             (                   CASE WHEN exp_date <> '9999' THEN                            CASE WHEN CONCAT('20', substring(exp_date from 1 for 2) ,'-', substring(exp_date from 3 for 2) ,'-01')::DATE <= to_char(NOW(),'YYYY-MM-DD')::DATE THEN 1                        ELSE 0                          END                            ELSE 0                          END         ) AS is_expired,                printed_status,         (
  CASE WHEN receive_date IS NULL THEN 0 ELSE 1 END             ) AS is_receive,                   card_link_status,               card_production.kode_cabang,            card_production.card_program_id,                card_production.has_printed FROM card_production WHERE  convert_from(decrypt( decode( card_no, 'hex' ), 'C@pPucC1n0'::bytea, 'aes' ),'UTF8') LIKE '5079941100008135' and card_program_id=1 GROUP BY card_id, exp_date,    card_production.printed_status, card_production.receive_date,   card_production.card_link_status,  card_production.kode_cabang,     card_production.card_program_id,        card_production.has_printed
2023-03-20 10:19:34,878 INFO  [stdout] (default task-3) query: SELECT COUNT(0) AS numrow FROM account WHERE  convert_from(decrypt( decode( account_no, 'hex' ), 'C@pPucC1n0'::bytea, 'aes' ),'UTF8') LIKE '0350221000169'
2023-03-20 10:19:34,887 INFO  [stdout] (default task-3) query: SELECT acc_card.status_kartu, convert_from(decrypt( decode( card_no, 'hex' ), 'C@pPucC1n0'::bytea, 'aes' ),'UTF8') AS card_no  FROM acc_card INNER JOIN card_production ON acc_card.card_id = card_production.card_id  WHERE account_id = (          SELECT account_id               FROM account            WHERE  convert_from(decrypt( decode( account_no, 'hex' ), 'C@pPucC1n0'::bytea, 'aes' ),'UTF8') LIKE '0350221000169')
2023-03-20 10:19:34,895 INFO  [stdout] (default task-3) query_result: [{"card_no":"5079941100003375","status_kartu":"-10"},{"card_no":"5079941100003383","status_kartu":"-10"}]
2023-03-20 10:19:34,896 INFO  [stdout] (default task-3) real cfg /opt/jboss/wildfly/standalone/deployments/atm.war/WEB-INF/config_cms.ini
2023-03-20 10:19:34,896 INFO  [stdout] (default task-3)  db serv ******8.10.20 usr ****gres pas ****1234 nam ***_cms dbp **08
2023-03-20 10:19:34,919 INFO  [stdout] (default task-3) query pin offset : SELECT convert_from(decrypt( decode( pin_offset, 'hex' ), 'C@pPucC1n0'::bytea, 'aes' ),'UTF8') from card_production where convert_from(decrypt( decode( card_no , 'hex' ), 'C@pPucC1n0'::bytea, 'aes' ),'UTF8') = 5079941100008135
2023-03-20 10:19:34,920 INFO  [stdout] (default task-3) PIN OFFSET : 613539
2023-03-20 10:19:34,920 INFO  [stdout] (default task-3) RegisCardAccount_postgre()
2023-03-20 10:19:34,920 INFO  [stdout] (default task-3) real cfg /opt/jboss/wildfly/standalone/deployments/atm.war/WEB-INF/config_cms.ini
2023-03-20 10:19:34,920 INFO  [stdout] (default task-3)  db serv ******8.10.20 usr ****gres pas ****1234 nam ***_cms dbp **08
2023-03-20 10:19:34,920 INFO  [stdout] (default task-3) prepareCall() { ? = call sp_regis_card_account( ?::varchar,?::varchar,?::varchar,?::varchar,?::varchar,?::varchar,?::varchar,?::smallint,?::smallint,?::smallint,?::smallint,?::varchar) }
2023-03-20 10:19:34,948 INFO  [stdout] (default task-3) 1|39-6524
2023-03-20 10:19:34,959 INFO  [stdout] (default task-3) executeGetLastID() INSERT INTO notifikasi (status,pesan,tujuan,typenotifikasi) values (0,'Kepada yang terhormat nasabah DELIMA, berikut PIN untuk aktivasi kartu DELIMA anda. Segera lakukan aktivasi kartu anda demi keamanan bertransaksi. PIN anda : .','082242512011',1)
2023-03-20 10:19:34,966 INFO  [stdout] (default task-3) lastid='76'
2023-03-20 10:19:34,966 INFO  [stdout] (default task-3) get export folder location: /opt/jboss/wildfly/standalone/deployments/atm.war/assets/files/export_card_production/
2023-03-20 10:19:34,993 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_98_20032023.csv'  WHERE card_batch_id = 98
2023-03-20 10:19:35,012 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_133_20032023.csv'  WHERE card_batch_id = 133
2023-03-20 10:19:35,030 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_2_20032023.csv'  WHERE card_batch_id = 2
2023-03-20 10:19:35,047 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_32_20032023.csv'  WHERE card_batch_id = 32
2023-03-20 10:19:35,066 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_71_20032023.csv'  WHERE card_batch_id = 71
2023-03-20 10:19:35,091 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_308_20032023.csv'  WHERE card_batch_id = 308
2023-03-20 10:19:35,113 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_137_20032023.csv'  WHERE card_batch_id = 137
2023-03-20 10:19:35,133 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_138_20032023.csv'  WHERE card_batch_id = 138
2023-03-20 10:19:35,152 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_309_20032023.csv'  WHERE card_batch_id = 309
2023-03-20 10:19:35,172 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_79_20032023.csv'  WHERE card_batch_id = 79
2023-03-20 10:19:35,192 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_84_20032023.csv'  WHERE card_batch_id = 84
2023-03-20 10:19:35,211 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_89_20032023.csv'  WHERE card_batch_id = 89
2023-03-20 10:19:35,230 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_94_20032023.csv'  WHERE card_batch_id = 94
2023-03-20 10:19:35,251 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_101_20032023.csv'  WHERE card_batch_id = 101
2023-03-20 10:19:35,271 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_106_20032023.csv'  WHERE card_batch_id = 106
2023-03-20 10:19:35,291 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_51_20032023.csv'  WHERE card_batch_id = 51
2023-03-20 10:19:35,310 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_153_20032023.csv'  WHERE card_batch_id = 153
2023-03-20 10:19:35,328 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_130_20032023.csv'  WHERE card_batch_id = 130
2023-03-20 10:19:35,349 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_67_20032023.csv'  WHERE card_batch_id = 67
2023-03-20 10:19:35,382 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_141_20032023.csv'  WHERE card_batch_id = 141
2023-03-20 10:19:35,410 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_149_20032023.csv'  WHERE card_batch_id = 149
2023-03-20 10:19:35,435 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_145_20032023.csv'  WHERE card_batch_id = 145
2023-03-20 10:19:35,456 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_182_20032023.csv'  WHERE card_batch_id = 182
2023-03-20 10:19:35,486 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_157_20032023.csv'  WHERE card_batch_id = 157
2023-03-20 10:19:35,509 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_161_20032023.csv'  WHERE card_batch_id = 161
2023-03-20 10:19:35,527 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_191_20032023.csv'  WHERE card_batch_id = 191
2023-03-20 10:19:35,545 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_43_20032023.csv'  WHERE card_batch_id = 43
2023-03-20 10:19:35,562 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_74_20032023.csv'  WHERE card_batch_id = 74
2023-03-20 10:19:35,580 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_111_20032023.csv'  WHERE card_batch_id = 111
2023-03-20 10:19:35,597 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_116_20032023.csv'  WHERE card_batch_id = 116
2023-03-20 10:19:35,615 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_60_20032023.csv'  WHERE card_batch_id = 60
2023-03-20 10:19:35,635 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_275_20032023.csv'  WHERE card_batch_id = 275
2023-03-20 10:19:35,654 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_192_20032023.csv'  WHERE card_batch_id = 192
2023-03-20 10:19:35,682 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_154_20032023.csv'  WHERE card_batch_id = 154
2023-03-20 10:19:35,702 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_158_20032023.csv'  WHERE card_batch_id = 158
2023-03-20 10:19:35,719 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_162_20032023.csv'  WHERE card_batch_id = 162
2023-03-20 10:19:35,738 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_112_20032023.csv'  WHERE card_batch_id = 112
2023-03-20 10:19:35,764 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_171_20032023.csv'  WHERE card_batch_id = 171
2023-03-20 10:19:35,785 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_167_20032023.csv'  WHERE card_batch_id = 167
2023-03-20 10:19:35,802 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_214_20032023.csv'  WHERE card_batch_id = 214
2023-03-20 10:19:35,820 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_194_20032023.csv'  WHERE card_batch_id = 194
2023-03-20 10:19:35,840 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_188_20032023.csv'  WHERE card_batch_id = 188
2023-03-20 10:19:35,859 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_80_20032023.csv'  WHERE card_batch_id = 80
2023-03-20 10:19:35,877 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_85_20032023.csv'  WHERE card_batch_id = 85
2023-03-20 10:19:35,896 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_90_20032023.csv'  WHERE card_batch_id = 90
2023-03-20 10:19:35,917 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_196_20032023.csv'  WHERE card_batch_id = 196
2023-03-20 10:19:35,938 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_135_20032023.csv'  WHERE card_batch_id = 135
2023-03-20 10:19:35,957 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_132_20032023.csv'  WHERE card_batch_id = 132
2023-03-20 10:19:35,975 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_211_20032023.csv'  WHERE card_batch_id = 211
2023-03-20 10:19:35,994 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_95_20032023.csv'  WHERE card_batch_id = 95
2023-03-20 10:19:36,013 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_69_20032023.csv'  WHERE card_batch_id = 69
2023-03-20 10:19:36,030 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_117_20032023.csv'  WHERE card_batch_id = 117
2023-03-20 10:19:36,048 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_122_20032023.csv'  WHERE card_batch_id = 122
2023-03-20 10:19:36,071 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_126_20032023.csv'  WHERE card_batch_id = 126
2023-03-20 10:19:36,092 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_131_20032023.csv'  WHERE card_batch_id = 131
2023-03-20 10:19:36,111 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_102_20032023.csv'  WHERE card_batch_id = 102
2023-03-20 10:19:36,129 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_107_20032023.csv'  WHERE card_batch_id = 107
2023-03-20 10:19:36,149 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_47_20032023.csv'  WHERE card_batch_id = 47
2023-03-20 10:19:36,170 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_55_20032023.csv'  WHERE card_batch_id = 55
2023-03-20 10:19:36,192 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_56_20032023.csv'  WHERE card_batch_id = 56
2023-03-20 10:19:36,224 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_70_20032023.csv'  WHERE card_batch_id = 70
2023-03-20 10:19:36,245 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_75_20032023.csv'  WHERE card_batch_id = 75
2023-03-20 10:19:36,263 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_175_20032023.csv'  WHERE card_batch_id = 175
2023-03-20 10:19:36,280 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_179_20032023.csv'  WHERE card_batch_id = 179
2023-03-20 10:19:36,301 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_183_20032023.csv'  WHERE card_batch_id = 183
2023-03-20 10:19:36,322 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_187_20032023.csv'  WHERE card_batch_id = 187
2023-03-20 10:19:36,343 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_139_20032023.csv'  WHERE card_batch_id = 139
2023-03-20 10:19:36,361 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_147_20032023.csv'  WHERE card_batch_id = 147
2023-03-20 10:19:36,379 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_178_20032023.csv'  WHERE card_batch_id = 178
2023-03-20 10:19:36,398 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_45_20032023.csv'  WHERE card_batch_id = 45
2023-03-20 10:19:36,416 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_142_20032023.csv'  WHERE card_batch_id = 142
2023-03-20 10:19:36,434 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_52_20032023.csv'  WHERE card_batch_id = 52
2023-03-20 10:19:36,452 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_61_20032023.csv'  WHERE card_batch_id = 61
2023-03-20 10:19:36,473 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_150_20032023.csv'  WHERE card_batch_id = 150
2023-03-20 10:19:36,491 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_193_20032023.csv'  WHERE card_batch_id = 193
2023-03-20 10:19:36,511 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_136_20032023.csv'  WHERE card_batch_id = 136
2023-03-20 10:19:36,529 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_209_20032023.csv'  WHERE card_batch_id = 209
2023-03-20 10:19:36,550 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_212_20032023.csv'  WHERE card_batch_id = 212
2023-03-20 10:19:36,568 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_215_20032023.csv'  WHERE card_batch_id = 215
2023-03-20 10:19:36,587 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_217_20032023.csv'  WHERE card_batch_id = 217
2023-03-20 10:19:36,604 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_219_20032023.csv'  WHERE card_batch_id = 219
2023-03-20 10:19:36,623 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_221_20032023.csv'  WHERE card_batch_id = 221
2023-03-20 10:19:36,644 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_224_20032023.csv'  WHERE card_batch_id = 224
2023-03-20 10:19:36,661 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_226_20032023.csv'  WHERE card_batch_id = 226
2023-03-20 10:19:36,678 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_228_20032023.csv'  WHERE card_batch_id = 228
2023-03-20 10:19:36,700 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_232_20032023.csv'  WHERE card_batch_id = 232
2023-03-20 10:19:36,739 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_234_20032023.csv'  WHERE card_batch_id = 234
2023-03-20 10:19:36,760 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_252_20032023.csv'  WHERE card_batch_id = 252
2023-03-20 10:19:36,782 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_202_20032023.csv'  WHERE card_batch_id = 202
2023-03-20 10:19:36,801 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_200_20032023.csv'  WHERE card_batch_id = 200
2023-03-20 10:19:36,821 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_205_20032023.csv'  WHERE card_batch_id = 205
2023-03-20 10:19:36,839 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_206_20032023.csv'  WHERE card_batch_id = 206
2023-03-20 10:19:36,858 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_265_20032023.csv'  WHERE card_batch_id = 265
2023-03-20 10:19:36,877 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_97_20032023.csv'  WHERE card_batch_id = 97
2023-03-20 10:19:36,897 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_42_20032023.csv'  WHERE card_batch_id = 42
2023-03-20 10:19:36,916 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_41_20032023.csv'  WHERE card_batch_id = 41
2023-03-20 10:19:36,934 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_57_20032023.csv'  WHERE card_batch_id = 57
2023-03-20 10:19:36,952 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_62_20032023.csv'  WHERE card_batch_id = 62
2023-03-20 10:19:36,970 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_222_20032023.csv'  WHERE card_batch_id = 222
2023-03-20 10:19:36,988 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_44_20032023.csv'  WHERE card_batch_id = 44
2023-03-20 10:19:37,006 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_176_20032023.csv'  WHERE card_batch_id = 176
2023-03-20 10:19:37,024 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_76_20032023.csv'  WHERE card_batch_id = 76
2023-03-20 10:19:37,043 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_81_20032023.csv'  WHERE card_batch_id = 81
2023-03-20 10:19:37,060 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_91_20032023.csv'  WHERE card_batch_id = 91
2023-03-20 10:19:37,083 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_86_20032023.csv'  WHERE card_batch_id = 86
2023-03-20 10:19:37,102 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_96_20032023.csv'  WHERE card_batch_id = 96
2023-03-20 10:19:37,121 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_103_20032023.csv'  WHERE card_batch_id = 103
2023-03-20 10:19:37,141 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_113_20032023.csv'  WHERE card_batch_id = 113
2023-03-20 10:19:37,159 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_108_20032023.csv'  WHERE card_batch_id = 108
2023-03-20 10:19:37,178 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_118_20032023.csv'  WHERE card_batch_id = 118
2023-03-20 10:19:37,196 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_123_20032023.csv'  WHERE card_batch_id = 123
2023-03-20 10:19:37,214 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_65_20032023.csv'  WHERE card_batch_id = 65
2023-03-20 10:19:37,232 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_127_20032023.csv'  WHERE card_batch_id = 127
2023-03-20 10:19:37,249 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_143_20032023.csv'  WHERE card_batch_id = 143
2023-03-20 10:19:37,269 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_144_20032023.csv'  WHERE card_batch_id = 144
2023-03-20 10:19:37,287 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_148_20032023.csv'  WHERE card_batch_id = 148
2023-03-20 10:19:37,310 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_152_20032023.csv'  WHERE card_batch_id = 152
2023-03-20 10:19:37,330 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_156_20032023.csv'  WHERE card_batch_id = 156
2023-03-20 10:19:37,348 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_160_20032023.csv'  WHERE card_batch_id = 160
2023-03-20 10:19:37,368 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_169_20032023.csv'  WHERE card_batch_id = 169
2023-03-20 10:19:37,386 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_173_20032023.csv'  WHERE card_batch_id = 173
2023-03-20 10:19:37,404 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_159_20032023.csv'  WHERE card_batch_id = 159
2023-03-20 10:19:37,424 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_164_20032023.csv'  WHERE card_batch_id = 164
2023-03-20 10:19:37,442 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_168_20032023.csv'  WHERE card_batch_id = 168
2023-03-20 10:19:37,461 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_172_20032023.csv'  WHERE card_batch_id = 172
2023-03-20 10:19:37,480 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_180_20032023.csv'  WHERE card_batch_id = 180
2023-03-20 10:19:37,498 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_184_20032023.csv'  WHERE card_batch_id = 184
2023-03-20 10:19:37,515 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_189_20032023.csv'  WHERE card_batch_id = 189
2023-03-20 10:19:37,534 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_216_20032023.csv'  WHERE card_batch_id = 216
2023-03-20 10:19:37,551 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_218_20032023.csv'  WHERE card_batch_id = 218
2023-03-20 10:19:37,569 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_220_20032023.csv'  WHERE card_batch_id = 220
2023-03-20 10:19:37,586 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_223_20032023.csv'  WHERE card_batch_id = 223
2023-03-20 10:19:37,604 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_225_20032023.csv'  WHERE card_batch_id = 225
2023-03-20 10:19:37,622 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_227_20032023.csv'  WHERE card_batch_id = 227
2023-03-20 10:19:37,641 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_229_20032023.csv'  WHERE card_batch_id = 229
2023-03-20 10:19:37,659 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_231_20032023.csv'  WHERE card_batch_id = 231
2023-03-20 10:19:37,677 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_233_20032023.csv'  WHERE card_batch_id = 233
2023-03-20 10:19:37,703 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_251_20032023.csv'  WHERE card_batch_id = 251
2023-03-20 10:19:37,724 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_253_20032023.csv'  WHERE card_batch_id = 253
2023-03-20 10:19:37,742 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_201_20032023.csv'  WHERE card_batch_id = 201
2023-03-20 10:19:37,760 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_199_20032023.csv'  WHERE card_batch_id = 199
2023-03-20 10:19:37,779 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_203_20032023.csv'  WHERE card_batch_id = 203
2023-03-20 10:19:37,799 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_207_20032023.csv'  WHERE card_batch_id = 207
2023-03-20 10:19:37,817 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_208_20032023.csv'  WHERE card_batch_id = 208
2023-03-20 10:19:37,835 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_260_20032023.csv'  WHERE card_batch_id = 260
2023-03-20 10:19:37,853 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_48_20032023.csv'  WHERE card_batch_id = 48
2023-03-20 10:19:37,871 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_35_20032023.csv'  WHERE card_batch_id = 35
2023-03-20 10:19:37,890 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_63_20032023.csv'  WHERE card_batch_id = 63
2023-03-20 10:19:37,908 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_49_20032023.csv'  WHERE card_batch_id = 49
2023-03-20 10:19:37,928 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_72_20032023.csv'  WHERE card_batch_id = 72
2023-03-20 10:19:37,945 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_77_20032023.csv'  WHERE card_batch_id = 77
2023-03-20 10:19:37,964 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_87_20032023.csv'  WHERE card_batch_id = 87
2023-03-20 10:19:37,982 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_82_20032023.csv'  WHERE card_batch_id = 82
2023-03-20 10:19:38,001 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_99_20032023.csv'  WHERE card_batch_id = 99
2023-03-20 10:19:38,019 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_92_20032023.csv'  WHERE card_batch_id = 92
2023-03-20 10:19:38,036 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_109_20032023.csv'  WHERE card_batch_id = 109
2023-03-20 10:19:38,054 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_104_20032023.csv'  WHERE card_batch_id = 104
2023-03-20 10:19:38,072 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_114_20032023.csv'  WHERE card_batch_id = 114
2023-03-20 10:19:38,091 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_128_20032023.csv'  WHERE card_batch_id = 128
2023-03-20 10:19:38,113 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_124_20032023.csv'  WHERE card_batch_id = 124
2023-03-20 10:19:38,132 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_140_20032023.csv'  WHERE card_batch_id = 140
2023-03-20 10:19:38,150 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_39_20032023.csv'  WHERE card_batch_id = 39
2023-03-20 10:19:38,168 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_93_20032023.csv'  WHERE card_batch_id = 93
2023-03-20 10:19:38,187 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_31_20032023.csv'  WHERE card_batch_id = 31
2023-03-20 10:19:38,209 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_245_20032023.csv'  WHERE card_batch_id = 245
2023-03-20 10:19:38,247 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_248_20032023.csv'  WHERE card_batch_id = 248
2023-03-20 10:19:38,267 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_50_20032023.csv'  WHERE card_batch_id = 50
2023-03-20 10:19:38,285 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_243_20032023.csv'  WHERE card_batch_id = 243
2023-03-20 10:19:38,303 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_244_20032023.csv'  WHERE card_batch_id = 244
2023-03-20 10:19:38,321 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_246_20032023.csv'  WHERE card_batch_id = 246
2023-03-20 10:19:38,346 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_115_20032023.csv'  WHERE card_batch_id = 115
2023-03-20 10:19:38,365 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_78_20032023.csv'  WHERE card_batch_id = 78
2023-03-20 10:19:38,383 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_238_20032023.csv'  WHERE card_batch_id = 238
2023-03-20 10:19:38,401 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_239_20032023.csv'  WHERE card_batch_id = 239
2023-03-20 10:19:38,420 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_181_20032023.csv'  WHERE card_batch_id = 181
2023-03-20 10:19:38,439 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_185_20032023.csv'  WHERE card_batch_id = 185
2023-03-20 10:19:38,458 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_190_20032023.csv'  WHERE card_batch_id = 190
2023-03-20 10:19:38,476 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_198_20032023.csv'  WHERE card_batch_id = 198
2023-03-20 10:19:38,495 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_134_20032023.csv'  WHERE card_batch_id = 134
2023-03-20 10:19:38,514 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_210_20032023.csv'  WHERE card_batch_id = 210
2023-03-20 10:19:38,532 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_213_20032023.csv'  WHERE card_batch_id = 213
2023-03-20 10:19:38,552 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_120_20032023.csv'  WHERE card_batch_id = 120
2023-03-20 10:19:38,572 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_235_20032023.csv'  WHERE card_batch_id = 235
2023-03-20 10:19:38,592 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_240_20032023.csv'  WHERE card_batch_id = 240
2023-03-20 10:19:38,610 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_237_20032023.csv'  WHERE card_batch_id = 237
2023-03-20 10:19:38,628 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_64_20032023.csv'  WHERE card_batch_id = 64
2023-03-20 10:19:38,647 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_88_20032023.csv'  WHERE card_batch_id = 88
2023-03-20 10:19:38,665 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_241_20032023.csv'  WHERE card_batch_id = 241
2023-03-20 10:19:38,683 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_242_20032023.csv'  WHERE card_batch_id = 242
2023-03-20 10:19:38,701 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_249_20032023.csv'  WHERE card_batch_id = 249
2023-03-20 10:19:38,758 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_320_20032023.csv'  WHERE card_batch_id = 320
2023-03-20 10:19:38,778 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_312_20032023.csv'  WHERE card_batch_id = 312
2023-03-20 10:19:38,806 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_53_20032023.csv'  WHERE card_batch_id = 53
2023-03-20 10:19:38,826 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_151_20032023.csv'  WHERE card_batch_id = 151
2023-03-20 10:19:38,847 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_166_20032023.csv'  WHERE card_batch_id = 166
2023-03-20 10:19:38,865 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_170_20032023.csv'  WHERE card_batch_id = 170
2023-03-20 10:19:38,884 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_100_20032023.csv'  WHERE card_batch_id = 100
2023-03-20 10:19:38,904 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_307_20032023.csv'  WHERE card_batch_id = 307
2023-03-20 10:19:38,924 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_174_20032023.csv'  WHERE card_batch_id = 174
2023-03-20 10:19:38,942 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_197_20032023.csv'  WHERE card_batch_id = 197
2023-03-20 10:19:38,961 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_155_20032023.csv'  WHERE card_batch_id = 155
2023-03-20 10:19:38,980 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_186_20032023.csv'  WHERE card_batch_id = 186
2023-03-20 10:19:38,999 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_177_20032023.csv'  WHERE card_batch_id = 177
2023-03-20 10:19:39,017 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_38_20032023.csv'  WHERE card_batch_id = 38
2023-03-20 10:19:39,035 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_195_20032023.csv'  WHERE card_batch_id = 195
2023-03-20 10:19:39,054 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_204_20032023.csv'  WHERE card_batch_id = 204
2023-03-20 10:19:39,072 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_58_20032023.csv'  WHERE card_batch_id = 58
2023-03-20 10:19:39,091 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_247_20032023.csv'  WHERE card_batch_id = 247
2023-03-20 10:19:39,111 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_236_20032023.csv'  WHERE card_batch_id = 236
2023-03-20 10:19:39,130 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_73_20032023.csv'  WHERE card_batch_id = 73
2023-03-20 10:19:39,150 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_110_20032023.csv'  WHERE card_batch_id = 110
2023-03-20 10:19:39,169 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_83_20032023.csv'  WHERE card_batch_id = 83
2023-03-20 10:19:39,187 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_250_20032023.csv'  WHERE card_batch_id = 250
2023-03-20 10:19:39,206 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_319_20032023.csv'  WHERE card_batch_id = 319
2023-03-20 10:19:39,226 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_54_20032023.csv'  WHERE card_batch_id = 54
2023-03-20 10:19:39,244 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_125_20032023.csv'  WHERE card_batch_id = 125
2023-03-20 10:19:39,264 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_165_20032023.csv'  WHERE card_batch_id = 165
2023-03-20 10:19:39,285 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_119_20032023.csv'  WHERE card_batch_id = 119
2023-03-20 10:19:39,303 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_68_20032023.csv'  WHERE card_batch_id = 68
2023-03-20 10:19:39,321 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_105_20032023.csv'  WHERE card_batch_id = 105
2023-03-20 10:19:39,338 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_334_20032023.csv'  WHERE card_batch_id = 334
2023-03-20 10:19:39,357 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_321_20032023.csv'  WHERE card_batch_id = 321
2023-03-20 10:19:39,375 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_46_20032023.csv'  WHERE card_batch_id = 46
2023-03-20 10:19:39,395 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_121_20032023.csv'  WHERE card_batch_id = 121
2023-03-20 10:19:39,415 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_40_20032023.csv'  WHERE card_batch_id = 40
2023-03-20 10:19:39,434 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_146_20032023.csv'  WHERE card_batch_id = 146
2023-03-20 10:19:39,452 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_163_20032023.csv'  WHERE card_batch_id = 163
2023-03-20 10:19:39,471 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_230_20032023.csv'  WHERE card_batch_id = 230
2023-03-20 10:19:39,490 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_66_20032023.csv'  WHERE card_batch_id = 66
2023-03-20 10:19:39,509 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_129_20032023.csv'  WHERE card_batch_id = 129
2023-03-20 10:19:39,528 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_59_20032023.csv'  WHERE card_batch_id = 59
2023-03-20 10:19:39,546 INFO  [stdout] (default task-3) DBConnection.execute()  UPDATE card_batch SET file_url_download = 'CardProduction_310_20032023.csv'  WHERE card_batch_id = 310
2023-03-20 10:19:39,588 INFO  [stdout] (default task-3) executeGetLastID() INSERT INTO approval_requests (is_print_name,customer_category_id,card_id,card_program_id,kode_bpr,card_name,approval_type,created_approval,approval_status,request_reason,created_user_approval,kode_cabang,card_type_id,account_id) values (0,2,6524,1,'001','',6,'2023-03-20 10:19:39',0,'',2,'0350',1,39)
2023-03-20 10:19:39,595 INFO  [stdout] (default task-3) lastid='169'
2023-03-20 10:19:39,595 INFO  [stdout] (default task-3) 169
2023-03-20 10:19:39,603 INFO  [stdout] (default task-3) executeGetLastID() INSERT INTO userlogs (userid,masking,log_detail,module,ip,logtime) values (?,?,?,?,?,?)
2023-03-20 10:19:39,608 INFO  [stdout] (default task-3) Country : userid President : int|2
2023-03-20 10:19:39,608 INFO  [stdout] (default task-3) split0() int
2023-03-20 10:19:39,608 INFO  [stdout] (default task-3) split1() 2
2023-03-20 10:19:39,609 INFO  [stdout] (default task-3) Country : masking President : int|1
2023-03-20 10:19:39,609 INFO  [stdout] (default task-3) split0() int
2023-03-20 10:19:39,609 INFO  [stdout] (default task-3) split1() 1
2023-03-20 10:19:39,609 INFO  [stdout] (default task-3) Country : log_detail President : string|99351D0EE233B51A4F1685E932299B7AF85396A8892430DBBA0109480EB82BE60663CAA9F3B0B931D29367C0CF0AFF637548C751C31095CA5A99BA891C79BABE8E9B36963F2BD55057FFBB960AFFAF4C93286383C7DCADBE541B996130F0C00CD356E625D040B6D793EFB29001323C9EF086705CBAF900CB573
2023-03-20 10:19:39,609 INFO  [stdout] (default task-3) split0() string
2023-03-20 10:19:39,609 INFO  [stdout] (default task-3) split1() 99351D0EE233B51A4F1685E932299B7AF85396A8892430DBBA0109480EB82BE60663CAA9F3B0B931D29367C0CF0AFF637548C751C31095CA5A99BA891C79BABE8E9B36963F2BD55057FFBB960AFFAF4C93286383C7DCADBE541B996130F0C00CD356E625D040B6D793EFB29001323C9EF086705CBAF900CB573
2023-03-20 10:19:39,609 INFO  [stdout] (default task-3) Country : module President : string|Pengajuan Registrasi Kartu Nasabah
2023-03-20 10:19:39,609 INFO  [stdout] (default task-3) split0() string
2023-03-20 10:19:39,609 INFO  [stdout] (default task-3) split1() Pengajuan Registrasi Kartu Nasabah
2023-03-20 10:19:39,609 INFO  [stdout] (default task-3) Country : ip President : string|172.19.0.1
2023-03-20 10:19:39,609 INFO  [stdout] (default task-3) split0() string
2023-03-20 10:19:39,609 INFO  [stdout] (default task-3) split1() 172.19.0.1
2023-03-20 10:19:39,609 INFO  [stdout] (default task-3) Country : logtime President : timestamp2|2023-03-20 10:19:39
2023-03-20 10:19:39,609 INFO  [stdout] (default task-3) split0() timestamp2
2023-03-20 10:19:39,609 INFO  [stdout] (default task-3) split1() 2023-03-20 10:19:39
2023-03-20 10:19:39,609 INFO  [stdout] (default task-3) asd3() [userid, masking, log_detail, module, ip, logtime]
2023-03-20 10:19:39,609 INFO  [stdout] (default task-3) executeGetLastID() INSERT INTO userlogs (userid,masking,log_detail,module,ip,logtime) values (2,1,'99351D0EE233B51A4F1685E932299B7AF85396A8892430DBBA0109480EB82BE60663CAA9F3B0B931D29367C0CF0AFF637548C751C31095CA5A99BA891C79BABE8E9B36963F2BD55057FFBB960AFFAF4C93286383C7DCADBE541B996130F0C00CD356E625D040B6D793EFB29001323C9EF086705CBAF900CB573','Pengajuan Registrasi Kartu Nasabah','172.19.0.1','2023-03-20 10:19:39.609+00')
2023-03-20 10:19:39,609 INFO  [stdout] (default task-3) RETURNING *
2023-03-20 10:19:39,611 INFO  [stdout] (default task-3) lastid='8635'
2023-03-20 10:19:39,611 INFO  [stdout] (default task-3) MSG INSERT : 8635
2023-03-20 10:19:39,611 INFO  [stdout] (default task-3) DBConnection.execute() UPDATE users_web SET lastactivity=NOW(),lastlogid = 8635 WHERE  userid = 2
2023-03-20 10:19:39,717 INFO  [stdout] (default task-3) user id 2
2023-03-20 10:19:39,717 INFO  [stdout] (default task-3) real cfg /opt/jboss/wildfly/standalone/deployments/atm.war/WEB-INF/config_cms.ini
2023-03-20 10:19:39,718 INFO  [stdout] (default task-3)  db serv ******8.10.20 usr ****gres pas ****1234 nam ***_cms dbp **08
2023-03-20 10:19:39,726 INFO  [stdout] (default task-3) =================================================== checkActivity ==1
2023-03-20 10:19:39,727 INFO  [stdout] (default task-3) real cfg /opt/jboss/wildfly/standalone/deployments/atm.war/WEB-INF/config_cms.ini
2023-03-20 10:19:39,727 INFO  [stdout] (default task-3)  db serv ******8.10.20 usr ****gres pas ****1234 nam ***_cms dbp **08

Raw Text