API tools faq
paste
DOS93

Untitled

DOS93
Dec 18th, 2020
257
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Apache Log 196.41 KB | None | 0 0
raw download clone embed print report
  1. December 17th 2020, 16:31:43.223    2020-12-17 14:31:43.223 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.security.web.FilterChainProxy        : /api/report/online/ at position 11 of 15 in additional filter chain; firing Filter: 'SecurityContextHolderAwareRequestFilter'   backend develop-dev-roscap
  2.     December 17th 2020, 16:31:43.223    2020-12-17 14:31:43.223 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.security.web.FilterChainProxy        : /api/report/online/ at position 9 of 15 in additional filter chain; firing Filter: 'SpnegoAuthenticationProcessingFilter'   backend develop-dev-roscap
  3.     December 17th 2020, 16:31:43.223    2020-12-17 14:31:43.223 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.w.a.AnonymousAuthenticationFilter  : SecurityContextHolder not populated with anonymous token, as it already contained: 'ru.lanit.rbs.authapi.dto.UserAuthentication@ea5f1742: Principal: ru.lanit.rbs.authapi.dto.ppa.PpaUserData@15a0e886; Credentials: [PROTECTED]; Authenticated: true; Details: null; Not granted any authorities'  backend develop-dev-roscap
  4.     December 17th 2020, 16:31:43.223    2020-12-17 14:31:43.223 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.security.web.FilterChainProxy        : /api/report/online/ at position 8 of 15 in additional filter chain; firing Filter: 'RequestCacheAwareFilter'    backend develop-dev-roscap
  5.     December 17th 2020, 16:31:43.223    2020-12-17 14:31:43.223 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.security.web.FilterChainProxy        : /api/report/online/ at position 14 of 15 in additional filter chain; firing Filter: 'ExceptionTranslationFilter'    backend develop-dev-roscap
  6.     December 17th 2020, 16:31:43.223    2020-12-17 14:31:43.223 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/api/session/get/user'  backend develop-dev-roscap
  7.     December 17th 2020, 16:31:43.223    2020-12-17 14:31:43.223 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.security.web.FilterChainProxy        : /api/report/online/ at position 10 of 15 in additional filter chain; firing Filter: 'SpnegoNegotiateHeaderRemoveFilter' backend develop-dev-roscap
  8.     December 17th 2020, 16:31:43.223    2020-12-17 14:31:43.223 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.security.web.FilterChainProxy        : /api/report/online/ at position 12 of 15 in additional filter chain; firing Filter: 'AnonymousAuthenticationFilter' backend develop-dev-roscap
  9.     December 17th 2020, 16:31:43.223    2020-12-17 14:31:43.223 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.security.web.FilterChainProxy        : /api/report/online/ at position 13 of 15 in additional filter chain; firing Filter: 'SessionManagementFilter'   backend develop-dev-roscap
  10.     December 17th 2020, 16:31:43.223    2020-12-17 14:31:43.223 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.security.web.FilterChainProxy        : /api/report/online/ at position 15 of 15 in additional filter chain; firing Filter: 'FilterSecurityInterceptor' backend develop-dev-roscap
  11.     December 17th 2020, 16:31:43.223    2020-12-17 14:31:43.223 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/api/swagger-ui/**' backend develop-dev-roscap
  12.     December 17th 2020, 16:31:43.223    2020-12-17 14:31:43.223 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/api/swagger-docs/**'   backend develop-dev-roscap
  13.     December 17th 2020, 16:31:43.224    2020-12-17 14:31:43.223 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/api/session/**'    backend develop-dev-roscap
  14.     December 17th 2020, 16:31:43.224    2020-12-17 14:31:43.223 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/api/settings/get'  backend develop-dev-roscap
  15.     December 17th 2020, 16:31:43.224    2020-12-17 14:31:43.224 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/api/electronic-dossier-int/**' backend develop-dev-roscap
  16.     December 17th 2020, 16:31:43.224    2020-12-17 14:31:43.224 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.w.util.matcher.AndRequestMatcher   : Trying to match using OrRequestMatcher [requestMatchers=[Ant [pattern='/sso/login'], RequestHeaderRequestMatcher [expectedHeaderName=Authorization, expectedHeaderValue=null], org.keycloak.adapters.springsecurity.filter.QueryParamPresenceRequestMatcher@20a7a021, org.keycloak.adapters.springsecurity.filter.AdapterStateCookieRequestMatcher@5cbe765d]]   backend develop-dev-roscap
  17.     December 17th 2020, 16:31:43.224    2020-12-17 14:31:43.224 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/sso/login' backend develop-dev-roscap
  18.     December 17th 2020, 16:31:43.224    2020-12-17 14:31:43.224 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.web.util.matcher.OrRequestMatcher  : Trying to match using org.keycloak.adapters.springsecurity.filter.AdapterStateCookieRequestMatcher@5cbe765d backend develop-dev-roscap
  19.     December 17th 2020, 16:31:43.224    2020-12-17 14:31:43.224 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.w.util.matcher.AndRequestMatcher   : Did not match   backend develop-dev-roscap
  20.     December 17th 2020, 16:31:43.224    2020-12-17 14:31:43.224 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.web.util.matcher.OrRequestMatcher  : Trying to match using org.keycloak.adapters.springsecurity.filter.QueryParamPresenceRequestMatcher@20a7a021 backend develop-dev-roscap
  21.     December 17th 2020, 16:31:43.224    2020-12-17 14:31:43.224 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.web.util.matcher.OrRequestMatcher  : No matches found    backend develop-dev-roscap
  22.     December 17th 2020, 16:31:43.224    2020-12-17 14:31:43.223 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/api/ppa/tokens/**/email/confirm'   backend develop-dev-roscap
  23.     December 17th 2020, 16:31:43.224    2020-12-17 14:31:43.224 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/direct-bank-gateway/**'    backend develop-dev-roscap
  24.     December 17th 2020, 16:31:43.224    2020-12-17 14:31:43.224 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.access.vote.AffirmativeBased       : Voter: org.springframework.security.web.access.expression.WebExpressionVoter@ec27bc, returned: 1    backend develop-dev-roscap
  25.     December 17th 2020, 16:31:43.224    2020-12-17 14:31:43.224 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.w.a.i.FilterSecurityInterceptor    : Authorization successful    backend develop-dev-roscap
  26.     December 17th 2020, 16:31:43.224    2020-12-17 14:31:43.224 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.web.util.matcher.OrRequestMatcher  : Trying to match using Ant [pattern='/sso/login']    backend develop-dev-roscap
  27.     December 17th 2020, 16:31:43.224    2020-12-17 14:31:43.223 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/api/test/**'   backend develop-dev-roscap
  28.     December 17th 2020, 16:31:43.224    2020-12-17 14:31:43.224 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.w.a.i.FilterSecurityInterceptor    : RunAsManager did not change Authentication object   backend develop-dev-roscap
  29.     December 17th 2020, 16:31:43.224    2020-12-17 14:31:43.223 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/actuator/**'   backend develop-dev-roscap
  30.     December 17th 2020, 16:31:43.224    2020-12-17 14:31:43.224 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/api/auth-external/**'  backend develop-dev-roscap
  31.     December 17th 2020, 16:31:43.224    2020-12-17 14:31:43.224 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.w.a.i.FilterSecurityInterceptor    : Previously Authenticated: ru.lanit.rbs.authapi.dto.UserAuthentication@ea5f1742: Principal: ru.lanit.rbs.authapi.dto.ppa.PpaUserData@15a0e886; Credentials: [PROTECTED]; Authenticated: true; Details: null; Not granted any authorities backend develop-dev-roscap
  32.     December 17th 2020, 16:31:43.224    2020-12-17 14:31:43.224 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.web.util.matcher.OrRequestMatcher  : Trying to match using RequestHeaderRequestMatcher [expectedHeaderName=Authorization, expectedHeaderValue=null]  backend develop-dev-roscap
  33.     December 17th 2020, 16:31:43.224    2020-12-17 14:31:43.223 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/bpm-api/**'    backend develop-dev-roscap
  34.     December 17th 2020, 16:31:43.224    2020-12-17 14:31:43.223 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/api/ppa/employee/keycloak/phone/confirm'"rootId":10370,"customerOrgRootId":19,"performerOrgRootIds":[],"accompaniedContract":"БС110ЛАНИТ","objects":[{"rootId":321,"objectAddress":"Московская область, Москва, ул. Тверская 22","objectName":"ЖК МАНХЭТТЕН","objectNumber":"21312","issueDate":{"year":2020,"month":8,"day":13},"projectId":"677790","id":435,"lastEditingDate":{"dateTime":{"date":{"year":2020,"month":10,"day":14},"time":{"hour":11,"minute":5,"second":35,"nano":852338000}},"offset":{"totalSeconds":10800}}},{"rootId":319,"objectAddress":"Московская область, Москва, ул. Тверская 22-2","objectName":"ЖК МАНХЭТТЕН","objectNumber":"21312","issueDate":{"year":2020,"month":8,"day":13},"projectId":"677790","id":433,"lastEditingDate":{"dateTime":{"date":{"year":2020,"month":10,"day":14},"time":{"hour":11,"minute":5,"second":26,"nano":15370000}},"offset":{"totalSeconds":10800}}},{"rootId":320,"objectAddress":"Московская область, Москва, ул. Тверская 22-3","objectName":"ЖК МАНХЭТТЕН","objectNumber":"21312","issueDate":{"year":2020,"month":8,"day":13},"projectId":"677790","id":434,"lastEditingDate":{"dateTime":{"date":{"year":2020,"month":10,"day":14},"time":{"hour":11,"minute":5,"second":30,"nano":992385000}},"offset":{"totalSeconds":10800}}}],"quarterlyReportPeriod":{"startDate":{"year":2020,"month":8,"day":12},"endDate":{"year":2020,"month":12,"day":17}},"agreementDate":{"year":2020,"month":8,"day":12},"reportKinds":["REPORT_5"]}    backend develop-dev-roscap
  35.     December 17th 2020, 16:31:44.734    2020-12-17 14:31:44.734 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [lTaskExecutor-4] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: aDbs77.run() params = ([10370], 2020-12-17)
  36. Hibernate: select agreementb0_.id as id2_9_, agreementb0_.last_editing_date as last_edi3_9_, agreementb0_.root_id as root_id4_9_, agreementb0_.accepted as accepted5_9_, agreementb0_.actual as actual6_9_, agreementb0_.agreement_date as agreemen7_9_, agreementb0_.agreement_number as agreemen8_9_, agreementb0_.create_date as create_d9_9_, agreementb0_.edit_reason as edit_re10_9_, agreementb0_.edit_reason_id as edit_re11_9_, agreementb0_.editor_employee_id as editor_12_9_, agreementb0_.editor_organization_id as editor_13_9_, agreementb0_.editor_organization_version_id as editor_14_9_, agreementb0_.from_credit_road as from_cr15_9_, agreementb0_.locked as locked16_9_, agreementb0_.on_paper as on_pape17_9_, agreementb0_.organization_id as organiz18_9_, agreementb0_.organization_version_id as organiz19_9_, agreementb0_.rejected_employee_root_id as rejecte20_9_, agreementb0_.status_root_id as status_21_9_, agreementb0_.system_number as system_22_9_, agreementb0_.version_number as version23_9_, agreementb0_.accompanied_contract as accompa24_9_, agreementb0_.accounting_type_id as account25_9_, agreementb0_.additional_info as additio26_9_, agreementb0_.controlled_cooperation_level_id as control27_9_, agreementb0_.need_change_status_to_sba as need_ch28_9_, agreementb0_.project_management_root_id as project29_9_, agreementb0_.readiness_compliant as readine30_9_, agreementb0_.responsible_employee as respons31_9_ from bagrsm.bagr_agreement agreementb0_ where agreementb0_.agreement_type_root_id=1 and agreementb0_.root_id=? and agreementb0_.status_root_id=? and DATE(agreementb0_.agreement_date)<=?
  37. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=? backend develop-dev-roscap
  38.     December 17th 2020, 16:31:45.300    2020-12-17 14:31:45.300 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [lTaskExecutor-4] r.l.r.b.i.b.info.AgreementBsServiceImpl  : Found 6 bank support agreements backend develop-dev-roscap
  39.     December 17th 2020, 16:31:45.302    2020-12-17 14:31:45.302 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [lTaskExecutor-4] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: aDbs77.run() aDbs77Response = {"data":{"10370":[{"performerOrgRootId":142,"contractorAgreements":[{"contractorAgreementId":30211,"contractorAgreementRootId":30211}]},{"performerOrgRootId":162,"cooperationLevel":6,"contractorAgreements":[{"contractorAgreementId":30180,"contractorAgreementRootId":30178}]},{"performerOrgRootId":142,"cooperationLevel":4,"contractorAgreements":[{"contractorAgreementId":30170,"contractorAgreementRootId":30170}]},{"performerOrgRootId":6,"contractorAgreements":[{"contractorAgreementId":30214,"contractorAgreementRootId":30214}]},{"performerOrgRootId":25,"cooperationLevel":5,"contractorAgreements":[{"contractorAgreementId":30171,"contractorAgreementRootId":30171}]},{"performerOrgRootId":20,"cooperationLevel":1,"contractorAgreements":[{"contractorAgreementId":30164,"contractorAgreementRootId":30164}]},{"performerOrgRootId":5,"cooperationLevel":2,"contractorAgreements":[{"contractorAgreementId":30165,"contractorAgreementRootId":30165}]},{"performerOrgRootId":6,"cooperationLevel":3,"contractorAgreements":[{"contractorAgreementId":30169,"contractorAgreementRootId":30169}]},{"performerOrgRootId":19,"cooperationLevel":0,"contractorAgreements":[{"contractorAgreementId":30164,"contractorAgreementRootId":30164}]},{"performerOrgRootId":226,"contractorAgreements":[{"contractorAgreementId":30235,"contractorAgreementRootId":30235}]}]}}   backend develop-dev-roscap
  40.     December 17th 2020, 16:31:45.302    2020-12-17 14:31:45.302 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [lTaskExecutor-4] r.l.r.r.impl.helper.ReportRequestHelper  : Trace-A_O_2: performerOrgRootIds=[162, 226, 19, 20, 5, 6, 25, 142], isOnline2and4Only=false
  41. Hibernate: select organizati0_.id as id1_223_, organizati0_.last_editing_date as last_edi2_223_, organizati0_.actual as actual3_223_, organizati0_.version_create_date as version_4_223_, organizati0_.version_number as version_5_223_, organizati0_.address as address6_223_, organizati0_.agency_territory as agency_t7_223_, organizati0_.agency_type as agency_t8_223_, organizati0_.is_branch as is_branc9_223_, organizati0_.branches_count as branche10_223_, organizati0_.data_source as data_so11_223_, organizati0_.email as email12_223_, organizati0_.email_confirmed as email_c13_223_, organizati0_.esia_id as esia_id14_223_, organizati0_.factual_address as factual15_223_, organizati0_.fax as fax16_223_, organizati0_.full_name as full_na17_223_, organizati0_.head_ppa_org_id as head_pp37_223_, organizati0_.ifrs_reporting as ifrs_re18_223_, organizati0_.information_source_root_id as informa19_223_, organizati0_.inn as inn20_223_, organizati0_.kpp as kpp21_223_, organizati0_.na_branch_code as na_bran22_223_, organizati0_.na_client_id as na_clie23_223_, organizati0_.na_id as na_id24_223_, organizati0_.na_status as na_stat25_223_, organizati0_.na_update_date as na_upda26_223_, organizati0_.ogrn as ogrn27_223_, organizati0_.okopf_code as okopf_c28_223_, organizati0_.ppa_organization_id as ppa_org29_223_, organizati0_.organization_type as organiz30_223_, organizati0_.phone as phone31_223_, organizati0_.short_name as short_n32_223_, organizati0_.state_registration_date as state_r33_223_, organizati0_.status_id as status_38_223_, organizati0_.statutory_full_name as statuto34_223_, organizati0_.statutory_name_differs as statuto35_223_, organizati0_.statutory_short_name as statuto36_223_ from ppasm.ppa_organization_version organizati0_ where (organizati0_.ppa_organization_id in (? , ? , ? , ? , ? , ? , ? , ?)) and organizati0_.actual=?
  42. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  43. Hibernate: select agreementb0_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  44. Hibernate: select organizati0_.id as id1_219_0_, organizati0_.last_editing_date as last_edi2_219_0_, organizati0_.login_1c as login_3_219_0_, organizati0_.ogrn as ogrn4_219_0_, organizati0_.password_1c as password5_219_0_, organizati0_.session_expiration_1c as session_6_219_0_, organizati0_.session_id_1c as session_7_219_0_ from ppasm.ppa_organization organizati0_ where organizati0_.id=?
  45. Hibernate: select organizati0_.id as id1_222_0_, organizati0_.last_editing_date as last_edi2_222_0_, organizati0_.block as block3_222_0_, organizati0_.block_date as block_da4_222_0_, organizati0_.block_reason_id as block_re5_222_0_, organizati0_.on_registration as on_regis6_222_0_, organizati0_.registered as register7_222_0_, organizati0_.registration_date as registra8_222_0_ from ppasm.ppa_organization_status organizati0_ where organizati0_.id=?
  46. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  47. Hibernate: select organizati0_.id as id1_219_0_, organizati0_.last_editing_date as last_edi2_219_0_, organizati0_.login_1c as login_3_219_0_, organizati0_.ogrn as ogrn4_219_0_, organizati0_.password_1c as password5_219_0_, organizati0_.session_expiration_1c as session_6_219_0_, organizati0_.session_id_1c as session_7_219_0_ from ppasm.ppa_organization organizati0_ where organizati0_.id=?
  48. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  49. Hibernate: select organizati0_.id as id1_222_0_, organizati0_.last_editing_date as last_edi2_222_0_, organizati0_.block as block3_222_0_, organizati0_.block_date as block_da4_222_0_, organizati0_.block_reason_id as block_re5_222_0_, organizati0_.on_registration as on_regis6_222_0_, organizati0_.registered as register7_222_0_, organizati0_.registration_date as registra8_222_0_ from ppasm.ppa_organization_status organizati0_ where organizati0_.id=?
  50. Hibernate: select agreementb0_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  51. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  52. Hibernate: select organizati0_.id as id1_219_0_, organizati0_.last_editing_date as last_edi2_219_0_, organizati0_.login_1c as login_3_219_0_, organizati0_.ogrn as ogrn4_219_0_, organizati0_.password_1c as password5_219_0_, organizati0_.session_expiration_1c as session_6_219_0_, organizati0_.session_id_1c as session_7_219_0_ from ppasm.ppa_organization organizati0_ where organizati0_.id=?
  53. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  54. Hibernate: select organizati0_.id as id1_222_0_, organizati0_.last_editing_date as last_edi2_222_0_, organizati0_.block as block3_222_0_, organizati0_.block_date as block_da4_222_0_, organizati0_.block_reason_id as block_re5_222_0_, organizati0_.on_registration as on_regis6_222_0_, organizati0_.registered as register7_222_0_, organizati0_.registration_date as registra8_222_0_ from ppasm.ppa_organization_status organizati0_ where organizati0_.id=?
  55. Hibernate: select agreementb0_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  56. Hibernate: select organizati0_.id as id1_219_0_, organizati0_.last_editing_date as last_edi2_219_0_, organizati0_.login_1c as login_3_219_0_, organizati0_.ogrn as ogrn4_219_0_, organizati0_.password_1c as password5_219_0_, organizati0_.session_expiration_1c as session_6_219_0_, organizati0_.session_id_1c as session_7_219_0_ from ppasm.ppa_organization organizati0_ where organizati0_.id=?
  57. Hibernate: select organizati0_.id as id1_222_0_, organizati0_.last_editing_date as last_edi2_222_0_, organizati0_.block as block3_222_0_, organizati0_.block_date as block_da4_222_0_, organizati0_.block_reason_id as block_re5_222_0_, organizati0_.on_registration as on_regis6_222_0_, organizati0_.registered as register7_222_0_, organizati0_.registration_date as registra8_222_0_ from ppasm.ppa_organization_status organizati0_ where organizati0_.id=?
  58. Hibernate: select organizati0_.id as id1_219_0_, organizati0_.last_editing_date as last_edi2_219_0_, organizati0_.login_1c as login_3_219_0_, organizati0_.ogrn as ogrn4_219_0_, organizati0_.password_1c as password5_219_0_, organizati0_.session_expiration_1c as session_6_219_0_, organizati0_.session_id_1c as session_7_219_0_ from ppasm.ppa_organization organizati0_ where organizati0_.id=?
  59. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  60. Hibernate: select organizati0_.id as id1_222_0_, organizati0_.last_editing_date as last_edi2_222_0_, organizati0_.block as block3_222_0_, organizati0_.block_date as block_da4_222_0_, organizati0_.block_reason_id as block_re5_222_0_, organizati0_.on_registration as on_regis6_222_0_, organizati0_.registered as register7_222_0_, organizati0_.registration_date as registra8_222_0_ from ppasm.ppa_organization_status organizati0_ where organizati0_.id=?
  61. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  62. Hibernate: select organizati0_.id as id1_219_0_, organizati0_.last_editing_date as last_edi2_219_0_, organizati0_.login_1c as login_3_219_0_, organizati0_.ogrn as ogrn4_219_0_, organizati0_.password_1c as password5_219_0_, organizati0_.session_expiration_1c as session_6_219_0_, organizati0_.session_id_1c as session_7_219_0_ from ppasm.ppa_organization organizati0_ where organizati0_.id=?
  63. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  64. Hibernate: select organizati0_.id as id1_222_0_, organizati0_.last_editing_date as last_edi2_222_0_, organizati0_.block as block3_222_0_, organizati0_.block_date as block_da4_222_0_, organizati0_.block_reason_id as block_re5_222_0_, organizati0_.on_registration as on_regis6_222_0_, organizati0_.registered as register7_222_0_, organizati0_.registration_date as registra8_222_0_ from ppasm.ppa_organization_status organizati0_ where organizati0_.id=?
  65. Hibernate: select agreementb0_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  66. Hibernate: select organizati0_.id as id1_219_0_, organizati0_.last_editing_date as last_edi2_219_0_, organizati0_.login_1c as login_3_219_0_, organizati0_.ogrn as ogrn4_219_0_, organizati0_.password_1c as password5_219_0_, organizati0_.session_expiration_1c as session_6_219_0_, organizati0_.session_id_1c as session_7_219_0_ from ppasm.ppa_organization organizati0_ where organizati0_.id=?
  67. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  68. Hibernate: select organizati0_.id as id1_222_0_, organizati0_.last_editing_date as last_edi2_222_0_, organizati0_.block as block3_222_0_, organizati0_.block_date as block_da4_222_0_, organizati0_.block_reason_id as block_re5_222_0_, organizati0_.on_registration as on_regis6_222_0_, organizati0_.registered as register7_222_0_, organizati0_.registration_date as registra8_222_0_ from ppasm.ppa_organization_status organizati0_ where organizati0_.id=?
  69. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  70. Hibernate: select agreementb0_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  71. Hibernate: select organizati0_.id as id1_219_0_, organizati0_.last_editing_date as last_edi2_219_0_, organizati0_.login_1c as login_3_219_0_, organizati0_.ogrn as ogrn4_219_0_, organizati0_.password_1c as password5_219_0_, organizati0_.session_expiration_1c as session_6_219_0_, organizati0_.session_id_1c as session_7_219_0_ from ppasm.ppa_organization organizati0_ where organizati0_.id=?
  72. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  73. Hibernate: select organizati0_.id as id1_222_0_, organizati0_.last_editing_date as last_edi2_222_0_, organizati0_.block as block3_222_0_, organizati0_.block_date as block_da4_222_0_, organizati0_.block_reason_id as block_re5_222_0_, organizati0_.on_registration as on_regis6_222_0_, organizati0_.registered as register7_222_0_, organizati0_.registration_date as registra8_222_0_ from ppasm.ppa_organization_status organizati0_ where organizati0_.id=?
  74. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  75. Hibernate: select orgroles0_.ppa_org_version_id as ppa_org_4_220_0_, orgroles0_.id as id1_220_0_, orgroles0_.id as id1_220_1_, orgroles0_.last_editing_date as last_edi2_220_1_, orgroles0_.org_role_root_id as org_role3_220_1_, orgroles0_.ppa_org_version_id as ppa_org_4_220_1_ from ppasm.ppa_organization_role orgroles0_ where orgroles0_.ppa_org_version_id=?
  76. Hibernate: select agreementb0_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  77. Hibernate: select orgroles0_.ppa_org_version_id as ppa_org_4_220_0_, orgroles0_.id as id1_220_0_, orgroles0_.id as id1_220_1_, orgroles0_.last_editing_date as last_edi2_220_1_, orgroles0_.org_role_root_id as org_role3_220_1_, orgroles0_.ppa_org_version_id as ppa_org_4_220_1_ from ppasm.ppa_organization_role orgroles0_ where orgroles0_.ppa_org_version_id=?
  78. Hibernate: select orgroles0_.ppa_org_version_id as ppa_org_4_220_0_, orgroles0_.id as id1_220_0_, orgroles0_.id as id1_220_1_, orgroles0_.last_editing_date as last_edi2_220_1_, orgroles0_.org_role_root_id as org_role3_220_1_, orgroles0_.ppa_org_version_id as ppa_org_4_220_1_ from ppasm.ppa_organization_role orgroles0_ where orgroles0_.ppa_org_version_id=?
  79. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  80. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  81. Hibernate: select orgroles0_.ppa_org_version_id as ppa_org_4_220_0_, orgroles0_.id as id1_220_0_, orgroles0_.id as id1_220_1_, orgroles0_.last_editing_date as last_edi2_220_1_, orgroles0_.org_role_root_id as org_role3_220_1_, orgroles0_.ppa_org_version_id as ppa_org_4_220_1_ from ppasm.ppa_organization_role orgroles0_ where orgroles0_.ppa_org_version_id=?
  82. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  83. Hibernate: select orgroles0_.ppa_org_version_id as ppa_org_4_220_0_, orgroles0_.id as id1_220_0_, orgroles0_.id as id1_220_1_, orgroles0_.last_editing_date as last_edi2_220_1_, orgroles0_.org_role_root_id as org_role3_220_1_, orgroles0_.ppa_org_version_id as ppa_org_4_220_1_ from ppasm.ppa_organization_role orgroles0_ where orgroles0_.ppa_org_version_id=?
  84. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  85. Hibernate: select orgroles0_.ppa_org_version_id as ppa_org_4_220_0_, orgroles0_.id as id1_220_0_, orgroles0_.id as id1_220_1_, orgroles0_.last_editing_date as last_edi2_220_1_, orgroles0_.org_role_root_id as org_role3_220_1_, orgroles0_.ppa_org_version_id as ppa_org_4_220_1_ from ppasm.ppa_organization_role orgroles0_ where orgroles0_.ppa_org_version_id=?
  86. Hibernate: select agreementb0_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  87. Hibernate: select orgroles0_.ppa_org_version_id as ppa_org_4_220_0_, orgroles0_.id as id1_220_0_, orgroles0_.id as id1_220_1_, orgroles0_.last_editing_date as last_edi2_220_1_, orgroles0_.org_role_root_id as org_role3_220_1_, orgroles0_.ppa_org_version_id as ppa_org_4_220_1_ from ppasm.ppa_organization_role orgroles0_ where orgroles0_.ppa_org_version_id=?
  88. Hibernate: select orgroles0_.ppa_org_version_id as ppa_org_4_220_0_, orgroles0_.id as id1_220_0_, orgroles0_.id as id1_220_1_, orgroles0_.last_editing_date as last_edi2_220_1_, orgroles0_.org_role_root_id as org_role3_220_1_, orgroles0_.ppa_org_version_id as ppa_org_4_220_1_ from ppasm.ppa_organization_role orgroles0_ where orgroles0_.ppa_org_version_id=?
  89. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  90. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=? backend develop-dev-roscap
  91.     December 17th 2020, 16:31:45.514    2020-12-17 14:31:45.514 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [lTaskExecutor-4] r.l.r.report.impl.algorithm.ReportA_O_2  : A_O_2: orgs info search completed data size=8   backend develop-dev-roscap
  92. December 17th 2020, 16:31:45.514    2020-12-17 14:31:45.514 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [lTaskExecutor-4] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: case: REPORT_5
  93. Hibernate: select agreementb0_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  94. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=? backend develop-dev-roscap
  95.     December 17th 2020, 16:31:45.519    2020-12-17 14:31:45.519 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [lTaskExecutor-4] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: A_DVRU_57 params = {"bsAgreementData":[{"bsAgreementRootId":10370,"performerData":[{"performerRootId":162,"contractorAgreementIds":[30180]},{"performerRootId":226,"contractorAgreementIds":[30235]},{"performerRootId":19,"contractorAgreementIds":[30164]},{"performerRootId":20,"contractorAgreementIds":[30164]},{"performerRootId":5,"contractorAgreementIds":[30165]},{"performerRootId":6,"contractorAgreementIds":[30214,30169]},{"performerRootId":25,"contractorAgreementIds":[30171]},{"performerRootId":142,"contractorAgreementIds":[30211,30170]}]}],"reportDate":{"year":2020,"month":12,"day":17}}
  96. Hibernate: select contractor0_.id as id1_53_, contractor0_.last_editing_date as last_edi2_53_, contractor0_.root_id as root_id3_53_, contractor0_.actual as actual4_53_, contractor0_.actual_by_business as actual_b5_53_, contractor0_.advance_amount_type_id as advance_6_53_, contractor0_.advance_amount_with_vat as advance_7_53_, contractor0_.agreement_date as agreemen8_53_, contractor0_.agreement_number as agreemen9_53_, contractor0_.agreement_subject as agreeme10_53_, contractor0_.agreement_sum as agreeme11_53_, contractor0_.bank_details_creation_required as bank_de12_53_, contractor0_.contract_subject_type_id as contrac13_53_, contractor0_.create_date as create_14_53_, contractor0_.creator_organization_id as creator15_53_, contractor0_.creator_organization_root_id as creator16_53_, contractor0_.currency_id as currenc17_53_, contractor0_.deduction as deducti18_53_, contractor0_.deduction_type_id as deducti19_53_, contractor0_.edit_reason as edit_re20_53_, contractor0_.edit_reason_id as edit_re21_53_, contractor0_.editor_employee_id as editor_22_53_, contractor0_.editor_employee_root_id as editor_23_53_, contractor0_.editor_organization_id as editor_24_53_, contractor0_.editor_organization_root_id as editor_25_53_, contractor0_.end_date as end_dat26_53_, contractor0_.guarantee_deduction as guarant27_53_, contractor0_.guarantee_deductions_exists as guarant28_53_, contractor0_.guarantee_type_id as guarant29_53_, contractor0_.info_from_abbyy as info_fr30_53_, contractor0_.locked as locked31_53_, contractor0_.other_deductions_exists as other_d32_53_, contractor0_.payment_conditions as payment33_53_, contractor0_.prepaid_possible as prepaid34_53_, contractor0_.recognition_batch_id as recogni35_53_, contractor0_.recognition_in_progress as recogni36_53_, contractor0_.recognition_result as recogni37_53_, contractor0_.service_cost as service38_53_, contractor0_.service_cost_type_id as service39_53_, contractor0_.status_root_id as status_40_53_, contractor0_.sum_with_vat as sum_wit41_53_, contractor0_.supply_conditions as supply_42_53_, contractor0_.system_number as system_43_53_, contractor0_.termless as termles44_53_, contractor0_.vat_rate_id as vat_rat45_53_, contractor0_.verification_task_id as verific46_53_, contractor0_.version_number as version47_53_ from cagrsm.cagr_agreement contractor0_ where contractor0_.id=?
  97. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  98. Hibernate: select parties0_.agreement_id as agreemen7_61_0_, parties0_.id as id1_61_0_, parties0_.id as id1_61_1_, parties0_.last_editing_date as last_edi2_61_1_, parties0_.agreement_party_type_root_id as agreemen3_61_1_, parties0_.bank_details_root_id as bank_det4_61_1_, parties0_.agreement_id as agreemen7_61_1_, parties0_.organization_id as organiza5_61_1_, parties0_.organization_root_id as organiza6_61_1_ from cagrsm.cagr_agreement_party parties0_ where parties0_.agreement_id=?
  99. Hibernate: select agreementb0_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  100. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  101. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  102. Hibernate: select contractor0_.id as id1_53_, contractor0_.last_editing_date as last_edi2_53_, contractor0_.root_id as root_id3_53_, contractor0_.actual as actual4_53_, contractor0_.actual_by_business as actual_b5_53_, contractor0_.advance_amount_type_id as advance_6_53_, contractor0_.advance_amount_with_vat as advance_7_53_, contractor0_.agreement_date as agreemen8_53_, contractor0_.agreement_number as agreemen9_53_, contractor0_.agreement_subject as agreeme10_53_, contractor0_.agreement_sum as agreeme11_53_, contractor0_.bank_details_creation_required as bank_de12_53_, contractor0_.contract_subject_type_id as contrac13_53_, contractor0_.create_date as create_14_53_, contractor0_.creator_organization_id as creator15_53_, contractor0_.creator_organization_root_id as creator16_53_, contractor0_.currency_id as currenc17_53_, contractor0_.deduction as deducti18_53_, contractor0_.deduction_type_id as deducti19_53_, contractor0_.edit_reason as edit_re20_53_, contractor0_.edit_reason_id as edit_re21_53_, contractor0_.editor_employee_id as editor_22_53_, contractor0_.editor_employee_root_id as editor_23_53_, contractor0_.editor_organization_id as editor_24_53_, contractor0_.editor_organization_root_id as editor_25_53_, contractor0_.end_date as end_dat26_53_, contractor0_.guarantee_deduction as guarant27_53_, contractor0_.guarantee_deductions_exists as guarant28_53_, contractor0_.guarantee_type_id as guarant29_53_, contractor0_.info_from_abbyy as info_fr30_53_, contractor0_.locked as locked31_53_, contractor0_.other_deductions_exists as other_d32_53_, contractor0_.payment_conditions as payment33_53_, contractor0_.prepaid_possible as prepaid34_53_, contractor0_.recognition_batch_id as recogni35_53_, contractor0_.recognition_in_progress as recogni36_53_, contractor0_.recognition_result as recogni37_53_, contractor0_.service_cost as service38_53_, contractor0_.service_cost_type_id as service39_53_, contractor0_.status_root_id as status_40_53_, contractor0_.sum_with_vat as sum_wit41_53_, contractor0_.supply_conditions as supply_42_53_, contractor0_.system_number as system_43_53_, contractor0_.termless as termles44_53_, contractor0_.vat_rate_id as vat_rat45_53_, contractor0_.verification_task_id as verific46_53_, contractor0_.version_number as version47_53_ from cagrsm.cagr_agreement contractor0_ where contractor0_.root_id=? and contractor0_.status_root_id=? and DATE(contractor0_.agreement_date)<=?
  103. Hibernate: select agreementb0_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  104. Hibernate: select parties0_.agreement_id as agreemen7_61_0_, parties0_.id as id1_61_0_, parties0_.id as id1_61_1_, parties0_.last_editing_date as last_edi2_61_1_, parties0_.agreement_party_type_root_id as agreemen3_61_1_, parties0_.bank_details_root_id as bank_det4_61_1_, parties0_.agreement_id as agreemen7_61_1_, parties0_.organization_id as organiza5_61_1_, parties0_.organization_root_id as organiza6_61_1_ from cagrsm.cagr_agreement_party parties0_ where parties0_.agreement_id=?
  105. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  106. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  107. Hibernate: select agreementb0_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  108. Hibernate: select parties0_.agreement_id as agreemen7_61_0_, parties0_.id as id1_61_0_, parties0_.id as id1_61_1_, parties0_.last_editing_date as last_edi2_61_1_, parties0_.agreement_party_type_root_id as agreemen3_61_1_, parties0_.bank_details_root_id as bank_det4_61_1_, parties0_.agreement_id as agreemen7_61_1_, parties0_.organization_id as organiza5_61_1_, parties0_.organization_root_id as organiza6_61_1_ from cagrsm.cagr_agreement_party parties0_ where parties0_.agreement_id=?
  109. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  110. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  111. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  112. Hibernate: select agreementb0_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  113. Hibernate: select organizati0_.id as id1_223_, organizati0_.last_editing_date as last_edi2_223_, organizati0_.actual as actual3_223_, organizati0_.version_create_date as version_4_223_, organizati0_.version_number as version_5_223_, organizati0_.address as address6_223_, organizati0_.agency_territory as agency_t7_223_, organizati0_.agency_type as agency_t8_223_, organizati0_.is_branch as is_branc9_223_, organizati0_.branches_count as branche10_223_, organizati0_.data_source as data_so11_223_, organizati0_.email as email12_223_, organizati0_.email_confirmed as email_c13_223_, organizati0_.esia_id as esia_id14_223_, organizati0_.factual_address as factual15_223_, organizati0_.fax as fax16_223_, organizati0_.full_name as full_na17_223_, organizati0_.head_ppa_org_id as head_pp37_223_, organizati0_.ifrs_reporting as ifrs_re18_223_, organizati0_.information_source_root_id as informa19_223_, organizati0_.inn as inn20_223_, organizati0_.kpp as kpp21_223_, organizati0_.na_branch_code as na_bran22_223_, organizati0_.na_client_id as na_clie23_223_, organizati0_.na_id as na_id24_223_, organizati0_.na_status as na_stat25_223_, organizati0_.na_update_date as na_upda26_223_, organizati0_.ogrn as ogrn27_223_, organizati0_.okopf_code as okopf_c28_223_, organizati0_.ppa_organization_id as ppa_org29_223_, organizati0_.organization_type as organiz30_223_, organizati0_.phone as phone31_223_, organizati0_.short_name as short_n32_223_, organizati0_.state_registration_date as state_r33_223_, organizati0_.status_id as status_38_223_, organizati0_.statutory_full_name as statuto34_223_, organizati0_.statutory_name_differs as statuto35_223_, organizati0_.statutory_short_name as statuto36_223_ from ppasm.ppa_organization_version organizati0_ where organizati0_.ppa_organization_id=? and organizati0_.actual=?
  114. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  115. Hibernate: select organizati0_.id as id1_219_0_, organizati0_.last_editing_date as last_edi2_219_0_, organizati0_.login_1c as login_3_219_0_, organizati0_.ogrn as ogrn4_219_0_, organizati0_.password_1c as password5_219_0_, organizati0_.session_expiration_1c as session_6_219_0_, organizati0_.session_id_1c as session_7_219_0_ from ppasm.ppa_organization organizati0_ where organizati0_.id=?
  116. Hibernate: select organizati0_.id as id1_222_0_, organizati0_.last_editing_date as last_edi2_222_0_, organizati0_.block as block3_222_0_, organizati0_.block_date as block_da4_222_0_, organizati0_.block_reason_id as block_re5_222_0_, organizati0_.on_registration as on_regis6_222_0_, organizati0_.registered as register7_222_0_, organizati0_.registration_date as registra8_222_0_ from ppasm.ppa_organization_status organizati0_ where organizati0_.id=?
  117. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  118. Hibernate: select agreementb0_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  119. Hibernate: select orgroles0_.ppa_org_version_id as ppa_org_4_220_0_, orgroles0_.id as id1_220_0_, orgroles0_.id as id1_220_1_, orgroles0_.last_editing_date as last_edi2_220_1_, orgroles0_.org_role_root_id as org_role3_220_1_, orgroles0_.ppa_org_version_id as ppa_org_4_220_1_ from ppasm.ppa_organization_role orgroles0_ where orgroles0_.ppa_org_version_id=?
  120. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  121. Hibernate: select contractor0_.id as id1_53_, contractor0_.last_editing_date as last_edi2_53_, contractor0_.root_id as root_id3_53_, contractor0_.actual as actual4_53_, contractor0_.actual_by_business as actual_b5_53_, contractor0_.advance_amount_type_id as advance_6_53_, contractor0_.advance_amount_with_vat as advance_7_53_, contractor0_.agreement_date as agreemen8_53_, contractor0_.agreement_number as agreemen9_53_, contractor0_.agreement_subject as agreeme10_53_, contractor0_.agreement_sum as agreeme11_53_, contractor0_.bank_details_creation_required as bank_de12_53_, contractor0_.contract_subject_type_id as contrac13_53_, contractor0_.create_date as create_14_53_, contractor0_.creator_organization_id as creator15_53_, contractor0_.creator_organization_root_id as creator16_53_, contractor0_.currency_id as currenc17_53_, contractor0_.deduction as deducti18_53_, contractor0_.deduction_type_id as deducti19_53_, contractor0_.edit_reason as edit_re20_53_, contractor0_.edit_reason_id as edit_re21_53_, contractor0_.editor_employee_id as editor_22_53_, contractor0_.editor_employee_root_id as editor_23_53_, contractor0_.editor_organization_id as editor_24_53_, contractor0_.editor_organization_root_id as editor_25_53_, contractor0_.end_date as end_dat26_53_, contractor0_.guarantee_deduction as guarant27_53_, contractor0_.guarantee_deductions_exists as guarant28_53_, contractor0_.guarantee_type_id as guarant29_53_, contractor0_.info_from_abbyy as info_fr30_53_, contractor0_.locked as locked31_53_, contractor0_.other_deductions_exists as other_d32_53_, contractor0_.payment_conditions as payment33_53_, contractor0_.prepaid_possible as prepaid34_53_, contractor0_.recognition_batch_id as recogni35_53_, contractor0_.recognition_in_progress as recogni36_53_, contractor0_.recognition_result as recogni37_53_, contractor0_.service_cost as service38_53_, contractor0_.service_cost_type_id as service39_53_, contractor0_.status_root_id as status_40_53_, contractor0_.sum_with_vat as sum_wit41_53_, contractor0_.supply_conditions as supply_42_53_, contractor0_.system_number as system_43_53_, contractor0_.termless as termles44_53_, contractor0_.vat_rate_id as vat_rat45_53_, contractor0_.verification_task_id as verific46_53_, contractor0_.version_number as version47_53_ from cagrsm.cagr_agreement contractor0_ where contractor0_.id=?
  122. Hibernate: select parties0_.agreement_id as agreemen7_61_0_, parties0_.id as id1_61_0_, parties0_.id as id1_61_1_, parties0_.last_editing_date as last_edi2_61_1_, parties0_.agreement_party_type_root_id as agreemen3_61_1_, parties0_.bank_details_root_id as bank_det4_61_1_, parties0_.agreement_id as agreemen7_61_1_, parties0_.organization_id as organiza5_61_1_, parties0_.organization_root_id as organiza6_61_1_ from cagrsm.cagr_agreement_party parties0_ where parties0_.agreement_id=?
  123. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  124. Hibernate: select agreementb0_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  125. Hibernate: select contractor0_.id as id1_53_, contractor0_.last_editing_date as last_edi2_53_, contractor0_.root_id as root_id3_53_, contractor0_.actual as actual4_53_, contractor0_.actual_by_business as actual_b5_53_, contractor0_.advance_amount_type_id as advance_6_53_, contractor0_.advance_amount_with_vat as advance_7_53_, contractor0_.agreement_date as agreemen8_53_, contractor0_.agreement_number as agreemen9_53_, contractor0_.agreement_subject as agreeme10_53_, contractor0_.agreement_sum as agreeme11_53_, contractor0_.bank_details_creation_required as bank_de12_53_, contractor0_.contract_subject_type_id as contrac13_53_, contractor0_.create_date as create_14_53_, contractor0_.creator_organization_id as creator15_53_, contractor0_.creator_organization_root_id as creator16_53_, contractor0_.currency_id as currenc17_53_, contractor0_.deduction as deducti18_53_, contractor0_.deduction_type_id as deducti19_53_, contractor0_.edit_reason as edit_re20_53_, contractor0_.edit_reason_id as edit_re21_53_, contractor0_.editor_employee_id as editor_22_53_, contractor0_.editor_employee_root_id as editor_23_53_, contractor0_.editor_organization_id as editor_24_53_, contractor0_.editor_organization_root_id as editor_25_53_, contractor0_.end_date as end_dat26_53_, contractor0_.guarantee_deduction as guarant27_53_, contractor0_.guarantee_deductions_exists as guarant28_53_, contractor0_.guarantee_type_id as guarant29_53_, contractor0_.info_from_abbyy as info_fr30_53_, contractor0_.locked as locked31_53_, contractor0_.other_deductions_exists as other_d32_53_, contractor0_.payment_conditions as payment33_53_, contractor0_.prepaid_possible as prepaid34_53_, contractor0_.recognition_batch_id as recogni35_53_, contractor0_.recognition_in_progress as recogni36_53_, contractor0_.recognition_result as recogni37_53_, contractor0_.service_cost as service38_53_, contractor0_.service_cost_type_id as service39_53_, contractor0_.status_root_id as status_40_53_, contractor0_.sum_with_vat as sum_wit41_53_, contractor0_.supply_conditions as supply_42_53_, contractor0_.system_number as system_43_53_, contractor0_.termless as termles44_53_, contractor0_.vat_rate_id as vat_rat45_53_, contractor0_.verification_task_id as verific46_53_, contractor0_.version_number as version47_53_ from cagrsm.cagr_agreement contractor0_ where contractor0_.root_id=? and contractor0_.status_root_id=? and DATE(contractor0_.agreement_date)<=?
  126. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  127. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  128. Hibernate: select parties0_.agreement_id as agreemen7_61_0_, parties0_.id as id1_61_0_, parties0_.id as id1_61_1_, parties0_.last_editing_date as last_edi2_61_1_, parties0_.agreement_party_type_root_id as agreemen3_61_1_, parties0_.bank_details_root_id as bank_det4_61_1_, parties0_.agreement_id as agreemen7_61_1_, parties0_.organization_id as organiza5_61_1_, parties0_.organization_root_id as organiza6_61_1_ from cagrsm.cagr_agreement_party parties0_ where parties0_.agreement_id=?
  129. Hibernate: select agreementb0_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  130. Hibernate: select parties0_.agreement_id as agreemen7_61_0_, parties0_.id as id1_61_0_, parties0_.id as id1_61_1_, parties0_.last_editing_date as last_edi2_61_1_, parties0_.agreement_party_type_root_id as agreemen3_61_1_, parties0_.bank_details_root_id as bank_det4_61_1_, parties0_.agreement_id as agreemen7_61_1_, parties0_.organization_id as organiza5_61_1_, parties0_.organization_root_id as organiza6_61_1_ from cagrsm.cagr_agreement_party parties0_ where parties0_.agreement_id=?
  131. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  132. Hibernate: select parties0_.agreement_id as agreemen7_61_0_, parties0_.id as id1_61_0_, parties0_.id as id1_61_1_, parties0_.last_editing_date as last_edi2_61_1_, parties0_.agreement_party_type_root_id as agreemen3_61_1_, parties0_.bank_details_root_id as bank_det4_61_1_, parties0_.agreement_id as agreemen7_61_1_, parties0_.organization_id as organiza5_61_1_, parties0_.organization_root_id as organiza6_61_1_ from cagrsm.cagr_agreement_party parties0_ where parties0_.agreement_id=?
  133. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  134. Hibernate: select agreementb0_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  135. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  136. Hibernate: select organizati0_.id as id1_223_, organizati0_.last_editing_date as last_edi2_223_, organizati0_.actual as actual3_223_, organizati0_.version_create_date as version_4_223_, organizati0_.version_number as version_5_223_, organizati0_.address as address6_223_, organizati0_.agency_territory as agency_t7_223_, organizati0_.agency_type as agency_t8_223_, organizati0_.is_branch as is_branc9_223_, organizati0_.branches_count as branche10_223_, organizati0_.data_source as data_so11_223_, organizati0_.email as email12_223_, organizati0_.email_confirmed as email_c13_223_, organizati0_.esia_id as esia_id14_223_, organizati0_.factual_address as factual15_223_, organizati0_.fax as fax16_223_, organizati0_.full_name as full_na17_223_, organizati0_.head_ppa_org_id as head_pp37_223_, organizati0_.ifrs_reporting as ifrs_re18_223_, organizati0_.information_source_root_id as informa19_223_, organizati0_.inn as inn20_223_, organizati0_.kpp as kpp21_223_, organizati0_.na_branch_code as na_bran22_223_, organizati0_.na_client_id as na_clie23_223_, organizati0_.na_id as na_id24_223_, organizati0_.na_status as na_stat25_223_, organizati0_.na_update_date as na_upda26_223_, organizati0_.ogrn as ogrn27_223_, organizati0_.okopf_code as okopf_c28_223_, organizati0_.ppa_organization_id as ppa_org29_223_, organizati0_.organization_type as organiz30_223_, organizati0_.phone as phone31_223_, organizati0_.short_name as short_n32_223_, organizati0_.state_registration_date as state_r33_223_, organizati0_.status_id as status_38_223_, organizati0_.statutory_full_name as statuto34_223_, organizati0_.statutory_name_differs as statuto35_223_, organizati0_.statutory_short_name as statuto36_223_ from ppasm.ppa_organization_version organizati0_ where organizati0_.ppa_organization_id=? and organizati0_.actual=?
  137. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  138. Hibernate: select organizati0_.id as id1_219_0_, organizati0_.last_editing_date as last_edi2_219_0_, organizati0_.login_1c as login_3_219_0_, organizati0_.ogrn as ogrn4_219_0_, organizati0_.password_1c as password5_219_0_, organizati0_.session_expiration_1c as session_6_219_0_, organizati0_.session_id_1c as session_7_219_0_ from ppasm.ppa_organization organizati0_ where organizati0_.id=?
  139. Hibernate: select agreementb0_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  140. Hibernate: select organizati0_.id as id1_222_0_, organizati0_.last_editing_date as last_edi2_222_0_, organizati0_.block as block3_222_0_, organizati0_.block_date as block_da4_222_0_, organizati0_.block_reason_id as block_re5_222_0_, organizati0_.on_registration as on_regis6_222_0_, organizati0_.registered as register7_222_0_, organizati0_.registration_date as registra8_222_0_ from ppasm.ppa_organization_status organizati0_ where organizati0_.id=?
  141. Hibernate: select orgroles0_.ppa_org_version_id as ppa_org_4_220_0_, orgroles0_.id as id1_220_0_, orgroles0_.id as id1_220_1_, orgroles0_.last_editing_date as last_edi2_220_1_, orgroles0_.org_role_root_id as org_role3_220_1_, orgroles0_.ppa_org_version_id as ppa_org_4_220_1_ from ppasm.ppa_organization_role orgroles0_ where orgroles0_.ppa_org_version_id=?
  142. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  143. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  144. Hibernate: select contractor0_.id as id1_53_, contractor0_.last_editing_date as last_edi2_53_, contractor0_.root_id as root_id3_53_, contractor0_.actual as actual4_53_, contractor0_.actual_by_business as actual_b5_53_, contractor0_.advance_amount_type_id as advance_6_53_, contractor0_.advance_amount_with_vat as advance_7_53_, contractor0_.agreement_date as agreemen8_53_, contractor0_.agreement_number as agreemen9_53_, contractor0_.agreement_subject as agreeme10_53_, contractor0_.agreement_sum as agreeme11_53_, contractor0_.bank_details_creation_required as bank_de12_53_, contractor0_.contract_subject_type_id as contrac13_53_, contractor0_.create_date as create_14_53_, contractor0_.creator_organization_id as creator15_53_, contractor0_.creator_organization_root_id as creator16_53_, contractor0_.currency_id as currenc17_53_, contractor0_.deduction as deducti18_53_, contractor0_.deduction_type_id as deducti19_53_, contractor0_.edit_reason as edit_re20_53_, contractor0_.edit_reason_id as edit_re21_53_, contractor0_.editor_employee_id as editor_22_53_, contractor0_.editor_employee_root_id as editor_23_53_, contractor0_.editor_organization_id as editor_24_53_, contractor0_.editor_organization_root_id as editor_25_53_, contractor0_.end_date as end_dat26_53_, contractor0_.guarantee_deduction as guarant27_53_, contractor0_.guarantee_deductions_exists as guarant28_53_, contractor0_.guarantee_type_id as guarant29_53_, contractor0_.info_from_abbyy as info_fr30_53_, contractor0_.locked as locked31_53_, contractor0_.other_deductions_exists as other_d32_53_, contractor0_.payment_conditions as payment33_53_, contractor0_.prepaid_possible as prepaid34_53_, contractor0_.recognition_batch_id as recogni35_53_, contractor0_.recognition_in_progress as recogni36_53_, contractor0_.recognition_result as recogni37_53_, contractor0_.service_cost as service38_53_, contractor0_.service_cost_type_id as service39_53_, contractor0_.status_root_id as status_40_53_, contractor0_.sum_with_vat as sum_wit41_53_, contractor0_.supply_conditions as supply_42_53_, contractor0_.system_number as system_43_53_, contractor0_.termless as termles44_53_, contractor0_.vat_rate_id as vat_rat45_53_, contractor0_.verification_task_id as verific46_53_, contractor0_.version_number as version47_53_ from cagrsm.cagr_agreement contractor0_ where contractor0_.id=?
  145. Hibernate: select agreementb0_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  146. Hibernate: select parties0_.agreement_id as agreemen7_61_0_, parties0_.id as id1_61_0_, parties0_.id as id1_61_1_, parties0_.last_editing_date as last_edi2_61_1_, parties0_.agreement_party_type_root_id as agreemen3_61_1_, parties0_.bank_details_root_id as bank_det4_61_1_, parties0_.agreement_id as agreemen7_61_1_, parties0_.organization_id as organiza5_61_1_, parties0_.organization_root_id as organiza6_61_1_ from cagrsm.cagr_agreement_party parties0_ where parties0_.agreement_id=?
  147. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  148. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  149. Hibernate: select agreementb0_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  150. Hibernate: select contractor0_.id as id1_53_, contractor0_.last_editing_date as last_edi2_53_, contractor0_.root_id as root_id3_53_, contractor0_.actual as actual4_53_, contractor0_.actual_by_business as actual_b5_53_, contractor0_.advance_amount_type_id as advance_6_53_, contractor0_.advance_amount_with_vat as advance_7_53_, contractor0_.agreement_date as agreemen8_53_, contractor0_.agreement_number as agreemen9_53_, contractor0_.agreement_subject as agreeme10_53_, contractor0_.agreement_sum as agreeme11_53_, contractor0_.bank_details_creation_required as bank_de12_53_, contractor0_.contract_subject_type_id as contrac13_53_, contractor0_.create_date as create_14_53_, contractor0_.creator_organization_id as creator15_53_, contractor0_.creator_organization_root_id as creator16_53_, contractor0_.currency_id as currenc17_53_, contractor0_.deduction as deducti18_53_, contractor0_.deduction_type_id as deducti19_53_, contractor0_.edit_reason as edit_re20_53_, contractor0_.edit_reason_id as edit_re21_53_, contractor0_.editor_employee_id as editor_22_53_, contractor0_.editor_employee_root_id as editor_23_53_, contractor0_.editor_organization_id as editor_24_53_, contractor0_.editor_organization_root_id as editor_25_53_, contractor0_.end_date as end_dat26_53_, contractor0_.guarantee_deduction as guarant27_53_, contractor0_.guarantee_deductions_exists as guarant28_53_, contractor0_.guarantee_type_id as guarant29_53_, contractor0_.info_from_abbyy as info_fr30_53_, contractor0_.locked as locked31_53_, contractor0_.other_deductions_exists as other_d32_53_, contractor0_.payment_conditions as payment33_53_, contractor0_.prepaid_possible as prepaid34_53_, contractor0_.recognition_batch_id as recogni35_53_, contractor0_.recognition_in_progress as recogni36_53_, contractor0_.recognition_result as recogni37_53_, contractor0_.service_cost as service38_53_, contractor0_.service_cost_type_id as service39_53_, contractor0_.status_root_id as status_40_53_, contractor0_.sum_with_vat as sum_wit41_53_, contractor0_.supply_conditions as supply_42_53_, contractor0_.system_number as system_43_53_, contractor0_.termless as termles44_53_, contractor0_.vat_rate_id as vat_rat45_53_, contractor0_.verification_task_id as verific46_53_, contractor0_.version_number as version47_53_ from cagrsm.cagr_agreement contractor0_ where contractor0_.root_id=? and contractor0_.status_root_id=? and DATE(contractor0_.agreement_date)<=?
  151. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  152. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  153. Hibernate: select parties0_.agreement_id as agreemen7_61_0_, parties0_.id as id1_61_0_, parties0_.id as id1_61_1_, parties0_.last_editing_date as last_edi2_61_1_, parties0_.agreement_party_type_root_id as agreemen3_61_1_, parties0_.bank_details_root_id as bank_det4_61_1_, parties0_.agreement_id as agreemen7_61_1_, parties0_.organization_id as organiza5_61_1_, parties0_.organization_root_id as organiza6_61_1_ from cagrsm.cagr_agreement_party parties0_ where parties0_.agreement_id=?
  154. Hibernate: select agreementb0_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  155. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  156. Hibernate: select organizati0_.id as id1_223_, organizati0_.last_editing_date as last_edi2_223_, organizati0_.actual as actual3_223_, organizati0_.version_create_date as version_4_223_, organizati0_.version_number as version_5_223_, organizati0_.address as address6_223_, organizati0_.agency_territory as agency_t7_223_, organizati0_.agency_type as agency_t8_223_, organizati0_.is_branch as is_branc9_223_, organizati0_.branches_count as branche10_223_, organizati0_.data_source as data_so11_223_, organizati0_.email as email12_223_, organizati0_.email_confirmed as email_c13_223_, organizati0_.esia_id as esia_id14_223_, organizati0_.factual_address as factual15_223_, organizati0_.fax as fax16_223_, organizati0_.full_name as full_na17_223_, organizati0_.head_ppa_org_id as head_pp37_223_, organizati0_.ifrs_reporting as ifrs_re18_223_, organizati0_.information_source_root_id as informa19_223_, organizati0_.inn as inn20_223_, organizati0_.kpp as kpp21_223_, organizati0_.na_branch_code as na_bran22_223_, organizati0_.na_client_id as na_clie23_223_, organizati0_.na_id as na_id24_223_, organizati0_.na_status as na_stat25_223_, organizati0_.na_update_date as na_upda26_223_, organizati0_.ogrn as ogrn27_223_, organizati0_.okopf_code as okopf_c28_223_, organizati0_.ppa_organization_id as ppa_org29_223_, organizati0_.organization_type as organiz30_223_, organizati0_.phone as phone31_223_, organizati0_.short_name as short_n32_223_, organizati0_.state_registration_date as state_r33_223_, organizati0_.status_id as status_38_223_, organizati0_.statutory_full_name as statuto34_223_, organizati0_.statutory_name_differs as statuto35_223_, organizati0_.statutory_short_name as statuto36_223_ from ppasm.ppa_organization_version organizati0_ where organizati0_.ppa_organization_id=? and organizati0_.actual=?
  157. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  158. Hibernate: select organizati0_.id as id1_219_0_, organizati0_.last_editing_date as last_edi2_219_0_, organizati0_.login_1c as login_3_219_0_, organizati0_.ogrn as ogrn4_219_0_, organizati0_.password_1c as password5_219_0_, organizati0_.session_expiration_1c as session_6_219_0_, organizati0_.session_id_1c as session_7_219_0_ from ppasm.ppa_organization organizati0_ where organizati0_.id=?
  159. Hibernate: select agreementb0_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  160. Hibernate: select organizati0_.id as id1_222_0_, organizati0_.last_editing_date as last_edi2_222_0_, organizati0_.block as block3_222_0_, organizati0_.block_date as block_da4_222_0_, organizati0_.block_reason_id as block_re5_222_0_, organizati0_.on_registration as on_regis6_222_0_, organizati0_.registered as register7_222_0_, organizati0_.registration_date as registra8_222_0_ from ppasm.ppa_organization_status organizati0_ where organizati0_.id=?
  161. Hibernate: select orgroles0_.ppa_org_version_id as ppa_org_4_220_0_, orgroles0_.id as id1_220_0_, orgroles0_.id as id1_220_1_, orgroles0_.last_editing_date as last_edi2_220_1_, orgroles0_.org_role_root_id as org_role3_220_1_, orgroles0_.ppa_org_version_id as ppa_org_4_220_1_ from ppasm.ppa_organization_role orgroles0_ where orgroles0_.ppa_org_version_id=?
  162. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  163. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  164. Hibernate: select contractor0_.id as id1_53_, contractor0_.last_editing_date as last_edi2_53_, contractor0_.root_id as root_id3_53_, contractor0_.actual as actual4_53_, contractor0_.actual_by_business as actual_b5_53_, contractor0_.advance_amount_type_id as advance_6_53_, contractor0_.advance_amount_with_vat as advance_7_53_, contractor0_.agreement_date as agreemen8_53_, contractor0_.agreement_number as agreemen9_53_, contractor0_.agreement_subject as agreeme10_53_, contractor0_.agreement_sum as agreeme11_53_, contractor0_.bank_details_creation_required as bank_de12_53_, contractor0_.contract_subject_type_id as contrac13_53_, contractor0_.create_date as create_14_53_, contractor0_.creator_organization_id as creator15_53_, contractor0_.creator_organization_root_id as creator16_53_, contractor0_.currency_id as currenc17_53_, contractor0_.deduction as deducti18_53_, contractor0_.deduction_type_id as deducti19_53_, contractor0_.edit_reason as edit_re20_53_, contractor0_.edit_reason_id as edit_re21_53_, contractor0_.editor_employee_id as editor_22_53_, contractor0_.editor_employee_root_id as editor_23_53_, contractor0_.editor_organization_id as editor_24_53_, contractor0_.editor_organization_root_id as editor_25_53_, contractor0_.end_date as end_dat26_53_, contractor0_.guarantee_deduction as guarant27_53_, contractor0_.guarantee_deductions_exists as guarant28_53_, contractor0_.guarantee_type_id as guarant29_53_, contractor0_.info_from_abbyy as info_fr30_53_, contractor0_.locked as locked31_53_, contractor0_.other_deductions_exists as other_d32_53_, contractor0_.payment_conditions as payment33_53_, contractor0_.prepaid_possible as prepaid34_53_, contractor0_.recognition_batch_id as recogni35_53_, contractor0_.recognition_in_progress as recogni36_53_, contractor0_.recognition_result as recogni37_53_, contractor0_.service_cost as service38_53_, contractor0_.service_cost_type_id as service39_53_, contractor0_.status_root_id as status_40_53_, contractor0_.sum_with_vat as sum_wit41_53_, contractor0_.supply_conditions as supply_42_53_, contractor0_.system_number as system_43_53_, contractor0_.termless as termles44_53_, contractor0_.vat_rate_id as vat_rat45_53_, contractor0_.verification_task_id as verific46_53_, contractor0_.version_number as version47_53_ from cagrsm.cagr_agreement contractor0_ where contractor0_.id=?    backend develop-dev-roscap
  165.     December 17th 2020, 16:31:46.284    2020-12-17 14:31:46.284 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [lTaskExecutor-4] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: A_DVRU_57 aDvru57Response = {"data":[{"bsAgreementRootId":10370,"performerData":[{"performerRootId":162,"contractorAgreementData":[{"rootId":30178,"dataNotFound":false,"agreementNumber":"ДВРУ11квартал_новоселье","agreementDate":{"date":{"year":2020,"month":9,"day":1},"time":{"hour":0,"minute":0,"second":0,"nano":0}},"contractSubjectTypeId":2,"currencyId":1,"sumWithVat":24000000.00,"customerRootId":5,"customerInn":"8601065920","customerName":"ООО \"11 КВАРТАЛ\""}]},{"performerRootId":226,"contractorAgreementData":[{"rootId":30235,"dataNotFound":false,"agreementNumber":"3 КМЧ","agreementDate":{"date":{"year":2020,"month":10,"day":30},"time":{"hour":0,"minute":0,"second":0,"nano":0}},"contractSubjectTypeId":2,"currencyId":1,"sumWithVat":2040.00,"customerRootId":6,"customerInn":"7839073281","customerName":"ООО \"4Д КОНСТРАКШН\""}]},{"performerRootId":19,"contractorAgreementData":[{"rootId":30164,"dataNotFound":false,"agreementNumber":"110-ЛАНИТ","agreementDate":{"date":{"year":2020,"month":8,"day":12},"time":{"hour":0,"minute":0,"second":0,"nano":0}},"contractSubjectTypeId":3,"currencyId":1,"sumWithVat":11800000.00,"customerRootId":19,"customerInn":"7813475980","customerName":"ООО \"РосСтройИнвест\""}]},{"performerRootId":20,"contractorAgreementData":[{"rootId":30164,"dataNotFound":false,"agreementNumber":"110-ЛАНИТ","agreementDate":{"date":{"year":2020,"month":8,"day":12},"time":{"hour":0,"minute":0,"second":0,"nano":0}},"contractSubjectTypeId":3,"currencyId":1,"sumWithVat":11800000.00,"customerRootId":19,"customerInn":"7813475980","customerName":"ООО \"РосСтройИнвест\""}]},{"performerRootId":5,"contractorAgreementData":[{"rootId":30165,"dataNotFound":false,"agreementNumber":"110-ЛАНИТ-01","agreementDate":{"date":{"year":2020,"month":8,"day":12},"time":{"hour":0,"minute":0,"second":0,"nano":0}},"contractSubjectTypeId":1,"currencyId":1,"sumWithVat":1180000.00,"customerRootId":20,"customerInn":"7816577885","customerName":"ООО \"СК \"ГОСТСТРОЙ\""}]},{"performerRootId":6,"contractorAgreementData":[{"rootId":30214,"dataNotFound":false,"agreementNumber":"2610202","agreementDate":{"date":{"year":2020,"month":10,"day":26},"time":{"hour":0,"minute":0,"second":0,"nano":0}},"contractSubjectTypeId":6,"currencyId":1,"sumWithVat":1180000.00,"customerRootId":5,"customerInn":"8601065920","customerName":"ООО \"11 КВАРТАЛ\""},{"rootId":30169,"dataNotFound":false,"agreementNumber":"200-ЛАНИТ","agreementDate":{"date":{"year":2020,"month":9,"day":14},"time":{"hour":0,"minute":0,"second":0,"nano":0}},"contractSubjectTypeId":4,"currencyId":1,"sumWithVat":3300000.00,"customerRootId":5,"customerInn":"8601065920","customerName":"ООО \"11 КВАРТАЛ\""}]},{"performerRootId":25,"contractorAgreementData":[{"rootId":30171,"dataNotFound":false,"agreementNumber":"220-ЛАНИТ","agreementDate":{"date":{"year":2020,"month":9,"day":14},"time":{"hour":0,"minute":0,"second":0,"nano":0}},"contractSubjectTypeId":4,"currencyId":1,"sumWithVat":110000.00,"customerRootId":142,"customerInn":"5180677750","customerName":"ООО \"Классик 55\""}]},{"performerRootId":142,"contractorAgreementData":[{"rootId":30211,"dataNotFound":false,"agreementNumber":"2610201","agreementDate":{"date":{"year":2020,"month":10,"day":26},"time":{"hour":0,"minute":0,"second":0,"nano":0}},"contractSubjectTypeId":4,"currencyId":1,"sumWithVat":1180000.00,"customerRootId":5,"customerInn":"8601065920","customerName":"ООО \"11 КВАРТАЛ\""},{"rootId":30170,"dataNotFound":false,"agreementNumber":"210-ЛАНИТ","agreementDate":{"date":{"year":2020,"month":9,"day":14},"time":{"hour":0,"minute":0,"second":0,"nano":0}},"contractSubjectTypeId":5,"currencyId":1,"sumWithVat":132000.00,"customerRootId":6,"customerInn":"7839073281","customerName":"ООО \"4Д КОНСТРАКШН\""}]}]}]}
  166. Hibernate: select participan0_.agreement_id as agreemen8_31_0_, participan0_.id as id1_31_0_, participan0_.id as id1_31_1_, participan0_.last_editing_date as last_edi2_31_1_, participan0_.agreement_id as agreemen8_31_1_, participan0_.bank_details_id as bank_det3_31_1_, participan0_.fund_subject as fund_sub4_31_1_, participan0_.organization_version_id as organiza5_31_1_, participan0_.organization_id as organiza6_31_1_, participan0_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_participant participan0_ where participan0_.agreement_id=?  backend develop-dev-roscap
  167.     December 17th 2020, 16:31:46.295    2020-12-17 14:31:46.295 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [lTaskExecutor-4] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: A_PD_39 params = {"bsAgreements":[{"agreementBsId":10370,"agreementBsObjectRootIds":[320,321,319],"contractorAgreementRootIdsWithSum":{"30178":24000000.00,"30211":1180000.00,"30164":11800000.00,"30165":1180000.00,"30214":1180000.00,"30169":3300000.00,"30170":132000.00,"30235":2040.00,"30171":110000.00}}],"datePeriod":{"endDate":{"year":2020,"month":12,"day""successType":"TYPE_1","data":[{"agreementBsId":10370,"agreementBsObjectRootId":320,"contractorAgreementRootId":30164,"sumA":0,"sumB":0,"sumC":0,"sumD":0,"sumE":11800000.00,"sumF":0,"sumG":0,"sumH":0},{"agreementBsId":10370,"agreementBsObjectRootId":321,"contractorAgreementRootId":30164,"sumA":0,"sumB":0,"sumC":0,"sumD":0,"sumE":11800000.00,"sumF":0,"sumG":0,"sumH":0},{"agreementBsId":10370,"agreementBsObjectRootId":319,"contractorAgreementRootId":30164,"sumA":15500.00,"sumB":200.00,"sumC":15300.00,"sumD":0.00,"sumE":11784500.00,"sumF":10200.00,"sumG":0,"sumH":0},{"agreementBsId":10370,"agreementBsObjectRootId":319,"contractorAgreementRootId":30165,"sumA":10000.00,"sumB":0,"sumC":10000.00,"sumD":0.00,"sumE":1170000.00,"sumF":0,"sumG":0,"sumH":0},{"agreementBsId":10370,"agreementBsObjectRootId":319,"contractorAgreementRootId":30169,"sumA":55000.00,"sumB":20000.00,"sumC":35000.00,"sumD":0.00,"sumE":3245000.00,"sumF":20000.00,"sumG":0,"sumH":0}]}   backend develop-dev-roscap
  168.     December 17th 2020, 16:31:47.610    2020-12-17 14:31:47.610 ERROR 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [lTaskExecutor-4] .a.i.SimpleAsyncUncaughtExceptionHandler : Unexpected exception occurred invoking async method: public void ru.lanit.rbs.report.impl.helper.AsyncHelper.callAsync(java.lang.Runnable)
  169.  
  170. java.lang.NullPointerException: null
  171.     at ru.lanit.rbs.report.impl.helper.ReportRequestHelper.lambda$getAPd40Request$11(ReportRequestHelper.java:226)
  172.     at java.base/java.lang.Iterable.forEach(Iterable.java:75)
  173.     at ru.lanit.rbs.report.impl.helper.ReportRequestHelper.lambda$getAPd40Request$12(ReportRequestHelper.java:226)
  174.     at java.base/java.util.HashMap.forEach(HashMap.java:1336)
  175.     at ru.lanit.rbs.report.impl.helper.ReportRequestHelper.getAPd40Request(ReportRequestHelper.java:215)
  176.     at ru.lanit.rbs.report.impl.algorithm.ReportA_O_2.fillReport5(ReportA_O_2.java:300)
  177.     at ru.lanit.rbs.report.impl.algorithm.ReportA_O_2.run(ReportA_O_2.java:133)
  178.     at ru.lanit.rbs.report.impl.algorithm.ReportA_O_2$$FastClassBySpringCGLIB$$6853031d.invoke(<generated>)
  179.     at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  180.     at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
  181.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  182.     at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
  183.     at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)
  184.     at ru.lanit.rbs.report.impl.aspect.ExecutionTimeAspect.logExecutionTime(ExecutionTimeAspect.java:22)
  185.     at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  186.     at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  187.     at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  188.     at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  189.     at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)
  190.     at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)
  191.     at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
  192.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
  193.     at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
  194.     at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
  195.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
  196.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  197.     at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
  198.     at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95)
  199.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  200.     at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
  201.     at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
  202.     at ru.lanit.rbs.report.impl.algorithm.ReportA_O_2$$EnhancerBySpringCGLIB$$fc25c18e.run(<generated>)
  203.     at ru.lanit.rbs.report.impl.algorithm.ReportA_O_5.getQuarterReports(ReportA_O_5.java:117)
  204.     at ru.lanit.rbs.report.impl.algorithm.ReportA_O_5.run(ReportA_O_5.java:85)
  205.     at ru.lanit.rbs.report.impl.algorithm.ReportA_O_5$$FastClassBySpringCGLIB$$68530320.invoke(<generated>)
  206.     at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  207.     at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
  208.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  209.     at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
  210.     at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)
  211.     at ru.lanit.rbs.report.impl.aspect.ExecutionTimeAspect.logExecutionTime(ExecutionTimeAspect.java:22)
  212.     at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  213.     at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  214.     at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  215.     at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  216.     at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)
  217.     at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)
  218.     at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
  219.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
  220.     at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
  221.     at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
  222.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
  223.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  224.     at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
  225.     at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95)
  226.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  227.     at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
  228.     at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
  229.     at ru.lanit.rbs.report.impl.algorithm.ReportA_O_5$$EnhancerBySpringCGLIB$$36f85b77.run(<generated>)
  230.     at ru.lanit.rbs.report.impl.service.ReportServiceImpl.lambda$generateOnlineReport$0(ReportServiceImpl.java:154)
  231.     at ru.lanit.rbs.report.impl.helper.AsyncHelper.callAsync(AsyncHelper.java:20)
  232.     at ru.lanit.rbs.report.impl.helper.AsyncHelper$$FastClassBySpringCGLIB$$cdc792be.invoke(<generated>)
  233.     at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  234.     at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
  235.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  236.     at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
  237.     at org.springframework.aop.interceptor.AsyncExecutionInterceptor.lambda$invoke$0(AsyncExecutionInterceptor.java:115)
  238.     at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
  239.     at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
  240.     at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
  241.     at java.base/java.lang.Thread.run(Thread.java:834)
  242.     backend develop-dev-roscap
  243.     December 17th 2020, 16:31:51.837    2020-12-17 14:31:51.837 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.security.web.FilterChainProxy        : /api/notification/last at position 1 of 15 in additional filter chain; firing Filter: 'WebAsyncManagerIntegrationFilter'    backend develop-dev-roscap
  244.     December 17th 2020, 16:31:51.837    2020-12-17 14:31:51.837 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.security.web.FilterChainProxy        : /api/notification/last at position 2 of 15 in additional filter chain; firing Filter: 'SecurityContextPersistenceFilter'    backend develop-dev-roscap
  245.     December 17th 2020, 16:31:51.839    2020-12-17 14:31:51.839 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] w.c.HttpSessionSecurityContextRepository : Obtained a valid SecurityContext from SPRING_SECURITY_CONTEXT: 'org.springframework.security.core.context.SecurityContextImpl@d8d6f85f: Authentication: ru.lanit.rbs.authapi.dto.UserAuthentication@d8d6f85f: Principal: ru.lanit.rbs.authapi.dto.ppa.PpaUserData@2729079b; Credentials: [PROTECTED]; Authenticated: true; Details: null; Not granted any authorities'  backend develop-dev-roscap
  246.     December 17th 2020, 16:31:51.840    2020-12-17 14:31:51.840 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.security.web.FilterChainProxy        : /api/notification/last at position 6 of 15 in additional filter chain; firing Filter: 'SessionAuthenticationFilter' backend develop-dev-roscap
  247.     December 17th 2020, 16:31:51.840    2020-12-17 14:31:51.839 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.security.web.FilterChainProxy        : /api/notification/last at position 3 of 15 in additional filter chain; firing Filter: 'HeaderWriterFilter'  backend develop-dev-roscap
  248.     December 17th 2020, 16:31:51.840    2020-12-17 14:31:51.839 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.security.web.FilterChainProxy        : /api/notification/last at position 5 of 15 in additional filter chain; firing Filter: 'LogoutFilter'    backend develop-dev-roscap
  249.     December 17th 2020, 16:31:51.840    2020-12-17 14:31:51.839 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.w.u.matcher.AntPathRequestMatcher  : Request 'GET /api/notification/last' doesn't match 'POST /logout'   backend develop-dev-roscap
  250.     December 17th 2020, 16:31:51.840    2020-12-17 14:31:51.839 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.security.web.FilterChainProxy        : /api/notification/last at position 4 of 15 in additional filter chain; firing Filter: 'CsrfFilter'  backend develop-dev-roscap
  251.     December 17th 2020, 16:31:51.840    2020-12-17 14:31:51.840 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.security.web.FilterChainProxy        : /api/notification/last at position 7 of 15 in additional filter chain; firing Filter: 'RequestDataFilter'   backend develop-dev-roscap
  252.     December 17th 2020, 16:31:51.840    2020-12-17 14:31:51.839 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.w.util.matcher.AndRequestMatcher   : Trying to match using org.springframework.security.web.csrf.CsrfFilter$DefaultRequiresCsrfMatcher@759e29c9  backend develop-dev-roscap
  253.     December 17th 2020, 16:31:51.840    2020-12-17 14:31:51.839 DEBUG 1 [c5b8b678-4c93-4f15-bbef-c517d513a3e6] --- [io-8080-exec-10] o.s.s.w.util.matcher.AndRequestMatcher   : Did not match   backend develop-dev-roscap
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!