Screen goes blank when drilling down to number type question (query builder)

My setup is METABASE with Postgres app server BD and Oracle Data warehouse.
Current stable version is 0.39.0

On TST env, with a replica of the APP BD and with the same DW access 0.39.0 work just like PRD server, so we use it to test upgrades.
After upgrading to 0.40.0 and after 0.40.1, we have an issue when navigation on a dashboard and clicking on a question (query builder one) with number visualization. What happens now, is that after the click, after a brief glance of que question openning and showing the filters, the screen goes complety blank.

I have the metabase log, the browser log and the HAR file.
Which would be more useful?

Tried with
Chrome 91.0.4472.164
Edge Version 91.0.864.71

Hi @drconstantino

Post "Diagnostic Info" from Admin > Troubleshooting.

I'm getting a bit confused - so this problem has existed since 0.39.0 - and is still a problem on 0.40.1?

Since it sounds like a frontend issue, then the browser log probably contains the only useful bit, but do see any errors in the Metabase log, when this problem occurs?

If you create a new question (similar to the existing) and add that to a new dashboard with the same filters etc, can you reproduce the problem when drilling there?
Or can you reproduce with the Sample Dataset?

Hi @flamber,

No, there's no problem on 0.39, only after 0.40.X

here's the diagnostic info
{
"browser-info": {
"language": "en-GB",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.164 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "1.8.0_282-b08",
"java.vendor": "Red Hat, Inc.",
"java.vendor.url": "https://www.redhat.com/",
"java.version": "1.8.0_282",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "25.282-b08",
"os.name": "Linux",
"os.version": "4.18.0-240.15.1.el8_3.x86_64",
"user.language": "en",
"user.timezone": "Europe/Lisbon"
},
"metabase-info": {
"databases": [
"oracle",
"h2"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "13.2"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.18"
}
},
"run-mode": "prod",
"version": {
"tag": "v0.40.1",
"date": "2021-07-14",
"branch": "release-x.40.x",
"hash": "ed8f9c8"
},
"settings": {
"report-timezone": "Europe/Lisbon"
}
}
}

I believe the issue is related with the fact that the summarize is based on custom field

case([Billing Item Type] != "Credit", [Billing Date], isempty([Orig Billing Item → ID]), [Billing Date], [Orig Billing Item → Billing Date])

Does it help? I've also tried to replace the isempty function by isnull and the issue persists.

@drconstantino
Okay, and which errors are you seeing from the browser console?
So if you try 0.39.5, then it works? Trying to narrow down exactly when the problem started.
Going to try playing around to see if I can reproduce somehow.

I've tried on tst with v0.39.5 and it works fine (I can enter and edit the question, the screen does not goes blank). Do you have a clue on what's causing the issue? I've tried to change the case logic and the issue persists. Also, on creating a new question with the same config the issue exists.
To give more feedback, I'm using the value resulting from that expression as the only summarize dimension (group by).
It seems that I'm stuck on 0.39.X :frowning:
In production I'm still on 0.39.0
Is v 0.39.5 considered stable? It is not shown on release notes section under admin-> updates

@drconstantino Okay, again, check the browser developer console and Admin > Troubleshooting > Logs for any errors, when you see the blank screen.

I don't have enough information about the question and field types to be able to reproduce.

Yes, 0.39.5 is stable - it was just released the same time as 0.40.0, so probably didn't get into the update notes. All release notes are available here: https://github.com/metabase/metabase/releases

