2022-07-11 09:14:59,964 INFO  [api.individu.ApiNewAccount] (EJB default - 1) PROCESSING
2022-07-11 09:14:59,970 INFO  [irvan.database.DatabaseConnection] (Thread-257) prepareStatement: SELECT tablename FROM pg_tables WHERE schemaname='log_api' AND tablename=?
2022-07-11 09:14:59,981 INFO  [irvan.database.DatabaseConnection] (Thread-257) prepareStatement: insert into log_api.log_202207_online ( param_request, api_type, api_timestamp, createdate, status_api )  values ( ? , ? , ? , CURRENT_TIMESTAMP, 0 )
2022-07-11 09:14:59,997 INFO  [api.individu.ApiNewAccount] (Thread-257) after saveLogRequestAPI() ApiUser() {"user.nik":"10A03A3F3F8EA455DAD1E779760B2C3826DF7F4B40793027","api.version":"2.5.0","user.signature":"3c8d4d47bfe29ca31d92a258eedeb6c849b81217f2d78260556420c649fd6e49","api.timestamp":"1657530924915","mob.app_version":"94 - 4.5.0 - Redmi Note 8","mob.os_type":1,"mob.signature":"f9e73fcaee23ef4dd7a46115691607697ca90f922fb76949f2e2111ed48c5555","api.status":"000","user.nohp":"36A8248CA300E85EBDE8C4B449BABF89","api.datetable":"202207","api.flag":1,"user.lat":-6.2313564,"api.lang":"IND","user.email":"49B5B4B8BAF5D7228F839E92F18DE10D","user.long":106.8383028,"mob.os_version":30,"api.type":"verify_identity","logid":"517","mob.imei":"67374C8A95BD0BCB194969F14DB56BFC6EF52A6BDD838554DFD47DB6D3166E446836723AC32E1DD934563145D5653CE22DA9FE5FF91843BD0209C8F7F694276D97423F97D0F824BD"}
2022-07-11 09:14:59,997 WARNING [irvan.utility.JSON] (Thread-257) get() api.channel
2022-07-11 09:15:00,002 WARNING [irvan.utility.JSON] (Thread-257) get() type_trigger
2022-07-11 09:15:00,002 WARNING [irvan.utility.JSON] (Thread-257) get() user.corp_code
2022-07-11 09:15:00,002 INFO  [api.ApiMain] (Thread-257)
2022-07-11 09:15:00,002 INFO  [api.ApiMain] (Thread-257) ===validasiParamApi===
2022-07-11 09:15:00,003 INFO  [api.ApiMain] (Thread-257) isi js pas masuk validasiparamApi {"api.class":"api.individu.ApiNewAccount","user.nik":"10A03A3F3F8EA455DAD1E779760B2C3826DF7F4B40793027","api.version":"2.5.0","user.signature":"3c8d4d47bfe29ca31d92a258eedeb6c849b81217f2d78260556420c649fd6e49","api.timestamp":"1657530924915","mob.app_version":"94 - 4.5.0 - Redmi Note 8","mob.os_type":1,"mob.signature":"f9e73fcaee23ef4dd7a46115691607697ca90f922fb76949f2e2111ed48c5555","type_trigger":1,"api.status":"000","user.nohp":"36A8248CA300E85EBDE8C4B449BABF89","api.datetable":"202207","user.corp_id":"-1","api.flag":1,"user.lat":-6.2313564,"api.lang":"IND","api.channel":"8003","user.email":"49B5B4B8BAF5D7228F839E92F18DE10D","user.long":106.8383028,"mob.os_version":30,"api.type":"verify_identity","logid":"517","mob.imei":"67374C8A95BD0BCB194969F14DB56BFC6EF52A6BDD838554DFD47DB6D3166E446836723AC32E1DD934563145D5653CE22DA9FE5FF91843BD0209C8F7F694276D97423F97D0F824BD"}
2022-07-11 09:15:00,003 WARNING [irvan.utility.JSON] (Thread-257) get() api.log
2022-07-11 09:15:00,003 WARNING [irvan.utility.JSON] (Thread-257) get() user.log
2022-07-11 09:15:00,003 WARNING [irvan.utility.JSON] (Thread-257) get() trans.log
2022-07-11 09:15:00,003 WARNING [irvan.utility.JSON] (Thread-257) get() mob.log
2022-07-11 09:15:00,003 WARNING [irvan.utility.JSON] (Thread-257) get() user.id
2022-07-11 09:15:00,003 INFO  [irvan.database.DatabaseConnection] (Thread-257) prepareStatement: SELECT status_api FROM api_type_list WHERE api_type=?
2022-07-11 09:15:00,015 INFO  [api.ApiMain] (Thread-257) isinya api status '1'
2022-07-11 09:15:00,101 INFO  [api.ApiMain] (Thread-257) getDecryptJSON(json,user.nik,false,true) with osType:1
2022-07-11 09:15:00,101 INFO  [api.ApiMain] (Thread-257) Field value:10A03A3F3F8EA455DAD1E779760B2C3826DF7F4B40793027
2022-07-11 09:15:00,101 INFO  [api.ApiMain] (Thread-257) Decrypted by decrypt3DES as +9567676788798986
2022-07-11 09:15:00,101 INFO  [api.ApiMain] (Thread-257) getDecryptJSON(json,user.nohp,false,true) with osType:1
2022-07-11 09:15:00,101 INFO  [api.ApiMain] (Thread-257) Field value:36A8248CA300E85EBDE8C4B449BABF89
2022-07-11 09:15:00,101 INFO  [api.ApiMain] (Thread-257) Decrypted by decrypt3DES as +082311122
2022-07-11 09:15:00,101 INFO  [api.ApiMain] (Thread-257) getDecryptJSON(json,user.email,false,true) with osType:1
2022-07-11 09:15:00,101 INFO  [api.ApiMain] (Thread-257) Field value:49B5B4B8BAF5D7228F839E92F18DE10D
2022-07-11 09:15:00,101 INFO  [api.ApiMain] (Thread-257) Decrypted by decrypt3DES as +test@gmail.com
2022-07-11 09:15:00,101 INFO  [api.ApiMain] (Thread-257) getDecryptJSON(json,mob.imei,false,true) with osType:1
2022-07-11 09:15:00,101 INFO  [api.ApiMain] (Thread-257) Field value:67374C8A95BD0BCB194969F14DB56BFC6EF52A6BDD838554DFD47DB6D3166E446836723AC32E1DD934563145D5653CE22DA9FE5FF91843BD0209C8F7F694276D97423F97D0F824BD
2022-07-11 09:15:00,102 INFO  [api.ApiMain] (Thread-257) Decrypted by decrypt3DES as +7FC46714CF409189DB8D1C5A112E16574BCC25DC845D3B8DAD937077799751C0
2022-07-11 09:15:00,102 INFO  [api.individu.ApiNewAccount] (Thread-257) Server Signature ********88798986|****11122|*****@tLA$T|test@gmail.com|-6.2313564|106.8383028|1657530924915
2022-07-11 09:15:00,102 INFO  [irvan.database.DatabaseConnection] (Thread-257) prepareStatement: select count(user_id) from user_online  where  (pgp_sym_decrypt( decode( nohp, 'hex' )::bytea, '1Rv@nr@B1ull@h' )=? or pgp_sym_decrypt( decode( email, 'hex' )::bytea, '1Rv@nr@B1ull@h' )=?) AND status_user <> -10
2022-07-11 09:15:00,147 INFO  [api.CoreResponder] (Thread-257) Getting Response : resp_inquiry_cif_fd2c3f63ffaa96d79507ce7ed7465ac8ec5c6ee4062dca902634ee014acf79cb
2022-07-11 09:15:00,152 INFO  [api.core.CheckNasabah] (Thread-257) Getter Check nasabah test@gmail.com ****11122
2022-07-11 09:15:05,158 INFO  [api.individu.ApiNewAccount] (Thread-257) test@gmail.com CIFstate [nik=99, nohp=99, email=99]
2022-07-11 09:15:05,158 INFO  [api.ApiMain] (Thread-257) saveLogTemp
2022-07-11 09:15:05,158 INFO  [api.ApiMain] (Thread-257) insert into log_api.log_202207_temp_user ( param, createdate, expired, status_api )  values (?, now(), current_timestamp + (30 * interval '1 minute'),0 )
2022-07-11 09:15:05,158 INFO  [irvan.database.DatabaseConnection] (Thread-257) prepareStatement: insert into log_api.log_202207_temp_user ( param, createdate, expired, status_api )  values (?, now(), current_timestamp + (30 * interval '1 minute'),0 )
2022-07-11 09:15:05,158 INFO  [api.ApiMain] (Thread-257) param={"api.class":"api.individu.ApiNewAccount","user.nik":"9567676788798986","api.version":"2.5.0","user.signature":"3c8d4d47bfe29ca31d92a258eedeb6c849b81217f2d78260556420c649fd6e49","api.timestamp":"1657530924915","mob.app_version":"94 - 4.5.0 - Redmi Note 8","mob.os_type":1,"mob.signature":"f9e73fcaee23ef4dd7a46115691607697ca90f922fb76949f2e2111ed48c5555","type_trigger":1,"api.status":"000","user.nohp":"082311122","api.datetable":"202207","user.corp_id":"-1","api.flag":1,"user.lat":-6.2313564,"api.lang":"IND","api.channel":"8003","user.email":"test@gmail.com","user.long":106.8383028,"mob.os_version":30,"api.type":"verify_identity","logid":"517","mob.imei":"7FC46714CF409189DB8D1C5A112E16574BCC25DC845D3B8DAD937077799751C0"}
2022-07-11 09:15:05,163 INFO  [api.ApiMain] (Thread-257) result logid=4
2022-07-11 09:15:05,163 INFO  [api.individu.ApiNewAccount] (Thread-257) response saveLogTemp() {"api.class":"api.individu.ApiNewAccount","user.nik":"9567676788798986","api.version":"2.5.0","user.signature":"3c8d4d47bfe29ca31d92a258eedeb6c849b81217f2d78260556420c649fd6e49","api.timestamp":"1657530924915","mob.app_version":"94 - 4.5.0 - Redmi Note 8","mob.os_type":1,"mob.signature":"f9e73fcaee23ef4dd7a46115691607697ca90f922fb76949f2e2111ed48c5555","type_trigger":1,"api.status":"000","user.nohp":"082311122","api.datetable":"202207","user.log":"4","user.corp_id":"-1","api.flag":1,"user.lat":-6.2313564,"api.lang":"IND","api.channel":"8003","user.email":"test@gmail.com","user.long":106.8383028,"mob.os_version":30,"api.type":"verify_identity","logid":"517","mob.imei":"7FC46714CF409189DB8D1C5A112E16574BCC25DC845D3B8DAD937077799751C0"}
2022-07-11 09:15:05,163 WARNING [irvan.utility.JSON] (Thread-257) get() user.id
2022-07-11 09:15:05,163 INFO  [irvan.database.DatabaseConnection] (Thread-257) isProduction(false)
2022-07-11 09:15:05,163 WARNING [irvan.utility.JSON] (Thread-257) get() trans.log
2022-07-11 09:15:05,163 WARNING [irvan.utility.JSON] (Thread-257) get() mob.log
2022-07-11 09:15:05,163 INFO  [irvan.database.DatabaseConnection] (Thread-257) prepareStatement: SELECT logid, counter_request FROM log_token_nohp WHERE logapi_id_user=? AND pgp_sym_decrypt( decode( nohp, 'hex' )::bytea, '1Rv@nr@B1ull@h' )=? AND api_type=? AND to_date(to_char(createdate,'YY-mm-dd'),'YY-mm-dd')=to_date(to_char(CURRENT_TIMESTAMP,'YY-mm-dd'),'YY-mm-dd')
2022-07-11 09:15:05,163 INFO  [irvan.database.DatabaseIrvan] (Thread-257) ProcessName:ambil data log_token_nohp untuk cek proses selain registrasi
2022-07-11 09:15:05,172 INFO  [api.ApiMain] (Thread-257) jsCounter : {}
2022-07-11 09:15:05,172 WARNING [irvan.utility.JSON] (Thread-257) get() counter_request
2022-07-11 09:15:05,172 INFO  [irvan.database.DatabaseConnection] (Thread-257) prepareStatement: update log_token set status_token=-1  where pgp_sym_decrypt( decode( no_hp, 'hex' )::bytea, '1Rv@nr@B1ull@h' )=? and CURRENT_TIMESTAMP < expired and status_token=1
2022-07-11 09:15:05,184 INFO  [irvan.database.DatabaseConnection] (Thread-257) prepareStatement: SELECT current_timestamp + (5 * interval '1 minute') as expired
2022-07-11 09:15:05,190 INFO  [irvan.database.DatabaseConnection] (Thread-257) prepareStatement: insert into log_token ( token, no_hp, user_id, expired, lastupdate, logapi_id_request, logapi_id_user, logapi_id_trans, logapi_id_mobile, api_type, status_token ) values (encode(pgp_sym_encrypt(?, '1Rv@nr@B1ull@h', 'compress-algo=1, cipher-algo=aes256'),'hex'),encode(pgp_sym_encrypt(?, '1Rv@nr@B1ull@h', 'compress-algo=1, cipher-algo=aes256'),'hex'), ?, current_timestamp + (5 * interval '1 minute'), now(), ?,?,?,?, ?,1)
2022-07-11 09:15:05,205 INFO  [irvan.database.DatabaseConnection] (Thread-257) prepareStatement: insert into log_token_nohp (nohp, logapi_id_user, logapi_id_trans, logapi_id_mobile, api_type ) values (encode(pgp_sym_encrypt(?, '1Rv@nr@B1ull@h', 'compress-algo=1, cipher-algo=aes256'),'hex'), ?, ?, ?, ?)
2022-07-11 09:15:05,222 INFO  [api.ApiMain] (Thread-257) ======>>> saveNotifSMS()
2022-07-11 09:15:05,225 INFO  [irvan.database.DatabaseConnection] (Thread-257) prepareStatement: SELECT setting_value FROM settings WHERE setting_id=?
2022-07-11 09:15:05,228 INFO  [irvan.database.DatabaseConnection] (Thread-257) prepareStatement: insert into notif_sms (lastupdate, message, no_hp, user_id, logapi_id )values (now(),?,?,?,?)
2022-07-11 09:15:05,248 WARNING [irvan.utility.JSON] (Thread-257) get() user.id
2022-07-11 09:15:05,248 INFO  [irvan.database.DatabaseConnection] (Thread-257) isProduction(false)
2022-07-11 09:15:05,282 INFO  [irvan.database.DatabaseConnection] (Thread-257) prepareStatement: insert into notif_email (lastupdate, to_email, subject, message )values (now(),?,?,?)
2022-07-11 09:15:05,306 INFO  [irvan.database.DatabaseConnection] (Thread-257) prepareStatement: SELECT setting_value FROM settings where setting_id='MOBILE_CONFIG_RESEND_SMS_INTERVAL'
2022-07-11 09:15:05,323 INFO  [api.ApiMain] (Thread-257) ====> setResponseJSON
2022-07-11 09:15:05,323 INFO  [irvan.database.DatabaseConnection] (Thread-257) prepareStatement: SELECT ind FROM response_message WHERE rc=?
2022-07-11 09:15:05,323 INFO  [api.ApiMain] (Thread-257) rc=000
2022-07-11 09:15:05,333 INFO  [api.ApiMain] (Thread-257) resultNotif : 'Sukses'
2022-07-11 09:15:05,333 INFO  [irvan.database.DatabaseConnection] (Thread-257) prepareStatement: update log_api.log_202207_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-07-11 09:15:05,333 WARNING [irvan.utility.JSON] (Thread-257) getLong(JSONObject json, key=auth_id, longDefault=-1 )
2022-07-11 09:15:05,333 WARNING [irvan.utility.JSON] (Thread-257) getLong(JSONObject json, user.id)
2022-07-11 09:15:05,333 WARNING [irvan.utility.JSON] (Thread-257) getLong(JSONObject json, request_temp_id)
2022-07-11 09:15:05,333 WARNING [irvan.utility.JSON] (Thread-257) getInt(JSONObject json, trans.flag)
2022-07-11 09:15:05,334 WARNING [irvan.utility.JSON] (Thread-257) get() trans.code
2022-07-11 09:15:05,346 WARNING [irvan.utility.JSON] (Thread-257) get() trans.log
2022-07-11 09:15:05,346 WARNING [irvan.utility.JSON] (Thread-257) get() trans.log
2022-07-11 09:15:05,346 WARNING [irvan.utility.JSON] (Thread-257) getLong(JSONObject json, key=request_temp_id, longDefault=-1 )
2022-07-11 09:15:05,346 INFO  [irvan.database.DatabaseConnection] (Thread-257) prepareStatement: update log_api.log_202207_temp_user set logapi_id=? where logid=?
2022-07-11 09:15:05,355 WARNING [irvan.utility.JSON] (Thread-257) getLong(JSONObject json, key=trans.log_id, longDefault=-1 )
2022-07-11 09:15:05,355 WARNING [irvan.utility.JSON] (Thread-257) get() mob.log
2022-07-11 09:15:05,356 WARNING [irvan.utility.JSON] (Thread-257) get() trans.log
2022-07-11 09:15:05,356 WARNING [irvan.utility.JSON] (Thread-257) get() user.id
2022-07-11 09:15:05,356 WARNING [irvan.utility.JSON] (Thread-257) get() api.auth
2022-07-11 09:15:05,356 WARNING [irvan.utility.JSON] (Thread-257) get() trans.log