Metabase version: v1.50.23
Starting on August 29th certain subscriptions display the header but do not include data in the notification that is sent to Slack. See example below.
Clicking on the link takes you to the dashboard where there is data available.
Not all subscriptions are affected and recreating the subscription did not help.
Upon further investigation we noticed that if we removed a a field payload that contains json from the results then the subscription works as expected. Furthermore, performing a force cast to string also works as well as left(payload,20)::string.
Grabbing logs from metabase I can see a bunch of warnings related to the field payload.
[c91761b5-4581-4820-9adc-6f7d096fe55e] 2024-09-04T13:07:28+02:00 WARN metabase.sync.util Error generating fingerprint for Field ''PAYLOAD'',java.time.format.DateTimeParseException: Text '{, "application_id": "XXXX",, "category": "XXXXX",, "ins...' could not be parsed, unparsed text found at index 0, at java.base/java.time.format.DateTimeFormatter.parseResolved0(Unknown Source), at java.base/java.time.format.DateTimeFormatter.parse(Unknown Source), at metabase.util.date_2.parse$parse_with_formatter.invokeStatic(parse.clj:69), at metabase.util.date_2.parse$parse_with_formatter.invoke(parse.clj:61), at metabase.util.date_2.parse$parse.invokeStatic(parse.clj:150), at metabase.util.date_2.parse$parse.invoke(parse.clj:146), at metabase.util.date_2$parse.invokeStatic(date_2.clj:47), at metabase.util.date_2$parse.invoke(date_2.clj:42), at metabase.analyze.fingerprint.fingerprinters$fn__59959.invokeStatic(fingerprinters.clj:196), at metabase.analyze.fingerprint.fingerprinters$fn__59959.invoke(fingerprinters.clj:194), at metabase.analyze.fingerprint.fingerprinters$fn__59946$G__59941__59951.invoke