Sync/re-scan values ERRORS on Oracle tables with BLOB, CLOB, and XMLTYPE columns

Metabase v0.46.6 connected to Oracle database.

Sync and re-scan values seems give errors on BLOB and CLOB columns.
The data that was in the tables at the time I initially connected Metabase are returned in queries, but any data added to the tables since then is not returned. Even after I try to do manual sync and re-scan. (see below for portion of log)

How can I get around this?

2023-07-13 09:37:02,289 ERROR models.field-values :: Error fetching field values
clojure.lang.ExceptionInfo: Error executing query: ORA-00932: inconsistent datatypes: expected - got CLOB
{:driver :oracle, :sql ["-- Metabase" "SELECT" " *" "FROM" " (" " SELECT" " "DEMOUSER"."TAPI_SUBSTANCE"."ADDITIONALINFORMATION" "ADDITIONALINFORMATION"" " FROM" " "DEMOUSER"."TAPI_SUBSTANCE"" " GROUP BY" " "DEMOUSER"."TAPI_SUBSTANCE"."ADDITIONALINFORMATION"" " ORDER BY" " "DEMOUSER"."TAPI_SUBSTANCE"."ADDITIONALINFORMATION" ASC" " )" "WHERE" " rownum <= 1000"], :params nil, :type :invalid-query}
at metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__71858.invoke(execute.clj:505)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:502)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:489)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:497)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:489)
at metabase.driver.sql_jdbc$fn__105169.invokeStatic(sql_jdbc.clj:63)
at metabase.driver.sql_jdbc$fn__105169.invoke(sql_jdbc.clj:61)
at metabase.driver.oracle$fn__107270.invokeStatic(oracle.clj:509)
at metabase.driver.oracle$fn__107270.invoke(oracle.clj:507)
at clojure.lang.MultiFn.invoke(MultiFn.java:244)
at metabase.query_processor.context$executef.invokeStatic(context.clj:60)
at metabase.query_processor.context$executef.invoke(context.clj:49)
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:46)
at metabase.query_processor.context$runf.invoke(context.clj:40)
at metabase.query_processor.reducible$identity_qp.invokeStatic(reducible.clj:15)
at metabase.query_processor.reducible$identity_qp.invoke(reducible.clj:12)
at metabase.query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___69242.invoke(cache.clj:224)
at metabase.query_processor.middleware.permissions$check_query_permissions$fn__64714.invoke(permissions.clj:126)
at metabase.query_processor.middleware.mbql_to_native$mbql__GT_native$fn__68133.invoke(mbql_to_native.clj:24)
at metabase.query_processor$fn__70761$combined_post_process__70766$combined_post_process_STAR___70767.invoke(query_processor.clj:243)
at metabase.query_processor$fn__70761$combined_pre_process__70762$combined_pre_process_STAR___70763.invoke(query_processor.clj:240)
at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__69153$fn__69158.invoke(resolve_database_and_driver.clj:36)
at metabase.driver$do_with_driver.invokeStatic(driver.clj:90)
at metabase.driver$do_with_driver.invoke(driver.clj:86)
at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__69153.invoke(resolve_database_and_driver.clj:35)
at metabase.query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__65024.invoke(fetch_source_query.clj:316)
at metabase.query_processor.middleware.store$initialize_store$fn__65202$fn__65203.invoke(store.clj:12)
at metabase.query_processor.store$do_with_store.invokeStatic(store.clj:47)
at metabase.query_processor.store$do_with_store.invoke(store.clj:41)
at metabase.query_processor.middleware.store$initialize_store$fn__65202.invoke(store.clj:11)
at metabase.query_processor.middleware.normalize_query$normalize$fn__69442.invoke(normalize_query.clj:25)
at metabase.query_processor.reducible$async_qp$qp_STAR___59523$thunk__59525.invoke(reducible.clj:103)
at metabase.query_processor.reducible$async_qp$qp_STAR___59523.invoke(reducible.clj:109)
at metabase.query_processor.reducible$async_qp$qp_STAR___59523.invoke(reducible.clj:94)
at metabase.query_processor.reducible$async_qp$qp_STAR___59523.invoke(reducible.clj:91)
at clojure.lang.AFn.applyToHelper(AFn.java:154)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$apply.invoke(core.clj:662)
at metabase.query_processor.reducible$sync_qp$qp_STAR___59535.doInvoke(reducible.clj:129)
at clojure.lang.RestFn.applyTo(RestFn.java:137)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.query_processor$process_query.invokeStatic(query_processor.clj:278)
at metabase.query_processor$process_query.doInvoke(query_processor.clj:272)
at clojure.lang.RestFn.invoke(RestFn.java:410)
at metabase.db.metadata_queries$qp_query$fn__77167.invoke(metadata_queries.clj:23)
at metabase.db.metadata_queries$qp_query.invokeStatic(metadata_queries.clj:22)
at metabase.db.metadata_queries$qp_query.invoke(metadata_queries.clj:20)
at metabase.db.metadata_queries$field_query.invokeStatic(metadata_queries.clj:33)
at metabase.db.metadata_queries$field_query.invoke(metadata_queries.clj:31)
at metabase.db.metadata_queries$fn__77184$field_distinct_values__77193$fn__77196.invoke(metadata_queries.clj:65)
at metabase.db.metadata_queries$fn__77184$field_distinct_values__77193.invoke(metadata_queries.clj:58)
at metabase.db.metadata_queries$fn__77184$field_distinct_values__77193$fn__77194.invoke(metadata_queries.clj:62)
at metabase.db.metadata_queries$fn__77184$field_distinct_values__77193.invoke(metadata_queries.clj:58)
at clojure.lang.Var.invoke(Var.java:384)
at metabase.models.field_values$distinct_values.invokeStatic(field_values.clj:306)
at metabase.models.field_values$distinct_values.invoke(field_values.clj:291)
at metabase.models.field_values$create_or_update_full_field_values_BANG_.invokeStatic(field_values.clj:333)
at metabase.models.field_values$create_or_update_full_field_values_BANG_.doInvoke(field_values.clj:325)
at clojure.lang.RestFn.invoke(RestFn.java:410)
at metabase.sync.field_values$fn__84967$update_field_values_for_field_BANG___84972$fn__84973.invoke(field_values.clj:31)
at metabase.sync.field_values$fn__84967$update_field_values_for_field_BANG___84972.invoke(field_values.clj:25)
at metabase.sync.field_values$fn__84998$update_field_values_for_table_BANG___85003$fn__85004$fn__85005$fn__85006.invoke(field_values.clj:56)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:161)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:154)
at metabase.sync.field_values$fn__84998$update_field_values_for_table_BANG___85003$fn__85004$fn__85005.invoke(field_values.clj:54)
at clojure.lang.PersistentVector.reduce(PersistentVector.java:343)
at clojure.core$reduce.invokeStatic(core.clj:6885)
at clojure.core$reduce.invoke(core.clj:6868)
at metabase.sync.field_values$fn__84998$update_field_values_for_table_BANG___85003$fn__85004.invoke(field_values.clj:53)
at metabase.sync.field_values$fn__84998$update_field_values_for_table_BANG___85003.invoke(field_values.clj:50)
at clojure.core$map$fn__5935.invoke(core.clj:2770)
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.boundedLength(RT.java:1790)
at clojure.lang.RestFn.applyTo(RestFn.java:130)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.sync.field_values$fn__85027$update_field_values_for_database_BANG___85032$fn__85033.invoke(field_values.clj:65)
at metabase.sync.field_values$fn__85027$update_field_values_for_database_BANG___85032.invoke(field_values.clj:62)
at metabase.sync.field_values$make_sync_field_values_steps$fn__85109.invoke(field_values.clj:114)
at clojure.lang.AFn.applyToHelper(AFn.java:154)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.sync.util$fn__55983$run_step_with_metadata__55988$fn__55992$fn__55994.doInvoke(util.clj:379)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:103)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:97)
at metabase.sync.util$with_start_and_finish_debug_logging.invokeStatic(util.clj:120)
at metabase.sync.util$with_start_and_finish_debug_logging.invoke(util.clj:117)
at metabase.sync.util$fn__55983$run_step_with_metadata__55988$fn__55992.invoke(util.clj:374)
at metabase.sync.util$fn__55983$run_step_with_metadata__55988.invoke(util.clj:369)
at metabase.sync.util$fn__56210$run_sync_operation__56215$fn__56216$fn__56224.invoke(util.clj:486)
at metabase.sync.util$fn__56210$run_sync_operation__56215$fn__56216.invoke(util.clj:484)
at metabase.sync.util$fn__56210$run_sync_operation__56215.invoke(util.clj:478)
at metabase.sync.field_values$fn__85118$update_field_values_BANG___85123$fn__85124$fn__85125.invoke(field_values.clj:124)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:161)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:154)
at clojure.core$partial$fn__5910.invoke(core.clj:2647)
at metabase.driver$fn__46820.invokeStatic(driver.clj:658)
at metabase.driver$fn__46820.invoke(driver.clj:658)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.sync.util$sync_in_context$fn__55903.invoke(util.clj:139)
at metabase.sync.util$with_db_logging_disabled$fn__55900.invoke(util.clj:130)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:103)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:97)
at metabase.sync.util$with_start_and_finish_logging$fn__55887.invoke(util.clj:115)
at metabase.sync.util$with_sync_events$fn__55882.invoke(util.clj:89)
at metabase.sync.util$with_duplicate_ops_prevented$fn__55872.invoke(util.clj:68)
at metabase.sync.util$do_sync_operation.invokeStatic(util.clj:182)
at metabase.sync.util$do_sync_operation.invoke(util.clj:179)
at metabase.sync.field_values$fn__85118$update_field_values_BANG___85123$fn__85124.invoke(field_values.clj:121)
at metabase.sync.field_values$fn__85118$update_field_values_BANG___85123.invoke(field_values.clj:117)
at metabase.api.database$fn__95106$fn__95107$fn__95108.invoke(database.clj:1011)
at clojure.core$binding_conveyor_fn$fn__5823.invoke(core.clj:2047)
at clojure.lang.AFn.call(AFn.java:18)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got CLOB

    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:702)
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:608)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1248)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:1041)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:443)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:518)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:156)
    at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:963)
    at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1205)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1135)
    at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1472)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1343)
    at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2198)
    at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2147)
    at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:330)
    at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)
    at metabase.driver.sql_jdbc.execute$fn__71783.invokeStatic(execute.clj:384)
    at metabase.driver.sql_jdbc.execute$fn__71783.invoke(execute.clj:382)
    at clojure.lang.MultiFn.invoke(MultiFn.java:239)
    at metabase.driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:392)
    at metabase.driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invoke(execute.clj:389)
    at metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__71858.invoke(execute.clj:503)
    ... 124 more

