topic Re: Qlik Alerting - Row Limit for triggering an alert in Reporting Service & Alerting

Qlik Alerting - Row Limit for triggering an alert

Timotix — Wed, 29 Jan 2025 15:57:23 GMT

Hello all,

i have a problem triggering an alert with more than 10k rows.
When selecting a filter to limit the rows <10k the alert will trigger and is sending out a mail.
But with a filter selecting more than >10k rows (or no filter at all) nothing is happening.

I am aware of the warning while editing the alert. But is there a general row limit for alerting?

Thank you!
Timo

Re: Qlik Alerting - Row Limit for triggering an alert

Timotix — Wed, 16 Feb 2022 12:15:41 GMT

After searching a little bit in the logs i could find following error when executing an alert >10k rows:

20220216T130923.774+0100 eagle 1.0.12 Global ERROR {"stack":"MongoError: document is larger than the maximum size 16777216\n at Function.create (...),"message":"document is larger than the maximum size 16777216","driver":true,"name":"MongoError"}

Is there a way to size up the limits?

Re: Qlik Alerting - Row Limit for triggering an alert

Timotix — Tue, 22 Feb 2022 12:27:01 GMT

After investigating a little bit more I found a solution to this error.
The 'Drill to dimension' I chose was a long string file with multiple information. (e.g. 0515413616_Test_Product_10x20 example_...) After changing to a smaller field without characters the alert was able to trigger and send an alertmail. The dimension has roundabout 100k distinct values and 40k got triggered.

Are these limits known to qlik. For us this will be a limitation in the future... 😞