Alerts needed for failure of the Quali.db updating the QualIInsight.db

Hi @Richard Hill, sorry for the delay, can you please explain what type of update fails – on nightly, on reserve, etc? did you open a ticket about it? if not - please do,

Gilat

This was entered as ticket #45111 opened on 5/26/2021 and closed on 6/17/2021
It was originally assumed to be another of the many Sisense issues we have had over the years but it turned out to be an intermittent bug that occurred after a Schema change back in 9.3. which was fixed in patch6, The defect is that the Quali.DB suddenly fails to update the QualIInsight.DB. and once this failure occurs, it does not self-correct over time.
We applied patch6 and then also found that the 9.3P6 upgrade is different from the previous ones in that it does not CALL the configuration applets when it does configuration, so we had to run the QualiConfig applet afterwards.

Due to the fact that we had assumed a Sisense issue at first, we had created new databases (after renaming the originals to no avail), and that was the last piece of fixing the issue as we had to re-associate the Elasticube to the correct databases.

This request is that additional code be added in the next patch for 9.3 as well as your current releases so that a nightly check on Quali background processes is done so that if any of the below occur, an alert is generated and sent to the admin accounts in Quali and Sisense and if a SQL process is involved, that the error be written to the log file of the running SQL process. This would not actually fix anything but would give next-day awareness, at the wors,t instead of discovering (in the case of my ticket) it days or weeks after the failure. This would provide greater awareness failures in the Quali data collection and presentation into Insight.

* "QualiInsight.db" (or whatever name has been assigned/changed) is not updated from the "Quali.db" (or whatever name has been assigned/changed)

* Elasticube rebuild fails to complete at any scheduled rebuild

* Elasticube cannot link to the QualiInsight.db (or whatever name has been assigned/changed)

It would also be great to have a process where the Elasticubes of record and the three SQL databases were backed up nightly or weekly automatically - but this is if lessor importance.

Thank you