Error when clicking into individual ID in collection

Hi there,

Our Metabase is connected to our MongoDB. Usually, clicking on the primary key of a table in Metabase opens up the individual document with all its associated fields. Now I'm getting an error when clicking into a specific id in a specific collection. Upon checking the logs, I find this error message: invalid hexadecimal representation of an ObjectId. I only face this error on one specific collection, and also I am able to filter with a native query (e.g., "$match":{"_id":ObjectId("XYZ")}). Does anyone know what's going on here? Clicking into the id in the table yields a blank screen.

Any help will be appreciated, thank you!

Hi @mtans68
Please post "Diagnostic Info" from Admin > Troubleshooting.
The error seems similar to this issue, but I cannot reproduce the blank screen:
https://github.com/metabase/metabase/issues/15801 - upvote by clicking :+1: on the first post

1 Like

Thank you, my diagnostic info is here. The error persists today and is only applicable to a single collection. I've checked the IDs offline and there're no duplicates or empty ID strings.

    {
      "browser-info": {
        "language": "en-sg",
        "platform": "MacIntel",
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.1.2 Safari/605.1.15",
        "vendor": "Apple Computer, Inc."
      },
      "system-info": {
        "file.encoding": "UTF-8",
        "java.runtime.name": "OpenJDK Runtime Environment",
        "java.runtime.version": "11.0.11+9-Ubuntu-0ubuntu2.18.04",
        "java.vendor": "Ubuntu",
        "java.vendor.url": "https://ubuntu.com/",
        "java.version": "11.0.11",
        "java.vm.name": "OpenJDK 64-Bit Server VM",
        "java.vm.version": "11.0.11+9-Ubuntu-0ubuntu2.18.04",
        "os.name": "Linux",
        "os.version": "4.15.0-66-generic",
        "user.language": "en",
        "user.timezone": "Etc/UTC"
      },
      "metabase-info": {
        "databases": [
          "mongo",
          "h2",
          "googleanalytics",
          "postgres"
        ],
        "hosting-env": "unknown",
        "application-database": "h2",
        "application-database-details": {
          "database": {
            "name": "H2",
            "version": "1.4.197 (2018-03-18)"
          },
          "jdbc-driver": {
            "name": "H2 JDBC Driver",
            "version": "1.4.197 (2018-03-18)"
          }
        },
        "run-mode": "prod",
        "version": {
          "date": "2021-04-27",
          "tag": "v0.39.1",
          "branch": "release-x.39.x",
          "hash": "6beba48"
        },
        "settings": {
          "report-timezone": "Asia/Kuala_Lumpur"
        }
      }
    }

@mtans68 I cannot reproduce on the latest release: https://github.com/metabase/metabase/releases/latest