Untitled

                Never    
Java
       
2022-07-14 14:57:52,806 INFO  [stdout] (default task-3) details-new-account
2022-07-14 14:57:52,807 INFO  [stdout] (default task-3) prepareStatement: select reg_id, created_at, updated_at, status, gelar, tempat_lahir, tgl_lahir, agama, pendidikan_terakhir, status_perkawinan,  alamat_ktp, rt_ktp, rw_ktp, kodepos_ktp, status_tempat_tinggal, alamat_domisili, rt_domisili,  rt_domisili, rw_domisili, kodepos_domisili, pekerjaan, jabatan, nama_tempat_kerja, alamat_tempat_kerja,  bidang_usaha, penghasilan_bulanan, sumber_penghasilan, tujuan_buka_rekening, tujuan_pemakaian_dana,  kelurahan_ktp, kecamatan_ktp, kota_kab_ktp, propinsi_ktp, kelurahan_domisili,  kecamatan_domisili, kota_kab_domisili, propinsi_domisili, jenis_kelamin  from newaccount.account_registration as acc where reg_id = '726'
2022-07-14 14:57:52,808 INFO  [stdout] (default task-3) prepareStatement: select reg_id, created_at, updated_at, status, jenis_kelamin, pgp_sym_decrypt( decode( nik, 'hex' )::bytea, '1Rv@nr@B1ull@h' ) as nik,  pgp_sym_decrypt( decode( email, 'hex' )::bytea, '1Rv@nr@B1ull@h' ) as email,  pgp_sym_decrypt( decode( nohp, 'hex' )::bytea, '1Rv@nr@B1ull@h' ) as nohp,  pgp_sym_decrypt( decode( nama, 'hex' )::bytea, '1Rv@nr@B1ull@h' ) as nama,  gelar, tempat_lahir, tgl_lahir, agama, pendidikan_terakhir, status_perkawinan,  pgp_sym_decrypt( decode( nama_ibu, 'hex' )::bytea, '1Rv@nr@B1ull@h' ) as nama_ibu,  alamat_ktp, rt_ktp, rw_ktp, kodepos_ktp, status_tempat_tinggal, alamat_domisili, rt_domisili,  rt_domisili, rw_domisili, kodepos_domisili, pekerjaan, jabatan, nama_tempat_kerja, alamat_tempat_kerja,  bidang_usaha, penghasilan_bulanan, sumber_penghasilan, tujuan_buka_rekening, tujuan_pemakaian_dana,  file_ktp, file_selfie_only, file_selfie_w_ktp, file_selfie_npwp,file_ttd, vc_code,file_formulir,   latitude, longitude,third_party_kyc_result,  pgp_sym_decrypt( decode( reg_username, 'hex' )::bytea, '1Rv@nr@B1ull@h' ) as reg_username,  fk_user, fcm_token, pgp_sym_decrypt( decode( npwp, 'hex' )::bytea, '1Rv@nr@B1ull@h' ) as npwp,  kelurahan_ktp, kecamatan_ktp, kota_kab_ktp, propinsi_ktp, kelurahan_domisili,  kecamatan_domisili, kota_kab_domisili, propinsi_domisili,  pend.nama_pendidikan_terakhir, agama.nama_agama, perkawinan.nama_status_perkawinan,  pekerjaan.nama_pekerjaan, jabatan.nama_jabatan,bidang.nama_bidang_usaha,  penghasilan.nama_penghasilan_bulanan, dana.nama_sumber_penghasilan,tujuan.nama_tujuan_buka_rekening, penggunaan.nama_tujuan_penggunaan_dana,kec_ktp.nama_kecamatan_ktp, kel_ktp.nama_kelurahan_ktp,  kota_ktp.nama_kota_kab_ktp, prov_ktp.nama_propinsi_ktp, kelurahan_dom.nama_kelurahan_domisili,  kota_domisili.nama_kota_kab_domisili, prov_domisili.nama_propinsi_domisili, kec_domisili.nama_kecamatan_domisili, kelamin.nama_jenis_kelamin, tempat_lahir.nama_tempat_lahir, status_tempat_tinggal.nama_status_tempat_tinggal,   note_reject, updated_at_video_call, updated_by_video_call, updated_at_core, updated_by_core,  other_pekerjaan, other_jabatan, other_bidang_usaha, other_sumber_dana, other_tujuan_pembukaan, other_tujuan_penggunaan,  up_user.nama_updated_by_video_call, core_user.nama_updated_by_core   from (select * from  newaccount.account_registration where reg_id ='726') as acc  left join (select nama as nama_pendidikan_terakhir, data_id, kode, status_data from cif.pendidikan_terakhir where kode ='07') as pend on cast(  pend.kode as text )= acc.pendidikan_terakhir   left join (select nama as nama_agama, data_id, kode, status_data  from cif.agama where kode = '1') as agama on cast ( agama.kode  as text )= acc.agama  left join (select nama as nama_status_perkawinan, data_id, kode, status_data  from cif.status_perkawinan where kode = '1' ) as perkawinan on cast( perkawinan.kode as text )= acc.status_perkawinan  left join (select nama as nama_pekerjaan, data_id, kode, status_data  from cif.pekerjaan where kode = '99') as pekerjaan on cast (pekerjaan.kode as text)  = acc.pekerjaan  left join ( select nama as nama_jabatan, data_id, kode, status_data  from cif.pangkat_pekerjaan where kode = '99') as jabatan  on cast ( jabatan.kode as text) = acc.jabatan left join ( select nama as nama_bidang_usaha, data_id, kode, status_data  from cif.bidang_usaha where kode ='9990' ) as bidang on cast (bidang.kode as text) = acc.bidang_usaha  left join (select nama as nama_penghasilan_bulanan, data_id, kode,status_data from cif.penghasilan where kode = '07') as penghasilan on cast( penghasilan.kode as text) = acc.penghasilan_bulanan  left join (select nama as nama_sumber_penghasilan, data_id, kode, status_data  from cif.sumber_dana where kode = '99') as dana on cast( dana.kode as text) = acc.sumber_penghasilan  left join (select nama as nama_tujuan_buka_rekening, data_id, kode,status_data  from cif.tujuan_pembukaan where kode = '99') as tujuan on cast( tujuan.kode as text) = acc.tujuan_buka_rekening  left join (select  nama as nama_tujuan_penggunaan_dana, data_id, kode,status_data  from cif.penggunaan_dana where kode = '99' ) as penggunaan on cast( penggunaan.kode as text) = acc.tujuan_pemakaian_dana  left join (select nama as nama_kecamatan_ktp,id_kec, id_kab, kode_core   from db_daerah.kecamatan where id_kec = '320807' ) as kec_ktp on cast( kec_ktp.id_kec as text) = acc.kecamatan_ktp  left join (select nama as nama_kelurahan_ktp, id_kel, id_kec, kode_core  from db_daerah.kelurahan where id_kel = '3208072018' ) as kel_ktp on cast( kel_ktp.id_kel as text) = acc.kelurahan_ktp  left join ( select nama as nama_kota_kab_ktp, id_kab, id_prov  from db_daerah.kabupaten where id_kab = '3208' ) as kota_ktp on cast( kota_ktp.id_kab as text)= acc.kota_kab_ktp  left join (select nama as nama_propinsi_ktp, id_prov, kode_core  from db_daerah.provinsi where id_prov = '32' ) as prov_ktp on cast ( prov_ktp.id_prov as text)= acc.propinsi_ktp  left join (select nama as  nama_kelurahan_domisili, id_kel, id_kec, kode_core  from db_daerah.kelurahan where id_kel = '3208072018') as kelurahan_dom on cast(  kelurahan_dom.id_kel as text) = acc.kelurahan_domisili  left join ( select nama as nama_kota_kab_domisili, id_kab, id_prov  from db_daerah.kabupaten where id_kab = '3208') as kota_domisili on   cast ( kota_domisili.id_kab as text)= acc.kota_kab_domisili  left join (select nama as nama_kecamatan_domisili,id_kec, id_kab, kode_core   from db_daerah.kecamatan where id_kec = '320807') as kec_domisili on cast( kec_domisili.id_kec as text) = acc.kecamatan_domisili  left join (select nama as nama_propinsi_domisili, id_prov, kode_core  from db_daerah.provinsi where id_prov = '32') as prov_domisili on cast (prov_domisili.id_prov as text) = acc.propinsi_domisili   left join (select nama as nama_jenis_kelamin, kode, data_id  from cif.jenis_kelamin where kode = 'L') as kelamin on cast (kelamin.kode as text ) = acc.jenis_kelamin  left join (select nama as nama_tempat_lahir, kode   from cif.tempat_lahir where kode = '0117') as tempat_lahir on cast(tempat_lahir.kode as text ) = acc.tempat_lahir  left join (select nama as nama_status_tempat_tinggal, kode  from cif.status_tempat_tinggal where kode = '03' ) as status_tempat_tinggal on cast(status_tempat_tinggal.kode as text ) = acc.status_tempat_tinggal  left join ( select user_id, nama_user as nama_updated_by_video_call from system_user ) as up_user on up_user.user_id = acc.updated_by_video_call  left join ( select user_id, nama_user as nama_updated_by_core from system_user ) as core_user on core_user.user_id = acc.updated_by_core   
2022-07-14 14:57:52,890 INFO  [stdout] (default task-3) prepareStatement: select setting_value from settings where setting_id='URL_VCALL_API' 
2022-07-14 14:57:52,891 INFO  [stdout] (default task-3) prepareStatement: select setting_value from settings where setting_id='USR_VCALL_API' 
2022-07-14 14:57:52,892 INFO  [stdout] (default task-3) prepareStatement: select setting_value from settings where setting_id='PWD_VCALL_API' 
2022-07-14 14:57:53,382 INFO  [stdout] (default task-3) 
2022-07-14 14:57:53,382 INFO  [stdout] (default task-3) Sending 'POST' request to URL : http://172.30.0.6:8056/token
2022-07-14 14:57:53,382 INFO  [stdout] (default task-3) Post parameters : username=bbw&password=-Soulo]dzLT2T>K
2022-07-14 14:57:53,382 INFO  [stdout] (default task-3) Response Code : 200
2022-07-14 14:57:53,383 INFO  [stdout] (default task-3) result : {"access_token":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiJiYnciLCJleHAiOjE2NTc3ODM2NzN9.woTxWenDy9swtEn3l5dHQf6j2m_I4bNUZ4ke-L1oAcY","token_type":"bearer"}
2022-07-14 14:57:53,383 INFO  [stdout] (default task-3) Header : sun.net.www.protocol.http.HttpURLConnection:http://172.30.0.6:8056/vcall-url
2022-07-14 14:57:53,383 INFO  [stdout] (default task-3) Authorization : Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiJiYnciLCJleHAiOjE2NTc3ODM2NzN9.woTxWenDy9swtEn3l5dHQf6j2m_I4bNUZ4ke-L1oAcY
2022-07-14 14:57:53,385 INFO  [stdout] (default task-3) 
2022-07-14 14:57:53,385 INFO  [stdout] (default task-3) Sending 'POST' request to URL : http://172.30.0.6:8056/vcall-url
2022-07-14 14:57:53,385 INFO  [stdout] (default task-3) Post parameters : {"filename": "5d6c10486a723ea9725a7f9e2ddff825c300"}
2022-07-14 14:57:53,385 INFO  [stdout] (default task-3) Response Code : 200
2022-07-14 14:57:53,385 INFO  [stdout] (default task-3) result : {"url":"https://minio.bprlestari.com/vcall/5d6c10486a723ea9725a7f9e2ddff825c300.mp4?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=minio-vcall%2F20220714%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20220714T065753Z&X-Amz-Expires=7200&X-Amz-SignedHeaders=host&X-Amz-Signature=2cf55f24158dce84473aac06065493e5fdac3c93ce8650ca2d47e2bd1b6cef15"}
2022-07-14 14:57:53,510 INFO  [stdout] (default task-3) myname : <ControllerApproval> 
2022-07-14 14:57:53,510 INFO  [stdout] (default task-3) prepareStatement: select setting_value from settings where setting_id = 'PATH_RECORDED_VIDEO'
2022-07-14 14:57:53,524 INFO  [stdout] (default task-3) path video https://vc08.bprlestari.com
2022-07-14 14:58:54,141 INFO  [async.newaccount.ServletHelper] (default task-3) getFormData api.timestamp
2022-07-14 14:58:54,141 INFO  [async.newaccount.ServletHelper] (default task-3) getFormData user.log
2022-07-14 14:58:54,144 INFO  [async.newaccount.ServletHelper] (default task-3) File /opt/uploads/KTP/ktp_BC43061788063510_1657781521682.tmp saved successfully
2022-07-14 14:58:54,149 INFO  [async.newaccount.ServletHelper] (default task-3) File /opt/uploads/SELFIE_WITH_KTP/selfie_w_ktp_BC43061788063510_1657781521682.tmp saved successfully
2022-07-14 14:58:54,154 INFO  [async.newaccount.ServletHelper] (default task-3) File /opt/uploads/SELFIE_ONLY/selfie_only_BC43061788063510_1657781521682.tmp saved successfully
2022-07-14 14:58:54,155 INFO  [async.newaccount.ServletHelper] (default task-3) File /opt/uploads/AUTOGRAPH/autograph_BC43061788063510_1657781521682.tmp saved successfully
2022-07-14 14:58:54,155 INFO  [async.newaccount.ServletHelper] (default task-3) validateUserDataFileUpload
2022-07-14 14:58:54,156 INFO  [async.newaccount.ServletHelper] (default task-3) FILE INCOMING SIGN FFD8FFE0 > RESULT true
2022-07-14 14:58:54,156 INFO  [async.newaccount.ServletHelper] (default task-3) FILE INCOMING SIGN FFD8FFE0 > RESULT true
2022-07-14 14:58:54,156 INFO  [async.newaccount.ServletHelper] (default task-3) FILE INCOMING SIGN FFD8FFE0 > RESULT true
2022-07-14 14:58:54,156 INFO  [async.newaccount.ServletHelper] (default task-3) ERR 0
2022-07-14 14:58:54,156 INFO  [async.newaccount.ServletHelper] (default task-3) FILE INCOMING SIGN 89504E470D0A1A0A vs 89504E470D0A1A0A > RESULT true
2022-07-14 14:58:54,156 INFO  [async.newaccount.ServletHelper] (default task-3) getFormData checksum_ktp
2022-07-14 14:58:54,156 INFO  [async.newaccount.ServletHelper] (default task-3) getFormData checksum_npwp
2022-07-14 14:58:54,156 INFO  [async.newaccount.ServletHelper] (default task-3) getFormData checksum_selfie_only
2022-07-14 14:58:54,156 INFO  [async.newaccount.ServletHelper] (default task-3) getFormData checksum_selfie_w_ktp
2022-07-14 14:58:54,156 INFO  [async.newaccount.ServletHelper] (default task-3) getFormData checksum_autograph
2022-07-14 14:58:54,156 INFO  [async.newaccount.ServletHelper] (default task-3) getFormData user.data
2022-07-14 14:58:54,156 INFO  [async.newaccount.ServletHelper] (default task-3) getFormData user.signature
2022-07-14 14:58:54,156 INFO  [async.newaccount.ServletHelper] (default task-3) getFormData user.disclaimer_citizenship
2022-07-14 14:58:54,156 INFO  [async.newaccount.ServletHelper] (default task-3) getFormData user.disclaimer_agree_tnc
2022-07-14 14:58:54,156 INFO  [async.newaccount.ServletHelper] (default task-3) getFormData user.disclaimer_agree_promo
2022-07-14 14:58:54,206 INFO  [async.newaccount.ServletHelper] (default task-3) getFormData api.lang
2022-07-14 14:58:54,207 INFO  [async.newaccount.ServletHelper] (default task-3) getFormData mob.os_type

Raw Text