Oracle Metadata not showing

Bug reports
1

Hello i was using Metabase v.37.0.1. there was no problem with Oracle metadata .
And then i update to Metabase v0.38 now my Oracle metadata not showing. I can still query with database but can not show tables.

Pls help .

2

Hi @omerfaruk
Please post “Diagnostic Info” from Admin > Troubleshooting, and the ojdbc8.jar version.
Check the log for details (Admin > Troubleshooting > Logs) during manual sync (Admin > Databases > [your db] > Sync database schemas now).
I’m fairly sure the problem is not with 0.38.0, but with changes to sync in 0.37.2.

3

Updated 38.1 and still no metada.
Diagnostic Info ;

{
  "browser-info": {
    "language": "en-US",
    "platform": "Linux x86_64",
    "userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.10+9",
    "java.vendor": "AdoptOpenJDK",
    "java.vendor.url": "https://adoptopenjdk.net/",
    "java.version": "11.0.10",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.10+9",
    "os.name": "Linux",
    "os.version": "3.10.0-1062.12.1.el7.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "h2",
      "oracle"
    ],
    "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-02-19",
      "tag": "v0.38.0.1",
      "branch": "release-x.38.x",
      "hash": "0635914"
    },
    "settings": {
      "report-timezone": null
    }
  }
}

