2017-06-27 13:02:03,065 TRACE http-apr-8090-exec-1:emcone(sso 172.26.99.11) [c.m.d.s.k.BLKernel3] [0s 50ms 1531MB/1540MB/2709MB] Invoked kernel3.dataviews.loaddata params {data=Tabulka: sdb_process sloupce: id_process,product_code,process_type,user_state,state_desc,progress_log,sys_state,id_pracovnik,date_start,date_finished,date_last_updated,kod_instance,steps_total,steps_current,steps_errors,user_process_name,job_steps_total,job_steps_current, øádky I:0, U:0, D: 0} 2017-06-27 13:02:03,066 TRACE http-apr-8090-exec-1:emcone(sso 172.26.99.11) [c.m.b.a.MyAnnotationConfigEmbeddedWebApplicationContext] Publishing event in cz.marbes.boot.application.MyAnnotationConfigEmbeddedWebApplicationContext@69f0adcd: ServletRequestHandledEvent: url=[/aa3/aa/webservices/mcdas]; client=[172.26.99.11]; method=[POST]; servlet=[aa]; session=[20A0B2C8EC127D60FBBB4FF72096DD44]; user=[null]; time=[51ms]; status=[OK] 2017-06-27 13:02:05,197 DEBUG http-apr-8090-exec-8:vacha(web) [o.h.SQL] select vokonfigur0_.id_konfigurace_isrs as id_konfi1_83_0_, vokonfigur0_.platnost_do as platnost2_83_0_, vokonfigur0_.platnost_od as platnost3_83_0_, vokonfigur0_.posledni as posledni4_83_0_, vokonfigur0_.ukoncil as ukoncil5_83_0_, vokonfigur0_.zalozil as zalozil6_83_0_, vokonfigur0_.cv_konfigurace_isrs as cv_konfi7_83_0_, vokonfigur0_.datum_zpracovani as datum_zp8_83_0_, vokonfigur0_.id_connector_odpoved as id_conne9_83_0_, vokonfigur0_.id_connector_pozadavek as id_conn10_83_0_, vokonfigur0_.login_odpoved as login_o11_83_0_, vokonfigur0_.login_pozadavek as login_p12_83_0_, vokonfigur0_.zalozit_do_spisu as zalozit13_83_0_ from zveisrs_konfigurace_isrs vokonfigur0_ where vokonfigur0_.id_konfigurace_isrs=? 2017-06-27 13:02:05,201 DEBUG http-apr-8090-exec-8:vacha(web) [o.h.SQL] update zveisrs_konfigurace_isrs set platnost_do=?, platnost_od=?, posledni=?, ukoncil=?, zalozil=?, cv_konfigurace_isrs=?, datum_zpracovani=?, id_connector_odpoved=?, id_connector_pozadavek=?, login_odpoved=?, login_pozadavek=?, zalozit_do_spisu=? where id_konfigurace_isrs=? 2017-06-27 13:02:05,210 DEBUG http-apr-8090-exec-8:vacha(web) [o.h.SQL] select vokonfigur0_.id_konfigurace_sbj_isrs as id_konfi1_84_, vokonfigur0_.platnost_do as platnost2_84_, vokonfigur0_.platnost_od as platnost3_84_, vokonfigur0_.posledni as posledni4_84_, vokonfigur0_.ukoncil as ukoncil5_84_, vokonfigur0_.zalozil as zalozil6_84_, vokonfigur0_.cv_konfigurace_sbj_isrs as cv_konfi7_84_, vokonfigur0_.id_konfigurace_isrs as id_konfi8_84_, vokonfigur0_.id_organizace as id_organ9_84_ from zveisrs_konfigurace_sbj_isrs vokonfigur0_ where vokonfigur0_.id_konfigurace_isrs=? 2017-06-27 13:02:05,212 DEBUG http-apr-8090-exec-8:vacha(web) [o.h.SQL] select vosubjekt0_.id_organizace as id_organ1_80_0_, vosubjekt0_.platnost_do as platnost2_80_0_, vosubjekt0_.platnost_od as platnost3_80_0_, vosubjekt0_.posledni as posledni4_80_0_, vosubjekt0_.ukoncil as ukoncil5_80_0_, vosubjekt0_.zalozil as zalozil6_80_0_, vosubjekt0_.adresa as adresa7_80_0_, vosubjekt0_.cv_subjekt as cv_subje8_80_0_, vosubjekt0_.datova_schranka as datova_s9_80_0_ from zve_subjekt vosubjekt0_ where vosubjekt0_.id_organizace=? 2017-06-27 13:02:05,214 DEBUG http-apr-8090-exec-8:vacha(web) [o.h.SQL] select vokonfigur0_.id_konfigurace_isrs as id_konfi1_83_, vokonfigur0_.platnost_do as platnost2_83_, vokonfigur0_.platnost_od as platnost3_83_, vokonfigur0_.posledni as posledni4_83_, vokonfigur0_.ukoncil as ukoncil5_83_, vokonfigur0_.zalozil as zalozil6_83_, vokonfigur0_.cv_konfigurace_isrs as cv_konfi7_83_, vokonfigur0_.datum_zpracovani as datum_zp8_83_, vokonfigur0_.id_connector_odpoved as id_conne9_83_, vokonfigur0_.id_connector_pozadavek as id_conn10_83_, vokonfigur0_.login_odpoved as login_o11_83_, vokonfigur0_.login_pozadavek as login_p12_83_, vokonfigur0_.zalozit_do_spisu as zalozit13_83_ from zveisrs_konfigurace_isrs vokonfigur0_ 2017-06-27 13:02:05,218 DEBUG http-apr-8090-exec-8:vacha(web) [o.h.SQL] select vocfgconne0_.id_connector as id_conne1_2_0_, vocfgconne0_.platnost_do as platnost2_2_0_, vocfgconne0_.platnost_od as platnost3_2_0_, vocfgconne0_.posledni as posledni4_2_0_, vocfgconne0_.ukoncil as ukoncil5_2_0_, vocfgconne0_.zalozil as zalozil6_2_0_, vocfgconne0_.connector as connecto7_2_0_, vocfgconne0_.cv_connector as cv_conne8_2_0_, vocfgconne0_.id_oj as id_oj9_2_0_, vocfgconne0_.nazev_instance as nazev_i10_2_0_ from cfg_connector vocfgconne0_ where vocfgconne0_.id_connector=? 2017-06-27 13:02:05,227 DEBUG http-apr-8090-exec-8:vacha(web) [o.h.SQL] select vokonfigur0_.id_konfigurace_sbj_isrs as id_konfi1_84_, vokonfigur0_.platnost_do as platnost2_84_, vokonfigur0_.platnost_od as platnost3_84_, vokonfigur0_.posledni as posledni4_84_, vokonfigur0_.ukoncil as ukoncil5_84_, vokonfigur0_.zalozil as zalozil6_84_, vokonfigur0_.cv_konfigurace_sbj_isrs as cv_konfi7_84_, vokonfigur0_.id_konfigurace_isrs as id_konfi8_84_, vokonfigur0_.id_organizace as id_organ9_84_ from zveisrs_konfigurace_sbj_isrs vokonfigur0_ where vokonfigur0_.id_konfigurace_isrs=? 2017-06-27 13:02:05,228 DEBUG http-apr-8090-exec-8:vacha(web) [o.h.SQL] select voorganiza0_.id_organizace as id_organ1_11_0_, voorganiza0_.platnost_do as platnost2_11_0_, voorganiza0_.platnost_od as platnost3_11_0_, voorganiza0_.posledni as posledni4_11_0_, voorganiza0_.ukoncil as ukoncil5_11_0_, voorganiza0_.zalozil as zalozil6_11_0_, voorganiza0_.cv_organizace as cv_organ7_11_0_, voorganiza0_.dic as dic8_11_0_, voorganiza0_.eos_id_oj as eos_id_o9_11_0_, voorganiza0_.ico as ico10_11_0_, voorganiza0_.kod_organizace as kod_org11_11_0_, voorganiza0_.nazev_organizace as nazev_o12_11_0_, voorganiza0_.ovm as ovm13_11_0_ from eo_organizace voorganiza0_ where voorganiza0_.id_organizace=? 2017-06-27 13:02:05,231 DEBUG http-apr-8090-exec-8:vacha(web) [o.h.SQL] select vopozadave0_.id_pozadavek_isrs as id_pozad1_86_, vopozadave0_.platnost_do as platnost2_86_, vopozadave0_.platnost_od as platnost3_86_, vopozadave0_.posledni as posledni4_86_, vopozadave0_.ukoncil as ukoncil5_86_, vopozadave0_.zalozil as zalozil6_86_, vopozadave0_.cj_pisemnost as cj_pisem7_86_, vopozadave0_.cv_pozadavek_isrs as cv_pozad8_86_, vopozadave0_.id_dokument_pdf as id_doku14_86_, vopozadave0_.id_datove_zpravy as id_datov9_86_, vopozadave0_.id_externi as id_exte10_86_, vopozadave0_.id_isrs_smlouva as id_isrs11_86_, vopozadave0_.id_isrs_verze as id_isrs12_86_, vopozadave0_.id_konfigurace_isrs as id_konf15_86_, vopozadave0_.id_pozadavek as id_poza16_86_, vopozadave0_.xml as xml13_86_ from zveisrs_pozadavek_isrs vopozadave0_ where vopozadave0_.id_konfigurace_isrs=? 2017-06-27 13:02:05,236 DEBUG http-apr-8090-exec-8:vacha(web) [o.h.SQL] select voodpovedi0_.id_odpoved_isrs as id_odpov1_85_, voodpovedi0_.platnost_do as platnost2_85_, voodpovedi0_.platnost_od as platnost3_85_, voodpovedi0_.posledni as posledni4_85_, voodpovedi0_.ukoncil as ukoncil5_85_, voodpovedi0_.zalozil as zalozil6_85_, voodpovedi0_.cv_odpoved_isrs as cv_odpov7_85_, voodpovedi0_.datum_zpracovani as datum_zp8_85_, voodpovedi0_.id_dokument_pdf as id_doku11_85_, voodpovedi0_.id_datove_zpravy as id_datov9_85_, voodpovedi0_.id_konfigurace_isrs as id_konf12_85_, voodpovedi0_.id_pozadavek_isrs as id_poza13_85_, voodpovedi0_.xml as xml10_85_ from zveisrs_odpoved_isrs voodpovedi0_ where voodpovedi0_.id_konfigurace_isrs=? 2017-06-27 13:02:07,483 DEBUG http-apr-8090-exec-4:vacha(web) [o.h.SQL] select vopozadave0_.id_pozadavek_isrs as id_pozad1_86_, vopozadave0_.platnost_do as platnost2_86_, vopozadave0_.platnost_od as platnost3_86_, vopozadave0_.posledni as posledni4_86_, vopozadave0_.ukoncil as ukoncil5_86_, vopozadave0_.zalozil as zalozil6_86_, vopozadave0_.cj_pisemnost as cj_pisem7_86_, vopozadave0_.cv_pozadavek_isrs as cv_pozad8_86_, vopozadave0_.id_dokument_pdf as id_doku14_86_, vopozadave0_.id_datove_zpravy as id_datov9_86_, vopozadave0_.id_externi as id_exte10_86_, vopozadave0_.id_isrs_smlouva as id_isrs11_86_, vopozadave0_.id_isrs_verze as id_isrs12_86_, vopozadave0_.id_konfigurace_isrs as id_konf15_86_, vopozadave0_.id_pozadavek as id_poza16_86_, vopozadave0_.xml as xml13_86_ from zveisrs_pozadavek_isrs vopozadave0_ where vopozadave0_.id_datove_zpravy is null 2017-06-27 13:02:07,485 INFO http-apr-8090-exec-4:vacha(web) [c.m.z.i.s.IsrsOdpovedService] Spusteni parovani odpovedi... 2017-06-27 13:02:07,485 DEBUG http-apr-8090-exec-4:vacha(web) [o.h.SQL] select voodpovedi0_.id_odpoved_isrs as col_0_0_ from zveisrs_odpoved_isrs voodpovedi0_ where (voodpovedi0_.id_datove_zpravy is not null) and (voodpovedi0_.id_pozadavek_isrs is null) order by voodpovedi0_.id_datove_zpravy 2017-06-27 13:02:07,486 INFO http-apr-8090-exec-4:vacha(web) [c.m.z.i.s.IsrsOdpovedService] Dokonceno nacitani a parovani odpovedi 2017-06-27 13:02:07,540 TRACE http-apr-8090-exec-3:URAD\emcone(ntlm2) [c.m.d.s.k.BLKernel3] [ 1501MB/1541MB/2709MB] Invoking kernel3.dataviews.loaddata params {entityname=SDB_Process, attributenames=ID_Process;Product_Code;Process_Type;User_State;State_Desc;progress_log;Sys_State;ID_Pracovnik;Date_Start;Date_Finished;Date_Last_Updated;kod_instance;steps_total;steps_current;steps_errors;User_Process_Name;job_steps_total;job_steps_current, filterxml=Sys_StateRProduct_CodeAAID_Pracovnik1, loadonlyreqattributes=false, multiedit=false, logovat=false} 2017-06-27 13:02:07,589 DEBUG http-apr-8090-exec-3:URAD\emcone(ntlm2) [c.m.d.s.k.s.SqlBuilder$SqlBuilderDao] 0s 39ms select main.id_process, main.product_code, main.process_type, main.user_state, main.state_desc, main.progress_log, main.sys_state, main.id_pracovnik, main.date_start, main.date_finished, main.date_last_updated, main.kod_instance, main.steps_total, main.steps_current, main.steps_errors, main.user_process_name, main.job_steps_total, main.job_steps_current from sdb_process main where (main.sys_state = 'R' and main.product_code = 'AA' and main.id_pracovnik = 1)