API tools faq
paste
Advertisement
DOS93

Untitled

DOS93
Dec 18th, 2020
230
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Apache Log 193.08 KB | None | 0 0
raw download clone embed print report
  1.     December 17th 2020, 16:30:45.099    2020-12-17 14:30:45.099 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [io-8080-exec-25] r.l.r.b.i.b.info.AgreementBsServiceImpl  : Found 2 bank support agreements
  2. 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  backend develop-dev-roscap
  3.     December 17th 2020, 16:30:45.100    2020-12-17 14:30:45.100 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [lTaskExecutor-3] r.l.r.report.impl.algorithm.ReportA_O_5  : A_O_5: Start creating online reports, agreementId=11016
  4. 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=?)
  5. 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=?)
  6. 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=?
  7. 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=?
  8. 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=?
  9. 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=?
  10. 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
  11. 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
  12.     December 17th 2020, 16:30:45.117    2020-12-17 14:30:45.116 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [io-8080-exec-25] 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  backend develop-dev-roscap
  13.     December 17th 2020, 16:30:45.121    2020-12-17 14:30:45.121 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [io-8080-exec-25] s.s.w.c.SecurityContextPersistenceFilter : SecurityContextHolder now cleared, as request processing completed
  14. 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=?
  15. 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
  16. 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=?
  17. 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=?
  18. 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
  19. 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=?
  20. 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
  21.     December 17th 2020, 16:30:45.121    2020-12-17 14:30:45.121 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [io-8080-exec-25] o.s.s.w.a.ExceptionTranslationFilter     : Chain processed normally    backend develop-dev-roscap
  22.     December 17th 2020, 16:30:45.186    2020-12-17 14:30:45.186 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [lTaskExecutor-3] r.l.r.report.impl.algorithm.ReportA_O_2  : A_O_2: Start generating quarterly report data, reportPeriod=startDate=2020-11-24, endDate=2020-12-17, isOnline=true
  23. 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
  24.     December 17th 2020, 16:30:45.199    2020-12-17 14:30:45.198 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [lTaskExecutor-3] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: aDbs77.run() params = ([11016], 2020-12-17)
  25. 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)<=?  backend develop-dev-roscap
  26.     December 17th 2020, 16:30:45.199    2020-12-17 14:30:45.198 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [lTaskExecutor-3] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: agreement = {"rootId":11016,"customerOrgRootId":25,"performerOrgRootIds":[],"accompaniedContract":"БС2020-АК1","objects":[{"rootId":997,"objectAddress":"г. Москва, Ботаническая 24","objectName":"ЖК РЕЖИССЕР","objectNumber":"А-1231","issueDate":{"year":2020,"month":11,"day":8},"projectId":"87668767","id":1023,"lastEditingDate":{"dateTime":{"date":{"year":2020,"month":11,"day":24},"time":{"hour":12,"minute":9,"second":35,"nano":903845000}},"offset":{"totalSeconds":10800}}},{"rootId":995,"objectAddress":"г. Москва, Ботаническая 20","objectName":"ЖК РЕЖИССЕР","objectNumber":"А-1231","issueDate":{"year":2020,"month":11,"day":8},"projectId":"87668767","id":1021,"lastEditingDate":{"dateTime":{"date":{"year":2020,"month":11,"day":24},"time":{"hour":12,"minute":9,"second":35,"nano":897998000}},"offset":{"totalSeconds":10800}}},{"rootId":999,"objectAddress":"г. Москва, Ботаническая 22","objectName":"ЖК РЕЖИССЕР","objectNumber":"А-1231","issueDate":{"year":2020,"month":11,"day":8},"projectId":"87668767","id":1025,"lastEditingDate":{"dateTime":{"date":{"year":2020,"month":11,"day":24},"time":{"hour":12,"minute":9,"second":35,"nano":908976000}},"offset":{"totalSeconds":10800}}},{"rootId":994,"objectAddress":"г. Москва, Ботаническая 21","objectName":"ЖК РЕЖИССЕР","objectNumber":"А-1231","issueDate":{"year":2020,"month":11,"day":8},"projectId":"87668767","id":1020,"lastEditingDate":{"dateTime":{"date":{"year":2020,"month":11,"day":24},"time":{"hour":12,"minute":9,"second":35,"nano":895111000}},"offset":{"totalSeconds":10800}}},{"rootId":998,"objectAddress":"г. Москва, Ботаническая 16","objectName":"ЖК РЕЖИССЕР","objectNumber":"А-1231","issueDate":{"year":2020,"month":11,"day":8},"projectId":"87668767","id":1024,"lastEditingDate":{"dateTime":{"date":{"year":2020,"month":11,"day":24},"time":{"hour":12,"minute":9,"second":35,"nano":906567000}},"offset":{"totalSeconds":10800}}},{"rootId":996,"objectAddress":"г. Москва, Ботаническая 15","objectName":"ЖК РЕЖИССЕР","objectNumber":"А-1231","issueDate":{"year":2020,"month":11,"day":8},"projectId":"87668767","id":1022,"lastEditingDate":{"dateTime":{"date":{"year":2020,"month":11,"day":24},"time":{"hour":12,"minute":9,"second":35,"nano":901010000}},"offset":{"totalSeconds":10800}}}],"quarterlyReportPeriod":{"startDate":{"year":2020,"month":11,"day":24},"endDate":{"year":2020,"month":12,"day":17}},"agreementDate":{"year":2020,"month":11,"day":24},"reportKinds":["REPORT_4"]}   backend develop-dev-roscap
  27.     December 17th 2020, 16:30:45.518    2020-12-17 14:30:45.518 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [lTaskExecutor-3] r.l.r.b.i.b.info.AgreementBsServiceImpl  : Found 2 bank support agreements backend develop-dev-roscap
  28.     December 17th 2020, 16:30:45.522    2020-12-17 14:30:45.522 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [lTaskExecutor-3] r.l.r.r.impl.helper.ReportRequestHelper  : Trace-A_O_2: performerOrgRootIds=[19, 20, 5, 6, 25], isOnline2and4Only=false
  29. Hibernate: select organizati0_.id as id1_223_, organizati0_.last_editing_date as last_edi2_223_, organizati0_.actual as actual3_223_, organizati0_.version_create_date as version_4_223_, organizati0_.version_number as version_5_223_, organizati0_.address as address6_223_, organizati0_.agency_territory as agency_t7_223_, organizati0_.agency_type as agency_t8_223_, organizati0_.is_branch as is_branc9_223_, organizati0_.branches_count as branche10_223_, organizati0_.data_source as data_so11_223_, organizati0_.email as email12_223_, organizati0_.email_confirmed as email_c13_223_, organizati0_.esia_id as esia_id14_223_, organizati0_.factual_address as factual15_223_, organizati0_.fax as fax16_223_, organizati0_.full_name as full_na17_223_, organizati0_.head_ppa_org_id as head_pp37_223_, organizati0_.ifrs_reporting as ifrs_re18_223_, organizati0_.information_source_root_id as informa19_223_, organizati0_.inn as inn20_223_, organizati0_.kpp as kpp21_223_, organizati0_.na_branch_code as na_bran22_223_, organizati0_.na_client_id as na_clie23_223_, organizati0_.na_id as na_id24_223_, organizati0_.na_status as na_stat25_223_, organizati0_.na_update_date as na_upda26_223_, organizati0_.ogrn as ogrn27_223_, organizati0_.okopf_code as okopf_c28_223_, organizati0_.ppa_organization_id as ppa_org29_223_, organizati0_.organization_type as organiz30_223_, organizati0_.phone as phone31_223_, organizati0_.short_name as short_n32_223_, organizati0_.state_registration_date as state_r33_223_, organizati0_.status_id as status_38_223_, organizati0_.statutory_full_name as statuto34_223_, organizati0_.statutory_name_differs as statuto35_223_, organizati0_.statutory_short_name as statuto36_223_ from ppasm.ppa_organization_version organizati0_ where (organizati0_.ppa_organization_id in (? , ? , ? , ? , ?)) and organizati0_.actual=?
  30. 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=?
  31. 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=?
  32. 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=?
  33. 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
  34. 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=?
  35. 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=?
  36. 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=?
  37. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  38. 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=?
  39. 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
  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 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=?
  42. 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=?
  43. 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=?
  44. 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
  45. Hibernate: select organizati0_.id as id1_222_0_, organizati0_.last_editing_date as last_edi2_222_0_, organizati0_.block as block3_222_0_, organizati0_.block_date as block_da4_222_0_, organizati0_.block_reason_id as block_re5_222_0_, organizati0_.on_registration as on_regis6_222_0_, organizati0_.registered as register7_222_0_, organizati0_.registration_date as registra8_222_0_ from ppasm.ppa_organization_status organizati0_ where organizati0_.id=?
  46. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  47. Hibernate: select organizati0_.id as id1_219_0_, organizati0_.last_editing_date as last_edi2_219_0_, organizati0_.login_1c as login_3_219_0_, organizati0_.ogrn as ogrn4_219_0_, organizati0_.password_1c as password5_219_0_, organizati0_.session_expiration_1c as session_6_219_0_, organizati0_.session_id_1c as session_7_219_0_ from ppasm.ppa_organization organizati0_ where organizati0_.id=?
  48. Hibernate: select 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=?
  49. 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=?
  50. 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=?
  51. 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
  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 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=?
  54. 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=?
  55. 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=?
  56. 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=?
  57. 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
  58. 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=?
  59. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  60. Hibernate: select 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
  61.     December 17th 2020, 16:30:45.522    2020-12-17 14:30:45.521 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [lTaskExecutor-3] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: aDbs77.run() aDbs77Response = {"data":{"11016":[{"performerOrgRootId":25,"cooperationLevel":0,"contractorAgreements":[{"contractorAgreementId":30348,"contractorAgreementRootId":30348}]},{"performerOrgRootId":6,"cooperationLevel":1,"contractorAgreements":[{"contractorAgreementId":30293,"contractorAgreementRootId":30293}]},{"performerOrgRootId":20,"cooperationLevel":0,"contractorAgreements":[{"contractorAgreementId":30250,"contractorAgreementRootId":30250}]},{"performerOrgRootId":5,"cooperationLevel":1,"contractorAgreements":[{"contractorAgreementId":30348,"contractorAgreementRootId":30348}]},{"performerOrgRootId":19,"cooperationLevel":0,"contractorAgreements":[{"contractorAgreementId":30293,"contractorAgreementRootId":30293}]},{"performerOrgRootId":20,"cooperationLevel":1,"contractorAgreements":[{"contractorAgreementId":30250,"contractorAgreementRootId":30250}]},{"performerOrgRootId":5,"cooperationLevel":2,"contractorAgreements":[{"contractorAgreementId":30251,"contractorAgreementRootId":30251}]},{"performerOrgRootId":6,"cooperationLevel":3,"contractorAgreements":[{"contractorAgreementId":30255,"contractorAgreementRootId":30255},{"contractorAgreementId":30252,"contractorAgreementRootId":30252},{"contractorAgreementId":30261,"contractorAgreementRootId":30261}]}]}} backend develop-dev-roscap
  62.     December 17th 2020, 16:30:45.625    2020-12-17 14:30:45.622 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [lTaskExecutor-3] r.l.r.report.impl.algorithm.ReportA_O_2  : A_O_2: orgs info search completed data size=5   backend develop-dev-roscap
  63.     December 17th 2020, 16:30:45.628    2020-12-17 14:30:45.627 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [lTaskExecutor-3] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: aDobs72 params = {"agreementsObjects":{"11016":[{"rootId":997,"objectAddress":"г. Москва, Ботаническая 24","objectName":"ЖК РЕЖИССЕР","objectNumber":"А-1231","issueDate":{"year":2020,"month":11,"day":8},"projectId":"87668767","id":1023,"lastEditingDate":{"dateTime":{"date":{"year":2020,"month":11,"day":24},"time":{"hour":12,"minute":9,"second":35,"nano":903845000}},"offset":{"totalSeconds":10800}}},{"rootId":995,"objectAddress":"г. Москва, Ботаническая 20","objectName":"ЖК РЕЖИССЕР","objectNumber":"А-1231","issueDate":{"year":2020,"month":11,"day":8},"projectId":"87668767","id":1021,"lastEditingDate":{"dateTime":{"date":{"year":2020,"month":11,"day":24},"time":{"hour":12,"minute":9,"second":35,"nano":897998000}},"offset":{"totalSeconds":10800}}},{"rootId":999,"objectAddress":"г. Москва, Ботаническая 22","objectName":"ЖК РЕЖИССЕР","objectNumber":"А-1231","issueDate":{"year":2020,"month":11,"day":8},"projectId":"87668767","id":1025,"lastEditingDate":{"dateTime":{"date":{"year":2020,"month":11,"day":24},"time":{"hour":12,"minute":9,"second":35,"nano":908976000}},"offset":{"totalSeconds":10800}}},{"rootId":994,"objectAddress":"г. Москва, Ботаническая 21","objectName":"ЖК РЕЖИССЕР","objectNumber":"А-1231","issueDate":{"year":2020,"month":11,"day":8},"projectId":"87668767","id":1020,"lastEditingDate":{"dateTime":{"date":{"year":2020,"month":11,"day":24},"time":{"hour":12,"minute":9,"second":35,"nano":895111000}},"offset":{"totalSeconds":10800}}},{"rootId":998,"objectAddress":"г. Москва, Ботаническая 16","objectName":"ЖК РЕЖИССЕР","objectNumber":"А-1231","issueDate":{"year":2020,"month":11,"day":8},"projectId":"87668767","id":1024,"lastEditingDate":{"dateTime":{"date":{"year":2020,"month":11,"day":24},"time":{"hour":12,"minute":9,"second":35,"nano":906567000}},"offset":{"totalSeconds":10800}}},{"rootId":996,"objectAddress":"г. Москва, Ботаническая 15","objectName":"ЖК РЕЖИССЕР","objectNumber":"А-1231","issueDate":{"year":2020,"month":11,"day":8},"projectId":"87668767","id":1022,"lastEditingDate":{"dateTime":{"date":{"year":2020,"month":11,"day":24},"time":{"hour":12,"minute":9,"second":35,"nano":901010000}},"offset":{"totalSeconds":10800}}}]},"performerOrgRootIds":[19,20,5,6,25],"reportDate":{"year":2020,"month":12,"day":17}}
  64. 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
  65. Hibernate: select agreements0_.id as id2_9_, agreements0_.last_editing_date as last_edi3_9_, agreements0_.root_id as root_id4_9_, agreements0_.accepted as accepted5_9_, agreements0_.actual as actual6_9_, agreements0_.agreement_date as agreemen7_9_, agreements0_.agreement_number as agreemen8_9_, agreements0_.create_date as create_d9_9_, agreements0_.edit_reason as edit_re10_9_, agreements0_.edit_reason_id as edit_re11_9_, agreements0_.editor_employee_id as editor_12_9_, agreements0_.editor_organization_id as editor_13_9_, agreements0_.editor_organization_version_id as editor_14_9_, agreements0_.from_credit_road as from_cr15_9_, agreements0_.locked as locked16_9_, agreements0_.on_paper as on_pape17_9_, agreements0_.organization_id as organiz18_9_, agreements0_.organization_version_id as organiz19_9_, agreements0_.rejected_employee_root_id as rejecte20_9_, agreements0_.status_root_id as status_21_9_, agreements0_.system_number as system_22_9_, agreements0_.version_number as version23_9_, agreements0_.agreement_id as agreeme35_9_, agreements0_.close_date as close_d32_9_, agreements0_.subdivision_location as subdivi33_9_, agreements0_.subdivision_name as subdivi34_9_ from bagrsm.bagr_agreement agreements0_ cross join bagrsm.bagr_agreement agreementb1_ where agreements0_.agreement_type_root_id=2 and agreements0_.agreement_id=agreementb1_.id and agreementb1_.root_id=? and agreements0_.status_root_id=? and (agreements0_.agreement_date is not null)
  66. 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=?
  67. 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
  68. 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=?
  69. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  70. Hibernate: select 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 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
  72. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  73. Hibernate: select 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=?
  74. Hibernate: select participan0_.agreement_id as agreemen8_31_0_, participan0_.id as id1_31_0_, participan0_.id as id1_31_1_, participan0_.last_editing_date as last_edi2_31_1_, participan0_.agreement_id as agreemen8_31_1_, participan0_.bank_details_id as bank_det3_31_1_, participan0_.fund_subject as fund_sub4_31_1_, participan0_.organization_version_id as organiza5_31_1_, participan0_.organization_id as organiza6_31_1_, participan0_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_participant participan0_ where participan0_.agreement_id=?
  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_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  77. Hibernate: select participan0_.agreement_id as agreemen8_31_0_, participan0_.id as id1_31_0_, participan0_.id as id1_31_1_, participan0_.last_editing_date as last_edi2_31_1_, participan0_.agreement_id as agreemen8_31_1_, participan0_.bank_details_id as bank_det3_31_1_, participan0_.fund_subject as fund_sub4_31_1_, participan0_.organization_version_id as organiza5_31_1_, participan0_.organization_id as organiza6_31_1_, participan0_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_participant participan0_ where participan0_.agreement_id=?
  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 additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  80. Hibernate: select agreements0_.agreement_sba_id as agreemen4_18_0_, agreements0_.id as id1_18_0_, agreements0_.id as id1_18_1_, agreements0_.last_editing_date as last_edi2_18_1_, agreements0_.agreement_sba_id as agreemen4_18_1_, agreements0_.agreement_bs_object_id as agreemen5_18_1_, agreements0_.agreement_bs_object_root_id as agreemen3_18_1_ from bagrsm.bagr_agreement_sba_object agreements0_ where agreements0_.agreement_sba_id=?
  81. 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
  82. Hibernate: select agreementb0_.id as id1_12_0_, agreementb0_.last_editing_date as last_edi2_12_0_, agreementb0_.root_id as root_id3_12_0_, agreementb0_.agreement_id as agreeme17_12_0_, agreementb0_.create_date as create_d4_12_0_, agreementb0_.fund_code as fund_cod5_12_0_, agreementb0_.issue_date as issue_da6_12_0_, agreementb0_.object_address as object_a7_12_0_, agreementb0_.object_address_text as object_a8_12_0_, agreementb0_.object_eis_id as object_e9_12_0_, agreementb0_.object_name as object_10_12_0_, agreementb0_.object_number as object_11_12_0_, agreementb0_.project_cost as project12_12_0_, agreementb0_.project_id as project13_12_0_, agreementb0_.prolonged_to_date as prolong14_12_0_, agreementb0_.region_id as region_15_12_0_, agreementb0_.valid_to_date as valid_t16_12_0_, agreementb1_.id as id2_9_1_, agreementb1_.last_editing_date as last_edi3_9_1_, agreementb1_.root_id as root_id4_9_1_, agreementb1_.accepted as accepted5_9_1_, agreementb1_.actual as actual6_9_1_, agreementb1_.agreement_date as agreemen7_9_1_, agreementb1_.agreement_number as agreemen8_9_1_, agreementb1_.create_date as create_d9_9_1_, agreementb1_.edit_reason as edit_re10_9_1_, agreementb1_.edit_reason_id as edit_re11_9_1_, agreementb1_.editor_employee_id as editor_12_9_1_, agreementb1_.editor_organization_id as editor_13_9_1_, agreementb1_.editor_organization_version_id as editor_14_9_1_, agreementb1_.from_credit_road as from_cr15_9_1_, agreementb1_.locked as locked16_9_1_, agreementb1_.on_paper as on_pape17_9_1_, agreementb1_.organization_id as organiz18_9_1_, agreementb1_.organization_version_id as organiz19_9_1_, agreementb1_.rejected_employee_root_id as rejecte20_9_1_, agreementb1_.status_root_id as status_21_9_1_, agreementb1_.system_number as system_22_9_1_, agreementb1_.version_number as version23_9_1_, agreementb1_.accompanied_contract as accompa24_9_1_, agreementb1_.accounting_type_id as account25_9_1_, agreementb1_.additional_info as additio26_9_1_, agreementb1_.controlled_cooperation_level_id as control27_9_1_, agreementb1_.need_change_status_to_sba as need_ch28_9_1_, agreementb1_.project_management_root_id as project29_9_1_, agreementb1_.readiness_compliant as readine30_9_1_, agreementb1_.responsible_employee as respons31_9_1_, participan2_.agreement_id as agreemen8_31_2_, participan2_.id as id1_31_2_, participan2_.id as id1_31_3_, participan2_.last_editing_date as last_edi2_31_3_, participan2_.agreement_id as agreemen8_31_3_, participan2_.bank_details_id as bank_det3_31_3_, participan2_.fund_subject as fund_sub4_31_3_, participan2_.organization_version_id as organiza5_31_3_, participan2_.organization_id as organiza6_31_3_, participan2_.participant_type_root_id as particip7_31_3_, agreementb3_.id as id1_15_4_, agreementb3_.last_editing_date as last_edi2_15_4_, agreementb3_.agreement_id as agreemen5_15_4_, agreementb3_.agreement_bs_type_id as agreemen3_15_4_, agreementb3_.agreement_bs_type_root_id as agreemen4_15_4_ from bagrsm.bagr_agreement_bs_object 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 left outer join bagrsm.bagr_agreement_bs_type agreementb3_ on agreementb1_.id=agreementb3_.agreement_id where agreementb0_.id=?
  83. 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=?
  84. Hibernate: select agreementb0_.id as id1_12_0_, agreementb0_.last_editing_date as last_edi2_12_0_, agreementb0_.root_id as root_id3_12_0_, agreementb0_.agreement_id as agreeme17_12_0_, agreementb0_.create_date as create_d4_12_0_, agreementb0_.fund_code as fund_cod5_12_0_, agreementb0_.issue_date as issue_da6_12_0_, agreementb0_.object_address as object_a7_12_0_, agreementb0_.object_address_text as object_a8_12_0_, agreementb0_.object_eis_id as object_e9_12_0_, agreementb0_.object_name as object_10_12_0_, agreementb0_.object_number as object_11_12_0_, agreementb0_.project_cost as project12_12_0_, agreementb0_.project_id as project13_12_0_, agreementb0_.prolonged_to_date as prolong14_12_0_, agreementb0_.region_id as region_15_12_0_, agreementb0_.valid_to_date as valid_t16_12_0_, agreementb1_.id as id2_9_1_, agreementb1_.last_editing_date as last_edi3_9_1_, agreementb1_.root_id as root_id4_9_1_, agreementb1_.accepted as accepted5_9_1_, agreementb1_.actual as actual6_9_1_, agreementb1_.agreement_date as agreemen7_9_1_, agreementb1_.agreement_number as agreemen8_9_1_, agreementb1_.create_date as create_d9_9_1_, agreementb1_.edit_reason as edit_re10_9_1_, agreementb1_.edit_reason_id as edit_re11_9_1_, agreementb1_.editor_employee_id as editor_12_9_1_, agreementb1_.editor_organization_id as editor_13_9_1_, agreementb1_.editor_organization_version_id as editor_14_9_1_, agreementb1_.from_credit_road as from_cr15_9_1_, agreementb1_.locked as locked16_9_1_, agreementb1_.on_paper as on_pape17_9_1_, agreementb1_.organization_id as organiz18_9_1_, agreementb1_.organization_version_id as organiz19_9_1_, agreementb1_.rejected_employee_root_id as rejecte20_9_1_, agreementb1_.status_root_id as status_21_9_1_, agreementb1_.system_number as system_22_9_1_, agreementb1_.version_number as version23_9_1_, agreementb1_.accompanied_contract as accompa24_9_1_, agreementb1_.accounting_type_id as account25_9_1_, agreementb1_.additional_info as additio26_9_1_, agreementb1_.controlled_cooperation_level_id as control27_9_1_, agreementb1_.need_change_status_to_sba as need_ch28_9_1_, agreementb1_.project_management_root_id as project29_9_1_, agreementb1_.readiness_compliant as readine30_9_1_, agreementb1_.responsible_employee as respons31_9_1_, participan2_.agreement_id as agreemen8_31_2_, participan2_.id as id1_31_2_, participan2_.id as id1_31_3_, participan2_.last_editing_date as last_edi2_31_3_, participan2_.agreement_id as agreemen8_31_3_, participan2_.bank_details_id as bank_det3_31_3_, participan2_.fund_subject as fund_sub4_31_3_, participan2_.organization_version_id as organiza5_31_3_, participan2_.organization_id as organiza6_31_3_, participan2_.participant_type_root_id as particip7_31_3_, agreementb3_.id as id1_15_4_, agreementb3_.last_editing_date as last_edi2_15_4_, agreementb3_.agreement_id as agreemen5_15_4_, agreementb3_.agreement_bs_type_id as agreemen3_15_4_, agreementb3_.agreement_bs_type_root_id as agreemen4_15_4_ from bagrsm.bagr_agreement_bs_object 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 left outer join bagrsm.bagr_agreement_bs_type agreementb3_ on agreementb1_.id=agreementb3_.agreement_id where agreementb0_.id=?
  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_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  87. Hibernate: select agreementb0_.id as id1_12_0_, agreementb0_.last_editing_date as last_edi2_12_0_, agreementb0_.root_id as root_id3_12_0_, agreementb0_.agreement_id as agreeme17_12_0_, agreementb0_.create_date as create_d4_12_0_, agreementb0_.fund_code as fund_cod5_12_0_, agreementb0_.issue_date as issue_da6_12_0_, agreementb0_.object_address as object_a7_12_0_, agreementb0_.object_address_text as object_a8_12_0_, agreementb0_.object_eis_id as object_e9_12_0_, agreementb0_.object_name as object_10_12_0_, agreementb0_.object_number as object_11_12_0_, agreementb0_.project_cost as project12_12_0_, agreementb0_.project_id as project13_12_0_, agreementb0_.prolonged_to_date as prolong14_12_0_, agreementb0_.region_id as region_15_12_0_, agreementb0_.valid_to_date as valid_t16_12_0_, agreementb1_.id as id2_9_1_, agreementb1_.last_editing_date as last_edi3_9_1_, agreementb1_.root_id as root_id4_9_1_, agreementb1_.accepted as accepted5_9_1_, agreementb1_.actual as actual6_9_1_, agreementb1_.agreement_date as agreemen7_9_1_, agreementb1_.agreement_number as agreemen8_9_1_, agreementb1_.create_date as create_d9_9_1_, agreementb1_.edit_reason as edit_re10_9_1_, agreementb1_.edit_reason_id as edit_re11_9_1_, agreementb1_.editor_employee_id as editor_12_9_1_, agreementb1_.editor_organization_id as editor_13_9_1_, agreementb1_.editor_organization_version_id as editor_14_9_1_, agreementb1_.from_credit_road as from_cr15_9_1_, agreementb1_.locked as locked16_9_1_, agreementb1_.on_paper as on_pape17_9_1_, agreementb1_.organization_id as organiz18_9_1_, agreementb1_.organization_version_id as organiz19_9_1_, agreementb1_.rejected_employee_root_id as rejecte20_9_1_, agreementb1_.status_root_id as status_21_9_1_, agreementb1_.system_number as system_22_9_1_, agreementb1_.version_number as version23_9_1_, agreementb1_.accompanied_contract as accompa24_9_1_, agreementb1_.accounting_type_id as account25_9_1_, agreementb1_.additional_info as additio26_9_1_, agreementb1_.controlled_cooperation_level_id as control27_9_1_, agreementb1_.need_change_status_to_sba as need_ch28_9_1_, agreementb1_.project_management_root_id as project29_9_1_, agreementb1_.readiness_compliant as readine30_9_1_, agreementb1_.responsible_employee as respons31_9_1_, participan2_.agreement_id as agreemen8_31_2_, participan2_.id as id1_31_2_, participan2_.id as id1_31_3_, participan2_.last_editing_date as last_edi2_31_3_, participan2_.agreement_id as agreemen8_31_3_, participan2_.bank_details_id as bank_det3_31_3_, participan2_.fund_subject as fund_sub4_31_3_, participan2_.organization_version_id as organiza5_31_3_, participan2_.organization_id as organiza6_31_3_, participan2_.participant_type_root_id as particip7_31_3_, agreementb3_.id as id1_15_4_, agreementb3_.last_editing_date as last_edi2_15_4_, agreementb3_.agreement_id as agreemen5_15_4_, agreementb3_.agreement_bs_type_id as agreemen3_15_4_, agreementb3_.agreement_bs_type_root_id as agreemen4_15_4_ from bagrsm.bagr_agreement_bs_object 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 left outer join bagrsm.bagr_agreement_bs_type agreementb3_ on agreementb1_.id=agreementb3_.agreement_id where agreementb0_.id=?
  88. 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=?
  89. Hibernate: select agreementb0_.id as id1_12_0_, agreementb0_.last_editing_date as last_edi2_12_0_, agreementb0_.root_id as root_id3_12_0_, agreementb0_.agreement_id as agreeme17_12_0_, agreementb0_.create_date as create_d4_12_0_, agreementb0_.fund_code as fund_cod5_12_0_, agreementb0_.issue_date as issue_da6_12_0_, agreementb0_.object_address as object_a7_12_0_, agreementb0_.object_address_text as object_a8_12_0_, agreementb0_.object_eis_id as object_e9_12_0_, agreementb0_.object_name as object_10_12_0_, agreementb0_.object_number as object_11_12_0_, agreementb0_.project_cost as project12_12_0_, agreementb0_.project_id as project13_12_0_, agreementb0_.prolonged_to_date as prolong14_12_0_, agreementb0_.region_id as region_15_12_0_, agreementb0_.valid_to_date as valid_t16_12_0_, agreementb1_.id as id2_9_1_, agreementb1_.last_editing_date as last_edi3_9_1_, agreementb1_.root_id as root_id4_9_1_, agreementb1_.accepted as accepted5_9_1_, agreementb1_.actual as actual6_9_1_, agreementb1_.agreement_date as agreemen7_9_1_, agreementb1_.agreement_number as agreemen8_9_1_, agreementb1_.create_date as create_d9_9_1_, agreementb1_.edit_reason as edit_re10_9_1_, agreementb1_.edit_reason_id as edit_re11_9_1_, agreementb1_.editor_employee_id as editor_12_9_1_, agreementb1_.editor_organization_id as editor_13_9_1_, agreementb1_.editor_organization_version_id as editor_14_9_1_, agreementb1_.from_credit_road as from_cr15_9_1_, agreementb1_.locked as locked16_9_1_, agreementb1_.on_paper as on_pape17_9_1_, agreementb1_.organization_id as organiz18_9_1_, agreementb1_.organization_version_id as organiz19_9_1_, agreementb1_.rejected_employee_root_id as rejecte20_9_1_, agreementb1_.status_root_id as status_21_9_1_, agreementb1_.system_number as system_22_9_1_, agreementb1_.version_number as version23_9_1_, agreementb1_.accompanied_contract as accompa24_9_1_, agreementb1_.accounting_type_id as account25_9_1_, agreementb1_.additional_info as additio26_9_1_, agreementb1_.controlled_cooperation_level_id as control27_9_1_, agreementb1_.need_change_status_to_sba as need_ch28_9_1_, agreementb1_.project_management_root_id as project29_9_1_, agreementb1_.readiness_compliant as readine30_9_1_, agreementb1_.responsible_employee as respons31_9_1_, participan2_.agreement_id as agreemen8_31_2_, participan2_.id as id1_31_2_, participan2_.id as id1_31_3_, participan2_.last_editing_date as last_edi2_31_3_, participan2_.agreement_id as agreemen8_31_3_, participan2_.bank_details_id as bank_det3_31_3_, participan2_.fund_subject as fund_sub4_31_3_, participan2_.organization_version_id as organiza5_31_3_, participan2_.organization_id as organiza6_31_3_, participan2_.participant_type_root_id as particip7_31_3_, agreementb3_.id as id1_15_4_, agreementb3_.last_editing_date as last_edi2_15_4_, agreementb3_.agreement_id as agreemen5_15_4_, agreementb3_.agreement_bs_type_id as agreemen3_15_4_, agreementb3_.agreement_bs_type_root_id as agreemen4_15_4_ from bagrsm.bagr_agreement_bs_object 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 left outer join bagrsm.bagr_agreement_bs_type agreementb3_ on agreementb1_.id=agreementb3_.agreement_id where agreementb0_.id=?
  90. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  91. 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=?
  92. Hibernate: select agreementb0_.id as id1_12_0_, agreementb0_.last_editing_date as last_edi2_12_0_, agreementb0_.root_id as root_id3_12_0_, agreementb0_.agreement_id as agreeme17_12_0_, agreementb0_.create_date as create_d4_12_0_, agreementb0_.fund_code as fund_cod5_12_0_, agreementb0_.issue_date as issue_da6_12_0_, agreementb0_.object_address as object_a7_12_0_, agreementb0_.object_address_text as object_a8_12_0_, agreementb0_.object_eis_id as object_e9_12_0_, agreementb0_.object_name as object_10_12_0_, agreementb0_.object_number as object_11_12_0_, agreementb0_.project_cost as project12_12_0_, agreementb0_.project_id as project13_12_0_, agreementb0_.prolonged_to_date as prolong14_12_0_, agreementb0_.region_id as region_15_12_0_, agreementb0_.valid_to_date as valid_t16_12_0_, agreementb1_.id as id2_9_1_, agreementb1_.last_editing_date as last_edi3_9_1_, agreementb1_.root_id as root_id4_9_1_, agreementb1_.accepted as accepted5_9_1_, agreementb1_.actual as actual6_9_1_, agreementb1_.agreement_date as agreemen7_9_1_, agreementb1_.agreement_number as agreemen8_9_1_, agreementb1_.create_date as create_d9_9_1_, agreementb1_.edit_reason as edit_re10_9_1_, agreementb1_.edit_reason_id as edit_re11_9_1_, agreementb1_.editor_employee_id as editor_12_9_1_, agreementb1_.editor_organization_id as editor_13_9_1_, agreementb1_.editor_organization_version_id as editor_14_9_1_, agreementb1_.from_credit_road as from_cr15_9_1_, agreementb1_.locked as locked16_9_1_, agreementb1_.on_paper as on_pape17_9_1_, agreementb1_.organization_id as organiz18_9_1_, agreementb1_.organization_version_id as organiz19_9_1_, agreementb1_.rejected_employee_root_id as rejecte20_9_1_, agreementb1_.status_root_id as status_21_9_1_, agreementb1_.system_number as system_22_9_1_, agreementb1_.version_number as version23_9_1_, agreementb1_.accompanied_contract as accompa24_9_1_, agreementb1_.accounting_type_id as account25_9_1_, agreementb1_.additional_info as additio26_9_1_, agreementb1_.controlled_cooperation_level_id as control27_9_1_, agreementb1_.need_change_status_to_sba as need_ch28_9_1_, agreementb1_.project_management_root_id as project29_9_1_, agreementb1_.readiness_compliant as readine30_9_1_, agreementb1_.responsible_employee as respons31_9_1_, participan2_.agreement_id as agreemen8_31_2_, participan2_.id as id1_31_2_, participan2_.id as id1_31_3_, participan2_.last_editing_date as last_edi2_31_3_, participan2_.agreement_id as agreemen8_31_3_, participan2_.bank_details_id as bank_det3_31_3_, participan2_.fund_subject as fund_sub4_31_3_, participan2_.organization_version_id as organiza5_31_3_, participan2_.organization_id as organiza6_31_3_, participan2_.participant_type_root_id as particip7_31_3_, agreementb3_.id as id1_15_4_, agreementb3_.last_editing_date as last_edi2_15_4_, agreementb3_.agreement_id as agreemen5_15_4_, agreementb3_.agreement_bs_type_id as agreemen3_15_4_, agreementb3_.agreement_bs_type_root_id as agreemen4_15_4_ from bagrsm.bagr_agreement_bs_object 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 left outer join bagrsm.bagr_agreement_bs_type agreementb3_ on agreementb1_.id=agreementb3_.agreement_id where agreementb0_.id=?
  93. Hibernate: select agreementb0_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  94. Hibernate: select agreementb0_.id as id1_12_0_, agreementb0_.last_editing_date as last_edi2_12_0_, agreementb0_.root_id as root_id3_12_0_, agreementb0_.agreement_id as agreeme17_12_0_, agreementb0_.create_date as create_d4_12_0_, agreementb0_.fund_code as fund_cod5_12_0_, agreementb0_.issue_date as issue_da6_12_0_, agreementb0_.object_address as object_a7_12_0_, agreementb0_.object_address_text as object_a8_12_0_, agreementb0_.object_eis_id as object_e9_12_0_, agreementb0_.object_name as object_10_12_0_, agreementb0_.object_number as object_11_12_0_, agreementb0_.project_cost as project12_12_0_, agreementb0_.project_id as project13_12_0_, agreementb0_.prolonged_to_date as prolong14_12_0_, agreementb0_.region_id as region_15_12_0_, agreementb0_.valid_to_date as valid_t16_12_0_, agreementb1_.id as id2_9_1_, agreementb1_.last_editing_date as last_edi3_9_1_, agreementb1_.root_id as root_id4_9_1_, agreementb1_.accepted as accepted5_9_1_, agreementb1_.actual as actual6_9_1_, agreementb1_.agreement_date as agreemen7_9_1_, agreementb1_.agreement_number as agreemen8_9_1_, agreementb1_.create_date as create_d9_9_1_, agreementb1_.edit_reason as edit_re10_9_1_, agreementb1_.edit_reason_id as edit_re11_9_1_, agreementb1_.editor_employee_id as editor_12_9_1_, agreementb1_.editor_organization_id as editor_13_9_1_, agreementb1_.editor_organization_version_id as editor_14_9_1_, agreementb1_.from_credit_road as from_cr15_9_1_, agreementb1_.locked as locked16_9_1_, agreementb1_.on_paper as on_pape17_9_1_, agreementb1_.organization_id as organiz18_9_1_, agreementb1_.organization_version_id as organiz19_9_1_, agreementb1_.rejected_employee_root_id as rejecte20_9_1_, agreementb1_.status_root_id as status_21_9_1_, agreementb1_.system_number as system_22_9_1_, agreementb1_.version_number as version23_9_1_, agreementb1_.accompanied_contract as accompa24_9_1_, agreementb1_.accounting_type_id as account25_9_1_, agreementb1_.additional_info as additio26_9_1_, agreementb1_.controlled_cooperation_level_id as control27_9_1_, agreementb1_.need_change_status_to_sba as need_ch28_9_1_, agreementb1_.project_management_root_id as project29_9_1_, agreementb1_.readiness_compliant as readine30_9_1_, agreementb1_.responsible_employee as respons31_9_1_, participan2_.agreement_id as agreemen8_31_2_, participan2_.id as id1_31_2_, participan2_.id as id1_31_3_, participan2_.last_editing_date as last_edi2_31_3_, participan2_.agreement_id as agreemen8_31_3_, participan2_.bank_details_id as bank_det3_31_3_, participan2_.fund_subject as fund_sub4_31_3_, participan2_.organization_version_id as organiza5_31_3_, participan2_.organization_id as organiza6_31_3_, participan2_.participant_type_root_id as particip7_31_3_, agreementb3_.id as id1_15_4_, agreementb3_.last_editing_date as last_edi2_15_4_, agreementb3_.agreement_id as agreemen5_15_4_, agreementb3_.agreement_bs_type_id as agreemen3_15_4_, agreementb3_.agreement_bs_type_root_id as agreemen4_15_4_ from bagrsm.bagr_agreement_bs_object 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 left outer join bagrsm.bagr_agreement_bs_type agreementb3_ on agreementb1_.id=agreementb3_.agreement_id where agreementb0_.id=?
  95. 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=?
  96. Hibernate: select errors0_.agreement_id as agreemen8_28_0_, errors0_.id as id1_28_0_, errors0_.id as id1_28_1_, errors0_.last_editing_date as last_edi2_28_1_, errors0_.actual as actual3_28_1_, errors0_.agreement_id as agreemen8_28_1_, errors0_.create_date as create_d4_28_1_, errors0_.error_text as error_te5_28_1_, errors0_.non_blocking as non_bloc6_28_1_, errors0_.visible as visible7_28_1_ from bagrsm.bagr_error errors0_ where ( errors0_.actual is true) and errors0_.agreement_id=?
  97. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  98. Hibernate: select agreements0_.agreement_id as agreemen7_17_0_, agreements0_.id as id1_17_0_, agreements0_.id as id1_17_1_, agreements0_.last_editing_date as last_edi2_17_1_, agreements0_.agreement_id as agreemen7_17_1_, agreements0_.bank_details_id as bank_det3_17_1_, agreements0_.contractor_agreement_id as contract4_17_1_, agreements0_.expense_sheet_present as expense_5_17_1_, agreements0_.not_actual_conditions as not_actu6_17_1_ from bagrsm.bagr_agreement_sba_link agreements0_ where agreements0_.agreement_id=?
  99. 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=?
  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 agreements0_.agreement_sba_id as agreemen4_18_0_, agreements0_.id as id1_18_0_, agreements0_.id as id1_18_1_, agreements0_.last_editing_date as last_edi2_18_1_, agreements0_.agreement_sba_id as agreemen4_18_1_, agreements0_.agreement_bs_object_id as agreemen5_18_1_, agreements0_.agreement_bs_object_root_id as agreemen3_18_1_ from bagrsm.bagr_agreement_sba_object agreements0_ where agreements0_.agreement_sba_id=?
  103. 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=?
  104. Hibernate: select errors0_.agreement_id as agreemen8_28_0_, errors0_.id as id1_28_0_, errors0_.id as id1_28_1_, errors0_.last_editing_date as last_edi2_28_1_, errors0_.actual as actual3_28_1_, errors0_.agreement_id as agreemen8_28_1_, errors0_.create_date as create_d4_28_1_, errors0_.error_text as error_te5_28_1_, errors0_.non_blocking as non_bloc6_28_1_, errors0_.visible as visible7_28_1_ from bagrsm.bagr_error errors0_ where ( errors0_.actual is true) and errors0_.agreement_id=?
  105. 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
  106. Hibernate: select agreements0_.agreement_id as agreemen7_17_0_, agreements0_.id as id1_17_0_, agreements0_.id as id1_17_1_, agreements0_.last_editing_date as last_edi2_17_1_, agreements0_.agreement_id as agreemen7_17_1_, agreements0_.bank_details_id as bank_det3_17_1_, agreements0_.contractor_agreement_id as contract4_17_1_, agreements0_.expense_sheet_present as expense_5_17_1_, agreements0_.not_actual_conditions as not_actu6_17_1_ from bagrsm.bagr_agreement_sba_link agreements0_ where agreements0_.agreement_id=?
  107. 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=?
  108. 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=?
  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=? backend develop-dev-roscap
  110.     December 17th 2020, 16:30:45.853    2020-12-17 14:30:45.852 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [lTaskExecutor-3] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: aDobs72 response = {"data":{"11016":[{"objectRootId":994,"agreementSbaDetailsSet":[{"sbaAgreementRootId":11017,"sbaAgreementNumber":"20АК-22354/ОБСС/ОБС","performerOrgRootId":25,"bankDetailsRootId":429},{"sbaAgreementRootId":11018,"sbaAgreementNumber":"05-006-20-1188617000758-860101001","performerOrgRootId":5,"bankDetailsRootId":658}]},{"objectRootId":995,"agreementSbaDetailsSet":[{"sbaAgreementRootId":11017,"sbaAgreementNumber":"20АК-22354/ОБСС/ОБС","performerOrgRootId":25,"bankDetailsRootId":429},{"sbaAgreementRootId":11018,"sbaAgreementNumber":"05-006-20-1188617000758-860101001","performerOrgRootId":5,"bankDetailsRootId":658}]},{"objectRootId":996,"agreementSbaDetailsSet":[{"sbaAgreementRootId":11017,"sbaAgreementNumber":"20АК-22354/ОБСС/ОБС","performerOrgRootId":25,"bankDetailsRootId":429},{"sbaAgreementRootId":11018,"sbaAgreementNumber":"05-006-20-1188617000758-860101001","performerOrgRootId":5,"bankDetailsRootId":658}]},{"objectRootId":997,"agreementSbaDetailsSet":[{"sbaAgreementRootId":11017,"sbaAgreementNumber":"20АК-22354/ОБСС/ОБС","performerOrgRootId":25,"bankDetailsRootId":429},{"sbaAgreementRootId":11018,"sbaAgreementNumber":"05-006-20-1188617000758-860101001","performerOrgRootId":5,"bankDetailsRootId":658}]},{"objectRootId":998,"agreementSbaDetailsSet":[{"sbaAgreementRootId":11017,"sbaAgreementNumber":"20АК-22354/ОБСС/ОБС","performerOrgRootId":25,"bankDetailsRootId":429},{"sbaAgreementRootId":11018,"sbaAgreementNumber":"05-006-20-1188617000758-860101001","performerOrgRootId":5,"bankDetailsRootId":658}]},{"objectRootId":999,"agreementSbaDetailsSet":[{"sbaAgreementRootId":11017,"sbaAgreementNumber":"20АК-22354/ОБСС/ОБС","performerOrgRootId":25,"bankDetailsRootId":429},{"sbaAgreementRootId":11018,"sbaAgreementNumber":"05-006-20-1188617000758-860101001","performerOrgRootId":5,"bankDetailsRootId":658}]}]}}    backend develop-dev-roscap
  111.     December 17th 2020, 16:30:45.853    2020-12-17 14:30:45.853 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [lTaskExecutor-3] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: isEmptyADobs72 = false backend develop-dev-roscap
  112.     December 17th 2020, 16:30:45.857    2020-12-17 14:30:45.857 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [lTaskExecutor-3] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: aVrr57 params = {"agreementBsId":11016,"bankDetailsRootIdsByPerformerIdsByObjectIds":{"994":{"5":[658],"25":[429]},"995":{"5":[658],"25":[429]},"996":{"5":[658],"25":[429]},"997":{"5":[658],"25":[429]},"998":{"5":[658],"25":[429]},"999":{"5":[658],"25":[429]}},"endDate":{"year":2020,"month":12,"day":17}}
  113. 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
  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=? backend develop-dev-roscap
  115.     December 17th 2020, 16:30:45.873    2020-12-17 14:30:45.857  INFO 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [lTaskExecutor-3] r.l.r.b.impl.service.algorithm.A_VRR_57  : A_VRR_57: BudgetsForReportFindRequest: { agreementBsId=11016, endDate=2020-12-17, bankDetailsRootIdsByPerformerIdsByObjectIds={994: {5: [658], 25: [429]}, 995: {5: [658], 25: [429]}, 996: {5: [658], 25: [429]}, 997: {5: [658], 25: [429]}, 998: {5: [658], 25: [429]}, 999: {5: [658], 25: [429]}} }
  116. Hibernate: select budgetvers0_.id as id1_52_, budgetvers0_.last_editing_date as last_edi2_52_, budgetvers0_.actual as actual3_52_, budgetvers0_.actual_by_business as actual_b4_52_, budgetvers0_.budget_id as budget_i6_52_, budgetvers0_.budget_number as budget_n5_52_, budgetvers0_.client_id as client_i7_52_, budgetvers0_.client_root_id as client_r8_52_, budgetvers0_.create_date as create_d9_52_, budgetvers0_.creator_organization_id as creator10_52_, budgetvers0_.creator_organization_root_id as creator11_52_, budgetvers0_.document_date as documen12_52_, budgetvers0_.editor_employee_root_id as editor_13_52_, budgetvers0_.editor_organization_id as editor_14_52_, budgetvers0_.editor_organization_root_id as editor_15_52_, budgetvers0_.employee_root_id_rejected as employe16_52_, budgetvers0_.employee_root_id_sent_to_signing as employe17_52_, budgetvers0_.inactive as inactiv18_52_, budgetvers0_.locked as locked19_52_, budgetvers0_.prepayment_limit as prepaym20_52_, budgetvers0_.recognition_in_progress as recogni21_52_, budgetvers0_.status_root_id as status_22_52_, budgetvers0_.system_number as system_23_52_, budgetvers0_.top_customer_id as top_cus24_52_, budgetvers0_.top_customer_root_id as top_cus25_52_, budgetvers0_.total_limit_with_vat as total_l26_52_, budgetvers0_.valid_to as valid_t27_52_, budgetvers0_.version_number as version28_52_ from bsm.b_budget_version budgetvers0_ cross join bsm.b_budget_account_cagr_relation budgetacco1_ where budgetvers0_.id=budgetacco1_.budget_version_id and budgetvers0_.status_root_id=? and budgetvers0_.document_date<? and budgetacco1_.bank_details_root_id=?
  117. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  118. Hibernate: select agreementb0_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  119. Hibernate: select budgetvers0_.id as id1_52_, budgetvers0_.last_editing_date as last_edi2_52_, budgetvers0_.actual as actual3_52_, budgetvers0_.actual_by_business as actual_b4_52_, budgetvers0_.budget_id as budget_i6_52_, budgetvers0_.budget_number as budget_n5_52_, budgetvers0_.client_id as client_i7_52_, budgetvers0_.client_root_id as client_r8_52_, budgetvers0_.create_date as create_d9_52_, budgetvers0_.creator_organization_id as creator10_52_, budgetvers0_.creator_organization_root_id as creator11_52_, budgetvers0_.document_date as documen12_52_, budgetvers0_.editor_employee_root_id as editor_13_52_, budgetvers0_.editor_organization_id as editor_14_52_, budgetvers0_.editor_organization_root_id as editor_15_52_, budgetvers0_.employee_root_id_rejected as employe16_52_, budgetvers0_.employee_root_id_sent_to_signing as employe17_52_, budgetvers0_.inactive as inactiv18_52_, budgetvers0_.locked as locked19_52_, budgetvers0_.prepayment_limit as prepaym20_52_, budgetvers0_.recognition_in_progress as recogni21_52_, budgetvers0_.status_root_id as status_22_52_, budgetvers0_.system_number as system_23_52_, budgetvers0_.top_customer_id as top_cus24_52_, budgetvers0_.top_customer_root_id as top_cus25_52_, budgetvers0_.total_limit_with_vat as total_l26_52_, budgetvers0_.valid_to as valid_t27_52_, budgetvers0_.version_number as version28_52_ from bsm.b_budget_version budgetvers0_ cross join bsm.b_budget_account_cagr_relation budgetacco1_ where budgetvers0_.id=budgetacco1_.budget_version_id and budgetvers0_.status_root_id=? and budgetvers0_.document_date<? and budgetacco1_.bank_details_root_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 budgetenti0_.id as id1_41_0_, budgetenti0_.last_editing_date as last_edi2_41_0_, budgetenti0_.bagr_agreement_id as bagr_agr3_41_0_, budgetenti0_.bagr_agreement_root_id as bagr_agr4_41_0_, budgetenti0_.cagr_changed_party as cagr_cha5_41_0_ from bsm.b_budget budgetenti0_ where budgetenti0_.id=?
  122. 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=?
  123. Hibernate: select budgetacco0_.id as id1_42_2_, budgetacco0_.last_editing_date as last_edi2_42_2_, budgetacco0_.budget_version_id as budget_v3_42_2_, budgetacco0_.bank_details_id as bank_det4_42_2_, budgetacco0_.bank_details_root_id as bank_det5_42_2_, budgetacco0_.budget_structure_id as budget_s6_42_2_, budgetvers1_.id as id1_52_0_, budgetvers1_.last_editing_date as last_edi2_52_0_, budgetvers1_.actual as actual3_52_0_, budgetvers1_.actual_by_business as actual_b4_52_0_, budgetvers1_.budget_id as budget_i6_52_0_, budgetvers1_.budget_number as budget_n5_52_0_, budgetvers1_.client_id as client_i7_52_0_, budgetvers1_.client_root_id as client_r8_52_0_, budgetvers1_.create_date as create_d9_52_0_, budgetvers1_.creator_organization_id as creator10_52_0_, budgetvers1_.creator_organization_root_id as creator11_52_0_, budgetvers1_.document_date as documen12_52_0_, budgetvers1_.editor_employee_root_id as editor_13_52_0_, budgetvers1_.editor_organization_id as editor_14_52_0_, budgetvers1_.editor_organization_root_id as editor_15_52_0_, budgetvers1_.employee_root_id_rejected as employe16_52_0_, budgetvers1_.employee_root_id_sent_to_signing as employe17_52_0_, budgetvers1_.inactive as inactiv18_52_0_, budgetvers1_.locked as locked19_52_0_, budgetvers1_.prepayment_limit as prepaym20_52_0_, budgetvers1_.recognition_in_progress as recogni21_52_0_, budgetvers1_.status_root_id as status_22_52_0_, budgetvers1_.system_number as system_23_52_0_, budgetvers1_.top_customer_id as top_cus24_52_0_, budgetvers1_.top_customer_root_id as top_cus25_52_0_, budgetvers1_.total_limit_with_vat as total_l26_52_0_, budgetvers1_.valid_to as valid_t27_52_0_, budgetvers1_.version_number as version28_52_0_, budgetenti2_.id as id1_41_1_, budgetenti2_.last_editing_date as last_edi2_41_1_, budgetenti2_.bagr_agreement_id as bagr_agr3_41_1_, budgetenti2_.bagr_agreement_root_id as bagr_agr4_41_1_, budgetenti2_.cagr_changed_party as cagr_cha5_41_1_ from bsm.b_budget_account_cagr_relation budgetacco0_ inner join bsm.b_budget_version budgetvers1_ on budgetacco0_.budget_version_id=budgetvers1_.id left outer join bsm.b_budget budgetenti2_ on budgetvers1_.budget_id=budgetenti2_.id where budgetacco0_.budget_version_id=?
  124. Hibernate: select agreementb0_.id as id2_9_0_, agreementb0_.last_editing_date as last_edi3_9_0_, agreementb0_.root_id as root_id4_9_0_, agreementb0_.accepted as accepted5_9_0_, agreementb0_.actual as actual6_9_0_, agreementb0_.agreement_date as agreemen7_9_0_, agreementb0_.agreement_number as agreemen8_9_0_, agreementb0_.create_date as create_d9_9_0_, agreementb0_.edit_reason as edit_re10_9_0_, agreementb0_.edit_reason_id as edit_re11_9_0_, agreementb0_.editor_employee_id as editor_12_9_0_, agreementb0_.editor_organization_id as editor_13_9_0_, agreementb0_.editor_organization_version_id as editor_14_9_0_, agreementb0_.from_credit_road as from_cr15_9_0_, agreementb0_.locked as locked16_9_0_, agreementb0_.on_paper as on_pape17_9_0_, agreementb0_.organization_id as organiz18_9_0_, agreementb0_.organization_version_id as organiz19_9_0_, agreementb0_.rejected_employee_root_id as rejecte20_9_0_, agreementb0_.status_root_id as status_21_9_0_, agreementb0_.system_number as system_22_9_0_, agreementb0_.version_number as version23_9_0_, agreementb0_.accompanied_contract as accompa24_9_0_, agreementb0_.accounting_type_id as account25_9_0_, agreementb0_.additional_info as additio26_9_0_, agreementb0_.controlled_cooperation_level_id as control27_9_0_, agreementb0_.need_change_status_to_sba as need_ch28_9_0_, agreementb0_.project_management_root_id as project29_9_0_, agreementb0_.readiness_compliant as readine30_9_0_, agreementb0_.responsible_employee as respons31_9_0_, participan1_.agreement_id as agreemen8_31_1_, participan1_.id as id1_31_1_, participan1_.id as id1_31_2_, participan1_.last_editing_date as last_edi2_31_2_, participan1_.agreement_id as agreemen8_31_2_, participan1_.bank_details_id as bank_det3_31_2_, participan1_.fund_subject as fund_sub4_31_2_, participan1_.organization_version_id as organiza5_31_2_, participan1_.organization_id as organiza6_31_2_, participan1_.participant_type_root_id as particip7_31_2_, agreementb2_.id as id1_15_3_, agreementb2_.last_editing_date as last_edi2_15_3_, agreementb2_.agreement_id as agreemen5_15_3_, agreementb2_.agreement_bs_type_id as agreemen3_15_3_, agreementb2_.agreement_bs_type_root_id as agreemen4_15_3_ from bagrsm.bagr_agreement agreementb0_ left outer join bagrsm.bagr_participant participan1_ on agreementb0_.id=participan1_.agreement_id left outer join bagrsm.bagr_agreement_bs_type agreementb2_ on agreementb0_.id=agreementb2_.agreement_id where agreementb0_.id=? and agreementb0_.agreement_type_root_id=1
  125. Hibernate: select 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 items0_.budget_version_id as budget_v3_48_0_, items0_.id as id1_48_0_, items0_.id as id1_48_1_, items0_.last_editing_date as last_edi2_48_1_, items0_.budget_version_id as budget_v3_48_1_, items0_.expense_distribution_item_id as expense_4_48_1_, items0_.expense_distribution_item_root_id as expense_5_48_1_, items0_.limit_with_vat as limit_wi6_48_1_, items0_.take_commission as take_com7_48_1_ from bsm.b_budget_item items0_ where items0_.budget_version_id=?
  127. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  128. Hibernate: select 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
  129. 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=?
  130. 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=?
  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 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
  133. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  134. Hibernate: select 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 nsiexpense0_.id as id1_111_, nsiexpense0_.actual as actual2_111_, nsiexpense0_.create_date as create_d3_111_, nsiexpense0_.deleted as deleted4_111_, nsiexpense0_.inner_code as inner_co5_111_, nsiexpense0_.last_editing_date as last_edi6_111_, nsiexpense0_.root_id as root_id7_111_, nsiexpense0_.sort_order as sort_ord8_111_, nsiexpense0_.value as value9_111_, nsiexpense0_.version_number as version10_111_, nsiexpense0_.added_manually as added_m11_111_, nsiexpense0_.contains_children as contain12_111_, nsiexpense0_.parent_root_id as parent_13_111_, nsiexpense0_.business_code as busines14_111_, nsiexpense0_.co_performer_only as co_perf15_111_, nsiexpense0_.commission_item as commiss16_111_, nsiexpense0_.no_limit_on_funds as no_limi17_111_, recordtype1_.expense_distribution_item_id as expense_1_115_0__, recordtype1_.record_type_id as record_t2_115_0__ from nsism.nsi_expense_distribution_item nsiexpense0_ left outer join nsism.nsi_expense_distribution_item_record_type recordtype1_ on nsiexpense0_.id=recordtype1_.expense_distribution_item_id where nsiexpense0_.actual=? order by nsiexpense0_.sort_order asc
  137. 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
  138. 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=?
  139. 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=?
  140. 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
  141. 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=?
  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 grouprooti0_.expense_distribution_item_id as expense_1_113_0_, grouprooti0_.expense_distribution_item_group_root_id as expense_2_113_0_ from nsism.nsi_expense_distribution_item_expense_item_group grouprooti0_ where grouprooti0_.expense_distribution_item_id=?
  144. 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
  145. 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=?
  146. Hibernate: select agreementb0_.expense_distribution_item_id as expense_1_112_0_, agreementb0_.agreement_bs_type_id as agreemen2_112_0_ from nsism.nsi_expense_distribution_item_agreement_bs_type agreementb0_ where agreementb0_.expense_distribution_item_id=?    backend develop-dev-roscap
  147.     December 17th 2020, 16:30:50.541    2020-12-17 14:30:50.541 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [io-8080-exec-25] o.s.security.web.FilterChainProxy        : /api/notification/search-tasks?conversations=true&pageNumber=0&pageSize=SIZE_10&sortDescending=true at position 1 of 15 in additional filter chain; firing Filter: 'WebAsyncManagerIntegrationFilter'   backend develop-dev-roscap
  148.     December 17th 2020, 16:30:50.541    2020-12-17 14:30:50.541 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [io-8080-exec-25] o.s.security.web.FilterChainProxy        : /api/notification/search-tasks?conversations=true&pageNumber=0&pageSize=SIZE_10&sortDescending=true at position 2 of 15 in additional filter chain; firing Filter: 'SecurityContextPersistenceFilter'   backend develop-dev-roscap
  149.     December 17th 2020, 16:30:50.543    2020-12-17 14:30:50.543 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [io-8080-exec-25] w.c.HttpSessionSecurityContextRepository : Obtained a valid SecurityContext from SPRING_SECURITY_CONTEXT: 'org.springframework.security.core.context.SecurityContextImpl@8a123b6d: Authentication: ru.lanit.rbs.authapi.dto.UserAuthentication@8a123b6d: Principal: ru.lanit.rbs.authapi.dto.ppa.PpaUserData@75edc4a9; Credentials: [PROTECTED]; Authenticated: true; Details: null; Not granted any authorities'  backend develop-dev-roscap
  150.     December 17th 2020, 16:30:50.543    2020-12-17 14:30:50.543 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [io-8080-exec-25] o.s.security.web.FilterChainProxy        : /api/notification/search-tasks?conversations=true&pageNumber=0&pageSize=SIZE_10&sortDescending=true at position 4 of 15 in additional filter chain; firing Filter: 'CsrfFilter' backend develop-dev-roscap
  151.     December 17th 2020, 16:30:50.543    2020-12-17 14:30:50.543 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [io-8080-exec-25] o.s.security.web.FilterChainProxy        : /api/notification/search-tasks?conversations=true&pageNumber=0&pageSize=SIZE_10&sortDescending=true at position 3 of 15 in additional filter chain; firing Filter: 'HeaderWriterFilter' backend develop-dev-roscap
  152.     December 17th 2020, 16:30:50.544    2020-12-17 14:30:50.544 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [io-8080-exec-25] o.s.security.web.FilterChainProxy        : /api/notification/search-tasks?conversations=true&pageNumber=0&pageSize=SIZE_10&sortDescending=true at position 6 of 15 in additional filter chain; firing Filter: 'SessionAuthenticationFilter'    backend develop-dev-roscap
  153.     December 17th 2020, 16:30:50.544    2020-12-17 14:30:50.544 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [io-8080-exec-25] o.s.s.w.u.matcher.AntPathRequestMatcher  : Request 'GET /api/notification/search-tasks' doesn't match 'POST /logout'   backend develop-dev-roscap
  154.     December 17th 2020, 16:30:50.544    2020-12-17 14:30:50.544 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [io-8080-exec-25] o.s.security.web.FilterChainProxy        : /api/notification/search-tasks?conversations=true&pageNumber=0&pageSize=SIZE_10&sortDescending=true at position 7 of 15 in additional filter chain; firing Filter: 'RequestDataFilter'  backend develop-dev-roscap
  155.     December 17th 2020, 16:30:50.544    2020-12-17 14:30:50.544 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [io-8080-exec-25] o.s.security.web.FilterChainProxy        : /api/notification/search-tasks?conversations=true&pageNumber=0&pageSize=SIZE_10&sortDescending=true at position 5 of 15 in additional filter chain; firing Filter: 'LogoutFilter'   backend develop-dev-roscap
  156.     December 17th 2020, 16:30:50.544    2020-12-17 14:30:50.543 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [io-8080-exec-25] o.s.s.w.util.matcher.AndRequestMatcher   : Trying to match using org.springframework.security.web.csrf.CsrfFilter$DefaultRequiresCsrfMatcher@759e29c9  backend develop-dev-roscap
  157.     December 17th 2020, 16:30:50.544    2020-12-17 14:30:50.544 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [io-8080-exec-25] o.s.s.w.util.matcher.AndRequestMatcher   : Did not match   backend develop-dev-roscap
  158.     December 17th 2020, 16:30:56.449    2020-12-17 14:30:56.448 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [lTaskExecutor-3] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: aVrr57 aVrr57Response = {"agreementBsId":11016,"budgetReportInfoByPerformerIdsByObjectIds":{"994":{"5":[{"bankDetailsRootId":658,"itemsByRootId":{}}],"25":[{"bankDetailsRootId":429,"itemsByRootId":{"1":{"expenseDistributionItemRootId":1,"expenseDistributionItemBusinessCode":"1","value":"Глава 1. Стоимость земельного участка и расходы по его содержанию","sortOrder":10000000000,"limitWithVat":1320002.00,"childrenItems":{"2":{"expenseDistributionItemRootId":2,"expenseDistributionItemBusinessCode":"1.1.1","value":"Затраты на приобретение прав на ЗУ","sortOrder":10100000000,"limitWithVat":20002.00,"childrenItems":{}},"3":{"expenseDistributionItemRootId":3,"expenseDistributionItemBusinessCode":"1.1.2","value":"Договор освоении территории в целях строительства стандартного жилья и связанные с его исполнением","sortOrder":10200000000,"limitWithVat":1200000.00,"childrenItems":{}},"4":{"expenseDistributionItemRootId":4,"expenseDistributionItemBusinessCode":"1.1.3","value":"Договор о развитии застроенной территории","sortOrder":10300000000,"limitWithVat":100000.00,"childrenItems":{}}}},"10":{"expenseDistributionItemRootId":10,"expenseDistributionItemBusinessCode":"2","value":"Глава 2. Стоимость строительства","sortOrder":50000000000,"limitWithVat":100000.00,"childrenItems":{"11":{"expenseDistributionItemRootId":11,"expenseDistributionItemBusinessCode":"2.1","value":"Подготовительный период","sortOrder":50100000000,"limitWithVat":100000.00,"childrenItems":{}}}},"88":{"expenseDistributionItemRootId":88,"expenseDistributionItemBusinessCode":"3","value":"Глава 3. Коммерческие расходы","sortOrder":70000000000,"limitWithVat":1000000.00,"childrenItems":{"89":{"expenseDistributionItemRootId":89,"expenseDistributionItemBusinessCode":"3.3.1","value":"Реклама","sortOrder":70100000000,"limitWithVat":1000000.00,"childrenItems":{"1108":{"expenseDistributionItemRootId":1108,"expenseDistributionItemBusinessCode":"3.3.1.0","value":"Работы/услуги сторонних организаций","sortOrder":70101000000,"limitWithVat":1000000.00,"childrenItems":{}}}},"93":{"expenseDistributionItemRootId":93,"expenseDistributionItemBusinessCode":"3.3.5","value":"Услуги банка","sortOrder":70500000000,"limitWithVat":0,"childrenItems":{}}}},"1175":{"expenseDistributionItemRootId":1175,"expenseDistributionItemBusinessCode":"3","value":"Расходы на организацию работ и обслуживание работников","sortOrder":80000000000,"limitWithVat":719998.00,"childrenItems":{"1177":{"expenseDistributionItemRootId":1177,"expenseDistributionItemBusinessCode":"3.2","value":"Приобретение оргтехники и расходных материалов","sortOrder":80200000000,"limitWithVat":200000.00,"childrenItems":{}},"1178":{"expenseDistributionItemRootId":1178,"expenseDistributionItemBusinessCode":"3.3","value":"Расходы на служебные командировки","sortOrder":80300000000,"limitWithVat":519000.00,"childrenItems":{}},"1179":{"expenseDistributionItemRootId":1179,"expenseDistributionItemBusinessCode":"3.4","value":"Расходы на охрану (сторожевую, пожарную)","sortOrder":80400000000,"limitWithVat":998.00,"childrenItems":{}}}},"1182":{"expenseDistributionItemRootId":1182,"expenseDistributionItemBusinessCode":"4","value":"Возврат","sortOrder":100000000000,"limitWithVat":200000.00,"childrenItems":{}},"1183":{"expenseDistributionItemRootId":1183,"expenseDistributionItemBusinessCode":"6","value":"Перенос остатка на новый счет в связи с реорганизацией обслуживающего счет подразделения","sortOrder":110000000000,"limitWithVat":200000.00,"childrenItems":{}}}}]},"995":{"5":[{"bankDetailsRootId":658,"itemsByRootId":{}}],"25":[{"bankDetailsRootId":429,"itemsByRootId":{"1":{"expenseDistributionItemRootId":1,"expenseDistributionItemBusinessCode":"1","value":"Глава 1. Стоимость земельного участка и расходы по его содержанию","sortOrder":10000000000,"limitWithVat":1320002.00,"childrenItems":{"2":{"expenseDistributionItemRootId":2,"expenseDistributionItemBusinessCode":"1.1.1","value":"Затраты на приобретение прав на ЗУ","sortOrder":10100000000,"limitWithVat":20002.00,"childrenItems":{}},"3":{"expenseDistributionItemRootId":3,"expenseDistributionItemBusinessCode":"1.1.2","value":"Договор освоении территории в целях строительства стандартного жилья и связанные с его исполнением","sortOrder":10200000000,"limitWithVat":1200000.00,"childrenItems":{}},"4":{"expenseDistributionItemRootId":4,"expenseDistributionItemBusinessCode":"1.1.3","value":"Договор о развитии застроенной территории","sortOrder":10300000000,"limitWithVat":100000.00,"childrenItems":{}}}},"10":{"expenseDistributionItemRootId":10,"expenseDistributionItemBusinessCode":"2","value":"Глава 2. Стоимость строительства","sortOrder":50000000000,"limitWithVat":100000.00,"childrenItems":{"11":{"expenseDistributionItemRootId":11,"expenseDistributionItemBusinessCode":"2.1","value":"Подготовительный период","sortOrder":50100000000,"limitWithVat":100000.00,"childrenItems":{}}}},"88":{"expenseDistributionItemRootId":88,"expenseDistributionItemBusinessCode":"3","value":"Глава 3. Коммерческие расходы","sortOrder":70000000000,"limitWithVat":1000000.00,"childrenItems":{"89":{"expenseDistributionItemRootId":89,"expenseDistributionItemBusinessCode":"3.3.1","value":"Реклама","sortOrder":70100000000,"limitWithVat":1000000.00,"childrenItems":{"1108":{"expenseDistributionItemRootId":1108,"expenseDistributionItemBusinessCode":"3.3.1.0","value":"Работы/услуги сторонних организаций","sortOrder":70101000000,"limitWithVat":1000000.00,"childrenItems":{}}}},"93":{"expenseDistributionItemRootId":93,"expenseDistributionItemBusinessCode":"3.3.5","value":"Услуги банка","sortOrder":70500000000,"limitWithVat":0,"childrenItems":{}}}},"1175":{"expenseDistributionItemRootId":1175,"expenseDistributionItemBusinessCode":"3","value":"Расходы на организацию работ и обслуживание работников","sortOrder":80000000000,"limitWithVat":719998.00,"childrenItems":{"1177":{"expenseDistributionItemRootId":1177,"expenseDistributionItemBusinessCode":"3.2","value":"Приобретение оргтехники и расходных материалов","sortOrder":80200000000,"limitWithVat":200000.00,"childrenItems":{}},"1178":{"expenseDistributionItemRootId":1178,"expenseDistributionItemBusinessCode":"3.3","value":"Расходы на служебные командировки","sortOrder":80300000000,"limitWithVat":519000.00,"childrenItems":{}},"1179":{"expenseDistributionItemRootId":1179,"expenseDistributionItemBusinessCode":"3.4","value":"Расходы на охрану (сторожевую, пожарную)","sortOrder":80400000000,"limitWithVat":998.00,"childrenItems":{}}}},"1182":{"expenseDistributionItemRootId":1182,"expenseDistributionItemBusinessCode":"4","value":"Возврат","sortOrder":100000000000,"limitWithVat":200000.00,"childrenItems":{}},"1183":{"expenseDistributionItemRootId":1183,"expenseDistributionItemBusinessCode":"6","value":"Перенос остатка на новый счет в связи с реорганизацией обслуживающего счет подразделения","sortOrder":110000000000,"limitWithVat":200000.00,"childrenItems":{}}}}]},"996":{"5":[{"bankDetailsRootId":658,"itemsByRootId":{}}],"25":[{"bankDetailsRootId":429,"itemsByRootId":{"1":{"expenseDistributionItemRootId":1,"expenseDistributionItemBusinessCode":"1","value":"Глава 1. Стоимость земельного участка и расходы по его содержанию","sortOrder":10000000000,"limitWithVat":1320002.00,"childrenItems":{"2":{"expenseDistributionItemRootId":2,"expenseDistributionItemBusinessCode":"1.1.1","value":"Затраты на приобретение прав на ЗУ","sortOrder":10100000000,"limitWithVat":20002.00,"childrenItems":{}},"3":{"expenseDistributionItemRootId":3,"expenseDistributionItemBusinessCode":"1.1.2","value":"Договор освоении территории в целях строительства стандартного жилья и связанные с его исполнением","sortOrder":10200000000,"limitWithVat":1200000.00,"childrenItems":{}},"4":{"expenseDistributionItemRootId":4,"expenseDistributionItemBusinessCode":"1.1.3","value":"Договор о развитии застроенной территории","sortOrder":10300000000,"limitWithVat":100000.00,"childrenItems":{}}}},"10":{"expenseDistributionItemRootId":10,"expenseDistributionItemBusinessCode":"2","value":"Глава 2. Стоимость строительства","sortOrder":50000000000,"limitWithVat":100000.00,"childrenItems":{"11":{"expenseDistributionItemRootId":11,"expenseDistributionItemBusinessCode":"2.1","value":"Подготовительный период","sortOrder":50100000000,"limitWithVat":100000.00,"childrenItems":{}}}},"88":{"expenseDistributionItemRootId":88,"expenseDistributionItemBusinessCode":"3","value":"Глава 3. Коммерческие расходы","sortOrder":70000000000,"limitWithVat":1000000.00,"childrenItems":{"89":{"expenseDistributionItemRootId":89,"expenseDistributionItemBusinessCode":"3.3.1","value":"Реклама","sortOrder":70100000000,"limitWithVat":1000000.00,"childrenItems":{"1108":{"expenseDistributionItemRootId":1108,"expenseDistributionItemBusinessCode":"3.3.1.0","value":"Работы/услуги сторонних организаций","sortOrder":70101000000,"limitWithVat":1000000.00,"childrenItems":{}}}},"93":{"expenseDistributionItemRootId":93,"expenseDistributionItemBusinessCode":"3.3.5","value":"Услуги банка","sortOrder":70500000000,"limitWithVat":0,"childrenItems":{}}}},"1175":{"expenseDistributionItemRootId":1175,"expenseDistributionItemBusinessCode":"3","value":"Расходы на организацию работ и обслуживание работников","sortOrder":80000000000,"limitWithVat":719998.00,"childrenItems":{"1177":{"expenseDistributionItemRootId":1177,"expenseDistributionItemBusinessCode":"3.2","value":"Приобретение оргтехники и расходных материалов","sortOrder":80200000000,"limitWithVat":200000.00,"childrenItems":{}},"1178":{"expenseDistributionItemRootId":1178,"expenseDistributionItemBusinessCode":"3.3","value":"Расходы на служебные командировки","sortOrder":80300000000,"limitWithVat":519000.00,"childrenItems":{}},"1179":{"expenseDistributionItemRootId":1179,"expenseDistributionItemBusinessCode":"3.4","value":"Расходы на охрану (сторожевую, пожарную)","sortOrder":80400000000,"limitWithVat":998.00,"childrenItems":{}}}},"1182":{"expenseDistributionItemRootId":1182,"expenseDistributionItemBusinessCode":"4","value":"Возврат","sortOrder":100000000000,"limitWithVat":200000.00,"childrenItems":{}},"1183":{"expenseDistributionItemRootId":1183,"expenseDistributionItemBusinessCode":"6","value":"Перенос остатка на новый счет в связи с реорганизацией обслуживающего счет подразделения","sortOrder":110000000000,"limitWithVat":200000.00,"childrenItems":{}}}}]},"997":{"5":[{"bankDetailsRootId":658,"itemsByRootId":{}}],"25":[{"bankDetailsRootId":429,"itemsByRootId":{"1":{"expenseDistributionItemRootId":1,"expenseDistributionItemBusinessCode":"1","value":"Глава 1. Стоимость земельного участка и расходы по его содержанию","sortOrder":10000000000,"limitWithVat":1320002.00,"childrenItems":{"2":{"expenseDistributionItemRootId":2,"expenseDistributionItemBusinessCode":"1.1.1","value":"Затраты на приобретение прав на ЗУ","sortOrder":10100000000,"limitWithVat":20002.00,"childrenItems":{}},"3":{"expenseDistributionItemRootId":3,"expenseDistributionItemBusinessCode":"1.1.2","value":"Договор освоении территории в целях строительства стандартного жилья и связанные с его исполнением","sortOrder":10200000000,"limitWithVat":1200000.00,"childrenItems":{}},"4":{"expenseDistributionItemRootId":4,"expenseDistributionItemBusinessCode":"1.1.3","value":"Договор о развитии застроенной территории","sortOrder":10300000000,"limitWithVat":100000.00,"childrenItems":{}}}},"10":{"expenseDistributionItemRootId":10,"expenseDistributionItemBusinessCode":"2","value":"Глава 2. Стоимость строительства","sortOrder":50000000000,"limitWithVat":100000.00,"childrenItems":{"11":{"expenseDistributionItemRootId":11,"expenseDistributionItemBusinessCode":"2.1","value":"Подготовительный период","sortOrder":50100000000,"limitWithVat":100000.00,"childrenItems":{}}}},"88":{"expenseDistributionItemRootId":88,"expenseDistributionItemBusinessCode":"3","value":"Глава 3. Коммерческие расходы","sortOrder":70000000000,"limitWithVat":1000000.00,"childrenItems":{"89":{"expenseDistributionItemRootId":89,"expenseDistributionItemBusinessCode":"3.3.1","value":"Реклама","sortOrder":70100000000,"limitWithVat":1000000.00,"childrenItems":{"1108":{"expenseDistributionItemRootId":1108,"expenseDistributionItemBusinessCode":"3.3.1.0","value":"Работы/услуги сторонних организаций","sortOrder":70101000000,"limitWithVat":1000000.00,"childrenItems":{}}}},"93":{"expenseDistributionItemRootId":93,"expenseDistributionItemBusinessCode":"3.3.5","value":"Услуги банка","sortOrder":70500000000,"limitWithVat":0,"childrenItems":{}}}},"1175":{"expenseDistributionItemRootId":1175,"expenseDistributionItemBusinessCode":"3","value":"Расходы на организацию работ и обслуживание работников","sortOrder":80000000000,"limitWithVat":719998.00,"childrenItems":{"1177":{"expenseDistributionItemRootId":1177,"expenseDistributionItemBusinessCode":"3.2","value":"Приобретение оргтехники и расходных материалов","sortOrder":80200000000,"limitWithVat":200000.00,"childrenItems":{}},"1178":{"expenseDistributionItemRootId":1178,"expenseDistributionItemBusinessCode":"3.3","value":"Расходы на служебные командировки","sortOrder":80300000000,"limitWithVat":519000.00,"childrenItems":{}},"1179":{"expenseDistributionItemRootId":1179,"expenseDistributionItemBusinessCode":"3.4","value":"Расходы на охрану (сторожевую, пожарную)","sortOrder":80400000000,"limitWithVat":998.00,"childrenItems":{}}}},"1182":{"expenseDistributionItemRootId":1182,"expenseDistributionItemBusinessCode":"4","value":"Возврат","sortOrder":100000000000,"limitWithVat":200000.00,"childrenItems":{}},"1183":{"expenseDistributionItemRootId":1183,"expenseDistributionItemBusinessCode":"6","value":"Перенос остатка на новый счет в связи с реорганизацией обслуживающего счет подразделения","sortOrder":110000000000,"limitWithVat":200000.00,"childrenItems":{}}}}]},"998":{"5":[{"bankDetailsRootId":658,"itemsByRootId":{}}],"25":[{"bankDetailsRootId":429,"itemsByRootId":{"1":{"expenseDistributionItemRootId":1,"expenseDistributionItemBusinessCode":"1","value":"Глава 1. Стоимость земельного уч��стка и расходы по его содержанию","sortOrder":10000000000,"limitWithVat":1320002.00,"childrenItems":{"2":{"expenseDistributionItemRootId":2,"expenseDistributionItemBusinessCode":"1.1.1","value":"Затраты на приобретение прав на ЗУ","sortOrder":10100000000,"limitWithVat":20002.00,"childrenItems":{}},"3":{"expenseDistributionItemRootId":3,"expenseDistributionItemBusinessCode":"1.1.2","value":"Договор освоении территории в целях строительства стандартного жилья и связанные с его исполнением","sortOrder":10200000000,"limitWithVat":1200000.00,"childrenItems":{}},"4":{"expenseDistributionItemRootId":4,"expenseDistributionItemBusinessCode":"1.1.3","value":"Договор о развитии застроенной территории","sortOrder":10300000000,"limitWithVat":100000.00,"childrenItems":{}}}},"10":{"expenseDistributionItemRootId":10,"expenseDistributionItemBusinessCode":"2","value":"Глава 2. Стоимость строительства","sortOrder":50000000000,"limitWithVat":100000.00,"childrenItems":{"11":{"expenseDistributionItemRootId":11,"expenseDistributionItemBusinessCode":"2.1","value":"Подготовительный период","sortOrder":50100000000,"limitWithVat":100000.00,"childrenItems":{}}}},"88":{"expenseDistributionItemRootId":88,"expenseDistributionItemBusinessCode":"3","value":"Глава 3. Коммерческие расходы","sortOrder":70000000000,"limitWithVat":1000000.00,"childrenItems":{"89":{"expenseDistributionItemRootId":89,"expenseDistributionItemBusinessCode":"3.3.1","value":"Реклама","sortOrder":70100000000,"limitWithVat":1000000.00,"childrenItems":{"1108":{"expenseDistributionItemRootId":1108,"expenseDistributionItemBusinessCode":"3.3.1.0","value":"Работы/услуги сторонних организаций","sortOrder":70101000000,"limitWithVat":1000000.00,"childrenItems":{}}}},"93":{"expenseDistributionItemRootId":93,"expenseDistributionItemBusinessCode":"3.3.5","value":"Услуги банка","sortOrder":70500000000,"limitWithVat":0,"childrenItems":{}}}},"1175":{"expenseDistributionItemRootId":1175,"expenseDistributionItemBusinessCode":"3","value":"Расходы на организацию работ и обслуживание работников","sortOrder":80000000000,"limitWithVat":719998.00,"childrenItems":{"1177":{"expenseDistributionItemRootId":1177,"expenseDistributionItemBusinessCode":"3.2","value":"Приобретение оргтехники и расходных материалов","sortOrder":80200000000,"limitWithVat":200000.00,"childrenItems":{}},"1178":{"expenseDistributionItemRootId":1178,"expenseDistributionItemBusinessCode":"3.3","value":"Расходы на служебные командировки","sortOrder":80300000000,"limitWithVat":519000.00,"childrenItems":{}},"1179":{"expenseDistributionItemRootId":1179,"expenseDistributionItemBusinessCode":"3.4","value":"Расходы на охрану (сторожевую, пожарную)","sortOrder":80400000000,"limitWithVat":998.00,"childrenItems":{}}}},"1182":{"expenseDistributionItemRootId":1182,"expenseDistributionItemBusinessCode":"4","value":"Возврат","sortOrder":100000000000,"limitWithVat":200000.00,"childrenItems":{}},"1183":{"expenseDistributionItemRootId":1183,"expenseDistributionItemBusinessCode":"6","value":"Перенос остатка на новый счет в связи с реорганизацией обслуживающего счет подразделения","sortOrder":110000000000,"limitWithVat":200000.00,"childrenItems":{}}}}]},"999":{"5":[{"bankDetailsRootId":658,"itemsByRootId":{}}],"25":[{"bankDetailsRootId":429,"itemsByRootId":{"1":{"expenseDistributionItemRootId":1,"expenseDistributionItemBusinessCode":"1","value":"Глава 1. Стоимость земельного участка и расходы по его содержанию","sortOrder":10000000000,"limitWithVat":1320002.00,"childrenItems":{"2":{"expenseDistributionItemRootId":2,"expenseDistributionItemBusinessCode":"1.1.1","value":"Затраты на приобретение прав на ЗУ","sortOrder":10100000000,"limitWithVat":20002.00,"childrenItems":{}},"3":{"expenseDistributionItemRootId":3,"expenseDistributionItemBusinessCode":"1.1.2","value":"Договор освоении территории в целях строительства стандартного жилья и связанные с его исполнением","sortOrder":10200000000,"limitWithVat":1200000.00,"childrenItems":{}},"4":{"expenseDistributionItemRootId":4,"expenseDistributionItemBusinessCode":"1.1.3","value":"Договор о развитии застроенной территории","sortOrder":10300000000,"limitWithVat":100000.00,"childrenItems":{}}}},"10":{"expenseDistributionItemRootId":10,"expenseDistributionItemBusinessCode":"2","value":"Глава 2. Стоимость строительства","sortOrder":50000000000,"limitWithVat":100000.00,"childrenItems":{"11":{"expenseDistributionItemRootId":11,"expenseDistributionItemBusinessCode":"2.1","value":"Подготовительный период","sortOrder":50100000000,"limitWithVat":100000.00,"childrenItems":{}}}},"88":{"expenseDistributionItemRootId":88,"expenseDistributionItemBusinessCode":"3","value":"Глава 3. Коммерческие расходы","sortOrder":70000000000,"limitWithVat":1000000.00,"childrenItems":{"89":{"expenseDistributionItemRootId":89,"expenseDistributionItemBusinessCode":"3.3.1","value":"Реклама","sortOrder":70100000000,"limitWithVat":1000000.00,"childrenItems":{"1108":{"expenseDistributionItemRootId":1108,"expenseDistributionItemBusinessCode":"3.3.1.0","value":"Работы/услуги сторонних организаций","sortOrder":70101000000,"limitWithVat":1000000.00,"childrenItems":{}}}},"93":{"expenseDistributionItemRootId":93,"expenseDistributionItemBusinessCode":"3.3.5","value":"Услуги банка","sortOrder":70500000000,"limitWithVat":0,"childrenItems":{}}}},"1175":{"expenseDistributionItemRootId":1175,"expenseDistributionItemBusinessCode":"3","value":"Расходы на организацию работ и обслуживание работников","sortOrder":80000000000,"limitWithVat":719998.00,"childrenItems":{"1177":{"expenseDistributionItemRootId":1177,"expenseDistributionItemBusinessCode":"3.2","value":"Приобретение оргтехники и расходных материалов","sortOrder":80200000000,"limitWithVat":200000.00,"childrenItems":{}},"1178":{"expenseDistributionItemRootId":1178,"expenseDistributionItemBusinessCode":"3.3","value":"Расходы на служебные командировки","sortOrder":80300000000,"limitWithVat":519000.00,"childrenItems":{}},"1179":{"expenseDistributionItemRootId":1179,"expenseDistributionItemBusinessCode":"3.4","value":"Расходы на охрану (сторожевую, пожарную)","sortOrder":80400000000,"limitWithVat":998.00,"childrenItems":{}}}},"1182":{"expenseDistributionItemRootId":1182,"expenseDistributionItemBusinessCode":"4","value":"Возврат","sortOrder":100000000000,"limitWithVat":200000.00,"childrenItems":{}},"1183":{"expenseDistributionItemRootId":1183,"expenseDistributionItemBusinessCode":"6","value":"Перенос остатка на новый счет в связи с реорганизацией обслуживающего счет подразделения","sortOrder":110000000000,"limitWithVat":200000.00,"childrenItems":{}}}}]}}}  backend develop-dev-roscap
  159.     December 17th 2020, 16:30:56.450    2020-12-17 14:30:56.449 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [lTaskExecutor-3] r.l.r.r.impl.helper.ReportRequestHelper  : Creating dateSearchCriteria for A_PD_* algorithm; period='startDate=2020-11-24, endDate=2020-12-17'
  160. Hibernate: select participan0_.agreement_id as agreemen8_31_0_, participan0_.id as id1_31_0_, participan0_.id as id1_31_1_, participan0_.last_editing_date as last_edi2_31_1_, participan0_.agreement_id as agreemen8_31_1_, participan0_.bank_details_id as bank_det3_31_1_, participan0_.fund_subject as fund_sub4_31_1_, participan0_.organization_version_id as organiza5_31_1_, participan0_.organization_id as organiza6_31_1_, participan0_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_participant participan0_ where participan0_.agreement_id=?
  161. Hibernate: select participan0_.agreement_id as agreemen8_31_0_, participan0_.id as id1_31_0_, participan0_.id as id1_31_1_, participan0_.last_editing_date as last_edi2_31_1_, participan0_.agreement_id as agreemen8_31_1_, participan0_.bank_details_id as bank_det3_31_1_, participan0_.fund_subject as fund_sub4_31_1_, participan0_.organization_version_id as organiza5_31_1_, participan0_.organization_id as organiza6_31_1_, participan0_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_participant participan0_ where participan0_.agreement_id=?  backend develop-dev-roscap
  162.     December 17th 2020, 16:30:56.450    2020-12-17 14:30:56.449 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [lTaskExecutor-3] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: case: REPORT_4 backend develop-dev-roscap
  163.     December 17th 2020, 16:30:56.459    2020-12-17 14:30:56.458 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [lTaskExecutor-3] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: A_PD_58 params = {"agreementBs":[{"agreementBsRootId":11016,"performers":[{"payerOrgRootId":25,"agreementBsObjects":[{"agreementBsObjectRootId":995,"bankDetails":[{"bankDetailsRootId":429,"expenseDistributionItemRootIds":[1,2,3,4,10,11,1108,1175,88,89,1177,1178,1179,93,1182,1183]}]}]},{"payerOrgRootId":5,"agreementBsObjects":[{"agreementBsObjectRootId":994,"bankDetails":[]}]},{"payerOrgRootId":25,"agreementBsObjects":[{"agreementBsObjectRootId":994,"bankDetails":[{"bankDetailsRootId":429,"expenseDistributionItemRootIds":[1,2,3,4,10,11,1108,1175,88,89,1177,1178,1179,93,1182,1183]}]}]},{"payerOrgRootId":5,"agreementBsObjects":[{"agreementBsObjectRootId":998,"bankDetails":[]}]},{"payerOrgRootId":5,"agreementBsObjects":[{"agreementBsObjectRootId":996,"bankDetails":[]}]},{"payerOrgRootId":25,"agreementBsObjects":[{"agreementBsObjectRootId":997,"bankDetails":[{"bankDetailsRootId":429,"expenseDistributionItemRootIds":[1,2,3,4,10,11,1108,1175,88,89,1177,1178,1179,93,1182,1183]}]}]},{"payerOrgRootId":25,"agreementBsObjects":[{"agreementBsObjectRootId":999,"bankDetails":[{"bankDetailsRootId":429,"expenseDistributionItemRootIds":[1,2,3,4,10,11,1108,1175,88,89,1177,1178,1179,93,1182,1183]}]}]},{"payerOrgRootId":25,"agreementBsObjects":[{"agreementBsObjectRootId":996,"bankDetails":[{"bankDetailsRootId":429,"expenseDistributionItemRootIds":[1,2,3,4,10,11,1108,1175,88,89,1177,1178,1179,93,1182,1183]}]}]},{"payerOrgRootId":5,"agreementBsObjects":[{"agreementBsObjectRootId":995,"bankDetails":[]}]},{"payerOrgRootId":25,"agreementBsObjects":[{"agreementBsObjectRootId":998,"bankDetails":[{"bankDetailsRootId":429,"expenseDistributionItemRootIds":[1,2,3,4,10,11,1108,1175,88,89,1177,1178,1179,93,1182,1183]}]}]},{"payerOrgRootId":5,"agreementBsObjects":[{"agreementBsObjectRootId":999,"bankDetails":[]}]},{"payerOrgRootId":5,"agreementBsObjects":[{"agreementBsObjectRootId":997,"bankDetails":[]}]}]}],"paymentOrderReportSearchDate":{"datePeriod":{"startDate":{"year":2020,"month":11,"day":24},"endDate":{"year":2020,"month":12,"day":17}}}}
  164. Hibernate: select participan0_.agreement_id as agreemen8_31_0_, participan0_.id as id1_31_0_, participan0_.id as id1_31_1_, participan0_.last_editing_date as last_edi2_31_1_, participan0_.agreement_id as agreemen8_31_1_, participan0_.bank_details_id as bank_det3_31_1_, participan0_.fund_subject as fund_sub4_31_1_, participan0_.organization_version_id as organiza5_31_1_, participan0_.organization_id as organiza6_31_1_, participan0_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_participant participan0_ where participan0_.agreement_id=?
  165. Hibernate: select participan0_.agreement_id as agreemen8_31_0_, participan0_.id as id1_31_0_, participan0_.id as id1_31_1_, participan0_.last_editing_date as last_edi2_31_1_, participan0_.agreement_id as agreemen8_31_1_, participan0_.bank_details_id as bank_det3_31_1_, participan0_.fund_subject as fund_sub4_31_1_, participan0_.organization_version_id as organiza5_31_1_, participan0_.organization_id as organiza6_31_1_, participan0_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_participant participan0_ where participan0_.agreement_id=?
  166. Hibernate: select participan0_.agreement_id as agreemen8_31_0_, participan0_.id as id1_31_0_, participan0_.id as id1_31_1_, participan0_.last_editing_date as last_edi2_31_1_, participan0_.agreement_id as agreemen8_31_1_, participan0_.bank_details_id as bank_det3_31_1_, participan0_.fund_subject as fund_sub4_31_1_, participan0_.organization_version_id as organiza5_31_1_, participan0_.organization_id as organiza6_31_1_, participan0_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_participant participan0_ where participan0_.agreement_id=?
  167. Hibernate: select participan0_.agreement_id as agreemen8_31_0_, participan0_.id as id1_31_0_, participan0_.id as id1_31_1_, participan0_.last_editing_date as last_edi2_31_1_, participan0_.agreement_id as agreemen8_31_1_, participan0_.bank_details_id as bank_det3_31_1_, participan0_.fund_subject as fund_sub4_31_1_, participan0_.organization_version_id as organiza5_31_1_, participan0_.organization_id as organiza6_31_1_, participan0_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_participant participan0_ where participan0_.agreement_id=?
  168. Hibernate: select participan0_.agreement_id as agreemen8_31_0_, participan0_.id as id1_31_0_, participan0_.id as id1_31_1_, participan0_.last_editing_date as last_edi2_31_1_, participan0_.agreement_id as agreemen8_31_1_, participan0_.bank_details_id as bank_det3_31_1_, participan0_.fund_subject as fund_sub4_31_1_, participan0_.organization_version_id as organiza5_31_1_, participan0_.organization_id as organiza6_31_1_, participan0_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_participant participan0_ where participan0_.agreement_id=?  backend develop-dev-roscap
  169.     December 17th 2020, 16:30:56.612    2020-12-17 14:30:56.612 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [lTaskExecutor-3] r.l.r.p.impl.service.algorithm.A_PD_58   : Method executed in 113 milliseconds backend develop-dev-roscap
  170.     December 17th 2020, 16:30:56.621    2020-12-17 14:30:56.617 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [lTaskExecutor-3] r.l.r.report.impl.algorithm.ReportA_O_2  : Trace-A_O_2: A_PD_58 aPd58Result = {"successType":"TYPE_2"} backend develop-dev-roscap
  171.     December 17th 2020, 16:30:56.621    2020-12-17 14:30:56.617 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [lTaskExecutor-3] r.l.r.report.impl.algorithm.ReportA_O_2  : A_O_2: reports data collection completed    backend develop-dev-roscap
  172.     December 17th 2020, 16:30:56.621    2020-12-17 14:30:56.618 DEBUG 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [lTaskExecutor-3] r.l.r.report.impl.algorithm.ReportA_O_5  : Data isn't found for report agreementRootId=11016, agreementNumber=БС2020-АК20811202, objectNumbers=[А-1231], reportKinds=[REPORT_4]
  173. Hibernate: select participan0_.agreement_id as agreemen8_31_0_, participan0_.id as id1_31_0_, participan0_.id as id1_31_1_, participan0_.last_editing_date as last_edi2_31_1_, participan0_.agreement_id as agreemen8_31_1_, participan0_.bank_details_id as bank_det3_31_1_, participan0_.fund_subject as fund_sub4_31_1_, participan0_.organization_version_id as organiza5_31_1_, participan0_.organization_id as organiza6_31_1_, participan0_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_participant participan0_ where participan0_.agreement_id=?
  174. Hibernate: select participan0_.agreement_id as agreemen8_31_0_, participan0_.id as id1_31_0_, participan0_.id as id1_31_1_, participan0_.last_editing_date as last_edi2_31_1_, participan0_.agreement_id as agreemen8_31_1_, participan0_.bank_details_id as bank_det3_31_1_, participan0_.fund_subject as fund_sub4_31_1_, participan0_.organization_version_id as organiza5_31_1_, participan0_.organization_id as organiza6_31_1_, participan0_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_participant participan0_ where participan0_.agreement_id=?
  175. Hibernate: select participan0_.agreement_id as agreemen8_31_0_, participan0_.id as id1_31_0_, participan0_.id as id1_31_1_, participan0_.last_editing_date as last_edi2_31_1_, participan0_.agreement_id as agreemen8_31_1_, participan0_.bank_details_id as bank_det3_31_1_, participan0_.fund_subject as fund_sub4_31_1_, participan0_.organization_version_id as organiza5_31_1_, participan0_.organization_id as organiza6_31_1_, participan0_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_participant participan0_ where participan0_.agreement_id=?
  176. Hibernate: select participan0_.agreement_id as agreemen8_31_0_, participan0_.id as id1_31_0_, participan0_.id as id1_31_1_, participan0_.last_editing_date as last_edi2_31_1_, participan0_.agreement_id as agreemen8_31_1_, participan0_.bank_details_id as bank_det3_31_1_, participan0_.fund_subject as fund_sub4_31_1_, participan0_.organization_version_id as organiza5_31_1_, participan0_.organization_id as organiza6_31_1_, participan0_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_participant participan0_ where participan0_.agreement_id=?
  177. Hibernate: select participan0_.agreement_id as agreemen8_31_0_, participan0_.id as id1_31_0_, participan0_.id as id1_31_1_, participan0_.last_editing_date as last_edi2_31_1_, participan0_.agreement_id as agreemen8_31_1_, participan0_.bank_details_id as bank_det3_31_1_, participan0_.fund_subject as fund_sub4_31_1_, participan0_.organization_version_id as organiza5_31_1_, participan0_.organization_id as organiza6_31_1_, participan0_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_participant participan0_ where participan0_.agreement_id=?
  178. Hibernate: select participan0_.agreement_id as agreemen8_31_0_, participan0_.id as id1_31_0_, participan0_.id as id1_31_1_, participan0_.last_editing_date as last_edi2_31_1_, participan0_.agreement_id as agreemen8_31_1_, participan0_.bank_details_id as bank_det3_31_1_, participan0_.fund_subject as fund_sub4_31_1_, participan0_.organization_version_id as organiza5_31_1_, participan0_.organization_id as organiza6_31_1_, participan0_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_participant participan0_ where participan0_.agreement_id=?
  179. Hibernate: select participan0_.agreement_id as agreemen8_31_0_, participan0_.id as id1_31_0_, participan0_.id as id1_31_1_, participan0_.last_editing_date as last_edi2_31_1_, participan0_.agreement_id as agreemen8_31_1_, participan0_.bank_details_id as bank_det3_31_1_, participan0_.fund_subject as fund_sub4_31_1_, participan0_.organization_version_id as organiza5_31_1_, participan0_.organization_id as organiza6_31_1_, participan0_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_participant participan0_ where participan0_.agreement_id=?  backend develop-dev-roscap
  180.     December 17th 2020, 16:30:56.621    2020-12-17 14:30:56.617  INFO 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [lTaskExecutor-3] r.l.r.r.impl.aspect.ExecutionTimeAspect  : ReportA_O_2.run Построение квартальных отчетов, выполнено за 11431мс   backend develop-dev-roscap
  181.     December 17th 2020, 16:30:56.852    2020-12-17 14:30:56.852  INFO 1 [1b269f03-55a1-46da-b43a-1e7c383cbb50] --- [lTaskExecutor-3] r.l.r.r.impl.aspect.ExecutionTimeAspect  : ReportA_O_5.run Формирование онлайн отчета (А_О_5), выполнено за 11751мс
  182. Hibernate: select participan0_.agreement_id as agreemen8_31_0_, participan0_.id as id1_31_0_, participan0_.id as id1_31_1_, participan0_.last_editing_date as last_edi2_31_1_, participan0_.agreement_id as agreemen8_31_1_, participan0_.bank_details_id as bank_det3_31_1_, participan0_.fund_subject as fund_sub4_31_1_, participan0_.organization_version_id as organiza5_31_1_, participan0_.organization_id as organiza6_31_1_, participan0_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_participant participan0_ where participan0_.agreement_id=?
  183. Hibernate: select participan0_.agreement_id as agreemen8_31_0_, participan0_.id as id1_31_0_, participan0_.id as id1_31_1_, participan0_.last_editing_date as last_edi2_31_1_, participan0_.agreement_id as agreemen8_31_1_, participan0_.bank_details_id as bank_det3_31_1_, participan0_.fund_subject as fund_sub4_31_1_, participan0_.organization_version_id as organiza5_31_1_, participan0_.organization_id as organiza6_31_1_, participan0_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_participant participan0_ where participan0_.agreement_id=?
  184. Hibernate: select participan0_.agreement_id as agreemen8_31_0_, participan0_.id as id1_31_0_, participan0_.id as id1_31_1_, participan0_.last_editing_date as last_edi2_31_1_, participan0_.agreement_id as agreemen8_31_1_, participan0_.bank_details_id as bank_det3_31_1_, participan0_.fund_subject as fund_sub4_31_1_, participan0_.organization_version_id as organiza5_31_1_, participan0_.organization_id as organiza6_31_1_, participan0_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_participant participan0_ where participan0_.agreement_id=?
  185. Hibernate: select participan0_.agreement_id as agreemen8_31_0_, participan0_.id as id1_31_0_, participan0_.id as id1_31_1_, participan0_.last_editing_date as last_edi2_31_1_, participan0_.agreement_id as agreemen8_31_1_, participan0_.bank_details_id as bank_det3_31_1_, participan0_.fund_subject as fund_sub4_31_1_, participan0_.organization_version_id as organiza5_31_1_, participan0_.organization_id as organiza6_31_1_, participan0_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_participant participan0_ where participan0_.agreement_id=?
  186. Hibernate: select participan0_.agreement_id as agreemen8_31_0_, participan0_.id as id1_31_0_, participan0_.id as id1_31_1_, participan0_.last_editing_date as last_edi2_31_1_, participan0_.agreement_id as agreemen8_31_1_, participan0_.bank_details_id as bank_det3_31_1_, participan0_.fund_subject as fund_sub4_31_1_, participan0_.organization_version_id as organiza5_31_1_, participan0_.organization_id as organiza6_31_1_, participan0_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_participant participan0_ where participan0_.agreement_id=?
  187. Hibernate: select participan0_.agreement_id as agreemen8_31_0_, participan0_.id as id1_31_0_, participan0_.id as id1_31_1_, participan0_.last_editing_date as last_edi2_31_1_, participan0_.agreement_id as agreemen8_31_1_, participan0_.bank_details_id as bank_det3_31_1_, participan0_.fund_subject as fund_sub4_31_1_, participan0_.organization_version_id as organiza5_31_1_, participan0_.organization_id as organiza6_31_1_, participan0_.participant_type_root_id as particip7_31_1_ from bagrsm.bagr_participant participan0_ where participan0_.agreement_id=?  backend develop-dev-roscap
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!