Automated rescan works as expected but manual doesn't work?

1

Metabase v0.46.6 connected to Oracle database.

The automated re-scan, when set to default once per day, works as expected.

Manual sync and re-scan values does not work; data that I've added to the base tables since the last re-scan does not show up. Log shows error on CLOB (see copy of log file below)

I found the option to change the automated re-scan to run once per hour, and tried that setting but that didn't produce expected result either. When I changed setting back to default, update started working (once per day) again.

I really need the manual update to work, once an hour isn't really sufficient, but I just tried it to see if it would help me figure out the issue.

Any suggestions on how to get around this?

... 124 more
Caused by: Error : 932, Position : 152, SQL = -- Metabase
SELECT * FROM (SELECT "DEMOUSER"."TDRUG_PRODUCT"."DRUGPRODUCTDESCRIPTION" "DRUGPRODUCTDESCRIPTION" FROM "DEMOUSER"."TDRUG_PRODUCT" GROUP BY "DEMOUSER"."TDRUG_PRODUCT"."DRUGPRODUCTDESCRIPTION" ORDER BY "DEMOUSER"."TDRUG_PRODUCT"."DRUGPRODUCTDESCRIPTION" ASC) WHERE rownum <= 1000, Original SQL = -- Metabase
SELECT * FROM (SELECT "DEMOUSER"."TDRUG_PRODUCT"."DRUGPRODUCTDESCRIPTION" "DRUGPRODUCTDESCRIPTION" FROM "DEMOUSER"."TDRUG_PRODUCT" GROUP BY "DEMOUSER"."TDRUG_PRODUCT"."DRUGPRODUCTDESCRIPTION" ORDER BY "DEMOUSER"."TDRUG_PRODUCT"."DRUGPRODUCTDESCRIPTION" 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-17 07:52:42,642 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"."TDRUG_PRODUCT_PART"."ADDITIONALINFORMATION" "ADDITIONALINFORMATION"" " FROM" " "DEMOUSER"."TDRUG_PRODUCT_PART"" " GROUP BY" " "DEMOUSER"."TDRUG_PRODUCT_PART"."ADDITIONALINFORMATION"" " ORDER BY" " "DEMOUSER"."TDRUG_PRODUCT_PART"."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)

2

Seems there’s a CLOB there, which is breaking the process, have you checked the notify api to do the automation of this ?

3

Is there some place I can get more information on what this means or how to do this? I'm running metabase JAR on my local machine; the free open source version. I found info on working with the API, but I'm not a developer and this is a little out of my comfort zone.

4

Is there a way to force Metabase to ignore the CLOB columns in the table? I do not plan to use them in the questions/dashboards.

5

As a test in my Oracle database I added a new record to the Oracle table, then in Metabase did manual sync then rescan.

The new record does not show Metabase.

Then I created a view of the table in my Oracle database excluding the CLOB column; I confirm the new record is included in the view in Oracle.

Then in Metabase I did a manual sync then rescan. The view now appears in Metabase, AND the new record shows in both the base table and the view in Metabase.

I add a new record to the base table in Oracle. The record shows in the table and the view in Oracle.

In Metabase I do a manual sync then rescan. In Metabase the new record does not appear in either the view or the table.

I drop the view from my Oracle database. Add a new record to my Oracle table.

In Metabase I do a manual sync then rescan. The view is gone from Metabase as expected AND the new record shows in the table in Metabase.

Any suggestions on how to handle this?