API tools faq
paste
DOS93

Untitled

DOS93
Dec 18th, 2020
228
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Apache Log 159.06 KB | None | 0 0
raw download clone embed print report
  1. December 17th 2020, 16:24:24.651    2020-12-17 14:24:24.651 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.security.web.FilterChainProxy        : /api/report/online/ at position 8 of 15 in additional filter chain; firing Filter: 'RequestCacheAwareFilter'    backend develop-dev-roscap
  2.     December 17th 2020, 16:24:24.651    2020-12-17 14:24:24.651 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] 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:24:24.651    2020-12-17 14:24:24.651 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/api/session/get/user'  backend develop-dev-roscap
  4.     December 17th 2020, 16:24:24.651    2020-12-17 14:24:24.651 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.security.web.FilterChainProxy        : /api/report/online/ at position 12 of 15 in additional filter chain; firing Filter: 'AnonymousAuthenticationFilter' backend develop-dev-roscap
  5.     December 17th 2020, 16:24:24.651    2020-12-17 14:24:24.651 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.security.web.FilterChainProxy        : /api/report/online/ at position 15 of 15 in additional filter chain; firing Filter: 'FilterSecurityInterceptor' backend develop-dev-roscap
  6.     December 17th 2020, 16:24:24.651    2020-12-17 14:24:24.651 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/api/swagger-docs/**'   backend develop-dev-roscap
  7.     December 17th 2020, 16:24:24.651    2020-12-17 14:24:24.651 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/api/session/**'    backend develop-dev-roscap
  8.     December 17th 2020, 16:24:24.651    2020-12-17 14:24:24.651 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.security.web.FilterChainProxy        : /api/report/online/ at position 10 of 15 in additional filter chain; firing Filter: 'SpnegoNegotiateHeaderRemoveFilter' backend develop-dev-roscap
  9.     December 17th 2020, 16:24:24.651    2020-12-17 14:24:24.651 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.security.web.FilterChainProxy        : /api/report/online/ at position 11 of 15 in additional filter chain; firing Filter: 'SecurityContextHolderAwareRequestFilter'   backend develop-dev-roscap
  10.     December 17th 2020, 16:24:24.651    2020-12-17 14:24:24.651 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/api/test/**'   backend develop-dev-roscap
  11.     December 17th 2020, 16:24:24.651    2020-12-17 14:24:24.651 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.a.AnonymousAuthenticationFilter  : SecurityContextHolder not populated with anonymous token, as it already contained: 'ru.lanit.rbs.authapi.dto.UserAuthentication@d338b4b6: Principal: ru.lanit.rbs.authapi.dto.ppa.PpaUserData@2cc74b72; Credentials: [PROTECTED]; Authenticated: true; Details: null; Not granted any authorities'  backend develop-dev-roscap
  12.     December 17th 2020, 16:24:24.651    2020-12-17 14:24:24.651 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.security.web.FilterChainProxy        : /api/report/online/ at position 14 of 15 in additional filter chain; firing Filter: 'ExceptionTranslationFilter'    backend develop-dev-roscap
  13.     December 17th 2020, 16:24:24.651    2020-12-17 14:24:24.651 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.security.web.FilterChainProxy        : /api/report/online/ at position 13 of 15 in additional filter chain; firing Filter: 'SessionManagementFilter'   backend develop-dev-roscap
  14.     December 17th 2020, 16:24:24.651    2020-12-17 14:24:24.651 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/api/swagger-ui/**' backend develop-dev-roscap
  15.     December 17th 2020, 16:24:24.651    2020-12-17 14:24:24.651 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/actuator/**'   backend develop-dev-roscap
  16.     December 17th 2020, 16:24:24.652    2020-12-17 14:24:24.651 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/api/ppa/tokens/**/email/confirm'   backend develop-dev-roscap
  17.     December 17th 2020, 16:24:24.652    2020-12-17 14:24:24.652 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.web.util.matcher.OrRequestMatcher  : Trying to match using Ant [pattern='/sso/login']    backend develop-dev-roscap
  18.     December 17th 2020, 16:24:24.652    2020-12-17 14:24:24.652 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] 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:24:24.652    2020-12-17 14:24:24.651 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/api/ppa/employee/keycloak/phone/confirm'   backend develop-dev-roscap
  20.     December 17th 2020, 16:24:24.652    2020-12-17 14:24:24.652 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.access.vote.AffirmativeBased       : Voter: org.springframework.security.web.access.expression.WebExpressionVoter@ec27bc, returned: 1    backend develop-dev-roscap
  21.     December 17th 2020, 16:24:24.652    2020-12-17 14:24:24.652 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.web.util.matcher.OrRequestMatcher  : Trying to match using RequestHeaderRequestMatcher [expectedHeaderName=Authorization, expectedHeaderValue=null]  backend develop-dev-roscap
  22.     December 17th 2020, 16:24:24.652    2020-12-17 14:24:24.652 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.web.util.matcher.OrRequestMatcher  : Trying to match using org.keycloak.adapters.springsecurity.filter.QueryParamPresenceRequestMatcher@20a7a021 backend develop-dev-roscap
  23.     December 17th 2020, 16:24:24.652    2020-12-17 14:24:24.652 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.web.util.matcher.OrRequestMatcher  : No matches found    backend develop-dev-roscap
  24.     December 17th 2020, 16:24:24.652    2020-12-17 14:24:24.651 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/bpm-api/**'    backend develop-dev-roscap
  25.     December 17th 2020, 16:24:24.652    2020-12-17 14:24:24.651 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/direct-bank-gateway/**'    backend develop-dev-roscap
  26.     December 17th 2020, 16:24:24.652    2020-12-17 14:24:24.652 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.a.i.FilterSecurityInterceptor    : Authorization successful    backend develop-dev-roscap
  27.     December 17th 2020, 16:24:24.652    2020-12-17 14:24:24.652 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.security.web.FilterChainProxy        : /api/report/online/ reached end of additional filter chain; proceeding with original chain  backend develop-dev-roscap
  28.     December 17th 2020, 16:24:24.652    2020-12-17 14:24:24.652 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/sso/login' backend develop-dev-roscap
  29.     December 17th 2020, 16:24:24.652    2020-12-17 14:24:24.652 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.util.matcher.AndRequestMatcher   : Did not match   backend develop-dev-roscap
  30.     December 17th 2020, 16:24:24.652    2020-12-17 14:24:24.651 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/api/electronic-dossier-int/**' backend develop-dev-roscap
  31.     December 17th 2020, 16:24:24.652    2020-12-17 14:24:24.651 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.a.i.FilterSecurityInterceptor    : Previously Authenticated: ru.lanit.rbs.authapi.dto.UserAuthentication@d338b4b6: Principal: ru.lanit.rbs.authapi.dto.ppa.PpaUserData@2cc74b72; Credentials: [PROTECTED]; Authenticated: true; Details: null; Not granted any authorities backend develop-dev-roscap
  32.     December 17th 2020, 16:24:24.652    2020-12-17 14:24:24.652 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.a.i.FilterSecurityInterceptor    : RunAsManager did not change Authentication object   backend develop-dev-roscap
  33.     December 17th 2020, 16:24:24.652    2020-12-17 14:24:24.652 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] 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
  34.     December 17th 2020, 16:24:24.652    2020-12-17 14:24:24.651 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/api/settings/get'  backend develop-dev-roscap
  35.     December 17th 2020, 16:24:24.652    2020-12-17 14:24:24.651 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.u.matcher.AntPathRequestMatcher  : Checking match of request : '/api/report/online/'; against '/api/auth-external/**'  backend develop-dev-roscap
  36.     December 17th 2020, 16:24:24.652    2020-12-17 14:24:24.651 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.a.i.FilterSecurityInterceptor    : Secure object: FilterInvocation: URL: /api/report/online/; Attributes: [authenticated]  backend develop-dev-roscap
  37.     December 17th 2020, 16:24:24.653    2020-12-17 14:24:24.653 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] r.l.r.a.i.PermissionInterceptor          : Check allowConditions on method [ReportServiceImpl.generateOnlineReport(..)]    backend develop-dev-roscap
  38.     December 17th 2020, 16:24:24.653    2020-12-17 14:24:24.653 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] r.l.r.a.i.PermissionInterceptor          : Access to method [ReportServiceImpl.generateOnlineReport(..)] granted
  39. 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)<=?
  40. 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=?
  41. Hibernate: select agreementb0_.id as id1_15_2_, agreementb0_.last_editing_date as last_edi2_15_2_, agreementb0_.agreement_id as agreemen5_15_2_, agreementb0_.agreement_bs_type_id as agreemen3_15_2_, agreementb0_.agreement_bs_type_root_id as agreemen4_15_2_, agreementb1_.id as id2_9_0_, agreementb1_.last_editing_date as last_edi3_9_0_, agreementb1_.root_id as root_id4_9_0_, agreementb1_.accepted as accepted5_9_0_, agreementb1_.actual as actual6_9_0_, agreementb1_.agreement_date as agreemen7_9_0_, agreementb1_.agreement_number as agreemen8_9_0_, agreementb1_.create_date as create_d9_9_0_, agreementb1_.edit_reason as edit_re10_9_0_, agreementb1_.edit_reason_id as edit_re11_9_0_, agreementb1_.editor_employee_id as editor_12_9_0_, agreementb1_.editor_organization_id as editor_13_9_0_, agreementb1_.editor_organization_version_id as editor_14_9_0_, agreementb1_.from_credit_road as from_cr15_9_0_, agreementb1_.locked as locked16_9_0_, agreementb1_.on_paper as on_pape17_9_0_, agreementb1_.organization_id as organiz18_9_0_, agreementb1_.organization_version_id as organiz19_9_0_, agreementb1_.rejected_employee_root_id as rejecte20_9_0_, agreementb1_.status_root_id as status_21_9_0_, agreementb1_.system_number as system_22_9_0_, agreementb1_.version_number as version23_9_0_, agreementb1_.accompanied_contract as accompa24_9_0_, agreementb1_.accounting_type_id as account25_9_0_, agreementb1_.additional_info as additio26_9_0_, agreementb1_.controlled_cooperation_level_id as control27_9_0_, agreementb1_.need_change_status_to_sba as need_ch28_9_0_, agreementb1_.project_management_root_id as project29_9_0_, agreementb1_.readiness_compliant as readine30_9_0_, agreementb1_.responsible_employee as respons31_9_0_, participan2_.agreement_id as agreemen8_31_4_, participan2_.id as id1_31_4_, participan2_.id as id1_31_1_, participan2_.last_editing_date as last_edi2_31_1_, participan2_.agreement_id as agreemen8_31_1_, participan2_.bank_details_id as bank_det3_31_1_, participan2_.fund_subject as fund_sub4_31_1_, participan2_.organization_version_id as organiza5_31_1_, participan2_.organization_id as organiza6_31_1_, participan2_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_agreement_bs_type agreementb0_ inner join bagrsm.bagr_agreement agreementb1_ on agreementb0_.agreement_id=agreementb1_.id left outer join bagrsm.bagr_participant participan2_ on agreementb1_.id=participan2_.agreement_id where agreementb0_.agreement_id=?
  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 id1_15_2_, agreementb0_.last_editing_date as last_edi2_15_2_, agreementb0_.agreement_id as agreemen5_15_2_, agreementb0_.agreement_bs_type_id as agreemen3_15_2_, agreementb0_.agreement_bs_type_root_id as agreemen4_15_2_, agreementb1_.id as id2_9_0_, agreementb1_.last_editing_date as last_edi3_9_0_, agreementb1_.root_id as root_id4_9_0_, agreementb1_.accepted as accepted5_9_0_, agreementb1_.actual as actual6_9_0_, agreementb1_.agreement_date as agreemen7_9_0_, agreementb1_.agreement_number as agreemen8_9_0_, agreementb1_.create_date as create_d9_9_0_, agreementb1_.edit_reason as edit_re10_9_0_, agreementb1_.edit_reason_id as edit_re11_9_0_, agreementb1_.editor_employee_id as editor_12_9_0_, agreementb1_.editor_organization_id as editor_13_9_0_, agreementb1_.editor_organization_version_id as editor_14_9_0_, agreementb1_.from_credit_road as from_cr15_9_0_, agreementb1_.locked as locked16_9_0_, agreementb1_.on_paper as on_pape17_9_0_, agreementb1_.organization_id as organiz18_9_0_, agreementb1_.organization_version_id as organiz19_9_0_, agreementb1_.rejected_employee_root_id as rejecte20_9_0_, agreementb1_.status_root_id as status_21_9_0_, agreementb1_.system_number as system_22_9_0_, agreementb1_.version_number as version23_9_0_, agreementb1_.accompanied_contract as accompa24_9_0_, agreementb1_.accounting_type_id as account25_9_0_, agreementb1_.additional_info as additio26_9_0_, agreementb1_.controlled_cooperation_level_id as control27_9_0_, agreementb1_.need_change_status_to_sba as need_ch28_9_0_, agreementb1_.project_management_root_id as project29_9_0_, agreementb1_.readiness_compliant as readine30_9_0_, agreementb1_.responsible_employee as respons31_9_0_, participan2_.agreement_id as agreemen8_31_4_, participan2_.id as id1_31_4_, participan2_.id as id1_31_1_, participan2_.last_editing_date as last_edi2_31_1_, participan2_.agreement_id as agreemen8_31_1_, participan2_.bank_details_id as bank_det3_31_1_, participan2_.fund_subject as fund_sub4_31_1_, participan2_.organization_version_id as organiza5_31_1_, participan2_.organization_id as organiza6_31_1_, participan2_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_agreement_bs_type agreementb0_ inner join bagrsm.bagr_agreement agreementb1_ on agreementb0_.agreement_id=agreementb1_.id left outer join bagrsm.bagr_participant participan2_ on agreementb1_.id=participan2_.agreement_id where agreementb0_.agreement_id=?
  44. 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=?
  45. Hibernate: select agreementb0_.id as id1_15_2_, agreementb0_.last_editing_date as last_edi2_15_2_, agreementb0_.agreement_id as agreemen5_15_2_, agreementb0_.agreement_bs_type_id as agreemen3_15_2_, agreementb0_.agreement_bs_type_root_id as agreemen4_15_2_, agreementb1_.id as id2_9_0_, agreementb1_.last_editing_date as last_edi3_9_0_, agreementb1_.root_id as root_id4_9_0_, agreementb1_.accepted as accepted5_9_0_, agreementb1_.actual as actual6_9_0_, agreementb1_.agreement_date as agreemen7_9_0_, agreementb1_.agreement_number as agreemen8_9_0_, agreementb1_.create_date as create_d9_9_0_, agreementb1_.edit_reason as edit_re10_9_0_, agreementb1_.edit_reason_id as edit_re11_9_0_, agreementb1_.editor_employee_id as editor_12_9_0_, agreementb1_.editor_organization_id as editor_13_9_0_, agreementb1_.editor_organization_version_id as editor_14_9_0_, agreementb1_.from_credit_road as from_cr15_9_0_, agreementb1_.locked as locked16_9_0_, agreementb1_.on_paper as on_pape17_9_0_, agreementb1_.organization_id as organiz18_9_0_, agreementb1_.organization_version_id as organiz19_9_0_, agreementb1_.rejected_employee_root_id as rejecte20_9_0_, agreementb1_.status_root_id as status_21_9_0_, agreementb1_.system_number as system_22_9_0_, agreementb1_.version_number as version23_9_0_, agreementb1_.accompanied_contract as accompa24_9_0_, agreementb1_.accounting_type_id as account25_9_0_, agreementb1_.additional_info as additio26_9_0_, agreementb1_.controlled_cooperation_level_id as control27_9_0_, agreementb1_.need_change_status_to_sba as need_ch28_9_0_, agreementb1_.project_management_root_id as project29_9_0_, agreementb1_.readiness_compliant as readine30_9_0_, agreementb1_.responsible_employee as respons31_9_0_, participan2_.agreement_id as agreemen8_31_4_, participan2_.id as id1_31_4_, participan2_.id as id1_31_1_, participan2_.last_editing_date as last_edi2_31_1_, participan2_.agreement_id as agreemen8_31_1_, participan2_.bank_details_id as bank_det3_31_1_, participan2_.fund_subject as fund_sub4_31_1_, participan2_.organization_version_id as organiza5_31_1_, participan2_.organization_id as organiza6_31_1_, participan2_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_agreement_bs_type agreementb0_ inner join bagrsm.bagr_agreement agreementb1_ on agreementb0_.agreement_id=agreementb1_.id left outer join bagrsm.bagr_participant participan2_ on agreementb1_.id=participan2_.agreement_id where agreementb0_.agreement_id=?   backend develop-dev-roscap
  46.     December 17th 2020, 16:24:25.112    2020-12-17 14:24:25.112 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] r.l.r.b.i.b.info.AgreementBsServiceImpl  : Found 10 bank support agreements    backend develop-dev-roscap
  47.     December 17th 2020, 16:24:25.113    2020-12-17 14:24:25.113 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [lTaskExecutor-2] r.l.r.report.impl.algorithm.ReportA_O_5  : A_O_5: Start creating online reports, agreementId=11028
  48. 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_.accepted=? and agreementb0_.root_id=(select agreementb1_.root_id from bagrsm.bagr_agreement agreementb1_ where agreementb1_.agreement_type_root_id=1 and agreementb1_.id=?)
  49. 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_.accepted=? and agreementb0_.root_id=(select agreementb1_.root_id from bagrsm.bagr_agreement agreementb1_ where agreementb1_.agreement_type_root_id=1 and agreementb1_.id=?)
  50. Hibernate: select fileformat0_.file_attachment_type_id as file_att1_119_0_, fileformat0_.file_format_root_id as file_for2_119_0_ from nsism.nsi_file_attachment_type_file_format_limitation fileformat0_ where fileformat0_.file_attachment_type_id=?
  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 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=?
  53. Hibernate: select entitytype0_.file_attach_type_id as file_att1_117_0_, entitytype0_.entity_type_root_id as entity_t2_117_0_ from nsism.nsi_file_attachment_entity_type entitytype0_ where entitytype0_.file_attach_type_id=?
  54. Hibernate: select fileformat0_.file_attachment_type_id as file_att1_119_0_, fileformat0_.file_format_root_id as file_for2_119_0_ from nsism.nsi_file_attachment_type_file_format_limitation fileformat0_ where fileformat0_.file_attachment_type_id=?
  55. Hibernate: select entitytype0_.file_attach_type_id as file_att1_117_0_, entitytype0_.entity_type_root_id as entity_t2_117_0_ from nsism.nsi_file_attachment_entity_type entitytype0_ where entitytype0_.file_attach_type_id=?   backend develop-dev-roscap
  56.     December 17th 2020, 16:24:25.121    2020-12-17 14:24:25.121 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.header.writers.HstsHeaderWriter  : Not injecting HSTS header since it did not match the requestMatcher org.springframework.security.web.header.writers.HstsHeaderWriter$SecureRequestMatcher@608c1119
  57. Hibernate: select agreementb0_.id as id1_15_2_, agreementb0_.last_editing_date as last_edi2_15_2_, agreementb0_.agreement_id as agreemen5_15_2_, agreementb0_.agreement_bs_type_id as agreemen3_15_2_, agreementb0_.agreement_bs_type_root_id as agreemen4_15_2_, agreementb1_.id as id2_9_0_, agreementb1_.last_editing_date as last_edi3_9_0_, agreementb1_.root_id as root_id4_9_0_, agreementb1_.accepted as accepted5_9_0_, agreementb1_.actual as actual6_9_0_, agreementb1_.agreement_date as agreemen7_9_0_, agreementb1_.agreement_number as agreemen8_9_0_, agreementb1_.create_date as create_d9_9_0_, agreementb1_.edit_reason as edit_re10_9_0_, agreementb1_.edit_reason_id as edit_re11_9_0_, agreementb1_.editor_employee_id as editor_12_9_0_, agreementb1_.editor_organization_id as editor_13_9_0_, agreementb1_.editor_organization_version_id as editor_14_9_0_, agreementb1_.from_credit_road as from_cr15_9_0_, agreementb1_.locked as locked16_9_0_, agreementb1_.on_paper as on_pape17_9_0_, agreementb1_.organization_id as organiz18_9_0_, agreementb1_.organization_version_id as organiz19_9_0_, agreementb1_.rejected_employee_root_id as rejecte20_9_0_, agreementb1_.status_root_id as status_21_9_0_, agreementb1_.system_number as system_22_9_0_, agreementb1_.version_number as version23_9_0_, agreementb1_.accompanied_contract as accompa24_9_0_, agreementb1_.accounting_type_id as account25_9_0_, agreementb1_.additional_info as additio26_9_0_, agreementb1_.controlled_cooperation_level_id as control27_9_0_, agreementb1_.need_change_status_to_sba as need_ch28_9_0_, agreementb1_.project_management_root_id as project29_9_0_, agreementb1_.readiness_compliant as readine30_9_0_, agreementb1_.responsible_employee as respons31_9_0_, participan2_.agreement_id as agreemen8_31_4_, participan2_.id as id1_31_4_, participan2_.id as id1_31_1_, participan2_.last_editing_date as last_edi2_31_1_, participan2_.agreement_id as agreemen8_31_1_, participan2_.bank_details_id as bank_det3_31_1_, participan2_.fund_subject as fund_sub4_31_1_, participan2_.organization_version_id as organiza5_31_1_, participan2_.organization_id as organiza6_31_1_, participan2_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_agreement_bs_type agreementb0_ inner join bagrsm.bagr_agreement agreementb1_ on agreementb0_.agreement_id=agreementb1_.id left outer join bagrsm.bagr_participant participan2_ on agreementb1_.id=participan2_.agreement_id where agreementb0_.agreement_id=?
  58. Hibernate: select fileformat0_.file_attachment_type_id as file_att1_119_0_, fileformat0_.file_format_root_id as file_for2_119_0_ from nsism.nsi_file_attachment_type_file_format_limitation fileformat0_ where fileformat0_.file_attachment_type_id=?
  59. Hibernate: select entitytype0_.file_attach_type_id as file_att1_117_0_, entitytype0_.entity_type_root_id as entity_t2_117_0_ from nsism.nsi_file_attachment_entity_type entitytype0_ where entitytype0_.file_attach_type_id=?
  60. 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
  61. Hibernate: select fileformat0_.file_attachment_type_id as file_att1_119_0_, fileformat0_.file_format_root_id as file_for2_119_0_ from nsism.nsi_file_attachment_type_file_format_limitation fileformat0_ where fileformat0_.file_attachment_type_id=?
  62. Hibernate: select entitytype0_.file_attach_type_id as file_att1_117_0_, entitytype0_.entity_type_root_id as entity_t2_117_0_ from nsism.nsi_file_attachment_entity_type entitytype0_ where entitytype0_.file_attach_type_id=?   backend develop-dev-roscap
  63.     December 17th 2020, 16:24:25.126    2020-12-17 14:24:25.126 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] s.s.w.c.SecurityContextPersistenceFilter : SecurityContextHolder now cleared, as request processing completed
  64. Hibernate: select fileformat0_.file_attachment_type_id as file_att1_119_0_, fileformat0_.file_format_root_id as file_for2_119_0_ from nsism.nsi_file_attachment_type_file_format_limitation fileformat0_ where fileformat0_.file_attachment_type_id=?
  65. Hibernate: select entitytype0_.file_attach_type_id as file_att1_117_0_, entitytype0_.entity_type_root_id as entity_t2_117_0_ from nsism.nsi_file_attachment_entity_type entitytype0_ where entitytype0_.file_attach_type_id=?
  66. Hibernate: select fileformat0_.file_attachment_type_id as file_att1_119_0_, fileformat0_.file_format_root_id as file_for2_119_0_ from nsism.nsi_file_attachment_type_file_format_limitation fileformat0_ where fileformat0_.file_attachment_type_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 entitytype0_.file_attach_type_id as file_att1_117_0_, entitytype0_.entity_type_root_id as entity_t2_117_0_ from nsism.nsi_file_attachment_entity_type entitytype0_ where entitytype0_.file_attach_type_id=?
  69. Hibernate: select fileformat0_.file_attachment_type_id as file_att1_119_0_, fileformat0_.file_format_root_id as file_for2_119_0_ from nsism.nsi_file_attachment_type_file_format_limitation fileformat0_ where fileformat0_.file_attachment_type_id=?
  70. 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=?
  71. Hibernate: select entitytype0_.file_attach_type_id as file_att1_117_0_, entitytype0_.entity_type_root_id as entity_t2_117_0_ from nsism.nsi_file_attachment_entity_type entitytype0_ where entitytype0_.file_attach_type_id=?
  72. Hibernate: select fileformat0_.file_attachment_type_id as file_att1_119_0_, fileformat0_.file_format_root_id as file_for2_119_0_ from nsism.nsi_file_attachment_type_file_format_limitation fileformat0_ where fileformat0_.file_attachment_type_id=?
  73. 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
  74. Hibernate: select filemetada0_.id as id1_72_, filemetada0_.blob_id as blob_id2_72_, filemetada0_.blob_url as blob_url3_72_, filemetada0_.context as context4_72_, filemetada0_.create_date as create_d5_72_, filemetada0_.document_date as document6_72_, filemetada0_.document_number as document7_72_, filemetada0_.document_status_root_id as document8_72_, filemetada0_.document_type_code as document9_72_, filemetada0_.document_type_id as documen10_72_, filemetada0_.entity_id as entity_11_72_, filemetada0_.entity_type as entity_12_72_, filemetada0_.hash as hash13_72_, filemetada0_.hidden as hidden14_72_, filemetada0_.last_editing_date as last_ed15_72_, filemetada0_.linked_sign_object as linked_16_72_, filemetada0_.name as name17_72_, filemetada0_.signed_by_one_party as signed_18_72_, filemetada0_.size as size19_72_, filemetada0_.status as status20_72_, filemetada0_.user_root_id as user_ro21_72_, filemetada0_.visible_to_client as visible22_72_ from fssm.fs_file filemetada0_ where filemetada0_.entity_type=? and filemetada0_.entity_id=?
  75. 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=?
  76. Hibernate: select agreementb0_.agreement_bs_type_id as agreeme11_16_0_, agreementb0_.id as id1_16_0_, agreementb0_.id as id1_16_1_, agreementb0_.last_editing_date as last_edi2_16_1_, agreementb0_.additional_info as addition3_16_1_, agreementb0_.bank_details_id_value as bank_det4_16_1_, agreementb0_.date_value as date_val5_16_1_, agreementb0_.nsi_value_id as nsi_valu6_16_1_, agreementb0_.nsi_value_root_id as nsi_valu7_16_1_, agreementb0_.numeric_value as numeric_8_16_1_, agreementb0_.text_value as text_val9_16_1_, agreementb0_.agreement_bs_type_id as agreeme11_16_1_, agreementb0_.agreement_type_attribute_id as agreeme10_16_1_ from bagrsm.bagr_agreement_bs_type_attribute agreementb0_ where agreementb0_.agreement_bs_type_id=?
  77. Hibernate: select agreementb0_.agreement_id as agreemen5_10_0_, agreementb0_.id as id1_10_0_, agreementb0_.id as id1_10_1_, agreementb0_.last_editing_date as last_edi2_10_1_, agreementb0_.root_id as root_id3_10_1_, agreementb0_.agreement_id as agreemen5_10_1_, agreementb0_.commission_type_id as commissi4_10_1_ from bagrsm.bagr_agreement_bs_commission agreementb0_ where agreementb0_.agreement_id=?
  78. 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=?
  79. Hibernate: select agreementb0_.commission_id as commiss12_11_0_, agreementb0_.id as id1_11_0_, agreementb0_.id as id1_11_1_, agreementb0_.last_editing_date as last_edi2_11_1_, agreementb0_.additional_info as addition3_11_1_, agreementb0_.bank_details_id_value as bank_det4_11_1_, agreementb0_.date_value as date_val5_11_1_, agreementb0_.nsi_value_id as nsi_valu6_11_1_, agreementb0_.nsi_value_root_id as nsi_valu7_11_1_, agreementb0_.numeric_value as numeric_8_11_1_, agreementb0_.text_value as text_val9_11_1_, agreementb0_.commission_id as commiss12_11_1_, agreementb0_.commission_attribute_type_id as commiss10_11_1_, agreementb0_.date_end_value as date_en11_11_1_ from bagrsm.bagr_agreement_bs_commission_attribute agreementb0_ where agreementb0_.commission_id=?
  80. 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
  81. Hibernate: select nsicommiss0_.id as id1_95_, nsicommiss0_.actual as actual2_95_, nsicommiss0_.create_date as create_d3_95_, nsicommiss0_.deleted as deleted4_95_, nsicommiss0_.inner_code as inner_co5_95_, nsicommiss0_.last_editing_date as last_edi6_95_, nsicommiss0_.root_id as root_id7_95_, nsicommiss0_.sort_order as sort_ord8_95_, nsicommiss0_.value as value9_95_, nsicommiss0_.version_number as version10_95_, nsicommiss0_.added_manually as added_m11_95_, nsicommiss0_.attribute_type_root_id as attribu12_95_, nsicommiss0_.default_bank_details_value_id as default13_95_, nsicommiss0_.default_date_value as default14_95_, nsicommiss0_.default_nsi_value_id as default15_95_, nsicommiss0_.default_nsi_value_root_id as default16_95_, nsicommiss0_.default_numeric_value as default17_95_, nsicommiss0_.default_text_value as default18_95_, nsicommiss0_.nsi_value_dic_root_id as nsi_val19_95_, nsicommiss0_.required as require20_95_, nsicommiss0_.commission_type_root_id as commiss21_95_, nsicommiss0_.default_date_end_value as default22_95_ from nsism.nsi_commission_type_attribute nsicommiss0_ where nsicommiss0_.id in (1 , 2 , 3 , 4 , 5 , 8 , 9 , 11 , 12 , 13) order by nsicommiss0_.sort_order asc
  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=? backend develop-dev-roscap
  83.     December 17th 2020, 16:24:25.126    2020-12-17 14:24:25.126 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.a.ExceptionTranslationFilter     : Chain processed normally    backend develop-dev-roscap
  84.     December 17th 2020, 16:24:25.217    2020-12-17 14:24:25.217 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [lTaskExecutor-2] r.l.r.report.impl.algorithm.ReportA_O_2  : A_O_2: Start generating quarterly report data, reportPeriod=startDate=2020-11-23, endDate=2020-12-17, isOnline=true
  85. 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=?
  86. Hibernate: select agreementb0_.agreement_id as agreeme17_12_0_, agreementb0_.id as id1_12_0_, agreementb0_.id as id1_12_1_, agreementb0_.last_editing_date as last_edi2_12_1_, agreementb0_.root_id as root_id3_12_1_, agreementb0_.agreement_id as agreeme17_12_1_, agreementb0_.create_date as create_d4_12_1_, agreementb0_.fund_code as fund_cod5_12_1_, agreementb0_.issue_date as issue_da6_12_1_, agreementb0_.object_address as object_a7_12_1_, agreementb0_.object_address_text as object_a8_12_1_, agreementb0_.object_eis_id as object_e9_12_1_, agreementb0_.object_name as object_10_12_1_, agreementb0_.object_number as object_11_12_1_, agreementb0_.project_cost as project12_12_1_, agreementb0_.project_id as project13_12_1_, agreementb0_.prolonged_to_date as prolong14_12_1_, agreementb0_.region_id as region_15_12_1_, agreementb0_.valid_to_date as valid_t16_12_1_ from bagrsm.bagr_agreement_bs_object agreementb0_ where agreementb0_.agreement_id=?  backend develop-dev-roscap
  87.     December 17th 2020, 16:24:25.221    2020-12-17 14:24:25.220 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [lTaskExecutor-2] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: agreement = {"rootId":11028,"customerOrgRootId":19,"performerOrgRootIds":[],"objects":[{"rootId":1008,"objectAddress":"Московская область, Москва, Мира 15","objectName":"ЖК Ласточка","projectId":"2312","id":1064,"lastEditingDate":{"dateTime":{"date":{"year":2020,"month":11,"day":26},"time":{"hour":9,"minute":15,"second":0,"nano":516795000}},"offset":{"totalSeconds":10800}}}],"quarterlyReportPeriod":{"startDate":{"year":2020,"month":11,"day":23},"endDate":{"year":2020,"month":12,"day":17}},"agreementDate":{"year":2020,"month":11,"day":23},"reportKinds":["REPORT_3","REPORT_4","REPORT_2","REPORT_6","REPORT_5"]}   backend develop-dev-roscap
  88.     December 17th 2020, 16:24:25.221    2020-12-17 14:24:25.221 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [lTaskExecutor-2] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: aDbs77.run() params = ([11028], 2020-12-17)
  89. 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)<=?
  90. 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
  91. 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_.id=?
  92. 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=?
  93. 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=?
  94. 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=?
  95. Hibernate: select agreementb0_.id as id1_15_2_, agreementb0_.last_editing_date as last_edi2_15_2_, agreementb0_.agreement_id as agreemen5_15_2_, agreementb0_.agreement_bs_type_id as agreemen3_15_2_, agreementb0_.agreement_bs_type_root_id as agreemen4_15_2_, agreementb1_.id as id2_9_0_, agreementb1_.last_editing_date as last_edi3_9_0_, agreementb1_.root_id as root_id4_9_0_, agreementb1_.accepted as accepted5_9_0_, agreementb1_.actual as actual6_9_0_, agreementb1_.agreement_date as agreemen7_9_0_, agreementb1_.agreement_number as agreemen8_9_0_, agreementb1_.create_date as create_d9_9_0_, agreementb1_.edit_reason as edit_re10_9_0_, agreementb1_.edit_reason_id as edit_re11_9_0_, agreementb1_.editor_employee_id as editor_12_9_0_, agreementb1_.editor_organization_id as editor_13_9_0_, agreementb1_.editor_organization_version_id as editor_14_9_0_, agreementb1_.from_credit_road as from_cr15_9_0_, agreementb1_.locked as locked16_9_0_, agreementb1_.on_paper as on_pape17_9_0_, agreementb1_.organization_id as organiz18_9_0_, agreementb1_.organization_version_id as organiz19_9_0_, agreementb1_.rejected_employee_root_id as rejecte20_9_0_, agreementb1_.status_root_id as status_21_9_0_, agreementb1_.system_number as system_22_9_0_, agreementb1_.version_number as version23_9_0_, agreementb1_.accompanied_contract as accompa24_9_0_, agreementb1_.accounting_type_id as account25_9_0_, agreementb1_.additional_info as additio26_9_0_, agreementb1_.controlled_cooperation_level_id as control27_9_0_, agreementb1_.need_change_status_to_sba as need_ch28_9_0_, agreementb1_.project_management_root_id as project29_9_0_, agreementb1_.readiness_compliant as readine30_9_0_, agreementb1_.responsible_employee as respons31_9_0_, participan2_.agreement_id as agreemen8_31_4_, participan2_.id as id1_31_4_, participan2_.id as id1_31_1_, participan2_.last_editing_date as last_edi2_31_1_, participan2_.agreement_id as agreemen8_31_1_, participan2_.bank_details_id as bank_det3_31_1_, participan2_.fund_subject as fund_sub4_31_1_, participan2_.organization_version_id as organiza5_31_1_, participan2_.organization_id as organiza6_31_1_, participan2_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_agreement_bs_type agreementb0_ inner join bagrsm.bagr_agreement agreementb1_ on agreementb0_.agreement_id=agreementb1_.id left outer join bagrsm.bagr_participant participan2_ on agreementb1_.id=participan2_.agreement_id where agreementb0_.agreement_id=?
  96. 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=?
  97. 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=?
  98. 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
  99. 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=?
  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 agreementb0_.id as id1_15_2_, agreementb0_.last_editing_date as last_edi2_15_2_, agreementb0_.agreement_id as agreemen5_15_2_, agreementb0_.agreement_bs_type_id as agreemen3_15_2_, agreementb0_.agreement_bs_type_root_id as agreemen4_15_2_, agreementb1_.id as id2_9_0_, agreementb1_.last_editing_date as last_edi3_9_0_, agreementb1_.root_id as root_id4_9_0_, agreementb1_.accepted as accepted5_9_0_, agreementb1_.actual as actual6_9_0_, agreementb1_.agreement_date as agreemen7_9_0_, agreementb1_.agreement_number as agreemen8_9_0_, agreementb1_.create_date as create_d9_9_0_, agreementb1_.edit_reason as edit_re10_9_0_, agreementb1_.edit_reason_id as edit_re11_9_0_, agreementb1_.editor_employee_id as editor_12_9_0_, agreementb1_.editor_organization_id as editor_13_9_0_, agreementb1_.editor_organization_version_id as editor_14_9_0_, agreementb1_.from_credit_road as from_cr15_9_0_, agreementb1_.locked as locked16_9_0_, agreementb1_.on_paper as on_pape17_9_0_, agreementb1_.organization_id as organiz18_9_0_, agreementb1_.organization_version_id as organiz19_9_0_, agreementb1_.rejected_employee_root_id as rejecte20_9_0_, agreementb1_.status_root_id as status_21_9_0_, agreementb1_.system_number as system_22_9_0_, agreementb1_.version_number as version23_9_0_, agreementb1_.accompanied_contract as accompa24_9_0_, agreementb1_.accounting_type_id as account25_9_0_, agreementb1_.additional_info as additio26_9_0_, agreementb1_.controlled_cooperation_level_id as control27_9_0_, agreementb1_.need_change_status_to_sba as need_ch28_9_0_, agreementb1_.project_management_root_id as project29_9_0_, agreementb1_.readiness_compliant as readine30_9_0_, agreementb1_.responsible_employee as respons31_9_0_, participan2_.agreement_id as agreemen8_31_4_, participan2_.id as id1_31_4_, participan2_.id as id1_31_1_, participan2_.last_editing_date as last_edi2_31_1_, participan2_.agreement_id as agreemen8_31_1_, participan2_.bank_details_id as bank_det3_31_1_, participan2_.fund_subject as fund_sub4_31_1_, participan2_.organization_version_id as organiza5_31_1_, participan2_.organization_id as organiza6_31_1_, participan2_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_agreement_bs_type agreementb0_ inner join bagrsm.bagr_agreement agreementb1_ on agreementb0_.agreement_id=agreementb1_.id left outer join bagrsm.bagr_participant participan2_ on agreementb1_.id=participan2_.agreement_id where agreementb0_.agreement_id=?
  103. Hibernate: select bankdetail0_.id as id1_35_, bankdetail0_.last_editing_date as last_edi2_35_, bankdetail0_.root_id as root_id3_35_, bankdetail0_.account as account4_35_, bankdetail0_.account_status_root_id as account_5_35_, bankdetail0_.account_type_root_id as account_6_35_, bankdetail0_.actual as actual7_35_, bankdetail0_.author_employee_root_id as author_e8_35_, bankdetail0_.author_org_root_id as author_o9_35_, bankdetail0_.base_agreement_date as base_ag10_35_, bankdetail0_.base_agreement_number as base_ag11_35_, bankdetail0_.bic as bic12_35_, bankdetail0_.close_date as close_d13_35_, bankdetail0_.correspondent_account as corresp14_35_, bankdetail0_.create_date as create_15_35_, bankdetail0_.credit_organization_name as credit_16_35_, bankdetail0_.currency_root_id as currenc17_35_, bankdetail0_.details_name as details18_35_, bankdetail0_.first_name as first_n19_35_, bankdetail0_.from_athena as from_at20_35_, bankdetail0_.inn as inn21_35_, bankdetail0_.last_name as last_na22_35_, bankdetail0_.middle_name as middle_23_35_, bankdetail0_.na_id as na_id24_35_, bankdetail0_.na_update_date as na_upda25_35_, bankdetail0_.open_date as open_da26_35_, bankdetail0_.ppa_organization_id as ppa_org27_35_, bankdetail0_.person_recipient as person_28_35_, bankdetail0_.recipient_name as recipie29_35_, bankdetail0_.subdivision_code as subdivi30_35_, bankdetail0_.version_number as version31_35_ from bdtsm.bdt_bank_details bankdetail0_ where bankdetail0_.root_id=? and bankdetail0_.actual=?
  104. 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=?
  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 agreementb0_.id as id1_15_2_, agreementb0_.last_editing_date as last_edi2_15_2_, agreementb0_.agreement_id as agreemen5_15_2_, agreementb0_.agreement_bs_type_id as agreemen3_15_2_, agreementb0_.agreement_bs_type_root_id as agreemen4_15_2_, agreementb1_.id as id2_9_0_, agreementb1_.last_editing_date as last_edi3_9_0_, agreementb1_.root_id as root_id4_9_0_, agreementb1_.accepted as accepted5_9_0_, agreementb1_.actual as actual6_9_0_, agreementb1_.agreement_date as agreemen7_9_0_, agreementb1_.agreement_number as agreemen8_9_0_, agreementb1_.create_date as create_d9_9_0_, agreementb1_.edit_reason as edit_re10_9_0_, agreementb1_.edit_reason_id as edit_re11_9_0_, agreementb1_.editor_employee_id as editor_12_9_0_, agreementb1_.editor_organization_id as editor_13_9_0_, agreementb1_.editor_organization_version_id as editor_14_9_0_, agreementb1_.from_credit_road as from_cr15_9_0_, agreementb1_.locked as locked16_9_0_, agreementb1_.on_paper as on_pape17_9_0_, agreementb1_.organization_id as organiz18_9_0_, agreementb1_.organization_version_id as organiz19_9_0_, agreementb1_.rejected_employee_root_id as rejecte20_9_0_, agreementb1_.status_root_id as status_21_9_0_, agreementb1_.system_number as system_22_9_0_, agreementb1_.version_number as version23_9_0_, agreementb1_.accompanied_contract as accompa24_9_0_, agreementb1_.accounting_type_id as account25_9_0_, agreementb1_.additional_info as additio26_9_0_, agreementb1_.controlled_cooperation_level_id as control27_9_0_, agreementb1_.need_change_status_to_sba as need_ch28_9_0_, agreementb1_.project_management_root_id as project29_9_0_, agreementb1_.readiness_compliant as readine30_9_0_, agreementb1_.responsible_employee as respons31_9_0_, participan2_.agreement_id as agreemen8_31_4_, participan2_.id as id1_31_4_, participan2_.id as id1_31_1_, participan2_.last_editing_date as last_edi2_31_1_, participan2_.agreement_id as agreemen8_31_1_, participan2_.bank_details_id as bank_det3_31_1_, participan2_.fund_subject as fund_sub4_31_1_, participan2_.organization_version_id as organiza5_31_1_, participan2_.organization_id as organiza6_31_1_, participan2_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_agreement_bs_type agreementb0_ inner join bagrsm.bagr_agreement agreementb1_ on agreementb0_.agreement_id=agreementb1_.id left outer join bagrsm.bagr_participant participan2_ on agreementb1_.id=participan2_.agreement_id where agreementb0_.agreement_id=?
  107. Hibernate: select bankdetail0_.bank_details_id as bank_det5_39_0_, bankdetail0_.id as id1_39_0_, bankdetail0_.id as id1_39_1_, bankdetail0_.last_editing_date as last_edi2_39_1_, bankdetail0_.author_organization_root_id as author_o3_39_1_, bankdetail0_.bank_details_id as bank_det5_39_1_, bankdetail0_.deleted as deleted4_39_1_ from bdtsm.bdt_bank_details_organizations bankdetail0_ where bankdetail0_.bank_details_id=?
  108. 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
  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 balanceent0_.id as id1_34_, balanceent0_.last_editing_date as last_edi2_34_, balanceent0_.root_id as root_id3_34_, balanceent0_.actual as actual4_34_, balanceent0_.balance as balance5_34_, balanceent0_.bank_details_root_id as bank_det6_34_, balanceent0_.create_date as create_d7_34_, balanceent0_.version_number as version_8_34_ from bdtsm.bdt_balance balanceent0_ where balanceent0_.actual=? and balanceent0_.bank_details_root_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 id1_15_2_, agreementb0_.last_editing_date as last_edi2_15_2_, agreementb0_.agreement_id as agreemen5_15_2_, agreementb0_.agreement_bs_type_id as agreemen3_15_2_, agreementb0_.agreement_bs_type_root_id as agreemen4_15_2_, agreementb1_.id as id2_9_0_, agreementb1_.last_editing_date as last_edi3_9_0_, agreementb1_.root_id as root_id4_9_0_, agreementb1_.accepted as accepted5_9_0_, agreementb1_.actual as actual6_9_0_, agreementb1_.agreement_date as agreemen7_9_0_, agreementb1_.agreement_number as agreemen8_9_0_, agreementb1_.create_date as create_d9_9_0_, agreementb1_.edit_reason as edit_re10_9_0_, agreementb1_.edit_reason_id as edit_re11_9_0_, agreementb1_.editor_employee_id as editor_12_9_0_, agreementb1_.editor_organization_id as editor_13_9_0_, agreementb1_.editor_organization_version_id as editor_14_9_0_, agreementb1_.from_credit_road as from_cr15_9_0_, agreementb1_.locked as locked16_9_0_, agreementb1_.on_paper as on_pape17_9_0_, agreementb1_.organization_id as organiz18_9_0_, agreementb1_.organization_version_id as organiz19_9_0_, agreementb1_.rejected_employee_root_id as rejecte20_9_0_, agreementb1_.status_root_id as status_21_9_0_, agreementb1_.system_number as system_22_9_0_, agreementb1_.version_number as version23_9_0_, agreementb1_.accompanied_contract as accompa24_9_0_, agreementb1_.accounting_type_id as account25_9_0_, agreementb1_.additional_info as additio26_9_0_, agreementb1_.controlled_cooperation_level_id as control27_9_0_, agreementb1_.need_change_status_to_sba as need_ch28_9_0_, agreementb1_.project_management_root_id as project29_9_0_, agreementb1_.readiness_compliant as readine30_9_0_, agreementb1_.responsible_employee as respons31_9_0_, participan2_.agreement_id as agreemen8_31_4_, participan2_.id as id1_31_4_, participan2_.id as id1_31_1_, participan2_.last_editing_date as last_edi2_31_1_, participan2_.agreement_id as agreemen8_31_1_, participan2_.bank_details_id as bank_det3_31_1_, participan2_.fund_subject as fund_sub4_31_1_, participan2_.organization_version_id as organiza5_31_1_, participan2_.organization_id as organiza6_31_1_, participan2_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_agreement_bs_type agreementb0_ inner join bagrsm.bagr_agreement agreementb1_ on agreementb0_.agreement_id=agreementb1_.id left outer join bagrsm.bagr_participant participan2_ on agreementb1_.id=participan2_.agreement_id where agreementb0_.agreement_id=?
  113. Hibernate: select budgetstru0_.agreement_id as agreemen4_21_0_, budgetstru0_.id as id1_21_0_, budgetstru0_.id as id1_21_1_, budgetstru0_.last_editing_date as last_edi2_21_1_, budgetstru0_.agreement_id as agreemen4_21_1_, budgetstru0_.applicability_type_root_id as applicab3_21_1_ from bagrsm.bagr_budget_structure budgetstru0_ where budgetstru0_.agreement_id=?
  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 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=?
  116. Hibernate: select agreementb0_.budget_structure_id as budget_s6_22_0_, agreementb0_.id as id1_22_0_, agreementb0_.id as id1_22_1_, agreementb0_.last_editing_date as last_edi2_22_1_, agreementb0_.root_id as root_id3_22_1_, agreementb0_.budget_structure_id as budget_s6_22_1_, agreementb0_.commission_item as commissi4_22_1_, agreementb0_.expense_distribution_item_id as expense_5_22_1_ from bagrsm.bagr_budget_structure_item agreementb0_ where agreementb0_.budget_structure_id=?
  117. Hibernate: select agreementb0_.id as id1_15_2_, agreementb0_.last_editing_date as last_edi2_15_2_, agreementb0_.agreement_id as agreemen5_15_2_, agreementb0_.agreement_bs_type_id as agreemen3_15_2_, agreementb0_.agreement_bs_type_root_id as agreemen4_15_2_, agreementb1_.id as id2_9_0_, agreementb1_.last_editing_date as last_edi3_9_0_, agreementb1_.root_id as root_id4_9_0_, agreementb1_.accepted as accepted5_9_0_, agreementb1_.actual as actual6_9_0_, agreementb1_.agreement_date as agreemen7_9_0_, agreementb1_.agreement_number as agreemen8_9_0_, agreementb1_.create_date as create_d9_9_0_, agreementb1_.edit_reason as edit_re10_9_0_, agreementb1_.edit_reason_id as edit_re11_9_0_, agreementb1_.editor_employee_id as editor_12_9_0_, agreementb1_.editor_organization_id as editor_13_9_0_, agreementb1_.editor_organization_version_id as editor_14_9_0_, agreementb1_.from_credit_road as from_cr15_9_0_, agreementb1_.locked as locked16_9_0_, agreementb1_.on_paper as on_pape17_9_0_, agreementb1_.organization_id as organiz18_9_0_, agreementb1_.organization_version_id as organiz19_9_0_, agreementb1_.rejected_employee_root_id as rejecte20_9_0_, agreementb1_.status_root_id as status_21_9_0_, agreementb1_.system_number as system_22_9_0_, agreementb1_.version_number as version23_9_0_, agreementb1_.accompanied_contract as accompa24_9_0_, agreementb1_.accounting_type_id as account25_9_0_, agreementb1_.additional_info as additio26_9_0_, agreementb1_.controlled_cooperation_level_id as control27_9_0_, agreementb1_.need_change_status_to_sba as need_ch28_9_0_, agreementb1_.project_management_root_id as project29_9_0_, agreementb1_.readiness_compliant as readine30_9_0_, agreementb1_.responsible_employee as respons31_9_0_, participan2_.agreement_id as agreemen8_31_4_, participan2_.id as id1_31_4_, participan2_.id as id1_31_1_, participan2_.last_editing_date as last_edi2_31_1_, participan2_.agreement_id as agreemen8_31_1_, participan2_.bank_details_id as bank_det3_31_1_, participan2_.fund_subject as fund_sub4_31_1_, participan2_.organization_version_id as organiza5_31_1_, participan2_.organization_id as organiza6_31_1_, participan2_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_agreement_bs_type agreementb0_ inner join bagrsm.bagr_agreement agreementb1_ on agreementb0_.agreement_id=agreementb1_.id left outer join bagrsm.bagr_participant participan2_ on agreementb1_.id=participan2_.agreement_id where agreementb0_.agreement_id=?
  118. 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=?
  119. 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=?
  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 nsieditinf0_.id as id1_106_, nsieditinf0_.actual as actual2_106_, nsieditinf0_.create_date as create_d3_106_, nsieditinf0_.deleted as deleted4_106_, nsieditinf0_.inner_code as inner_co5_106_, nsieditinf0_.last_editing_date as last_edi6_106_, nsieditinf0_.root_id as root_id7_106_, nsieditinf0_.sort_order as sort_ord8_106_, nsieditinf0_.value as value9_106_, nsieditinf0_.version_number as version10_106_, nsieditinf0_.added_manually as added_m11_106_, nsieditinf0_.additional_agreement_required as additio12_106_, nsieditinf0_.displayed_to_bank as display13_106_, nsieditinf0_.displayed_to_client as display14_106_ from nsism.nsi_edit_info_reason nsieditinf0_ where nsieditinf0_.id in (2) order by nsieditinf0_.sort_order asc
  122. 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
  123. Hibernate: select agreementb0_.id as id1_15_2_, agreementb0_.last_editing_date as last_edi2_15_2_, agreementb0_.agreement_id as agreemen5_15_2_, agreementb0_.agreement_bs_type_id as agreemen3_15_2_, agreementb0_.agreement_bs_type_root_id as agreemen4_15_2_, agreementb1_.id as id2_9_0_, agreementb1_.last_editing_date as last_edi3_9_0_, agreementb1_.root_id as root_id4_9_0_, agreementb1_.accepted as accepted5_9_0_, agreementb1_.actual as actual6_9_0_, agreementb1_.agreement_date as agreemen7_9_0_, agreementb1_.agreement_number as agreemen8_9_0_, agreementb1_.create_date as create_d9_9_0_, agreementb1_.edit_reason as edit_re10_9_0_, agreementb1_.edit_reason_id as edit_re11_9_0_, agreementb1_.editor_employee_id as editor_12_9_0_, agreementb1_.editor_organization_id as editor_13_9_0_, agreementb1_.editor_organization_version_id as editor_14_9_0_, agreementb1_.from_credit_road as from_cr15_9_0_, agreementb1_.locked as locked16_9_0_, agreementb1_.on_paper as on_pape17_9_0_, agreementb1_.organization_id as organiz18_9_0_, agreementb1_.organization_version_id as organiz19_9_0_, agreementb1_.rejected_employee_root_id as rejecte20_9_0_, agreementb1_.status_root_id as status_21_9_0_, agreementb1_.system_number as system_22_9_0_, agreementb1_.version_number as version23_9_0_, agreementb1_.accompanied_contract as accompa24_9_0_, agreementb1_.accounting_type_id as account25_9_0_, agreementb1_.additional_info as additio26_9_0_, agreementb1_.controlled_cooperation_level_id as control27_9_0_, agreementb1_.need_change_status_to_sba as need_ch28_9_0_, agreementb1_.project_management_root_id as project29_9_0_, agreementb1_.readiness_compliant as readine30_9_0_, agreementb1_.responsible_employee as respons31_9_0_, participan2_.agreement_id as agreemen8_31_4_, participan2_.id as id1_31_4_, participan2_.id as id1_31_1_, participan2_.last_editing_date as last_edi2_31_1_, participan2_.agreement_id as agreemen8_31_1_, participan2_.bank_details_id as bank_det3_31_1_, participan2_.fund_subject as fund_sub4_31_1_, participan2_.organization_version_id as organiza5_31_1_, participan2_.organization_id as organiza6_31_1_, participan2_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_agreement_bs_type agreementb0_ inner join bagrsm.bagr_agreement agreementb1_ on agreementb0_.agreement_id=agreementb1_.id left outer join bagrsm.bagr_participant participan2_ on agreementb1_.id=participan2_.agreement_id where agreementb0_.agreement_id=?
  124. Hibernate: select nsifileatt0_.id as id1_118_, nsifileatt0_.actual as actual2_118_, nsifileatt0_.create_date as create_d3_118_, nsifileatt0_.deleted as deleted4_118_, nsifileatt0_.inner_code as inner_co5_118_, nsifileatt0_.last_editing_date as last_edi6_118_, nsifileatt0_.root_id as root_id7_118_, nsifileatt0_.sort_order as sort_ord8_118_, nsifileatt0_.value as value9_118_, nsifileatt0_.version_number as version10_118_, nsifileatt0_.added_manually as added_m11_118_, nsifileatt0_.allowed_only_pdf as allowed12_118_, nsifileatt0_.attachment_required as attachm13_118_ from nsism.nsi_file_attachment_type nsifileatt0_ where nsifileatt0_.id in (48 , 45) order by nsifileatt0_.sort_order asc
  125. 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=?
  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 agreementb0_.id as id1_15_2_, agreementb0_.last_editing_date as last_edi2_15_2_, agreementb0_.agreement_id as agreemen5_15_2_, agreementb0_.agreement_bs_type_id as agreemen3_15_2_, agreementb0_.agreement_bs_type_root_id as agreemen4_15_2_, agreementb1_.id as id2_9_0_, agreementb1_.last_editing_date as last_edi3_9_0_, agreementb1_.root_id as root_id4_9_0_, agreementb1_.accepted as accepted5_9_0_, agreementb1_.actual as actual6_9_0_, agreementb1_.agreement_date as agreemen7_9_0_, agreementb1_.agreement_number as agreemen8_9_0_, agreementb1_.create_date as create_d9_9_0_, agreementb1_.edit_reason as edit_re10_9_0_, agreementb1_.edit_reason_id as edit_re11_9_0_, agreementb1_.editor_employee_id as editor_12_9_0_, agreementb1_.editor_organization_id as editor_13_9_0_, agreementb1_.editor_organization_version_id as editor_14_9_0_, agreementb1_.from_credit_road as from_cr15_9_0_, agreementb1_.locked as locked16_9_0_, agreementb1_.on_paper as on_pape17_9_0_, agreementb1_.organization_id as organiz18_9_0_, agreementb1_.organization_version_id as organiz19_9_0_, agreementb1_.rejected_employee_root_id as rejecte20_9_0_, agreementb1_.status_root_id as status_21_9_0_, agreementb1_.system_number as system_22_9_0_, agreementb1_.version_number as version23_9_0_, agreementb1_.accompanied_contract as accompa24_9_0_, agreementb1_.accounting_type_id as account25_9_0_, agreementb1_.additional_info as additio26_9_0_, agreementb1_.controlled_cooperation_level_id as control27_9_0_, agreementb1_.need_change_status_to_sba as need_ch28_9_0_, agreementb1_.project_management_root_id as project29_9_0_, agreementb1_.readiness_compliant as readine30_9_0_, agreementb1_.responsible_employee as respons31_9_0_, participan2_.agreement_id as agreemen8_31_4_, participan2_.id as id1_31_4_, participan2_.id as id1_31_1_, participan2_.last_editing_date as last_edi2_31_1_, participan2_.agreement_id as agreemen8_31_1_, participan2_.bank_details_id as bank_det3_31_1_, participan2_.fund_subject as fund_sub4_31_1_, participan2_.organization_version_id as organiza5_31_1_, participan2_.organization_id as organiza6_31_1_, participan2_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_agreement_bs_type agreementb0_ inner join bagrsm.bagr_agreement agreementb1_ on agreementb0_.agreement_id=agreementb1_.id left outer join bagrsm.bagr_participant participan2_ on agreementb1_.id=participan2_.agreement_id where agreementb0_.agreement_id=?
  128. 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=?
  129. Hibernate: select nsidevelop0_.id as id1_104_, nsidevelop0_.actual as actual2_104_, nsidevelop0_.create_date as create_d3_104_, nsidevelop0_.deleted as deleted4_104_, nsidevelop0_.inner_code as inner_co5_104_, nsidevelop0_.last_editing_date as last_edi6_104_, nsidevelop0_.root_id as root_id7_104_, nsidevelop0_.sort_order as sort_ord8_104_, nsidevelop0_.value as value9_104_, nsidevelop0_.version_number as version10_104_ from nsism.nsi_developer_settlement_system nsidevelop0_ where nsidevelop0_.id in (3) order by nsidevelop0_.sort_order asc
  130. 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
  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 nsicoopera0_.id as id1_100_, nsicoopera0_.actual as actual2_100_, nsicoopera0_.create_date as create_d3_100_, nsicoopera0_.deleted as deleted4_100_, nsicoopera0_.inner_code as inner_co5_100_, nsicoopera0_.last_editing_date as last_edi6_100_, nsicoopera0_.root_id as root_id7_100_, nsicoopera0_.sort_order as sort_ord8_100_, nsicoopera0_.value as value9_100_, nsicoopera0_.version_number as version10_100_ from nsism.nsi_cooperation_controlled_level nsicoopera0_ where nsicoopera0_.id in (7) order by nsicoopera0_.sort_order asc
  133. Hibernate: select agreementb0_.id as id1_15_2_, agreementb0_.last_editing_date as last_edi2_15_2_, agreementb0_.agreement_id as agreemen5_15_2_, agreementb0_.agreement_bs_type_id as agreemen3_15_2_, agreementb0_.agreement_bs_type_root_id as agreemen4_15_2_, agreementb1_.id as id2_9_0_, agreementb1_.last_editing_date as last_edi3_9_0_, agreementb1_.root_id as root_id4_9_0_, agreementb1_.accepted as accepted5_9_0_, agreementb1_.actual as actual6_9_0_, agreementb1_.agreement_date as agreemen7_9_0_, agreementb1_.agreement_number as agreemen8_9_0_, agreementb1_.create_date as create_d9_9_0_, agreementb1_.edit_reason as edit_re10_9_0_, agreementb1_.edit_reason_id as edit_re11_9_0_, agreementb1_.editor_employee_id as editor_12_9_0_, agreementb1_.editor_organization_id as editor_13_9_0_, agreementb1_.editor_organization_version_id as editor_14_9_0_, agreementb1_.from_credit_road as from_cr15_9_0_, agreementb1_.locked as locked16_9_0_, agreementb1_.on_paper as on_pape17_9_0_, agreementb1_.organization_id as organiz18_9_0_, agreementb1_.organization_version_id as organiz19_9_0_, agreementb1_.rejected_employee_root_id as rejecte20_9_0_, agreementb1_.status_root_id as status_21_9_0_, agreementb1_.system_number as system_22_9_0_, agreementb1_.version_number as version23_9_0_, agreementb1_.accompanied_contract as accompa24_9_0_, agreementb1_.accounting_type_id as account25_9_0_, agreementb1_.additional_info as additio26_9_0_, agreementb1_.controlled_cooperation_level_id as control27_9_0_, agreementb1_.need_change_status_to_sba as need_ch28_9_0_, agreementb1_.project_management_root_id as project29_9_0_, agreementb1_.readiness_compliant as readine30_9_0_, agreementb1_.responsible_employee as respons31_9_0_, participan2_.agreement_id as agreemen8_31_4_, participan2_.id as id1_31_4_, participan2_.id as id1_31_1_, participan2_.last_editing_date as last_edi2_31_1_, participan2_.agreement_id as agreemen8_31_1_, participan2_.bank_details_id as bank_det3_31_1_, participan2_.fund_subject as fund_sub4_31_1_, participan2_.organization_version_id as organiza5_31_1_, participan2_.organization_id as organiza6_31_1_, participan2_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_agreement_bs_type agreementb0_ inner join bagrsm.bagr_agreement agreementb1_ on agreementb0_.agreement_id=agreementb1_.id left outer join bagrsm.bagr_participant participan2_ on agreementb1_.id=participan2_.agreement_id where agreementb0_.agreement_id=?
  134. 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=?
  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 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=?
  137. Hibernate: select agreementb0_.id as id1_15_2_, agreementb0_.last_editing_date as last_edi2_15_2_, agreementb0_.agreement_id as agreemen5_15_2_, agreementb0_.agreement_bs_type_id as agreemen3_15_2_, agreementb0_.agreement_bs_type_root_id as agreemen4_15_2_, agreementb1_.id as id2_9_0_, agreementb1_.last_editing_date as last_edi3_9_0_, agreementb1_.root_id as root_id4_9_0_, agreementb1_.accepted as accepted5_9_0_, agreementb1_.actual as actual6_9_0_, agreementb1_.agreement_date as agreemen7_9_0_, agreementb1_.agreement_number as agreemen8_9_0_, agreementb1_.create_date as create_d9_9_0_, agreementb1_.edit_reason as edit_re10_9_0_, agreementb1_.edit_reason_id as edit_re11_9_0_, agreementb1_.editor_employee_id as editor_12_9_0_, agreementb1_.editor_organization_id as editor_13_9_0_, agreementb1_.editor_organization_version_id as editor_14_9_0_, agreementb1_.from_credit_road as from_cr15_9_0_, agreementb1_.locked as locked16_9_0_, agreementb1_.on_paper as on_pape17_9_0_, agreementb1_.organization_id as organiz18_9_0_, agreementb1_.organization_version_id as organiz19_9_0_, agreementb1_.rejected_employee_root_id as rejecte20_9_0_, agreementb1_.status_root_id as status_21_9_0_, agreementb1_.system_number as system_22_9_0_, agreementb1_.version_number as version23_9_0_, agreementb1_.accompanied_contract as accompa24_9_0_, agreementb1_.accounting_type_id as account25_9_0_, agreementb1_.additional_info as additio26_9_0_, agreementb1_.controlled_cooperation_level_id as control27_9_0_, agreementb1_.need_change_status_to_sba as need_ch28_9_0_, agreementb1_.project_management_root_id as project29_9_0_, agreementb1_.readiness_compliant as readine30_9_0_, agreementb1_.responsible_employee as respons31_9_0_, participan2_.agreement_id as agreemen8_31_4_, participan2_.id as id1_31_4_, participan2_.id as id1_31_1_, participan2_.last_editing_date as last_edi2_31_1_, participan2_.agreement_id as agreemen8_31_1_, participan2_.bank_details_id as bank_det3_31_1_, participan2_.fund_subject as fund_sub4_31_1_, participan2_.organization_version_id as organiza5_31_1_, participan2_.organization_id as organiza6_31_1_, participan2_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_agreement_bs_type agreementb0_ inner join bagrsm.bagr_agreement agreementb1_ on agreementb0_.agreement_id=agreementb1_.id left outer join bagrsm.bagr_participant participan2_ on agreementb1_.id=participan2_.agreement_id where agreementb0_.agreement_id=?
  138. Hibernate: select nsibanksup0_.id as id1_88_, nsibanksup0_.actual as actual2_88_, nsibanksup0_.create_date as create_d3_88_, nsibanksup0_.deleted as deleted4_88_, nsibanksup0_.inner_code as inner_co5_88_, nsibanksup0_.last_editing_date as last_edi6_88_, nsibanksup0_.root_id as root_id7_88_, nsibanksup0_.sort_order as sort_ord8_88_, nsibanksup0_.value as value9_88_, nsibanksup0_.version_number as version10_88_, nsibanksup0_.added_manually as added_m11_88_, nsibanksup0_.description as descrip12_88_ from nsism.nsi_bank_support_agreement_type nsibanksup0_ where nsibanksup0_.id in (1) order by nsibanksup0_.sort_order asc
  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 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=?
  141. Hibernate: select nsicommiss0_.id as id1_94_, nsicommiss0_.actual as actual2_94_, nsicommiss0_.create_date as create_d3_94_, nsicommiss0_.deleted as deleted4_94_, nsicommiss0_.inner_code as inner_co5_94_, nsicommiss0_.last_editing_date as last_edi6_94_, nsicommiss0_.root_id as root_id7_94_, nsicommiss0_.sort_order as sort_ord8_94_, nsicommiss0_.value as value9_94_, nsicommiss0_.version_number as version10_94_, nsicommiss0_.added_manually as added_m11_94_, nsicommiss0_.description as descrip12_94_ from nsism.nsi_commission_type nsicommiss0_ where nsicommiss0_.id in (23) order by nsicommiss0_.sort_order asc
  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 agreementb0_.id as id1_15_2_, agreementb0_.last_editing_date as last_edi2_15_2_, agreementb0_.agreement_id as agreemen5_15_2_, agreementb0_.agreement_bs_type_id as agreemen3_15_2_, agreementb0_.agreement_bs_type_root_id as agreemen4_15_2_, agreementb1_.id as id2_9_0_, agreementb1_.last_editing_date as last_edi3_9_0_, agreementb1_.root_id as root_id4_9_0_, agreementb1_.accepted as accepted5_9_0_, agreementb1_.actual as actual6_9_0_, agreementb1_.agreement_date as agreemen7_9_0_, agreementb1_.agreement_number as agreemen8_9_0_, agreementb1_.create_date as create_d9_9_0_, agreementb1_.edit_reason as edit_re10_9_0_, agreementb1_.edit_reason_id as edit_re11_9_0_, agreementb1_.editor_employee_id as editor_12_9_0_, agreementb1_.editor_organization_id as editor_13_9_0_, agreementb1_.editor_organization_version_id as editor_14_9_0_, agreementb1_.from_credit_road as from_cr15_9_0_, agreementb1_.locked as locked16_9_0_, agreementb1_.on_paper as on_pape17_9_0_, agreementb1_.organization_id as organiz18_9_0_, agreementb1_.organization_version_id as organiz19_9_0_, agreementb1_.rejected_employee_root_id as rejecte20_9_0_, agreementb1_.status_root_id as status_21_9_0_, agreementb1_.system_number as system_22_9_0_, agreementb1_.version_number as version23_9_0_, agreementb1_.accompanied_contract as accompa24_9_0_, agreementb1_.accounting_type_id as account25_9_0_, agreementb1_.additional_info as additio26_9_0_, agreementb1_.controlled_cooperation_level_id as control27_9_0_, agreementb1_.need_change_status_to_sba as need_ch28_9_0_, agreementb1_.project_management_root_id as project29_9_0_, agreementb1_.readiness_compliant as readine30_9_0_, agreementb1_.responsible_employee as respons31_9_0_, participan2_.agreement_id as agreemen8_31_4_, participan2_.id as id1_31_4_, participan2_.id as id1_31_1_, participan2_.last_editing_date as last_edi2_31_1_, participan2_.agreement_id as agreemen8_31_1_, participan2_.bank_details_id as bank_det3_31_1_, participan2_.fund_subject as fund_sub4_31_1_, participan2_.organization_version_id as organiza5_31_1_, participan2_.organization_id as organiza6_31_1_, participan2_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_agreement_bs_type agreementb0_ inner join bagrsm.bagr_agreement agreementb1_ on agreementb0_.agreement_id=agreementb1_.id left outer join bagrsm.bagr_participant participan2_ on agreementb1_.id=participan2_.agreement_id where agreementb0_.agreement_id=?
  144. 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=?
  145. Hibernate: select agreementb0_.agreement_id as agreeme17_12_0_, agreementb0_.id as id1_12_0_, agreementb0_.id as id1_12_1_, agreementb0_.last_editing_date as last_edi2_12_1_, agreementb0_.root_id as root_id3_12_1_, agreementb0_.agreement_id as agreeme17_12_1_, agreementb0_.create_date as create_d4_12_1_, agreementb0_.fund_code as fund_cod5_12_1_, agreementb0_.issue_date as issue_da6_12_1_, agreementb0_.object_address as object_a7_12_1_, agreementb0_.object_address_text as object_a8_12_1_, agreementb0_.object_eis_id as object_e9_12_1_, agreementb0_.object_name as object_10_12_1_, agreementb0_.object_number as object_11_12_1_, agreementb0_.project_cost as project12_12_1_, agreementb0_.project_id as project13_12_1_, agreementb0_.prolonged_to_date as prolong14_12_1_, agreementb0_.region_id as region_15_12_1_, agreementb0_.valid_to_date as valid_t16_12_1_ from bagrsm.bagr_agreement_bs_object agreementb0_ where agreementb0_.agreement_id=?
  146. Hibernate: select nsicommiss0_.id as id1_95_, nsicommiss0_.actual as actual2_95_, nsicommiss0_.create_date as create_d3_95_, nsicommiss0_.deleted as deleted4_95_, nsicommiss0_.inner_code as inner_co5_95_, nsicommiss0_.last_editing_date as last_edi6_95_, nsicommiss0_.root_id as root_id7_95_, nsicommiss0_.sort_order as sort_ord8_95_, nsicommiss0_.value as value9_95_, nsicommiss0_.version_number as version10_95_, nsicommiss0_.added_manually as added_m11_95_, nsicommiss0_.attribute_type_root_id as attribu12_95_, nsicommiss0_.default_bank_details_value_id as default13_95_, nsicommiss0_.default_date_value as default14_95_, nsicommiss0_.default_nsi_value_id as default15_95_, nsicommiss0_.default_nsi_value_root_id as default16_95_, nsicommiss0_.default_numeric_value as default17_95_, nsicommiss0_.default_text_value as default18_95_, nsicommiss0_.nsi_value_dic_root_id as nsi_val19_95_, nsicommiss0_.required as require20_95_, nsicommiss0_.commission_type_root_id as commiss21_95_, nsicommiss0_.default_date_end_value as default22_95_ from nsism.nsi_commission_type_attribute nsicommiss0_ where nsicommiss0_.id in (1 , 2 , 3 , 4 , 5 , 8 , 9 , 11 , 12 , 13) order by nsicommiss0_.sort_order asc
  147. 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
  148. Hibernate: select reportkind0_.agreement_id as agreemen1_14_0_, reportkind0_.report_kind_root_id as report_k2_14_0_ from bagrsm.bagr_agreement_bs_report_kind reportkind0_ where reportkind0_.agreement_id=?
  149. 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=?
  150. Hibernate: select coperforme0_.agreement_id as agreemen9_23_0_, coperforme0_.id as id1_23_0_, coperforme0_.id as id1_23_1_, coperforme0_.last_editing_date as last_edi2_23_1_, coperforme0_.additional_info as addition3_23_1_, coperforme0_.agreement_id as agreemen9_23_1_, coperforme0_.changed_manually as changed_4_23_1_, coperforme0_.cooperation_level as cooperat5_23_1_, coperforme0_.create_date as create_d6_23_1_, coperforme0_.organization_version_id as organiza7_23_1_, coperforme0_.organization_id as organiza8_23_1_ from bagrsm.bagr_co_performer coperforme0_ where coperforme0_.agreement_id=?
  151. Hibernate: select nsicommiss0_.id as id1_93_, nsicommiss0_.actual as actual2_93_, nsicommiss0_.create_date as create_d3_93_, nsicommiss0_.deleted as deleted4_93_, nsicommiss0_.inner_code as inner_co5_93_, nsicommiss0_.last_editing_date as last_edi6_93_, nsicommiss0_.root_id as root_id7_93_, nsicommiss0_.sort_order as sort_ord8_93_, nsicommiss0_.value as value9_93_, nsicommiss0_.version_number as version10_93_, nsicommiss0_.added_manually as added_m11_93_, nsicommiss0_.days_count as days_co12_93_ from nsism.nsi_commission_payment_option nsicommiss0_ where nsicommiss0_.id in (1) order by nsicommiss0_.sort_order asc
  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 agreementb0_.agreement_id as agreeme17_12_0_, agreementb0_.id as id1_12_0_, agreementb0_.id as id1_12_1_, agreementb0_.last_editing_date as last_edi2_12_1_, agreementb0_.root_id as root_id3_12_1_, agreementb0_.agreement_id as agreeme17_12_1_, agreementb0_.create_date as create_d4_12_1_, agreementb0_.fund_code as fund_cod5_12_1_, agreementb0_.issue_date as issue_da6_12_1_, agreementb0_.object_address as object_a7_12_1_, agreementb0_.object_address_text as object_a8_12_1_, agreementb0_.object_eis_id as object_e9_12_1_, agreementb0_.object_name as object_10_12_1_, agreementb0_.object_number as object_11_12_1_, agreementb0_.project_cost as project12_12_1_, agreementb0_.project_id as project13_12_1_, agreementb0_.prolonged_to_date as prolong14_12_1_, agreementb0_.region_id as region_15_12_1_, agreementb0_.valid_to_date as valid_t16_12_1_ from bagrsm.bagr_agreement_bs_object agreementb0_ where agreementb0_.agreement_id=?
  154. Hibernate: select reportkind0_.agreement_id as agreemen1_14_0_, reportkind0_.report_kind_root_id as report_k2_14_0_ from bagrsm.bagr_agreement_bs_report_kind reportkind0_ where reportkind0_.agreement_id=?
  155. Hibernate: select nsipayment0_.id as id1_146_, nsipayment0_.actual as actual2_146_, nsipayment0_.create_date as create_d3_146_, nsipayment0_.deleted as deleted4_146_, nsipayment0_.inner_code as inner_co5_146_, nsipayment0_.last_editing_date as last_edi6_146_, nsipayment0_.root_id as root_id7_146_, nsipayment0_.sort_order as sort_ord8_146_, nsipayment0_.value as value9_146_, nsipayment0_.version_number as version10_146_, nsipayment0_.code_letter as code_le11_146_ from nsism.nsi_payment_type nsipayment0_ where nsipayment0_.id in (1) order by nsipayment0_.sort_order asc
  156. 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
  157.     December 17th 2020, 16:24:25.544    2020-12-17 14:24:25.543 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [lTaskExecutor-2] r.l.r.b.i.b.info.AgreementBsServiceImpl  : Found 10 bank support agreements
  158. 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
  159.     December 17th 2020, 16:24:25.545    2020-12-17 14:24:25.545 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [lTaskExecutor-2] r.l.r.r.impl.helper.ReportRequestHelper  : Trace-A_O_2: performerOrgRootIds=[], isOnline2and4Only=false    backend develop-dev-roscap
  160.     December 17th 2020, 16:24:25.545    2020-12-17 14:24:25.545 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [lTaskExecutor-2] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: case: REPORT_6 backend develop-dev-roscap
  161.     December 17th 2020, 16:24:25.545    2020-12-17 14:24:25.545 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [lTaskExecutor-2] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: case: REPORT_4 backend develop-dev-roscap
  162. December 17th 2020, 16:24:25.545    2020-12-17 14:24:25.545 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [lTaskExecutor-2] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: aDbs77.run() aDbs77Response = {"data":{"11028":[]}}    backend develop-dev-roscap
  163.     December 17th 2020, 16:24:25.545    2020-12-17 14:24:25.545 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [lTaskExecutor-2] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: case: REPORT_3 backend develop-dev-roscap
  164.     December 17th 2020, 16:24:25.545    2020-12-17 14:24:25.545 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [lTaskExecutor-2] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: case: REPORT_5 backend develop-dev-roscap
  165.     December 17th 2020, 16:24:25.545    2020-12-17 14:24:25.545 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [lTaskExecutor-2] r.l.r.r.impl.helper.ReportRequestHelper  : Creating dateSearchCriteria for A_PD_* algorithm; period='startDate=2020-11-23, endDate=2020-12-17'
  166. 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
  167.     December 17th 2020, 16:24:25.545    2020-12-17 14:24:25.545 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [lTaskExecutor-2] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: case: REPORT_2 backend develop-dev-roscap
  168.     December 17th 2020, 16:24:25.546    2020-12-17 14:24:25.546 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [lTaskExecutor-2] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: A_PD_59 params = {"agreementBsRootId":11028,"agreementBsObjectRootIds":[1008],"paymentOrderReportSearchDate":{"datePeriod":{"startDate":{"year":2020,"month":11,"day":23},"endDate":{"year":2020,"month":12,"day":17}}}}
  169. 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
  170. 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=?
  171. Hibernate: select nsipayment0_.id as id1_140_, nsipayment0_.actual as actual2_140_, nsipayment0_.create_date as create_d3_140_, nsipayment0_.deleted as deleted4_140_, nsipayment0_.inner_code as inner_co5_140_, nsipayment0_.last_editing_date as last_edi6_140_, nsipayment0_.root_id as root_id7_140_, nsipayment0_.sort_order as sort_ord8_140_, nsipayment0_.value as value9_140_, nsipayment0_.version_number as version10_140_ from nsism.nsi_payment_operation_type nsipayment0_ where nsipayment0_.value=? and nsipayment0_.actual=? order by nsipayment0_.sort_order asc
  172. 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=?
  173. 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=?
  174. 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=?
  175. Hibernate: select paymentord0_.id as id1_201_, paymentord0_.last_editing_date as last_edi2_201_, paymentord0_.actual as actual3_201_, paymentord0_.actual_by_business as actual_b4_201_, paymentord0_.bagr_agreement_bs_id as bagr_agr5_201_, paymentord0_.bagr_agreement_bs_object_id as bagr_agr6_201_, paymentord0_.bagr_agreement_bs_object_root_id as bagr_agr7_201_, paymentord0_.bagr_agreement_sba_object_id as bagr_agr8_201_, paymentord0_.amount as amount9_201_, paymentord0_.amount_with_vat as amount_10_201_, paymentord0_.analytics_filled as analyti11_201_, paymentord0_.budget_version_id as budget_12_201_, paymentord0_.budgetary_payment as budgeta13_201_, paymentord0_.budgetary_payment_document_number as budgeta14_201_, paymentord0_.cagr_agreement_id as cagr_ag15_201_, paymentord0_.cagr_agreement_root_id as cagr_ag16_201_, paymentord0_.code as code17_201_, paymentord0_.create_date as create_18_201_, paymentord0_.create_date_month as create_19_201_, paymentord0_.create_date_year as create_20_201_, paymentord0_.creator_organization_id as creator21_201_, paymentord0_.creator_organization_root_id as creator22_201_, paymentord0_.currency_id as currenc23_201_, paymentord0_.currency_root_id as currenc24_201_, paymentord0_.currency_transaction_type_code_id as currenc25_201_, paymentord0_.currency_transaction_type_code_root_id as currenc26_201_, paymentord0_.customs_code as customs27_201_, paymentord0_.editor_employee_root_id as editor_28_201_, paymentord0_.editor_organization_id as editor_29_201_, paymentord0_.editor_organization_root_id as editor_30_201_, paymentord0_.electronic_document_id_1c as electro31_201_, paymentord0_.employee_root_id_sent_to_signing as employe32_201_, paymentord0_.employee_root_id_signed as employe33_201_, paymentord0_.extended_day as extende34_201_, paymentord0_.group_operation_id as group_o35_201_, paymentord0_.import_file_id as import_36_201_, paymentord0_.import_id as import_37_201_, paymentord0_.income_type_code_id as income_38_201_, paymentord0_.income_type_code_root_id as income_39_201_, paymentord0_.individual_information_id as individ40_201_, paymentord0_.information_source_id as informa41_201_, paymentord0_.information_source_root_id as informa42_201_, paymentord0_.kbk as kbk43_201_, paymentord0_.law_214_operation as law_44_201_, paymentord0_.law_214_operation_type_root_id as law_45_201_, paymentord0_.limit_absence as limit_a46_201_, paymentord0_.locked as locked47_201_, paymentord0_.new_athena_payment_order_id as new_ath48_201_, paymentord0_.not_show_payment_cause_document_date as not_sho49_201_, paymentord0_.oktmo as oktmo50_201_, paymentord0_.operation_type_id as operati51_201_, paymentord0_.operation_type_root_id as operati52_201_, paymentord0_.parent_na_id as parent_53_201_, paymentord0_.parent_payment_order_version_id as parent_54_201_, paymentord0_.payer_status_id as payer_s55_201_, paymentord0_.payer_status_root_id as payer_s56_201_, paymentord0_.payment_by_cagr_agreement as payment57_201_, paymentord0_.payment_cause_document_date as payment58_201_, paymentord0_.payment_cause_id as payment59_201_, paymentord0_.payment_cause_root_id as payment60_201_, paymentord0_.payment_form_id as payment61_201_, paymentord0_.payment_form_root_id as payment62_201_, paymentord0_.payment_order_id as payment96_201_, paymentord0_.payment_order_create_date as payment63_201_, paymentord0_.payment_order_number as payment64_201_, paymentord0_.payment_priority_id as payment65_201_, paymentord0_.payment_priority_root_id as payment66_201_, paymentord0_.payment_purpose as payment67_201_, paymentord0_.payment_purpose_code as payment68_201_, paymentord0_.payment_term as payment69_201_, paymentord0_.payment_type_id as payment70_201_, paymentord0_.payment_type_root_id as payment71_201_, paymentord0_.payment_with_funds_received_by_agreement as payment72_201_, paymentord0_.period_id as period_73_201_, paymentord0_.period_root_id as period_74_201_, paymentord0_.refund_payment_order_version_id as refund_75_201_, paymentord0_.requisites_clarification as requisi76_201_, paymentord0_.requisites_clarification_number as requisi77_201_, paymentord0_.reserve_field as reserve78_201_, paymentord0_.sent_to_clarification as sent_to79_201_, paymentord0_.sent_to_eiszhs as sent_to80_201_, paymentord0_.sent_to_eiszhs_id as sent_to81_201_, paymentord0_.status_root_id as status_82_201_, paymentord0_.system_number as system_83_201_, paymentord0_.tax_period_date as tax_per84_201_, paymentord0_.tax_period_id as tax_per85_201_, paymentord0_.tax_period_indicator_id as tax_per86_201_, paymentord0_.tax_period_indicator_root_id as tax_per87_201_, paymentord0_.tax_period_root_id as tax_per88_201_, paymentord0_.tax_period_year as tax_per89_201_, paymentord0_.vat_amount as vat_amo90_201_, paymentord0_.vat_rate_id as vat_rat91_201_, paymentord0_.vat_rate_root_id as vat_rat92_201_, paymentord0_.vat_type_id as vat_typ93_201_, paymentord0_.vat_type_root_id as vat_typ94_201_, paymentord0_.version_number as version95_201_ from posm.po_payment_order_version paymentord0_ cross join posm.po_payment_order_system_data paymentord1_ where paymentord0_.id=paymentord1_.payment_order_version_id and (paymentord0_.status_root_id in (? , ?)) and (paymentord0_.status_root_id=? and paymentord1_.payment_order_discard_date<=? and paymentord1_.payment_order_discard_date>=? or paymentord0_.status_root_id=? and paymentord0_.last_editing_date<=? and paymentord0_.last_editing_date>=?) and paymentord0_.operation_type_root_id=? and paymentord0_.bagr_agreement_bs_object_root_id=?
  176. 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
  177. Hibernate: select agreementb0_.id as id1_15_2_, agreementb0_.last_editing_date as last_edi2_15_2_, agreementb0_.agreement_id as agreemen5_15_2_, agreementb0_.agreement_bs_type_id as agreemen3_15_2_, agreementb0_.agreement_bs_type_root_id as agreemen4_15_2_, agreementb1_.id as id2_9_0_, agreementb1_.last_editing_date as last_edi3_9_0_, agreementb1_.root_id as root_id4_9_0_, agreementb1_.accepted as accepted5_9_0_, agreementb1_.actual as actual6_9_0_, agreementb1_.agreement_date as agreemen7_9_0_, agreementb1_.agreement_number as agreemen8_9_0_, agreementb1_.create_date as create_d9_9_0_, agreementb1_.edit_reason as edit_re10_9_0_, agreementb1_.edit_reason_id as edit_re11_9_0_, agreementb1_.editor_employee_id as editor_12_9_0_, agreementb1_.editor_organization_id as editor_13_9_0_, agreementb1_.editor_organization_version_id as editor_14_9_0_, agreementb1_.from_credit_road as from_cr15_9_0_, agreementb1_.locked as locked16_9_0_, agreementb1_.on_paper as on_pape17_9_0_, agreementb1_.organization_id as organiz18_9_0_, agreementb1_.organization_version_id as organiz19_9_0_, agreementb1_.rejected_employee_root_id as rejecte20_9_0_, agreementb1_.status_root_id as status_21_9_0_, agreementb1_.system_number as system_22_9_0_, agreementb1_.version_number as version23_9_0_, agreementb1_.accompanied_contract as accompa24_9_0_, agreementb1_.accounting_type_id as account25_9_0_, agreementb1_.additional_info as additio26_9_0_, agreementb1_.controlled_cooperation_level_id as control27_9_0_, agreementb1_.need_change_status_to_sba as need_ch28_9_0_, agreementb1_.project_management_root_id as project29_9_0_, agreementb1_.readiness_compliant as readine30_9_0_, agreementb1_.responsible_employee as respons31_9_0_, participan2_.agreement_id as agreemen8_31_4_, participan2_.id as id1_31_4_, participan2_.id as id1_31_1_, participan2_.last_editing_date as last_edi2_31_1_, participan2_.agreement_id as agreemen8_31_1_, participan2_.bank_details_id as bank_det3_31_1_, participan2_.fund_subject as fund_sub4_31_1_, participan2_.organization_version_id as organiza5_31_1_, participan2_.organization_id as organiza6_31_1_, participan2_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_agreement_bs_type agreementb0_ inner join bagrsm.bagr_agreement agreementb1_ on agreementb0_.agreement_id=agreementb1_.id left outer join bagrsm.bagr_participant participan2_ on agreementb1_.id=participan2_.agreement_id where agreementb0_.agreement_id=?
  178. 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
  179.     December 17th 2020, 16:24:25.594    2020-12-17 14:24:25.594 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [lTaskExecutor-2] r.l.r.p.impl.service.algorithm.A_PD_59   : Method executed in 47 milliseconds
  180. 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
  181.     December 17th 2020, 16:24:25.605    2020-12-17 14:24:25.605 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [lTaskExecutor-2] r.l.r.report.impl.algorithm.ReportA_O_2  : A_O_2: reports data collection completed    backend develop-dev-roscap
  182.     December 17th 2020, 16:24:25.605    2020-12-17 14:24:25.605  INFO 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [lTaskExecutor-2] r.l.r.r.impl.aspect.ExecutionTimeAspect  : ReportA_O_2.run Построение квартальных отчетов, выполнено за 387мс backend develop-dev-roscap
  183.     December 17th 2020, 16:24:25.605    2020-12-17 14:24:25.605 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [lTaskExecutor-2] r.l.r.report.impl.algorithm.ReportA_O_5  : Data isn't found for report agreementRootId=11028, agreementNumber=БС2020-11028, objectNumbers=[null], reportKinds=[REPORT_3, REPORT_4, REPORT_2, REPORT_6, REPORT_5]
  184. Hibernate: select signers0_.sign_block_id as sign_bl15_20_0_, signers0_.id as id1_20_0_, signers0_.id as id1_20_1_, signers0_.last_editing_date as last_edi2_20_1_, signers0_.cert_finish_date as cert_fin3_20_1_, signers0_.cert_id as cert_id4_20_1_, signers0_.cert_serial_number as cert_ser5_20_1_, signers0_.cert_start_date as cert_sta6_20_1_, signers0_.emp_id as emp_id7_20_1_, signers0_.emp_root_id as emp_root8_20_1_, signers0_.org_id as org_id9_20_1_, signers0_.org_root_id as org_roo10_20_1_, signers0_.owner_name as owner_n11_20_1_, signers0_.position as positio12_20_1_, signers0_.sign_block_id as sign_bl15_20_1_, signers0_.sign_date as sign_da13_20_1_, signers0_.type_id as type_id14_20_1_ from bagrsm.bagr_agreement_signer signers0_ where signers0_.sign_block_id=?
  185. 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=?
  186. 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=?
  187. 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
  188. Hibernate: insert into bagrsm.bagr_agreement_signer (last_editing_date, cert_finish_date, cert_id, cert_serial_number, cert_start_date, emp_id, emp_root_id, org_id, org_root_id, owner_name, position, sign_block_id, sign_date, type_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)    backend develop-dev-roscap
  189.     December 17th 2020, 16:24:25.605    2020-12-17 14:24:25.605 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [lTaskExecutor-2] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: A_PD_59 aPd59Result = {"successType":"TYPE_2"} backend develop-dev-roscap
  190.     December 17th 2020, 16:24:25.639    2020-12-17 14:24:25.639  INFO 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [lTaskExecutor-2] r.l.r.r.impl.aspect.ExecutionTimeAspect  : ReportA_O_5.run Формирование онлайн отчета (А_О_5), выполнено за 526мс
  191. 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=?
  192. 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=?
  193. 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
  194. 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=?
  195. 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=?
  196. Hibernate: select filemetada0_.id as id1_72_, filemetada0_.blob_id as blob_id2_72_, filemetada0_.blob_url as blob_url3_72_, filemetada0_.context as context4_72_, filemetada0_.create_date as create_d5_72_, filemetada0_.document_date as document6_72_, filemetada0_.document_number as document7_72_, filemetada0_.document_status_root_id as document8_72_, filemetada0_.document_type_code as document9_72_, filemetada0_.document_type_id as documen10_72_, filemetada0_.entity_id as entity_11_72_, filemetada0_.entity_type as entity_12_72_, filemetada0_.hash as hash13_72_, filemetada0_.hidden as hidden14_72_, filemetada0_.last_editing_date as last_ed15_72_, filemetada0_.linked_sign_object as linked_16_72_, filemetada0_.name as name17_72_, filemetada0_.signed_by_one_party as signed_18_72_, filemetada0_.size as size19_72_, filemetada0_.status as status20_72_, filemetada0_.user_root_id as user_ro21_72_, filemetada0_.visible_to_client as visible22_72_ from fssm.fs_file filemetada0_ where filemetada0_.entity_type=? and filemetada0_.entity_id=?
  197. 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
  198. 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
  199.     December 17th 2020, 16:24:27.828    2020-12-17 14:24:27.828 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.security.web.FilterChainProxy        : /api/bs-agreements/11690/operations?pageNumber=0&pageSize=SIZE_100&agreementBsId=11690&operationTypeRootId=1 at position 2 of 15 in additional filter chain; firing Filter: 'SecurityContextPersistenceFilter'  backend develop-dev-roscap
  200.     December 17th 2020, 16:24:27.828    2020-12-17 14:24:27.827 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.security.web.FilterChainProxy        : /api/bs-agreements/11690/operations?pageNumber=0&pageSize=SIZE_100&agreementBsId=11690&operationTypeRootId=1 at position 1 of 15 in additional filter chain; firing Filter: 'WebAsyncManagerIntegrationFilter'  backend develop-dev-roscap
  201.     December 17th 2020, 16:24:27.831    2020-12-17 14:24:27.831 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.security.web.FilterChainProxy        : /api/bs-agreements/11690/operations?pageNumber=0&pageSize=SIZE_100&agreementBsId=11690&operationTypeRootId=1 at position 3 of 15 in additional filter chain; firing Filter: 'HeaderWriterFilter'    backend develop-dev-roscap
  202.     December 17th 2020, 16:24:27.831    2020-12-17 14:24:27.831 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] w.c.HttpSessionSecurityContextRepository : Obtained a valid SecurityContext from SPRING_SECURITY_CONTEXT: 'org.springframework.security.core.context.SecurityContextImpl@a1803ace: Authentication: ru.lanit.rbs.authapi.dto.UserAuthentication@a1803ace: Principal: ru.lanit.rbs.authapi.dto.ppa.PpaUserData@5e7fc50a; Credentials: [PROTECTED]; Authenticated: true; Details: null; Not granted any authorities'  backend develop-dev-roscap
  203.     December 17th 2020, 16:24:27.832    2020-12-17 14:24:27.831 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.security.web.FilterChainProxy        : /api/bs-agreements/11690/operations?pageNumber=0&pageSize=SIZE_100&agreementBsId=11690&operationTypeRootId=1 at position 4 of 15 in additional filter chain; firing Filter: 'CsrfFilter'    backend develop-dev-roscap
  204.     December 17th 2020, 16:24:27.832    2020-12-17 14:24:27.831 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.security.web.FilterChainProxy        : /api/bs-agreements/11690/operations?pageNumber=0&pageSize=SIZE_100&agreementBsId=11690&operationTypeRootId=1 at position 5 of 15 in additional filter chain; firing Filter: 'LogoutFilter'  backend develop-dev-roscap
  205.     December 17th 2020, 16:24:27.832    2020-12-17 14:24:27.831 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.u.matcher.AntPathRequestMatcher  : Request 'GET /api/bs-agreements/11690/operations' doesn't match 'POST /logout'
  206. Hibernate: select applicable0_.edit_info_reason_id as edit_inf1_107_0_, applicable0_.entity_type_root_id as entity_t2_107_0_ from nsism.nsi_edit_info_reason_entity_type applicable0_ where applicable0_.edit_info_reason_id=?  backend develop-dev-roscap
  207.     December 17th 2020, 16:24:27.832    2020-12-17 14:24:27.831 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.util.matcher.AndRequestMatcher   : Trying to match using org.springframework.security.web.csrf.CsrfFilter$DefaultRequiresCsrfMatcher@759e29c9  backend develop-dev-roscap
  208.     December 17th 2020, 16:24:27.832    2020-12-17 14:24:27.831 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.s.w.util.matcher.AndRequestMatcher   : Did not match   backend develop-dev-roscap
  209.     December 17th 2020, 16:24:27.832    2020-12-17 14:24:27.831 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.security.web.FilterChainProxy        : /api/bs-agreements/11690/operations?pageNumber=0&pageSize=SIZE_100&agreementBsId=11690&operationTypeRootId=1 at position 6 of 15 in additional filter chain; firing Filter: 'SessionAuthenticationFilter'   backend develop-dev-roscap
  210.     December 17th 2020, 16:24:27.832    2020-12-17 14:24:27.831 DEBUG 1 [25ae27af-1cf0-4e71-9878-4388c42a8731] --- [io-8080-exec-14] o.s.security.web.FilterChainProxy        : /api/bs-agreements/11690/operations?pageNumber=0&pageSize=SIZE_100&agreementBsId=11690&operationTypeRootId=1 at position 7 of 15 in additional filter chain; firing Filter: 'RequestDataFilter' 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!