Casting and field filters

Get Help
1

Hi everybody!
I am fairly new to Metabase.
I am experiencing this issue: I have to apply a field filter on time in a column from a view in an Oracle db and I have no direct access to this db. This column is casted as a Temporal from the admin panel, nonetheless the values are shown as a timestamp ( like this 20220916154816 )and I cannot filter on time because of this error (which is obvious given the situation):

Missing IN or OUT parameter at index::

I obviously cannot filter on a casted column from a select clause, because field filters, from what I understood, can be applied only on an existing column.

Are there any other ways to handle this problem?

Thank you all and sorry for my bad english!

frav

2

Hi @frav
Post "Diagnostic Info" from Admin > Troubleshooting.
And the ojdbc version you're using: https://www.metabase.com/docs/latest/databases/connections/oracle

3

Hi @flamber.
These are my diagnostic info:

{
  "browser-info": {
    "language": "it-IT",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.5112.102 Safari/537.36 OPR/90.0.4480.100 (Edition std-1)",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.16+8-LTS",
    "java.vendor": "Red Hat, Inc.",
    "java.vendor.url": "https://www.redhat.com/",
    "java.version": "11.0.16",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.16+8-LTS",
    "os.name": "Linux",
    "os.version": "3.10.0-1160.59.1.el7.x86_64",
    "user.language": "en",
    "user.timezone": "Europe/Rome"
  },
  "metabase-info": {
    "databases": [
      "sqlserver",
      "csv",
      "oracle",
      "h2"
    ],
    "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": "2022-08-31",
      "tag": "v0.44.2",
      "branch": "release-x.44.x",
      "hash": "8d9de8a"
    },
    "settings": {
      "report-timezone": "Europe/Berlin"
    }
  }
}

Regarding the ojdbc version, I have no direct access to this db.

4

@frav I'm not asking for direct access to the database, I'm asking explicitly about which ojdbc file (the version, checksum) you have downloaded, since that is the only way to get Oracle to work.

Unrelated, migrate away from H2 if you're using Metabase in production:
https://www.metabase.com/docs/latest/installation-and-operation/migrating-from-h2

5

Since I have no direct access to anything, I can't find the ojdbc version, because I can't reach the file.

6

@frav Then contact whoever is managing your Metabase instance and ask them for help.