2022-09-06 03:28:28,607 INFO  [async.individu.ReportService] (EJB default - 1) INCOMING -> {"api.auth":"ffe0c67de29efd97372c02837c7fcf3004eda708fd9fcade76ba7463aea2cdcd","report.signature":"ad4c5ce465e2e5abe18dd9fab32b4342e5cd05362380c8a8cf22e922b070801c","search.date_by":"days","search.page":1,"trans.code":"TFR","trans.rek_id":"81253C232367C0EB","user.id":"C7A65842B4E26C6F","mob.app_version":"97 - 4.6.0 - Redmi Note 8","api.lang":"IND","user.last_login":"1662434890246","mob.os_type":1,"mob.os_version":30,"api.timestamp":"1662434942616","api.type":"report_transaction","api.version":"2.5.0"}
2022-09-06 03:28:28,607 INFO  [irvan.database.DatabaseConnection] (Thread-866) prepareStatement: SELECT tablename FROM pg_tables WHERE schemaname='log_api' AND tablename=?
2022-09-06 03:28:28,615 INFO  [irvan.database.DatabaseConnection] (Thread-866) prepareStatement: insert into log_api.log_202209_online ( param_request, api_type, api_timestamp, createdate, status_api )  values ( ? , ? , ? , CURRENT_TIMESTAMP, 0 )
2022-09-06 03:28:28,628 INFO  [api.individu.ApiReport] (Thread-866) after saveLogRequestAPI() ApiReport() {"api.version":"2.5.0","user.id":"C7A65842B4E26C6F","api.timestamp":"1662434942616","mob.app_version":"97 - 4.6.0 - Redmi Note 8","mob.os_type":1,"trans.code":"TFR","search.date_by":"days","trans.rek_id":"81253C232367C0EB","api.status":"000","api.datetable":"202209","api.lang":"IND","api.auth":"ffe0c67de29efd97372c02837c7fcf3004eda708fd9fcade76ba7463aea2cdcd","search.page":1,"report.signature":"ad4c5ce465e2e5abe18dd9fab32b4342e5cd05362380c8a8cf22e922b070801c","user.last_login":"1662434890246","mob.os_version":30,"api.type":"report_transaction","logid":"342"}
2022-09-06 03:28:28,628 WARNING [irvan.utility.JSON] (Thread-866) get() api.channel
2022-09-06 03:28:28,628 WARNING [irvan.utility.JSON] (Thread-866) get() type_trigger
2022-09-06 03:28:28,628 WARNING [irvan.utility.JSON] (Thread-866) get() user.corp_code
2022-09-06 03:28:28,628 INFO  [api.ApiMain] (Thread-866)
2022-09-06 03:28:28,628 INFO  [api.ApiMain] (Thread-866) ===validasiParamApi===
2022-09-06 03:28:28,628 INFO  [api.ApiMain] (Thread-866) isi js pas masuk validasiparamApi {"api.class":"ApiReport","api.version":"2.5.0","user.id":"C7A65842B4E26C6F","api.timestamp":"1662434942616","mob.app_version":"97 - 4.6.0 - Redmi Note 8","mob.os_type":1,"trans.code":"TFR","type_trigger":1,"search.date_by":"days","trans.rek_id":"81253C232367C0EB","api.status":"000","api.datetable":"202209","user.corp_id":"-1","api.lang":"IND","api.auth":"ffe0c67de29efd97372c02837c7fcf3004eda708fd9fcade76ba7463aea2cdcd","search.page":1,"api.channel":"8003","report.signature":"ad4c5ce465e2e5abe18dd9fab32b4342e5cd05362380c8a8cf22e922b070801c","user.last_login":"1662434890246","mob.os_version":30,"api.type":"report_transaction","logid":"342"}
2022-09-06 03:28:28,628 WARNING [irvan.utility.JSON] (Thread-866) getInt(JSONObject json, api.flag)
2022-09-06 03:28:28,628 WARNING [irvan.utility.JSON] (Thread-866) get() api.log
2022-09-06 03:28:28,628 WARNING [irvan.utility.JSON] (Thread-866) get() user.log
2022-09-06 03:28:28,628 WARNING [irvan.utility.JSON] (Thread-866) get() trans.log
2022-09-06 03:28:28,628 WARNING [irvan.utility.JSON] (Thread-866) get() mob.log
2022-09-06 03:28:28,628 WARNING [irvan.utility.JSON] (Thread-866) get() api.flag
2022-09-06 03:28:28,628 INFO  [api.ApiMain] (Thread-866) getDecryptJSON(json,user.id,true,true) with osType:1
2022-09-06 03:28:28,628 INFO  [api.ApiMain] (Thread-866) Field value:C7A65842B4E26C6F
2022-09-06 03:28:28,628 INFO  [irvan.database.DatabaseConnection] (Thread-866) prepareStatement: SELECT status_api FROM api_type_list WHERE api_type=?
2022-09-06 03:28:28,636 INFO  [api.ApiMain] (Thread-866) isinya api status '1'
2022-09-06 03:28:28,636 INFO  [irvan.database.DatabaseConnection] (Thread-866) 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 03:28:28,636 INFO  [irvan.database.DatabaseIrvan] (Thread-866) ProcessName:cek user nasabah
2022-09-06 03:28:28,684 INFO  [irvan.database.DatabaseConnection] (Thread-866) prepareStatement: update log_api.log_202209_auth  set expired=current_timestamp + (10 * interval '1 minute'), lastupdate=now() where auth_id=?
2022-09-06 03:28:28,695 INFO  [api.ApiMain] (Thread-866) after update record TABLE_LOG_AUTH
2022-09-06 03:28:28,751 INFO  [api.ApiMain] (Thread-866) after update record TABLE_LOG_AUTH - 2
2022-09-06 03:28:28,751 INFO  [api.ApiMain] (Thread-866) before checkLastLoginDbs()
2022-09-06 03:28:28,751 INFO  [api.ApiMain] (Thread-866) after lastLoginDateAPI() 1662434890246
2022-09-06 03:28:28,751 INFO  [irvan.database.DatabaseConnection] (Thread-866) prepareStatement: SELECT lastlogin_timestamp FROM user_online WHERE user_id=?
2022-09-06 03:28:28,754 INFO  [api.ApiMain] (Thread-866) before js.put( API._API_STATUS, RC.APPROVE );
2022-09-06 03:28:28,754 INFO  [api.individu.ApiReport] (Thread-866) doReportTransaction()
2022-09-06 03:28:28,754 WARNING [irvan.utility.JSON] (Thread-866) get() search.user_account
2022-09-06 03:28:28,754 WARNING [irvan.utility.JSON] (Thread-866) get() api.flag
2022-09-06 03:28:28,754 INFO  [api.ApiMain] (Thread-866) getDecryptJSON(json,search.user_account,false,false) with osType:1
2022-09-06 03:28:28,754 INFO  [api.ApiMain] (Thread-866) Field value:
2022-09-06 03:28:28,754 WARNING [irvan.utility.JSON] (Thread-866) get() search.user_account
2022-09-06 03:28:28,754 INFO  [api.ApiMain] (Thread-866) getEncryptString() user.id  osType:1
2022-09-06 03:28:28,754 INFO  [api.ApiMain] (Thread-866) getEncryptString() user.id  osType:1
2022-09-06 03:28:28,754 INFO  [api.individu.ApiReport] (Thread-866) serverSignature : C7A65842B4E26C6F|4l0n3@tLA$T|81253C232367C0EB|TFR||1662434942616
2022-09-06 03:28:28,754 WARNING [irvan.utility.JSON] (Thread-866) get() api.flag
2022-09-06 03:28:28,754 INFO  [api.ApiMain] (Thread-866) getDecryptJSON(json,trans.rek_id,true,true) with osType:1
2022-09-06 03:28:28,754 INFO  [api.ApiMain] (Thread-866) Field value:81253C232367C0EB
2022-09-06 03:28:28,754 INFO  [irvan.database.DatabaseConnection] (Thread-866) 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_ind 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 03:28:28,763 INFO  [irvan.database.DatabaseConnection] (Thread-866) <error> Error: get reportorg.postgresql.util.PSQLException: ERROR: invalid input syntax for type integer: "123r"
2022-09-06 03:28:28,763 INFO  [api.ApiMain] (Thread-866) ====> setResponseJSON
2022-09-06 03:28:28,763 WARNING [irvan.utility.JSON] (Thread-866) getInt(JSONObject json, api.flag)
2022-09-06 03:28:28,763 INFO  [irvan.database.DatabaseConnection] (Thread-866) prepareStatement: SELECT ind FROM response_message WHERE rc=?
2022-09-06 03:28:28,763 INFO  [api.ApiMain] (Thread-866) rc=153
2022-09-06 03:28:28,769 INFO  [api.ApiMain] (Thread-866) resultNotif : 'Data transaksi tidak ditemukan'
2022-09-06 03:28:28,769 INFO  [irvan.database.DatabaseConnection] (Thread-866) 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 03:28:28,769 WARNING [irvan.utility.JSON] (Thread-866) getLong(JSONObject json, request_temp_id)
2022-09-06 03:28:28,769 WARNING [irvan.utility.JSON] (Thread-866) getInt(JSONObject json, api.flag)
2022-09-06 03:28:28,769 WARNING [irvan.utility.JSON] (Thread-866) getInt(JSONObject json, trans.flag)
2022-09-06 03:28:28,778 WARNING [irvan.utility.JSON] (Thread-866) get() trans.log
2022-09-06 03:28:28,778 WARNING [irvan.utility.JSON] (Thread-866) get() user.log
2022-09-06 03:28:28,778 WARNING [irvan.utility.JSON] (Thread-866) get() mob.log
2022-09-06 03:28:28,778 WARNING [irvan.utility.JSON] (Thread-866) getLong(JSONObject json, key=trans.log_id, longDefault=-1 )
2022-09-06 03:28:28,778 WARNING [irvan.utility.JSON] (Thread-866) get() mob.log
2022-09-06 03:28:28,778 WARNING [irvan.utility.JSON] (Thread-866) get() user.log
2022-09-06 03:28:28,778 WARNING [irvan.utility.JSON] (Thread-866) get() trans.log
2022-09-06 03:28:28,778 WARNING [irvan.utility.JSON] (Thread-866) get() trans.log
2022-09-06 03:28:28,778 INFO  [api.ApiMain] (Thread-866) ApiMain.setResponseJSON() on invalidStatus 153
2022-09-06 03:28:28,779 INFO  [async.individu.ReportService] (EJB default - 1) OUTGOING <- {"api.lang":"IND","api.auth":"ffe0c67de29efd97372c02837c7fcf3004eda708fd9fcade76ba7463aea2cdcd","api.msg":"Data transaksi tidak ditemukan","api.timestamp":"1662434908763","api.status":"153","report.transaction":[],"error":"[ACC] ","api.signature":"0696ae880f3daca52615a9b6e0e255b2c93e96b361f75e831d597b2559f24ad7"}