[56ae5490-393f-4bb8-b791-8810a267cab0] 2021-08-10T17:32:59+01:00 WARN metabase.sync.util Error reducing earliest
java.lang.ClassCastException: java.time.OffsetDateTime cannot be cast to java.time.Instant
at java_time.temporal$fn__25711.invokeStatic(temporal.clj:366)
at java_time.temporal$fn__25711.invoke(temporal.clj:366)
at java_time.core$fn__24715$G__24695__24722.invoke(core.clj:136)
at java_time.core$before_QMARK_.invokeStatic(core.clj:165)
at java_time.core$before_QMARK_.invoke(core.clj:154)
at metabase.sync.analyze.fingerprint.fingerprinters$earliest.invokeStatic(fingerprinters.clj:173)
at metabase.sync.analyze.fingerprint.fingerprinters$earliest.invoke(fingerprinters.clj:168)
at metabase.sync.analyze.fingerprint.fingerprinters$with_error_handling$fn__40657$fn__40662.invoke(fingerprinters.clj:81)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:156)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:149)
at metabase.sync.analyze.fingerprint.fingerprinters$with_error_handling$fn__40657.invoke(fingerprinters.clj:81)
at redux.core$post_complete$fn__39330.invoke(core.cljc:15)
at redux.core$juxt$fn__39336$fn__39341.invoke(core.cljc:37)
at clojure.core$map$fn__5870.invoke(core.clj:2760)
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$into.invokeStatic(core.clj:6895)
at clojure.core$mapv.invokeStatic(core.clj:6903)
at clojure.core$mapv.invoke(core.clj:6903)
at redux.core$juxt$fn__39336.invoke(core.cljc:34)
at redux.core$post_complete$fn__39330.invoke(core.cljc:15)
at clojure.core$map$fn__5862$fn__5863.invoke(core.clj:2742)
at redux.core$post_complete$fn__39330.invoke(core.cljc:15)
at redux.core$juxt$fn__39336$fn__39341.invoke(core.cljc:37)
at clojure.core$map$fn__5870.invoke(core.clj:2760)
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$into.invokeStatic(core.clj:6895)
at clojure.core$mapv.invokeStatic(core.clj:6903)
at clojure.core$mapv.invoke(core.clj:6903)
at redux.core$juxt$fn__39336.invoke(core.cljc:34)
at redux.core$post_complete$fn__39330.invoke(core.cljc:15)
at metabase.sync.analyze.fingerprint.fingerprinters$with_error_handling$fn__40657$fn__40662.invoke(fingerprinters.clj:81)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:156)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:149)
at metabase.sync.analyze.fingerprint.fingerprinters$with_error_handling$fn__40657.invoke(fingerprinters.clj:81)
at metabase.sync.analyze.fingerprint.fingerprinters$col_wise$fn__40620$fn__40625.invoke(fingerprinters.clj:31)
at clojure.core$map$fn__5873.invoke(core.clj:2766)
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$into.invokeStatic(core.clj:6895)
at clojure.core$mapv.invokeStatic(core.clj:6903)
at clojure.core$mapv.invoke(core.clj:6903)
at metabase.sync.analyze.fingerprint.fingerprinters$col_wise$fn__40620.invoke(fingerprinters.clj:28)
at redux.core$juxt$fn__39336$fn__39341.invoke(core.cljc:37)
at clojure.core$map$fn__5870.invoke(core.clj:2760)
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$into.invokeStatic(core.clj:6895)
at clojure.core$mapv.invokeStatic(core.clj:6903)
at clojure.core$mapv.invoke(core.clj:6903)
at redux.core$juxt$fn__39336.invoke(core.cljc:34)
at redux.core$post_complete$fn__39330.invoke(core.cljc:15)
at metabase.query_processor.reducible$combine_additional_reducing_fns$fn__38269$fn__38272$fn__38273.invoke(reducible.clj:213)
at clojure.core$map$fn__5870.invoke(core.clj:2760)
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$into.invokeStatic(core.clj:6895)
at clojure.core$mapv.invokeStatic(core.clj:6903)
at clojure.core$mapv.invoke(core.clj:6903)
at metabase.query_processor.reducible$combine_additional_reducing_fns$fn__38269$fn__38272.invoke(reducible.clj:210)
at metabase.query_processor.reducible$combine_additional_reducing_fns$fn__38269.invoke(reducible.clj:209)
at metabase.query_processor.middleware.add_rows_truncated$add_rows_truncated_xform$fn__45162.invoke(add_rows_truncated.clj:27)
at metabase.query_processor.middleware.format_rows$format_rows_xform$fn__47812.invoke(format_rows.clj:68)
at metabase.query_processor.reducible$combine_additional_reducing_fns$fn__38269.invoke(reducible.clj:216)
at metabase.query_processor.middleware.cache$save_results_xform$fn__46412.invoke(cache.clj:108)
at metabase.query_processor.middleware.limit$limit_xform$fn__47871.invoke(limit.clj:24)
at metabase.query_processor.reducible$reducible_rows$reify__38262.reduce(reducible.clj:161)
at clojure.core$transduce.invokeStatic(core.clj:6883)
at clojure.core$transduce.invokeStatic(core.clj:6879)
at clojure.core$transduce.invoke(core.clj:6870)
at metabase.query_processor.context.default$default_reducef$fn__37435.invoke(default.clj:58)
at metabase.query_processor.context.default$default_reducef.invokeStatic(default.clj:57)
at metabase.query_processor.context.default$default_reducef.invoke(default.clj:48)
at metabase.query_processor.context$reducef.invokeStatic(context.clj:69)
at metabase.query_processor.context$reducef.invoke(context.clj:62)
at metabase.query_processor.context.default$default_runf$respond_STAR___37439.invoke(default.clj:69)
at metabase.driver.oracle$remove_rownum_column.invokeStatic(oracle.clj:313)
at metabase.driver.oracle$remove_rownum_column.invoke(oracle.clj:309)
at clojure.core$partial$fn__5839.invoke(core.clj:2625)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:485)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:463)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:472)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:463)
at metabase.driver.sql_jdbc$fn__82291.invokeStatic(sql_jdbc.clj:54)
at metabase.driver.sql_jdbc$fn__82291.invoke(sql_jdbc.clj:52)
at metabase.driver.oracle$eval582$fn__583.invoke(oracle.clj:326)
at clojure.lang.MultiFn.invoke(MultiFn.java:244)
at metabase.query_processor.context$executef.invokeStatic(context.clj:59)
at metabase.query_processor.context$executef.invoke(context.clj:48)
at metabase.query_processor.context.default$default_runf.invokeStatic(default.clj:68)
at metabase.query_processor.context.default$default_runf.invoke(default.clj:66)
at metabase.query_processor.context$runf.invokeStatic(context.clj:45)
at metabase.query_processor.context$runf.invoke(context.clj:39)
at metabase.query_processor.reducible$pivot.invokeStatic(reducible.clj:34)
at metabase.query_processor.reducible$pivot.invoke(reducible.clj:31)
at metabase.query_processor.middleware.mbql_to_native$mbql__GT_native$fn__47888.invoke(mbql_to_native.clj:25)
at metabase.query_processor.middleware.check_features$check_features$fn__47002.invoke(check_features.clj:39)
at metabase.query_processor.middleware.limit$limit$fn__47874.invoke(limit.clj:37)
at metabase.query_processor.middleware.cache$run_query_with_cache.invokeStatic(cache.clj:177)
at metabase.query_processor.middleware.cache$run_query_with_cache.invoke(cache.clj:168)
at metabase.query_processor.middleware.cache$maybe_return_cached_results$fn__46454.invoke(cache.clj:203)
at metabase.query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__48134.invoke(optimize_temporal_filters.clj:204)
at metabase.query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__50066.invoke(validate_temporal_bucketing.clj:50)
at metabase.query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__45573.invoke(auto_parse_filter_values.clj:43)
at metabase.query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__41707.invoke(wrap_value_literals.clj:161)
at metabase.query_processor.middleware.annotate$add_column_info$fn__41582.invoke(annotate.clj:608)
at metabase.query_processor.middleware.permissions$check_query_permissions$fn__46874.invoke(permissions.clj:81)
at metabase.query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__48995.invoke(pre_alias_aggregations.clj:40)
at metabase.query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__47075.invoke(cumulative_aggregations.clj:60)
at metabase.query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__49292.invoke(resolve_joined_fields.clj:102)
at metabase.query_processor.middleware.resolve_joins$resolve_joins$fn__49605.invoke(resolve_joins.clj:171)
at metabase.query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__45149.invoke(add_implicit_joins.clj:190)
at metabase.query_processor.middleware.large_int_id$convert_id_to_string$fn__47838.invoke(large_int_id.clj:59)
at metabase.query_processor.middleware.format_rows$format_rows$fn__47819.invoke(format_rows.clj:74)
at metabase.query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__44443.invoke(add_default_temporal_unit.clj:23)
at metabase.query_processor.middleware.desugar$desugar$fn__47141.invoke(desugar.clj:21)
at metabase.query_processor.middleware.binning$update_binning_strategy$fn__45960.invoke(binning.clj:229)
at metabase.query_processor.middleware.resolve_fields$resolve_fields$fn__46677.invoke(resolve_fields.clj:34)
at metabase.query_processor.middleware.add_dimension_projections$add_remapping$fn__44798.invoke(add_dimension_projections.clj:312)
at metabase.query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__45027.invoke(add_implicit_clauses.clj:147)
at metabase.query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__50015.invoke(upgrade_field_literals.clj:40)
at metabase.query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__45312.invoke(add_source_metadata.clj:123)
at metabase.query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__49167.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)
at metabase.query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__45520.invoke(auto_bucket_datetimes.clj:147)
at metabase.query_processor.middleware.resolve_source_table$resolve_source_tables$fn__46724.invoke(resolve_source_table.clj:45)
at metabase.query_processor.middleware.parameters$substitute_parameters$fn__48977.invoke(parameters.clj:111)
at metabase.query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__46776.invoke(resolve_referenced.clj:79)
at metabase.query_processor.middleware.expand_macros$expand_macros$fn__47525.invoke(expand_macros.clj:184)
at metabase.query_processor.middleware.add_timezone_info$add_timezone_info$fn__45321.invoke(add_timezone_info.clj:15)
at metabase.query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__49968.invoke(splice_params_in_response.clj:32)
at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49178$fn__49182.invoke(resolve_database_and_driver.clj:31)
at metabase.driver$do_with_driver.invokeStatic(driver.clj:60)
at metabase.driver$do_with_driver.invoke(driver.clj:56)
at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49178.invoke(resolve_database_and_driver.clj:25)
at metabase.query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__47765.invoke(fetch_source_query.clj:274)
at metabase.query_processor.middleware.store$initialize_store$fn__49977$fn__49978.invoke(store.clj:11)
at metabase.query_processor.store$do_with_store.invokeStatic(store.clj:44)
at metabase.query_processor.store$do_with_store.invoke(store.clj:38)
at metabase.query_processor.middleware.store$initialize_store$fn__49977.invoke(store.clj:10)
at metabase.query_processor.middleware.validate$validate_query$fn__50022.invoke(validate.clj:10)
at metabase.query_processor.middleware.normalize_query$normalize$fn__47901.invoke(normalize_query.clj:22)
at metabase.query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__45167.invoke(add_rows_truncated.clj:35)
at metabase.query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49953.invoke(results_metadata.clj:147)
at metabase.query_processor.middleware.constraints$add_default_userland_constraints$fn__47018.invoke(constraints.clj:42)
at metabase.query_processor.middleware.process_userland_query$process_userland_query$fn__49064.invoke(process_userland_query.clj:134)
at metabase.query_processor.middleware.catch_exceptions$catch_exceptions$fn__46958.invoke(catch_exceptions.clj:173)
at metabase.query_processor.reducible$async_qp$qp_STAR___38246$thunk__38247.invoke(reducible.clj:103)
at metabase.query_processor.reducible$async_qp$qp_STAR___38246$fn__38249.invoke(reducible.clj:108)
at clojure.core$binding_conveyor_fn$fn__5754.invoke(core.clj:2030)
at clojure.lang.AFn.call(AFn.java:18)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
[56ae5490-393f-4bb8-b791-8810a267cab0] 2021-08-10T17:32:59+01:00 WARN metabase.sync.util Error reducing latest
java.lang.ClassCastException: java.time.OffsetDateTime cannot be cast to java.time.Instant
at java_time.temporal$fn__25709.invokeStatic(temporal.clj:366)
at java_time.temporal$fn__25709.invoke(temporal.clj:366)
at java_time.core$fn__24702$G__24697__24709.invoke(core.clj:136)
at java_time.core$after_QMARK_.invokeStatic(core.clj:184)
at java_time.core$after_QMARK_.invoke(core.clj:173)
at metabase.sync.analyze.fingerprint.fingerprinters$latest.invokeStatic(fingerprinters.clj:182)
at metabase.sync.analyze.fingerprint.fingerprinters$latest.invoke(fingerprinters.clj:177)
at metabase.sync.analyze.fingerprint.fingerprinters$with_error_handling$fn__40657$fn__40662.invoke(fingerprinters.clj:81)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:156)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:149)
at metabase.sync.analyze.fingerprint.fingerprinters$with_error_handling$fn__40657.invoke(fingerprinters.clj:81)
at redux.core$post_complete$fn__39330.invoke(core.cljc:15)
at redux.core$juxt$fn__39336$fn__39341.invoke(core.cljc:37)
at clojure.core$map$fn__5870.invoke(core.clj:2760)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.Cons.next(Cons.java:39)
at clojure.lang.RT.next(RT.java:713)
at clojure.core$next__5386.invokeStatic(core.clj:64)
at clojure.core.protocols$fn__8159.invokeStatic(protocols.clj:169)
at clojure.core.protocols$fn__8159.invoke(protocols.clj:124)
at clojure.core.protocols$fn__8114$G__8109__8123.invoke(protocols.clj:19)
at clojure.core.protocols$seq_reduce.invokeStatic(protocols.clj:31)
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$into.invokeStatic(core.clj:6895)
at clojure.core$mapv.invokeStatic(core.clj:6903)
at clojure.core$mapv.invoke(core.clj:6903)
at redux.core$juxt$fn__39336.invoke(core.cljc:34)
at redux.core$post_complete$fn__39330.invoke(core.cljc:15)
at clojure.core$map$fn__5862$fn__5863.invoke(core.clj:2742)
at redux.core$post_complete$fn__39330.invoke(core.cljc:15)
at redux.core$juxt$fn__39336$fn__39341.invoke(core.cljc:37)
at clojure.core$map$fn__5870.invoke(core.clj:2760)
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$into.invokeStatic(core.clj:6895)
at clojure.core$mapv.invokeStatic(core.clj:6903)
at clojure.core$mapv.invoke(core.clj:6903)
at redux.core$juxt$fn__39336.invoke(core.cljc:34)
at redux.core$post_complete$fn__39330.invoke(core.cljc:15)
at metabase.sync.analyze.fingerprint.fingerprinters$with_error_handling$fn__40657$fn__40662.invoke(fingerprinters.clj:81)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:156)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:149)
at metabase.sync.analyze.fingerprint.fingerprinters$with_error_handling$fn__40657.invoke(fingerprinters.clj:81)
at metabase.sync.analyze.fingerprint.fingerprinters$col_wise$fn__40620$fn__40625.invoke(fingerprinters.clj:31)
at clojure.core$map$fn__5873.invoke(core.clj:2766)
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$into.invokeStatic(core.clj:6895)
at clojure.core$mapv.invokeStatic(core.clj:6903)
at clojure.core$mapv.invoke(core.clj:6903)
at metabase.sync.analyze.fingerprint.fingerprinters$col_wise$fn__40620.invoke(fingerprinters.clj:28)
at redux.core$juxt$fn__39336$fn__39341.invoke(core.cljc:37)
at clojure.core$map$fn__5870.invoke(core.clj:2760)
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$into.invokeStatic(core.clj:6895)
at clojure.core$mapv.invokeStatic(core.clj:6903)
at clojure.core$mapv.invoke(core.clj:6903)
at redux.core$juxt$fn__39336.invoke(core.cljc:34)
at redux.core$post_complete$fn__39330.invoke(core.cljc:15)
at metabase.query_processor.reducible$combine_additional_reducing_fns$fn__38269$fn__38272$fn__38273.invoke(reducible.clj:213)
at clojure.core$map$fn__5870.invoke(core.clj:2760)
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$into.invokeStatic(core.clj:6895)
at clojure.core$mapv.invokeStatic(core.clj:6903)
at clojure.core$mapv.invoke(core.clj:6903)
at metabase.query_processor.reducible$combine_additional_reducing_fns$fn__38269$fn__38272.invoke(reducible.clj:210)
at metabase.query_processor.reducible$combine_additional_reducing_fns$fn__38269.invoke(reducible.clj:209)
at metabase.query_processor.middleware.add_rows_truncated$add_rows_truncated_xform$fn__45162.invoke(add_rows_truncated.clj:27)
at metabase.query_processor.middleware.format_rows$format_rows_xform$fn__47812.invoke(format_rows.clj:68)
at metabase.query_processor.reducible$combine_additional_reducing_fns$fn__38269.invoke(reducible.clj:216)
at metabase.query_processor.middleware.cache$save_results_xform$fn__46412.invoke(cache.clj:108)
at metabase.query_processor.middleware.limit$limit_xform$fn__47871.invoke(limit.clj:24)
at metabase.query_processor.reducible$reducible_rows$reify__38262.reduce(reducible.clj:161)
at clojure.core$transduce.invokeStatic(core.clj:6883)
at clojure.core$transduce.invokeStatic(core.clj:6879)
at clojure.core$transduce.invoke(core.clj:6870)
at metabase.query_processor.context.default$default_reducef$fn__37435.invoke(default.clj:58)
at metabase.query_processor.context.default$default_reducef.invokeStatic(default.clj:57)
at metabase.query_processor.context.default$default_reducef.invoke(default.clj:48)
at metabase.query_processor.context$reducef.invokeStatic(context.clj:69)
at metabase.query_processor.context$reducef.invoke(context.clj:62)
at metabase.query_processor.context.default$default_runf$respond_STAR___37439.invoke(default.clj:69)
at metabase.driver.oracle$remove_rownum_column.invokeStatic(oracle.clj:313)
at metabase.driver.oracle$remove_rownum_column.invoke(oracle.clj:309)
at clojure.core$partial$fn__5839.invoke(core.clj:2625)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:485)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:463)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:472)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:463)
at metabase.driver.sql_jdbc$fn__82291.invokeStatic(sql_jdbc.clj:54)
at metabase.driver.sql_jdbc$fn__82291.invoke(sql_jdbc.clj:52)
at metabase.driver.oracle$eval582$fn__583.invoke(oracle.clj:326)
at clojure.lang.MultiFn.invoke(MultiFn.java:244)
at metabase.query_processor.context$executef.invokeStatic(context.clj:59)
at metabase.query_processor.context$executef.invoke(context.clj:48)
at metabase.query_processor.context.default$default_runf.invokeStatic(default.clj:68)
at metabase.query_processor.context.default$default_runf.invoke(default.clj:66)
at metabase.query_processor.context$runf.invokeStatic(context.clj:45)
at metabase.query_processor.context$runf.invoke(context.clj:39)
at metabase.query_processor.reducible$pivot.invokeStatic(reducible.clj:34)
at metabase.query_processor.reducible$pivot.invoke(reducible.clj:31)
at metabase.query_processor.middleware.mbql_to_native$mbql__GT_native$fn__47888.invoke(mbql_to_native.clj:25)
at metabase.query_processor.middleware.check_features$check_features$fn__47002.invoke(check_features.clj:39)
at metabase.query_processor.middleware.limit$limit$fn__47874.invoke(limit.clj:37)
at metabase.query_processor.middleware.cache$run_query_with_cache.invokeStatic(cache.clj:177)
at metabase.query_processor.middleware.cache$run_query_with_cache.invoke(cache.clj:168)
at metabase.query_processor.middleware.cache$maybe_return_cached_results$fn__46454.invoke(cache.clj:203)
at metabase.query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__48134.invoke(optimize_temporal_filters.clj:204)
at metabase.query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__50066.invoke(validate_temporal_bucketing.clj:50)
at metabase.query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__45573.invoke(auto_parse_filter_values.clj:43)
at metabase.query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__41707.invoke(wrap_value_literals.clj:161)
at metabase.query_processor.middleware.annotate$add_column_info$fn__41582.invoke(annotate.clj:608)
at metabase.query_processor.middleware.permissions$check_query_permissions$fn__46874.invoke(permissions.clj:81)
at metabase.query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__48995.invoke(pre_alias_aggregations.clj:40)
at metabase.query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__47075.invoke(cumulative_aggregations.clj:60)
at metabase.query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__49292.invoke(resolve_joined_fields.clj:102)
at metabase.query_processor.middleware.resolve_joins$resolve_joins$fn__49605.invoke(resolve_joins.clj:171)
at metabase.query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__45149.invoke(add_implicit_joins.clj:190)
at metabase.query_processor.middleware.large_int_id$convert_id_to_string$fn__47838.invoke(large_int_id.clj:59)
at metabase.query_processor.middleware.format_rows$format_rows$fn__47819.invoke(format_rows.clj:74)
at metabase.query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__44443.invoke(add_default_temporal_unit.clj:23)
at metabase.query_processor.middleware.desugar$desugar$fn__47141.invoke(desugar.clj:21)
at metabase.query_processor.middleware.binning$update_binning_strategy$fn__45960.invoke(binning.clj:229)
at metabase.query_processor.middleware.resolve_fields$resolve_fields$fn__46677.invoke(resolve_fields.clj:34)
at metabase.query_processor.middleware.add_dimension_projections$add_remapping$fn__44798.invoke(add_dimension_projections.clj:312)
at metabase.query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__45027.invoke(add_implicit_clauses.clj:147)
at metabase.query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__50015.invoke(upgrade_field_literals.clj:40)
at metabase.query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__45312.invoke(add_source_metadata.clj:123)
at metabase.query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__49167.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)
at metabase.query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__45520.invoke(auto_bucket_datetimes.clj:147)
at metabase.query_processor.middleware.resolve_source_table$resolve_source_tables$fn__46724.invoke(resolve_source_table.clj:45)
at metabase.query_processor.middleware.parameters$substitute_parameters$fn__48977.invoke(parameters.clj:111)
at metabase.query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__46776.invoke(resolve_referenced.clj:79)
at metabase.query_processor.middleware.expand_macros$expand_macros$fn__47525.invoke(expand_macros.clj:184)
at metabase.query_processor.middleware.add_timezone_info$add_timezone_info$fn__45321.invoke(add_timezone_info.clj:15)
at metabase.query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__49968.invoke(splice_params_in_response.clj:32)
at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49178$fn__49182.invoke(resolve_database_and_driver.clj:31)
at metabase.driver$do_with_driver.invokeStatic(driver.clj:60)
at metabase.driver$do_with_driver.invoke(driver.clj:56)
at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49178.invoke(resolve_database_and_driver.clj:25)
at metabase.query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__47765.invoke(fetch_source_query.clj:274)
at metabase.query_processor.middleware.store$initialize_store$fn__49977$fn__49978.invoke(store.clj:11)
at metabase.query_processor.store$do_with_store.invokeStatic(store.clj:44)
at metabase.query_processor.store$do_with_store.invoke(store.clj:38)
at metabase.query_processor.middleware.store$initialize_store$fn__49977.invoke(store.clj:10)
at metabase.query_processor.middleware.validate$validate_query$fn__50022.invoke(validate.clj:10)
at metabase.query_processor.middleware.normalize_query$normalize$fn__47901.invoke(normalize_query.clj:22)
at metabase.query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__45167.invoke(add_rows_truncated.clj:35)
at metabase.query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__49953.invoke(results_metadata.clj:147)
at metabase.query_processor.middleware.constraints$add_default_userland_constraints$fn__47018.invoke(constraints.clj:42)
at metabase.query_processor.middleware.process_userland_query$process_userland_query$fn__49064.invoke(process_userland_query.clj:134)
at metabase.query_processor.middleware.catch_exceptions$catch_exceptions$fn__46958.invoke(catch_exceptions.clj:173)
at metabase.query_processor.reducible$async_qp$qp_STAR___38246$thunk__38247.invoke(reducible.clj:103)
at metabase.query_processor.reducible$async_qp$qp_STAR___38246$fn__38249.invoke(reducible.clj:108)
at clojure.core$binding_conveyor_fn$fn__5754.invoke(core.clj:2030)
at clojure.lang.AFn.call(AFn.java:18)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