My logs after trigger the manual syc

   [c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:00:56+03:00 INFO metabase.sync.util STARTING: Sync metadata for oracle Database 2 'msdw'
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:00:56+03:00 INFO metabase.sync.util STARTING: step 'sync-timezone' for oracle Database 2 'msdw'
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:01:05+03:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 10.2 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 6/50 (4 idle, 0 queued) (63 total active threads) Queries in flight: 0 (0 queued)
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:01:05+03:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 19.1 ms (2 DB calls) App DB connections: 0/4 Jetty threads: 6/50 (4 idle, 0 queued) (63 total active threads) Queries in flight: 0 (0 queued)
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:01:05+03:00 DEBUG metabase.server.middleware.log GET /api/database 200 19.2 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (4 idle, 0 queued) (63 total active threads) Queries in flight: 0 (0 queued)
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:01:23+03:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 10.8 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 6/50 (6 idle, 0 queued) (61 total active threads) Queries in flight: 0 (0 queued)
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:01:23+03:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 22.3 ms (2 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (6 idle, 0 queued) (61 total active threads) Queries in flight: 0 (0 queued)
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:01:23+03:00 DEBUG metabase.server.middleware.log GET /api/database 200 21.7 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (6 idle, 0 queued) (61 total active threads) Queries in flight: 0 (0 queued)
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:01:47+03:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 13.2 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 6/50 (5 idle, 0 queued) (60 total active threads) Queries in flight: 0 (0 queued)
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:01:47+03:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 17.0 ms (2 DB calls) App DB connections: 0/4 Jetty threads: 6/50 (5 idle, 0 queued) (60 total active threads) Queries in flight: 0 (0 queued)
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:01:47+03:00 DEBUG metabase.server.middleware.log GET /api/database 200 16.2 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (5 idle, 0 queued) (60 total active threads) Queries in flight: 0 (0 queued)
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:03:00+03:00 INFO metabase.task.sync-databases Starting sync task for Database 2.
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:03:00+03:00 INFO metabase.sync.util STARTING: Analyze data for oracle Database 2 'msdw'
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:03:00+03:00 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for oracle Database 2 'msdw'
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:03:00+03:00 INFO metabase.sync.util FINISHED: step 'fingerprint-fields' for oracle Database 2 'msdw' (1.2 ms)
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:03:00+03:00 INFO metabase.sync.util STARTING: step 'classify-fields' for oracle Database 2 'msdw'
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:03:00+03:00 INFO metabase.sync.util FINISHED: step 'classify-fields' for oracle Database 2 'msdw' (744.2 µs)
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:03:00+03:00 INFO metabase.sync.util STARTING: step 'classify-tables' for oracle Database 2 'msdw'
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:03:00+03:00 INFO metabase.sync.util FINISHED: step 'classify-tables' for oracle Database 2 'msdw' (809.4 µs)
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:03:00+03:00 INFO metabase.sync.util FINISHED: Analyze data for oracle Database 2 'msdw' (26.4 ms)
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:03:16+03:00 INFO metabase.sync.util FINISHED: step 'sync-timezone' for oracle Database 2 'msdw' (2.3 mins)
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:03:16+03:00 INFO metabase.sync.util STARTING: step 'sync-tables' for oracle Database 2 'msdw'
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:03:16+03:00 ERROR metabase.sync.util Error running sync step
java.sql.SQLException: Non supported character set (add orai18n.jar in your classpath): WE8ISO8859P9
	at oracle.sql.CharacterSetUnknown.failCharsetUnknown(CharacterSetFactoryThin.java:233)
	at oracle.sql.CharacterSetUnknown.convert(CharacterSetFactoryThin.java:194)
	at oracle.jdbc.driver.PhysicalConnection.throughDbCharset(PhysicalConnection.java:10365)
	at oracle.jdbc.driver.PhysicalConnection.enquoteIdentifier(PhysicalConnection.java:10442)
	at oracle.jdbc.driver.OracleStatement.enquoteIdentifier(OracleStatement.java:6452)
	at oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:3853)
	at oracle.jdbc.driver.InsensitiveScrollableResultSet.findColumn(InsensitiveScrollableResultSet.java:270)
	at oracle.jdbc.driver.GeneratedResultSet.getString(GeneratedResultSet.java:596)
	at com.mchange.v2.c3p0.impl.NewProxyResultSet.getString(NewProxyResultSet.java:4163)
	at metabase.driver.sql_jdbc.sync.describe_database$all_schemas$fn__77556$fn__77557.invoke(describe_database.clj:21)
	at metabase.driver.sql_jdbc.sync.common$reducible_results$reify__77545$fn__77546.invoke(common.clj:40)
	at clojure.core$repeatedly$fn__6463.invoke(core.clj:5149)
	at clojure.lang.LazySeq.sval(LazySeq.java:42)
	at clojure.lang.LazySeq.seq(LazySeq.java:51)
	at clojure.lang.RT.seq(RT.java:535)
	at clojure.core$seq__5402.invokeStatic(core.clj:137)
	at clojure.core.protocols$seq_reduce.invokeStatic(protocols.clj:24)
	at clojure.core.protocols$fn__8146.invokeStatic(protocols.clj:75)
	at clojure.core.protocols$fn__8146.invoke(protocols.clj:75)
	at clojure.core.protocols$fn__8088$G__8083__8101.invoke(protocols.clj:13)
	at clojure.core$reduce.invokeStatic(core.clj:6828)
	at clojure.core$reduce.invoke(core.clj:6810)
	at metabase.driver.sql_jdbc.sync.common$reducible_results$reify__77545.reduce(common.clj:35)
	at clojure.core$transduce.invokeStatic(core.clj:6883)
	at clojure.core.Eduction.reduce(core.clj:7682)
	at clojure.core$transduce.invokeStatic(core.clj:6883)
	at clojure.core.Eduction.reduce(core.clj:7682)
	at clojure.core$reduce.invokeStatic(core.clj:6827)
	at clojure.core$into.invokeStatic(core.clj:6895)
	at clojure.core$into.invoke(core.clj:6887)
	at metabase.driver.sql_jdbc.sync.describe_database$describe_database$fn__77602.invoke(describe_database.clj:122)
	at metabase.driver.sql_jdbc.sync.describe_database$describe_database.invokeStatic(describe_database.clj:117)
	at metabase.driver.sql_jdbc.sync.describe_database$describe_database.invoke(describe_database.clj:114)
	at metabase.driver.sql_jdbc$fn__78971.invokeStatic(sql_jdbc.clj:62)
	at metabase.driver.sql_jdbc$fn__78971.invoke(sql_jdbc.clj:60)
	at clojure.lang.MultiFn.invoke(MultiFn.java:234)
	at metabase.sync.fetch_metadata$fn__59847$db_metadata__59852$fn__59853.invoke(fetch_metadata.clj:13)
	at metabase.sync.fetch_metadata$fn__59847$db_metadata__59852.invoke(fetch_metadata.clj:10)
	at metabase.sync.sync_metadata.tables$fn__61273$db_metadata__61278$fn__61279.invoke(tables.clj:143)
	at metabase.sync.sync_metadata.tables$fn__61273$db_metadata__61278.invoke(tables.clj:140)
	at metabase.sync.sync_metadata.tables$fn__61334$sync_tables_BANG___61339$fn__61340.invoke(tables.clj:160)
	at metabase.sync.sync_metadata.tables$fn__61334$sync_tables_BANG___61339.invoke(tables.clj:155)
	at metabase.sync.util$fn__39372$run_step_with_metadata__39377$fn__39381$fn__39383.invoke(util.clj:342)
	at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:99)
	at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:93)
	at metabase.sync.util$with_start_and_finish_debug_logging.invokeStatic(util.clj:116)
	at metabase.sync.util$with_start_and_finish_debug_logging.invoke(util.clj:113)
	at metabase.sync.util$fn__39372$run_step_with_metadata__39377$fn__39381.invoke(util.clj:339)
	at metabase.sync.util$fn__39372$run_step_with_metadata__39377.invoke(util.clj:334)
	at metabase.sync.util$fn__39564$run_sync_operation__39569$fn__39570$fn__39571.invoke(util.clj:427)
	at clojure.core$mapv$fn__8445.invoke(core.clj:6912)
	at clojure.lang.PersistentVector.reduce(PersistentVector.java:343)
	at clojure.core$reduce.invokeStatic(core.clj:6827)
	at clojure.core$mapv.invokeStatic(core.clj:6903)
	at clojure.core$mapv.invoke(core.clj:6903)
	at metabase.sync.util$fn__39564$run_sync_operation__39569$fn__39570.invoke(util.clj:427)
	at metabase.sync.util$fn__39564$run_sync_operation__39569.invoke(util.clj:421)
	at metabase.sync.sync_metadata$fn__61387$sync_db_metadata_BANG___61392$fn__61393$fn__61394.invoke(sync_metadata.clj:49)
	at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:146)
	at metabase.sync.util$do_with_error_handling.invoke(util.clj:139)
	at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:142)
	at metabase.sync.util$do_with_error_handling.invoke(util.clj:139)
	at clojure.core$partial$fn__5839.invoke(core.clj:2623)
	at metabase.driver$fn__29100.invokeStatic(driver.clj:527)
	at metabase.driver$fn__29100.invoke(driver.clj:527)
	at clojure.lang.MultiFn.invoke(MultiFn.java:239)
	at metabase.sync.util$sync_in_context$fn__39284.invoke(util.clj:135)
	at metabase.sync.util$with_db_logging_disabled$fn__39281.invoke(util.clj:126)
	at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:99)
	at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:93)
	at metabase.sync.util$with_start_and_finish_logging$fn__39270.invoke(util.clj:111)
	at metabase.sync.util$with_sync_events$fn__39265.invoke(util.clj:85)
	at metabase.sync.util$with_duplicate_ops_prevented$fn__39256.invoke(util.clj:64)
	at metabase.sync.util$do_sync_operation.invokeStatic(util.clj:161)
	at metabase.sync.util$do_sync_operation.invoke(util.clj:158)
	at metabase.sync.sync_metadata$fn__61387$sync_db_metadata_BANG___61392$fn__61393.invoke(sync_metadata.clj:48)
	at metabase.sync.sync_metadata$fn__61387$sync_db_metadata_BANG___61392.invoke(sync_metadata.clj:45)
	at metabase.api.database$fn__62177$fn__62179.invoke(database.clj:621)
	at clojure.core$binding_conveyor_fn$fn__5754.invoke(core.clj:2030)
	at clojure.lang.AFn.call(AFn.java:18)
	at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.base/java.lang.Thread.run(Unknown Source)
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:03:16+03:00 INFO metabase.sync.util FINISHED: Sync metadata for oracle Database 2 'msdw' (2.3 mins)
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:03:16+03:00 INFO metabase.sync.util STARTING: Analyze data for oracle Database 2 'msdw'
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:03:16+03:00 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for oracle Database 2 'msdw'
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:03:16+03:00 INFO metabase.sync.util FINISHED: step 'fingerprint-fields' for oracle Database 2 'msdw' (952.6 µs)
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:03:16+03:00 INFO metabase.sync.util STARTING: step 'classify-fields' for oracle Database 2 'msdw'
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:03:16+03:00 INFO metabase.sync.util FINISHED: step 'classify-fields' for oracle Database 2 'msdw' (741.8 µs)
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:03:16+03:00 INFO metabase.sync.util STARTING: step 'classify-tables' for oracle Database 2 'msdw'
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:03:16+03:00 INFO metabase.sync.util FINISHED: step 'classify-tables' for oracle Database 2 'msdw' (768.2 µs)
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:03:16+03:00 INFO metabase.sync.util FINISHED: Analyze data for oracle Database 2 'msdw' (23.7 ms)
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:03:46+03:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 8.7 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 6/50 (4 idle, 0 queued) (59 total active threads) Queries in flight: 0 (0 queued)
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:03:46+03:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 22.5 ms (2 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (4 idle, 0 queued) (59 total active threads) Queries in flight: 0 (0 queued)
[c35771e9-5156-4650-ad9c-fbcb8b99ab8e] 2021-02-22T15:03:46+03:00 DEBUG metabase.server.middleware.log GET /api/database 200 21.1 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (4 idle, 0 queued) (59 total active threads) Queries in flight: 0 (0 queued)
4

@omerfaruk We haven’t released 0.38.1 yet, only 0.38.0.1 which was a hotfix for a specific issue.

  1. Which version of ojdbc8.jar are you using?
  2. Which version of Oracle Server?
  3. Which character set is your database using?

The logs indicates that it’s an international character issue, where you need to also add orai18n.jar.

You should migrate away from H2 if you’re using Metabase in production:
https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html

5

where should i add orai18n ? is it should be same with the ojdbc8.jar . i mean in /plugins ?

ok i add the orai18n file into /plugins directory and my problem is solved. thanks.