Caused by: Error : 932, Position : 152, SQL = -- Metabase
SELECT * FROM (SELECT "DEMOUSER"."TAPI_SUBSTANCE"."ADDITIONALINFORMATION" "ADDITIONALINFORMATION" FROM "DEMOUSER"."TAPI_SUBSTANCE" GROUP BY "DEMOUSER"."TAPI_SUBSTANCE"."ADDITIONALINFORMATION" ORDER BY "DEMOUSER"."TAPI_SUBSTANCE"."ADDITIONALINFORMATION" ASC) WHERE rownum <= 1000, Original SQL = -- Metabase
SELECT * FROM (SELECT "DEMOUSER"."TAPI_SUBSTANCE"."ADDITIONALINFORMATION" "ADDITIONALINFORMATION" FROM "DEMOUSER"."TAPI_SUBSTANCE" GROUP BY "DEMOUSER"."TAPI_SUBSTANCE"."ADDITIONALINFORMATION" ORDER BY "DEMOUSER"."TAPI_SUBSTANCE"."ADDITIONALINFORMATION" ASC) WHERE rownum <= 1000, Error Message = ORA-00932: inconsistent datatypes: expected - got CLOB

    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:710)
    ... 145 more

2023-07-13 09:37:02,449 ERROR models.field-values :: Error fetching field values
clojure.lang.ExceptionInfo: Error executing query: ORA-00932: inconsistent datatypes: expected - got BLOB
{:driver :oracle, :sql ["-- Metabase" "SELECT" " *" "FROM" " (" " SELECT" " "DEMOUSER"."TAPI_SUBSTANCE"."SUBSTANCESTRUCTUREGRAPHIC" "SUBSTANCESTRUCTUREGRAPHIC"" " FROM" " "DEMOUSER"."TAPI_SUBSTANCE"" " GROUP BY" " "DEMOUSER"."TAPI_SUBSTANCE"."SUBSTANCESTRUCTUREGRAPHIC"" " ORDER BY" " "DEMOUSER"."TAPI_SUBSTANCE"."SUBSTANCESTRUCTUREGRAPHIC" ASC" " )" "WHERE" " rownum <= 1000"], :params nil, :type :invalid-query}
at metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__71858.invoke(execute.clj:505)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:502)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:489)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:497)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:489)
at metabase.driver.sql_jdbc$fn__105169.invokeStatic(sql_jdbc.clj:63)
at metabase.driver.sql_jdbc$fn__105169.invoke(sql_jdbc.clj:61)
at metabase.driver.oracle$fn__107270.invokeStatic(oracle.clj:509)
at metabase.driver.oracle$fn__107270.invoke(oracle.clj:507)
at clojure.lang.MultiFn.invoke(MultiFn.java:244)
at metabase.query_processor.context$executef.invokeStatic(context.clj:60)
at metabase.query_processor.context$executef.invoke(context.clj:49)
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:46)
at metabase.query_processor.context$runf.invoke(context.clj:40)
at metabase.query_processor.reducible$identity_qp.invokeStatic(reducible.clj:15)
at metabase.query_processor.reducible$identity_qp.invoke(reducible.clj:12)
at metabase.query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___69242.invoke(cache.clj:224)
at metabase.query_processor.middleware.permissions$check_query_permissions$fn__64714.invoke(permissions.clj:126)
at metabase.query_processor.middleware.mbql_to_native$mbql__GT_native$fn__68133.invoke(mbql_to_native.clj:24)
at metabase.query_processor$fn__70761$combined_post_process__70766$combined_post_process_STAR___70767.invoke(query_processor.clj:243)
at metabase.query_processor$fn__70761$combined_pre_process__70762$combined_pre_process_STAR___70763.invoke(query_processor.clj:240)
at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__69153$fn__69158.invoke(resolve_database_and_driver.clj:36)
at metabase.driver$do_with_driver.invokeStatic(driver.clj:90)
at metabase.driver$do_with_driver.invoke(driver.clj:86)
at metabase.query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__69153.invoke(resolve_database_and_driver.clj:35)
at metabase.query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__65024.invoke(fetch_source_query.clj:316)
at metabase.query_processor.middleware.store$initialize_store$fn__65202$fn__65203.invoke(store.clj:12)
at metabase.query_processor.store$do_with_store.invokeStatic(store.clj:47)
at metabase.query_processor.store$do_with_store.invoke(store.clj:41)
at metabase.query_processor.middleware.store$initialize_store$fn__65202.invoke(store.clj:11)
at metabase.query_processor.middleware.normalize_query$normalize$fn__69442.invoke(normalize_query.clj:25)
at metabase.query_processor.reducible$async_qp$qp_STAR___59523$thunk__59525.invoke(reducible.clj:103)
at metabase.query_processor.reducible$async_qp$qp_STAR___59523.invoke(reducible.clj:109)
at metabase.query_processor.reducible$async_qp$qp_STAR___59523.invoke(reducible.clj:94)
at metabase.query_processor.reducible$async_qp$qp_STAR___59523.invoke(reducible.clj:91)
at clojure.lang.AFn.applyToHelper(AFn.java:154)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$apply.invoke(core.clj:662)
at metabase.query_processor.reducible$sync_qp$qp_STAR___59535.doInvoke(reducible.clj:129)
at clojure.lang.RestFn.applyTo(RestFn.java:137)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.query_processor$process_query.invokeStatic(query_processor.clj:278)
at metabase.query_processor$process_query.doInvoke(query_processor.clj:272)
at clojure.lang.RestFn.invoke(RestFn.java:410)
at metabase.db.metadata_queries$qp_query$fn__77167.invoke(metadata_queries.clj:23)
at metabase.db.metadata_queries$qp_query.invokeStatic(metadata_queries.clj:22)
at metabase.db.metadata_queries$qp_query.invoke(metadata_queries.clj:20)
at metabase.db.metadata_queries$field_query.invokeStatic(metadata_queries.clj:33)
at metabase.db.metadata_queries$field_query.invoke(metadata_queries.clj:31)
at metabase.db.metadata_queries$fn__77184$field_distinct_values__77193$fn__77196.invoke(metadata_queries.clj:65)
at metabase.db.metadata_queries$fn__77184$field_distinct_values__77193.invoke(metadata_queries.clj:58)
at metabase.db.metadata_queries$fn__77184$field_distinct_values__77193$fn__77194.invoke(metadata_queries.clj:62)
at metabase.db.metadata_queries$fn__77184$field_distinct_values__77193.invoke(metadata_queries.clj:58)
at clojure.lang.Var.invoke(Var.java:384)
at metabase.models.field_values$distinct_values.invokeStatic(field_values.clj:306)
at metabase.models.field_values$distinct_values.invoke(field_values.clj:291)
at metabase.models.field_values$create_or_update_full_field_values_BANG_.invokeStatic(field_values.clj:333)
at metabase.models.field_values$create_or_update_full_field_values_BANG_.doInvoke(field_values.clj:325)
at clojure.lang.RestFn.invoke(RestFn.java:410)
at metabase.sync.field_values$fn__84967$update_field_values_for_field_BANG___84972$fn__84973.invoke(field_values.clj:31)
at metabase.sync.field_values$fn__84967$update_field_values_for_field_BANG___84972.invoke(field_values.clj:25)
at metabase.sync.field_values$fn__84998$update_field_values_for_table_BANG___85003$fn__85004$fn__85005$fn__85006.invoke(field_values.clj:56)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:161)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:154)
at metabase.sync.field_values$fn__84998$update_field_values_for_table_BANG___85003$fn__85004$fn__85005.invoke(field_values.clj:54)
at clojure.lang.PersistentVector.reduce(PersistentVector.java:343)
at clojure.core$reduce.invokeStatic(core.clj:6885)
at clojure.core$reduce.invoke(core.clj:6868)
at metabase.sync.field_values$fn__84998$update_field_values_for_table_BANG___85003$fn__85004.invoke(field_values.clj:53)
at metabase.sync.field_values$fn__84998$update_field_values_for_table_BANG___85003.invoke(field_values.clj:50)
at clojure.core$map$fn__5935.invoke(core.clj:2770)
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.boundedLength(RT.java:1790)
at clojure.lang.RestFn.applyTo(RestFn.java:130)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.sync.field_values$fn__85027$update_field_values_for_database_BANG___85032$fn__85033.invoke(field_values.clj:65)
at metabase.sync.field_values$fn__85027$update_field_values_for_database_BANG___85032.invoke(field_values.clj:62)
at metabase.sync.field_values$make_sync_field_values_steps$fn__85109.invoke(field_values.clj:114)
at clojure.lang.AFn.applyToHelper(AFn.java:154)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.sync.util$fn__55983$run_step_with_metadata__55988$fn__55992$fn__55994.doInvoke(util.clj:379)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:103)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:97)
at metabase.sync.util$with_start_and_finish_debug_logging.invokeStatic(util.clj:120)
at metabase.sync.util$with_start_and_finish_debug_logging.invoke(util.clj:117)
at metabase.sync.util$fn__55983$run_step_with_metadata__55988$fn__55992.invoke(util.clj:374)
at metabase.sync.util$fn__55983$run_step_with_metadata__55988.invoke(util.clj:369)
at metabase.sync.util$fn__56210$run_sync_operation__56215$fn__56216$fn__56224.invoke(util.clj:486)
at metabase.sync.util$fn__56210$run_sync_operation__56215$fn__56216.invoke(util.clj:484)
at metabase.sync.util$fn__56210$run_sync_operation__56215.invoke(util.clj:478)
at metabase.sync.field_values$fn__85118$update_field_values_BANG___85123$fn__85124$fn__85125.invoke(field_values.clj:124)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:161)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:154)
at clojure.core$partial$fn__5910.invoke(core.clj:2647)
at metabase.driver$fn__46820.invokeStatic(driver.clj:658)
at metabase.driver$fn__46820.invoke(driver.clj:658)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.sync.util$sync_in_context$fn__55903.invoke(util.clj:139)
at metabase.sync.util$with_db_logging_disabled$fn__55900.invoke(util.clj:130)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:103)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:97)
at metabase.sync.util$with_start_and_finish_logging$fn__55887.invoke(util.clj:115)
at metabase.sync.util$with_sync_events$fn__55882.invoke(util.clj:89)
at metabase.sync.util$with_duplicate_ops_prevented$fn__55872.invoke(util.clj:68)
at metabase.sync.util$do_sync_operation.invokeStatic(util.clj:182)
at metabase.sync.util$do_sync_operation.invoke(util.clj:179)
at metabase.sync.field_values$fn__85118$update_field_values_BANG___85123$fn__85124.invoke(field_values.clj:121)
at metabase.sync.field_values$fn__85118$update_field_values_BANG___85123.invoke(field_values.clj:117)
at metabase.api.database$fn__95106$fn__95107$fn__95108.invoke(database.clj:1011)
at clojure.core$binding_conveyor_fn$fn__5823.invoke(core.clj:2047)
at clojure.lang.AFn.call(AFn.java:18)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got BLOB

    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:702)
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:608)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1248)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:1041)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:443)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:518)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:156)
    at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:963)
    at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1205)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1135)
    at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1472)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1343)
    at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2198)
    at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2147)
    at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:330)
    at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)
    at metabase.driver.sql_jdbc.execute$fn__71783.invokeStatic(execute.clj:384)
    at metabase.driver.sql_jdbc.execute$fn__71783.invoke(execute.clj:382)
    at clojure.lang.MultiFn.invoke(MultiFn.java:239)
    at metabase.driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:392)
    at metabase.driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invoke(execute.clj:389)
    at metabase.driver.sql_jdbc.execute$execute_reducible_query$fn__71858.invoke(execute.clj:503)
    ... 124 more

