March 26th 2021, 10:59:00.558   develop-dev-roscap  Received CreateTaskResponse message: {"entityRootId":4669,"entityVersionId":1974,"taskId":3137} bpm-app DEBUG
    March 26th 2021, 10:59:03.231   develop-dev-roscap  Found taskId = 3137 backend DEBUG
    March 26th 2021, 10:59:25.759   develop-dev-roscap  Found taskId = 3137 backend DEBUG
    March 26th 2021, 10:59:28.200   develop-dev-roscap  Found taskId = 3137
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=?   backend DEBUG
    March 26th 2021, 10:59:28.692   develop-dev-roscap  Found taskId = 3137 backend DEBUG
    March 26th 2021, 10:59:32.197   develop-dev-roscap  Received InitChangeTaskStatusRequest message: {"entityRootId":4669,"entityVersionId":1974,"taskId":3137,"taskTargetStatus":"ST_OK_ASSIGNEE","assigneeRootId":61,"pauseReason":null,"pauseReasonRootId":null}    bpm-app DEBUG
    March 26th 2021, 10:59:32.438   develop-dev-roscap  Prepare for task status update: id=3137, actual status=ST_OK_ASSIGNEE, target status=ST_OK_ASSIGNEE bpm-app DEBUG
    March 26th 2021, 10:59:32.438   develop-dev-roscap  Sending into camundaRbs::camundaChangeTaskStatusRequest message: {"taskId":3137,"assigneeRootId":61,"taskTargetStatus":"ST_OK_ASSIGNEE","pauseReason":null,"manualTask":false,"pauseReasonRootId":null,"entityRootId":4669,"entityVersionId":1974}  bpm-app DEBUG
    March 26th 2021, 10:59:32.472   develop-dev-roscap  Found taskId = 3137 backend DEBUG
    March 26th 2021, 10:59:32.646   develop-dev-roscap  Получен запрос от Camunda: {"entityRootId":4669,"entityVersionId":1974,"taskId":3137,"assigneeRootId":61,"taskTargetStatus":"ST_OK_ASSIGNEE","pauseReason":null,"manualTask":false,"pauseReasonRootId":null}, corellationId = 6f4daf5a-8df8-11eb-936e-5e684e6d1759
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_, taskdistri1_.id as id1_260_1_, taskdistri1_.last_editing_date as last_edi2_260_1_, taskdistri1_.root_id as root_id3_260_1_, taskdistri1_.actual as actual4_260_1_, taskdistri1_.applicable_to as applicab5_260_1_, taskdistri1_.automatic_distribution as automati6_260_1_, taskdistri1_.create_date as create_d7_260_1_, taskdistri1_.deleted as deleted8_260_1_, taskdistri1_.rule_name as rule_nam9_260_1_, taskdistri1_.priority as priorit10_260_1_, taskdistri1_.start_date as start_d11_260_1_, taskdistri1_.stop_date as stop_da12_260_1_, taskdistri1_.rule_type as rule_ty13_260_1_, taskdistri1_.version_number as version14_260_1_ from tasksm.task taskentity0_ left outer join tasksm.task_distribution_rule taskdistri1_ on taskentity0_.rule_id=taskdistri1_.id where taskentity0_.id=?
Hibernate: select taskworken0_.id as id1_268_, taskworken0_.last_editing_date as last_edi2_268_, taskworken0_.assign_date as assign_d3_268_, taskworken0_.end_date as end_date4_268_, taskworken0_.pause_reason as pause_re5_268_, taskworken0_.pause_reason_root_id as pause_re6_268_, taskworken0_.performer_employee_id as performe7_268_, taskworken0_.revoked as revoked8_268_, taskworken0_.start_date as start_da9_268_, taskworken0_.task_id as task_id10_268_ from tasksm.task_work taskworken0_ where taskworken0_.task_id=? and (taskworken0_.performer_employee_id is null)
Hibernate: select nsitasksta0_.id as id1_163_, nsitasksta0_.actual as actual2_163_, nsitasksta0_.create_date as create_d3_163_, nsitasksta0_.deleted as deleted4_163_, nsitasksta0_.inner_code as inner_co5_163_, nsitasksta0_.last_editing_date as last_edi6_163_, nsitasksta0_.root_id as root_id7_163_, nsitasksta0_.sort_order as sort_ord8_163_, nsitasksta0_.value as value9_163_, nsitasksta0_.version_number as version10_163_ from nsism.nsi_task_status nsitasksta0_ where nsitasksta0_.actual=true and nsitasksta0_.root_id=2
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_emp46_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_.keycloak_user_id as keycloa29_217_, employeeve0_.last_name as last_na30_217_, employeeve0_.middle_name as middle_31_217_, employeeve0_.is_org_chief as is_org_32_217_, employeeve0_.phone as phone33_217_, employeeve0_.phone_confirmation_date as phone_c34_217_, employeeve0_.phone_confirmation_message as phone_c35_217_, employeeve0_.phone_confirmation_status as phone_c36_217_, employeeve0_.phone_confirmed as phone_c37_217_, employeeve0_.phone_number_on_confirmation as phone_n38_217_, employeeve0_.popup_allowed as popup_a39_217_, employeeve0_.position_emp as positio40_217_, employeeve0_.registration_address as registr41_217_, employeeve0_.role_emp as role_em42_217_, employeeve0_.snils as snils43_217_, employeeve0_.status_id as status_47_217_, employeeve0_.subdivision_root_id as subdivi44_217_, employeeve0_.time_zone_root_id as time_zo45_217_ from ppasm.ppa_employee_version employeeve0_ where employeeve0_.ppa_employee_id=? and employeeve0_.actual=?
Hibernate: select employeeen0_.id as id1_211_0_, employeeen0_.last_editing_date as last_edi2_211_0_, employeeen0_.ppa_organization_id as ppa_orga4_211_0_, employeeen0_.user_privileges as user_pri3_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=?
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=?
Hibernate: select paymentord0_.id as id1_202_0_, paymentord0_.last_editing_date as last_edi2_202_0_, paymentord0_.actual as actual3_202_0_, paymentord0_.actual_by_business as actual_b4_202_0_, paymentord0_.bagr_agreement_bs_id as bagr_agr5_202_0_, paymentord0_.bagr_agreement_bs_object_id as bagr_agr6_202_0_, paymentord0_.bagr_agreement_bs_object_root_id as bagr_agr7_202_0_, paymentord0_.bagr_agreement_sba_object_id as bagr_agr8_202_0_, paymentord0_.amount as amount9_202_0_, paymentord0_.amount_with_vat as amount_10_202_0_, paymentord0_.analytics_filled as analyti11_202_0_, paymentord0_.budget_version_id as budget_12_202_0_, paymentord0_.budgetary_payment as budgeta13_202_0_, paymentord0_.budgetary_payment_document_number as budgeta14_202_0_, paymentord0_.cagr_agreement_id as cagr_ag15_202_0_, paymentord0_.cagr_agreement_root_id as cagr_ag16_202_0_, paymentord0_.code as code17_202_0_, paymentord0_.create_date as create_18_202_0_, paymentord0_.create_date_month as create_19_202_0_, paymentord0_.create_date_year as create_20_202_0_, paymentord0_.creator_organization_id as creator21_202_0_, paymentord0_.creator_organization_root_id as creator22_202_0_, paymentord0_.currency_id as currenc23_202_0_, paymentord0_.currency_root_id as currenc24_202_0_, paymentord0_.currency_transaction_type_code_id as currenc25_202_0_, paymentord0_.currency_transaction_type_code_root_id as currenc26_202_0_, paymentord0_.customs_code as customs27_202_0_, paymentord0_.editor_employee_root_id as editor_28_202_0_, paymentord0_.editor_organization_id as editor_29_202_0_, paymentord0_.editor_organization_root_id as editor_30_202_0_, paymentord0_.electronic_document_id_1c as electro31_202_0_, paymentord0_.employee_root_id_sent_to_signing as employe32_202_0_, paymentord0_.employee_root_id_signed as employe33_202_0_, paymentord0_.extended_day as extende34_202_0_, paymentord0_.group_operation_id as group_o35_202_0_, paymentord0_.import_file_id as import_36_202_0_, paymentord0_.import_id as import_37_202_0_, paymentord0_.income_type_code_id as income_38_202_0_, paymentord0_.income_type_code_root_id as income_39_202_0_, paymentord0_.individual_information_id as individ40_202_0_, paymentord0_.information_source_id as informa41_202_0_, paymentord0_.information_source_root_id as informa42_202_0_, paymentord0_.kbk as kbk43_202_0_, paymentord0_.law_214_operation as law_44_202_0_, paymentord0_.law_214_operation_type_root_id as law_45_202_0_, paymentord0_.limit_absence as limit_a46_202_0_, paymentord0_.locked as locked47_202_0_, paymentord0_.new_athena_payment_order_id as new_ath48_202_0_, paymentord0_.not_show_payment_cause_document_date as not_sho49_202_0_, paymentord0_.oktmo as oktmo50_202_0_, paymentord0_.operation_type_id as operati51_202_0_, paymentord0_.operation_type_root_id as operati52_202_0_, paymentord0_.parent_na_id as parent_53_202_0_, paymentord0_.parent_payment_order_version_id as parent_54_202_0_, paymentord0_.payer_status_id as payer_s55_202_0_, paymentord0_.payer_status_root_id as payer_s56_202_0_, paymentord0_.payment_by_cagr_agreement as payment57_202_0_, paymentord0_.payment_cause_document_date as payment58_202_0_, paymentord0_.payment_cause_id as payment59_202_0_, paymentord0_.payment_cause_root_id as payment60_202_0_, paymentord0_.payment_form_id as payment61_202_0_, paymentord0_.payment_form_root_id as payment62_202_0_, paymentord0_.payment_order_id as payment98_202_0_, paymentord0_.payment_order_create_date as payment63_202_0_, paymentord0_.payment_order_number as payment64_202_0_, paymentord0_.payment_priority_id as payment65_202_0_, paymentord0_.payment_priority_root_id as payment66_202_0_, paymentord0_.payment_purpose as payment67_202_0_, paymentord0_.payment_purpose_code as payment68_202_0_, paymentord0_.payment_term as payment69_202_0_, paymentord0_.payment_type_id as payment70_202_0_, paymentord0_.payment_type_root_id as payment71_202_0_, paymentord0_.payment_with_funds_received_by_agreement as payment72_202_0_, paymentord0_.period_id as period_73_202_0_, paymentord0_.period_root_id as period_74_202_0_, paymentord0_.refund_payment_order_version_id as refund_75_202_0_, paymentord0_.requisites_clarification as requisi76_202_0_, paymentord0_.requisites_clarification_number as requisi77_202_0_, paymentord0_.reserve_field as reserve78_202_0_, paymentord0_.revoked_by_client as revoked79_202_0_, paymentord0_.sent_clarification_notification as sent_cl80_202_0_, paymentord0_.sent_to_clarification as sent_to81_202_0_, paymentord0_.sent_to_eiszhs as sent_to82_202_0_, paymentord0_.sent_to_eiszhs_id as sent_to83_202_0_, paymentord0_.status_root_id as status_84_202_0_, paymentord0_.system_number as system_85_202_0_, paymentord0_.tax_period_date as tax_per86_202_0_, paymentord0_.tax_period_id as tax_per87_202_0_, paymentord0_.tax_period_indicator_id as tax_per88_202_0_, paymentord0_.tax_period_indicator_root_id as tax_per89_202_0_, paymentord0_.tax_period_root_id as tax_per90_202_0_, paymentord0_.tax_period_year as tax_per91_202_0_, paymentord0_.vat_amount as vat_amo92_202_0_, paymentord0_.vat_rate_id as vat_rat93_202_0_, paymentord0_.vat_rate_root_id as vat_rat94_202_0_, paymentord0_.vat_type_id as vat_typ95_202_0_, paymentord0_.vat_type_root_id as vat_typ96_202_0_, paymentord0_.version_number as version97_202_0_, paymentord1_.id as id1_182_1_, paymentord1_.last_editing_date as last_edi2_182_1_, paymentord2_.id as id1_186_2_, paymentord2_.last_editing_date as last_edi2_186_2_, paymentord2_.payment_order_version_id as payment_4_186_2_, paymentord2_.partial_payment as partial_3_186_2_, paymentord3_.id as id1_194_3_, paymentord3_.last_editing_date as last_edi2_194_3_, paymentord3_.payment_order_version_id as payment10_194_3_, paymentord3_.bank_details_id as bank_det3_194_3_, paymentord3_.bank_details_version_id as bank_det4_194_3_, paymentord3_.first_name as first_na5_194_3_, paymentord3_.individual_recipient as individu6_194_3_, paymentord3_.last_name as last_nam7_194_3_, paymentord3_.middle_name as middle_n8_194_3_, paymentord3_.party_type_root_id as party_ty9_194_3_, paymentord4_.id as id1_201_4_, paymentord4_.last_editing_date as last_edi2_201_4_, paymentord4_.payment_order_version_id as payment_9_201_4_, paymentord4_.acceptance_id as acceptan3_201_4_, paymentord4_.payer_account_debiting_date as payer_ac4_201_4_, paymentord4_.payer_bank_income_date as payer_ba5_201_4_, paymentord4_.payment_order_discard_date as payment_6_201_4_, paymentord4_.payment_sending_date as payment_7_201_4_, paymentord4_.send_to_clarification_by_bank as send_to_8_201_4_ from posm.po_payment_order_version paymentord0_ inner join posm.po_payment_order paymentord1_ on paymentord0_.payment_order_id=paymentord1_.id left outer join posm.po_payment_order_additional_info paymentord2_ on paymentord0_.id=paymentord2_.payment_order_version_id left outer join posm.po_payment_order_individual_party paymentord3_ on paymentord0_.id=paymentord3_.payment_order_version_id left outer join posm.po_payment_order_system_data paymentord4_ on paymentord0_.id=paymentord4_.payment_order_version_id where paymentord0_.id=?
Hibernate: select legalentit0_.payment_order_version_id as payment_9_195_0_, legalentit0_.id as id1_195_0_, legalentit0_.id as id1_195_1_, legalentit0_.last_editing_date as last_edi2_195_1_, legalentit0_.payment_order_version_id as payment_9_195_1_, legalentit0_.bank_details_id as bank_det3_195_1_, legalentit0_.bank_details_version_id as bank_det4_195_1_, legalentit0_.party_id as party_id5_195_1_, legalentit0_.party_root_id as party_ro6_195_1_, legalentit0_.party_type_root_id as party_ty7_195_1_, legalentit0_.recipient_name as recipien8_195_1_ from posm.po_payment_order_legal_entity_party legalentit0_ where legalentit0_.payment_order_version_id=?
Hibernate: select bankdetail0_.id as id1_36_0_, bankdetail0_.last_editing_date as last_edi2_36_0_, bankdetail0_.root_id as root_id3_36_0_, bankdetail0_.account as account4_36_0_, bankdetail0_.account_status_root_id as account_5_36_0_, bankdetail0_.account_type_root_id as account_6_36_0_, bankdetail0_.actual as actual7_36_0_, bankdetail0_.author_employee_root_id as author_e8_36_0_, bankdetail0_.author_org_root_id as author_o9_36_0_, bankdetail0_.base_agreement_date as base_ag10_36_0_, bankdetail0_.base_agreement_number as base_ag11_36_0_, bankdetail0_.bic as bic12_36_0_, bankdetail0_.close_date as close_d13_36_0_, bankdetail0_.correspondent_account as corresp14_36_0_, bankdetail0_.create_date as create_15_36_0_, bankdetail0_.credit_organization_name as credit_16_36_0_, bankdetail0_.currency_root_id as currenc17_36_0_, bankdetail0_.details_name as details18_36_0_, bankdetail0_.first_name as first_n19_36_0_, bankdetail0_.from_athena as from_at20_36_0_, bankdetail0_.inn as inn21_36_0_, bankdetail0_.last_name as last_na22_36_0_, bankdetail0_.middle_name as middle_23_36_0_, bankdetail0_.na_id as na_id24_36_0_, bankdetail0_.na_update_date as na_upda25_36_0_, bankdetail0_.open_date as open_da26_36_0_, bankdetail0_.ppa_organization_id as ppa_org27_36_0_, bankdetail0_.person_recipient as person_28_36_0_, bankdetail0_.recipient_name as recipie29_36_0_, bankdetail0_.subdivision_code as subdivi30_36_0_, bankdetail0_.version_number as version31_36_0_ from bdtsm.bdt_bank_details bankdetail0_ where bankdetail0_.id=?
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=?
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
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=?
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=?
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=?
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=?
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=?
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=?
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=?
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=?
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=?
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 (?)
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_.id=?
Hibernate: select bankdetail0_.id as id1_36_0_, bankdetail0_.last_editing_date as last_edi2_36_0_, bankdetail0_.root_id as root_id3_36_0_, bankdetail0_.account as account4_36_0_, bankdetail0_.account_status_root_id as account_5_36_0_, bankdetail0_.account_type_root_id as account_6_36_0_, bankdetail0_.actual as actual7_36_0_, bankdetail0_.author_employee_root_id as author_e8_36_0_, bankdetail0_.author_org_root_id as author_o9_36_0_, bankdetail0_.base_agreement_date as base_ag10_36_0_, bankdetail0_.base_agreement_number as base_ag11_36_0_, bankdetail0_.bic as bic12_36_0_, bankdetail0_.close_date as close_d13_36_0_, bankdetail0_.correspondent_account as corresp14_36_0_, bankdetail0_.create_date as create_15_36_0_, bankdetail0_.credit_organization_name as credit_16_36_0_, bankdetail0_.currency_root_id as currenc17_36_0_, bankdetail0_.details_name as details18_36_0_, bankdetail0_.first_name as first_n19_36_0_, bankdetail0_.from_athena as from_at20_36_0_, bankdetail0_.inn as inn21_36_0_, bankdetail0_.last_name as last_na22_36_0_, bankdetail0_.middle_name as middle_23_36_0_, bankdetail0_.na_id as na_id24_36_0_, bankdetail0_.na_update_date as na_upda25_36_0_, bankdetail0_.open_date as open_da26_36_0_, bankdetail0_.ppa_organization_id as ppa_org27_36_0_, bankdetail0_.person_recipient as person_28_36_0_, bankdetail0_.recipient_name as recipie29_36_0_, bankdetail0_.subdivision_code as subdivi30_36_0_, bankdetail0_.version_number as version31_36_0_ from bdtsm.bdt_bank_details bankdetail0_ where bankdetail0_.id=?
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=?
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=?
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=?
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=?
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=?
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=?
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=?
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=?
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 (?)
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_.id=?
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_emp46_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_.keycloak_user_id as keycloa29_217_, employeeve0_.last_name as last_na30_217_, employeeve0_.middle_name as middle_31_217_, employeeve0_.is_org_chief as is_org_32_217_, employeeve0_.phone as phone33_217_, employeeve0_.phone_confirmation_date as phone_c34_217_, employeeve0_.phone_confirmation_message as phone_c35_217_, employeeve0_.phone_confirmation_status as phone_c36_217_, employeeve0_.phone_confirmed as phone_c37_217_, employeeve0_.phone_number_on_confirmation as phone_n38_217_, employeeve0_.popup_allowed as popup_a39_217_, employeeve0_.position_emp as positio40_217_, employeeve0_.registration_address as registr41_217_, employeeve0_.role_emp as role_em42_217_, employeeve0_.snils as snils43_217_, employeeve0_.status_id as status_47_217_, employeeve0_.subdivision_root_id as subdivi44_217_, employeeve0_.time_zone_root_id as time_zo45_217_ from ppasm.ppa_employee_version employeeve0_ where employeeve0_.ppa_employee_id=? and employeeve0_.actual=?
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=?
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=?
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=5
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=2
Hibernate: select taskworken0_.id as id1_268_, taskworken0_.last_editing_date as last_edi2_268_, taskworken0_.assign_date as assign_d3_268_, taskworken0_.end_date as end_date4_268_, taskworken0_.pause_reason as pause_re5_268_, taskworken0_.pause_reason_root_id as pause_re6_268_, taskworken0_.performer_employee_id as performe7_268_, taskworken0_.revoked as revoked8_268_, taskworken0_.start_date as start_da9_268_, taskworken0_.task_id as task_id10_268_ from tasksm.task_work taskworken0_ where taskworken0_.task_id=?
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=?
Hibernate: update tasksm.task set last_editing_date=?, added_manually=?, additional_info=?, assign_date=?, automatic_distribution=?, complete_date=?, create_date=?, created_entity_version_id=?, entity_root_id=?, entity_status_root_id=?, entity_version_id=?, locked=?, performer_employee_id=?, previous_entity_version_id=?, priority=?, rule_id=?, task_number=?, task_status_root_id=?, task_type_root_id=? where id=? and last_editing_date=?
Hibernate: insert into tasksm.task_work (last_editing_date, assign_date, end_date, pause_reason, pause_reason_root_id, performer_employee_id, revoked, start_date, task_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?)  backend DEBUG
    March 26th 2021, 10:59:32.721   develop-dev-roscap  processEventNotificationQueue request: NotificationCreateRequest{entityType=TASK_BY_PAYMENT_ORDEReventCode=CO_OK_27entity.id=nullentity.rootId=3137}
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=?
Hibernate: select employeeve0_.id as id1_217_0_, employeeen7_.id as id1_211_1_, organizati8_.id as id1_220_2_, employeest9_.id as id1_216_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_emp46_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_.keycloak_user_id as keycloa29_217_0_, employeeve0_.last_name as last_na30_217_0_, employeeve0_.middle_name as middle_31_217_0_, employeeve0_.is_org_chief as is_org_32_217_0_, employeeve0_.phone as phone33_217_0_, employeeve0_.phone_confirmation_date as phone_c34_217_0_, employeeve0_.phone_confirmation_message as phone_c35_217_0_, employeeve0_.phone_confirmation_status as phone_c36_217_0_, employeeve0_.phone_confirmed as phone_c37_217_0_, employeeve0_.phone_number_on_confirmation as phone_n38_217_0_, employeeve0_.popup_allowed as popup_a39_217_0_, employeeve0_.position_emp as positio40_217_0_, employeeve0_.registration_address as registr41_217_0_, employeeve0_.role_emp as role_em42_217_0_, employeeve0_.snils as snils43_217_0_, employeeve0_.status_id as status_47_217_0_, employeeve0_.subdivision_root_id as subdivi44_217_0_, employeeve0_.time_zone_root_id as time_zo45_217_0_, employeeen7_.last_editing_date as last_edi2_211_1_, employeeen7_.ppa_organization_id as ppa_orga4_211_1_, employeeen7_.user_privileges as user_pri3_211_1_, organizati8_.last_editing_date as last_edi2_220_2_, organizati8_.login_1c as login_3_220_2_, organizati8_.ogrn as ogrn4_220_2_, organizati8_.password_1c as password5_220_2_, organizati8_.session_expiration_1c as session_6_220_2_, organizati8_.session_id_1c as session_7_220_2_, employeest9_.last_editing_date as last_edi2_216_3_, employeest9_.block as block3_216_3_, employeest9_.block_date as block_da4_216_3_, employeest9_.block_info as block_in5_216_3_, employeest9_.block_reason_id as block_re6_216_3_, employeest9_.registered as register7_216_3_, employeest9_.registration_date as registra8_216_3_, employeest9_.unlock_date as unlock_d9_216_3_ from ppasm.ppa_employee_version employeeve0_ left outer join ppasm.ppa_employee employeeen7_ on employeeve0_.ppa_employee_id=employeeen7_.id left outer join ppasm.ppa_organization organizati8_ on employeeen7_.ppa_organization_id=organizati8_.id left outer join ppasm.ppa_employee_status employeest9_ on employeeve0_.status_id=employeest9_.id cross join ppasm.ppa_employee_status employeest1_ where employeeve0_.status_id=employeest1_.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 (exists (select 1 from ppasm.ppa_organization_role orgroles6_ where organizati2_.id=orgroles6_.ppa_org_version_id and orgroles6_.org_role_root_id=?)))) and employeeve0_.ppa_employee_id=?
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=?
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=? backend DEBUG
    March 26th 2021, 10:59:32.733   develop-dev-roscap  Received ChangeTaskStatusResponse message: {"entityRootId":4669,"entityVersionId":1974,"taskId":3137}   bpm-app DEBUG
    March 26th 2021, 10:59:32.738   develop-dev-roscap  Created notification: id=1616413, receiver=NotificationReceiver{employeeRootId=61, firstName='Алексей', middleName='Александрович', lastName='Логинов', email='testVDTSDK@testmail.test', phone='89762786187'}, request=NotificationCreateRequest{entityType=TASK_BY_PAYMENT_ORDEReventCode=CO_OK_27entity.id=nullentity.rootId=3137}    backend DEBUG
    March 26th 2021, 10:59:33.447   develop-dev-roscap  Found taskId = 3137 backend DEBUG
    March 26th 2021, 10:59:45.792   develop-dev-roscap  Found taskId = 3137 backend DEBUG
    March 26th 2021, 10:59:47.699   develop-dev-roscap  Init task status change [taskId=3137, targetStatus=ST_OK_STARTW]
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=?
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=?
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=?
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=?
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=?
Hibernate: select items0_.budget_version_id as budget_v3_49_0_, items0_.id as id1_49_0_, items0_.id as id1_49_1_, items0_.last_editing_date as last_edi2_49_1_, items0_.budget_version_id as budget_v3_49_1_, items0_.expense_distribution_item_id as expense_4_49_1_, items0_.expense_distribution_item_root_id as expense_5_49_1_, items0_.limit_with_vat as limit_wi6_49_1_, items0_.take_commission as take_com7_49_1_ from bsm.b_budget_item items0_ where items0_.budget_version_id=?
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=?
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=?
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=?
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=?
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=?
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=?
Hibernate: select actualbala0_.id as id1_41_, actualbala0_.last_editing_date as last_edi2_41_, actualbala0_.budget_version_id as budget_v3_41_, actualbala0_.actual as actual4_41_, actualbala0_.actual_balance_by_executed_operations as actual_b5_41_, actualbala0_.actual_balance_by_operations as actual_b6_41_, actualbala0_.actual_balance_in_system as actual_b7_41_, actualbala0_.budget_id as budget_i8_41_, actualbala0_.expense_distribution_item_id as expense_9_41_, actualbala0_.expense_distribution_item_root_id as expense10_41_, actualbala0_.payment_order_version_id as payment11_41_, actualbala0_.valid_from as valid_f12_41_, actualbala0_.valid_to as valid_t13_41_ from bsm.b_actual_balance actualbala0_ where actualbala0_.budget_version_id=? and actualbala0_.actual=?
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=?
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=?
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=?
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=?
Hibernate: select signblocks0_.budget_version_id as budget_v5_51_0_, signblocks0_.id as id1_51_0_, signblocks0_.id as id1_51_1_, signblocks0_.last_editing_date as last_edi2_51_1_, signblocks0_.hash as hash3_51_1_, signblocks0_.type_id as type_id4_51_1_, signblocks0_.budget_version_id as budget_v5_51_1_ from bsm.b_budget_sign_block signblocks0_ where signblocks0_.budget_version_id=?
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=?
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=?
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=?
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=?
Hibernate: select budgetitem0_.payment_order_version_id as payment_7_188_0_, budgetitem0_.id as id1_188_0_, budgetitem0_.id as id1_188_1_, budgetitem0_.last_editing_date as last_edi2_188_1_, budgetitem0_.payment_order_version_id as payment_7_188_1_, budgetitem0_.amount as amount3_188_1_, budgetitem0_.budget_item_id as budget_i4_188_1_, budgetitem0_.expense_distribution_item_id as expense_5_188_1_, budgetitem0_.expense_distribution_item_root_id as expense_6_188_1_ from posm.po_payment_order_budget_item budgetitem0_ where budgetitem0_.payment_order_version_id=?
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=?
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=?
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=?   backend DEBUG
    March 26th 2021, 10:59:47.953   develop-dev-roscap  Received InitChangeTaskStatusRequest message: {"entityRootId":4669,"entityVersionId":1974,"taskId":3137,"taskTargetStatus":"ST_OK_STARTW","assigneeRootId":61,"pauseReason":null,"pauseReasonRootId":null}  bpm-app DEBUG
    March 26th 2021, 10:59:48.271   develop-dev-roscap  Found taskId = 3137 backend DEBUG
    March 26th 2021, 10:59:48.407   develop-dev-roscap  Prepare for task status update: id=3137, actual status=ST_OK_STARTW, target status=ST_OK_STARTW bpm-app DEBUG
    March 26th 2021, 10:59:48.408   develop-dev-roscap  Sending into camundaRbs::camundaChangeTaskStatusRequest message: {"taskId":3137,"assigneeRootId":61,"taskTargetStatus":"ST_OK_STARTW","pauseReason":null,"manualTask":false,"pauseReasonRootId":null,"entityRootId":4669,"entityVersionId":1974}    bpm-app DEBUG
    March 26th 2021, 10:59:49.105   develop-dev-roscap  Получен запрос от Camunda: {"entityRootId":4669,"entityVersionId":1974,"taskId":3137,"assigneeRootId":61,"taskTargetStatus":"ST_OK_STARTW","pauseReason":null,"manualTask":false,"pauseReasonRootId":null}, corellationId = 78b53797-8df8-11eb-936e-5e684e6d1759
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_, taskdistri1_.id as id1_260_1_, taskdistri1_.last_editing_date as last_edi2_260_1_, taskdistri1_.root_id as root_id3_260_1_, taskdistri1_.actual as actual4_260_1_, taskdistri1_.applicable_to as applicab5_260_1_, taskdistri1_.automatic_distribution as automati6_260_1_, taskdistri1_.create_date as create_d7_260_1_, taskdistri1_.deleted as deleted8_260_1_, taskdistri1_.rule_name as rule_nam9_260_1_, taskdistri1_.priority as priorit10_260_1_, taskdistri1_.start_date as start_d11_260_1_, taskdistri1_.stop_date as stop_da12_260_1_, taskdistri1_.rule_type as rule_ty13_260_1_, taskdistri1_.version_number as version14_260_1_ from tasksm.task taskentity0_ left outer join tasksm.task_distribution_rule taskdistri1_ on taskentity0_.rule_id=taskdistri1_.id where taskentity0_.id=?
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=?
Hibernate: select taskentity0_.id as id1_250_, taskentity0_.last_editing_date as last_edi2_250_, taskentity0_.added_manually as added_ma3_250_, taskentity0_.additional_info as addition4_250_, taskentity0_.assign_date as assign_d5_250_, taskentity0_.automatic_distribution as automati6_250_, taskentity0_.complete_date as complete7_250_, taskentity0_.create_date as create_d8_250_, taskentity0_.created_entity_version_id as created_9_250_, taskentity0_.entity_root_id as entity_10_250_, taskentity0_.entity_status_root_id as entity_11_250_, taskentity0_.entity_version_id as entity_12_250_, taskentity0_.locked as locked13_250_, taskentity0_.performer_employee_id as perform14_250_, taskentity0_.previous_entity_version_id as previou15_250_, taskentity0_.priority as priorit16_250_, taskentity0_.rule_id as rule_id20_250_, taskentity0_.task_number as task_nu17_250_, taskentity0_.task_status_root_id as task_st18_250_, taskentity0_.task_type_root_id as task_ty19_250_ from tasksm.task taskentity0_ where taskentity0_.id=? and taskentity0_.performer_employee_id=?
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=?
Hibernate: select taskworken0_.id as id1_268_, taskworken0_.last_editing_date as last_edi2_268_, taskworken0_.assign_date as assign_d3_268_, taskworken0_.end_date as end_date4_268_, taskworken0_.pause_reason as pause_re5_268_, taskworken0_.pause_reason_root_id as pause_re6_268_, taskworken0_.performer_employee_id as performe7_268_, taskworken0_.revoked as revoked8_268_, taskworken0_.start_date as start_da9_268_, taskworken0_.task_id as task_id10_268_ from tasksm.task_work taskworken0_ where taskworken0_.task_id=? and taskworken0_.performer_employee_id=?
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=?
Hibernate: select nsitasksta0_.id as id1_163_, nsitasksta0_.actual as actual2_163_, nsitasksta0_.create_date as create_d3_163_, nsitasksta0_.deleted as deleted4_163_, nsitasksta0_.inner_code as inner_co5_163_, nsitasksta0_.last_editing_date as last_edi6_163_, nsitasksta0_.root_id as root_id7_163_, nsitasksta0_.sort_order as sort_ord8_163_, nsitasksta0_.value as value9_163_, nsitasksta0_.version_number as version10_163_ from nsism.nsi_task_status nsitasksta0_ where nsitasksta0_.actual=true and nsitasksta0_.root_id=3
Hibernate: select bankdetail0_.id as id1_37_, bankdetail0_.last_editing_date as last_edi2_37_, bankdetail0_.bank_details_root_id as bank_det3_37_, bankdetail0_.details_name as details_4_37_, bankdetail0_.favorite as favorite5_37_, bankdetail0_.organization_root_id as organiza6_37_ from bdtsm.bdt_bank_details_name bankdetail0_ where bankdetail0_.bank_details_root_id=? and bankdetail0_.organization_root_id=?
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_emp46_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_.keycloak_user_id as keycloa29_217_, employeeve0_.last_name as last_na30_217_, employeeve0_.middle_name as middle_31_217_, employeeve0_.is_org_chief as is_org_32_217_, employeeve0_.phone as phone33_217_, employeeve0_.phone_confirmation_date as phone_c34_217_, employeeve0_.phone_confirmation_message as phone_c35_217_, employeeve0_.phone_confirmation_status as phone_c36_217_, employeeve0_.phone_confirmed as phone_c37_217_, employeeve0_.phone_number_on_confirmation as phone_n38_217_, employeeve0_.popup_allowed as popup_a39_217_, employeeve0_.position_emp as positio40_217_, employeeve0_.registration_address as registr41_217_, employeeve0_.role_emp as role_em42_217_, employeeve0_.snils as snils43_217_, employeeve0_.status_id as status_47_217_, employeeve0_.subdivision_root_id as subdivi44_217_, employeeve0_.time_zone_root_id as time_zo45_217_ from ppasm.ppa_employee_version employeeve0_ where employeeve0_.ppa_employee_id=? and employeeve0_.actual=?
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 (?)
Hibernate: select employeeen0_.id as id1_211_0_, employeeen0_.last_editing_date as last_edi2_211_0_, employeeen0_.ppa_organization_id as ppa_orga4_211_0_, employeeen0_.user_privileges as user_pri3_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=?
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=?
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_.id=?
Hibernate: select paymentord0_.id as id1_202_0_, paymentord0_.last_editing_date as last_edi2_202_0_, paymentord0_.actual as actual3_202_0_, paymentord0_.actual_by_business as actual_b4_202_0_, paymentord0_.bagr_agreement_bs_id as bagr_agr5_202_0_, paymentord0_.bagr_agreement_bs_object_id as bagr_agr6_202_0_, paymentord0_.bagr_agreement_bs_object_root_id as bagr_agr7_202_0_, paymentord0_.bagr_agreement_sba_object_id as bagr_agr8_202_0_, paymentord0_.amount as amount9_202_0_, paymentord0_.amount_with_vat as amount_10_202_0_, paymentord0_.analytics_filled as analyti11_202_0_, paymentord0_.budget_version_id as budget_12_202_0_, paymentord0_.budgetary_payment as budgeta13_202_0_, paymentord0_.budgetary_payment_document_number as budgeta14_202_0_, paymentord0_.cagr_agreement_id as cagr_ag15_202_0_, paymentord0_.cagr_agreement_root_id as cagr_ag16_202_0_, paymentord0_.code as code17_202_0_, paymentord0_.create_date as create_18_202_0_, paymentord0_.create_date_month as create_19_202_0_, paymentord0_.create_date_year as create_20_202_0_, paymentord0_.creator_organization_id as creator21_202_0_, paymentord0_.creator_organization_root_id as creator22_202_0_, paymentord0_.currency_id as currenc23_202_0_, paymentord0_.currency_root_id as currenc24_202_0_, paymentord0_.currency_transaction_type_code_id as currenc25_202_0_, paymentord0_.currency_transaction_type_code_root_id as currenc26_202_0_, paymentord0_.customs_code as customs27_202_0_, paymentord0_.editor_employee_root_id as editor_28_202_0_, paymentord0_.editor_organization_id as editor_29_202_0_, paymentord0_.editor_organization_root_id as editor_30_202_0_, paymentord0_.electronic_document_id_1c as electro31_202_0_, paymentord0_.employee_root_id_sent_to_signing as employe32_202_0_, paymentord0_.employee_root_id_signed as employe33_202_0_, paymentord0_.extended_day as extende34_202_0_, paymentord0_.group_operation_id as group_o35_202_0_, paymentord0_.import_file_id as import_36_202_0_, paymentord0_.import_id as import_37_202_0_, paymentord0_.income_type_code_id as income_38_202_0_, paymentord0_.income_type_code_root_id as income_39_202_0_, paymentord0_.individual_information_id as individ40_202_0_, paymentord0_.information_source_id as informa41_202_0_, paymentord0_.information_source_root_id as informa42_202_0_, paymentord0_.kbk as kbk43_202_0_, paymentord0_.law_214_operation as law_44_202_0_, paymentord0_.law_214_operation_type_root_id as law_45_202_0_, paymentord0_.limit_absence as limit_a46_202_0_, paymentord0_.locked as locked47_202_0_, paymentord0_.new_athena_payment_order_id as new_ath48_202_0_, paymentord0_.not_show_payment_cause_document_date as not_sho49_202_0_, paymentord0_.oktmo as oktmo50_202_0_, paymentord0_.operation_type_id as operati51_202_0_, paymentord0_.operation_type_root_id as operati52_202_0_, paymentord0_.parent_na_id as parent_53_202_0_, paymentord0_.parent_payment_order_version_id as parent_54_202_0_, paymentord0_.payer_status_id as payer_s55_202_0_, paymentord0_.payer_status_root_id as payer_s56_202_0_, paymentord0_.payment_by_cagr_agreement as payment57_202_0_, paymentord0_.payment_cause_document_date as payment58_202_0_, paymentord0_.payment_cause_id as payment59_202_0_, paymentord0_.payment_cause_root_id as payment60_202_0_, paymentord0_.payment_form_id as payment61_202_0_, paymentord0_.payment_form_root_id as payment62_202_0_, paymentord0_.payment_order_id as payment98_202_0_, paymentord0_.payment_order_create_date as payment63_202_0_, paymentord0_.payment_order_number as payment64_202_0_, paymentord0_.payment_priority_id as payment65_202_0_, paymentord0_.payment_priority_root_id as payment66_202_0_, paymentord0_.payment_purpose as payment67_202_0_, paymentord0_.payment_purpose_code as payment68_202_0_, paymentord0_.payment_term as payment69_202_0_, paymentord0_.payment_type_id as payment70_202_0_, paymentord0_.payment_type_root_id as payment71_202_0_, paymentord0_.payment_with_funds_received_by_agreement as payment72_202_0_, paymentord0_.period_id as period_73_202_0_, paymentord0_.period_root_id as period_74_202_0_, paymentord0_.refund_payment_order_version_id as refund_75_202_0_, paymentord0_.requisites_clarification as requisi76_202_0_, paymentord0_.requisites_clarification_number as requisi77_202_0_, paymentord0_.reserve_field as reserve78_202_0_, paymentord0_.revoked_by_client as revoked79_202_0_, paymentord0_.sent_clarification_notification as sent_cl80_202_0_, paymentord0_.sent_to_clarification as sent_to81_202_0_, paymentord0_.sent_to_eiszhs as sent_to82_202_0_, paymentord0_.sent_to_eiszhs_id as sent_to83_202_0_, paymentord0_.status_root_id as status_84_202_0_, paymentord0_.system_number as system_85_202_0_, paymentord0_.tax_period_date as tax_per86_202_0_, paymentord0_.tax_period_id as tax_per87_202_0_, paymentord0_.tax_period_indicator_id as tax_per88_202_0_, paymentord0_.tax_period_indicator_root_id as tax_per89_202_0_, paymentord0_.tax_period_root_id as tax_per90_202_0_, paymentord0_.tax_period_year as tax_per91_202_0_, paymentord0_.vat_amount as vat_amo92_202_0_, paymentord0_.vat_rate_id as vat_rat93_202_0_, paymentord0_.vat_rate_root_id as vat_rat94_202_0_, paymentord0_.vat_type_id as vat_typ95_202_0_, paymentord0_.vat_type_root_id as vat_typ96_202_0_, paymentord0_.version_number as version97_202_0_, paymentord1_.id as id1_182_1_, paymentord1_.last_editing_date as last_edi2_182_1_, paymentord2_.id as id1_186_2_, paymentord2_.last_editing_date as last_edi2_186_2_, paymentord2_.payment_order_version_id as payment_4_186_2_, paymentord2_.partial_payment as partial_3_186_2_, paymentord3_.id as id1_194_3_, paymentord3_.last_editing_date as last_edi2_194_3_, paymentord3_.payment_order_version_id as payment10_194_3_, paymentord3_.bank_details_id as bank_det3_194_3_, paymentord3_.bank_details_version_id as bank_det4_194_3_, paymentord3_.first_name as first_na5_194_3_, paymentord3_.individual_recipient as individu6_194_3_, paymentord3_.last_name as last_nam7_194_3_, paymentord3_.middle_name as middle_n8_194_3_, paymentord3_.party_type_root_id as party_ty9_194_3_, paymentord4_.id as id1_201_4_, paymentord4_.last_editing_date as last_edi2_201_4_, paymentord4_.payment_order_version_id as payment_9_201_4_, paymentord4_.acceptance_id as acceptan3_201_4_, paymentord4_.payer_account_debiting_date as payer_ac4_201_4_, paymentord4_.payer_bank_income_date as payer_ba5_201_4_, paymentord4_.payment_order_discard_date as payment_6_201_4_, paymentord4_.payment_sending_date as payment_7_201_4_, paymentord4_.send_to_clarification_by_bank as send_to_8_201_4_ from posm.po_payment_order_version paymentord0_ inner join posm.po_payment_order paymentord1_ on paymentord0_.payment_order_id=paymentord1_.id left outer join posm.po_payment_order_additional_info paymentord2_ on paymentord0_.id=paymentord2_.payment_order_version_id left outer join posm.po_payment_order_individual_party paymentord3_ on paymentord0_.id=paymentord3_.payment_order_version_id left outer join posm.po_payment_order_system_data paymentord4_ on paymentord0_.id=paymentord4_.payment_order_version_id where paymentord0_.id=?
Hibernate: select bankdetail0_.id as id1_36_0_, bankdetail0_.last_editing_date as last_edi2_36_0_, bankdetail0_.root_id as root_id3_36_0_, bankdetail0_.account as account4_36_0_, bankdetail0_.account_status_root_id as account_5_36_0_, bankdetail0_.account_type_root_id as account_6_36_0_, bankdetail0_.actual as actual7_36_0_, bankdetail0_.author_employee_root_id as author_e8_36_0_, bankdetail0_.author_org_root_id as author_o9_36_0_, bankdetail0_.base_agreement_date as base_ag10_36_0_, bankdetail0_.base_agreement_number as base_ag11_36_0_, bankdetail0_.bic as bic12_36_0_, bankdetail0_.close_date as close_d13_36_0_, bankdetail0_.correspondent_account as corresp14_36_0_, bankdetail0_.create_date as create_15_36_0_, bankdetail0_.credit_organization_name as credit_16_36_0_, bankdetail0_.currency_root_id as currenc17_36_0_, bankdetail0_.details_name as details18_36_0_, bankdetail0_.first_name as first_n19_36_0_, bankdetail0_.from_athena as from_at20_36_0_, bankdetail0_.inn as inn21_36_0_, bankdetail0_.last_name as last_na22_36_0_, bankdetail0_.middle_name as middle_23_36_0_, bankdetail0_.na_id as na_id24_36_0_, bankdetail0_.na_update_date as na_upda25_36_0_, bankdetail0_.open_date as open_da26_36_0_, bankdetail0_.ppa_organization_id as ppa_org27_36_0_, bankdetail0_.person_recipient as person_28_36_0_, bankdetail0_.recipient_name as recipie29_36_0_, bankdetail0_.subdivision_code as subdivi30_36_0_, bankdetail0_.version_number as version31_36_0_ from bdtsm.bdt_bank_details bankdetail0_ where bankdetail0_.id=?
Hibernate: select legalentit0_.payment_order_version_id as payment_9_195_0_, legalentit0_.id as id1_195_0_, legalentit0_.id as id1_195_1_, legalentit0_.last_editing_date as last_edi2_195_1_, legalentit0_.payment_order_version_id as payment_9_195_1_, legalentit0_.bank_details_id as bank_det3_195_1_, legalentit0_.bank_details_version_id as bank_det4_195_1_, legalentit0_.party_id as party_id5_195_1_, legalentit0_.party_root_id as party_ro6_195_1_, legalentit0_.party_type_root_id as party_ty7_195_1_, legalentit0_.recipient_name as recipien8_195_1_ from posm.po_payment_order_legal_entity_party legalentit0_ where legalentit0_.payment_order_version_id=?
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=?
Hibernate: select bankdetail0_.id as id1_36_0_, bankdetail0_.last_editing_date as last_edi2_36_0_, bankdetail0_.root_id as root_id3_36_0_, bankdetail0_.account as account4_36_0_, bankdetail0_.account_status_root_id as account_5_36_0_, bankdetail0_.account_type_root_id as account_6_36_0_, bankdetail0_.actual as actual7_36_0_, bankdetail0_.author_employee_root_id as author_e8_36_0_, bankdetail0_.author_org_root_id as author_o9_36_0_, bankdetail0_.base_agreement_date as base_ag10_36_0_, bankdetail0_.base_agreement_number as base_ag11_36_0_, bankdetail0_.bic as bic12_36_0_, bankdetail0_.close_date as close_d13_36_0_, bankdetail0_.correspondent_account as corresp14_36_0_, bankdetail0_.create_date as create_15_36_0_, bankdetail0_.credit_organization_name as credit_16_36_0_, bankdetail0_.currency_root_id as currenc17_36_0_, bankdetail0_.details_name as details18_36_0_, bankdetail0_.first_name as first_n19_36_0_, bankdetail0_.from_athena as from_at20_36_0_, bankdetail0_.inn as inn21_36_0_, bankdetail0_.last_name as last_na22_36_0_, bankdetail0_.middle_name as middle_23_36_0_, bankdetail0_.na_id as na_id24_36_0_, bankdetail0_.na_update_date as na_upda25_36_0_, bankdetail0_.open_date as open_da26_36_0_, bankdetail0_.ppa_organization_id as ppa_org27_36_0_, bankdetail0_.person_recipient as person_28_36_0_, bankdetail0_.recipient_name as recipie29_36_0_, bankdetail0_.subdivision_code as subdivi30_36_0_, bankdetail0_.version_number as version31_36_0_ from bdtsm.bdt_bank_details bankdetail0_ where bankdetail0_.id=?
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=?
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=?
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=?
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=?
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
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=?
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=?
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=?
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=?
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=?
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=?
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=?
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=?
Hibernate: select bankdetail0_.id as id1_37_, bankdetail0_.last_editing_date as last_edi2_37_, bankdetail0_.bank_details_root_id as bank_det3_37_, bankdetail0_.details_name as details_4_37_, bankdetail0_.favorite as favorite5_37_, bankdetail0_.organization_root_id as organiza6_37_ from bdtsm.bdt_bank_details_name bankdetail0_ where bankdetail0_.bank_details_root_id=? and bankdetail0_.organization_root_id=?
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=?
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 (?)
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=?
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=?
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_.id=?
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=?  backend DEBUG
    March 26th 2021, 10:59:49.638   develop-dev-roscap  Received ChangeTaskStatusResponse message: {"entityRootId":4669,"entityVersionId":1974,"taskId":3137}   bpm-app DEBUG
    March 26th 2021, 10:59:50.054   develop-dev-roscap  Found taskId = 3137 backend DEBUG
    March 26th 2021, 10:59:52.341   develop-dev-roscap  Found taskId = 3137 backend DEBUG
    March 26th 2021, 11:00:10.200   develop-dev-roscap  send to camundaRbs::camundaResolvePaymentOrderRequest, request ru.lanit.rbs.paymentorders.api.request.camunda.jms.outcoming.CamundaResolvePaymentOrderRequest@708e05a2[resolution=ACCEPT,taskId=3137,initiatorId=61,entityRootId=4669,entityVersionId=1974] backend INFO
    March 26th 2021, 11:00:10.225   develop-dev-roscap  Received BankDecisionRequest message: {"entityRootId":4669,"entityVersionId":1974,"initiatorId":61,"resolution":"ACCEPT","taskId":3137} bpm-app DEBUG
    March 26th 2021, 11:00:10.257   develop-dev-roscap  [BankDecisionRequest] Completing task 3137 in process with business key 4669    bpm-app INFO
    March 26th 2021, 11:00:14.197   develop-dev-roscap  Found taskId = 3137 backend DEBUG
    March 26th 2021, 11:00:16.075   develop-dev-roscap  Prepare for task status update: id=3137, actual status=ST_OK_STARTW, target status=ST_OK_COMPLETED  bpm-app DEBUG
    March 26th 2021, 11:00:16.075   develop-dev-roscap  Sending into camundaRbs::camundaChangeTaskStatusRequest message: {"taskId":3137,"assigneeRootId":61,"taskTargetStatus":"ST_OK_COMPLETED","pauseReason":null,"manualTask":false,"pauseReasonRootId":null,"entityRootId":4669,"entityVersionId":1974} bpm-app DEBUG
    March 26th 2021, 11:00:16.770   develop-dev-roscap  Получен запрос от Camunda: {"entityRootId":4669,"entityVersionId":1974,"taskId":3137,"assigneeRootId":61,"taskTargetStatus":"ST_OK_COMPLETED","pauseReason":null,"manualTask":false,"pauseReasonRootId":null}, corellationId = 87efd653-8df8-11eb-936e-5e684e6d1759
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_, taskdistri1_.id as id1_260_1_, taskdistri1_.last_editing_date as last_edi2_260_1_, taskdistri1_.root_id as root_id3_260_1_, taskdistri1_.actual as actual4_260_1_, taskdistri1_.applicable_to as applicab5_260_1_, taskdistri1_.automatic_distribution as automati6_260_1_, taskdistri1_.create_date as create_d7_260_1_, taskdistri1_.deleted as deleted8_260_1_, taskdistri1_.rule_name as rule_nam9_260_1_, taskdistri1_.priority as priorit10_260_1_, taskdistri1_.start_date as start_d11_260_1_, taskdistri1_.stop_date as stop_da12_260_1_, taskdistri1_.rule_type as rule_ty13_260_1_, taskdistri1_.version_number as version14_260_1_ from tasksm.task taskentity0_ left outer join tasksm.task_distribution_rule taskdistri1_ on taskentity0_.rule_id=taskdistri1_.id where taskentity0_.id=?
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=?
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=?
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=?
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=?
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=?
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=?
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=?
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=?
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=?
Hibernate: select taskentity0_.id as id1_250_, taskentity0_.last_editing_date as last_edi2_250_, taskentity0_.added_manually as added_ma3_250_, taskentity0_.additional_info as addition4_250_, taskentity0_.assign_date as assign_d5_250_, taskentity0_.automatic_distribution as automati6_250_, taskentity0_.complete_date as complete7_250_, taskentity0_.create_date as create_d8_250_, taskentity0_.created_entity_version_id as created_9_250_, taskentity0_.entity_root_id as entity_10_250_, taskentity0_.entity_status_root_id as entity_11_250_, taskentity0_.entity_version_id as entity_12_250_, taskentity0_.locked as locked13_250_, taskentity0_.performer_employee_id as perform14_250_, taskentity0_.previous_entity_version_id as previou15_250_, taskentity0_.priority as priorit16_250_, taskentity0_.rule_id as rule_id20_250_, taskentity0_.task_number as task_nu17_250_, taskentity0_.task_status_root_id as task_st18_250_, taskentity0_.task_type_root_id as task_ty19_250_ from tasksm.task taskentity0_ where taskentity0_.id=? and taskentity0_.performer_employee_id=?
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=?
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=?
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=?
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=?
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=?
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=?
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=?
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=?
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=?
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=?
Hibernate: select taskworken0_.id as id1_268_, taskworken0_.last_editing_date as last_edi2_268_, taskworken0_.assign_date as assign_d3_268_, taskworken0_.end_date as end_date4_268_, taskworken0_.pause_reason as pause_re5_268_, taskworken0_.pause_reason_root_id as pause_re6_268_, taskworken0_.performer_employee_id as performe7_268_, taskworken0_.revoked as revoked8_268_, taskworken0_.start_date as start_da9_268_, taskworken0_.task_id as task_id10_268_ from tasksm.task_work taskworken0_ where taskworken0_.task_id=? and taskworken0_.performer_employee_id=?
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=?
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=?
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=?
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=?
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=?
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=?
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=?
Hibernate: select nsitasksta0_.id as id1_163_, nsitasksta0_.actual as actual2_163_, nsitasksta0_.create_date as create_d3_163_, nsitasksta0_.deleted as deleted4_163_, nsitasksta0_.inner_code as inner_co5_163_, nsitasksta0_.last_editing_date as last_edi6_163_, nsitasksta0_.root_id as root_id7_163_, nsitasksta0_.sort_order as sort_ord8_163_, nsitasksta0_.value as value9_163_, nsitasksta0_.version_number as version10_163_ from nsism.nsi_task_status nsitasksta0_ where nsitasksta0_.actual=true and nsitasksta0_.root_id=5
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=?
Hibernate: select bankdetail0_.id as id1_37_, bankdetail0_.last_editing_date as last_edi2_37_, bankdetail0_.bank_details_root_id as bank_det3_37_, bankdetail0_.details_name as details_4_37_, bankdetail0_.favorite as favorite5_37_, bankdetail0_.organization_root_id as organiza6_37_ from bdtsm.bdt_bank_details_name bankdetail0_ where bankdetail0_.bank_details_root_id=? and bankdetail0_.organization_root_id=?
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=?
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=?
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=?
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=?
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
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=?
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=?
Hibernate: select filemetada0_.id as id1_73_0_, filemetada0_.blob_id as blob_id2_73_0_, filemetada0_.blob_url as blob_url3_73_0_, filemetada0_.context as context4_73_0_, filemetada0_.create_date as create_d5_73_0_, filemetada0_.document_date as document6_73_0_, filemetada0_.document_number as document7_73_0_, filemetada0_.document_status_root_id as document8_73_0_, filemetada0_.document_type_code as document9_73_0_, filemetada0_.document_type_id as documen10_73_0_, filemetada0_.entity_id as entity_11_73_0_, filemetada0_.entity_type as entity_12_73_0_, filemetada0_.hash as hash13_73_0_, filemetada0_.hidden as hidden14_73_0_, filemetada0_.last_editing_date as last_ed15_73_0_, filemetada0_.linked_sign_object as linked_16_73_0_, filemetada0_.name as name17_73_0_, filemetada0_.signed_by_one_party as signed_18_73_0_, filemetada0_.size as size19_73_0_, filemetada0_.status as status20_73_0_, filemetada0_.user_root_id as user_ro21_73_0_, filemetada0_.visible_to_client as visible22_73_0_ from fssm.fs_file filemetada0_ where filemetada0_.id=?
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
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=?
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=?   backend DEBUG
    March 26th 2021, 11:00:17.503   develop-dev-roscap  Received ChangeTaskStatusResponse message: {"entityRootId":4669,"entityVersionId":1974,"taskId":3137}   bpm-app DEBUG
    March 26th 2021, 11:00:37.876   develop-dev-roscap  Prepare for task status update: id=3137, actual status=ST_OK_COMPLETED, target status=ST_OK_ASSIGNEE    bpm-app DEBUG
    March 26th 2021, 11:00:37.877   develop-dev-roscap  Sending into camundaRbs::camundaChangeTaskStatusRequest message: {"taskId":3137,"assigneeRootId":61,"taskTargetStatus":"ST_OK_ASSIGNEE","pauseReason":null,"manualTask":false,"pauseReasonRootId":null,"entityRootId":4669,"entityVersionId":1974}  bpm-app DEBUG
    March 26th 2021, 11:00:40.250   develop-dev-roscap  Получен запрос от Camunda: {"entityRootId":4669,"entityVersionId":1974,"taskId":3137,"assigneeRootId":61,"taskTargetStatus":"ST_OK_ASSIGNEE","pauseReason":null,"manualTask":false,"pauseReasonRootId":null}, corellationId = 95b2f0cc-8df8-11eb-936e-5e684e6d1759
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_, taskdistri1_.id as id1_260_1_, taskdistri1_.last_editing_date as last_edi2_260_1_, taskdistri1_.root_id as root_id3_260_1_, taskdistri1_.actual as actual4_260_1_, taskdistri1_.applicable_to as applicab5_260_1_, taskdistri1_.automatic_distribution as automati6_260_1_, taskdistri1_.create_date as create_d7_260_1_, taskdistri1_.deleted as deleted8_260_1_, taskdistri1_.rule_name as rule_nam9_260_1_, taskdistri1_.priority as priorit10_260_1_, taskdistri1_.start_date as start_d11_260_1_, taskdistri1_.stop_date as stop_da12_260_1_, taskdistri1_.rule_type as rule_ty13_260_1_, taskdistri1_.version_number as version14_260_1_ from tasksm.task taskentity0_ left outer join tasksm.task_distribution_rule taskdistri1_ on taskentity0_.rule_id=taskdistri1_.id where taskentity0_.id=?
Hibernate: select taskworken0_.id as id1_268_, taskworken0_.last_editing_date as last_edi2_268_, taskworken0_.assign_date as assign_d3_268_, taskworken0_.end_date as end_date4_268_, taskworken0_.pause_reason as pause_re5_268_, taskworken0_.pause_reason_root_id as pause_re6_268_, taskworken0_.performer_employee_id as performe7_268_, taskworken0_.revoked as revoked8_268_, taskworken0_.start_date as start_da9_268_, taskworken0_.task_id as task_id10_268_ from tasksm.task_work taskworken0_ where taskworken0_.task_id=? and taskworken0_.performer_employee_id=?
Hibernate: select nsitasksta0_.id as id1_163_, nsitasksta0_.actual as actual2_163_, nsitasksta0_.create_date as create_d3_163_, nsitasksta0_.deleted as deleted4_163_, nsitasksta0_.inner_code as inner_co5_163_, nsitasksta0_.last_editing_date as last_edi6_163_, nsitasksta0_.root_id as root_id7_163_, nsitasksta0_.sort_order as sort_ord8_163_, nsitasksta0_.value as value9_163_, nsitasksta0_.version_number as version10_163_ from nsism.nsi_task_status nsitasksta0_ where nsitasksta0_.actual=true and nsitasksta0_.root_id=2
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_emp46_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_.keycloak_user_id as keycloa29_217_, employeeve0_.last_name as last_na30_217_, employeeve0_.middle_name as middle_31_217_, employeeve0_.is_org_chief as is_org_32_217_, employeeve0_.phone as phone33_217_, employeeve0_.phone_confirmation_date as phone_c34_217_, employeeve0_.phone_confirmation_message as phone_c35_217_, employeeve0_.phone_confirmation_status as phone_c36_217_, employeeve0_.phone_confirmed as phone_c37_217_, employeeve0_.phone_number_on_confirmation as phone_n38_217_, employeeve0_.popup_allowed as popup_a39_217_, employeeve0_.position_emp as positio40_217_, employeeve0_.registration_address as registr41_217_, employeeve0_.role_emp as role_em42_217_, employeeve0_.snils as snils43_217_, employeeve0_.status_id as status_47_217_, employeeve0_.subdivision_root_id as subdivi44_217_, employeeve0_.time_zone_root_id as time_zo45_217_ from ppasm.ppa_employee_version employeeve0_ where employeeve0_.ppa_employee_id=? and employeeve0_.actual=?
Hibernate: select employeeen0_.id as id1_211_0_, employeeen0_.last_editing_date as last_edi2_211_0_, employeeen0_.ppa_organization_id as ppa_orga4_211_0_, employeeen0_.user_privileges as user_pri3_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=?
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=?
Hibernate: select paymentord0_.id as id1_202_0_, paymentord0_.last_editing_date as last_edi2_202_0_, paymentord0_.actual as actual3_202_0_, paymentord0_.actual_by_business as actual_b4_202_0_, paymentord0_.bagr_agreement_bs_id as bagr_agr5_202_0_, paymentord0_.bagr_agreement_bs_object_id as bagr_agr6_202_0_, paymentord0_.bagr_agreement_bs_object_root_id as bagr_agr7_202_0_, paymentord0_.bagr_agreement_sba_object_id as bagr_agr8_202_0_, paymentord0_.amount as amount9_202_0_, paymentord0_.amount_with_vat as amount_10_202_0_, paymentord0_.analytics_filled as analyti11_202_0_, paymentord0_.budget_version_id as budget_12_202_0_, paymentord0_.budgetary_payment as budgeta13_202_0_, paymentord0_.budgetary_payment_document_number as budgeta14_202_0_, paymentord0_.cagr_agreement_id as cagr_ag15_202_0_, paymentord0_.cagr_agreement_root_id as cagr_ag16_202_0_, paymentord0_.code as code17_202_0_, paymentord0_.create_date as create_18_202_0_, paymentord0_.create_date_month as create_19_202_0_, paymentord0_.create_date_year as create_20_202_0_, paymentord0_.creator_organization_id as creator21_202_0_, paymentord0_.creator_organization_root_id as creator22_202_0_, paymentord0_.currency_id as currenc23_202_0_, paymentord0_.currency_root_id as currenc24_202_0_, paymentord0_.currency_transaction_type_code_id as currenc25_202_0_, paymentord0_.currency_transaction_type_code_root_id as currenc26_202_0_, paymentord0_.customs_code as customs27_202_0_, paymentord0_.editor_employee_root_id as editor_28_202_0_, paymentord0_.editor_organization_id as editor_29_202_0_, paymentord0_.editor_organization_root_id as editor_30_202_0_, paymentord0_.electronic_document_id_1c as electro31_202_0_, paymentord0_.employee_root_id_sent_to_signing as employe32_202_0_, paymentord0_.employee_root_id_signed as employe33_202_0_, paymentord0_.extended_day as extende34_202_0_, paymentord0_.group_operation_id as group_o35_202_0_, paymentord0_.import_file_id as import_36_202_0_, paymentord0_.import_id as import_37_202_0_, paymentord0_.income_type_code_id as income_38_202_0_, paymentord0_.income_type_code_root_id as income_39_202_0_, paymentord0_.individual_information_id as individ40_202_0_, paymentord0_.information_source_id as informa41_202_0_, paymentord0_.information_source_root_id as informa42_202_0_, paymentord0_.kbk as kbk43_202_0_, paymentord0_.law_214_operation as law_44_202_0_, paymentord0_.law_214_operation_type_root_id as law_45_202_0_, paymentord0_.limit_absence as limit_a46_202_0_, paymentord0_.locked as locked47_202_0_, paymentord0_.new_athena_payment_order_id as new_ath48_202_0_, paymentord0_.not_show_payment_cause_document_date as not_sho49_202_0_, paymentord0_.oktmo as oktmo50_202_0_, paymentord0_.operation_type_id as operati51_202_0_, paymentord0_.operation_type_root_id as operati52_202_0_, paymentord0_.parent_na_id as parent_53_202_0_, paymentord0_.parent_payment_order_version_id as parent_54_202_0_, paymentord0_.payer_status_id as payer_s55_202_0_, paymentord0_.payer_status_root_id as payer_s56_202_0_, paymentord0_.payment_by_cagr_agreement as payment57_202_0_, paymentord0_.payment_cause_document_date as payment58_202_0_, paymentord0_.payment_cause_id as payment59_202_0_, paymentord0_.payment_cause_root_id as payment60_202_0_, paymentord0_.payment_form_id as payment61_202_0_, paymentord0_.payment_form_root_id as payment62_202_0_, paymentord0_.payment_order_id as payment98_202_0_, paymentord0_.payment_order_create_date as payment63_202_0_, paymentord0_.payment_order_number as payment64_202_0_, paymentord0_.payment_priority_id as payment65_202_0_, paymentord0_.payment_priority_root_id as payment66_202_0_, paymentord0_.payment_purpose as payment67_202_0_, paymentord0_.payment_purpose_code as payment68_202_0_, paymentord0_.payment_term as payment69_202_0_, paymentord0_.payment_type_id as payment70_202_0_, paymentord0_.payment_type_root_id as payment71_202_0_, paymentord0_.payment_with_funds_received_by_agreement as payment72_202_0_, paymentord0_.period_id as period_73_202_0_, paymentord0_.period_root_id as period_74_202_0_, paymentord0_.refund_payment_order_version_id as refund_75_202_0_, paymentord0_.requisites_clarification as requisi76_202_0_, paymentord0_.requisites_clarification_number as requisi77_202_0_, paymentord0_.reserve_field as reserve78_202_0_, paymentord0_.revoked_by_client as revoked79_202_0_, paymentord0_.sent_clarification_notification as sent_cl80_202_0_, paymentord0_.sent_to_clarification as sent_to81_202_0_, paymentord0_.sent_to_eiszhs as sent_to82_202_0_, paymentord0_.sent_to_eiszhs_id as sent_to83_202_0_, paymentord0_.status_root_id as status_84_202_0_, paymentord0_.system_number as system_85_202_0_, paymentord0_.tax_period_date as tax_per86_202_0_, paymentord0_.tax_period_id as tax_per87_202_0_, paymentord0_.tax_period_indicator_id as tax_per88_202_0_, paymentord0_.tax_period_indicator_root_id as tax_per89_202_0_, paymentord0_.tax_period_root_id as tax_per90_202_0_, paymentord0_.tax_period_year as tax_per91_202_0_, paymentord0_.vat_amount as vat_amo92_202_0_, paymentord0_.vat_rate_id as vat_rat93_202_0_, paymentord0_.vat_rate_root_id as vat_rat94_202_0_, paymentord0_.vat_type_id as vat_typ95_202_0_, paymentord0_.vat_type_root_id as vat_typ96_202_0_, paymentord0_.version_number as version97_202_0_, paymentord1_.id as id1_182_1_, paymentord1_.last_editing_date as last_edi2_182_1_, paymentord2_.id as id1_186_2_, paymentord2_.last_editing_date as last_edi2_186_2_, paymentord2_.payment_order_version_id as payment_4_186_2_, paymentord2_.partial_payment as partial_3_186_2_, paymentord3_.id as id1_194_3_, paymentord3_.last_editing_date as last_edi2_194_3_, paymentord3_.payment_order_version_id as payment10_194_3_, paymentord3_.bank_details_id as bank_det3_194_3_, paymentord3_.bank_details_version_id as bank_det4_194_3_, paymentord3_.first_name as first_na5_194_3_, paymentord3_.individual_recipient as individu6_194_3_, paymentord3_.last_name as last_nam7_194_3_, paymentord3_.middle_name as middle_n8_194_3_, paymentord3_.party_type_root_id as party_ty9_194_3_, paymentord4_.id as id1_201_4_, paymentord4_.last_editing_date as last_edi2_201_4_, paymentord4_.payment_order_version_id as payment_9_201_4_, paymentord4_.acceptance_id as acceptan3_201_4_, paymentord4_.payer_account_debiting_date as payer_ac4_201_4_, paymentord4_.payer_bank_income_date as payer_ba5_201_4_, paymentord4_.payment_order_discard_date as payment_6_201_4_, paymentord4_.payment_sending_date as payment_7_201_4_, paymentord4_.send_to_clarification_by_bank as send_to_8_201_4_ from posm.po_payment_order_version paymentord0_ inner join posm.po_payment_order paymentord1_ on paymentord0_.payment_order_id=paymentord1_.id left outer join posm.po_payment_order_additional_info paymentord2_ on paymentord0_.id=paymentord2_.payment_order_version_id left outer join posm.po_payment_order_individual_party paymentord3_ on paymentord0_.id=paymentord3_.payment_order_version_id left outer join posm.po_payment_order_system_data paymentord4_ on paymentord0_.id=paymentord4_.payment_order_version_id where paymentord0_.id=?
Hibernate: select legalentit0_.payment_order_version_id as payment_9_195_0_, legalentit0_.id as id1_195_0_, legalentit0_.id as id1_195_1_, legalentit0_.last_editing_date as last_edi2_195_1_, legalentit0_.payment_order_version_id as payment_9_195_1_, legalentit0_.bank_details_id as bank_det3_195_1_, legalentit0_.bank_details_version_id as bank_det4_195_1_, legalentit0_.party_id as party_id5_195_1_, legalentit0_.party_root_id as party_ro6_195_1_, legalentit0_.party_type_root_id as party_ty7_195_1_, legalentit0_.recipient_name as recipien8_195_1_ from posm.po_payment_order_legal_entity_party legalentit0_ where legalentit0_.payment_order_version_id=?
Hibernate: select bankdetail0_.id as id1_36_0_, bankdetail0_.last_editing_date as last_edi2_36_0_, bankdetail0_.root_id as root_id3_36_0_, bankdetail0_.account as account4_36_0_, bankdetail0_.account_status_root_id as account_5_36_0_, bankdetail0_.account_type_root_id as account_6_36_0_, bankdetail0_.actual as actual7_36_0_, bankdetail0_.author_employee_root_id as author_e8_36_0_, bankdetail0_.author_org_root_id as author_o9_36_0_, bankdetail0_.base_agreement_date as base_ag10_36_0_, bankdetail0_.base_agreement_number as base_ag11_36_0_, bankdetail0_.bic as bic12_36_0_, bankdetail0_.close_date as close_d13_36_0_, bankdetail0_.correspondent_account as corresp14_36_0_, bankdetail0_.create_date as create_15_36_0_, bankdetail0_.credit_organization_name as credit_16_36_0_, bankdetail0_.currency_root_id as currenc17_36_0_, bankdetail0_.details_name as details18_36_0_, bankdetail0_.first_name as first_n19_36_0_, bankdetail0_.from_athena as from_at20_36_0_, bankdetail0_.inn as inn21_36_0_, bankdetail0_.last_name as last_na22_36_0_, bankdetail0_.middle_name as middle_23_36_0_, bankdetail0_.na_id as na_id24_36_0_, bankdetail0_.na_update_date as na_upda25_36_0_, bankdetail0_.open_date as open_da26_36_0_, bankdetail0_.ppa_organization_id as ppa_org27_36_0_, bankdetail0_.person_recipient as person_28_36_0_, bankdetail0_.recipient_name as recipie29_36_0_, bankdetail0_.subdivision_code as subdivi30_36_0_, bankdetail0_.version_number as version31_36_0_ from bdtsm.bdt_bank_details bankdetail0_ where bankdetail0_.id=?
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=?
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
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=?
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=?
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=?
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=?
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=?
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=?
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=?
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=?
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=?
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 (?)
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_.id=?
Hibernate: select bankdetail0_.id as id1_36_0_, bankdetail0_.last_editing_date as last_edi2_36_0_, bankdetail0_.root_id as root_id3_36_0_, bankdetail0_.account as account4_36_0_, bankdetail0_.account_status_root_id as account_5_36_0_, bankdetail0_.account_type_root_id as account_6_36_0_, bankdetail0_.actual as actual7_36_0_, bankdetail0_.author_employee_root_id as author_e8_36_0_, bankdetail0_.author_org_root_id as author_o9_36_0_, bankdetail0_.base_agreement_date as base_ag10_36_0_, bankdetail0_.base_agreement_number as base_ag11_36_0_, bankdetail0_.bic as bic12_36_0_, bankdetail0_.close_date as close_d13_36_0_, bankdetail0_.correspondent_account as corresp14_36_0_, bankdetail0_.create_date as create_15_36_0_, bankdetail0_.credit_organization_name as credit_16_36_0_, bankdetail0_.currency_root_id as currenc17_36_0_, bankdetail0_.details_name as details18_36_0_, bankdetail0_.first_name as first_n19_36_0_, bankdetail0_.from_athena as from_at20_36_0_, bankdetail0_.inn as inn21_36_0_, bankdetail0_.last_name as last_na22_36_0_, bankdetail0_.middle_name as middle_23_36_0_, bankdetail0_.na_id as na_id24_36_0_, bankdetail0_.na_update_date as na_upda25_36_0_, bankdetail0_.open_date as open_da26_36_0_, bankdetail0_.ppa_organization_id as ppa_org27_36_0_, bankdetail0_.person_recipient as person_28_36_0_, bankdetail0_.recipient_name as recipie29_36_0_, bankdetail0_.subdivision_code as subdivi30_36_0_, bankdetail0_.version_number as version31_36_0_ from bdtsm.bdt_bank_details bankdetail0_ where bankdetail0_.id=?
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=?
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=?
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=?
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=?
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=?
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=?
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=?
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=?
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 (?)
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_.id=?
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_emp46_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_.keycloak_user_id as keycloa29_217_, employeeve0_.last_name as last_na30_217_, employeeve0_.middle_name as middle_31_217_, employeeve0_.is_org_chief as is_org_32_217_, employeeve0_.phone as phone33_217_, employeeve0_.phone_confirmation_date as phone_c34_217_, employeeve0_.phone_confirmation_message as phone_c35_217_, employeeve0_.phone_confirmation_status as phone_c36_217_, employeeve0_.phone_confirmed as phone_c37_217_, employeeve0_.phone_number_on_confirmation as phone_n38_217_, employeeve0_.popup_allowed as popup_a39_217_, employeeve0_.position_emp as positio40_217_, employeeve0_.registration_address as registr41_217_, employeeve0_.role_emp as role_em42_217_, employeeve0_.snils as snils43_217_, employeeve0_.status_id as status_47_217_, employeeve0_.subdivision_root_id as subdivi44_217_, employeeve0_.time_zone_root_id as time_zo45_217_ from ppasm.ppa_employee_version employeeve0_ where employeeve0_.ppa_employee_id=? and employeeve0_.actual=?
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=?
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=?
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=5
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=2
Hibernate: select taskworken0_.id as id1_268_, taskworken0_.last_editing_date as last_edi2_268_, taskworken0_.assign_date as assign_d3_268_, taskworken0_.end_date as end_date4_268_, taskworken0_.pause_reason as pause_re5_268_, taskworken0_.pause_reason_root_id as pause_re6_268_, taskworken0_.performer_employee_id as performe7_268_, taskworken0_.revoked as revoked8_268_, taskworken0_.start_date as start_da9_268_, taskworken0_.task_id as task_id10_268_ from tasksm.task_work taskworken0_ where taskworken0_.task_id=?
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=?
Hibernate: update tasksm.task set last_editing_date=?, added_manually=?, additional_info=?, assign_date=?, automatic_distribution=?, complete_date=?, create_date=?, created_entity_version_id=?, entity_root_id=?, entity_status_root_id=?, entity_version_id=?, locked=?, performer_employee_id=?, previous_entity_version_id=?, priority=?, rule_id=?, task_number=?, task_status_root_id=?, task_type_root_id=? where id=? and last_editing_date=?
Hibernate: insert into tasksm.task_work (last_editing_date, assign_date, end_date, pause_reason, pause_reason_root_id, performer_employee_id, revoked, start_date, task_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?)  backend DEBUG
    March 26th 2021, 11:00:40.388   develop-dev-roscap  processEventNotificationQueue request: NotificationCreateRequest{entityType=TASK_BY_PAYMENT_ORDEReventCode=CO_OK_27entity.id=nullentity.rootId=3137}
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=?
Hibernate: select employeeve0_.id as id1_217_0_, employeeen7_.id as id1_211_1_, organizati8_.id as id1_220_2_, employeest9_.id as id1_216_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_emp46_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_.keycloak_user_id as keycloa29_217_0_, employeeve0_.last_name as last_na30_217_0_, employeeve0_.middle_name as middle_31_217_0_, employeeve0_.is_org_chief as is_org_32_217_0_, employeeve0_.phone as phone33_217_0_, employeeve0_.phone_confirmation_date as phone_c34_217_0_, employeeve0_.phone_confirmation_message as phone_c35_217_0_, employeeve0_.phone_confirmation_status as phone_c36_217_0_, employeeve0_.phone_confirmed as phone_c37_217_0_, employeeve0_.phone_number_on_confirmation as phone_n38_217_0_, employeeve0_.popup_allowed as popup_a39_217_0_, employeeve0_.position_emp as positio40_217_0_, employeeve0_.registration_address as registr41_217_0_, employeeve0_.role_emp as role_em42_217_0_, employeeve0_.snils as snils43_217_0_, employeeve0_.status_id as status_47_217_0_, employeeve0_.subdivision_root_id as subdivi44_217_0_, employeeve0_.time_zone_root_id as time_zo45_217_0_, employeeen7_.last_editing_date as last_edi2_211_1_, employeeen7_.ppa_organization_id as ppa_orga4_211_1_, employeeen7_.user_privileges as user_pri3_211_1_, organizati8_.last_editing_date as last_edi2_220_2_, organizati8_.login_1c as login_3_220_2_, organizati8_.ogrn as ogrn4_220_2_, organizati8_.password_1c as password5_220_2_, organizati8_.session_expiration_1c as session_6_220_2_, organizati8_.session_id_1c as session_7_220_2_, employeest9_.last_editing_date as last_edi2_216_3_, employeest9_.block as block3_216_3_, employeest9_.block_date as block_da4_216_3_, employeest9_.block_info as block_in5_216_3_, employeest9_.block_reason_id as block_re6_216_3_, employeest9_.registered as register7_216_3_, employeest9_.registration_date as registra8_216_3_, employeest9_.unlock_date as unlock_d9_216_3_ from ppasm.ppa_employee_version employeeve0_ left outer join ppasm.ppa_employee employeeen7_ on employeeve0_.ppa_employee_id=employeeen7_.id left outer join ppasm.ppa_organization organizati8_ on employeeen7_.ppa_organization_id=organizati8_.id left outer join ppasm.ppa_employee_status employeest9_ on employeeve0_.status_id=employeest9_.id cross join ppasm.ppa_employee_status employeest1_ where employeeve0_.status_id=employeest1_.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 (exists (select 1 from ppasm.ppa_organization_role orgroles6_ where organizati2_.id=orgroles6_.ppa_org_version_id and orgroles6_.org_role_root_id=?)))) and employeeve0_.ppa_employee_id=?
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=?
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=? backend DEBUG
    March 26th 2021, 11:00:40.392   develop-dev-roscap  Received ChangeTaskStatusResponse message: {"entityRootId":4669,"entityVersionId":1974,"taskId":3137}   bpm-app DEBUG
    March 26th 2021, 11:00:40.408   develop-dev-roscap  Created notification: id=1616442, receiver=NotificationReceiver{employeeRootId=61, firstName='Алексей', middleName='Александрович', lastName='Логинов', email='testVDTSDK@testmail.test', phone='89762786187'"entityRootId":4669,"entityVersionId":1974,"taskId":3137,"taskTargetStatus":"ST_OK_STARTW","assigneeRootId":61,"pauseReason":null,"pauseReasonRootId":null} bpm-app DEBUG
    March 26th 2021, 11:00:51.769   develop-dev-roscap  Message processing exception

