Getting error while running Custom Report

#1

Hello All,
I have custom report with the masked serial number of type MD5, whenever i add that column to custom report i a get a below error.
nth not supported on this type: SQLException

PLease help me on this .

I am in 0.32.7 Metabase
Centos 8

#2

Hi @sushant.naik
There must be more details in the log. What database are you using a data source?

#3

Hello @flamber
This is what i am getting in logs.

{:status :failed,
:class java.lang.UnsupportedOperationException,
:error “nth not supported on this type: SQLException”,
:stacktrace
(“clojure.lang.RT.nthFrom(RT.java:928)”
“clojure.lang.RT.nth(RT.java:893)”
“–> query_processor.middleware.annotate$native_cols$iter__32250__32254$fn__32255$fn__32256$iter__32257__32261$fn__32262$fn__32263.invoke(annotate.clj:50)”
“query_processor.middleware.annotate$native_cols$iter__32250__32254$fn__32255$fn__32256$iter__32257__32261$fn__32262.invoke(annotate.clj:49)”
“driver.common$values__GT_base_type.invokeStatic(common.clj:237)”
“driver.common$values__GT_base_type.invoke(common.clj:231)”
“query_processor.middleware.annotate$native_cols$iter__32250__32254$fn__32255$fn__32256.invoke(annotate.clj:49)”
“query_processor.middleware.annotate$native_cols$iter__32250__32254$fn__32255.invoke(annotate.clj:44)”
“query_processor.middleware.annotate$native_cols.invokeStatic(annotate.clj:44)”
“query_processor.middleware.annotate$native_cols.invoke(annotate.clj:39)”
“query_processor.middleware.annotate$add_native_column_info.invokeStatic(annotate.clj:58)”
“query_processor.middleware.annotate$add_native_column_info.invoke(annotate.clj:54)”
“query_processor.middleware.annotate$fn__32572$add_column_info_STAR___32577$fn__32584.invoke(annotate.clj:285)”
“query_processor.middleware.annotate$fn__32572$add_column_info_STAR___32577.invoke(annotate.clj:280)”
“query_processor.middleware.annotate$add_column_info$fn__32600.invoke(annotate.clj:303)”
“query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__34138.invoke(cumulative_aggregations.clj:57)”
“query_processor.middleware.limit$limit$fn__34631.invoke(limit.clj:19)”
“query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__40243.invoke(results_metadata.clj:86)”
“query_processor.middleware.format_rows$format_rows$fn__34619.invoke(format_rows.clj:26)”
“query_processor.middleware.add_dimension_projections$add_remapping$fn__31752.invoke(add_dimension_projections.clj:234)”
“query_processor.middleware.add_row_count_and_status$add_row_count_and_status$fn__32146.invoke(add_row_count_and_status.clj:16)”
“query_processor.middleware.driver_specific$process_query_in_context$fn__34380.invoke(driver_specific.clj:12)”
“query_processor.middleware.resolve_driver$resolve_driver$fn__37209.invoke(resolve_driver.clj:15)”
“query_processor.middleware.bind_effective_timezone$bind_effective_timezone$fn__33550$fn__33551.invoke(bind_effective_timezone.clj:9)”
“util.date$call_with_effective_timezone.invokeStatic(date.clj:88)”
“util.date$call_with_effective_timezone.invoke(date.clj:77)”
“query_processor.middleware.bind_effective_timezone$bind_effective_timezone$fn__33550.invoke(bind_effective_timezone.clj:8)”
“query_processor.middleware.store$initialize_store$fn__40268$fn__40269.invoke(store.clj:11)”
“query_processor.store$do_with_new_store.invokeStatic(store.clj:35)”
“query_processor.store$do_with_new_store.invoke(store.clj:31)”
“query_processor.middleware.store$initialize_store$fn__40268.invoke(store.clj:10)”
“query_processor.middleware.async$async__GT_sync$fn__33146.invoke(async.clj:19)”
“query_processor.middleware.async_wait$runnable$fn__33277.invoke(async_wait.clj:71)”),
:query
{:type “native”,
:native

#4

@sushant.naik
I’ve never seen that error before.

  1. Which database are you querying?
  2. Can you post your query?
  3. What’s the Field Type of that MD5 column?
  4. Is there any database that has a column type MD5 ?
#5

Hi @flamber,

Please find the below comments

  1. Which database are you querying?
    I am using Maria DB
  2. Can you post your query?
    i am just selecting the Masked Serial number of datatype varchar(32)
  3. What’s the Field Type of that MD5 column?
    varchar(32)
  4. Is there any database that has a column type MD5 ?
    No
#6

@sushant.naik
Things are getting lost in translation.

  1. I do not know what “Masked Serial” is. Where do you configure that?
  2. What’s the Field Type of the column in Metabase > Admin > Data Model > (database) > (table) > (column).
  3. Check your log to see if you can find the exact query - otherwise look in your MariaDB log.
#7

Hello @flamber

Thanks . I will have a look into it.