@drconstantino Okay, so this is the core problem:
java.lang.ClassCastException: java.time.OffsetDateTime cannot be cast to java.time.Instant

Which version of ojdbc8.jar are you using?

Which column type is the following two fields Billing Date and Orig Billing Item → Billing Date ?
And what is the Field Type and possibly the Semantic Type in Metabase > Admin > Data Model ?

Hi, the version of ojdbc8.jar is
Oracle 19.9.0.0.0 JDBC 4.2 compiled with javac 1.8.0_251 on Tue_Aug_11_01:11:38_PDT_2020
#Default Connection Properties Resource
#Wed Aug 11 10:03:22 WEST 2021

****** JCE UNLIMITED STRENGTH IS INSTALLED *****

In regards with the Billing Date, both belong to the same table as I'm joining the same table by orig billing item ID = ID

the field Billing Date is a Date on Oracle and on metabase datamodel layer, I've defined it as creationdate, creation timestamp and no semantic type, all of the option resulting in the same error.

Rgds

@drconstantino
Okay, can you post the output of /api/field/123, where 123 is the field id in Metabase, which you can see in the URL, when going to Admin > Data Model > (db) > (table) > Billing Date :gear:

No quite sure what you request here, but
Searched for the field id 816 (which is the one Billing Date) on the logs and found just stuff like this:

