PowerProtect Data Manager | SQL database assets removed from Policy

Сводка: PowerProtect Data Manager (PPDM) SQL asset backups are automatically removed from policy. The customer has to manually add the assets back for the backups to happen again.

Данная статья применяется к Данная статья не применяется к Эта статья не привязана к какому-либо конкретному продукту. В этой статье указаны не все версии продуктов.
Ознакомьтесь с другими ресурсами

Симптомы

Assets are count for SQL protection policy is set to 0.

CBS Logs show the unassignment calls:
  
2023-01-29T17:10:12.395Z INFO [] [https-jsse-nio-127.0.0.1-8445-exec-47] [][][][TRACE_ID:b5badb32fb0ec1fb][] [c.e.b.c.f.RestLogFilter.doFilter(43)] - Enter RESTful Msg - Method: POST , Path: https://localhost:8443/api/v2/protection-policies/aff733d6-280a-4d2c-a3bb-053ad35ee832/asset-unassignments 2023-01-29T17:10:12.398Z INFO [] [https-jsse-nio-127.0.0.1-8445-exec-47] [][][][TRACE_ID:b5badb32fb0ec1fb][]

SQL policy screen 1
 




SQL policy screen 2
 

Причина

This issue appears to be caused by SQL server, or services become unavailable. When asset discovery runs, it marks these missing (unavailable) assets as deleted.
  
253788:2023-02-23T21:22:00.607Z INFO [] [notificationActorSystem-akka.actor.default-dispatcher-6855] [][][][][] [c.e.d.e.a.s.h.AssetActorHandler.isDeletedinHostAndGcedInEs(937)] -  Asset with natural ids: [R019PxRr0ARm7gH27_QFHrp4CngOz8IrRhpofRD0vyvM8k=] is either in deleted State or deleted/Not detected/GCed from ES. So skipping the discovery processing for this asset.
253789:2023-02-23T21:22:00.610Z INFO [] [notificationActorSystem-akka.actor.default-dispatcher-6855] [][][][][] [c.e.d.e.a.s.h.AssetActorHandler.isDeletedinHostAndGcedInEs(937)] -  Asset with natural ids: [R01KjoOTC-IRlrJVZeOyqeLBqKVMKor_3nQXpRJ9YOnJ8k=] is either in deleted State or deleted/Not detected/GCed from ES. So skipping the discovery processing for this asset.


Разрешение

This issue has been fixed in build 19.13.x onwards. If the SQL services are down and discovery happens before SQL databases are available, the assets are marked as "not detected" instead of "deleted."

In v19.13, since databases are not marked as "deleted" they are not removed from the policy.
Свойства статьи
Номер статьи: 000212443
Тип статьи: Solution
Последнее изменение: 02 Jun 2023
Версия:  2
Получите ответы на свои вопросы от других пользователей Dell
Услуги технической поддержки
Проверьте, распространяются ли на ваше устройство услуги технической поддержки.