Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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... 😞
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?
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... 😞