SAS® Visual Investigator flows are stuck in a pending state when running the Alert Generation Process (AGP)


When generating the alerts and publishing SAS Visual Investigator scenario flow, the overall status is completed. However, the sub-component of the Save Alerting Events flow enters a pending state and, in some of the scenarios, the flow is never completed. As a result, the alerts are not generated, and the following error occurs:

--- [TaskExecutor-10] c.s.f.t.s.ReplicatedObjectService : sas.svi-alert [3ad89e50c2c335d4] Replicated object already found in database. Keeping the old one. Entity Type Name:xxxx

Save an alerting event data batch

Note: This issue occurs because the RabbitMQ queues are stuck.

Workaround

To circumvent this issue, complete the following steps:

  1. Stop the alert service on any running servers by issuing the following command:

    $ sudo systemctl stop sas-viya-svi-alert-default

  2. Log on to the RabbitMQ admin user interface (UI).
  3. Find the following queues on the Queues tab and click the purge button:
    • AlertingDataNestedQueue
    • AlertingDataFlatQueue
    • AlertGenerationQueue
    • ReplicationQueue
    • WorkspaceGenerationQueue
  4. Start the alert service by issuing the following command:

    sudo systemctl start sas-viya-svi-alert-default