API tools faq
paste
Advertisement
DOS93

Untitled

DOS93
May 25th, 2021
273
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Apache Log 216.04 KB | None | 0 0
raw download clone embed print report
  1. May 25, 2021 @ 13:46:03.359 Десериализовано сообщение: {"entityRootId":35410,"entityVersionId":35410,"actionType":"AGREEMENT_BS_SENDING_TO_APPROVAL","bank":true,"initiator":null,"initiatorId"'true''true') where accessgrou0_.ppa_employee_id=?
  2. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  3. Hibernate: select nsisubdivi0_.id as id1_160_, nsisubdivi0_.actual as actual2_160_, nsisubdivi0_.create_date as create_d3_160_, nsisubdivi0_.deleted as deleted4_160_, nsisubdivi0_.inner_code as inner_co5_160_, nsisubdivi0_.last_editing_date as last_edi6_160_, nsisubdivi0_.root_id as root_id7_160_, nsisubdivi0_.sort_order as sort_ord8_160_, nsisubdivi0_.value as value9_160_, nsisubdivi0_.version_number as version10_160_, nsisubdivi0_.time_zone_root_id as time_zo11_160_ from nsism.nsi_subdivision nsisubdivi0_ where nsisubdivi0_.actual=true and nsisubdivi0_.root_id=9
  4. Hibernate: select nsitimezon0_.id as id1_167_, nsitimezon0_.actual as actual2_167_, nsitimezon0_.create_date as create_d3_167_, nsitimezon0_.deleted as deleted4_167_, nsitimezon0_.inner_code as inner_co5_167_, nsitimezon0_.last_editing_date as last_edi6_167_, nsitimezon0_.root_id as root_id7_167_, nsitimezon0_.sort_order as sort_ord8_167_, nsitimezon0_.value as value9_167_, nsitimezon0_.version_number as version10_167_, nsitimezon0_.code as code11_167_, nsitimezon0_.olson_name as olson_n12_167_, nsitimezon0_.rus_name as rus_nam13_167_ from nsism.nsi_time_zone nsitimezon0_ where nsitimezon0_.actual=true and nsitimezon0_.root_id=4
  5. Hibernate: select organizati0_.id as id1_224_, organizati0_.last_editing_date as last_edi2_224_, organizati0_.actual as actual3_224_, organizati0_.version_create_date as version_4_224_, organizati0_.version_number as version_5_224_, organizati0_.address as address6_224_, organizati0_.agency_territory as agency_t7_224_, organizati0_.agency_type as agency_t8_224_, organizati0_.is_branch as is_branc9_224_, organizati0_.branches_count as branche10_224_, organizati0_.data_source as data_so11_224_, organizati0_.email as email12_224_, organizati0_.email_confirmed as email_c13_224_, organizati0_.esia_id as esia_id14_224_, organizati0_.factual_address as factual15_224_, organizati0_.fax as fax16_224_, organizati0_.full_name as full_na17_224_, organizati0_.head_ppa_org_id as head_pp38_224_, organizati0_.ifrs_reporting as ifrs_re18_224_, organizati0_.information_source_root_id as informa19_224_, organizati0_.inn as inn20_224_, organizati0_.kpp as kpp21_224_, organizati0_.na_branch_code as na_bran22_224_, organizati0_.na_client_id as na_clie23_224_, organizati0_.na_id as na_id24_224_, organizati0_.na_status as na_stat25_224_, organizati0_.na_update_date as na_upda26_224_, organizati0_.not_blacklisted as not_bla27_224_, organizati0_.ogrn as ogrn28_224_, organizati0_.okopf_code as okopf_c29_224_, organizati0_.ppa_organization_id as ppa_org30_224_, organizati0_.organization_type as organiz31_224_, organizati0_.phone as phone32_224_, organizati0_.short_name as short_n33_224_, organizati0_.state_registration_date as state_r34_224_, organizati0_.status_id as status_39_224_, organizati0_.statutory_full_name as statuto35_224_, organizati0_.statutory_name_differs as statuto36_224_, organizati0_.statutory_short_name as statuto37_224_ from ppasm.ppa_organization_version organizati0_ where organizati0_.ppa_organization_id=? and organizati0_.actual=?
  6. Hibernate: select organizati0_.id as id1_223_0_, organizati0_.last_editing_date as last_edi2_223_0_, organizati0_.block as block3_223_0_, organizati0_.block_date as block_da4_223_0_, organizati0_.block_reason_id as block_re5_223_0_, organizati0_.on_registration as on_regis6_223_0_, organizati0_.registered as register7_223_0_, organizati0_.registration_date as registra8_223_0_ from ppasm.ppa_organization_status organizati0_ where organizati0_.id=?
  7. Hibernate: select orgroles0_.ppa_org_version_id as ppa_org_4_221_0_, orgroles0_.id as id1_221_0_, orgroles0_.id as id1_221_1_, orgroles0_.last_editing_date as last_edi2_221_1_, orgroles0_.org_role_root_id as org_role3_221_1_, orgroles0_.ppa_org_version_id as ppa_org_4_221_1_ from ppasm.ppa_organization_role orgroles0_ where orgroles0_.ppa_org_version_id=?
  8. 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_.agreement_number_serial_number as agreemen9_9_, agreementb0_.agreement_number_text_value as agreeme10_9_, agreementb0_.create_date as create_11_9_, agreementb0_.edit_reason as edit_re12_9_, agreementb0_.edit_reason_id as edit_re13_9_, agreementb0_.editor_employee_id as editor_14_9_, agreementb0_.editor_organization_id as editor_15_9_, agreementb0_.editor_organization_version_id as editor_16_9_, agreementb0_.from_credit_road as from_cr17_9_, agreementb0_.locked as locked18_9_, agreementb0_.on_paper as on_pape19_9_, agreementb0_.organization_id as organiz20_9_, agreementb0_.organization_version_id as organiz21_9_, agreementb0_.rejected_employee_root_id as rejecte22_9_, agreementb0_.status_root_id as status_23_9_, agreementb0_.system_number as system_24_9_, agreementb0_.version_number as version25_9_, agreementb0_.accompanied_contract as accompa26_9_, agreementb0_.accounting_type_id as account27_9_, agreementb0_.additional_info as additio28_9_, agreementb0_.agreement_number_short_name as agreeme29_9_, agreementb0_.agreement_number_year as agreeme30_9_, agreementb0_.controlled_cooperation_level_id as control31_9_, agreementb0_.need_change_status_to_sba as need_ch32_9_, agreementb0_.project_management_root_id as project33_9_, agreementb0_.readiness_compliant as readine34_9_, agreementb0_.responsible_employee as respons35_9_ from bagrsm.bagr_agreement agreementb0_ where agreementb0_.agreement_type_root_id=1 and agreementb0_.id=? and agreementb0_.status_root_id<>?
  9. 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=?
  10. 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_.agreement_number_serial_number as agreemen9_9_0_, agreementb1_.agreement_number_text_value as agreeme10_9_0_, agreementb1_.create_date as create_11_9_0_, agreementb1_.edit_reason as edit_re12_9_0_, agreementb1_.edit_reason_id as edit_re13_9_0_, agreementb1_.editor_employee_id as editor_14_9_0_, agreementb1_.editor_organization_id as editor_15_9_0_, agreementb1_.editor_organization_version_id as editor_16_9_0_, agreementb1_.from_credit_road as from_cr17_9_0_, agreementb1_.locked as locked18_9_0_, agreementb1_.on_paper as on_pape19_9_0_, agreementb1_.organization_id as organiz20_9_0_, agreementb1_.organization_version_id as organiz21_9_0_, agreementb1_.rejected_employee_root_id as rejecte22_9_0_, agreementb1_.status_root_id as status_23_9_0_, agreementb1_.system_number as system_24_9_0_, agreementb1_.version_number as version25_9_0_, agreementb1_.accompanied_contract as accompa26_9_0_, agreementb1_.accounting_type_id as account27_9_0_, agreementb1_.additional_info as additio28_9_0_, agreementb1_.agreement_number_short_name as agreeme29_9_0_, agreementb1_.agreement_number_year as agreeme30_9_0_, agreementb1_.controlled_cooperation_level_id as control31_9_0_, agreementb1_.need_change_status_to_sba as need_ch32_9_0_, agreementb1_.project_management_root_id as project33_9_0_, agreementb1_.readiness_compliant as readine34_9_0_, agreementb1_.responsible_employee as respons35_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=?
  11. Hibernate: select agreementb0_.id as col_0_0_ from bagrsm.bagr_agreement agreementb0_ where agreementb0_.agreement_type_root_id=1 and agreementb0_.root_id=? and agreementb0_.status_root_id<>8 DEBUG   backend develop
  12.     May 25, 2021 @ 13:46:06.139 run method started. algorithmRequest is: PaymentOrderEarliestApprovalDateSearchRequest{agreementBsIds=[35410]}
  13. Hibernate: select paymentord0_.id as id1_202_, paymentord0_.last_editing_date as last_edi2_202_, paymentord0_.actual as actual3_202_, paymentord0_.actual_by_business as actual_b4_202_, paymentord0_.bagr_agreement_bs_id as bagr_agr5_202_, paymentord0_.bagr_agreement_bs_object_id as bagr_agr6_202_, paymentord0_.bagr_agreement_bs_object_root_id as bagr_agr7_202_, paymentord0_.bagr_agreement_sba_object_id as bagr_agr8_202_, paymentord0_.amount as amount9_202_, paymentord0_.amount_with_vat as amount_10_202_, paymentord0_.analytics_filled as analyti11_202_, paymentord0_.budget_version_id as budget_12_202_, paymentord0_.budgetary_payment as budgeta13_202_, paymentord0_.budgetary_payment_document_number as budgeta14_202_, paymentord0_.cagr_agreement_id as cagr_ag15_202_, paymentord0_.cagr_agreement_root_id as cagr_ag16_202_, paymentord0_.change_date as change_17_202_, paymentord0_.code as code18_202_, paymentord0_.create_date as create_19_202_, paymentord0_.create_date_month as create_20_202_, paymentord0_.create_date_year as create_21_202_, paymentord0_.creator_organization_id as creator22_202_, paymentord0_.creator_organization_root_id as creator23_202_, paymentord0_.currency_id as currenc24_202_, paymentord0_.currency_root_id as currenc25_202_, paymentord0_.currency_transaction_type_code_id as currenc26_202_, paymentord0_.currency_transaction_type_code_root_id as currenc27_202_, paymentord0_.customs_code as customs28_202_, paymentord0_.editor_employee_root_id as editor_29_202_, paymentord0_.editor_organization_id as editor_30_202_, paymentord0_.editor_organization_root_id as editor_31_202_, paymentord0_.electronic_document_id_1c as electro32_202_, paymentord0_.employee_root_id_sent_to_signing as employe33_202_, paymentord0_.employee_root_id_signed as employe34_202_, paymentord0_.extended_day as extende35_202_, paymentord0_.group_operation_id as group_o36_202_, paymentord0_.import_file_id as import_37_202_, paymentord0_.import_id as import_38_202_, paymentord0_.income_type_code_id as income_39_202_, paymentord0_.income_type_code_root_id as income_40_202_, paymentord0_.individual_information_id as individ41_202_, paymentord0_.information_source_id as informa42_202_, paymentord0_.information_source_root_id as informa43_202_, paymentord0_.kbk as kbk44_202_, paymentord0_.law_214_operation as law_45_202_, paymentord0_.law_214_operation_type_root_id as law_46_202_, paymentord0_.limit_absence as limit_a47_202_, paymentord0_.locked as locked48_202_, paymentord0_.new_athena_payment_order_id as new_ath49_202_, paymentord0_.not_show_payment_cause_document_date as not_sho50_202_, paymentord0_.oktmo as oktmo51_202_, paymentord0_.operation_type_id as operati52_202_, paymentord0_.operation_type_root_id as operati53_202_, paymentord0_.parent_na_id as parent_54_202_, paymentord0_.parent_payment_order_version_id as parent_55_202_, paymentord0_.payer_status_id as payer_s56_202_, paymentord0_.payer_status_root_id as payer_s57_202_, paymentord0_.payment_by_cagr_agreement as payment58_202_, paymentord0_.payment_cause_document_date as payment59_202_, paymentord0_.payment_cause_id as payment60_202_, paymentord0_.payment_cause_root_id as payment61_202_, paymentord0_.payment_form_id as payment62_202_, paymentord0_.payment_form_root_id as payment63_202_, paymentord0_.payment_order_id as payment99_202_, paymentord0_.payment_order_create_date as payment64_202_, paymentord0_.payment_order_number as payment65_202_, paymentord0_.payment_priority_id as payment66_202_, paymentord0_.payment_priority_root_id as payment67_202_, paymentord0_.payment_purpose as payment68_202_, paymentord0_.payment_purpose_code as payment69_202_, paymentord0_.payment_term as payment70_202_, paymentord0_.payment_type_id as payment71_202_, paymentord0_.payment_type_root_id as payment72_202_, paymentord0_.payment_with_funds_received_by_agreement as payment73_202_, paymentord0_.period_id as period_74_202_, paymentord0_.period_root_id as period_75_202_, paymentord0_.refund_payment_order_version_id as refund_76_202_, paymentord0_.requisites_clarification as requisi77_202_, paymentord0_.requisites_clarification_number as requisi78_202_, paymentord0_.reserve_field as reserve79_202_, paymentord0_.revoked_by_client as revoked80_202_, paymentord0_.sent_clarification_notification as sent_cl81_202_, paymentord0_.sent_to_clarification as sent_to82_202_, paymentord0_.sent_to_eiszhs as sent_to83_202_, paymentord0_.sent_to_eiszhs_id as sent_to84_202_, paymentord0_.status_root_id as status_85_202_, paymentord0_.system_number as system_86_202_, paymentord0_.tax_period_date as tax_per87_202_, paymentord0_.tax_period_id as tax_per88_202_, paymentord0_.tax_period_indicator_id as tax_per89_202_, paymentord0_.tax_period_indicator_root_id as tax_per90_202_, paymentord0_.tax_period_root_id as tax_per91_202_, paymentord0_.tax_period_year as tax_per92_202_, paymentord0_.vat_amount as vat_amo93_202_, paymentord0_.vat_rate_id as vat_rat94_202_, paymentord0_.vat_rate_root_id as vat_rat95_202_, paymentord0_.vat_type_id as vat_typ96_202_, paymentord0_.vat_type_root_id as vat_typ97_202_, paymentord0_.version_number as version98_202_ from posm.po_payment_order_version paymentord0_ where (paymentord0_.status_root_id in (? , ? , ?)) and paymentord0_.bagr_agreement_bs_id=?
  14. Hibernate: select recognitio0_.id as id1_170_, recognitio0_.last_editing_date as last_edi2_170_, recognitio0_.batch_id as batch_id3_170_, recognitio0_.create_date as create_d4_170_, recognitio0_.entity_id as entity_i5_170_, recognitio0_.entity_type_root_id as entity_t6_170_, recognitio0_.file_id as file_id7_170_, recognitio0_.flexi_stage as flexi_st8_170_, recognitio0_.initiator as initiato9_170_, recognitio0_.module_type as module_10_170_, recognitio0_.next_poll_date as next_po11_170_, recognitio0_.poll_date as poll_da12_170_, recognitio0_.polling_in_progress as polling13_170_, recognitio0_.result_json as result_14_170_, recognitio0_.result_raw as result_15_170_, recognitio0_.rbs_stage as rbs_sta16_170_, recognitio0_.task_id as task_id17_170_ from ocrsm.ocr_recognition_task recognitio0_ where recognitio0_.next_poll_date<? and (recognitio0_.rbs_stage in (? , ?)) and recognitio0_.polling_in_progress=? order by recognitio0_.next_poll_date asc limit ? for update of recognitio0_ skip locked   DEBUG   backend develop
  15.     May 25, 2021 @ 13:46:08.546 Десериализовано сообщение: {"entityRootId":35410,"entityVersionId":35410,"agreementTargetStatus":"ST_DBS_ACCEPT_C","revoked":false,"locked":false,"initiatorId":888,"revocationUnavailable":false,"actionType":null}
  16. 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_.agreement_number_serial_number as agreemen9_9_, agreementb0_.agreement_number_text_value as agreeme10_9_, agreementb0_.create_date as create_11_9_, agreementb0_.edit_reason as edit_re12_9_, agreementb0_.edit_reason_id as edit_re13_9_, agreementb0_.editor_employee_id as editor_14_9_, agreementb0_.editor_organization_id as editor_15_9_, agreementb0_.editor_organization_version_id as editor_16_9_, agreementb0_.from_credit_road as from_cr17_9_, agreementb0_.locked as locked18_9_, agreementb0_.on_paper as on_pape19_9_, agreementb0_.organization_id as organiz20_9_, agreementb0_.organization_version_id as organiz21_9_, agreementb0_.rejected_employee_root_id as rejecte22_9_, agreementb0_.status_root_id as status_23_9_, agreementb0_.system_number as system_24_9_, agreementb0_.version_number as version25_9_, agreementb0_.accompanied_contract as accompa26_9_, agreementb0_.accounting_type_id as account27_9_, agreementb0_.additional_info as additio28_9_, agreementb0_.agreement_number_short_name as agreeme29_9_, agreementb0_.agreement_number_year as agreeme30_9_, agreementb0_.controlled_cooperation_level_id as control31_9_, agreementb0_.need_change_status_to_sba as need_ch32_9_, agreementb0_.project_management_root_id as project33_9_, agreementb0_.readiness_compliant as readine34_9_, agreementb0_.responsible_employee as respons35_9_ from bagrsm.bagr_agreement agreementb0_ where agreementb0_.agreement_type_root_id=1 and agreementb0_.id=? and agreementb0_.status_root_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 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_.agreement_number_serial_number as agreemen9_9_0_, agreementb1_.agreement_number_text_value as agreeme10_9_0_, agreementb1_.create_date as create_11_9_0_, agreementb1_.edit_reason as edit_re12_9_0_, agreementb1_.edit_reason_id as edit_re13_9_0_, agreementb1_.editor_employee_id as editor_14_9_0_, agreementb1_.editor_organization_id as editor_15_9_0_, agreementb1_.editor_organization_version_id as editor_16_9_0_, agreementb1_.from_credit_road as from_cr17_9_0_, agreementb1_.locked as locked18_9_0_, agreementb1_.on_paper as on_pape19_9_0_, agreementb1_.organization_id as organiz20_9_0_, agreementb1_.organization_version_id as organiz21_9_0_, agreementb1_.rejected_employee_root_id as rejecte22_9_0_, agreementb1_.status_root_id as status_23_9_0_, agreementb1_.system_number as system_24_9_0_, agreementb1_.version_number as version25_9_0_, agreementb1_.accompanied_contract as accompa26_9_0_, agreementb1_.accounting_type_id as account27_9_0_, agreementb1_.additional_info as additio28_9_0_, agreementb1_.agreement_number_short_name as agreeme29_9_0_, agreementb1_.agreement_number_year as agreeme30_9_0_, agreementb1_.controlled_cooperation_level_id as control31_9_0_, agreementb1_.need_change_status_to_sba as need_ch32_9_0_, agreementb1_.project_management_root_id as project33_9_0_, agreementb1_.readiness_compliant as readine34_9_0_, agreementb1_.responsible_employee as respons35_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=?
  19. Hibernate: select filemetada0_.id as id1_73_, filemetada0_.blob_id as blob_id2_73_, filemetada0_.blob_url as blob_url3_73_, filemetada0_.context as context4_73_, filemetada0_.create_date as create_d5_73_, filemetada0_.document_date as document6_73_, filemetada0_.document_number as document7_73_, filemetada0_.document_status_root_id as document8_73_, filemetada0_.document_type_code as document9_73_, filemetada0_.document_type_id as documen10_73_, filemetada0_.entity_id as entity_11_73_, filemetada0_.entity_type as entity_12_73_, filemetada0_.hash as hash13_73_, filemetada0_.hidden as hidden14_73_, filemetada0_.last_editing_date as last_ed15_73_, filemetada0_.linked_sign_object as linked_16_73_, filemetada0_.name as name17_73_, filemetada0_.signed_by_one_party as signed_18_73_, filemetada0_.size as size19_73_, filemetada0_.status as status20_73_, filemetada0_.user_root_id as user_ro21_73_, filemetada0_.visible_to_client as visible22_73_ from fssm.fs_file filemetada0_ where filemetada0_.entity_type=? and filemetada0_.entity_id=?
  20. Hibernate: select filemetada0_.id as id1_73_, filemetada0_.blob_id as blob_id2_73_, filemetada0_.blob_url as blob_url3_73_, filemetada0_.context as context4_73_, filemetada0_.create_date as create_d5_73_, filemetada0_.document_date as document6_73_, filemetada0_.document_number as document7_73_, filemetada0_.document_status_root_id as document8_73_, filemetada0_.document_type_code as document9_73_, filemetada0_.document_type_id as documen10_73_, filemetada0_.entity_id as entity_11_73_, filemetada0_.entity_type as entity_12_73_, filemetada0_.hash as hash13_73_, filemetada0_.hidden as hidden14_73_, filemetada0_.last_editing_date as last_ed15_73_, filemetada0_.linked_sign_object as linked_16_73_, filemetada0_.name as name17_73_, filemetada0_.signed_by_one_party as signed_18_73_, filemetada0_.size as size19_73_, filemetada0_.status as status20_73_, filemetada0_.user_root_id as user_ro21_73_, filemetada0_.visible_to_client as visible22_73_ from fssm.fs_file filemetada0_ where filemetada0_.id in (?)
  21. Hibernate: select nsifileatt0_.id as id1_119_, nsifileatt0_.actual as actual2_119_, nsifileatt0_.create_date as create_d3_119_, nsifileatt0_.deleted as deleted4_119_, nsifileatt0_.inner_code as inner_co5_119_, nsifileatt0_.last_editing_date as last_edi6_119_, nsifileatt0_.root_id as root_id7_119_, nsifileatt0_.sort_order as sort_ord8_119_, nsifileatt0_.value as value9_119_, nsifileatt0_.version_number as version10_119_, nsifileatt0_.added_manually as added_m11_119_, nsifileatt0_.allowed_only_pdf as allowed12_119_, nsifileatt0_.attachment_required as attachm13_119_ from nsism.nsi_file_attachment_type nsifileatt0_ where nsifileatt0_.id in (569) order by nsifileatt0_.sort_order asc
  22. Hibernate: select entitytype0_.file_attach_type_id as file_att1_118_0_, entitytype0_.entity_type_root_id as entity_t2_118_0_ from nsism.nsi_file_attachment_entity_type entitytype0_ where entitytype0_.file_attach_type_id=?
  23. Hibernate: select fileformat0_.file_attachment_type_id as file_att1_120_0_, fileformat0_.file_format_root_id as file_for2_120_0_ from nsism.nsi_file_attachment_type_file_format_limitation fileformat0_ where fileformat0_.file_attachment_type_id=?   DEBUG   backend develop
  24.     May 25, 2021 @ 13:46:08.954 processEventNotificationQueue request: NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}
  25. Hibernate: select notiftempl0_.id as id1_75_, notiftempl0_.last_editing_date as last_edi2_75_, notiftempl0_.email_enabled as email_en3_75_, notiftempl0_.email_event_name as email_ev4_75_, notiftempl0_.email_mandatory as email_ma5_75_, notiftempl0_.email_template as email_te6_75_, notiftempl0_.entity_type_root_id as entity_t7_75_, notiftempl0_.event_code as event_co8_75_, notiftempl0_.important as importan9_75_, notiftempl0_.inner_enabled as inner_e10_75_, notiftempl0_.inner_event_name as inner_e11_75_, notiftempl0_.inner_mandatory as inner_m12_75_, notiftempl0_.inner_template as inner_t13_75_, notiftempl0_.task as task14_75_ from notifsm.notif_template notiftempl0_ where notiftempl0_.event_code=?
  26. Hibernate: select employeeve0_.id as id1_217_0_, employeest10_.id as id1_216_1_, employeeen11_.id as id1_211_2_, organizati12_.id as id1_220_3_, employeeve0_.last_editing_date as last_edi2_217_0_, employeeve0_.actual as actual3_217_0_, employeeve0_.version_create_date as version_4_217_0_, employeeve0_.version_number as version_5_217_0_, employeeve0_.address as address6_217_0_, employeeve0_.birth_date as birth_da7_217_0_, employeeve0_.branch_kpp as branch_k8_217_0_, employeeve0_.citizenship as citizens9_217_0_, employeeve0_.data_source as data_so10_217_0_, employeeve0_.delete_date as delete_11_217_0_, employeeve0_.doc_act_number as doc_act12_217_0_, employeeve0_.doc_expiry_date as doc_exp13_217_0_, employeeve0_.doc_first_name as doc_fir14_217_0_, employeeve0_.doc_issue_date as doc_iss15_217_0_, employeeve0_.doc_issue_id as doc_iss16_217_0_, employeeve0_.doc_issue_by as doc_iss17_217_0_, employeeve0_.doc_last_name as doc_las18_217_0_, employeeve0_.doc_number as doc_num19_217_0_, employeeve0_.doc_series as doc_ser20_217_0_, employeeve0_.doc_type as doc_typ21_217_0_, employeeve0_.doc_edit_available as doc_edi22_217_0_, employeeve0_.email as email23_217_0_, employeeve0_.email_confirmed as email_c24_217_0_, employeeve0_.ppa_employee_id as ppa_emp45_217_0_, employeeve0_.esia_id as esia_id25_217_0_, employeeve0_.first_name as first_n26_217_0_, employeeve0_.gender as gender27_217_0_, employeeve0_.inn as inn28_217_0_, employeeve0_.last_name as last_na29_217_0_, employeeve0_.middle_name as middle_30_217_0_, employeeve0_.is_org_chief as is_org_31_217_0_, employeeve0_.phone as phone32_217_0_, employeeve0_.phone_confirmation_date as phone_c33_217_0_, employeeve0_.phone_confirmation_message as phone_c34_217_0_, employeeve0_.phone_confirmation_status as phone_c35_217_0_, employeeve0_.phone_confirmed as phone_c36_217_0_, employeeve0_.phone_number_on_confirmation as phone_n37_217_0_, employeeve0_.popup_allowed as popup_a38_217_0_, employeeve0_.position_emp as positio39_217_0_, employeeve0_.registration_address as registr40_217_0_, employeeve0_.role_emp as role_em41_217_0_, employeeve0_.snils as snils42_217_0_, employeeve0_.status_id as status_46_217_0_, employeeve0_.subdivision_root_id as subdivi43_217_0_, employeeve0_.time_zone_root_id as time_zo44_217_0_, employeest10_.last_editing_date as last_edi2_216_1_, employeest10_.block as block3_216_1_, employeest10_.block_date as block_da4_216_1_, employeest10_.block_info as block_in5_216_1_, employeest10_.block_reason_id as block_re6_216_1_, employeest10_.registered as register7_216_1_, employeest10_.registration_date as registra8_216_1_, employeest10_.unlock_date as unlock_d9_216_1_, employeeen11_.last_editing_date as last_edi2_211_2_, employeeen11_.keycloak_user_id as keycloak3_211_2_, employeeen11_.ppa_organization_id as ppa_orga5_211_2_, employeeen11_.user_privileges as user_pri4_211_2_, organizati12_.last_editing_date as last_edi2_220_3_, organizati12_.login_1c as login_3_220_3_, organizati12_.ogrn as ogrn4_220_3_, organizati12_.password_1c as password5_220_3_, organizati12_.session_expiration_1c as session_6_220_3_, organizati12_.session_id_1c as session_7_220_3_ from ppasm.ppa_employee_version employeeve0_ left outer join ppasm.ppa_employee_status employeest10_ on employeeve0_.status_id=employeest10_.id left outer join ppasm.ppa_employee employeeen11_ on employeeve0_.ppa_employee_id=employeeen11_.id left outer join ppasm.ppa_organization organizati12_ on employeeen11_.ppa_organization_id=organizati12_.id cross join ppasm.ppa_employee_status employeest1_ cross join ppasm.ppa_employee employeeen6_ where employeeve0_.status_id=employeest1_.id and employeeve0_.ppa_employee_id=employeeen6_.id and employeeve0_.actual=? and employeest1_.block=? and (exists (select 1 from ppasm.ppa_organization_version organizati2_ cross join ppasm.ppa_employee employeeen3_ cross join ppasm.ppa_organization_status organizati4_ where employeeve0_.ppa_employee_id=employeeen3_.id and organizati2_.status_id=organizati4_.id and organizati2_.ppa_organization_id=employeeen3_.ppa_organization_id and organizati2_.actual=? and organizati4_.block=? and organizati4_.registered=?)) and (employeeen6_.ppa_organization_id in (? , ?)) and (arrayoverlap(employeeen6_.user_privileges, ?)=true or exists (select 1 from ppasm.ppa_access_group accessgrou8_ where (employeeve0_.ppa_employee_id in (select employees9_.ppa_employee_id from ppasm.ppa_employee_access_group employees9_ where accessgrou8_.id=employees9_.ppa_access_group_id)) and arrayoverlap(accessgrou8_.group_privileges, ?)=true))
  27. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  28. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  29. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  30. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  31. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  32. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  33. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  34. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  35. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  36. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  37. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  38. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  39. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  40. Hibernate: select childgroup0_.parent_group_id as parent_g2_208_0_, childgroup0_.child_group_id as child_gr1_208_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_access_group_link childgroup0_ inner join ppasm.ppa_access_group accessgrou1_ on childgroup0_.child_group_id=accessgrou1_.id where childgroup0_.parent_group_id=?
  41. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  42. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  43. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  44. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  45. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  46. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  47. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  48. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  49. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  50. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  51. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  52. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  53. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  54. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  55. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  56. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  57. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  58. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  59. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  60. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  61. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  62. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  63. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  64. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  65. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  66. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  67. Hibernate: select childgroup0_.parent_group_id as parent_g2_208_0_, childgroup0_.child_group_id as child_gr1_208_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_access_group_link childgroup0_ inner join ppasm.ppa_access_group accessgrou1_ on childgroup0_.child_group_id=accessgrou1_.id where childgroup0_.parent_group_id=?
  68. Hibernate: select childgroup0_.parent_group_id as parent_g2_208_0_, childgroup0_.child_group_id as child_gr1_208_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_access_group_link childgroup0_ inner join ppasm.ppa_access_group accessgrou1_ on childgroup0_.child_group_id=accessgrou1_.id where childgroup0_.parent_group_id=?
  69. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  70. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  71. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  72. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  73. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  74. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  75. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  76. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  77. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  78. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  79. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  80. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  81. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  82. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  83. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  84. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  85. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  86. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  87. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  88. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  89. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  90. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  91. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  92. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  93. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  94. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  95. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=? DEBUG   backend develop
  96.     May 25, 2021 @ 13:46:09.147 Created notification: id=2391689, receiver=NotificationReceiver{employeeRootId=34, firstName='Иван', middleName='Иванович', lastName='Иванов', email='lanit_ivanov@lanit.ru', phone='79265964656'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}
  97. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  98.     May 25, 2021 @ 13:46:09.178 Created notification: id=2391690, receiver=NotificationReceiver{employeeRootId=36, firstName='Андрей', middleName='Максимович', lastName='Васильев', email='usertes1t@mail.ru', phone='1115588'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410} DEBUG   backend develop
  99.     May 25, 2021 @ 13:46:09.901 Created notification: id=2391691, receiver=NotificationReceiver{employeeRootId=935, firstName='Влас', middleName='Альбертович', lastName='Потапов', email='usertest@test.ru', phone='95465462456'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410} DEBUG   backend develop
  100.     May 25, 2021 @ 13:46:10.336 Created notification: id=2391692, receiver=NotificationReceiver{employeeRootId=233, firstName='Михаил', middleName='Викторович', lastName='Дроздов', email='www@rr.rr', phone='71233210005'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}
  101. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  102.     May 25, 2021 @ 13:46:10.350 Created notification: id=2391693, receiver=NotificationReceiver{employeeRootId=619, firstName='Банка', middleName='null', lastName='Сотрудник', email='newmail123@mail.orgg', phone='79523657444'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}
  103. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  104.     May 25, 2021 @ 13:46:10.391 Created notification: id=2391694, receiver=NotificationReceiver{employeeRootId=173, firstName='Тест', middleName='null', lastName='Тестовый', email='test@mail.ru', phone='79178524589'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}
  105. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  106.     May 25, 2021 @ 13:46:10.397 Created notification: id=2391695, receiver=NotificationReceiver{employeeRootId=942, firstName='Олег', middleName='Александрович', lastName='Новый', email='xxx@yyy.ru', phone='79231453257'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}
  107. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  108.     May 25, 2021 @ 13:46:10.410 Created notification: id=2391696, receiver=NotificationReceiver{employeeRootId=944, firstName='Олег3', middleName='Александрович', lastName='Новый', email='xxx@yyy.ru', phone='79367432468'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}
  109. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  110.     May 25, 2021 @ 13:46:10.418 Created notification: id=2391697, receiver=NotificationReceiver{employeeRootId=946, firstName='Олег5', middleName='Александрович', lastName='Новый', email='xxx@yyy.ru', phone='79372432564'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}
  111. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  112.     May 25, 2021 @ 13:46:10.424 Created notification: id=2391698, receiver=NotificationReceiver{employeeRootId=947, firstName='Олег6', middleName='Александрович', lastName='Новый', email='xxx@yyy.ru', phone='79765485478'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}
  113. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  114.     May 25, 2021 @ 13:46:10.430 Created notification: id=2391699, receiver=NotificationReceiver{employeeRootId=888, firstName='Эрнест', middleName='null', lastName='Хемингуэй', email='Hemingway@testtest.test', phone='72342321241'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}    DEBUG   backend develop
  115.     May 25, 2021 @ 13:46:10.908 Created notification: id=2391700, receiver=NotificationReceiver{employeeRootId=889, firstName='Василий', middleName='Алибабаевич', lastName='Алибабаев', email='Vasya@rbs.internal', phone='79009998877'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}
  116. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  117.     May 25, 2021 @ 13:46:10.915 Created notification: id=2391701, receiver=NotificationReceiver{employeeRootId=954, firstName='Роман', middleName='Юлманович', lastName='Жуков', email='xrmtesttest@test.ru', phone='77922117513'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}
  118. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  119.     May 25, 2021 @ 13:46:10.921 Created notification: id=2391702, receiver=NotificationReceiver{employeeRootId=59, firstName='Полина', middleName='Алексеевна', lastName='Афанасьева', email='AAfanaseva@gmail.com', phone='79548965896'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}
  120. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  121.     May 25, 2021 @ 13:46:10.928 Created notification: id=2391703, receiver=NotificationReceiver{employeeRootId=955, firstName='Агафон', middleName='Яковлевич', lastName='Исаков', email='xrmtesttt@mailxrm.ru', phone='71231244421'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}
  122. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  123.     May 25, 2021 @ 13:46:10.939 Created notification: id=2391704, receiver=NotificationReceiver{employeeRootId=60, firstName='Дарья', middleName='Ковальчук', lastName='Владимировна', email='kovtest1@test.ru', phone='1115588'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}  DEBUG   backend develop
  124.     May 25, 2021 @ 13:46:11.374 Created notification: id=2391705, receiver=NotificationReceiver{employeeRootId=956, firstName='Алексеев', middleName='Львович', lastName='Мартын', email='xrmeewe@mailxrm.com', phone='74444421231'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}    DEBUG   backend develop
  125.     May 25, 2021 @ 13:46:11.384 Created notification: id=2391706, receiver=NotificationReceiver{employeeRootId=61, firstName='Анна', middleName='Аннова', lastName='Анновна', email='user0603@user.ru', phone='79528569898'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}    DEBUG   backend develop
  126.     May 25, 2021 @ 13:46:11.586 Created notification: id=2391707, receiver=NotificationReceiver{employeeRootId=958, firstName='Николай', middleName='Семенович', lastName='Гордов', email='semenov1@ya.ru', phone='75465465465'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}
  127. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  128.     May 25, 2021 @ 13:46:11.594 Created notification: id=2391708, receiver=NotificationReceiver{employeeRootId=959, firstName='Николай', middleName='Семенович', lastName='Гордов', email='semenov@ya.ru', phone='75465465465'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}
  129. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  130.     May 25, 2021 @ 13:46:11.601 Created notification: id=2391709, receiver=NotificationReceiver{employeeRootId=703, firstName='Виктория', middleName='Мансуровна', lastName='Нургалиева', email='nurgalieva_bank@m.orggg', phone='79954125014'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}
  131. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  132.     May 25, 2021 @ 13:46:11.611 Created notification: id=2391710, receiver=NotificationReceiver{employeeRootId=576, firstName='44', middleName='44', lastName='44', email='fggff@ya.ru', phone='79653934444'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}
  133. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  134.     May 25, 2021 @ 13:46:11.619 Created notification: id=2391711, receiver=NotificationReceiver{employeeRootId=1, firstName='Артем', middleName='Николаевич', lastName='Гусев', email='gusev13@gmail.com', phone='74950472388'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}  DEBUG   backend develop
  135.     May 25, 2021 @ 13:46:11.771 Created notification: id=2391712, receiver=NotificationReceiver{employeeRootId=9, firstName='Ирина', middleName='Петровна', lastName='Иванова', email='null', phone='null'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}  DEBUG   backend develop
  136.     May 25, 2021 @ 13:46:11.782 Created notification: id=2391713, receiver=NotificationReceiver{employeeRootId=80, firstName='Виктория', middleName='Дмитриевна', lastName='Ильина', email='usertestilina@test.ru', phone='1115588'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410} DEBUG   backend develop
  137.     May 25, 2021 @ 13:46:11.912 Created notification: id=2391714, receiver=NotificationReceiver{employeeRootId=977, firstName='Николай', middleName='Владимирович', lastName='Яров', email='w@t.ru', phone='75546456456'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}
  138. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  139.     May 25, 2021 @ 13:46:11.926 Created notification: id=2391715, receiver=NotificationReceiver{employeeRootId=210, firstName='тест', middleName='тест', lastName='тест', email='text@text.com', phone='77575757575'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}
  140. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  141.     May 25, 2021 @ 13:46:11.933 Created notification: id=2391716, receiver=NotificationReceiver{employeeRootId=19, firstName='Бэльб', middleName='null', lastName='Банкова', email='test@ma.ru', phone='79565656566'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}
  142. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  143.     May 25, 2021 @ 13:46:11.940 Created notification: id=2391717, receiver=NotificationReceiver{employeeRootId=83, firstName='Юрий', middleName='Михайлович', lastName='Десяткин', email='1EDITusertest@mail.com', phone='75157271825'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}    DEBUG   backend develop
  144.     May 25, 2021 @ 13:46:12.187 Created notification: id=2391718, receiver=NotificationReceiver{employeeRootId=90, firstName='Иван', middleName='Петрович', lastName='Петриченко', email='petrichenko_bank@test.ru', phone='73331755204'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}  DEBUG   backend develop
  145.     May 25, 2021 @ 13:46:12.534 Created notification: id=2391719, receiver=NotificationReceiver{employeeRootId=91, firstName='Анастасия', middleName='Витальевна', lastName='Войтович', email='user81@test.ru', phone='7955588'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}
  146. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  147.     May 25, 2021 @ 13:46:12.540 Created notification: id=2391720, receiver=NotificationReceiver{employeeRootId=93, firstName='Роман', middleName='Иванович', lastName='Петров', email='usertest@test.ru', phone='1115588'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410}
  148. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  149.     May 25, 2021 @ 13:46:12.546 Created notification: id=2391721, receiver=NotificationReceiver{employeeRootId=30, firstName='Сергей', middleName='Петрович', lastName='Гончаров', email='goncharov@mail.ru', phone='89267866004'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_06entity.id=35410entity.rootId=35410} DEBUG   backend develop
  150.     May 25, 2021 @ 13:46:59.173 Десериализовано сообщение: {"entityRootId":35410,"entityVersionId":35410,"agreementTargetStatus":"ST_DBS_REJECTED_C","revoked":false,"locked":false,"initiatorId":36,"revocationUnavailable":false,"actionType":null}
  151. 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_.agreement_number_serial_number as agreemen9_9_, agreementb0_.agreement_number_text_value as agreeme10_9_, agreementb0_.create_date as create_11_9_, agreementb0_.edit_reason as edit_re12_9_, agreementb0_.edit_reason_id as edit_re13_9_, agreementb0_.editor_employee_id as editor_14_9_, agreementb0_.editor_organization_id as editor_15_9_, agreementb0_.editor_organization_version_id as editor_16_9_, agreementb0_.from_credit_road as from_cr17_9_, agreementb0_.locked as locked18_9_, agreementb0_.on_paper as on_pape19_9_, agreementb0_.organization_id as organiz20_9_, agreementb0_.organization_version_id as organiz21_9_, agreementb0_.rejected_employee_root_id as rejecte22_9_, agreementb0_.status_root_id as status_23_9_, agreementb0_.system_number as system_24_9_, agreementb0_.version_number as version25_9_, agreementb0_.accompanied_contract as accompa26_9_, agreementb0_.accounting_type_id as account27_9_, agreementb0_.additional_info as additio28_9_, agreementb0_.agreement_number_short_name as agreeme29_9_, agreementb0_.agreement_number_year as agreeme30_9_, agreementb0_.controlled_cooperation_level_id as control31_9_, agreementb0_.need_change_status_to_sba as need_ch32_9_, agreementb0_.project_management_root_id as project33_9_, agreementb0_.readiness_compliant as readine34_9_, agreementb0_.responsible_employee as respons35_9_ from bagrsm.bagr_agreement agreementb0_ where agreementb0_.agreement_type_root_id=1 and agreementb0_.id=? and agreementb0_.status_root_id<>?
  152. Hibernate: select additional0_.id as id1_8_0_, additional0_.last_editing_date as last_edi2_8_0_, additional0_.agreement_id as agreemen4_8_0_, additional0_.agreement_date as agreemen3_8_0_, additional0_.agreement_number as agreemen5_8_0_, additional0_.comment_text as comment_6_8_0_, additional0_.end_date as end_date7_8_0_, additional0_.on_paper as on_paper8_8_0_, additional0_.start_date as start_da9_8_0_ from bagrsm.bagr_additional_agreement additional0_ where additional0_.agreement_id=?
  153. Hibernate: select 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_.agreement_number_serial_number as agreemen9_9_0_, agreementb1_.agreement_number_text_value as agreeme10_9_0_, agreementb1_.create_date as create_11_9_0_, agreementb1_.edit_reason as edit_re12_9_0_, agreementb1_.edit_reason_id as edit_re13_9_0_, agreementb1_.editor_employee_id as editor_14_9_0_, agreementb1_.editor_organization_id as editor_15_9_0_, agreementb1_.editor_organization_version_id as editor_16_9_0_, agreementb1_.from_credit_road as from_cr17_9_0_, agreementb1_.locked as locked18_9_0_, agreementb1_.on_paper as on_pape19_9_0_, agreementb1_.organization_id as organiz20_9_0_, agreementb1_.organization_version_id as organiz21_9_0_, agreementb1_.rejected_employee_root_id as rejecte22_9_0_, agreementb1_.status_root_id as status_23_9_0_, agreementb1_.system_number as system_24_9_0_, agreementb1_.version_number as version25_9_0_, agreementb1_.accompanied_contract as accompa26_9_0_, agreementb1_.accounting_type_id as account27_9_0_, agreementb1_.additional_info as additio28_9_0_, agreementb1_.agreement_number_short_name as agreeme29_9_0_, agreementb1_.agreement_number_year as agreeme30_9_0_, agreementb1_.controlled_cooperation_level_id as control31_9_0_, agreementb1_.need_change_status_to_sba as need_ch32_9_0_, agreementb1_.project_management_root_id as project33_9_0_, agreementb1_.readiness_compliant as readine34_9_0_, agreementb1_.responsible_employee as respons35_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=?
  154. Hibernate: select errorentit0_.id as id1_28_, errorentit0_.last_editing_date as last_edi2_28_, errorentit0_.actual as actual3_28_, errorentit0_.agreement_id as agreemen8_28_, errorentit0_.create_date as create_d4_28_, errorentit0_.error_text as error_te5_28_, errorentit0_.non_blocking as non_bloc6_28_, errorentit0_.visible as visible7_28_ from bagrsm.bagr_error errorentit0_ where errorentit0_.agreement_id=? and errorentit0_.actual=true
  155. Hibernate: update bagrsm.bagr_agreement set last_editing_date=?, root_id=?, accepted=?, actual=?, agreement_date=?, agreement_number=?, agreement_number_serial_number=?, agreement_number_text_value=?, create_date=?, edit_reason=?, edit_reason_id=?, editor_employee_id=?, editor_organization_id=?, editor_organization_version_id=?, from_credit_road=?, locked=?, on_paper=?, organization_id=?, organization_version_id=?, rejected_employee_root_id=?, status_root_id=?, system_number=?, version_number=?, accompanied_contract=?, accounting_type_id=?, additional_info=?, agreement_number_short_name=?, agreement_number_year=?, controlled_cooperation_level_id=?, need_change_status_to_sba=?, project_management_root_id=?, readiness_compliant=?, responsible_employee=? where id=? and last_editing_date=?
  156. 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_.agreement_number_serial_number as agreemen9_9_, agreementb0_.agreement_number_text_value as agreeme10_9_, agreementb0_.create_date as create_11_9_, agreementb0_.edit_reason as edit_re12_9_, agreementb0_.edit_reason_id as edit_re13_9_, agreementb0_.editor_employee_id as editor_14_9_, agreementb0_.editor_organization_id as editor_15_9_, agreementb0_.editor_organization_version_id as editor_16_9_, agreementb0_.from_credit_road as from_cr17_9_, agreementb0_.locked as locked18_9_, agreementb0_.on_paper as on_pape19_9_, agreementb0_.organization_id as organiz20_9_, agreementb0_.organization_version_id as organiz21_9_, agreementb0_.rejected_employee_root_id as rejecte22_9_, agreementb0_.status_root_id as status_23_9_, agreementb0_.system_number as system_24_9_, agreementb0_.version_number as version25_9_, agreementb0_.accompanied_contract as accompa26_9_, agreementb0_.accounting_type_id as account27_9_, agreementb0_.additional_info as additio28_9_, agreementb0_.agreement_number_short_name as agreeme29_9_, agreementb0_.agreement_number_year as agreeme30_9_, agreementb0_.controlled_cooperation_level_id as control31_9_, agreementb0_.need_change_status_to_sba as need_ch32_9_, agreementb0_.project_management_root_id as project33_9_, agreementb0_.readiness_compliant as readine34_9_, agreementb0_.responsible_employee as respons35_9_ from bagrsm.bagr_agreement agreementb0_ where agreementb0_.agreement_type_root_id=1 and agreementb0_.id=? and agreementb0_.status_root_id<>?
  157. 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_.agreement_number_serial_number as agreemen9_9_, agreementb0_.agreement_number_text_value as agreeme10_9_, agreementb0_.create_date as create_11_9_, agreementb0_.edit_reason as edit_re12_9_, agreementb0_.edit_reason_id as edit_re13_9_, agreementb0_.editor_employee_id as editor_14_9_, agreementb0_.editor_organization_id as editor_15_9_, agreementb0_.editor_organization_version_id as editor_16_9_, agreementb0_.from_credit_road as from_cr17_9_, agreementb0_.locked as locked18_9_, agreementb0_.on_paper as on_pape19_9_, agreementb0_.organization_id as organiz20_9_, agreementb0_.organization_version_id as organiz21_9_, agreementb0_.rejected_employee_root_id as rejecte22_9_, agreementb0_.status_root_id as status_23_9_, agreementb0_.system_number as system_24_9_, agreementb0_.version_number as version25_9_, agreementb0_.accompanied_contract as accompa26_9_, agreementb0_.accounting_type_id as account27_9_, agreementb0_.additional_info as additio28_9_, agreementb0_.agreement_number_short_name as agreeme29_9_, agreementb0_.agreement_number_year as agreeme30_9_, agreementb0_.controlled_cooperation_level_id as control31_9_, agreementb0_.need_change_status_to_sba as need_ch32_9_, agreementb0_.project_management_root_id as project33_9_, agreementb0_.readiness_compliant as readine34_9_, agreementb0_.responsible_employee as respons35_9_ from bagrsm.bagr_agreement agreementb0_ where agreementb0_.agreement_type_root_id=1 and agreementb0_.root_id=? and agreementb0_.status_root_id=? and agreementb0_.id<>?
  158. Hibernate: select filemetada0_.id as id1_73_, filemetada0_.blob_id as blob_id2_73_, filemetada0_.blob_url as blob_url3_73_, filemetada0_.context as context4_73_, filemetada0_.create_date as create_d5_73_, filemetada0_.document_date as document6_73_, filemetada0_.document_number as document7_73_, filemetada0_.document_status_root_id as document8_73_, filemetada0_.document_type_code as document9_73_, filemetada0_.document_type_id as documen10_73_, filemetada0_.entity_id as entity_11_73_, filemetada0_.entity_type as entity_12_73_, filemetada0_.hash as hash13_73_, filemetada0_.hidden as hidden14_73_, filemetada0_.last_editing_date as last_ed15_73_, filemetada0_.linked_sign_object as linked_16_73_, filemetada0_.name as name17_73_, filemetada0_.signed_by_one_party as signed_18_73_, filemetada0_.size as size19_73_, filemetada0_.status as status20_73_, filemetada0_.user_root_id as user_ro21_73_, filemetada0_.visible_to_client as visible22_73_ from fssm.fs_file filemetada0_ where filemetada0_.entity_type=? and filemetada0_.entity_id=?
  159. Hibernate: select agreementb0_.id as id1_25_, agreementb0_.last_editing_date as last_edi2_25_, agreementb0_.actual as actual3_25_, agreementb0_.approval_reason_id as approval4_25_, agreementb0_.comment_text as comment_5_25_, agreementb0_.create_date as create_d6_25_, agreementb0_.employee_root_id as employee7_25_, agreementb0_.message_subject_id as message_8_25_, agreementb0_.operation_type_root_id as operatio9_25_, agreementb0_.organization_root_id as organiz10_25_, agreementb0_.reason_text as reason_11_25_, agreementb0_.system_comment as system_12_25_, agreementb0_.visible_only_to_bank as visible13_25_, agreementb0_.agreement_id as agreeme14_25_, agreementb0_.agreement_root_id as agreeme15_25_ from bagrsm.bagr_comment agreementb0_ where agreementb0_.agreement_id=?
  160. Hibernate: select agreementc0_.id as id1_26_, agreementc0_.last_editing_date as last_edi2_26_, agreementc0_.comment_id as comment_3_26_, agreementc0_.hash as hash4_26_, agreementc0_.type as type5_26_ from bagrsm.bagr_comment_sign_block agreementc0_ where agreementc0_.comment_id=?
  161. Hibernate: select agreementc0_.id as id1_26_, agreementc0_.last_editing_date as last_edi2_26_, agreementc0_.comment_id as comment_3_26_, agreementc0_.hash as hash4_26_, agreementc0_.type as type5_26_ from bagrsm.bagr_comment_sign_block agreementc0_ where agreementc0_.comment_id=?    DEBUG   backend develop
  162.     May 25, 2021 @ 13:46:59.250 Алгоритм сохранения документов для сущности (id: 35410, type: BANK_SUPPORT_AGREEMENT, number: БС250520212021-354101345) был успешно запущен. reject: true, documentsSize: 2
  163. Hibernate: select folderenti0_.id as id1_70_, folderenti0_.last_editing_date as last_edi2_70_, folderenti0_.client_root_id as client_r3_70_, folderenti0_.create_date as create_d4_70_, folderenti0_.deleted as deleted5_70_, folderenti0_.entity_root_id as entity_r6_70_, folderenti0_.entity_type_root_id as entity_t7_70_, folderenti0_.folder_type_root_id as folder_t8_70_, folderenti0_.name as name9_70_, folderenti0_.parent_folder_id as parent_10_70_ from edsm.ed_folder folderenti0_ where folderenti0_.entity_type_root_id=? and folderenti0_.entity_root_id=? and folderenti0_.client_root_id=? and folderenti0_.deleted=false limit ?
  164. Hibernate: insert into edsm.ed_folder (last_editing_date, client_root_id, create_date, deleted, entity_root_id, entity_type_root_id, folder_type_root_id, name, parent_folder_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
  165. Hibernate: select folderenti0_.id as id1_70_, folderenti0_.last_editing_date as last_edi2_70_, folderenti0_.client_root_id as client_r3_70_, folderenti0_.create_date as create_d4_70_, folderenti0_.deleted as deleted5_70_, folderenti0_.entity_root_id as entity_r6_70_, folderenti0_.entity_type_root_id as entity_t7_70_, folderenti0_.folder_type_root_id as folder_t8_70_, folderenti0_.name as name9_70_, folderenti0_.parent_folder_id as parent_10_70_ from edsm.ed_folder folderenti0_ where folderenti0_.client_root_id=? and folderenti0_.folder_type_root_id=?    DEBUG   backend develop
  166.     May 25, 2021 @ 13:47:04.755 Алгоритм сохранения документов для сущности (id: 35410, type: BANK_SUPPORT_AGREEMENT, number: БС250520212021-354101345) был успешно выполнен. Количество обновленных/созданных документов: 1
  167. Hibernate: select nsiagreeme0_.id as id1_82_, nsiagreeme0_.actual as actual2_82_, nsiagreeme0_.create_date as create_d3_82_, nsiagreeme0_.deleted as deleted4_82_, nsiagreeme0_.inner_code as inner_co5_82_, nsiagreeme0_.last_editing_date as last_edi6_82_, nsiagreeme0_.root_id as root_id7_82_, nsiagreeme0_.sort_order as sort_ord8_82_, nsiagreeme0_.value as value9_82_, nsiagreeme0_.version_number as version10_82_, nsiagreeme0_.applicable_to_agreement_type_root_id as applica11_82_ from nsism.nsi_agreement_status nsiagreeme0_ where (nsiagreeme0_.root_id in (2 , 5)) and nsiagreeme0_.actual=? and nsiagreeme0_.deleted=? order by nsiagreeme0_.sort_order asc
  168. Hibernate: select organizati0_.ppa_organization_id as col_0_0_ from ppasm.ppa_organization_version organizati0_ inner join ppasm.ppa_organization_role orgroles1_ on organizati0_.id=orgroles1_.ppa_org_version_id where orgroles1_.org_role_root_id=? and organizati0_.actual=true DEBUG   backend develop
  169.     May 25, 2021 @ 13:47:05.125 processEventNotificationQueue request: NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}
  170. Hibernate: select notiftempl0_.id as id1_75_, notiftempl0_.last_editing_date as last_edi2_75_, notiftempl0_.email_enabled as email_en3_75_, notiftempl0_.email_event_name as email_ev4_75_, notiftempl0_.email_mandatory as email_ma5_75_, notiftempl0_.email_template as email_te6_75_, notiftempl0_.entity_type_root_id as entity_t7_75_, notiftempl0_.event_code as event_co8_75_, notiftempl0_.important as importan9_75_, notiftempl0_.inner_enabled as inner_e10_75_, notiftempl0_.inner_event_name as inner_e11_75_, notiftempl0_.inner_mandatory as inner_m12_75_, notiftempl0_.inner_template as inner_t13_75_, notiftempl0_.task as task14_75_ from notifsm.notif_template notiftempl0_ where notiftempl0_.event_code=?
  171. Hibernate: select organizati0_.id as id1_220_0_, organizati0_.last_editing_date as last_edi2_220_0_, organizati0_.login_1c as login_3_220_0_, organizati0_.ogrn as ogrn4_220_0_, organizati0_.password_1c as password5_220_0_, organizati0_.session_expiration_1c as session_6_220_0_, organizati0_.session_id_1c as session_7_220_0_ from ppasm.ppa_organization organizati0_ where organizati0_.id=?
  172. Hibernate: select organizati0_.id as id1_223_0_, organizati0_.last_editing_date as last_edi2_223_0_, organizati0_.block as block3_223_0_, organizati0_.block_date as block_da4_223_0_, organizati0_.block_reason_id as block_re5_223_0_, organizati0_.on_registration as on_regis6_223_0_, organizati0_.registered as register7_223_0_, organizati0_.registration_date as registra8_223_0_ from ppasm.ppa_organization_status organizati0_ where organizati0_.id=?
  173. Hibernate: select orgroles0_.ppa_org_version_id as ppa_org_4_221_0_, orgroles0_.id as id1_221_0_, orgroles0_.id as id1_221_1_, orgroles0_.last_editing_date as last_edi2_221_1_, orgroles0_.org_role_root_id as org_role3_221_1_, orgroles0_.ppa_org_version_id as ppa_org_4_221_1_ from ppasm.ppa_organization_role orgroles0_ where orgroles0_.ppa_org_version_id=?
  174. Hibernate: select nsicurrenc0_.id as id1_102_0_, nsicurrenc0_.actual as actual2_102_0_, nsicurrenc0_.create_date as create_d3_102_0_, nsicurrenc0_.deleted as deleted4_102_0_, nsicurrenc0_.inner_code as inner_co5_102_0_, nsicurrenc0_.last_editing_date as last_edi6_102_0_, nsicurrenc0_.root_id as root_id7_102_0_, nsicurrenc0_.sort_order as sort_ord8_102_0_, nsicurrenc0_.value as value9_102_0_, nsicurrenc0_.version_number as version10_102_0_, nsicurrenc0_.code_letter as code_le11_102_0_, nsicurrenc0_.code_numeric as code_nu12_102_0_ from nsism.nsi_currency nsicurrenc0_ where nsicurrenc0_.id=?
  175. Hibernate: select organizati0_.ppa_organization_id as col_0_0_ from ppasm.ppa_organization_version organizati0_ inner join ppasm.ppa_organization_role orgroles1_ on organizati0_.id=orgroles1_.ppa_org_version_id where orgroles1_.org_role_root_id=? and organizati0_.actual=true DEBUG   backend develop
  176.     May 25, 2021 @ 13:47:05.399 Created notification: id=2391722, receiver=NotificationReceiver{employeeRootId=34, firstName='Иван', middleName='Иванович', lastName='Иванов', email='lanit_ivanov@lanit.ru', phone='79265964656'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}
  177. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  178.     May 25, 2021 @ 13:47:05.459 Created notification: id=2391723, receiver=NotificationReceiver{employeeRootId=935, firstName='Влас', middleName='Альбертович', lastName='Потапов', email='usertest@test.ru', phone='95465462456'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}    DEBUG   backend develop
  179.     May 25, 2021 @ 13:47:05.958 Created notification: id=2391724, receiver=NotificationReceiver{employeeRootId=233, firstName='Михаил', middleName='Викторович', lastName='Дроздов', email='www@rr.rr', phone='71233210005'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}
  180. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  181.     May 25, 2021 @ 13:47:06.072 Created notification: id=2391725, receiver=NotificationReceiver{employeeRootId=619, firstName='Банка', middleName='null', lastName='Сотрудник', email='newmail123@mail.orgg', phone='79523657444'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}
  182. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  183.     May 25, 2021 @ 13:47:06.184 Created notification: id=2391726, receiver=NotificationReceiver{employeeRootId=173, firstName='Тест', middleName='null', lastName='Тестовый', email='test@mail.ru', phone='79178524589'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}
  184. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  185.     May 25, 2021 @ 13:47:06.194 Created notification: id=2391727, receiver=NotificationReceiver{employeeRootId=942, firstName='Олег', middleName='Александрович', lastName='Новый', email='xxx@yyy.ru', phone='79231453257'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}
  186. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  187. May 25, 2021 @ 13:47:06.202 Created notification: id=2391728, receiver=NotificationReceiver{employeeRootId=944, firstName='Олег3', middleName='Александрович', lastName='Новый', email='xxx@yyy.ru', phone='79367432468'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}
  188. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  189.     May 25, 2021 @ 13:47:06.210 Created notification: id=2391729, receiver=NotificationReceiver{employeeRootId=946, firstName='Олег5', middleName='Александрович', lastName='Новый', email='xxx@yyy.ru', phone='79372432564'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}
  190. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  191.     May 25, 2021 @ 13:47:06.319 Created notification: id=2391730, receiver=NotificationReceiver{employeeRootId=947, firstName='Олег6', middleName='Александрович', lastName='Новый', email='xxx@yyy.ru', phone='79765485478'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}
  192. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  193.     May 25, 2021 @ 13:47:06.382 Created notification: id=2391731, receiver=NotificationReceiver{employeeRootId=888, firstName='Эрнест', middleName='null', lastName='Хемингуэй', email='Hemingway@testtest.test', phone='72342321241'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}   DEBUG   backend develop
  194.     May 25, 2021 @ 13:47:06.431 Получен запрос от Camunda: {"entityRootId":35410,"entityVersionId":35410,"taskTypeCode":1,"assigneeRootId":null,"targetStatus":null}, corellationId = c8261f88-bd35-11eb-b379-b64357ae58f9
  195. 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_.agreement_number_serial_number as agreemen9_9_, agreementb0_.agreement_number_text_value as agreeme10_9_, agreementb0_.create_date as create_11_9_, agreementb0_.edit_reason as edit_re12_9_, agreementb0_.edit_reason_id as edit_re13_9_, agreementb0_.editor_employee_id as editor_14_9_, agreementb0_.editor_organization_id as editor_15_9_, agreementb0_.editor_organization_version_id as editor_16_9_, agreementb0_.from_credit_road as from_cr17_9_, agreementb0_.locked as locked18_9_, agreementb0_.on_paper as on_pape19_9_, agreementb0_.organization_id as organiz20_9_, agreementb0_.organization_version_id as organiz21_9_, agreementb0_.rejected_employee_root_id as rejecte22_9_, agreementb0_.status_root_id as status_23_9_, agreementb0_.system_number as system_24_9_, agreementb0_.version_number as version25_9_, agreementb0_.accompanied_contract as accompa26_9_, agreementb0_.accounting_type_id as account27_9_, agreementb0_.additional_info as additio28_9_, agreementb0_.agreement_number_short_name as agreeme29_9_, agreementb0_.agreement_number_year as agreeme30_9_, agreementb0_.controlled_cooperation_level_id as control31_9_, agreementb0_.need_change_status_to_sba as need_ch32_9_, agreementb0_.project_management_root_id as project33_9_, agreementb0_.readiness_compliant as readine34_9_, agreementb0_.responsible_employee as respons35_9_ from bagrsm.bagr_agreement agreementb0_ where agreementb0_.agreement_type_root_id=1 and agreementb0_.id=?
  196. 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=?
  197. 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_.agreement_number_serial_number as agreemen9_9_0_, agreementb1_.agreement_number_text_value as agreeme10_9_0_, agreementb1_.create_date as create_11_9_0_, agreementb1_.edit_reason as edit_re12_9_0_, agreementb1_.edit_reason_id as edit_re13_9_0_, agreementb1_.editor_employee_id as editor_14_9_0_, agreementb1_.editor_organization_id as editor_15_9_0_, agreementb1_.editor_organization_version_id as editor_16_9_0_, agreementb1_.from_credit_road as from_cr17_9_0_, agreementb1_.locked as locked18_9_0_, agreementb1_.on_paper as on_pape19_9_0_, agreementb1_.organization_id as organiz20_9_0_, agreementb1_.organization_version_id as organiz21_9_0_, agreementb1_.rejected_employee_root_id as rejecte22_9_0_, agreementb1_.status_root_id as status_23_9_0_, agreementb1_.system_number as system_24_9_0_, agreementb1_.version_number as version25_9_0_, agreementb1_.accompanied_contract as accompa26_9_0_, agreementb1_.accounting_type_id as account27_9_0_, agreementb1_.additional_info as additio28_9_0_, agreementb1_.agreement_number_short_name as agreeme29_9_0_, agreementb1_.agreement_number_year as agreeme30_9_0_, agreementb1_.controlled_cooperation_level_id as control31_9_0_, agreementb1_.need_change_status_to_sba as need_ch32_9_0_, agreementb1_.project_management_root_id as project33_9_0_, agreementb1_.readiness_compliant as readine34_9_0_, agreementb1_.responsible_employee as respons35_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=?
  198. Hibernate: select agreementb0_.agreement_id as agreeme17_12_0_, agreementb0_.id as id1_12_0_, agreementb0_.id as id1_12_1_, agreementb0_.last_editing_date as last_edi2_12_1_, agreementb0_.root_id as root_id3_12_1_, agreementb0_.agreement_id as agreeme17_12_1_, agreementb0_.create_date as create_d4_12_1_, agreementb0_.fund_code as fund_cod5_12_1_, agreementb0_.issue_date as issue_da6_12_1_, agreementb0_.object_address as object_a7_12_1_, agreementb0_.object_address_text as object_a8_12_1_, agreementb0_.object_eis_id as object_e9_12_1_, agreementb0_.object_name as object_10_12_1_, agreementb0_.object_number as object_11_12_1_, agreementb0_.project_cost as project12_12_1_, agreementb0_.project_id as project13_12_1_, agreementb0_.prolonged_to_date as prolong14_12_1_, agreementb0_.region_id as region_15_12_1_, agreementb0_.valid_to_date as valid_t16_12_1_ from bagrsm.bagr_agreement_bs_object agreementb0_ where agreementb0_.agreement_id=?
  199. Hibernate: select bankdetail0_.id as id1_36_, bankdetail0_.last_editing_date as last_edi2_36_, bankdetail0_.root_id as root_id3_36_, bankdetail0_.account as account4_36_, bankdetail0_.account_status_root_id as account_5_36_, bankdetail0_.account_type_root_id as account_6_36_, bankdetail0_.actual as actual7_36_, bankdetail0_.author_employee_root_id as author_e8_36_, bankdetail0_.author_org_root_id as author_o9_36_, bankdetail0_.base_agreement_date as base_ag10_36_, bankdetail0_.base_agreement_number as base_ag11_36_, bankdetail0_.bic as bic12_36_, bankdetail0_.close_date as close_d13_36_, bankdetail0_.correspondent_account as corresp14_36_, bankdetail0_.create_date as create_15_36_, bankdetail0_.credit_organization_name as credit_16_36_, bankdetail0_.currency_root_id as currenc17_36_, bankdetail0_.details_name as details18_36_, bankdetail0_.first_name as first_n19_36_, bankdetail0_.from_athena as from_at20_36_, bankdetail0_.inn as inn21_36_, bankdetail0_.last_name as last_na22_36_, bankdetail0_.middle_name as middle_23_36_, bankdetail0_.na_id as na_id24_36_, bankdetail0_.na_update_date as na_upda25_36_, bankdetail0_.open_date as open_da26_36_, bankdetail0_.ppa_organization_id as ppa_org27_36_, bankdetail0_.person_recipient as person_28_36_, bankdetail0_.recipient_name as recipie29_36_, bankdetail0_.subdivision_code as subdivi30_36_, bankdetail0_.version_number as version31_36_ from bdtsm.bdt_bank_details bankdetail0_ where bankdetail0_.root_id=? and bankdetail0_.actual=?
  200. Hibernate: select balanceent0_.id as id1_35_, balanceent0_.last_editing_date as last_edi2_35_, balanceent0_.root_id as root_id3_35_, balanceent0_.actual as actual4_35_, balanceent0_.balance as balance5_35_, balanceent0_.bank_details_root_id as bank_det6_35_, balanceent0_.create_date as create_d7_35_, balanceent0_.version_number as version_8_35_ from bdtsm.bdt_balance balanceent0_ where balanceent0_.actual=? and balanceent0_.bank_details_root_id=?
  201. Hibernate: select organizati0_.ppa_organization_id as col_0_0_ from ppasm.ppa_organization_version organizati0_ inner join ppasm.ppa_organization_role orgroles1_ on organizati0_.id=orgroles1_.ppa_org_version_id where orgroles1_.org_role_root_id=? and organizati0_.actual=true
  202. Hibernate: select bankdetail0_.bank_details_id as bank_det6_40_0_, bankdetail0_.id as id1_40_0_, bankdetail0_.id as id1_40_1_, bankdetail0_.last_editing_date as last_edi2_40_1_, bankdetail0_.author_organization_root_id as author_o3_40_1_, bankdetail0_.bank_details_id as bank_det6_40_1_, bankdetail0_.deleted as deleted4_40_1_, bankdetail0_.recipient_name as recipien5_40_1_ from bdtsm.bdt_bank_details_organizations bankdetail0_ where bankdetail0_.bank_details_id=?
  203. Hibernate: select organizati0_.id as id1_224_, organizati0_.last_editing_date as last_edi2_224_, organizati0_.actual as actual3_224_, organizati0_.version_create_date as version_4_224_, organizati0_.version_number as version_5_224_, organizati0_.address as address6_224_, organizati0_.agency_territory as agency_t7_224_, organizati0_.agency_type as agency_t8_224_, organizati0_.is_branch as is_branc9_224_, organizati0_.branches_count as branche10_224_, organizati0_.data_source as data_so11_224_, organizati0_.email as email12_224_, organizati0_.email_confirmed as email_c13_224_, organizati0_.esia_id as esia_id14_224_, organizati0_.factual_address as factual15_224_, organizati0_.fax as fax16_224_, organizati0_.full_name as full_na17_224_, organizati0_.head_ppa_org_id as head_pp38_224_, organizati0_.ifrs_reporting as ifrs_re18_224_, organizati0_.information_source_root_id as informa19_224_, organizati0_.inn as inn20_224_, organizati0_.kpp as kpp21_224_, organizati0_.na_branch_code as na_bran22_224_, organizati0_.na_client_id as na_clie23_224_, organizati0_.na_id as na_id24_224_, organizati0_.na_status as na_stat25_224_, organizati0_.na_update_date as na_upda26_224_, organizati0_.not_blacklisted as not_bla27_224_, organizati0_.ogrn as ogrn28_224_, organizati0_.okopf_code as okopf_c29_224_, organizati0_.ppa_organization_id as ppa_org30_224_, organizati0_.organization_type as organiz31_224_, organizati0_.phone as phone32_224_, organizati0_.short_name as short_n33_224_, organizati0_.state_registration_date as state_r34_224_, organizati0_.status_id as status_39_224_, organizati0_.statutory_full_name as statuto35_224_, organizati0_.statutory_name_differs as statuto36_224_, organizati0_.statutory_short_name as statuto37_224_ from ppasm.ppa_organization_version organizati0_ where organizati0_.ppa_organization_id=? and organizati0_.actual=?
  204. Hibernate: select organizati0_.id as id1_220_0_, organizati0_.last_editing_date as last_edi2_220_0_, organizati0_.login_1c as login_3_220_0_, organizati0_.ogrn as ogrn4_220_0_, organizati0_.password_1c as password5_220_0_, organizati0_.session_expiration_1c as session_6_220_0_, organizati0_.session_id_1c as session_7_220_0_ from ppasm.ppa_organization organizati0_ where organizati0_.id=?
  205. Hibernate: select organizati0_.id as id1_223_0_, organizati0_.last_editing_date as last_edi2_223_0_, organizati0_.block as block3_223_0_, organizati0_.block_date as block_da4_223_0_, organizati0_.block_reason_id as block_re5_223_0_, organizati0_.on_registration as on_regis6_223_0_, organizati0_.registered as register7_223_0_, organizati0_.registration_date as registra8_223_0_ from ppasm.ppa_organization_status organizati0_ where organizati0_.id=?
  206. Hibernate: select orgroles0_.ppa_org_version_id as ppa_org_4_221_0_, orgroles0_.id as id1_221_0_, orgroles0_.id as id1_221_1_, orgroles0_.last_editing_date as last_edi2_221_1_, orgroles0_.org_role_root_id as org_role3_221_1_, orgroles0_.ppa_org_version_id as ppa_org_4_221_1_ from ppasm.ppa_organization_role orgroles0_ where orgroles0_.ppa_org_version_id=?
  207. Hibernate: select bankdetail0_.id as id1_38_, bankdetail0_.account as account2_38_, bankdetail0_.actual as actual3_38_, bankdetail0_.bic as bic4_38_, bankdetail0_.contractor_agreement_date as contract5_38_, bankdetail0_.contractor_agreement_number as contract6_38_, bankdetail0_.object_address as object_a7_38_, bankdetail0_.object_name as object_n8_38_, bankdetail0_.object_number as object_n9_38_, bankdetail0_.root_id as root_id10_38_ from bdtsm.bdt_bank_details_objects_dvru_v bankdetail0_ where bankdetail0_.id in (?)
  208. Hibernate: select bankdetail0_.id as id1_36_, bankdetail0_.last_editing_date as last_edi2_36_, bankdetail0_.root_id as root_id3_36_, bankdetail0_.account as account4_36_, bankdetail0_.account_status_root_id as account_5_36_, bankdetail0_.account_type_root_id as account_6_36_, bankdetail0_.actual as actual7_36_, bankdetail0_.author_employee_root_id as author_e8_36_, bankdetail0_.author_org_root_id as author_o9_36_, bankdetail0_.base_agreement_date as base_ag10_36_, bankdetail0_.base_agreement_number as base_ag11_36_, bankdetail0_.bic as bic12_36_, bankdetail0_.close_date as close_d13_36_, bankdetail0_.correspondent_account as corresp14_36_, bankdetail0_.create_date as create_15_36_, bankdetail0_.credit_organization_name as credit_16_36_, bankdetail0_.currency_root_id as currenc17_36_, bankdetail0_.details_name as details18_36_, bankdetail0_.first_name as first_n19_36_, bankdetail0_.from_athena as from_at20_36_, bankdetail0_.inn as inn21_36_, bankdetail0_.last_name as last_na22_36_, bankdetail0_.middle_name as middle_23_36_, bankdetail0_.na_id as na_id24_36_, bankdetail0_.na_update_date as na_upda25_36_, bankdetail0_.open_date as open_da26_36_, bankdetail0_.ppa_organization_id as ppa_org27_36_, bankdetail0_.person_recipient as person_28_36_, bankdetail0_.recipient_name as recipie29_36_, bankdetail0_.subdivision_code as subdivi30_36_, bankdetail0_.version_number as version31_36_ from bdtsm.bdt_bank_details bankdetail0_ where bankdetail0_.root_id=? and bankdetail0_.actual=?
  209. Hibernate: select balanceent0_.id as id1_35_, balanceent0_.last_editing_date as last_edi2_35_, balanceent0_.root_id as root_id3_35_, balanceent0_.actual as actual4_35_, balanceent0_.balance as balance5_35_, balanceent0_.bank_details_root_id as bank_det6_35_, balanceent0_.create_date as create_d7_35_, balanceent0_.version_number as version_8_35_ from bdtsm.bdt_balance balanceent0_ where balanceent0_.actual=? and balanceent0_.bank_details_root_id=?
  210. Hibernate: select organizati0_.id as id1_224_, organizati0_.last_editing_date as last_edi2_224_, organizati0_.actual as actual3_224_, organizati0_.version_create_date as version_4_224_, organizati0_.version_number as version_5_224_, organizati0_.address as address6_224_, organizati0_.agency_territory as agency_t7_224_, organizati0_.agency_type as agency_t8_224_, organizati0_.is_branch as is_branc9_224_, organizati0_.branches_count as branche10_224_, organizati0_.data_source as data_so11_224_, organizati0_.email as email12_224_, organizati0_.email_confirmed as email_c13_224_, organizati0_.esia_id as esia_id14_224_, organizati0_.factual_address as factual15_224_, organizati0_.fax as fax16_224_, organizati0_.full_name as full_na17_224_, organizati0_.head_ppa_org_id as head_pp38_224_, organizati0_.ifrs_reporting as ifrs_re18_224_, organizati0_.information_source_root_id as informa19_224_, organizati0_.inn as inn20_224_, organizati0_.kpp as kpp21_224_, organizati0_.na_branch_code as na_bran22_224_, organizati0_.na_client_id as na_clie23_224_, organizati0_.na_id as na_id24_224_, organizati0_.na_status as na_stat25_224_, organizati0_.na_update_date as na_upda26_224_, organizati0_.not_blacklisted as not_bla27_224_, organizati0_.ogrn as ogrn28_224_, organizati0_.okopf_code as okopf_c29_224_, organizati0_.ppa_organization_id as ppa_org30_224_, organizati0_.organization_type as organiz31_224_, organizati0_.phone as phone32_224_, organizati0_.short_name as short_n33_224_, organizati0_.state_registration_date as state_r34_224_, organizati0_.status_id as status_39_224_, organizati0_.statutory_full_name as statuto35_224_, organizati0_.statutory_name_differs as statuto36_224_, organizati0_.statutory_short_name as statuto37_224_ from ppasm.ppa_organization_version organizati0_ where organizati0_.ppa_organization_id=? and organizati0_.actual=?
  211. Hibernate: select bankdetail0_.id as id1_38_, bankdetail0_.account as account2_38_, bankdetail0_.actual as actual3_38_, bankdetail0_.bic as bic4_38_, bankdetail0_.contractor_agreement_date as contract5_38_, bankdetail0_.contractor_agreement_number as contract6_38_, bankdetail0_.object_address as object_a7_38_, bankdetail0_.object_name as object_n8_38_, bankdetail0_.object_number as object_n9_38_, bankdetail0_.root_id as root_id10_38_ from bdtsm.bdt_bank_details_objects_dvru_v bankdetail0_ where bankdetail0_.id in (?)
  212. Hibernate: select tasksm.getNextTaskNumberCounter(?, ?, ?); DEBUG   backend develop
  213.     May 25, 2021 @ 13:47:06.600 Created notification: id=2391732, receiver=NotificationReceiver{employeeRootId=889, firstName='Василий', middleName='Алибабаевич', lastName='Алибабаев', email='Vasya@rbs.internal', phone='79009998877'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}
  214. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  215.     May 25, 2021 @ 13:47:06.604 Created notification: id=2391733, receiver=NotificationReceiver{employeeRootId=954, firstName='Роман', middleName='Юлманович', lastName='Жуков', email='xrmtesttest@test.ru', phone='77922117513'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}
  216. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  217.     May 25, 2021 @ 13:47:06.612 Created notification: id=2391734, receiver=NotificationReceiver{employeeRootId=59, firstName='Полина', middleName='Алексеевна', lastName='Афанасьева', email='AAfanaseva@gmail.com', phone='79548965896'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}
  218. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  219.     May 25, 2021 @ 13:47:06.618 Created notification: id=2391735, receiver=NotificationReceiver{employeeRootId=955, firstName='Агафон', middleName='Яковлевич', lastName='Исаков', email='xrmtesttt@mailxrm.ru', phone='71231244421'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}
  220. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  221.     May 25, 2021 @ 13:47:06.630 Created notification: id=2391736, receiver=NotificationReceiver{employeeRootId=60, firstName='Дарья', middleName='Ковальчук', lastName='Владимировна', email='kovtest1@test.ru', phone='1115588'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410} DEBUG   backend develop
  222.     May 25, 2021 @ 13:47:06.773 Отправлен ответ CamundaBase{entityRootId=35410, entityVersionId=35410} в Camunda в очередь camundaRbs::camundaCreateTaskResponse, corellationId = c8261f88-bd35-11eb-b379-b64357ae58f9   DEBUG   backend develop
  223.     May 25, 2021 @ 13:47:07.853 Created notification: id=2391737, receiver=NotificationReceiver{employeeRootId=956, firstName='Алексеев', middleName='Львович', lastName='Мартын', email='xrmeewe@mailxrm.com', phone='74444421231'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}
  224. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  225.     May 25, 2021 @ 13:47:07.860 Created notification: id=2391738, receiver=NotificationReceiver{employeeRootId=61, firstName='Анна', middleName='Аннова', lastName='Анновна', email='user0603@user.ru', phone='79528569898'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}   DEBUG   backend develop
  226.     May 25, 2021 @ 13:47:08.315 Created notification: id=2391739, receiver=NotificationReceiver{employeeRootId=958, firstName='Николай', middleName='Семенович', lastName='Гордов', email='semenov1@ya.ru', phone='75465465465'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}
  227. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  228.     May 25, 2021 @ 13:47:08.326 Created notification: id=2391740, receiver=NotificationReceiver{employeeRootId=959, firstName='Николай', middleName='Семенович', lastName='Гордов', email='semenov@ya.ru', phone='75465465465'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}
  229. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  230.     May 25, 2021 @ 13:47:08.340 Created notification: id=2391741, receiver=NotificationReceiver{employeeRootId=703, firstName='Виктория', middleName='Мансуровна', lastName='Нургалиева', email='nurgalieva_bank@m.orggg', phone='79954125014'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}
  231. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  232.     May 25, 2021 @ 13:47:08.383 Created notification: id=2391742, receiver=NotificationReceiver{employeeRootId=576, firstName='44', middleName='44', lastName='44', email='fggff@ya.ru', phone='79653934444'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}
  233. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  234.     May 25, 2021 @ 13:47:08.389 Created notification: id=2391743, receiver=NotificationReceiver{employeeRootId=1, firstName='Артем', middleName='Николаевич', lastName='Гусев', email='gusev13@gmail.com', phone='74950472388'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410} DEBUG   backend develop
  235.     May 25, 2021 @ 13:47:08.534 Created notification: id=2391744, receiver=NotificationReceiver{employeeRootId=9, firstName='Ирина', middleName='Петровна', lastName='Иванова', email='null', phone='null'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}
  236. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  237.     May 25, 2021 @ 13:47:08.541 Created notification: id=2391745, receiver=NotificationReceiver{employeeRootId=80, firstName='Виктория', middleName='Дмитриевна', lastName='Ильина', email='usertestilina@test.ru', phone='1115588'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}    DEBUG   backend develop
  238.     May 25, 2021 @ 13:47:08.732 Created notification: id=2391746, receiver=NotificationReceiver{employeeRootId=977, firstName='Николай', middleName='Владимирович', lastName='Яров', email='w@t.ru', phone='75546456456'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}
  239. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  240.     May 25, 2021 @ 13:47:08.738 Created notification: id=2391747, receiver=NotificationReceiver{employeeRootId=210, firstName='тест', middleName='тест', lastName='тест', email='text@text.com', phone='77575757575'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}
  241. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  242.     May 25, 2021 @ 13:47:08.742 Created notification: id=2391748, receiver=NotificationReceiver{employeeRootId=19, firstName='Бэльб', middleName='null', lastName='Банкова', email='test@ma.ru', phone='79565656566'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}
  243. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  244.     May 25, 2021 @ 13:47:08.747 Created notification: id=2391749, receiver=NotificationReceiver{employeeRootId=83, firstName='Юрий', middleName='Михайлович', lastName='Десяткин', email='1EDITusertest@mail.com', phone='75157271825'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}   DEBUG   backend develop
  245.     May 25, 2021 @ 13:47:09.131 Created notification: id=2391750, receiver=NotificationReceiver{employeeRootId=90, firstName='Иван', middleName='Петрович', lastName='Петриченко', email='petrichenko_bank@test.ru', phone='73331755204'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410} DEBUG   backend develop
  246.     May 25, 2021 @ 13:47:09.582 Created notification: id=2391751, receiver=NotificationReceiver{employeeRootId=91, firstName='Анастасия', middleName='Витальевна', lastName='Войтович', email='user81@test.ru', phone='7955588'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}
  247. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  248.     May 25, 2021 @ 13:47:09.588 Created notification: id=2391752, receiver=NotificationReceiver{employeeRootId=93, firstName='Роман', middleName='Иванович', lastName='Петров', email='usertest@test.ru', phone='1115588'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}
  249. Hibernate: insert into notifsm.notification (bank_only, create_date, email_event_name, email_subject, email_text, entity_root_id, entity_type_root_id, entity_version_id, event_code, important, inner_event_name, inner_text, last_editing_date, popup_sended, receiver_root_id, status, status_editing_date, task) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  DEBUG   backend develop
  250.     May 25, 2021 @ 13:47:09.593 Created notification: id=2391753, receiver=NotificationReceiver{employeeRootId=30, firstName='Сергей', middleName='Петрович', lastName='Гончаров', email='goncharov@mail.ru', phone='89267866004'}, request=NotificationCreateRequest{entityType=BANK_SUPPORT_AGREEMENTeventCode=CO_DBS_132entity.id=35410entity.rootId=35410}    DEBUG   backend develop
  251.     May 25, 2021 @ 13:47:44.914 Получен запрос от Camunda: {"entityRootId":35410,"entityVersionId":35410,"taskId":10462,"assigneeRootId":888,"taskTargetStatus":"ST_OK_ASSIGNEE","pauseReason":null,"manualTask":false,"pauseReasonRootId":null}, corellationId = deee7dc5-bd35-11eb-bd14-0e9d94984603
  252. Hibernate: select taskentity0_.id as id1_250_0_, taskentity0_.last_editing_date as last_edi2_250_0_, taskentity0_.added_manually as added_ma3_250_0_, taskentity0_.additional_info as addition4_250_0_, taskentity0_.assign_date as assign_d5_250_0_, taskentity0_.automatic_distribution as automati6_250_0_, taskentity0_.complete_date as complete7_250_0_, taskentity0_.create_date as create_d8_250_0_, taskentity0_.created_entity_version_id as created_9_250_0_, taskentity0_.entity_root_id as entity_10_250_0_, taskentity0_.entity_status_root_id as entity_11_250_0_, taskentity0_.entity_version_id as entity_12_250_0_, taskentity0_.locked as locked13_250_0_, taskentity0_.performer_employee_id as perform14_250_0_, taskentity0_.previous_entity_version_id as previou15_250_0_, taskentity0_.priority as priorit16_250_0_, taskentity0_.rule_id as rule_id20_250_0_, taskentity0_.task_number as task_nu17_250_0_, taskentity0_.task_status_root_id as task_st18_250_0_, taskentity0_.task_type_root_id as task_ty19_250_0_ from tasksm.task taskentity0_ where taskentity0_.id=?    DEBUG   backend develop
  253.     May 25, 2021 @ 13:47:45.131 Отправлен ответ CamundaBase{entityRootId=35410, entityVersionId=35410} в Camunda в очередь camundaRbs::camundaChangeTaskStatusResponse, corellationId = deee7dc5-bd35-11eb-bd14-0e9d94984603
  254. Hibernate: select count(notificati0_.id) as col_0_0_ from notifsm.notification notificati0_ where notificati0_.receiver_root_id=? and (notificati0_.inner_event_name is not null) and notificati0_.status=?
  255. Hibernate: select notificati0_.id as id1_76_, notificati0_.bank_only as bank_onl2_76_, notificati0_.create_date as create_d3_76_, notificati0_.email_event_name as email_ev4_76_, notificati0_.email_subject as email_su5_76_, notificati0_.email_text as email_te6_76_, notificati0_.entity_root_id as entity_r7_76_, notificati0_.entity_type_root_id as entity_t8_76_, notificati0_.entity_version_id as entity_v9_76_, notificati0_.event_code as event_c10_76_, notificati0_.important as importa11_76_, notificati0_.inner_event_name as inner_e12_76_, notificati0_.inner_text as inner_t13_76_, notificati0_.last_editing_date as last_ed14_76_, notificati0_.popup_sended as popup_s15_76_, notificati0_.receiver_root_id as receive16_76_, notificati0_.status as status17_76_, notificati0_.status_editing_date as status_18_76_, notificati0_.task as task19_76_ from notifsm.notification notificati0_ where notificati0_.receiver_root_id=? and (notificati0_.inner_event_name is not null) and notificati0_.status=? and (notificati0_.popup_sended=? or notificati0_.popup_sended is null) and (notificati0_.create_date between ? and ?) order by notificati0_.create_date desc    DEBUG   backend develop
  256.     May 25, 2021 @ 13:47:48.788 Получен запрос от Camunda: {"entityRootId":35410,"entityVersionId":35410,"taskId":10462,"assigneeRootId":888,"taskTargetStatus":"ST_OK_STARTW","pauseReason":null,"manualTask":false,"pauseReasonRootId":null}, corellationId = e1a05734-bd35-11eb-b379-b64357ae58f9
  257. Hibernate: select employeeve0_.id as id1_217_, employeeve0_.last_editing_date as last_edi2_217_, employeeve0_.actual as actual3_217_, employeeve0_.version_create_date as version_4_217_, employeeve0_.version_number as version_5_217_, employeeve0_.address as address6_217_, employeeve0_.birth_date as birth_da7_217_, employeeve0_.branch_kpp as branch_k8_217_, employeeve0_.citizenship as citizens9_217_, employeeve0_.data_source as data_so10_217_, employeeve0_.delete_date as delete_11_217_, employeeve0_.doc_act_number as doc_act12_217_, employeeve0_.doc_expiry_date as doc_exp13_217_, employeeve0_.doc_first_name as doc_fir14_217_, employeeve0_.doc_issue_date as doc_iss15_217_, employeeve0_.doc_issue_id as doc_iss16_217_, employeeve0_.doc_issue_by as doc_iss17_217_, employeeve0_.doc_last_name as doc_las18_217_, employeeve0_.doc_number as doc_num19_217_, employeeve0_.doc_series as doc_ser20_217_, employeeve0_.doc_type as doc_typ21_217_, employeeve0_.doc_edit_available as doc_edi22_217_, employeeve0_.email as email23_217_, employeeve0_.email_confirmed as email_c24_217_, employeeve0_.ppa_employee_id as ppa_emp45_217_, employeeve0_.esia_id as esia_id25_217_, employeeve0_.first_name as first_n26_217_, employeeve0_.gender as gender27_217_, employeeve0_.inn as inn28_217_, employeeve0_.last_name as last_na29_217_, employeeve0_.middle_name as middle_30_217_, employeeve0_.is_org_chief as is_org_31_217_, employeeve0_.phone as phone32_217_, employeeve0_.phone_confirmation_date as phone_c33_217_, employeeve0_.phone_confirmation_message as phone_c34_217_, employeeve0_.phone_confirmation_status as phone_c35_217_, employeeve0_.phone_confirmed as phone_c36_217_, employeeve0_.phone_number_on_confirmation as phone_n37_217_, employeeve0_.popup_allowed as popup_a38_217_, employeeve0_.position_emp as positio39_217_, employeeve0_.registration_address as registr40_217_, employeeve0_.role_emp as role_em41_217_, employeeve0_.snils as snils42_217_, employeeve0_.status_id as status_46_217_, employeeve0_.subdivision_root_id as subdivi43_217_, employeeve0_.time_zone_root_id as time_zo44_217_ from ppasm.ppa_employee_version employeeve0_ where employeeve0_.ppa_employee_id=? and employeeve0_.actual=?
  258. Hibernate: select employeeen0_.id as id1_211_0_, employeeen0_.last_editing_date as last_edi2_211_0_, employeeen0_.keycloak_user_id as keycloak3_211_0_, employeeen0_.ppa_organization_id as ppa_orga5_211_0_, employeeen0_.user_privileges as user_pri4_211_0_, organizati1_.id as id1_220_1_, organizati1_.last_editing_date as last_edi2_220_1_, organizati1_.login_1c as login_3_220_1_, organizati1_.ogrn as ogrn4_220_1_, organizati1_.password_1c as password5_220_1_, organizati1_.session_expiration_1c as session_6_220_1_, organizati1_.session_id_1c as session_7_220_1_ from ppasm.ppa_employee employeeen0_ inner join ppasm.ppa_organization organizati1_ on employeeen0_.ppa_organization_id=organizati1_.id where employeeen0_.id=?
  259. Hibernate: select employeest0_.id as id1_216_0_, employeest0_.last_editing_date as last_edi2_216_0_, employeest0_.block as block3_216_0_, employeest0_.block_date as block_da4_216_0_, employeest0_.block_info as block_in5_216_0_, employeest0_.block_reason_id as block_re6_216_0_, employeest0_.registered as register7_216_0_, employeest0_.registration_date as registra8_216_0_, employeest0_.unlock_date as unlock_d9_216_0_ from ppasm.ppa_employee_status employeest0_ where employeest0_.id=?
  260. Hibernate: select accessgrou0_.ppa_employee_id as ppa_empl1_212_0_, accessgrou0_.ppa_access_group_id as ppa_acce2_212_0_, accessgrou1_.id as id1_207_1_, accessgrou1_.last_editing_date as last_edi2_207_1_, accessgrou1_.actual as actual3_207_1_, accessgrou1_.code as code4_207_1_, accessgrou1_.description as descript5_207_1_, accessgrou1_.group_name as group_na6_207_1_, accessgrou1_.non_removable as non_remo7_207_1_, accessgrou1_.group_privileges as group_pr8_207_1_, accessgrou1_.user_roles as user_rol9_207_1_ from ppasm.ppa_employee_access_group accessgrou0_ inner join ppasm.ppa_access_group accessgrou1_ on accessgrou0_.ppa_access_group_id=accessgrou1_.id and ( accessgrou1_.actual='true') where accessgrou0_.ppa_employee_id=?
  261. Hibernate: select phones0_.employee_id as employee4_214_0_, phones0_.id as id1_214_0_, phones0_.id as id1_214_1_, phones0_.last_editing_date as last_edi2_214_1_, phones0_.employee_id as employee4_214_1_, phones0_.phone as phone3_214_1_ from ppasm.ppa_employee_contact_phone phones0_ where phones0_.employee_id=?
  262. Hibernate: select nsisubdivi0_.id as id1_160_, nsisubdivi0_.actual as actual2_160_, nsisubdivi0_.create_date as create_d3_160_, nsisubdivi0_.deleted as deleted4_160_, nsisubdivi0_.inner_code as inner_co5_160_, nsisubdivi0_.last_editing_date as last_edi6_160_, nsisubdivi0_.root_id as root_id7_160_, nsisubdivi0_.sort_order as sort_ord8_160_, nsisubdivi0_.value as value9_160_, nsisubdivi0_.version_number as version10_160_, nsisubdivi0_.time_zone_root_id as time_zo11_160_ from nsism.nsi_subdivision nsisubdivi0_ where nsisubdivi0_.actual=true and nsisubdivi0_.root_id=9
  263. Hibernate: select nsitimezon0_.id as id1_167_, nsitimezon0_.actual as actual2_167_, nsitimezon0_.create_date as create_d3_167_, nsitimezon0_.deleted as deleted4_167_, nsitimezon0_.inner_code as inner_co5_167_, nsitimezon0_.last_editing_date as last_edi6_167_, nsitimezon0_.root_id as root_id7_167_, nsitimezon0_.sort_order as sort_ord8_167_, nsitimezon0_.value as value9_167_, nsitimezon0_.version_number as version10_167_, nsitimezon0_.code as code11_167_, nsitimezon0_.olson_name as olson_n12_167_, nsitimezon0_.rus_name as rus_nam13_167_ from nsism.nsi_time_zone nsitimezon0_ where nsitimezon0_.actual=true and nsitimezon0_.root_id=4
  264. Hibernate: select organizati0_.id as id1_224_, organizati0_.last_editing_date as last_edi2_224_, organizati0_.actual as actual3_224_, organizati0_.version_create_date as version_4_224_, organizati0_.version_number as version_5_224_, organizati0_.address as address6_224_, organizati0_.agency_territory as agency_t7_224_, organizati0_.agency_type as agency_t8_224_, organizati0_.is_branch as is_branc9_224_, organizati0_.branches_count as branche10_224_, organizati0_.data_source as data_so11_224_, organizati0_.email as email12_224_, organizati0_.email_confirmed as email_c13_224_, organizati0_.esia_id as esia_id14_224_, organizati0_.factual_address as factual15_224_, organizati0_.fax as fax16_224_, organizati0_.full_name as full_na17_224_, organizati0_.head_ppa_org_id as head_pp38_224_, organizati0_.ifrs_reporting as ifrs_re18_224_, organizati0_.information_source_root_id as informa19_224_, organizati0_.inn as inn20_224_, organizati0_.kpp as kpp21_224_, organizati0_.na_branch_code as na_bran22_224_, organizati0_.na_client_id as na_clie23_224_, organizati0_.na_id as na_id24_224_, organizati0_.na_status as na_stat25_224_, organizati0_.na_update_date as na_upda26_224_, organizati0_.not_blacklisted as not_bla27_224_, organizati0_.ogrn as ogrn28_224_, organizati0_.okopf_code as okopf_c29_224_, organizati0_.ppa_organization_id as ppa_org30_224_, organizati0_.organization_type as organiz31_224_, organizati0_.phone as phone32_224_, organizati0_.short_name as short_n33_224_, organizati0_.state_registration_date as state_r34_224_, organizati0_.status_id as status_39_224_, organizati0_.statutory_full_name as statuto35_224_, organizati0_.statutory_name_differs as statuto36_224_, organizati0_.statutory_short_name as statuto37_224_ from ppasm.ppa_organization_version organizati0_ where organizati0_.ppa_organization_id=? and organizati0_.actual=?
  265. Hibernate: select organizati0_.id as id1_223_0_, organizati0_.last_editing_date as last_edi2_223_0_, organizati0_.block as block3_223_0_, organizati0_.block_date as block_da4_223_0_, organizati0_.block_reason_id as block_re5_223_0_, organizati0_.on_registration as on_regis6_223_0_, organizati0_.registered as register7_223_0_, organizati0_.registration_date as registra8_223_0_ from ppasm.ppa_organization_status organizati0_ where organizati0_.id=?
  266. Hibernate: select orgroles0_.ppa_org_version_id as ppa_org_4_221_0_, orgroles0_.id as id1_221_0_, orgroles0_.id as id1_221_1_, orgroles0_.last_editing_date as last_edi2_221_1_, orgroles0_.org_role_root_id as org_role3_221_1_, orgroles0_.ppa_org_version_id as ppa_org_4_221_1_ from ppasm.ppa_organization_role orgroles0_ where orgroles0_.ppa_org_version_id=?
  267. Hibernate: select taskentity0_.id as id1_250_0_, taskentity0_.last_editing_date as last_edi2_250_0_, taskentity0_.added_manually as added_ma3_250_0_, taskentity0_.additional_info as addition4_250_0_, taskentity0_.assign_date as assign_d5_250_0_, taskentity0_.automatic_distribution as automati6_250_0_, taskentity0_.complete_date as complete7_250_0_, taskentity0_.create_date as create_d8_250_0_, taskentity0_.created_entity_version_id as created_9_250_0_, taskentity0_.entity_root_id as entity_10_250_0_, taskentity0_.entity_status_root_id as entity_11_250_0_, taskentity0_.entity_version_id as entity_12_250_0_, taskentity0_.locked as locked13_250_0_, taskentity0_.performer_employee_id as perform14_250_0_, taskentity0_.previous_entity_version_id as previou15_250_0_, taskentity0_.priority as priorit16_250_0_, taskentity0_.rule_id as rule_id20_250_0_, taskentity0_.task_number as task_nu17_250_0_, taskentity0_.task_status_root_id as task_st18_250_0_, taskentity0_.task_type_root_id as task_ty19_250_0_ from tasksm.task taskentity0_ where taskentity0_.id=?    DEBUG   backend develop
  268.     May 25, 2021 @ 13:47:49.010 Отправлен ответ CamundaBase{entityRootId=35410, entityVersionId=35410} в Camunda в очередь camundaRbs::camundaChangeTaskStatusResponse, corellationId = e1a05734-bd35-11eb-b379-b64357ae58f9
  269. Hibernate: select count(notificati0_.id) as col_0_0_ from notifsm.notification notificati0_ where notificati0_.receiver_root_id=? and (notificati0_.inner_event_name is not null) and notificati0_.status=?
  270. Hibernate: select notificati0_.id as id1_76_, notificati0_.bank_only as bank_onl2_76_, notificati0_.create_date as create_d3_76_, notificati0_.email_event_name as email_ev4_76_, notificati0_.email_subject as email_su5_76_, notificati0_.email_text as email_te6_76_, notificati0_.entity_root_id as entity_r7_76_, notificati0_.entity_type_root_id as entity_t8_76_, notificati0_.entity_version_id as entity_v9_76_, notificati0_.event_code as event_c10_76_, notificati0_.important as importa11_76_, notificati0_.inner_event_name as inner_e12_76_, notificati0_.inner_text as inner_t13_76_, notificati0_.last_editing_date as last_ed14_76_, notificati0_.popup_sended as popup_s15_76_, notificati0_.receiver_root_id as receive16_76_, notificati0_.status as status17_76_, notificati0_.status_editing_date as status_18_76_, notificati0_.task as task19_76_ from notifsm.notification notificati0_ where notificati0_.receiver_root_id=? and (notificati0_.inner_event_name is not null) and notificati0_.status=? and (notificati0_.popup_sended=? or notificati0_.popup_sended is null) and (notificati0_.create_date between ? and ?) order by notificati0_.create_date desc
  271. Hibernate: select count(notificati0_.id) as col_0_0_ from notifsm.notification notificati0_ where notificati0_.receiver_root_id=? and (notificati0_.inner_event_name is not null) and notificati0_.status=?
  272. Hibernate: select notificati0_.id as id1_76_, notificati0_.bank_only as bank_onl2_76_, notificati0_.create_date as create_d3_76_, notificati0_.email_event_name as email_ev4_76_, notificati0_.email_subject as email_su5_76_, notificati0_.email_text as email_te6_76_, notificati0_.entity_root_id as entity_r7_76_, notificati0_.entity_type_root_id as entity_t8_76_, notificati0_.entity_version_id as entity_v9_76_, notificati0_.event_code as event_c10_76_, notificati0_.important as importa11_76_, notificati0_.inner_event_name as inner_e12_76_, notificati0_.inner_text as inner_t13_76_, notificati0_.last_editing_date as last_ed14_76_, notificati0_.popup_sended as popup_s15_76_, notificati0_.receiver_root_id as receive16_76_, notificati0_.status as status17_76_, notificati0_.status_editing_date as status_18_76_, notificati0_.task as task19_76_ from notifsm.notification notificati0_ where notificati0_.receiver_root_id=? and (notificati0_.inner_event_name is not null) and notificati0_.status=? and (notificati0_.popup_sended=? or notificati0_.popup_sended is null) and (notificati0_.create_date between ? and ?) order by notificati0_.create_date desc
  273. Hibernate: select count(notificati0_.id) as col_0_0_ from notifsm.notification notificati0_ where notificati0_.receiver_root_id=? and (notificati0_.inner_event_name is not null) and notificati0_.status=?
  274. Hibernate: select notificati0_.id as id1_76_, notificati0_.bank_only as bank_onl2_76_, notificati0_.create_date as create_d3_76_, notificati0_.email_event_name as email_ev4_76_, notificati0_.email_subject as email_su5_76_, notificati0_.email_text as email_te6_76_, notificati0_.entity_root_id as entity_r7_76_, notificati0_.entity_type_root_id as entity_t8_76_, notificati0_.entity_version_id as entity_v9_76_, notificati0_.event_code as event_c10_76_, notificati0_.important as importa11_76_, notificati0_.inner_event_name as inner_e12_76_, notificati0_.inner_text as inner_t13_76_, notificati0_.last_editing_date as last_ed14_76_, notificati0_.popup_sended as popup_s15_76_, notificati0_.receiver_root_id as receive16_76_, notificati0_.status as status17_76_, notificati0_.status_editing_date as status_18_76_, notificati0_.task as task19_76_ from notifsm.notification notificati0_ where notificati0_.receiver_root_id=? and (notificati0_.inner_event_name is not null) and notificati0_.status=? and (notificati0_.popup_sended=? or notificati0_.popup_sended is null) and (notificati0_.create_date between ? and ?) order by notificati0_.create_date desc    DEBUG   backend develop
  275.     May 25, 2021 @ 13:47:55.152 Получен запрос от Camunda: {"entityRootId":35410,"entityVersionId":35411,"taskId":10462,"assigneeRootId":null,"taskTargetStatus":null,"pauseReason":null,"manualTask":null,"pauseReasonRootId":null}, corellationId = e54172f5-bd35-11eb-bd14-0e9d94984603
  276. Hibernate: select taskentity0_.id as id1_250_0_, taskentity0_.last_editing_date as last_edi2_250_0_, taskentity0_.added_manually as added_ma3_250_0_, taskentity0_.additional_info as addition4_250_0_, taskentity0_.assign_date as assign_d5_250_0_, taskentity0_.automatic_distribution as automati6_250_0_, taskentity0_.complete_date as complete7_250_0_, taskentity0_.create_date as create_d8_250_0_, taskentity0_.created_entity_version_id as created_9_250_0_, taskentity0_.entity_root_id as entity_10_250_0_, taskentity0_.entity_status_root_id as entity_11_250_0_, taskentity0_.entity_version_id as entity_12_250_0_, taskentity0_.locked as locked13_250_0_, taskentity0_.performer_employee_id as perform14_250_0_, taskentity0_.previous_entity_version_id as previou15_250_0_, taskentity0_.priority as priorit16_250_0_, taskentity0_.rule_id as rule_id20_250_0_, taskentity0_.task_number as task_nu17_250_0_, taskentity0_.task_status_root_id as task_st18_250_0_, taskentity0_.task_type_root_id as task_ty19_250_0_ from tasksm.task taskentity0_ where taskentity0_.id=?    DEBUG   backend develop
  277.     May 25, 2021 @ 13:47:55.223 Отправлен ответ CamundaBase{entityRootId=35410, entityVersionId=35411} в Camunda в очередь camundaRbs::camundaChangeTaskStatusResponse, corellationId = e54172f5-bd35-11eb-bd14-0e9d94984603
  278. Hibernate: select employeewo0_.id as id1_218_, employeewo0_.ppa_employee_id as ppa_empl2_218_, employeewo0_.last_editing_date as last_edi3_218_, employeewo0_.work_status_root_id as work_sta4_218_ from ppasm.ppa_employee_work_status employeewo0_ where employeewo0_.ppa_employee_id=?
  279. Hibernate: select nsiemploye0_.id as id1_111_, nsiemploye0_.actual as actual2_111_, nsiemploye0_.create_date as create_d3_111_, nsiemploye0_.deleted as deleted4_111_, nsiemploye0_.inner_code as inner_co5_111_, nsiemploye0_.last_editing_date as last_edi6_111_, nsiemploye0_.root_id as root_id7_111_, nsiemploye0_.sort_order as sort_ord8_111_, nsiemploye0_.value as value9_111_, nsiemploye0_.version_number as version10_111_ from nsism.nsi_employee_status nsiemploye0_ where 1=1 order by nsiemploye0_.sort_order asc
  280. Hibernate: select employeeve0_.id as id1_217_, employeeve0_.last_editing_date as last_edi2_217_, employeeve0_.actual as actual3_217_, employeeve0_.version_create_date as version_4_217_, employeeve0_.version_number as version_5_217_, employeeve0_.address as address6_217_, employeeve0_.birth_date as birth_da7_217_, employeeve0_.branch_kpp as branch_k8_217_, employeeve0_.citizenship as citizens9_217_, employeeve0_.data_source as data_so10_217_, employeeve0_.delete_date as delete_11_217_, employeeve0_.doc_act_number as doc_act12_217_, employeeve0_.doc_expiry_date as doc_exp13_217_, employeeve0_.doc_first_name as doc_fir14_217_, employeeve0_.doc_issue_date as doc_iss15_217_, employeeve0_.doc_issue_id as doc_iss16_217_, employeeve0_.doc_issue_by as doc_iss17_217_, employeeve0_.doc_last_name as doc_las18_217_, employeeve0_.doc_number as doc_num19_217_, employeeve0_.doc_series as doc_ser20_217_, employeeve0_.doc_type as doc_typ21_217_, employeeve0_.doc_edit_available as doc_edi22_217_, employeeve0_.email as email23_217_, employeeve0_.email_confirmed as email_c24_217_, employeeve0_.ppa_employee_id as ppa_emp45_217_, employeeve0_.esia_id as esia_id25_217_, employeeve0_.first_name as first_n26_217_, employeeve0_.gender as gender27_217_, employeeve0_.inn as inn28_217_, employeeve0_.last_name as last_na29_217_, employeeve0_.middle_name as middle_30_217_, employeeve0_.is_org_chief as is_org_31_217_, employeeve0_.phone as phone32_217_, employeeve0_.phone_confirmation_date as phone_c33_217_, employeeve0_.phone_confirmation_message as phone_c34_217_, employeeve0_.phone_confirmation_status as phone_c35_217_, employeeve0_.phone_confirmed as phone_c36_217_, employeeve0_.phone_number_on_confirmation as phone_n37_217_, employeeve0_.popup_allowed as popup_a38_217_, employeeve0_.position_emp as positio39_217_, employeeve0_.registration_address as registr40_217_, employeeve0_.role_emp as role_em41_217_, employeeve0_.snils as snils42_217_, employeeve0_.status_id as status_46_217_, employeeve0_.subdivision_root_id as subdivi43_217_, employeeve0_.time_zone_root_id as time_zo44_217_ from ppasm.ppa_employee_version employeeve0_ where employeeve0_.ppa_employee_id=? and employeeve0_.actual=?
  281. Hibernate: select employeeen0_.id as id1_211_0_, employeeen0_.last_editing_date as last_edi2_211_0_, employeeen0_.keycloak_user_id as keycloak3_211_0_, employeeen0_.ppa_organization_id as ppa_orga5_211_0_, employeeen0_.user_privileges as user_pri4_211_0_, organizati1_.id as id1_220_1_, organizati1_.last_editing_date as last_edi2_220_1_, organizati1_.login_1c as login_3_220_1_, organizati1_.ogrn as ogrn4_220_1_, organizati1_.password_1c as password5_220_1_, organizati1_.session_expiration_1c as session_6_220_1_, organizati1_.session_id_1c as session_7_220_1_ from ppasm.ppa_employee employeeen0_ inner join ppasm.ppa_organization organizati1_ on employeeen0_.ppa_organization_id=organizati1_.id where employeeen0_.id=?
  282. Hibernate: select employeest0_.id as id1_216_0_, employeest0_.last_editing_date as last_edi2_216_0_, employeest0_.block as block3_216_0_, employeest0_.block_date as block_da4_216_0_, employeest0_.block_info as block_in5_216_0_, employeest0_.block_reason_id as block_re6_216_0_, employeest0_.registered as register7_216_0_, employeest0_.registration_date as registra8_216_0_, employeest0_.unlock_date as unlock_d9_216_0_ from ppasm.ppa_employee_status employeest0_ where employeest0_.id=?
  283. Hibernate: select count(organizati0_.id) as col_0_0_ from ppasm.ppa_organization_version organizati0_ cross join ppasm.ppa_organization_status organizati1_ where organizati0_.status_id=organizati1_.id and organizati0_.actual=? and organizati1_.block=? and organizati1_.registered=? and (exists (select 1 from ppasm.ppa_employee_version employeeve3_ cross join ppasm.ppa_employee employeeen4_ cross join ppasm.ppa_employee_status employeest5_ where employeeve3_.ppa_employee_id=employeeen4_.id and employeeve3_.status_id=employeest5_.id and employeeen4_.ppa_organization_id=organizati0_.ppa_organization_id and employeeve3_.actual=? and employeest5_.block=? and employeest5_.registered=? and employeeve3_.snils=? and employeeve3_.phone=?))
  284. Hibernate: select count(notificati0_.id) as col_0_0_ from notifsm.notification notificati0_ where notificati0_.receiver_root_id=? and (notificati0_.inner_event_name is not null) and notificati0_.status=?
  285. Hibernate: select notificati0_.id as id1_76_, notificati0_.bank_only as bank_onl2_76_, notificati0_.create_date as create_d3_76_, notificati0_.email_event_name as email_ev4_76_, notificati0_.email_subject as email_su5_76_, notificati0_.email_text as email_te6_76_, notificati0_.entity_root_id as entity_r7_76_, notificati0_.entity_type_root_id as entity_t8_76_, notificati0_.entity_version_id as entity_v9_76_, notificati0_.event_code as event_c10_76_, notificati0_.important as importa11_76_, notificati0_.inner_event_name as inner_e12_76_, notificati0_.inner_text as inner_t13_76_, notificati0_.last_editing_date as last_ed14_76_, notificati0_.popup_sended as popup_s15_76_, notificati0_.receiver_root_id as receive16_76_, notificati0_.status as status17_76_, notificati0_.status_editing_date as status_18_76_, notificati0_.task as task19_76_ from notifsm.notification notificati0_ where notificati0_.receiver_root_id=? and (notificati0_.inner_event_name is not null) and notificati0_.status=? and (notificati0_.popup_sended=? or notificati0_.popup_sended is null) and (notificati0_.create_date between ? and ?) order by notificati0_.create_date desc    DEBUG   backend develop
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!