Oracle Tables not getting listed in Metabase

mkhatib · March 4, 2020, 10:54am

I was trying to generate some reports using oracle database but I could see a issues while importing tables however I can write custom query using sql.

So is there solution for this issues ?

flamber · March 4, 2020, 10:57am

Hi @mkhatib
If you see any issues/errors, while importing, then post those. Admin > Troubleshooting > Logs
Please include Admin > Troubleshooting > Diagnostic Info
And the version of your ojdbc driver.

mkhatib · March 4, 2020, 11:31am

[632c4d62-cc81-4c73-94ea-8cf486a6ab18] 2020-03-04T14:00:00+03:00 INFO metabase.sync.util FINISHED: Sync metadata for oracle Database 35 ‘SRA_STAGE’ (76.8 ms) [632c4d62-cc81-4c73-94ea-8cf486a6ab18] 2020-03-04T14:00:00+03:00 INFO metabase.sync.util STARTING: Sync metadata for oracle Database 37 ‘Usr2’ [632c4d62-cc81-4c73-94ea-8cf486a6ab18] 2020-03-04T14:00:00+03:00 INFO metabase.sync.util STARTING: step ‘sync-timezone’ for oracle Database 37 ‘Usr2’ [632c4d62-cc81-4c73-94ea-8cf486a6ab18] 2020-03-04T14:00:00+03:00 INFO metabase.sync.util FINISHED: step ‘sync-timezone’ for oracle Database 37 ‘Usr2’ (40.0 ms) [632c4d62-cc81-4c73-94ea-8cf486a6ab18] 2020-03-04T14:00:00+03:00 INFO metabase.sync.util STARTING: step ‘sync-tables’ for oracle Database 37 ‘Usr2’ [632c4d62-cc81-4c73-94ea-8cf486a6ab18] 2020-03-04T14:00:00+03:00 ERROR metabase.sync.util Error running sync step: ORA-00942: table or view does not exist (“oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)” “oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)” “oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)” “oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)” “oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)” “oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)” “oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)” “oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37)” “oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733)” “oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)” “oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)” “oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1276)” “oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:366)” “oracle.jdbc.OracleDatabaseMetaData.getSchemas(OracleDatabaseMetaData.java:2752)” “com.mchange.v2.c3p0.impl.NewProxyDatabaseMetaData.getSchemas(NewProxyDatabaseMetaData.java:3062)” “–> driver.sql_jdbc.sync$fast_active_tables.invokeStatic(sync.clj:104)” “driver.sql_jdbc.sync$fast_active_tables.doInvoke(sync.clj:96)” “driver.sql_jdbc.sync$fn__69422.invokeStatic(sync.clj:35)” “driver.sql_jdbc.sync$fn__69422.invoke(sync.clj:34)” “driver.sql_jdbc.sync$describe_database.invokeStatic(sync.clj:191)” “driver.sql_jdbc.sync$describe_database.invoke(sync.clj:187)” “driver.sql_jdbc$fn__71320.invokeStatic(sql_jdbc.clj:57)” “driver.sql_jdbc$fn__71320.invoke(sql_jdbc.clj:55)” “sync.fetch_metadata$fn__51814$db_metadata__51819$fn__51820.invoke(fetch_metadata.clj:13)” “sync.fetch_metadata$fn__51814$db_metadata__51819.invoke(fetch_metadata.clj:10)” “sync.sync_metadata.tables$fn__53283$db_metadata__53288$fn__53289.invoke(tables.clj:146)” “sync.sync_metadata.tables$fn__53283$db_metadata__53288.invoke(tables.clj:143)” “sync.sync_metadata.tables$fn__53344$sync_tables_BANG___53349$fn__53350.invoke(tables.clj:163)” “sync.sync_metadata.tables$fn__53344$sync_tables_BANG___53349.invoke(tables.clj:158)” “sync.util$fn__43704$run_step_with_metadata__43709$fn__43713$fn__43715.invoke(util.clj:347)” “sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:102)” “sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:96)” “sync.util$with_start_and_finish_debug_logging.invokeStatic(util.clj:119)” “sync.util$with_start_and_finish_debug_logging.invoke(util.clj:116)” “sync.util$fn__43704$run_step_with_metadata__43709$fn__43713.invoke(util.clj:344)” “sync.util$fn__43704$run_step_with_metadata__43709.invoke(util.clj:339)” “sync.util$fn__43896$run_sync_operation__43901$fn__43902$fn__43903.invoke(util.clj:432)” “sync.util$fn__43896$run_sync_operation__43901$fn__43902.invoke(util.clj:432)” “sync.util$fn__43896$run_sync_operation__43901.invoke(util.clj:426)” “sync.sync_metadata$fn__53397$sync_db_metadata_BANG___53402$fn__53403$fn__53404.invoke(sync_metadata.clj:51)” “sync.util$do_with_error_handling.invokeStatic(util.clj:147)” “sync.util$do_with_error_handling.invoke(util.clj:142)” “sync.util$do_with_error_handling.invokeStatic(util.clj:145)” “sync.util$do_with_error_handling.invoke(util.clj:142)” “driver$fn__22274.invokeStatic(driver.clj:524)” “driver$fn__22274.invoke(driver.clj:524)” “sync.util$sync_in_context$fn__43615.invoke(util.clj:138)” “sync.util$with_db_logging_disabled$fn__43612.invoke(util.clj:129)” “sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:102)” “sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:96)” “sync.util$with_start_and_finish_logging$fn__43601.invoke(util.clj:114)” “sync.util$with_sync_events$fn__43596.invoke(util.clj:88)” “sync.util$with_duplicate_ops_prevented$fn__43587.invoke(util.clj:67)” “sync.util$do_sync_operation.invokeStatic(util.clj:166)” “sync.util$do_sync_operation.invoke(util.clj:163)” “sync.sync_metadata$fn__53397$sync_db_metadata_BANG___53402$fn__53403.invoke(sync_metadata.clj:50)” “sync.sync_metadata$fn__53397$sync_db_metadata_BANG___53402.invoke(sync_metadata.clj:47)” “task.sync_databases.SyncAndAnalyzeDatabase.execute(sync_databases.clj:39)”) [632c4d62-cc81-4c73-94ea-8cf486a6ab18] 2020-03-04T14:00:00+03:00 INFO metabase.sync.util FINISHED: Sync metadata for oracle Database 37 ‘Usr2’ (112.3 ms) [632c4d62-cc81-4c73-94ea-8cf486a6ab18] 2020-03-04T14:00:00+03:00 INFO metabase.sync.util STARTING: Analyze data for oracle Database 37 ‘Usr2’ [632c4d62-cc81-4c73-94ea-8cf486a6ab18] 2020-03-04T14:00:00+03:00 INFO metabase.sync.util FINISHED: step ‘classify-fields’ for oracle Database 37 ‘Usr2’ (37.0 µs) [632c4d62-cc81-4c73-94ea-8cf486a6ab18] 2020-03-04T14:00:00+03:00 INFO metabase.sync.util FINISHED: step ‘classify-tables’ for oracle Database 37 ‘Usr2’ (36.2 µs) [632c4d62-cc81-4c73-94ea-8cf486a6ab18] 2020-03-04T14:00:00+03:00 INFO metabase.sync.util FINISHED: step ‘fingerprint-fields’ for oracle Database 37 ‘Usr2’ (95.8 µs) [632c4d62-cc81-4c73-94ea-8cf486a6ab18] 2020-03-04T14:00:00+03:00 INFO metabase.sync.util STARTING: step ‘classify-fields’ for oracle Database 37 ‘Usr2’ [632c4d62-cc81-4c73-94ea-8cf486a6ab18] 2020-03-04T14:00:00+03:00 INFO metabase.sync.util STARTING: step ‘classify-tables’ for oracle Database 37 ‘Usr2’ [632c4d62-cc81-4c73-94ea-8cf486a6ab18] 2020-03-04T14:00:00+03:00 INFO metabase.sync.util STARTING: step ‘fingerprint-fields’ for oracle Database 37 ‘Usr2’ [632c4d62-cc81-4c73-94ea-8cf486a6ab18] 2020-03-04T14:00:00+03:00 INFO metabase.sync.util FINISHED: Analyze data for oracle Database 37 ‘Usr2’ (12.8 ms) [632c4d62-cc81-4c73-94ea-8cf486a6ab18] 2020-03-04T14:11:31+03:00 DEBUG metabase.middleware.log GET /api/database/40/schemas 200 38.4 ms (5 DB calls) Jetty threads: 5/50 (2 idle, 0 queued) (129 total active threads) Queries in flight: 0 [632c4d62-cc81-4c73-94ea-8cf486a6ab18] 2020-03-04T14:11:31+03:00 DEBUG metabase.middleware.log GET /api/database/40/metadata 200 11.5 ms (4 DB calls) Jetty threads: 5/50 (2 idle, 0 queued) (129 total active threads) Queries in flight: 0 [632c4d62-cc81-4c73-94ea-8cf486a6ab18] 2020-03-04T14:11:48+03:00 DEBUG metabase.middleware.log GET /api/session/properties 200 15.8 ms (1 DB calls) Jetty threads: 6/50 (1 idle, 0 queued) (129 total active threads) Queries in flight: 0 [632c4d62-cc81-4c73-94ea-8cf486a6ab18] 2020-03-04T14:11:48+03:00 DEBUG metabase.middleware.log GET /api/setup/admin_checklist 200 22.5 ms (11 DB calls) Jetty threads: 5/50 (1 idle, 0 queued) (129 total active threads) Queries in flight: 0 [632c4d62-cc81-4c73-94ea-8cf486a6ab18] 2020-03-04T14:11:48+03:00 DEBUG metabase.middleware.log GET /api/setting 200 1.4 ms (0 DB calls) Jetty threads: 5/50 (1 idle, 0 queued) (129 total active threads) Queries in flight: 0 [632c4d62-cc81-4c73-94ea-8cf486a6ab18] 2020-03-04T14:11:53+03:00 DEBUG metabase.middleware.log GET /api/util/bug_report_details 200 28.4 ms (1 DB calls) Jetty threads: 5/50 (1 idle, 0 queued) (129 total active threads) Queries in flight: 0

