Email sending errors when dashboard is displaying

mvtemple · October 25, 2021, 1:42pm

Hi -

My email subscription is showing an error, but the dashboard is working fine. What should I do?

flamber · October 25, 2021, 1:52pm

Post "Diagnostic Info" from Admin > Troubleshooting.
Post the detailed error stacktrace from Admin > Troubleshooting > Logs.

mvtemple · October 25, 2021, 2:11pm

{
  "browser-info": {
    "language": "en-US",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.81 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.12+7",
    "java.vendor": "Eclipse Foundation",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "11.0.12",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.12+7",
    "os.name": "Linux",
    "os.version": "4.14.219-164.354.amzn2.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "h2",
      "snowflake"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "11.9"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.18"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2021-09-21",
      "tag": "v1.40.5",
      "branch": "release-x.40.x",
      "hash": "042a36e"
    },
    "settings": {
      "report-timezone": "America/New_York"
    }
  }
}

mvtemple · October 25, 2021, 6:50pm

Hi @flamber, how do I find the detailed error message in the logs?

flamber · October 25, 2021, 6:54pm

@mvtemple Reproduce the problem - and then check the logs. The newest logs are at the bottom.

mvtemple · October 25, 2021, 7:09pm

@flamber Ok, it's working now, but I noticed that I have timestamps in the dashboard that are only displaying as dates in the email:

Why is that? Is that fixable?

flamber · October 25, 2021, 7:15pm

@mvtemple There's a lot of changes to Subscription/Pulse formatting in 1.41:
https://www.metabase.com/blog/Metabase-0.41/index.html
If you're using Metabase Cloud, then you'll be upgraded this week.

mvtemple · October 28, 2021, 1:16pm

@flamber Hi! So I'm still getting these errors with my dashboard subscription - Based on the log, I think it's due to permission errors:

If I can see the dashboard, shouldn't I be able to schedule the subscription? I can "send now" just fine.

I prevent users querying some of these tables for sensitive information, but want to be able to schedule what's in the dashboard

flamber · October 28, 2021, 1:24pm

@mvtemple Okay, then you're seeing this issue:
https://github.com/metabase/metabase/issues/18009 - upvote by clicking on the first post