log inbox mobile staging

                Never    
Java
       
2022-09-06 11:32:58,134 INFO  [async.individu.ReportService] (EJB default - 1) INCOMING -> {"api.auth":"2b3472cf8a91196a22e24e424f7a7cccc95a2bc2802402ce16eb8ba72369bf4f","report.signature":"3f85ba50b3b51f4de433873567612453a0ccaa7ae296f7f12ef6b320d3fa659a","search.date_by":"days","search.page":1,"trans.code":"TFR","trans.rek_id":"096C120FBA14BD95","user.id":"B08DF66E5DE945EA","mob.app_version":"98 - 4.6.0 - Redmi Note 8","api.lang":"ENG","user.last_login":"1662435099864","mob.os_type":1,"mob.os_version":30,"api.timestamp":"1662435176862","api.type":"report_transaction","api.version":"2.5.0"}
2022-09-06 11:32:58,135 INFO  [irvan.database.DatabaseConnection] (ForkJoinPool.commonPool-worker-4) prepareStatement: SELECT tablename FROM pg_tables WHERE schemaname='log_api' AND tablename=?
2022-09-06 11:32:58,136 INFO  [irvan.database.DatabaseConnection] (ForkJoinPool.commonPool-worker-4) prepareStatement: insert into log_api.log_202209_online ( param_request, api_type, api_timestamp, createdate, status_api )  values ( ? , ? , ? , CURRENT_TIMESTAMP, 0 )
2022-09-06 11:32:58,147 INFO  [api.individu.ApiReport] (ForkJoinPool.commonPool-worker-4) after saveLogRequestAPI() ApiReport() {"api.version":"2.5.0","user.id":"B08DF66E5DE945EA","api.timestamp":"1662435176862","mob.app_version":"98 - 4.6.0 - Redmi Note 8","mob.os_type":1,"trans.code":"TFR","search.date_by":"days","trans.rek_id":"096C120FBA14BD95","api.status":"000","api.datetable":"202209","api.lang":"ENG","api.auth":"2b3472cf8a91196a22e24e424f7a7cccc95a2bc2802402ce16eb8ba72369bf4f","search.page":1,"report.signature":"3f85ba50b3b51f4de433873567612453a0ccaa7ae296f7f12ef6b320d3fa659a","user.last_login":"1662435099864","mob.os_version":30,"api.type":"report_transaction","logid":"321"}
2022-09-06 11:32:58,147 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) get() api.channel
2022-09-06 11:32:58,149 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) get() type_trigger
2022-09-06 11:32:58,149 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) get() user.corp_code
2022-09-06 11:32:58,149 INFO  [api.ApiMain] (ForkJoinPool.commonPool-worker-4)
2022-09-06 11:32:58,149 INFO  [api.ApiMain] (ForkJoinPool.commonPool-worker-4) ===validasiParamApi===
2022-09-06 11:32:58,149 INFO  [api.ApiMain] (ForkJoinPool.commonPool-worker-4) isi js pas masuk validasiparamApi {"api.class":"ApiReport","api.version":"2.5.0","user.id":"B08DF66E5DE945EA","api.timestamp":"1662435176862","mob.app_version":"98 - 4.6.0 - Redmi Note 8","mob.os_type":1,"trans.code":"TFR","type_trigger":1,"search.date_by":"days","trans.rek_id":"096C120FBA14BD95","api.status":"000","api.datetable":"202209","user.corp_id":"-1","api.lang":"ENG","api.auth":"2b3472cf8a91196a22e24e424f7a7cccc95a2bc2802402ce16eb8ba72369bf4f","search.page":1,"api.channel":"8003","report.signature":"3f85ba50b3b51f4de433873567612453a0ccaa7ae296f7f12ef6b320d3fa659a","user.last_login":"1662435099864","mob.os_version":30,"api.type":"report_transaction","logid":"321"}
2022-09-06 11:32:58,149 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) getInt(JSONObject json, api.flag)
2022-09-06 11:32:58,149 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) get() api.log
2022-09-06 11:32:58,149 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) get() user.log
2022-09-06 11:32:58,149 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) get() trans.log
2022-09-06 11:32:58,149 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) get() mob.log
2022-09-06 11:32:58,149 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) get() api.flag
2022-09-06 11:32:58,149 INFO  [api.ApiMain] (ForkJoinPool.commonPool-worker-4) getDecryptJSON(json,user.id,true,true) with osType:1
2022-09-06 11:32:58,149 INFO  [api.ApiMain] (ForkJoinPool.commonPool-worker-4) Field value:B08DF66E5DE945EA
2022-09-06 11:32:58,149 INFO  [irvan.database.DatabaseConnection] (ForkJoinPool.commonPool-worker-4) prepareStatement: SELECT status_api FROM api_type_list WHERE api_type=?
2022-09-06 11:32:58,149 INFO  [api.ApiMain] (ForkJoinPool.commonPool-worker-4) isinya api status '1'
2022-09-06 11:32:58,149 INFO  [irvan.database.DatabaseConnection] (ForkJoinPool.commonPool-worker-4) prepareStatement: SELECT status_user FROM user_online WHERE user_id=? AND type_user=0 AND user_level=1 AND corp_id=-1
2022-09-06 11:32:58,149 INFO  [irvan.database.DatabaseIrvan] (ForkJoinPool.commonPool-worker-4) ProcessName:cek user nasabah
2022-09-06 11:32:58,150 INFO  [irvan.database.DatabaseConnection] (ForkJoinPool.commonPool-worker-4) prepareStatement: update log_api.log_202209_auth  set expired=current_timestamp + (10 * interval '1 minute'), lastupdate=now() where auth_id=?
2022-09-06 11:32:58,153 INFO  [api.ApiMain] (ForkJoinPool.commonPool-worker-4) after update record TABLE_LOG_AUTH
2022-09-06 11:32:58,154 INFO  [api.ApiMain] (ForkJoinPool.commonPool-worker-4) after update record TABLE_LOG_AUTH - 2
2022-09-06 11:32:58,154 INFO  [api.ApiMain] (ForkJoinPool.commonPool-worker-4) before checkLastLoginDbs()
2022-09-06 11:32:58,154 INFO  [api.ApiMain] (ForkJoinPool.commonPool-worker-4) after lastLoginDateAPI() 1662435099864
2022-09-06 11:32:58,154 INFO  [irvan.database.DatabaseConnection] (ForkJoinPool.commonPool-worker-4) prepareStatement: SELECT lastlogin_timestamp FROM user_online WHERE user_id=?
2022-09-06 11:32:58,154 INFO  [api.ApiMain] (ForkJoinPool.commonPool-worker-4) before js.put( API._API_STATUS, RC.APPROVE );
2022-09-06 11:32:58,154 INFO  [api.individu.ApiReport] (ForkJoinPool.commonPool-worker-4) doReportTransaction()
2022-09-06 11:32:58,154 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) get() search.user_account
2022-09-06 11:32:58,154 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) get() api.flag
2022-09-06 11:32:58,154 INFO  [api.ApiMain] (ForkJoinPool.commonPool-worker-4) getDecryptJSON(json,search.user_account,false,false) with osType:1
2022-09-06 11:32:58,154 INFO  [api.ApiMain] (ForkJoinPool.commonPool-worker-4) Field value:
2022-09-06 11:32:58,154 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) get() search.user_account
2022-09-06 11:32:58,154 INFO  [api.ApiMain] (ForkJoinPool.commonPool-worker-4) getEncryptString() user.id  osType:1
2022-09-06 11:32:58,154 INFO  [api.ApiMain] (ForkJoinPool.commonPool-worker-4) getEncryptString() user.id  osType:1
2022-09-06 11:32:58,154 INFO  [api.individu.ApiReport] (ForkJoinPool.commonPool-worker-4) serverSignature : B08DF66E5DE945EA|4l0n3@tLA$T|096C120FBA14BD95|TFR||1662435176862
2022-09-06 11:32:58,154 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) get() api.flag
2022-09-06 11:32:58,154 INFO  [api.ApiMain] (ForkJoinPool.commonPool-worker-4) getDecryptJSON(json,trans.rek_id,true,true) with osType:1
2022-09-06 11:32:58,154 INFO  [api.ApiMain] (ForkJoinPool.commonPool-worker-4) Field value:096C120FBA14BD95
2022-09-06 11:32:58,155 INFO  [irvan.database.DatabaseConnection] (ForkJoinPool.commonPool-worker-4) prepareStatement:  SELECT  namabank AS dest_bank_name, amount, fee, note, dest_email AS email,  list.ref_number AS ref_number, type_rutin, trans_status, dest_code, list.rc_detail,  dest_code_name AS dest_detail,  code.trans_name_eng AS trans_name, pgp_sym_decrypt( decode( sender_no, 'hex' )::bytea, '1Rv@nr@B1ull@h' ) as sender_no, pgp_sym_decrypt( decode( sender_name, 'hex' )::bytea, '1Rv@nr@B1ull@h' ) as sender_name,  CASE WHEN code.trans_code = 'VTR' THEN pgp_sym_decrypt ( decode( ma.account_number, 'hex' ) :: bytea, '1Rv@nr@B1ull@h' ) ELSE pgp_sym_decrypt ( decode( dest_no, 'hex' ) :: bytea, '1Rv@nr@B1ull@h' )  END AS dest_no,  CASE WHEN code.trans_code = 'VTR' THEN m.nama ELSE pgp_sym_decrypt ( decode( dest_name, 'hex' ) :: bytea, '1Rv@nr@B1ull@h' ) END AS dest_name,  list.createdate AS createdate,  list.trans_list_id as trans_list_id, ref_number_service,  code.trans_code AS trans_code, discount,  list.status_read AS read, now() as retrieve_time  FROM transaksi_list list  LEFT JOIN transaksi_code code ON code.trans_id = list.trans_id  LEFT JOIN bank_code bank ON CAST(bank.kodebank AS int)=list.dest_code  LEFT JOIN virtual_transfer_list vtl ON list.trans_list_id = vtl.trans_list_id AND vtl.status = 3  LEFT JOIN merchants m ON m.code=vtl.merchant_code  LEFT JOIN merchant_account ma on m.merchant_id = ma.merchant_account_id  WHERE user_id=? AND rekening_id=? AND (trans_status=1 OR trans_status=0 OR trans_status=2) AND show_inbox=true  AND (code.trans_code='TFR' OR code.trans_code='TFB' OR code.trans_code='TFO' OR code.trans_code='VTR') AND CASE WHEN code.trans_code = 'VTR' THEN vtl.status IS NOT NULL ELSE 1 = 1 END  ORDER BY trans_list_id DESC  limit 10 offset 0
2022-09-06 11:32:58,409 INFO  [api.ApiMain] (ForkJoinPool.commonPool-worker-4) ====> setResponseJSON
2022-09-06 11:32:58,409 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) getInt(JSONObject json, api.flag)
2022-09-06 11:32:58,409 INFO  [irvan.database.DatabaseConnection] (ForkJoinPool.commonPool-worker-4) prepareStatement: SELECT eng FROM response_message WHERE rc=?
2022-09-06 11:32:58,409 INFO  [api.ApiMain] (ForkJoinPool.commonPool-worker-4) rc=000
2022-09-06 11:32:58,409 INFO  [api.ApiMain] (ForkJoinPool.commonPool-worker-4) resultNotif : 'Success'
2022-09-06 11:32:58,409 INFO  [irvan.database.DatabaseConnection] (ForkJoinPool.commonPool-worker-4) prepareStatement: update log_api.log_202209_online set param_response=?, rc=?, rc_message=?, rc_detail=?, rc_category=?, status_api=1,auth_id=?, api_timestamp=?, userid=?, corp_id=?, request_temp_id=?, api_flag=?,trans_flag=?, trans_code=?, lastupdate=now() where logid=?
2022-09-06 11:32:58,409 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) getLong(JSONObject json, request_temp_id)
2022-09-06 11:32:58,409 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) getInt(JSONObject json, api.flag)
2022-09-06 11:32:58,409 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) getInt(JSONObject json, trans.flag)
2022-09-06 11:32:58,433 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) get() trans.log
2022-09-06 11:32:58,433 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) get() user.log
2022-09-06 11:32:58,433 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) get() mob.log
2022-09-06 11:32:58,433 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) getLong(JSONObject json, key=trans.log_id, longDefault=-1 )
2022-09-06 11:32:58,433 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) get() mob.log
2022-09-06 11:32:58,433 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) get() user.log
2022-09-06 11:32:58,433 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) get() trans.log
2022-09-06 11:32:58,433 WARNING [irvan.utility.JSON] (ForkJoinPool.commonPool-worker-4) get() trans.log
2022-09-06 11:32:58,434 INFO  [async.individu.ReportService] (EJB default - 1) OUTGOING <- {"api.lang":"ENG","api.auth":"2b3472cf8a91196a22e24e424f7a7cccc95a2bc2802402ce16eb8ba72369bf4f","api.msg":"Success","api.timestamp":"1662435178409","api.status":"000","report.transaction":[{"sender_no":"0110048483","ref_number_service":"BDILSR202207190001000041","date":"2022-07-19 18:05:29","note":"Test fee","ref_number":"005151190722000022","dest_detail":"BANK NISP","amount":"2000000","trans_code":"TFO","read":"0","retrieve_time":"2022-09-06 11:32:58.155264+08","fee":"0","trans_name":"Transfer Bank Other","discount":"0","sender_name":"Ahmad Sahal","dest_bank_name":"BANK NISP","type":"Pay Now","dest_no":"10800042151","dest_code":"28","dest_name":"MEIRANTY NANCY GIROTH","id":"A836CDE827811286","email":"","trans_status":"1"},{"sender_no":"0110048483","ref_number_service":"","date":"2022-07-05 11:29:43","note":"","ref_number":"","dest_detail":"BANK NISP","amount":"200000","trans_code":"TFO","read":"0","retrieve_time":"2022-09-06 11:32:58.155264+08","fee":"0","trans_name":"Transfer Bank Other","discount":"0","sender_name":"Ahmad Sahal","dest_bank_name":"BANK NISP","type":"Pay Now","dest_no":"10800042151","dest_code":"28","dest_name":"MEIRANTY NANCY GIROTH","id":"D5D7FC31C1F3DAAB","email":"","trans_status":"0"},{"sender_no":"0110048483","ref_number_service":"202206290110048483","date":"2022-06-29 17:29:15","note":"Test ke bank lain via bifast","ref_number":"004314290622000015","dest_detail":"BANK NISP","amount":"1000098","trans_code":"TFO","read":"0","retrieve_time":"2022-09-06 11:32:58.155264+08","fee":"0","trans_name":"Transfer Bank Other","discount":"0","sender_name":"Ahmad Sahal","dest_bank_name":"BANK NISP","type":"Pay Now","dest_no":"10800042151","dest_code":"28","dest_name":"MEIRANTY NANCY GIROTH","id":"B7208B541FDC8576","email":"","trans_status":"0"},{"sender_no":"0110048483","ref_number_service":"BDILSR202206290001000021","date":"2022-06-29 17:13:56","note":"Test bca via bifast","ref_number":"001679290622000014","dest_detail":"BANK CENTRAL ASIA","amount":"1000099","trans_code":"TFB","read":"1","retrieve_time":"2022-09-06 11:32:58.155264+08","fee":"0","trans_name":"Transfer Bank","discount":"0","sender_name":"Ahmad Sahal","dest_bank_name":"BANK CENTRAL ASIA","type":"Pay Now","dest_no":"0951102384","dest_code":"14","dest_name":"CENAIDJA DEFAULT","id":"50CD47C45D203156","email":"","trans_status":"1"},{"sender_no":"0110048483","ref_number_service":"","date":"2022-06-29 16:03:50","note":"Test 1","ref_number":"1656489829954","dest_detail":"BANK UOB INDONESIA, PT","amount":"5000000","trans_code":"TFO","read":"0","retrieve_time":"2022-09-06 11:32:58.155264+08","fee":"0","trans_name":"Transfer Bank Other","discount":"0","sender_name":"Ahmad Sahal","dest_bank_name":"BANK UOB INDONESIA, PT","type":"Pay Now","dest_no":"4043710359","dest_code":"23","dest_name":"RENNY INDRA","id":"3C4C6F5409377FC3","email":"","trans_status":"2"},{"sender_no":"0110048483","ref_number_service":"202206240110048483","date":"2022-06-24 17:12:05","note":"","ref_number":"003441240622000027","dest_detail":"BANK NISP","amount":"200000","trans_code":"TFO","read":"0","retrieve_time":"2022-09-06 11:32:58.155264+08","fee":"0","trans_name":"Transfer Bank Other","discount":"0","sender_name":"Ahmad Sahal","dest_bank_name":"BANK NISP","type":"Pay Now","dest_no":"10800042151","dest_code":"28","dest_name":"MEIRANTY NANCY GIROTH","id":"0BDAB78AC6312E39","email":"","trans_status":"0"},{"sender_no":"0110048483","ref_number_service":"202206240110048483","date":"2022-06-24 17:04:00","note":"","ref_number":"000548240622000026","dest_detail":"BANK NISP","amount":"200000","trans_code":"TFO","read":"0","retrieve_time":"2022-09-06 11:32:58.155264+08","fee":"0","trans_name":"Transfer Bank Other","discount":"0","sender_name":"Ahmad Sahal","dest_bank_name":"BANK NISP","type":"Pay Now","dest_no":"10800042151","dest_code":"28","dest_name":"MEIRANTY NANCY GIROTH","id":"491DB89913935DB2","email":"","trans_status":"1"},{"sender_no":"0110048483","ref_number_service":"202206240110048483","date":"2022-06-24 16:42:42","note":"","ref_number":"004673240622000025","dest_detail":"BANK NISP","amount":"200000","trans_code":"TFO","read":"0","retrieve_time":"2022-09-06 11:32:58.155264+08","fee":"0","trans_name":"Transfer Bank Other","discount":"0","sender_name":"Ahmad Sahal","dest_bank_name":"BANK NISP","type":"Pay Now","dest_no":"10800042151","dest_code":"28","dest_name":"MEIRANTY NANCY GIROTH","id":"D136817E1F85AD48","email":"","trans_status":"1"},{"sender_no":"0110048483","ref_number_service":"Ahmad Sahal","date":"2022-06-24 15:56:20","note":"","ref_number":"004667200000006360","dest_detail":"BPR LESTARI BALI","amount":"200000","trans_code":"TFR","read":"0","retrieve_time":"2022-09-06 11:32:58.155264+08","fee":"0","trans_name":"Transfer Antar Rekening","discount":"0","sender_name":"Ahmad Sahal","dest_bank_name":"BPR LESTARI BALI","type":"Pay Now","dest_no":"0110032212","dest_code":"905","dest_name":"ANAK AGUNG SAGUNG ALIT DWIJAYANTI","id":"C580EB03FC3922E8","email":"","trans_status":"1"},{"sender_no":"0110048483","ref_number_service":"202206240110048483","date":"2022-06-24 15:43:34","note":"","ref_number":"004658240622000009","dest_detail":"BANK NISP","amount":"200000","trans_code":"TFO","read":"0","retrieve_time":"2022-09-06 11:32:58.155264+08","fee":"0","trans_name":"Transfer Bank Other","discount":"0","sender_name":"Ahmad Sahal","dest_bank_name":"BANK NISP","type":"Pay Now","dest_no":"10800042151","dest_code":"28","dest_name":"MEIRANTY NANCY GIROTH","id":"393B916994EE1D03","email":"","trans_status":"1"}],"error":"[ACC] ","api.signature":"ef0761e7650d670e2ee6203c1a080db3ceb4fb40af0cd85044c2b6f6861589e3"}

Raw Text