X-Ray does not wok for Oracle view containing space in Columns

stripathi · August 16, 2021, 8:39am

I have created Custom question and used sum function from Oracle View, but when i am clicking x-ray option on the bar chart its giving error "Can't create dashboard for number of Vw Cab Wise Cost"

flamber · August 16, 2021, 8:45am

Hi @stripathi

Post "Diagnostic Info" from Admin > Troubleshooting
Which version of ojdbc8.jar?
Post errors from Admin > Troubleshooting > Logs.

stripathi · August 16, 2021, 11:15am

Diagnostic Info
Please include these details in support requests. Thank you!

{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.131 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "Cp1252",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11+28",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "http://java.oracle.com/",
"java.version": "11",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11+28",
"os.name": "Windows Server 2012 R2",
"os.version": "6.3",
"user.language": "en",
"user.timezone": "Asia/Calcutta"
},
"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-04-08",
"tag": "v0.38.4",
"branch": "release-x.38.x",
"hash": "057b6bb"
},
"settings": {
"report-timezone": null
}
}
}

Error Logs -->>>>>

[5df8c817-9b50-41ec-9197-f716102f00ae] 2021-08-16T16:43:07+05:30 DEBUG metabase.server.middleware.log GET /api/card/99 200 3.1 ms (6 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (1 idle, 0 queued) (116 total active threads) Queries in flight: 0 (0 queued)
[5df8c817-9b50-41ec-9197-f716102f00ae] 2021-08-16T16:43:07+05:30 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 189.5 ms (11 DB calls) App DB connections: 1/15 Jetty threads: 4/50 (1 idle, 0 queued) (116 total active threads) Queries in flight: 0 (0 queued)
[5df8c817-9b50-41ec-9197-f716102f00ae] 2021-08-16T16:43:12+05:30 ERROR metabase.server.middleware.log GET /api/automagic-dashboards/adhoc/eyJ0eXBlIjoicXVlcnkiLCJxdWVyeSI6eyJzb3VyY2UtdGFibGUiOjE0NDEwLCJmaWx0ZXIiOlsiYW5kIixbInRpbWUtaW50ZXJ2YWwiLFsiZmllbGQtaWQiLDE3OTIzOF0sLTIsIm1vbnRoIl1dLCJhZ2dyZWdhdGlvbiI6W1sic3VtIixbImZpZWxkLWlkIiwxNzkyNDNdXV0sImJyZWFrb3V0IjpbWyJmaWVsZC1pZCIsMTc5MTEyXSxbImZpZWxkLWlkIiwxNzkyMjldXX0sImRhdGFiYXNlIjoyfQ==/cell/WyJhbmQiLFsiPSIsWyJmaWVsZC1pZCIsMTc5MTEyXSwiSlVMLTIxIl0sWyI9IixbImZpZWxkLWlkIiwxNzkyMjldLCJBU0VaIl1d 500 122.1 ms (41 DB calls)
{:via
[{:type clojure.lang.ExceptionInfo,
:message "Can't create dashboard for sum of Total Cost",
:data
{:root
{:short-name "sum of Total Cost",
:rules-prefix ["metric"],
:source
{:description nil,
:entity_type nil,
:schema "SMTCG",
:show_in_getting_started false,
:name "VW_CAB_WISE_COST",
:caveats nil,
:updated_at #t "2021-08-15T22:42:06.264",
:entity_name nil,
:active true,
:id 14410,
:db_id 2,
:visibility_type nil,
:field_order :database,
:display_name "Vw Cab Wise Cost",
:created_at #t "2021-08-15T22:42:06.264",
:points_of_interest nil},
:url "/auto/dashboard/metric/null",
:full-name "sum of Total Cost",
:database 2,
:cell-query ("and" ["=" ["field-id" 179112] "JUL-21"] ["=" ["field-id" 179229] "ASEZ"]),
:query-filter [:time-interval [:field-id 179238] -2 :month],
:entity
{:definition {:aggregation [[:sum [:field-id 179243]]], :source-table 14410},
:name "sum of Total Cost",
:table_id 14410},
:show :all},
:available-rules ("GenericMetric")},
:at [metabase.automagic_dashboards.core$automagic_dashboard invokeStatic "core.clj" 1010]}],
:trace
[[metabase.automagic_dashboards.core$automagic_dashboard invokeStatic "core.clj" 1010]
[metabase.automagic_dashboards.core$automagic_dashboard invoke "core.clj" 980]
[metabase.automagic_dashboards.core$fn__53235 invokeStatic "core.clj" 1031]
[metabase.automagic_dashboards.core$fn__53235 invoke "core.clj" 1029]
[clojure.lang.MultiFn invoke "MultiFn.java" 234]
[metabase.automagic_dashboards.core$decompose_question$fn__53242 invoke "core.clj" 1057]
[clojure.core$map$fn__5866 invoke "core.clj" 2753]
[clojure.lang.LazySeq sval "LazySeq.java" 42]
[clojure.lang.LazySeq seq "LazySeq.java" 51]
[clojure.lang.RT seq "RT.java" 535]
[clojure.core$seq__5402 invokeStatic "core.clj" 137]
[clojure.core.protocols$seq_reduce invokeStatic "protocols.clj" 24]
[clojure.core.protocols$fn__8146 invokeStatic "protocols.clj" 75]
[clojure.core.protocols$fn__8146 invoke "protocols.clj" 75]
[clojure.core.protocols$fn__8088$G__8083__8101 invoke "protocols.clj" 13]
[clojure.core$reduce invokeStatic "core.clj" 6828]
[clojure.core$reduce invoke "core.clj" 6810]
[metabase.automagic_dashboards.core$fn__53301 invokeStatic "core.clj" 1200]
[metabase.automagic_dashboards.core$fn__53301 invoke "core.clj" 1186]
[clojure.lang.MultiFn invoke "MultiFn.java" 234]
[metabase.api.automagic_dashboards$fn__53589 invokeStatic "automagic_dashboards.clj" 131]
[metabase.api.automagic_dashboards$fn__53589 invoke "automagic_dashboards.clj" 121]
[compojure.core$wrap_response$fn__1996 invoke "core.clj" 160]
[compojure.core$wrap_route_middleware$fn__1980 invoke "core.clj" 132]
[compojure.core$wrap_route_info$fn__1985 invoke "core.clj" 139]
[compojure.core$wrap_route_matches$fn__1989 invoke "core.clj" 151]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__1989 invoke "core.clj" 152]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008 invoke "core.clj" 200]
[metabase.server.middleware.auth$enforce_authentication$fn__73892 invoke "auth.clj" 14]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008 invoke "core.clj" 200]
[compojure.core$make_context$handler__2036 invoke "core.clj" 287]
[compojure.core$make_context$fn__2038 invoke "core.clj" 296]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$make_context$fn__2038 invoke "core.clj" 297]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$make_context$fn__2038 invoke "core.clj" 297]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[metabase.api.routes$fn__74014$fn__74016 invoke "routes.clj" 69]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008 invoke "core.clj" 200]
[clojure.lang.AFn applyToHelper "AFn.java" 160]
[clojure.lang.AFn applyTo "AFn.java" 144]
[clojure.core$apply invokeStatic "core.clj" 665]
[clojure.core$apply invoke "core.clj" 660]
[metabase.server.routes$fn__76247$fn__76248 doInvoke "routes.clj" 57]
[clojure.lang.RestFn invoke "RestFn.java" 436]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008 invoke "core.clj" 200]
[compojure.core$make_context$handler__2036 invoke "core.clj" 287]
[compojure.core$make_context$fn__2038 invoke "core.clj" 296]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__1989 invoke "core.clj" 152]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__1989 invoke "core.clj" 152]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[compojure.core$wrap_route_matches$fn__1989 invoke "core.clj" 152]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010 invoke "core.clj" 197]
[metabase.server.routes$fn__76235$fn__76237 invoke "routes.clj" 41]
[compojure.core$routes$fn__2008$f__2009 invoke "core.clj" 198]
[compojure.core$routes$fn__2008 invoke "core.clj" 200]
[metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__74005 invoke "exceptions.clj" 98]
[metabase.server.middleware.exceptions$catch_api_exceptions$fn__74002 invoke "exceptions.clj" 86]
[metabase.server.middleware.log$log_api_call$fn__76163$fn__76164 invoke "log.clj" 195]
[toucan.db$_do_with_call_counting invokeStatic "db.clj" 216]
[toucan.db$_do_with_call_counting invoke "db.clj" 209]
[metabase.server.middleware.log$log_api_call$fn__76163 invoke "log.clj" 189]
[metabase.server.middleware.security$add_security_headers$fn__73967 invoke "security.clj" 142]
[metabase.server.middleware.json$wrap_json_body$fn__75944 invoke "json.clj" 62]
[metabase.server.middleware.json$wrap_streamed_json_response$fn__75962 invoke "json.clj" 98]
[ring.middleware.keyword_params$wrap_keyword_params$fn__76504 invoke "keyword_params.clj" 55]
[ring.middleware.params$wrap_params$fn__76520 invoke "params.clj" 69]
[metabase.server.middleware.misc$maybe_set_site_url$fn__34784 invoke "misc.clj" 58]
[metabase.server.middleware.session$bind_current_user$fn__41763$fn__41764 invoke "session.clj" 277]
[metabase.server.middleware.session$do_with_current_user invokeStatic "session.clj" 258]
[metabase.server.middleware.session$do_with_current_user invoke "session.clj" 250]
[metabase.server.middleware.session$bind_current_user$fn__41763 invoke "session.clj" 276]
[metabase.server.middleware.session$wrap_current_user_info$fn__41750 invoke "session.clj" 236]
[metabase.server.middleware.session$wrap_session_id$fn__41736 invoke "session.clj" 182]
[metabase.server.middleware.auth$wrap_api_key$fn__73900 invoke "auth.clj" 27]
[ring.middleware.cookies$wrap_cookies$fn__76424 invoke "cookies.clj" 216]
[metabase.server.middleware.misc$add_content_type$fn__34767 invoke "misc.clj" 27]
[metabase.server.middleware.misc$disable_streaming_buffering$fn__34792 invoke "misc.clj" 75]
[ring.middleware.gzip$wrap_gzip$fn__76466 invoke "gzip.clj" 86]
[metabase.server.middleware.misc$bind_request$fn__34795 invoke "misc.clj" 92]
[metabase.server.middleware.ssl$redirect_to_https_middleware$fn__76180 invoke "ssl.clj" 48]
[metabase.server$async_proxy_handler$fn__75777 invoke "server.clj" 71]
[metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a handle nil -1]
[org.eclipse.jetty.server.handler.HandlerWrapper handle "HandlerWrapper.java" 127]
[org.eclipse.jetty.server.Server handle "Server.java" 516]
[org.eclipse.jetty.server.HttpChannel lambda$handle$1 "HttpChannel.java" 383]
[org.eclipse.jetty.server.HttpChannel dispatch "HttpChannel.java" 556]
[org.eclipse.jetty.server.HttpChannel handle "HttpChannel.java" 375]
[org.eclipse.jetty.server.HttpConnection onFillable "HttpConnection.java" 273]
[org.eclipse.jetty.io.AbstractConnection$ReadCallback succeeded "AbstractConnection.java" 311]
[org.eclipse.jetty.io.FillInterest fillable "FillInterest.java" 105]
[org.eclipse.jetty.io.ChannelEndPoint$1 run "ChannelEndPoint.java" 104]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill runTask "EatWhatYouKill.java" 336]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill doProduce "EatWhatYouKill.java" 313]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill tryProduce "EatWhatYouKill.java" 171]
[org.eclipse.jetty.util.thread.strategy.EatWhatYouKill run "EatWhatYouKill.java" 129]
[org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread run "ReservedThreadExecutor.java" 375]
[org.eclipse.jetty.util.thread.QueuedThreadPool runJob "QueuedThreadPool.java" 773]
[org.eclipse.jetty.util.thread.QueuedThreadPool$Runner run "QueuedThreadPool.java" 905]
[java.lang.Thread run "Thread.java" 834]],
:cause "Can't create dashboard for sum of Total Cost",
:data
{:root
{:short-name "sum of Total Cost",
:rules-prefix ["metric"],
:source
{:description nil,
:entity_type nil,
:schema "SMTCG",
:show_in_getting_started false,
:name "VW_CAB_WISE_COST",
:caveats nil,
:updated_at #t "2021-08-15T22:42:06.264",
:entity_name nil,
:active true,
:id 14410,
:db_id 2,
:visibility_type nil,
:field_order :database,
:display_name "Vw Cab Wise Cost",
:created_at #t "2021-08-15T22:42:06.264",
:points_of_interest nil},
:url "/auto/dashboard/metric/null",
:full-name "sum of Total Cost",
:database 2,
:cell-query ("and" ["=" ["field-id" 179112] "JUL-21"] ["=" ["field-id" 179229] "ASEZ"]),
:query-filter [:time-interval [:field-id 179238] -2 :month],
:entity
{:definition {:aggregation [[:sum [:field-id 179243]]], :source-table 14410},
:name "sum of Total Cost",
:table_id 14410},
:show :all},
:available-rules ("GenericMetric")},
:message "Can't create dashboard for sum of Total Cost",
:root
{:short-name "sum of Total Cost",
:rules-prefix ["metric"],
:source
{:description nil,
:entity_type nil,
:schema "SMTCG",
:show_in_getting_started false,
:name "VW_CAB_WISE_COST",
:caveats nil,
:updated_at #t "2021-08-15T22:42:06.264",
:entity_name nil,
:active true,
:id 14410,
:db_id 2,
:visibility_type nil,
:field_order :database,
:display_name "Vw Cab Wise Cost",
:created_at #t "2021-08-15T22:42:06.264",
:points_of_interest nil},
:url "/auto/dashboard/metric/null",
:full-name "sum of Total Cost",
:database 2,
:cell-query ("and" ["=" ["field-id" 179112] "JUL-21"] ["=" ["field-id" 179229] "ASEZ"]),
:query-filter [:time-interval [:field-id 179238] -2 :month],
:entity
{:definition {:aggregation [[:sum [:field-id 179243]]], :source-table 14410},
:name "sum of Total Cost",
:table_id 14410},
:show :all},
:available-rules ("GenericMetric")}

flamber · August 16, 2021, 11:37am

@stripathi

Try the latest release, 0.40.2 - remember to backup first:
https://github.com/metabase/metabase/releases/latest
Make sure you are using ojdbc8.jar version 19.3 (19c) or newer:
https://www.metabase.com/docs/latest/administration-guide/databases/oracle.html

If you are still having problems after you have updated, then post the full stacktrace from that error.

stripathi · August 19, 2021, 1:34pm

@flamber, thanks
Its resolved now.

flamber · August 19, 2021, 1:44pm

@stripathi Perfect. Then migrate away from H2 if you are using Metabase in production:
https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html