2022-07-11 09:18:58,874 INFO  [api.individu.ApiNewAccount] (EJB default - 1) PROCESSING
2022-07-11 09:18:58,878 INFO  [irvan.database.DatabaseConnection] (Thread-260) prepareStatement: SELECT tablename FROM pg_tables WHERE schemaname='log_api' AND tablename=?
2022-07-11 09:18:58,887 INFO  [irvan.database.DatabaseConnection] (Thread-260) 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:18:58,899 INFO  [api.individu.ApiNewAccount] (Thread-260) after saveLogRequestAPI() ApiUser() {"api.version":"2.5.0","user.signature":"57b0f98ac3df2e370d7ee6839b4d49c3e89ef2a0a2999dd9e74749de4bbe5c95","api.timestamp":"1657531163034","mob.app_version":"94 - 4.5.0 - Redmi Note 8","mob.os_type":1,"api.token_email":"4F320597C716AD8D","user.name":"9ECE1B4D3D90315479619C96825C2583","api.status":"000","api.datetable":"202207","user.log":"7AAC4363B6446E17","user.password":"BF8E5A50017AF9EF9516A3E20CB78D1BA0EEB18CD5472204722D5A5260DFA375BCA90DE4F720F90B2A35B347820459B3EA3B9622539023F3F3921B98F89E09301EDD1BECC8A36964","api.token":"4F320597C716AD8D","api.flag":2,"api.lang":"IND","mob.os_version":30,"api.type":"user_registration","logid":"520"}
2022-07-11 09:18:58,899 WARNING [irvan.utility.JSON] (Thread-260) get() api.channel
2022-07-11 09:18:58,900 WARNING [irvan.utility.JSON] (Thread-260) get() type_trigger
2022-07-11 09:18:58,900 WARNING [irvan.utility.JSON] (Thread-260) get() user.corp_code
2022-07-11 09:18:58,900 INFO  [api.ApiMain] (Thread-260)
2022-07-11 09:18:58,900 INFO  [api.ApiMain] (Thread-260) ===validasiParamApi===
2022-07-11 09:18:58,900 INFO  [api.ApiMain] (Thread-260) isi js pas masuk validasiparamApi {"api.class":"api.individu.ApiNewAccount","api.version":"2.5.0","user.signature":"57b0f98ac3df2e370d7ee6839b4d49c3e89ef2a0a2999dd9e74749de4bbe5c95","api.timestamp":"1657531163034","mob.app_version":"94 - 4.5.0 - Redmi Note 8","mob.os_type":1,"type_trigger":1,"api.token_email":"4F320597C716AD8D","user.name":"9ECE1B4D3D90315479619C96825C2583","api.status":"000","api.datetable":"202207","user.log":"7AAC4363B6446E17","user.password":"BF8E5A50017AF9EF9516A3E20CB78D1BA0EEB18CD5472204722D5A5260DFA375BCA90DE4F720F90B2A35B347820459B3EA3B9622539023F3F3921B98F89E09301EDD1BECC8A36964","user.corp_id":"-1","api.token":"4F320597C716AD8D","api.flag":2,"api.lang":"IND","api.channel":"8003","mob.os_version":30,"api.type":"user_registration","logid":"520"}
2022-07-11 09:18:58,900 WARNING [irvan.utility.JSON] (Thread-260) get() api.log
2022-07-11 09:18:58,900 INFO  [api.ApiMain] (Thread-260) getDecryptJSON(json,user.log,true,true) with osType:1
2022-07-11 09:18:58,900 INFO  [api.ApiMain] (Thread-260) Field value:7AAC4363B6446E17
2022-07-11 09:18:58,900 WARNING [irvan.utility.JSON] (Thread-260) get() trans.log
2022-07-11 09:18:58,900 WARNING [irvan.utility.JSON] (Thread-260) get() mob.log
2022-07-11 09:18:58,900 WARNING [irvan.utility.JSON] (Thread-260) get() user.id
2022-07-11 09:18:58,900 INFO  [irvan.database.DatabaseConnection] (Thread-260) prepareStatement: SELECT status_api FROM api_type_list WHERE api_type=?
2022-07-11 09:18:58,907 INFO  [api.ApiMain] (Thread-260) isinya api status '1'
2022-07-11 09:18:58,907 INFO  [api.ApiMain] (Thread-260) getDecryptJSON(json,user.name,false,true) with osType:1
2022-07-11 09:18:58,907 INFO  [api.ApiMain] (Thread-260) Field value:9ECE1B4D3D90315479619C96825C2583
2022-07-11 09:18:58,907 INFO  [api.ApiMain] (Thread-260) Decrypted by decrypt3DES as +fajar9494
2022-07-11 09:18:58,907 INFO  [api.ApiMain] (Thread-260) getDecryptJSON(json,user.password,false,true) with osType:1
2022-07-11 09:18:58,907 INFO  [api.ApiMain] (Thread-260) Field value:BF8E5A50017AF9EF9516A3E20CB78D1BA0EEB18CD5472204722D5A5260DFA375BCA90DE4F720F90B2A35B347820459B3EA3B9622539023F3F3921B98F89E09301EDD1BECC8A36964
2022-07-11 09:18:58,908 INFO  [api.ApiMain] (Thread-260) Decrypted by decrypt3DES as +03ca1b764548391784bc3041573c9d3d02a841f5a4489085d8bb444cdf0c52b3
2022-07-11 09:18:58,908 INFO  [api.ApiMain] (Thread-260) getDecryptJSON(json,api.token,false,true) with osType:1
2022-07-11 09:18:58,908 INFO  [api.ApiMain] (Thread-260) Field value:4F320597C716AD8D
2022-07-11 09:18:58,908 INFO  [api.ApiMain] (Thread-260) Decrypted by decrypt3DES as +123456
2022-07-11 09:18:58,908 INFO  [api.ApiMain] (Thread-260) getDecryptJSON(json,api.token_email,false,true) with osType:1
2022-07-11 09:18:58,908 INFO  [api.ApiMain] (Thread-260) Field value:4F320597C716AD8D
2022-07-11 09:18:58,908 INFO  [api.ApiMain] (Thread-260) Decrypted by decrypt3DES as +123456
2022-07-11 09:18:58,908 INFO  [api.ApiMain] (Thread-260) getEncryptString() user.log  osType:1
2022-07-11 09:18:58,908 INFO  [api.ApiMain] (Thread-260) getEncryptString() user.log  osType:1
2022-07-11 09:18:58,908 INFO  [api.ApiMain] (Thread-260) SELECT param FROM log_api.log_202207_temp_user WHERE logid=?
2022-07-11 09:18:58,908 INFO  [irvan.database.DatabaseConnection] (Thread-260) prepareStatement: SELECT param FROM log_api.log_202207_temp_user WHERE logid=?
2022-07-11 09:18:58,908 INFO  [api.ApiMain] (Thread-260) logid=4
2022-07-11 09:18:58,913 WARNING [irvan.utility.JSON] (Thread-260) get() user.id
2022-07-11 09:18:58,913 WARNING [irvan.utility.JSON] (Thread-260) get() user.id
2022-07-11 09:18:58,913 INFO  [api.ApiMain] (Thread-260) getLogTemp() -> USER ID : jsTempUser|js : |
2022-07-11 09:18:58,913 WARNING [irvan.utility.JSON] (Thread-260) get() user.id
2022-07-11 09:18:58,913 WARNING [irvan.utility.JSON] (Thread-260) get() user.id
2022-07-11 09:18:58,913 INFO  [irvan.database.DatabaseConnection] (Thread-260) prepareStatement: SELECT user_id as user_id FROM user_online WHERE pgp_sym_decrypt( decode( username, 'hex' )::bytea, '1Rv@nr@B1ull@h' )=?
2022-07-11 09:18:58,919 INFO  [irvan.database.DatabaseConnection] (Thread-260) prepareStatement: SELECT reg_id as reg_id FROM newaccount.account_registration WHERE pgp_sym_decrypt( decode( reg_username, 'hex' )::bytea, '1Rv@nr@B1ull@h' )=?
2022-07-11 09:18:58,985 INFO  [irvan.database.DatabaseConnection] (Thread-260) prepareStatement: SELECT mobile_id, os_type, status_mobile, os_version, user_id, is_otp_device, pgp_sym_decrypt( decode( imei, 'hex' )::bytea, '1Rv@nr@B1ull@h' ) as imei FROM device_mobile WHERE pgp_sym_decrypt( decode( imei, 'hex' )::bytea, '1Rv@nr@B1ull@h' )=? and status_mobile=1
2022-07-11 09:18:58,985 INFO  [irvan.database.DatabaseIrvan] (Thread-260) ProcessName:_getImeiUser()
2022-07-11 09:18:59,043 INFO  [api.ApiMain] (Thread-260) Key token Sms ****token - Key token Email *******en_email
2022-07-11 09:18:59,043 WARNING [irvan.utility.JSON] (Thread-260) get() user.id
2022-07-11 09:18:59,043 INFO  [api.ApiMain] (Thread-260) tokenKey ***************************on.TEST@GMAIL.COM.082311122
2022-07-11 09:18:59,072 INFO  [api.ApiMain] (Thread-260) jsUser {}
2022-07-11 09:18:59,089 INFO  [api.ApiMain] (Thread-260) saveLogTemp
2022-07-11 09:18:59,089 INFO  [api.ApiMain] (Thread-260) 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:18:59,089 INFO  [irvan.database.DatabaseConnection] (Thread-260) 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:18:59,089 INFO  [api.ApiMain] (Thread-260) param={"api.version":"2.5.0","user.signature":"57b0f98ac3df2e370d7ee6839b4d49c3e89ef2a0a2999dd9e74749de4bbe5c95","api.token_email":"123456","user.name":"fajar9494","api.status":"000","user.nohp":"082311122","api.token":"123456","request_temp_id":4,"user.email":"TEST@GMAIL.COM","mob.os_version":"30","mob.imei":"7FC46714CF409189DB8D1C5A112E16574BCC25DC845D3B8DAD937077799751C0","api.class":"api.individu.ApiNewAccount","api.timestamp":"1657531163034","mob.app_version":"94 - 4.5.0 - Redmi Note 8","mob.os_type":"1","type_trigger":1,"api.datetable":"202207","user.log":"4","user.password":"03ca1b764548391784bc3041573c9d3d02a841f5a4489085d8bb444cdf0c52b3","user.corp_id":"-1","api.flag":2,"api.lang":"IND","api.channel":"8003","api.type":"user_registration","logid":"520"}
2022-07-11 09:18:59,103 INFO  [api.ApiMain] (Thread-260) result logid=5
2022-07-11 09:18:59,103 INFO  [api.individu.ApiNewAccount] (Thread-260) response saveLogTemp() {"api.version":"2.5.0","user.signature":"57b0f98ac3df2e370d7ee6839b4d49c3e89ef2a0a2999dd9e74749de4bbe5c95","api.token_email":"123456","user.name":"fajar9494","api.status":"000","user.nohp":"082311122","api.token":"123456","request_temp_id":4,"user.email":"TEST@GMAIL.COM","mob.os_version":"30","mob.imei":"7FC46714CF409189DB8D1C5A112E16574BCC25DC845D3B8DAD937077799751C0","api.class":"api.individu.ApiNewAccount","api.timestamp":"1657531163034","mob.app_version":"94 - 4.5.0 - Redmi Note 8","mob.os_type":"1","type_trigger":1,"api.datetable":"202207","user.log":"5","user.password":"03ca1b764548391784bc3041573c9d3d02a841f5a4489085d8bb444cdf0c52b3","user.corp_id":"-1","api.flag":2,"api.lang":"IND","api.channel":"8003","api.type":"user_registration","logid":"520"}
2022-07-11 09:18:59,103 INFO  [api.ApiMain] (Thread-260) ====> setResponseJSON
2022-07-11 09:18:59,103 INFO  [irvan.database.DatabaseConnection] (Thread-260) prepareStatement: SELECT ind FROM response_message WHERE rc=?
2022-07-11 09:18:59,103 INFO  [api.ApiMain] (Thread-260) rc=000
2022-07-11 09:18:59,109 INFO  [api.ApiMain] (Thread-260) resultNotif : 'Sukses'
2022-07-11 09:18:59,109 INFO  [irvan.database.DatabaseConnection] (Thread-260) 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:18:59,109 WARNING [irvan.utility.JSON] (Thread-260) getLong(JSONObject json, key=auth_id, longDefault=-1 )
2022-07-11 09:18:59,109 WARNING [irvan.utility.JSON] (Thread-260) getLong(JSONObject json, user.id)
2022-07-11 09:18:59,109 WARNING [irvan.utility.JSON] (Thread-260) getInt(JSONObject json, trans.flag)
2022-07-11 09:18:59,110 WARNING [irvan.utility.JSON] (Thread-260) get() trans.code
2022-07-11 09:18:59,123 WARNING [irvan.utility.JSON] (Thread-260) get() trans.log
2022-07-11 09:18:59,123 WARNING [irvan.utility.JSON] (Thread-260) get() trans.log
2022-07-11 09:18:59,123 INFO  [irvan.database.DatabaseConnection] (Thread-260) prepareStatement: update log_api.log_202207_temp_user set logapi_id=? where logid=?
2022-07-11 09:18:59,135 WARNING [irvan.utility.JSON] (Thread-260) getLong(JSONObject json, key=trans.log_id, longDefault=-1 )
2022-07-11 09:18:59,135 WARNING [irvan.utility.JSON] (Thread-260) get() mob.log
2022-07-11 09:18:59,135 WARNING [irvan.utility.JSON] (Thread-260) get() trans.log
2022-07-11 09:18:59,135 WARNING [irvan.utility.JSON] (Thread-260) get() user.id
2022-07-11 09:18:59,135 WARNING [irvan.utility.JSON] (Thread-260) get() api.auth
2022-07-11 09:18:59,135 WARNING [irvan.utility.JSON] (Thread-260) get() trans.log