how to map configurator user session end to end in database
Hi
we are having an issue where we can see a configurator user session having stuck thread in oacore server, we want to kill the respective users session in database at application as well as at a DB level.
I am not able to map the session details from oacore log message to respective database or application process
any way we can map these details
below is the log message in oacore log
Workmanager: default, Version: 0, Scheduled=true, Started=true, Started time: 6794975 ms [ GET /OA_HTML/configurator/UiServlet?XMLmsg=%3Cbatch_validate%20validation_type%3D%22validate_order%22%3E<initialize><param+name="database_id">PTRXI</param><param+name="context_org_id">104</param><param+name="config_creation_date">09-19-2018-18-08-34</param><param+name="calling_application_id">660</param><param+name="responsibility_id">50573</param><param+name="model_id">16551719</param><param+name="config_header_id">666060333</param><param+name="config_rev_nbr">1</param><param+name="save_config_behavior">new_revision</param><param+name="terminate_msg_behavior">brief</param><param+name="model_quantity">1</param><param+name="icx_session_ticket">ZAodq7khw71OAdhd8gGFMAuYzG</param><param+name="client_header">5477934</param><param+name="client_line">97688012</param><param+name="sbm_flag">TRUE</param><param+name="config_effective_date">09-19-2018-18-15-19</param><param+name="config_model_lookup_date">09-19-2018-18-15-19</param></initialize></batch_validate> HTTP/1.1 ECID-Context: 1.005TZpYid1hDWbGpMwx0ie0002Od00017u;kXjE Connection: Keep-Alive X-Forwarded-For: 10.xx.xx.xx Proxy-Client-IP: 10.xx.xx.xx X-WebLogic-KeepAliveSecs: 30 X-WebLogic-Force-JVMID: 1933423244 ]