ru.lanit.bpm.rbs.common.exception.TaskNotFoundException: Task with id 3137 is not found
    at ru.lanit.bpm.rbs.service.impl.ProcessServiceImpl.findTaskById(ProcessServiceImpl.java:100) ~[classes!/:na]
    at ru.lanit.bpm.rbs.service.impl.ProcessServiceImpl.assignTask(ProcessServiceImpl.java:89) ~[classes!/:na]
    at ru.lanit.bpm.rbs.common.processors.TaskMessageProcessor.processInitChangeTaskStatusRequest(TaskMessageProcessor.java:63) ~[classes!/:na]
    at ru.lanit.bpm.rbs.common.TaskJmsReceiver.lambda$processInitChangeTaskStatusRequest$0(TaskJmsReceiver.java:45) ~[classes!/:na]
    at ru.lanit.bpm.rbs.common.TaskJmsReceiver.ignoringBpmRuntimeException(TaskJmsReceiver.java:69) ~[classes!/:na]
    at ru.lanit.bpm.rbs.common.TaskJmsReceiver.processInitChangeTaskStatusRequest(TaskJmsReceiver.java:45) ~[classes!/:na]
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:na]
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:na]
    at java.base/java.lang.reflect.Method.invoke(Unknown Source) ~[na:na]
    at org.springframework.messaging.handler.invocation.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:171) ~[spring-messaging-5.2.2.RELEASE.jar!/:5.2.2.RELEASE]
    at org.springframework.messaging.handler.invocation.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:120) ~[spring-messaging-5.2.2.RELEASE.jar!/:5.2.2.RELEASE]
    at org.springframework.jms.listener.adapter.MessagingMessageListenerAdapter.invokeHandler(MessagingMessageListenerAdapter.java:114) ~[spring-jms-5.2.2.RELEASE.jar!/:5.2.2.RELEASE]
    at org.springframework.jms.listener.adapter.MessagingMessageListenerAdapter.onMessage(MessagingMessageListenerAdapter.java:77) ~[spring-jms-5.2.2.RELEASE.jar!/:5.2.2.RELEASE]
    at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:736) ~[spring-jms-5.2.2.RELEASE.jar!/:5.2.2.RELEASE]
    at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:696) ~[spring-jms-5.2.2.RELEASE.jar!/:5.2.2.RELEASE]
    at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:674) ~[spring-jms-5.2.2.RELEASE.jar!/:5.2.2.RELEASE]
    at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:318) ~[spring-jms-5.2.2.RELEASE.jar!/:5.2.2.RELEASE]
    at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:245) ~[spring-jms-5.2.2.RELEASE.jar!/:5.2.2.RELEASE]
    at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1189) ~[spring-jms-5.2.2.RELEASE.jar!/:5.2.2.RELEASE]
    at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1179) ~[spring-jms-5.2.2.RELEASE.jar!/:5.2.2.RELEASE]
    at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:1076) ~[spring-jms-5.2.2.RELEASE.jar!/:5.2.2.RELEASE]
    at java.base/java.lang.Thread.run(Unknown Source) ~[na:na]
    bpm-app ERROR
    March 26th 2021, 11:00:54.106   develop-dev-roscap  Found taskId = 3137 backend DEBUG
    March 26th 2021, 11:01:12.591   develop-dev-roscap  Found taskId = 3137 backend DEBUG
    March 26th 2021, 11:01:14.623   develop-dev-roscap  Found taskId = 3137 backend DEBUG
    March 26th 2021, 11:01:17.329   develop-dev-roscap  Found taskId = 3137 backend DEBUG
March 26th 2021, 11:01:18.662   develop-dev-roscap  Found taskId = 3137 backend DEBUG
    March 26th 2021, 11:01:21.122   develop-dev-roscap  Found taskId = 3137 backend DEBUG
    March 26th 2021, 11:01:23.311   develop-dev-roscap  Found taskId = 3137 backend DEBUG
    March 26th 2021, 11:01:30.346   develop-dev-roscap  Found taskId = 3137 backend DEBUG
    March 26th 2021, 11:01:32.506   develop-dev-roscap  Found taskId = 3137
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=?
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=?   backend DEBUG
    March 26th 2021, 12:16:47.371   develop-dev-roscap  Found taskId = 3137 backend DEBUG
    March 26th 2021, 12:17:03.618   develop-dev-roscap  Found taskId = 3137 backend DEBUG