[56ae5490-393f-4bb8-b791-8810a267cab0] 2021-08-11T12:37:12+01:00 DEBUG metabase.server.middleware.log GET /api/field/816/values 200 25.3 ms (4 DB calls) App DB connections: 2/15 Jetty threads: 5/50 (2 idle, 0 queued) (108 total active threads) Queries in flight: 0 (0 queued)
[56ae5490-393f-4bb8-b791-8810a267cab0] 2021-08-11T12:37:38+01:00 DEBUG metabase.server.middleware.log PUT /api/field/816 200 10.8 ms (5 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (6 idle, 0 queued) (114 total active threads) Queries in flight: 0 (0 queued)

Also went to metabase db and searched for the field
and the info:
{
"metabase_field": [
{
"id" : 816,
"created_at" : "2021-01-12T15:15:40.958Z",
"updated_at" : "2021-08-11T11:37:38.009Z",
"name" : "BILLING_DATE",
"base_type" : "type/Date",
"semantic_type" : "type/CreationDate",
"active" : true,
"description" : null,
"preview_display" : true,
"position" : 41,
"table_id" : 54,
"parent_id" : null,
"display_name" : "Billing Date",
"visibility_type" : "normal",
"fk_target_field_id" : null,
"last_analyzed" : "2021-01-12T15:17:25.537Z",
"points_of_interest" : null,
"caveats" : null,
"fingerprint" : "{"global":{"distinct-count":74,"nil%":0.0},"type":{"type/DateTime":{"earliest":"2015-07-20T00:00:00Z","latest":"2052-03-20T00:00:00Z"}}}",
"fingerprint_version" : 5,
"database_type" : "DATE",
"has_field_values" : "none",
"settings" : "{"time_enabled":null,"view_as":"auto","date_abbreviate":true}",
"database_position" : 41,
"custom_position" : 0,
"effective_type" : "type/Date",
"coercion_strategy" : null
}
]}

Regarding field values on metabase_field_values table, I couldn't find any record for that field

Any other suggestions?

Rgds

@drconstantino I was just trying to get the info when you go to the URL /api/field/816, but it should be the same as metabase_field.
There are no field values for dates.
Let me play around by creating something similar, so I can see if I can reproduce.

@drconstantino Okay, so I think I overlooked that the log you posted had nothing to do with your current problem. That is a warning during sync, which is likely not relevant for the current problem at all.
I'm not completely sure why you posted that log.

Are you seeing any logs that are relevant (meaning the same time) to when you get the blank screen?

There must be errors in your browser console - the page cannot go blank unless there's javascript errors.

Hi, on my first comment is attached the HAR field as well as console log.

@drconstantino Where?

You're right, I have the files but I can't attach files here.
The console log is to long to paste just the text.
The har file I don't have alternative.
Can you please suggest a way for me to post those files without violating the forum rules?

@drconstantino I really don't understand how the console logs could be so big unless they contain a lot of unrelated stuff. But upload the files to another service and post a link here.

Console Log

HAR File

@drconstantino Okay, so I think you're seeing a combination of things.
Probably this issue is not helping, though you would see query errors if you hitting that:
https://github.com/metabase/metabase/issues/15978
But I'm also seeing indications of this issue:
https://github.com/metabase/metabase/issues/13595
That should still not result in a blank screen, and it's something that I have been trying to reproduce the past week, but I think I'm on the right track now - and it's likely not specific to Oracle.