2020-10-13 08:59:45,422|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.ObjectManager|query||SQL query: jdbc/simplicite: select t.idx_key, t.idx_object, t.idx_row_id, t.idx_ukey, t.idx_all from m_index t where (t.idx_key like ?) order by t.idx_key asc 2020-10-13 08:59:45,422|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|query||Host: column [1] value (DocumentSystem:3110) 2020-10-13 08:59:45,422|SIMPLICITE|http://9d656f7324d4:8080||SQLUSER|system|DBAccess|SQL|query|SQL=jdbc/simplicite: select t.idx_key, t.idx_object, t.idx_row_id, t.idx_ukey, t.idx_all from m_index t where (t.idx_key like ?) order by t.idx_key asc Hosts=[DocumentSystem:3110] 2020-10-13 08:59:45,423|SIMPLICITE|http://9d656f7324d4:8080||REPOSITORY|system|ObjectIndex|search||Message=found 0 row(s) SQL=select t.idx_key, t.idx_object, t.idx_row_id, t.idx_ukey, t.idx_all from m_index t where (t.idx_key like ?) order by t.idx_key asc Hosts=[DocumentSystem:3110] 2020-10-13 08:59:45,425|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.ObjectManager|update||SQL query: jdbc/simplicite: insert into m_index (idx_key,idx_object,idx_row_id,idx_ukey,idx_all) values (?,?,?,?,?) 2020-10-13 08:59:45,425|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column idx_key value (DocumentSystem:3110) 2020-10-13 08:59:45,425|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column idx_object value (DocumentSystem) 2020-10-13 08:59:45,425|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column idx_row_id value (3110) 2020-10-13 08:59:45,425|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column idx_ukey value (XMLSupervisor/xsp_src_id/0/92/flow_20201013_085945.xml) 2020-10-13 08:59:45,425|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column idx_all value (flow_20201013_085945.xml ) 2020-10-13 08:59:45,425|SIMPLICITE|http://9d656f7324d4:8080||SQLUSER|system|DBAccess|SQL|query|SQL=jdbc/simplicite: insert into m_index (idx_key,idx_object,idx_row_id,idx_ukey,idx_all) values (?,?,?,?,?) Hosts=[DocumentSystem:3110][DocumentSystem][3110][XMLSupervisor/xsp_src_id/0/92/flow_20201013_085945.xml][flow_20201013_085945.xml ] 2020-10-13 08:59:45,425|SIMPLICITE|http://9d656f7324d4:8080||REPOSITORY|system|ObjectIndex|create|DocumentSystem:3110|Message= SQL=insert into m_index (idx_key,idx_object,idx_row_id,idx_ukey,idx_all) values (?,?,?,?,?) Hosts=[DocumentSystem:3110][DocumentSystem][3110][XMLSupervisor/xsp_src_id/0/92/flow_20201013_085945.xml][flow_20201013_085945.xml ] 2020-10-13 08:59:45,425|SIMPLICITE|http://9d656f7324d4:8080||DEBUG|system|com.simplicite.util.tools.IndexSQLTool|indexFields||Event: Index created DocumentSystem:3110 ukey=XMLSupervisor/xsp_src_id/0/92/flow_20201013_085945.xml 13-Oct-2020 08:59:45.638 INFO [http-nio-8080-exec-39] org.apache.catalina.core.StandardWrapperValve.invoke 2020-10-13 08:59:45,410|SIMPLICITE|http://9d656f7324d4:8080||DEBUG|system|com.simplicite.webapp.servlets.IOServlet|doPost||Event: Root: Location: /io Simple parameters: service = [xmlimport] log = [true] Multiple parameters: service = [xmlimport] log = [true] Document parameters: file = [test.xml] Method: POST Content type: multipart/form-data Charset: User agent: curl/7.70.0 Session ID: 2AC426F4855E177878019CA425137701 Headers: authorization = Basic ZGVzaWduZXI6Y2hhdXZpZ25l content-length = 1056 host = localhost:8080 content-type = multipart/form-data; boundary=------------------------68f1d368791fcd34 user-agent = curl/7.70.0 accept = */* 2020-10-13 08:59:45,411|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.ObjectManager|query||SQL query: select rid_curval from m_rowid where rid_table='m_xml.row_id' 2020-10-13 08:59:45,411|SIMPLICITE|http://9d656f7324d4:8080||SQLSYSTEM|system|DBAccess|SQL|query|SQL=select rid_curval from m_rowid where rid_table='m_xml.row_id' Hosts= 2020-10-13 08:59:45,411|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.ObjectManager|update||SQL query: update m_rowid set rid_curval=92 where rid_table='m_xml.row_id' and rid_curval=91 2020-10-13 08:59:45,411|SIMPLICITE|http://9d656f7324d4:8080||SQLSYSTEM|system|DBAccess|SQL|query|SQL=update m_rowid set rid_curval=92 where rid_table='m_xml.row_id' and rid_curval=91 Hosts= 2020-10-13 08:59:45,411|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.ObjectManager|update||SQL query: jdbc/simplicite: insert into m_xml (row_id,created_dt,updated_dt,created_by,updated_by,xsp_status,xsp_user_id,xsp_origin,xsp_effect_dt,xsp_run_dt,xsp_duration,xsp_src_id,xsp_file_id,xsp_log_id,xsp_err_id,xsp_adapter_id) values (?,?,?,?,?,?,?,?,null,?,null,null,null,null,null,null) 2020-10-13 08:59:45,411|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column row_id value (92) 2020-10-13 08:59:45,411|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column xsp_created_dt value (2020-10-13 08:59:45) 2020-10-13 08:59:45,411|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column updated_dt value (2020-10-13 08:59:45) 2020-10-13 08:59:45,411|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column created_by value (system) 2020-10-13 08:59:45,412|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column updated_by value (system) 2020-10-13 08:59:45,412|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column xsp_status value (R) 2020-10-13 08:59:45,412|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column xsp_user_id value () 2020-10-13 08:59:45,412|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column xsp_origin value (I/O XML import test.xml) 2020-10-13 08:59:45,412|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column xsp_run_dt value (2020-10-13 08:59:45) 2020-10-13 08:59:45,412|SIMPLICITE|http://9d656f7324d4:8080||SQLUSER|system|DBAccess|SQL|query|SQL=jdbc/simplicite: insert into m_xml (row_id,created_dt,updated_dt,created_by,updated_by,xsp_status,xsp_user_id,xsp_origin,xsp_effect_dt,xsp_run_dt,xsp_duration,xsp_src_id,xsp_file_id,xsp_log_id,xsp_err_id,xsp_adapter_id) values (?,?,?,?,?,?,?,?,null,?,null,null,null,null,null,null) Hosts=[92][2020-10-13 08:59:45][2020-10-13 08:59:45][system][system][R][][I/O XML import test.xml][2020-10-13 08:59:45] 2020-10-13 08:59:45,412|SIMPLICITE|http://9d656f7324d4:8080||REPOSITORY|system|XMLSupervisor|create|92|Message= SQL=insert into m_xml (row_id,created_dt,updated_dt,created_by,updated_by,xsp_status,xsp_user_id,xsp_origin,xsp_effect_dt,xsp_run_dt,xsp_duration,xsp_src_id,xsp_file_id,xsp_log_id,xsp_err_id,xsp_adapter_id) values (?,?,?,?,?,?,?,?,null,?,null,null,null,null,null,null) Hosts=[92][2020-10-13 08:59:45][2020-10-13 08:59:45][system][system][R][][I/O XML import test.xml][2020-10-13 08:59:45] 2020-10-13 08:59:45,418|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.ObjectManager|query||SQL query: jdbc/simplicite: select t.row_id, t.dbd_name, t.dbd_vers, t.row_id, t.dbd_path, t.dbd_size, t.dbd_mime, t.dbd_index_id, t_dbd_index_id.din_name, t.dbd_object_id, t.dbd_resp_id, t_dbd_object_id.obj_name, t.dbd_field_id, t_dbd_resp_id.usr_login, t_dbd_field_id.fld_name, t.dbd_row_id, t.created_dt, t.created_by, t.updated_dt, t.updated_by from m_document t left outer join m_docindex t_dbd_index_id on (t.dbd_index_id=t_dbd_index_id.row_id) left outer join m_object t_dbd_object_id on (t.dbd_object_id=t_dbd_object_id.row_id) left outer join m_user t_dbd_resp_id on (t.dbd_resp_id=t_dbd_resp_id.row_id) left outer join m_field t_dbd_field_id on (t.dbd_field_id=t_dbd_field_id.row_id) where (1=1 and (t.dbd_path='XMLSupervisor/xsp_src_id/0/92/flow_20201013_085945.xml')) order by t.dbd_name asc, t.dbd_vers asc, t.row_id asc 2020-10-13 08:59:45,418|SIMPLICITE|http://9d656f7324d4:8080||SQLUSER|system|DBAccess|SQL|query|SQL=jdbc/simplicite: select t.row_id, t.dbd_name, t.dbd_vers, t.row_id, t.dbd_path, t.dbd_size, t.dbd_mime, t.dbd_index_id, t_dbd_index_id.din_name, t.dbd_object_id, t.dbd_resp_id, t_dbd_object_id.obj_name, t.dbd_field_id, t_dbd_resp_id.usr_login, t_dbd_field_id.fld_name, t.dbd_row_id, t.created_dt, t.created_by, t.updated_dt, t.updated_by from m_document t left outer join m_docindex t_dbd_index_id on (t.dbd_index_id=t_dbd_index_id.row_id) left outer join m_object t_dbd_object_id on (t.dbd_object_id=t_dbd_object_id.row_id) left outer join m_user t_dbd_resp_id on (t.dbd_resp_id=t_dbd_resp_id.row_id) left outer join m_field t_dbd_field_id on (t.dbd_field_id=t_dbd_field_id.row_id) where (1=1 and (t.dbd_path='XMLSupervisor/xsp_src_id/0/92/flow_20201013_085945.xml')) order by t.dbd_name asc, t.dbd_vers asc, t.row_id asc Hosts= 2020-10-13 08:59:45,419|SIMPLICITE|http://9d656f7324d4:8080||REPOSITORY|system|DocumentSystem|search||Message=found 0 row(s) SQL=select t.row_id, t.dbd_name, t.dbd_vers, t.row_id, t.dbd_path, t.dbd_size, t.dbd_mime, t.dbd_index_id, t_dbd_index_id.din_name, t.dbd_object_id, t.dbd_resp_id, t_dbd_object_id.obj_name, t.dbd_field_id, t_dbd_resp_id.usr_login, t_dbd_field_id.fld_name, t.dbd_row_id, t.created_dt, t.created_by, t.updated_dt, t.updated_by from m_document t left outer join m_docindex t_dbd_index_id on (t.dbd_index_id=t_dbd_index_id.row_id) left outer join m_object t_dbd_object_id on (t.dbd_object_id=t_dbd_object_id.row_id) left outer join m_user t_dbd_resp_id on (t.dbd_resp_id=t_dbd_resp_id.row_id) left outer join m_field t_dbd_field_id on (t.dbd_field_id=t_dbd_field_id.row_id) where (1=1 and (t.dbd_path='XMLSupervisor/xsp_src_id/0/92/flow_20201013_085945.xml')) order by t.dbd_name asc, t.dbd_vers asc, t.row_id asc Hosts= 2020-10-13 08:59:45,419|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.ObjectManager|query||SQL query: jdbc/simplicite: select count(*) from m_object where row_id=344 2020-10-13 08:59:45,419|SIMPLICITE|http://9d656f7324d4:8080||SQLSYSTEM|system|DBAccess|SQL|query|SQL=jdbc/simplicite: select count(*) from m_object where row_id=344 Hosts= 2020-10-13 08:59:45,419|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.ObjectManager|query||SQL query: jdbc/simplicite: select count(*) from m_field where row_id=3409 2020-10-13 08:59:45,419|SIMPLICITE|http://9d656f7324d4:8080||SQLSYSTEM|system|DBAccess|SQL|query|SQL=jdbc/simplicite: select count(*) from m_field where row_id=3409 Hosts= 2020-10-13 08:59:45,419|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.ObjectManager|query||SQL query: select rid_curval from m_rowid where rid_table='m_document.row_id' 2020-10-13 08:59:45,419|SIMPLICITE|http://9d656f7324d4:8080||SQLSYSTEM|system|DBAccess|SQL|query|SQL=select rid_curval from m_rowid where rid_table='m_document.row_id' Hosts= 2020-10-13 08:59:45,420|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.ObjectManager|update||SQL query: update m_rowid set rid_curval=3110 where rid_table='m_document.row_id' and rid_curval=3109 2020-10-13 08:59:45,420|SIMPLICITE|http://9d656f7324d4:8080||SQLSYSTEM|system|DBAccess|SQL|query|SQL=update m_rowid set rid_curval=3110 where rid_table='m_document.row_id' and rid_curval=3109 Hosts= 2020-10-13 08:59:45,420|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.ObjectManager|update||SQL query: jdbc/simplicite: insert into m_document (row_id,created_dt,updated_dt,created_by,updated_by,dbd_name,dbd_vers,dbd_path,dbd_size,dbd_mime,dbd_index_id,dbd_object_id,dbd_resp_id,dbd_field_id,dbd_row_id) values (?,?,?,?,?,?,?,?,?,?,null,?,null,?,?) 2020-10-13 08:59:45,420|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column row_id value (3110) 2020-10-13 08:59:45,420|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column created_dt value (2020-10-13 08:59:45) 2020-10-13 08:59:45,420|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column updated_dt value (2020-10-13 08:59:45) 2020-10-13 08:59:45,420|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column created_by value (system) 2020-10-13 08:59:45,420|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column updated_by value (system) 2020-10-13 08:59:45,420|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column dbd_name value (flow_20201013_085945.xml) 2020-10-13 08:59:45,420|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column dbd_vers value (0) 2020-10-13 08:59:45,420|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column dbd_path value (XMLSupervisor/xsp_src_id/0/92/flow_20201013_085945.xml) 2020-10-13 08:59:45,420|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column dbd_size value (664) 2020-10-13 08:59:45,420|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column dbd_mime value (text/xml) 2020-10-13 08:59:45,420|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column dbd_object_id value (344) 2020-10-13 08:59:45,420|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column dbd_field_id value (3409) 2020-10-13 08:59:45,420|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|update||Host: column dbd_row_id value (92) 2020-10-13 08:59:45,420|SIMPLICITE|http://9d656f7324d4:8080||SQLUSER|system|DBAccess|SQL|query|SQL=jdbc/simplicite: insert into m_document (row_id,created_dt,updated_dt,created_by,updated_by,dbd_name,dbd_vers,dbd_path,dbd_size,dbd_mime,dbd_index_id,dbd_object_id,dbd_resp_id,dbd_field_id,dbd_row_id) values (?,?,?,?,?,?,?,?,?,?,null,?,null,?,?) Hosts=[3110][2020-10-13 08:59:45][2020-10-13 08:59:45][system][system][flow_20201013_085945.xml][0][XMLSupervisor/xsp_src_id/0/92/flow_20201013_085945.xml][664][text/xml][344][3409][92] 2020-10-13 08:59:45,420|SIMPLICITE|http://9d656f7324d4:8080||REPOSITORY|system|DocumentSystem|create|3110|Message= SQL=insert into m_document (row_id,created_dt,updated_dt,created_by,updated_by,dbd_name,dbd_vers,dbd_path,dbd_size,dbd_mime,dbd_index_id,dbd_object_id,dbd_resp_id,dbd_field_id,dbd_row_id) values (?,?,?,?,?,?,?,?,?,?,null,?,null,?,?) Hosts=[3110][2020-10-13 08:59:45][2020-10-13 08:59:45][system][system][flow_20201013_085945.xml][0][XMLSupervisor/xsp_src_id/0/92/flow_20201013_085945.xml][664][text/xml][344][3409][92] 2020-10-13 08:59:45,422|SIMPLICITE|http://9d656f7324d4:8080||DOCUMENT|system|DBDoc|upload||Document path=XMLSupervisor/xsp_src_id/0/92/flow_20201013_085945.xml size=664 2020-10-13 08:59:45,422|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.GrantManager|update||SQL query: update m_xml set xsp_src_id=3110 where row_id=92 2020-10-13 08:59:45,422|SIMPLICITE|http://9d656f7324d4:8080||SQLUSER|system|DBAccess|SQL|query|SQL=update m_xml set xsp_src_id=3110 where row_id=92 Hosts= 2020-10-13 08:59:45,423|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.GrantManager|query||SQL query: select d.dbd_name, d.dbd_path, d.dbd_size, d.dbd_vers, d.dbd_mime, d.dbd_resp_id, d.dbd_index_id, o.obj_name, f.fld_name, d.dbd_row_id, d.updated_dt from m_document d left outer join m_object o on (d.dbd_object_id=o.row_id) left outer join m_field f on (d.dbd_field_id=f.row_id) where d.row_id=3110 2020-10-13 08:59:45,425|SIMPLICITE|http://9d656f7324d4:8080||SQLUSER|system|DBAccess|SQL|query|SQL=select d.dbd_name, d.dbd_path, d.dbd_size, d.dbd_vers, d.dbd_mime, d.dbd_resp_id, d.dbd_index_id, o.obj_name, f.fld_name, d.dbd_row_id, d.updated_dt from m_document d left outer join m_object o on (d.dbd_object_id=o.row_id) left outer join m_field f on (d.dbd_field_id=f.row_id) where d.row_id=3110 Hosts= 2020-10-13 08:59:45,426|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.ObjectManager|query||SQL query: jdbc/simplicite: select t.row_id, t.xsp_status, t.xsp_user_id, t_xsp_user_id.usr_login, t.xsp_origin, t.created_dt, t.xsp_effect_dt, t.xsp_run_dt, t.xsp_duration, t.xsp_src_id, t.xsp_file_id, t.xsp_log_id, t.xsp_err_id, t.xsp_adapter_id, t_xsp_adapter_id.adp_name, t_xsp_adapter_id.adp_type, t.created_dt, t.created_by, t.updated_dt, t.updated_by from m_xml t inner join m_user t_xsp_user_id on (t.xsp_user_id=t_xsp_user_id.row_id) left outer join m_adapter t_xsp_adapter_id on (t.xsp_adapter_id=t_xsp_adapter_id.row_id) where (t.row_id=?) order by t.created_dt desc, t.row_id asc 2020-10-13 08:59:45,426|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|query||Host: column [1] value (92) 2020-10-13 08:59:45,426|SIMPLICITE|http://9d656f7324d4:8080||SQLUSER|system|DBAccess|SQL|query|SQL=jdbc/simplicite: select t.row_id, t.xsp_status, t.xsp_user_id, t_xsp_user_id.usr_login, t.xsp_origin, t.created_dt, t.xsp_effect_dt, t.xsp_run_dt, t.xsp_duration, t.xsp_src_id, t.xsp_file_id, t.xsp_log_id, t.xsp_err_id, t.xsp_adapter_id, t_xsp_adapter_id.adp_name, t_xsp_adapter_id.adp_type, t.created_dt, t.created_by, t.updated_dt, t.updated_by from m_xml t inner join m_user t_xsp_user_id on (t.xsp_user_id=t_xsp_user_id.row_id) left outer join m_adapter t_xsp_adapter_id on (t.xsp_adapter_id=t_xsp_adapter_id.row_id) where (t.row_id=?) order by t.created_dt desc, t.row_id asc Hosts=[92] 2020-10-13 08:59:45,426|SIMPLICITE|http://9d656f7324d4:8080||REPOSITORY|system|XMLSupervisor|search||Message=found 0 row(s) SQL=select t.row_id, t.xsp_status, t.xsp_user_id, t_xsp_user_id.usr_login, t.xsp_origin, t.created_dt, t.xsp_effect_dt, t.xsp_run_dt, t.xsp_duration, t.xsp_src_id, t.xsp_file_id, t.xsp_log_id, t.xsp_err_id, t.xsp_adapter_id, t_xsp_adapter_id.adp_name, t_xsp_adapter_id.adp_type, t.created_dt, t.created_by, t.updated_dt, t.updated_by from m_xml t inner join m_user t_xsp_user_id on (t.xsp_user_id=t_xsp_user_id.row_id) left outer join m_adapter t_xsp_adapter_id on (t.xsp_adapter_id=t_xsp_adapter_id.row_id) where (t.row_id=?) order by t.created_dt desc, t.row_id asc Hosts=[92] 2020-10-13 08:59:45,635|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.ObjectManager|query||SQL query: jdbc/simplicite: select t.row_id, t.xsp_status, t.xsp_user_id, t_xsp_user_id.usr_login, t.xsp_origin, t.created_dt, t.xsp_effect_dt, t.xsp_run_dt, t.xsp_duration, t.xsp_src_id, t.xsp_file_id, t.xsp_log_id, t.xsp_err_id, t.xsp_adapter_id, t_xsp_adapter_id.adp_name, t_xsp_adapter_id.adp_type, t.created_dt, t.created_by, t.updated_dt, t.updated_by from m_xml t inner join m_user t_xsp_user_id on (t.xsp_user_id=t_xsp_user_id.row_id) left outer join m_adapter t_xsp_adapter_id on (t.xsp_adapter_id=t_xsp_adapter_id.row_id) where (t.row_id=?) order by t.created_dt desc, t.row_id asc 2020-10-13 08:59:45,635|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|query||Host: column [1] value (92) 2020-10-13 08:59:45,635|SIMPLICITE|http://9d656f7324d4:8080||SQLUSER|system|DBAccess|SQL|query|SQL=jdbc/simplicite: select t.row_id, t.xsp_status, t.xsp_user_id, t_xsp_user_id.usr_login, t.xsp_origin, t.created_dt, t.xsp_effect_dt, t.xsp_run_dt, t.xsp_duration, t.xsp_src_id, t.xsp_file_id, t.xsp_log_id, t.xsp_err_id, t.xsp_adapter_id, t_xsp_adapter_id.adp_name, t_xsp_adapter_id.adp_type, t.created_dt, t.created_by, t.updated_dt, t.updated_by from m_xml t inner join m_user t_xsp_user_id on (t.xsp_user_id=t_xsp_user_id.row_id) left outer join m_adapter t_xsp_adapter_id on (t.xsp_adapter_id=t_xsp_adapter_id.row_id) where (t.row_id=?) order by t.created_dt desc, t.row_id asc Hosts=[92] 2020-10-13 08:59:45,635|SIMPLICITE|http://9d656f7324d4:8080||REPOSITORY|system|XMLSupervisor|search||Message=found 0 row(s) SQL=select t.row_id, t.xsp_status, t.xsp_user_id, t_xsp_user_id.usr_login, t.xsp_origin, t.created_dt, t.xsp_effect_dt, t.xsp_run_dt, t.xsp_duration, t.xsp_src_id, t.xsp_file_id, t.xsp_log_id, t.xsp_err_id, t.xsp_adapter_id, t_xsp_adapter_id.adp_name, t_xsp_adapter_id.adp_type, t.created_dt, t.created_by, t.updated_dt, t.updated_by from m_xml t inner join m_user t_xsp_user_id on (t.xsp_user_id=t_xsp_user_id.row_id) left outer join m_adapter t_xsp_adapter_id on (t.xsp_adapter_id=t_xsp_adapter_id.row_id) where (t.row_id=?) order by t.created_dt desc, t.row_id asc Hosts=[92] 2020-10-13 08:59:45,635|SIMPLICITE|http://9d656f7324d4:8080||DEBUG|system|com.simplicite.webapp.tools.ServletTool|setHTTPHeaders||Event: [REQUEST] method POST on /io from 172.20.0.1 with session 2AC426F4855E177878019CA425137701, [RESPONSE] MIME type: text/plain max age: -1 seconds 13-Oct-2020 08:59:51.114 INFO [http-nio-8080-exec-38] org.apache.catalina.core.StandardWrapperValve.invoke 2020-10-13 08:59:50,780|SIMPLICITE|http://9d656f7324d4:8080||DEBUG|system|com.simplicite.webapp.tools.ServletTool|setHTTPHeaders||Event: [REQUEST] method GET on /ui/logs from 172.20.0.1 with session BC265DD17824F31198E9310E738FF033, [RESPONSE] MIME type: text/html; charset=UTF-8 max age: 0 seconds 2020-10-13 09:00:00,002|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.GrantManager|query||SQL query: select sys_value, sys_value2 from m_system where sys_code='CRON_LOCK' 2020-10-13 09:00:00,002|SIMPLICITE|http://9d656f7324d4:8080||SQLSYSTEM|system|DBAccess|SQL|query|SQL=select sys_value, sys_value2 from m_system where sys_code='CRON_LOCK' Hosts= 2020-10-13 09:00:00,008|SIMPLICITE|http://9d656f7324d4:8080||DCORECF001|system|com.simplicite.objects.System.SystemParam|postLoad||Configuration: Loaded configuration object SystemParam () 2020-10-13 09:00:00,009|SIMPLICITE|http://9d656f7324d4:8080||ICORECM004|system|com.simplicite.util.CronJob|run||Execute job ImportXML at 2020-10-13 09:00:00 2020-10-13 09:00:00,009|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.GrantManager|query||SQL query: select row_id from m_xml where xsp_status='I' and xsp_effect_dt<=current_timestamp 2020-10-13 09:00:00,009|SIMPLICITE|http://9d656f7324d4:8080||SQLUSER|system|DBAccess|SQL|query|SQL=select row_id from m_xml where xsp_status='I' and xsp_effect_dt<=current_timestamp Hosts= 2020-10-13 09:00:00,009|SIMPLICITE|http://9d656f7324d4:8080||REPOSITORY|system|XMLSupervisor|manageImport||Message=Result: No XML file to import. SQL= Hosts= 2020-10-13 09:00:00,009|SIMPLICITE|http://9d656f7324d4:8080||ICORECM005|system|com.simplicite.util.CronJob|run||Result of job ImportXML : No XML file to import. 2020-10-13 09:00:00,009|SIMPLICITE|http://9d656f7324d4:8080||ICORECM004|system|com.simplicite.util.CronJob|run||Execute job HealthCheck at 2020-10-13 09:00:00 2020-10-13 09:00:00,010|SIMPLICITE|http://9d656f7324d4:8080||ICORECM005|system|com.simplicite.util.CronJob|run||Result of job HealthCheck : Application version : 1.0.0, platform version : 5 patchlevel P00b 2020-10-13 09:00:00,010|SIMPLICITE|http://9d656f7324d4:8080||ICORECM004|system|com.simplicite.util.CronJob|run||Execute job deadlockTimestamp at 2020-10-13 09:00:00 2020-10-13 09:00:00,010|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.GrantManager|query||SQL query: select count(*) from m_object_usage where obu_date < ? 2020-10-13 09:00:00,010|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.GrantManager|query||Host: column [1] value (2020-10-13 08:55:00) 2020-10-13 09:00:00,010|SIMPLICITE|http://9d656f7324d4:8080||SQLUSER|system|DBAccess|SQL|query|SQL=select count(*) from m_object_usage where obu_date < ? Hosts=[2020-10-13 08:55:00] 2020-10-13 09:00:00,010|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.GrantManager|update||SQL query: delete from m_object_usage where obu_date < ? 2020-10-13 09:00:00,010|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.GrantManager|update||Host: column [1] value (2020-10-13 08:55:00) 2020-10-13 09:00:00,010|SIMPLICITE|http://9d656f7324d4:8080||SQLUSER|system|DBAccess|SQL|query|SQL=delete from m_object_usage where obu_date < ? Hosts=[2020-10-13 08:55:00] 2020-10-13 09:00:00,010|SIMPLICITE|http://9d656f7324d4:8080||REPOSITORY|system|ObjectUsage|ObjectUsage-deadlock||Message=Result: 0 object(s) unlocked.#INFO SQL= Hosts= 2020-10-13 09:00:00,010|SIMPLICITE|http://9d656f7324d4:8080||ICORECM005|system|com.simplicite.util.CronJob|run||Result of job deadlockTimestamp : 0 object(s) unlocked.#INFO 2020-10-13 09:00:00,014|SIMPLICITE|http://9d656f7324d4:8080||DCORECF001|system|com.simplicite.objects.Workflow.BPMProcess|postLoad||Configuration: Loaded configuration object BPMProcess () 2020-10-13 09:00:00,015|SIMPLICITE|http://9d656f7324d4:8080||ICORECM004|system|com.simplicite.util.CronJob|run||Execute job deadlineProcess at 2020-10-13 09:00:00 2020-10-13 09:00:00,017|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.ObjectManager|query||SQL query: jdbc/simplicite: select t.row_id, t.pcf_process_id, t_pcf_process_id.pcs_name, t.pcf_serial, t.pcf_start_dt, t.pcf_end_dt, t.pcf_duration, t.pcf_status, t.pcf_deadline_dt, t.pcf_object, t.pcf_acf_id, t_pcf_acf_id.acf_pcf_id, t_acf_pcf_id.pcf_serial, t_pcf_acf_id.acf_serial, t_acf_pcf_id.pcf_process_id, t_pcf_acf_id_acf_pcf_id_pcf_process_id.pcs_name, t.pcf_owner_id, t_pcf_owner_id.usr_login, t_pcf_owner_id.usr_last_name, t_pcf_owner_id.usr_first_name, t_pcf_owner_id.usr_email, t_pcf_owner_id.usr_work_num, t.created_dt, t.created_by, t.updated_dt, t.updated_by from bpm_process_file t left outer join bpm_process t_pcf_process_id on (t.pcf_process_id=t_pcf_process_id.row_id) left outer join bpm_activity_file t_pcf_acf_id on (t.pcf_acf_id=t_pcf_acf_id.row_id) left outer join bpm_process_file t_acf_pcf_id on (t_pcf_acf_id.acf_pcf_id=t_acf_pcf_id.row_id) left outer join bpm_process t_pcf_acf_id_acf_pcf_id_pcf_process_id on (t_acf_pcf_id.pcf_process_id=t_pcf_acf_id_acf_pcf_id_pcf_process_id.row_id) left outer join m_user t_pcf_owner_id on (t.pcf_owner_id=t_pcf_owner_id.row_id) where ( t.pcf_end_dt is null) and ( t.pcf_deadline_dt is not null and t.pcf_deadline_dt <=current_timestamp) order by t_pcf_process_id.pcs_name asc, t.pcf_serial asc, t.row_id asc 2020-10-13 09:00:00,018|SIMPLICITE|http://9d656f7324d4:8080||SQLUSER|system|DBAccess|SQL|query|SQL=jdbc/simplicite: select t.row_id, t.pcf_process_id, t_pcf_process_id.pcs_name, t.pcf_serial, t.pcf_start_dt, t.pcf_end_dt, t.pcf_duration, t.pcf_status, t.pcf_deadline_dt, t.pcf_object, t.pcf_acf_id, t_pcf_acf_id.acf_pcf_id, t_acf_pcf_id.pcf_serial, t_pcf_acf_id.acf_serial, t_acf_pcf_id.pcf_process_id, t_pcf_acf_id_acf_pcf_id_pcf_process_id.pcs_name, t.pcf_owner_id, t_pcf_owner_id.usr_login, t_pcf_owner_id.usr_last_name, t_pcf_owner_id.usr_first_name, t_pcf_owner_id.usr_email, t_pcf_owner_id.usr_work_num, t.created_dt, t.created_by, t.updated_dt, t.updated_by from bpm_process_file t left outer join bpm_process t_pcf_process_id on (t.pcf_process_id=t_pcf_process_id.row_id) left outer join bpm_activity_file t_pcf_acf_id on (t.pcf_acf_id=t_pcf_acf_id.row_id) left outer join bpm_process_file t_acf_pcf_id on (t_pcf_acf_id.acf_pcf_id=t_acf_pcf_id.row_id) left outer join bpm_process t_pcf_acf_id_acf_pcf_id_pcf_process_id on (t_acf_pcf_id.pcf_process_id=t_pcf_acf_id_acf_pcf_id_pcf_process_id.row_id) left outer join m_user t_pcf_owner_id on (t.pcf_owner_id=t_pcf_owner_id.row_id) where ( t.pcf_end_dt is null) and ( t.pcf_deadline_dt is not null and t.pcf_deadline_dt <=current_timestamp) order by t_pcf_process_id.pcs_name asc, t.pcf_serial asc, t.row_id asc Hosts= 2020-10-13 09:00:00,018|SIMPLICITE|http://9d656f7324d4:8080||REPOSITORY|system|BPMProcessFile|search||Message=found 0 row(s) SQL=select t.row_id, t.pcf_process_id, t_pcf_process_id.pcs_name, t.pcf_serial, t.pcf_start_dt, t.pcf_end_dt, t.pcf_duration, t.pcf_status, t.pcf_deadline_dt, t.pcf_object, t.pcf_acf_id, t_pcf_acf_id.acf_pcf_id, t_acf_pcf_id.pcf_serial, t_pcf_acf_id.acf_serial, t_acf_pcf_id.pcf_process_id, t_pcf_acf_id_acf_pcf_id_pcf_process_id.pcs_name, t.pcf_owner_id, t_pcf_owner_id.usr_login, t_pcf_owner_id.usr_last_name, t_pcf_owner_id.usr_first_name, t_pcf_owner_id.usr_email, t_pcf_owner_id.usr_work_num, t.created_dt, t.created_by, t.updated_dt, t.updated_by from bpm_process_file t left outer join bpm_process t_pcf_process_id on (t.pcf_process_id=t_pcf_process_id.row_id) left outer join bpm_activity_file t_pcf_acf_id on (t.pcf_acf_id=t_pcf_acf_id.row_id) left outer join bpm_process_file t_acf_pcf_id on (t_pcf_acf_id.acf_pcf_id=t_acf_pcf_id.row_id) left outer join bpm_process t_pcf_acf_id_acf_pcf_id_pcf_process_id on (t_acf_pcf_id.pcf_process_id=t_pcf_acf_id_acf_pcf_id_pcf_process_id.row_id) left outer join m_user t_pcf_owner_id on (t.pcf_owner_id=t_pcf_owner_id.row_id) where ( t.pcf_end_dt is null) and ( t.pcf_deadline_dt is not null and t.pcf_deadline_dt <=current_timestamp) order by t_pcf_process_id.pcs_name asc, t.pcf_serial asc, t.row_id asc Hosts= 2020-10-13 09:00:00,018|SIMPLICITE|http://9d656f7324d4:8080||ICORETM004|system|com.simplicite.util.engine.ProcessScheduler|manageDeadlineProcess||found 0 process(es) 2020-10-13 09:00:00,018|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.GrantManager|query||SQL query: select row_id, pcs_persist_depth, pcs_duration_unit from bpm_process where pcs_type = '1' and pcs_persitant = '1' 2020-10-13 09:00:00,019|SIMPLICITE|http://9d656f7324d4:8080||SQLUSER|system|DBAccess|SQL|query|SQL=select row_id, pcs_persist_depth, pcs_duration_unit from bpm_process where pcs_type = '1' and pcs_persitant = '1' Hosts= 2020-10-13 09:00:00,019|SIMPLICITE|http://9d656f7324d4:8080||REPOSITORY|system|BPMProcess|deadlineProcess||Message=Result: SQL= Hosts= 2020-10-13 09:00:00,019|SIMPLICITE|http://9d656f7324d4:8080||ICORECM005|system|com.simplicite.util.CronJob|run||Result of job deadlineProcess : 2020-10-13 09:00:00,019|SIMPLICITE|http://9d656f7324d4:8080||ICORECM004|system|com.simplicite.util.CronJob|run||Execute job ClearUserTokens at 2020-10-13 09:00:00 2020-10-13 09:00:00,019|SIMPLICITE|http://9d656f7324d4:8080||DCORECF001|system|com.simplicite.objects.Workflow.BPMActivity|postLoad||Configuration: Loaded configuration object BPMActivity () 2020-10-13 09:00:00,020|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.ObjectManager|query||SQL query: jdbc/simplicite: select t.row_id, t.utk_usr_id, t_utk_usr_id.usr_login, t.utk_token, t.utk_refreshtoken, t.utk_type, t.utk_provider, t.utk_clientid, t.utk_creationdate, t.utk_expirydate, t.utk_data from m_user_token t left outer join m_user t_utk_usr_id on (t.utk_usr_id=t_utk_usr_id.row_id) where (t.utk_expirydate<=?) order by t.utk_provider asc, t.row_id asc 2020-10-13 09:00:00,021|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB002|system|com.simplicite.util.engine.ObjectManager|query||Host: column [1] value (2020-10-13 09:00:00) 2020-10-13 09:00:00,021|SIMPLICITE|http://9d656f7324d4:8080||SQLUSER|system|DBAccess|SQL|query|SQL=jdbc/simplicite: select t.row_id, t.utk_usr_id, t_utk_usr_id.usr_login, t.utk_token, t.utk_refreshtoken, t.utk_type, t.utk_provider, t.utk_clientid, t.utk_creationdate, t.utk_expirydate, t.utk_data from m_user_token t left outer join m_user t_utk_usr_id on (t.utk_usr_id=t_utk_usr_id.row_id) where (t.utk_expirydate<=?) order by t.utk_provider asc, t.row_id asc Hosts=[2020-10-13 09:00:00] 2020-10-13 09:00:00,021|SIMPLICITE|http://9d656f7324d4:8080||REPOSITORY|system|UserToken|search||Message=found 0 row(s) SQL=select t.row_id, t.utk_usr_id, t_utk_usr_id.usr_login, t.utk_token, t.utk_refreshtoken, t.utk_type, t.utk_provider, t.utk_clientid, t.utk_creationdate, t.utk_expirydate, t.utk_data from m_user_token t left outer join m_user t_utk_usr_id on (t.utk_usr_id=t_utk_usr_id.row_id) where (t.utk_expirydate<=?) order by t.utk_provider asc, t.row_id asc Hosts=[2020-10-13 09:00:00] 2020-10-13 09:00:00,021|SIMPLICITE|http://9d656f7324d4:8080||REPOSITORY|system|UserToken|ClearUserTokens||Message=Result: No expired tokens to delete#WARNING SQL= Hosts= 2020-10-13 09:00:00,021|SIMPLICITE|http://9d656f7324d4:8080||ICORECM005|system|com.simplicite.util.CronJob|run||Result of job ClearUserTokens : No expired tokens to delete#WARNING 2020-10-13 09:00:00,021|SIMPLICITE|http://9d656f7324d4:8080||DCORECF001|system|com.simplicite.objects.System.BPMState|postLoad||Configuration: Loaded configuration object BPMState (.) 2020-10-13 09:00:00,021|SIMPLICITE|http://9d656f7324d4:8080||INFO|system|com.simplicite.util.engine.CronManager|run||Event: Next cron job: ObjectFullGC at Tue Oct 13 09:03:00 UTC 2020 2020-10-13 09:00:00,022|SIMPLICITE|http://9d656f7324d4:8080||ICORECM004|system|com.simplicite.util.CronJob|run||Execute job deadlockActivity at 2020-10-13 09:00:00 2020-10-13 09:00:00,022|SIMPLICITE|http://9d656f7324d4:8080||INFO|system|com.simplicite.util.engine.CronManager|run||Event: Cron manager is sleeping for 0:02:59... 2020-10-13 09:00:00,022|SIMPLICITE|http://9d656f7324d4:8080||ICORECM004|system|com.simplicite.util.CronJob|run||Execute job deadlineActivity at 2020-10-13 09:00:00 2020-10-13 09:00:00,022|SIMPLICITE|http://9d656f7324d4:8080||ICORECM004|system|com.simplicite.util.CronJob|run||Execute job deadlineState at 2020-10-13 09:00:00 2020-10-13 09:00:00,022|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.GrantManager|query||SQL query: select distinct o.obj_name, o.obj_dbtable, f.fld_dbname, s.sta_timeout, s.sta_alert_id, c.lov_code from bpm_state s, m_field f, m_objfield l, m_object o, m_list_code c where s.sta_state_id=c.row_id and f.fld_list_id=c.lov_list_id and f.row_id=l.obf_field_id and o.row_id=l.obf_object_id and f.fld_type='7' and s.sta_activ='1' and s.sta_alert_id is not null and s.sta_timeout>0 and l.obf_ref_field_id is null and o.obj_name not like '%Historic' 2020-10-13 09:00:00,022|SIMPLICITE|http://9d656f7324d4:8080||SQLUSER|system|DBAccess|SQL|query|SQL=select distinct o.obj_name, o.obj_dbtable, f.fld_dbname, s.sta_timeout, s.sta_alert_id, c.lov_code from bpm_state s, m_field f, m_objfield l, m_object o, m_list_code c where s.sta_state_id=c.row_id and f.fld_list_id=c.lov_list_id and f.row_id=l.obf_field_id and o.row_id=l.obf_object_id and f.fld_type='7' and s.sta_activ='1' and s.sta_alert_id is not null and s.sta_timeout>0 and l.obf_ref_field_id is null and o.obj_name not like '%Historic' Hosts= 2020-10-13 09:00:00,026|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.ObjectManager|query||SQL query: jdbc/simplicite: select t.row_id, t.acf_activity_id, t_acf_activity_id.acy_process_id, null, t_acy_process_id.pcs_name, t_acf_activity_id.acy_step, t_acf_activity_id.acy_type, t_acf_activity_id.acy_name, t.acf_status, t.acf_plan_dt, t.acf_start_dt, t.acf_deadline_dt, t.acf_end_dt, t.acf_waiting, t.acf_pcf_id, t_acf_pcf_id.pcf_serial, t_acf_pcf_id.pcf_process_id, t_pcf_process_id.pcs_name, t.acf_serial, t_acf_pcf_id.pcf_status, t_acf_pcf_id.pcf_start_dt, t_acf_pcf_id.pcf_deadline_dt, t_acf_pcf_id.pcf_end_dt, t_acf_pcf_id.pcf_object, t.acf_data, t.acf_owner_id, t_acf_owner_id.usr_login, t_acf_owner_id.usr_last_name, t_acf_owner_id.usr_first_name, t_acf_owner_id.usr_email, t_acf_owner_id.usr_work_num, t.created_dt, t.created_by, t.updated_dt, t.updated_by from bpm_activity_file t left outer join bpm_activity t_acf_activity_id on (t.acf_activity_id=t_acf_activity_id.row_id) left outer join bpm_process t_acy_process_id on (t_acf_activity_id.acy_process_id=t_acy_process_id.row_id) left outer join bpm_process_file t_acf_pcf_id on (t.acf_pcf_id=t_acf_pcf_id.row_id) left outer join bpm_process t_pcf_process_id on (t_acf_pcf_id.pcf_process_id=t_pcf_process_id.row_id) left outer join m_user t_acf_owner_id on (t.acf_owner_id=t_acf_owner_id.row_id) where ( t.acf_deadline_dt is not null and t.acf_deadline_dt <=current_timestamp) and ( t.acf_end_dt is null) order by t_acy_process_id.pcs_name asc, t_acf_pcf_id.pcf_serial asc, t.acf_serial asc, t.row_id asc 2020-10-13 09:00:00,026|SIMPLICITE|http://9d656f7324d4:8080||SQLUSER|system|DBAccess|SQL|query|SQL=jdbc/simplicite: select t.row_id, t.acf_activity_id, t_acf_activity_id.acy_process_id, null, t_acy_process_id.pcs_name, t_acf_activity_id.acy_step, t_acf_activity_id.acy_type, t_acf_activity_id.acy_name, t.acf_status, t.acf_plan_dt, t.acf_start_dt, t.acf_deadline_dt, t.acf_end_dt, t.acf_waiting, t.acf_pcf_id, t_acf_pcf_id.pcf_serial, t_acf_pcf_id.pcf_process_id, t_pcf_process_id.pcs_name, t.acf_serial, t_acf_pcf_id.pcf_status, t_acf_pcf_id.pcf_start_dt, t_acf_pcf_id.pcf_deadline_dt, t_acf_pcf_id.pcf_end_dt, t_acf_pcf_id.pcf_object, t.acf_data, t.acf_owner_id, t_acf_owner_id.usr_login, t_acf_owner_id.usr_last_name, t_acf_owner_id.usr_first_name, t_acf_owner_id.usr_email, t_acf_owner_id.usr_work_num, t.created_dt, t.created_by, t.updated_dt, t.updated_by from bpm_activity_file t left outer join bpm_activity t_acf_activity_id on (t.acf_activity_id=t_acf_activity_id.row_id) left outer join bpm_process t_acy_process_id on (t_acf_activity_id.acy_process_id=t_acy_process_id.row_id) left outer join bpm_process_file t_acf_pcf_id on (t.acf_pcf_id=t_acf_pcf_id.row_id) left outer join bpm_process t_pcf_process_id on (t_acf_pcf_id.pcf_process_id=t_pcf_process_id.row_id) left outer join m_user t_acf_owner_id on (t.acf_owner_id=t_acf_owner_id.row_id) where ( t.acf_deadline_dt is not null and t.acf_deadline_dt <=current_timestamp) and ( t.acf_end_dt is null) order by t_acy_process_id.pcs_name asc, t_acf_pcf_id.pcf_serial asc, t.acf_serial asc, t.row_id asc Hosts= 2020-10-13 09:00:00,026|SIMPLICITE|http://9d656f7324d4:8080||REPOSITORY|system|BPMActivityFile|search||Message=found 0 row(s) SQL=select t.row_id, t.acf_activity_id, t_acf_activity_id.acy_process_id, null, t_acy_process_id.pcs_name, t_acf_activity_id.acy_step, t_acf_activity_id.acy_type, t_acf_activity_id.acy_name, t.acf_status, t.acf_plan_dt, t.acf_start_dt, t.acf_deadline_dt, t.acf_end_dt, t.acf_waiting, t.acf_pcf_id, t_acf_pcf_id.pcf_serial, t_acf_pcf_id.pcf_process_id, t_pcf_process_id.pcs_name, t.acf_serial, t_acf_pcf_id.pcf_status, t_acf_pcf_id.pcf_start_dt, t_acf_pcf_id.pcf_deadline_dt, t_acf_pcf_id.pcf_end_dt, t_acf_pcf_id.pcf_object, t.acf_data, t.acf_owner_id, t_acf_owner_id.usr_login, t_acf_owner_id.usr_last_name, t_acf_owner_id.usr_first_name, t_acf_owner_id.usr_email, t_acf_owner_id.usr_work_num, t.created_dt, t.created_by, t.updated_dt, t.updated_by from bpm_activity_file t left outer join bpm_activity t_acf_activity_id on (t.acf_activity_id=t_acf_activity_id.row_id) left outer join bpm_process t_acy_process_id on (t_acf_activity_id.acy_process_id=t_acy_process_id.row_id) left outer join bpm_process_file t_acf_pcf_id on (t.acf_pcf_id=t_acf_pcf_id.row_id) left outer join bpm_process t_pcf_process_id on (t_acf_pcf_id.pcf_process_id=t_pcf_process_id.row_id) left outer join m_user t_acf_owner_id on (t.acf_owner_id=t_acf_owner_id.row_id) where ( t.acf_deadline_dt is not null and t.acf_deadline_dt <=current_timestamp) and ( t.acf_end_dt is null) order by t_acy_process_id.pcs_name asc, t_acf_pcf_id.pcf_serial asc, t.acf_serial asc, t.row_id asc Hosts= 2020-10-13 09:00:00,026|SIMPLICITE|http://9d656f7324d4:8080||ICORETM005|system|com.simplicite.util.engine.ProcessScheduler|manageDeadlineActivity||found 0 activity(ies) 2020-10-13 09:00:00,026|SIMPLICITE|http://9d656f7324d4:8080||REPOSITORY|system|BPMActivity|deadlineActivity||Message=Result: SQL= Hosts= 2020-10-13 09:00:00,026|SIMPLICITE|http://9d656f7324d4:8080||ICORECM005|system|com.simplicite.util.CronJob|run||Result of job deadlineActivity : 2020-10-13 09:00:00,026|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.GrantManager|query||SQL query: select sys_value, sys_value2 from m_system where sys_code='ACTIVITY_LOCK_LIMIT' 2020-10-13 09:00:00,027|SIMPLICITE|http://9d656f7324d4:8080||SQLSYSTEM|system|DBAccess|SQL|query|SQL=select sys_value, sys_value2 from m_system where sys_code='ACTIVITY_LOCK_LIMIT' Hosts= 2020-10-13 09:00:00,027|SIMPLICITE|http://9d656f7324d4:8080||ICORETM009|system|com.simplicite.util.engine.ProcessScheduler|manageDeadlockActivity||System param ACTIVITY_LOCK_LIMIT = 3600s 2020-10-13 09:00:00,027|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.ObjectManager|query||SQL query: jdbc/simplicite: select t.row_id, t.acf_activity_id, t_acf_activity_id.acy_process_id, null, t_acy_process_id.pcs_name, t_acf_activity_id.acy_step, t_acf_activity_id.acy_type, t_acf_activity_id.acy_name, t.acf_status, t.acf_plan_dt, t.acf_start_dt, t.acf_deadline_dt, t.acf_end_dt, t.acf_waiting, t.acf_pcf_id, t_acf_pcf_id.pcf_serial, t_acf_pcf_id.pcf_process_id, t_pcf_process_id.pcs_name, t.acf_serial, t_acf_pcf_id.pcf_status, t_acf_pcf_id.pcf_start_dt, t_acf_pcf_id.pcf_deadline_dt, t_acf_pcf_id.pcf_end_dt, t_acf_pcf_id.pcf_object, t.acf_data, t.acf_owner_id, t_acf_owner_id.usr_login, t_acf_owner_id.usr_last_name, t_acf_owner_id.usr_first_name, t_acf_owner_id.usr_email, t_acf_owner_id.usr_work_num, t.created_dt, t.created_by, t.updated_dt, t.updated_by from bpm_activity_file t left outer join bpm_activity t_acf_activity_id on (t.acf_activity_id=t_acf_activity_id.row_id) left outer join bpm_process t_acy_process_id on (t_acf_activity_id.acy_process_id=t_acy_process_id.row_id) left outer join bpm_process_file t_acf_pcf_id on (t.acf_pcf_id=t_acf_pcf_id.row_id) left outer join bpm_process t_pcf_process_id on (t_acf_pcf_id.pcf_process_id=t_pcf_process_id.row_id) left outer join m_user t_acf_owner_id on (t.acf_owner_id=t_acf_owner_id.row_id) where (t.acf_status='R') and ( t.acf_end_dt is null) order by t_acy_process_id.pcs_name asc, t_acf_pcf_id.pcf_serial asc, t.acf_serial asc, t.row_id asc 2020-10-13 09:00:00,027|SIMPLICITE|http://9d656f7324d4:8080||SQLUSER|system|DBAccess|SQL|query|SQL=jdbc/simplicite: select t.row_id, t.acf_activity_id, t_acf_activity_id.acy_process_id, null, t_acy_process_id.pcs_name, t_acf_activity_id.acy_step, t_acf_activity_id.acy_type, t_acf_activity_id.acy_name, t.acf_status, t.acf_plan_dt, t.acf_start_dt, t.acf_deadline_dt, t.acf_end_dt, t.acf_waiting, t.acf_pcf_id, t_acf_pcf_id.pcf_serial, t_acf_pcf_id.pcf_process_id, t_pcf_process_id.pcs_name, t.acf_serial, t_acf_pcf_id.pcf_status, t_acf_pcf_id.pcf_start_dt, t_acf_pcf_id.pcf_deadline_dt, t_acf_pcf_id.pcf_end_dt, t_acf_pcf_id.pcf_object, t.acf_data, t.acf_owner_id, t_acf_owner_id.usr_login, t_acf_owner_id.usr_last_name, t_acf_owner_id.usr_first_name, t_acf_owner_id.usr_email, t_acf_owner_id.usr_work_num, t.created_dt, t.created_by, t.updated_dt, t.updated_by from bpm_activity_file t left outer join bpm_activity t_acf_activity_id on (t.acf_activity_id=t_acf_activity_id.row_id) left outer join bpm_process t_acy_process_id on (t_acf_activity_id.acy_process_id=t_acy_process_id.row_id) left outer join bpm_process_file t_acf_pcf_id on (t.acf_pcf_id=t_acf_pcf_id.row_id) left outer join bpm_process t_pcf_process_id on (t_acf_pcf_id.pcf_process_id=t_pcf_process_id.row_id) left outer join m_user t_acf_owner_id on (t.acf_owner_id=t_acf_owner_id.row_id) where (t.acf_status='R') and ( t.acf_end_dt is null) order by t_acy_process_id.pcs_name asc, t_acf_pcf_id.pcf_serial asc, t.acf_serial asc, t.row_id asc Hosts= 2020-10-13 09:00:00,027|SIMPLICITE|http://9d656f7324d4:8080||REPOSITORY|system|BPMState|deadlineState||Message=Result: SQL= Hosts= 2020-10-13 09:00:00,027|SIMPLICITE|http://9d656f7324d4:8080||REPOSITORY|system|BPMActivityFile|search||Message=found 0 row(s) SQL=select t.row_id, t.acf_activity_id, t_acf_activity_id.acy_process_id, null, t_acy_process_id.pcs_name, t_acf_activity_id.acy_step, t_acf_activity_id.acy_type, t_acf_activity_id.acy_name, t.acf_status, t.acf_plan_dt, t.acf_start_dt, t.acf_deadline_dt, t.acf_end_dt, t.acf_waiting, t.acf_pcf_id, t_acf_pcf_id.pcf_serial, t_acf_pcf_id.pcf_process_id, t_pcf_process_id.pcs_name, t.acf_serial, t_acf_pcf_id.pcf_status, t_acf_pcf_id.pcf_start_dt, t_acf_pcf_id.pcf_deadline_dt, t_acf_pcf_id.pcf_end_dt, t_acf_pcf_id.pcf_object, t.acf_data, t.acf_owner_id, t_acf_owner_id.usr_login, t_acf_owner_id.usr_last_name, t_acf_owner_id.usr_first_name, t_acf_owner_id.usr_email, t_acf_owner_id.usr_work_num, t.created_dt, t.created_by, t.updated_dt, t.updated_by from bpm_activity_file t left outer join bpm_activity t_acf_activity_id on (t.acf_activity_id=t_acf_activity_id.row_id) left outer join bpm_process t_acy_process_id on (t_acf_activity_id.acy_process_id=t_acy_process_id.row_id) left outer join bpm_process_file t_acf_pcf_id on (t.acf_pcf_id=t_acf_pcf_id.row_id) left outer join bpm_process t_pcf_process_id on (t_acf_pcf_id.pcf_process_id=t_pcf_process_id.row_id) left outer join m_user t_acf_owner_id on (t.acf_owner_id=t_acf_owner_id.row_id) where (t.acf_status='R') and ( t.acf_end_dt is null) order by t_acy_process_id.pcs_name asc, t_acf_pcf_id.pcf_serial asc, t.acf_serial asc, t.row_id asc Hosts= 2020-10-13 09:00:00,028|SIMPLICITE|http://9d656f7324d4:8080||REPOSITORY|system|BPMActivity|deadlockActivity||Message=Result: SQL= Hosts= 2020-10-13 09:00:00,028|SIMPLICITE|http://9d656f7324d4:8080||ICORECM005|system|com.simplicite.util.CronJob|run||Result of job deadlockActivity : 2020-10-13 09:00:00,028|SIMPLICITE|http://9d656f7324d4:8080||ICORECM005|system|com.simplicite.util.CronJob|run||Result of job deadlineState : 2020-10-13 09:03:00,000|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.GrantManager|query||SQL query: select sys_value, sys_value2 from m_system where sys_code='CRON_LOCK' 2020-10-13 09:03:00,000|SIMPLICITE|http://9d656f7324d4:8080||SQLSYSTEM|system|DBAccess|SQL|query|SQL=select sys_value, sys_value2 from m_system where sys_code='CRON_LOCK' Hosts= 2020-10-13 09:03:00,000|SIMPLICITE|http://9d656f7324d4:8080||DCOREDB001|system|com.simplicite.util.engine.GrantManager|query||SQL query: select row_id from m_async_job where job_crontab_id=15 and job_start_dt