Diagnostic Info

{
“browser-info”: {
“language”: “en-US”,
“platform”: “MacIntel”,
“userAgent”: “Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/605.1.15 (KHTML, like Gecko)”,
“vendor”: “Apple Computer, Inc.”
},
“system-info”: {
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “11.0.7+9-202002041938”,
“java.vendor”: “AdoptOpenJDK”,
“java.vendor.url”: “https://adoptopenjdk.net/”,
“java.version”: “11.0.7”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “11.0.7+9-202002041938”,
“os.name”: “Mac OS X”,
“os.version”: “10.14.6”,
“user.language”: “en”,
“user.timezone”: “Asia/Qatar”
},
“metabase-info”: {
“databases”: [
“h2”,
“mysql”,
“oracle”
],
“hosting-env”: “osx”,
“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”: “2020-02-25”,
“tag”: “v0.34.3”,
“branch”: “release-0.34.x”,
“hash”: “1a83edb”
},
“settings”: {
“report-timezone”: null
}
}
}

Derivers Version

ojdbc8.jar
oracle.metabase-driver.jar

Yes we have Varchar2 fields in our tables.

flamber · March 4, 2020, 11:59am

@mkhatib

Post “Diagnostic Info” from Admin > Troubleshooting.
Which version of ojdbc are you using? https://www.metabase.com/docs/latest/administration-guide/databases/oracle.html
Do you have any VARCHAR2 column types in the database?

