ededevvds

Natalia, [06.06.2025 18:05]
Для удаления данных по файлам/документам с тестового стенда необходимо:

1. Выключить pod-ы ФК

2. Очистить содержимое таблиц в БД, выполнив скрипты:
delete from audit_event;
delete from asc_x5archive_document;
delete from asc_x5archive_document_files;
delete from dq_messages;
delete from source_bw_load_request;
delete from source_bw_load_task;
delete from source_dmp_load_request;
delete from source_dmp_load_task;
delete from source_opentext_load_tasks;
delete from source_oracle_load_tasks_oracle_uzdo;
delete from source_oracle_load_tasks_oracle_vgo;
delete from common_revise;
delete from common_revise_task;

3. В кафке "extkafka" очистить следующие топики:
- delay-queue-in
- docs-in
- files-in  
- reference-in
- event-log

4. Включить pod-ы ФК

Natalia, [06.06.2025 18:05]
Очистка и повторное наполнение справочников, интегрированных с MDM (Деловые партнеры/страны)

1. Очистить содержимое таблиц справочников в БД, выполнив скрипты:
DELETE FROM asc_x5archive_business_partner_address_history;
DELETE FROM asc_x5archive_business_partner_address;
DELETE FROM asc_x5archive_business_partner_counterparty_group;
DELETE FROM asc_x5archive_business_partner_kpp_history;
DELETE FROM asc_x5archive_business_partner_kpp_largest_taxpayer_history;
DELETE FROM asc_x5archive_business_partner_kpp;
DELETE FROM asc_x5archive_business_partner_name_history;
DELETE FROM asc_x5archive_business_partner_name;
DELETE FROM asc_x5archive_business_partner;
DELETE FROM asc_x5archive_country;

2. Запросить инициировать выгрузку сначала Стран, потом Деловых партнеров для стенда TEST

3. Дождаться наполнения справочников (Журнал событий, сами справочники)

Natalia, [06.06.2025 18:06]
Очистка справочников, автопополняемых при загрузке получаемых из источника данных

1. Очистить содержимое таблиц справочников в БД, выполнив скрипты:
DELETE FROM asc_x5archive_counterparty_account_group_buyers;
DELETE FROM asc_x5archive_counterparty_account_group_sellers;
DELETE FROM asc_x5archive_erp_account;
DELETE FROM asc_x5archive_financial_disposition_group;
DELETE FROM asc_x5archive_metadata_assembly_algorithm;
DELETE FROM asc_x5archive_metadata_source_table_erp;
DELETE FROM asc_x5archive_order_type_mm;
DELETE FROM asc_x5archive_order_type_sd;
DELETE FROM asc_x5archive_project_type;
DELETE FROM asc_x5archive_source_doc_type;
DELETE FROM asc_x5archive_source_edi_status;
DELETE FROM asc_x5archive_source_status;
DELETE FROM asc_x5archive_mvz;
DELETE FROM asc_x5archive_spp;
DELETE FROM asc_x5archive_store_erp;
DELETE FROM asc_x5archive_tax_ledger_code_erp;