Metabase DB Scan: Error fingerprinting Table

Get Help
1

I am seeing errors from my Metabase service and Postgres DB around fingerprinting a number of tables. Unfortunately, the error message is quite large. It appears to be an issue with storing a null value in a timestamp field. An abbreviated version:

"clojure.lang.ExceptionInfo: Error executing query: ERROR: invalid input syntax for type timestamp: "" {:driver :postgres, :sql ["-- Metabase" "SELECT" "  \"source\".\"substring36118536\"
...
, :type :invalid-query}"

The full stack trace is quite long, if I can share part that would be helpful let me know. When this error happens, I see the following parallel error on my postgresql db:

[1-1] db=my_db,user=metabase_ro ERROR:  invalid input syntax for type timestamp: ""

I see similar on our database for our date type, which we allow null values for:

invalid input syntax for type date: ""

I see similar errors on my database coming from trying to read a json object as bigint:

invalid input syntax for type bigint: "{"id":"1234","system":"PHONE","use":"HOME","value":"+1234236","isPrimary":true,"isAssociatedWithAuth0User":false,"hasAssociatedAuthoUserLoggedIn":false,"notes":"","createdAt":"2023-08-16T19:45:43Z","notify":true}"

As well as a lot of spam of the following errors:

ERROR: could not determine data type of parameter $1

and

ERROR:  unsupported Unicode escape sequence

Is there anything I can do to help these get fingerprinted accurately and stop erroring? We have a lot of databases hooked up, so if I can do via API even better.

Here is my general info:

{
  "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/122.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.22+7",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "11.0.22",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.22+7",
    "os.name": "Linux",
    "os.version": "4.4.0",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "postgres",
      "h2"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "15.5"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.6.0"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2024-03-04",
      "tag": "v0.48.8",
      "hash": "a900c85"
    },
    "settings": {
      "report-timezone": null
    }
  }
}
2

disable the json parsing in the settings

3

Hi Luiggi,

This seems to have resolved most of these errors for me! Thank you! I am still, unfortuantely, seeing an error around date fields, which we allow to be null in postgres:

invalid input syntax for type date: ""

Any advice?

Thanks,
Gus