Metabase version: v0.37.8
Oracle version: Oracle 19.11
An Oracle view is used to populate a filter. The Metabase report works fine without adding the filter.
After selecting a value from the filter, the report gives error "Invalid column index".
When an Oracle table with the same records is used to populate the filter, the filter works as expected, i.e., selecting a value in the filter and the report filters the result as expected.
Has anyone experience the error?
Hi @robinL
Post "Diagnostic Info" from Admin > Troubleshooting.
Post the detailed stacktrace error from Admin > Troubleshooting > Logs.
Which version of ojdbc8.jar are you using?
Hi @flamber,
Here is the info:
Diagnostic info
{
"browser-info": {
"language": "en-CA",
"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": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.9.1+1-LTS",
"java.vendor": "Red Hat, Inc.",
"java.vendor.url": https://www.redhat.com/,
"java.version": "11.0.9.1",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.9.1+1-LTS",
"os.name": "Linux",
"os.version": "4.18.0-240.10.1.el8_3.x86_64",
"user.language": "en",
"user.timezone": "America/Vancouver"
},
"metabase-info": {
"databases": [
"h2",
"oracle"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "8.0.23"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.6.2"
}
},
"run-mode": "prod",
"version": {
"date": "2021-01-20",
"tag": "v0.37.8-SNAPSHOT",
"branch": "?",
"hash": "2b034aa"
},
"settings": {
"report-timezone": null
}
}
}
Stack trace from logs: some app info are replaced with ***
[bd1dcff8-50f9-49ba-bcfd-8be7b874d18c] 2021-08-10T10:58:55-07:00 INFO metabase.api.card Question's average execution duration is 1.1 s; using 'magic' TTL of 11.0 s 
[bd1dcff8-50f9-49ba-bcfd-8be7b874d18c] 2021-08-10T10:58:56-07:00 INFO metabase.query-processor.middleware.cache Query took 1.2 s to run; minimum for cache eligibility is 60.0 s
[bd1dcff8-50f9-49ba-bcfd-8be7b874d18c] 2021-08-10T10:58:56-07:00 DEBUG metabase.middleware.log POST /api/card/379/query 202 [ASYNC: completed] 1.2 s (10 DB calls) App DB connections: 1/15 Jetty threads: 3/50 (1 idle, 0 queued) (133 total active threads) Queries in flight: 1 (0 queued)
[bd1dcff8-50f9-49ba-bcfd-8be7b874d18c] 2021-08-10T10:59:00-07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 2,
:started_at #t "2021-08-10T10:59:00.293870-07:00[America/Vancouver]",
:state "99999",
:json_query
{:constraints {:max-results 1000000, :max-results-bare-rows 1000000},
:type :native,
:middleware {:js-int-to-string? true},
:native
{:template-tags
{"date" {:id "1217c792-ebec-67e3-0889-17391729535b", :name "date", :display-name "Date", :type :dimension, :dimension [:field-id 411], :widget-type :date/month-year, :default nil},
"***"
{:id "056bdf23-3e7a-e30e-41e1-6ad329dd48e5",
:name "***",
:display-name "*",
:type :dimension,
:dimension [:field-id 1045],
:widget-type :category,
:default nil},
"OfficeLoc" {:id "4d56ada3-f4a3-9c31-44e2-d9e2adc8d4a6", :name "", :display-name "", :type :dimension, :dimension [:field-id 1044], :widget-type :category, :default nil}},
:query
" QUERY REMOVED **,
:database 2,
:parameters [{:type "category", :target ["dimension" ["template-tag" ""]], :value [""]}],
:async? true,
:cache-ttl nil},
:status :failed,
:class java.sql.SQLException,
:stacktrace
["oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:4889)"
"oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:7688)"
"oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:7619)"
"oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8374)"
"oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:8349)"
"oracle.jdbc.driver.OraclePreparedStatementWrapper.setObject(OraclePreparedStatementWrapper.java:221)"
"com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.setObject(NewProxyPreparedStatement.java:1008)"
"--> driver.sql_jdbc.execute$set_object.invokeStatic(execute.clj:180)"
"driver.sql_jdbc.execute$set_object.invoke(execute.clj:177)"
"driver.sql_jdbc.execute$fn__36149.invokeStatic(execute.clj:189)"
"driver.sql_jdbc.execute$fn__36149.invoke(execute.clj:187)"
"driver.sql_jdbc.execute$set_parameters_BANG_$fn__36167.invoke(execute.clj:233)"
"driver.sql_jdbc.execute$set_parameters_BANG_.invokeStatic(execute.clj:229)"
"driver.sql_jdbc.execute$set_parameters_BANG_.invoke(execute.clj:225)"
"driver.oracle$eval579$fn__580.invoke(oracle.clj:323)"
"driver.sql_jdbc.execute$prepared_statement_STAR_.invokeStatic(execute.clj:256)"
"driver.sql_jdbc.execute$prepared_statement_STAR_.invoke(execute.clj:253)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:389)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:376)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:385)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:376)"
"driver.sql_jdbc$fn__82103.invokeStatic(sql_jdbc.clj:49)"
"driver.sql_jdbc$fn__82103.invoke(sql_jdbc.clj:47)"
"driver.oracle$eval551$fn__552.invoke(oracle.clj:260)"
"query_processor.context$executef.invokeStatic(context.clj:59)"
"query_processor.context$executef.invoke(context.clj:48)"
"query_processor.context.default$default_runf.invokeStatic(default.clj:70)"
"query_processor.context.default$default_runf.invoke(default.clj:68)"
"query_processor.context$runf.invokeStatic(context.clj:45)"
"query_processor.context$runf.invoke(context.clj:39)"
"query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
"query_processor.reducible$pivot.invoke(reducible.clj:31)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__45802.invoke(mbql_to_native.clj:26)"
"query_processor.middleware.check_features$check_features$fn__45078.invoke(check_features.clj:42)"
"query_processor.middleware.limit$limit$fn__45788.invoke(limit.clj:38)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__44731.invoke(cache.clj:214)"
"query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__45967.invoke(optimize_datetime_filters.clj:133)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__43878.invoke(auto_parse_filter_values.clj:44)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__40532.invoke(wrap_value_literals.clj:149)"
"query_processor.middleware.annotate$add_column_info$fn__40417.invoke(annotate.clj:575)"
"query_processor.middleware.permissions$check_query_permissions$fn__44953.invoke(permissions.clj:70)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__46485.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__45151.invoke(cumulative_aggregations.clj:61)"
"metabase_enterprise.sandbox.query_processor.middleware.row_level_restrictions$apply_row_level_permissions$fn__47752.invoke(row_level_restrictions.clj:292)"
"query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__46722.invoke(resolve_joined_fields.clj:36)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__47041.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__43476.invoke(add_implicit_joins.clj:254)"
"query_processor.middleware.large_int_id$convert_id_to_string$fn__45763.invoke(large_int_id.clj:44)"
"query_processor.middleware.format_rows$format_rows$fn__45743.invoke(format_rows.clj:75)"
"query_processor.middleware.desugar$desugar$fn__45217.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__44237.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__44755.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__43024.invoke(add_dimension_projections.clj:316)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__43227.invoke(add_implicit_clauses.clj:141)"
"metabase_enterprise.sandbox.query_processor.middleware.row_level_restrictions$apply_row_level_permissions$fn__47752.invoke(row_level_restrictions.clj:292)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__43625.invoke(add_source_metadata.clj:105)"
"metabase_enterprise.sandbox.query_processor.middleware.column_level_perms_check$maybe_apply_column_level_perms_check$fn__47454.invoke(column_level_perms_check.clj:24)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46682.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43825.invoke(auto_bucket_datetimes.clj:140)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44802.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__46467.invoke(parameters.clj:114)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44854.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__45473.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__43634.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47403.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46693$fn__46697.invoke(resolve_database_and_driver.clj:33)"
"driver$do_with_driver.invokeStatic(driver.clj:61)"
"driver$do_with_driver.invoke(driver.clj:57)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46693.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45691.invoke(fetch_source_query.clj:267)"
"query_processor.middleware.store$initialize_store$fn__47412$fn__47413.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:46)"
"query_processor.store$do_with_store.invoke(store.clj:40)"
"query_processor.middleware.store$initialize_store$fn__47412.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__47421.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__45815.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__43494.invoke(add_rows_truncated.clj:36)"
"metabase_enterprise.audit.query_processor.middleware.handle_audit_queries$handle_internal_queries$fn__31546.invoke(handle_audit_queries.clj:165)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47388.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__45094.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__46556.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__45037.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___33016$thunk__33017.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___33016$fn__33019.invoke(reducible.clj:108)"],
:context :question,
:error "Invalid column index",
:row_count 0,
:running_time 0,
:data {:rows [], :cols []}}
Ojdbc is version 19.3
@robinL You are using some old custom build of Metabase. I would recommend that you try with the official latest release: https://github.com/metabase/metabase/releases/latest
Make sure you backup before upgrading.