Caused by: Error : 932, Position : 160, SQL = -- Metabase
SELECT * FROM (SELECT "DEMOUSER"."TAPI_SUBSTANCE"."SUBSTANCESTRUCTUREGRAPHIC" "SUBSTANCESTRUCTUREGRAPHIC" FROM "DEMOUSER"."TAPI_SUBSTANCE" GROUP BY "DEMOUSER"."TAPI_SUBSTANCE"."SUBSTANCESTRUCTUREGRAPHIC" ORDER BY "DEMOUSER"."TAPI_SUBSTANCE"."SUBSTANCESTRUCTUREGRAPHIC" ASC) WHERE rownum <= 1000, Original SQL = -- Metabase
SELECT * FROM (SELECT "DEMOUSER"."TAPI_SUBSTANCE"."SUBSTANCESTRUCTUREGRAPHIC" "SUBSTANCESTRUCTUREGRAPHIC" FROM "DEMOUSER"."TAPI_SUBSTANCE" GROUP BY "DEMOUSER"."TAPI_SUBSTANCE"."SUBSTANCESTRUCTUREGRAPHIC" ORDER BY "DEMOUSER"."TAPI_SUBSTANCE"."SUBSTANCESTRUCTUREGRAPHIC" ASC) WHERE rownum <= 1000, Error Message = ORA-00932: inconsistent datatypes: expected - got BLOB

    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:710)
    ... 145 more