mkhatib · March 5, 2020, 4:48am

Diagnostic Info

{
“browser-info”: {
“language”: “en-US”,
“platform”: “MacIntel”,
“userAgent”: “Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/605.1.15 (KHTML, like Gecko)”,
“vendor”: “Apple Computer, Inc.”
},
“system-info”: {
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “11.0.7+9-202002041938”,
“java.vendor”: “AdoptOpenJDK”,
“java.vendor.url”: “https://adoptopenjdk.net/”,
“java.version”: “11.0.7”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “11.0.7+9-202002041938”,
“os.name”: “Mac OS X”,
“os.version”: “10.14.6”,
“user.language”: “en”,
“user.timezone”: “Asia/Qatar”
},
“metabase-info”: {
“databases”: [
“h2”,
“mysql”,
“oracle”
],
“hosting-env”: “osx”,
“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”: “2020-02-25”,
“tag”: “v0.34.3”,
“branch”: “release-0.34.x”,
“hash”: “1a83edb”
},
“settings”: {
“report-timezone”: null
}
}
}

Derivers Version

ojdbc8.jar
oracle.metabase-driver.jar

Yes we have Varchar2 fields in our tables.

flamber · March 5, 2020, 6:49pm

@mkhatib Then you’re seeing this issue:
https://github.com/metabase/metabase/issues/11477 - upvote by clicking on the first post