2023-07-13 09:37:03,294 ERROR models.field-values :: Error fetching field values
clojure.lang.ExceptionInfo: Error executing query: ORA-00932: inconsistent datatypes: expected - got CLOB
{:driver :oracle, :sql ["-- Metabase" "SELECT" " *" "FROM" " (" " SELECT" " "DEMOUSER"."OTEMP_DRUG_PRODUCT"."DRUGPRODUCTDESCRIPTION" "DRUGPRODUCTDESCRIPTION"" " FROM" " "DEMOUSER"."OTEMP_DRUG_PRODUCT"" " GROUP BY" " "DEMOUSER"."OTEMP_DRUG_PRODUCT"."DRUGPRODUCTDESCRIPTION"" " ORDER BY" " "DEMOUSER"."OTEMP_DRUG_PRODUCT"."DRUGPRODUCTDESCRIPTION" ASC" " )" "WHERE" " rownum <= 1000"], :params nil, :type :invalid-query}

wee seem to be supporting clobs since v32: Support Oracle CLOB data type · Issue #9026 · metabase/metabase · GitHub, is it possible that this is a custom data type?

I found the automated re-scan works as expected if left to default 1 per day.

When I tried to change it to 1 per hour, the re-scan did not produce expected results, meaning data added since last update does not show in Metabase.
Manual re-scan does not work as expected, meaning data added since last update does not show in Metabase.

Any suggestions? One update per day will not be sufficient for what we want to do.

Have you checked the notify endpoint ?

I have very limited experience with Metabase and am just running the free open source version as a JAR on my local machine. Could you please provide a little more information about what you are suggesting I check/look for?