Hello there, I have an integration In Airbyte that extract information from my webpage that has a woocommerce plugin in wordpress.
I store the information in a postgres database. The thing is that when I load the information from metabase it gives me this error:
No fields found for table "casanatalia_orders".
See the image below:
My diagnostic info is this:
{
"browser-info": {
"language": "en-US",
"platform": "Linux x86_64",
"userAgent": "Mozilla/5.0 (X11; Linux x86_64; rv:130.0) Gecko/20100101 Firefox/130.0",
"vendor": ""
},
"metabase-info": {
"databases": [
"mysql",
"postgres"
],
"run-mode": "prod",
"plan-alias": "",
"version": {
"date": "2024-09-16",
"tag": "v0.50.26",
"hash": "5a65f46"
},
"settings": {
"report-timezone": "America/Argentina/Buenos_Aires"
},
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "14.13 (Debian 14.13-1.pgdg120+1)"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.7.3"
}
}
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.24+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.24",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.24+8",
"os.name": "Linux",
"os.version": "5.15.0-121-generic",
"user.language": "en",
"user.timezone": "GMT"
}
}
And this is the logs when I load the table:
[e4ff8ca1-b3b6-486b-b3d5-bb049c9f4146] 2024-09-19T17:39:43-03:00 ERROR metabase.models.query.permissions ,clojure.lang.ExceptionInfo: Error calculating permissions for query {:query {:database 10, :type :query, :query {:source-table 5641}}}, at metabase.models.query.permissions$legacy_mbql_required_perms.invokeStatic(permissions.clj:153), at metabase.models.query.permissions$legacy_mbql_required_perms.invoke(permissions.clj:131), at metabase.models.query.permissions$required_perms_for_query.invokeStatic(permissions.clj:180), at metabase.models.query.permissions$required_perms_for_query.doInvoke(permissions.clj:171), at clojure.lang.RestFn.invoke(RestFn.java:410), at metabase.models.query.permissions$can_run_query_QMARK_.invokeStatic(permissions.clj:266), at metabase.models.query.permissions$can_run_query_QMARK_.invoke(permissions.clj:263), at metabase.models.query.permissions$can_query_table_QMARK_.invokeStatic(permissions.clj:272), at metabase.models.query.permissions$can_query_table_QMARK_.invoke(permissions.clj:269), at metabase.events.view_log$publish_event_BANG__primary_method_metabase_events_view_log_table_read.invokeStatic(view_log.clj:154), at metabase.events.view_log$publish_event_BANG__primary_method_metabase_events_view_log_table_read.invoke(view_log.clj:141), at methodical.util.FnWithMeta.invoke(util.clj:46), at methodical.impl.combo.operator$invoke_fn$fn__18297.invoke(operator.clj:69), at methodical.impl.combo.operator$fn__18318$fn__18319$fn__18320.invoke(operator.clj:112), at clojure.core$comp$fn__5876.invoke(core.clj:2587), at metabase.events$publish_event_BANG__around_method_default$fn__39544.invoke(events.clj:132), at metabase.events$publish_event_BANG__around_method_default.invokeStatic(events.clj:129), at metabase.events$publish_event_BANG__around_method_default.invoke(events.clj:108), at methodical.impl.combo.common$partial_STAR_$fn__18182.invoke(common.clj:12), at methodical.util.FnWithMeta.invoke(util.clj:46), at methodical.impl.standard$invoke_multifn.invokeStatic(standard.clj:55), at methodical.impl.standard$invoke_multifn.invoke(standard.clj:47), at methodical.impl.standard.StandardMultiFn.invoke(standard.clj:210), at metabase.api.dataset$run_streaming_query.invokeStatic(dataset.clj:66), at metabase.api.dataset$run_streaming_query.doInvoke(dataset.clj:50), at clojure.lang.RestFn.invoke(RestFn.java:410), at metabase.api.dataset$fn__94140.invokeStatic(dataset.clj:90), at metabase.api.dataset$fn__94140.invoke(dataset.clj:86), at compojure.core$wrap_response$fn__52764.invoke(core.clj:160), at compojure.core$wrap_route_middleware$fn__52748.invoke(core.clj:132), at compojure.core$wrap_route_info$fn__52753.invoke(core.clj:139), at compojure.core$wrap_route_matches$fn__52757.invoke(core.clj:151), at clojure.lang.Var.invoke(Var.java:393), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$wrap_route_matches$fn__52757.invoke(core.clj:152), at clojure.lang.Var.invoke(Var.java:393), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776.invoke(core.clj:200), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at metabase.server.middleware.auth$enforce_authentication$fn__97435.invoke(auth.clj:18), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776.invoke(core.clj:200), at compojure.core$make_context$handler__52804.invoke(core.clj:290), at compojure.core$make_context$fn__52808.invoke(core.clj:300), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$make_context$fn__52808.invoke(core.clj:301), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$make_context$fn__52808.invoke(core.clj:301), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$make_context$fn__52808.invoke(core.clj:301), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$make_context$fn__52808.invoke(core.clj:301), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$make_context$fn__52808.invoke(core.clj:301), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$make_context$fn__52808.invoke(core.clj:301), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$make_context$fn__52808.invoke(core.clj:301), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$make_context$fn__52808.invoke(core.clj:301), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$make_context$fn__52808.invoke(core.clj:301), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$make_context$fn__52808.invoke(core.clj:301), at clojure.lang.AFn.applyToHelper(AFn.java:160), at clojure.lang.AFn.applyTo(AFn.java:144), at clojure.lang.AFunction$1.doInvoke(AFunction.java:31), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$wrap_route_matches$fn__52757.invoke(core.clj:153), at clojure.lang.Var.invoke(Var.java:393), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at metabase.api.routes$fn__103111$fn__103114.invoke(routes.clj:73), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776.invoke(core.clj:200), at clojure.lang.AFn.applyToHelper(AFn.java:160), 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.server.routes$fn__103391$fn__103392.doInvoke(routes.clj:73), at clojure.lang.RestFn.invoke(RestFn.java:436), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776.invoke(core.clj:200), at compojure.core$make_context$handler__52804.invoke(core.clj:290), at compojure.core$make_context$fn__52808.invoke(core.clj:300), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$wrap_route_matches$fn__52757.invoke(core.clj:153), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$wrap_route_matches$fn__52757.invoke(core.clj:153), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$wrap_route_matches$fn__52757.invoke(core.clj:153), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at compojure.core$wrap_route_matches$fn__52757.invoke(core.clj:153), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776$f__52777$respond_SINGLEQUOTE___52778.invoke(core.clj:197), at metabase.server.routes$fn__103374$fn__103376.invoke(routes.clj:47), at compojure.core$routes$fn__52776$f__52777.invoke(core.clj:198), at compojure.core$routes$fn__52776.invoke(core.clj:200), at metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__99469.invoke(exceptions.clj:107), at metabase.server.middleware.exceptions$catch_api_exceptions$fn__99466.invoke(exceptions.clj:96), at metabase.server.middleware.log$log_api_call$fn__103678$fn__103679$fn__103680.invoke(log.clj:233), at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invokeStatic(diagnostic.clj:18), at metabase.driver.sql_jdbc.execute.diagnostic$do_with_diagnostic_info.invoke(diagnostic.clj:12), at metabase.server.middleware.log$log_api_call$fn__103678$fn__103679.invoke(log.clj:224), at toucan2.execute$do_with_call_counts.invokeStatic(execute.clj:112), at toucan2.execute$do_with_call_counts.invoke(execute.clj:103), at metabase.server.middleware.log$log_api_call$fn__103678.invoke(log.clj:223), at metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__106968.invoke(browser_cookie.clj:40), at metabase.server.middleware.security$add_security_headers$fn__99425.invoke(security.clj:246), at ring.middleware.json$wrap_json_body$fn__107227.invoke(json.clj:64), at metabase.server.middleware.offset_paging$handle_paging$fn__87789.invoke(offset_paging.clj:43), at metabase.server.middleware.json$wrap_streamed_json_response$fn__54392.invoke(json.clj:83), at ring.middleware.keyword_params$wrap_keyword_params$fn__107316.invoke(keyword_params.clj:55), at ring.middleware.params$wrap_params$fn__107335.invoke(params.clj:77), at metabase.server.middleware.misc$maybe_set_site_url$fn__64236.invoke(misc.clj:59), at metabase.server.middleware.session$reset_session_timeout$fn__65787.invoke(session.clj:548), at metabase.server.middleware.session$bind_current_user$fn__65753$fn__65754.invoke(session.clj:443), at metabase.server.middleware.session$do_with_current_user.invokeStatic(session.clj:422), at metabase.server.middleware.session$do_with_current_user.invoke(session.clj:405), at metabase.server.middleware.session$bind_current_user$fn__65753.invoke(session.clj:442), at metabase.server.middleware.session$wrap_current_user_info$fn__65734.invoke(session.clj:381), at metabase.server.middleware.session$wrap_session_id$fn__65706.invoke(session.clj:259), at metabase.server.middleware.auth$wrap_static_api_key$fn__97443.invoke(auth.clj:32), at ring.middleware.cookies$wrap_cookies$fn__107155.invoke(cookies.clj:200), at metabase.server.middleware.misc$add_content_type$fn__64218.invoke(misc.clj:28), at metabase.server.middleware.misc$disable_streaming_buffering$fn__64244.invoke(misc.clj:75), at ring.middleware.gzip$wrap_gzip$fn__107197.invoke(gzip.clj:86), at metabase.server.middleware.misc$bind_request$fn__64247.invoke(misc.clj:91), at metabase.server.middleware.ssl$redirect_to_https_middleware$fn__106984.invoke(ssl.clj:51), at metabase.server$async_proxy_handler$fn__71978.invoke(server.clj:77), at metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source), at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:173), at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122), at org.eclipse.jetty.server.Server.handle(Server.java:563), at org.eclipse.jetty.server.HttpChannel$RequestDispatchable.dispatch(HttpChannel.java:1598), at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:753), at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:501), at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:287), at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:314), at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100), at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53), at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:421), at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:390), at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:277), at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.run(AdaptiveExecutionStrategy.java:199), at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:411), at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:969), at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.doRunJob(QueuedThreadPool.java:1194), at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1149), at java.base/java.lang.Thread.run(Unknown Source),Caused by: clojure.lang.ExceptionInfo: Error preprocessing query in metabase.query_processor.preprocess$ensure_legacy$fn__67746@59e5482d: No fields found for table "casanatalia_orders". {:fn #object[metabase.query_processor.preprocess$ensure_legacy$fn__67746 0x59e5482d "metabase.query_processor.preprocess$ensure_legacy$fn__67746@59e5482d"], :query {:database 10, :type :query, :query {:source-table 5641}}, :type :qp}, at metabase.query_processor.preprocess$preprocess$fn__67754$fn__67755.invoke(preprocess.clj:133), at clojure.lang.PersistentVector.reduce(PersistentVector.java:343), at clojure.core$transduce.invokeStatic(core.clj:6947), at clojure.core$transduce.invoke(core.clj:6934), at metabase.query_processor.preprocess$preprocess$fn__67754.invoke(preprocess.clj:119), at metabase.query_processor.setup$do_with_canceled_chan$fn__67239.invoke(setup.clj:189), at metabase.query_processor.setup$do_with_database_local_settings$fn__67234.invoke(setup.clj:181), at metabase.query_processor.setup$do_with_driver$fn__67229$fn__67230.invoke(setup.clj:166), at metabase.driver$do_with_driver.invokeStatic(driver.clj:104), at metabase.driver$do_with_driver.invoke(driver.clj:99), at metabase.query_processor.setup$do_with_driver$fn__67229.invoke(setup.clj:165), at metabase.query_processor.setup$do_with_metadata_provider$fn__67222$fn__67225.invoke(setup.clj:151), at metabase.query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:170), at metabase.query_processor.store$do_with_metadata_provider.invoke(store.clj:150), at metabase.query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:159), at metabase.query_processor.store$do_with_metadata_provider.invoke(store.clj:150), at metabase.query_processor.setup$do_with_metadata_provider$fn__67222.invoke(setup.clj:150), at metabase.query_processor.setup$do_with_resolved_database$fn__67216.invoke(setup.clj:128), at metabase.query_processor.setup$do_with_qp_setup.invokeStatic(setup.clj:232), at metabase.query_processor.setup$do_with_qp_setup.invoke(setup.clj:216), at metabase.query_processor.preprocess$preprocess.invokeStatic(preprocess.clj:118), at metabase.query_processor.preprocess$preprocess.invoke(preprocess.clj:114), at clojure.lang.Var.invoke(Var.java:384), at metabase.models.query.permissions$preprocess_query$fn__66055.invoke(permissions.clj:105), at metabase.server.middleware.session$do_with_current_user.invokeStatic(session.clj:422), at metabase.server.middleware.session$do_with_current_user.invoke(session.clj:405), at metabase.models.query.permissions$preprocess_query.invokeStatic(permissions.clj:104), at metabase.models.query.permissions$preprocess_query.invoke(permissions.clj:100), at metabase.models.query.permissions$legacy_mbql_required_perms.invokeStatic(permissions.clj:139), ... 213 more,Caused by: clojure.lang.ExceptionInfo: No fields found for table "casanatalia_orders". {:table-id 5641, :type :invalid-query}, at metabase.query_processor.middleware.add_implicit_clauses$sorted_implicit_fields_for_table.invokeStatic(add_implicit_clauses.clj:36), at metabase.query_processor.middleware.add_implicit_clauses$sorted_implicit_fields_for_table.invoke(add_implicit_clauses.clj:30), at metabase.query_processor.middleware.add_implicit_clauses$add_implicit_fields.invokeStatic(add_implicit_clauses.clj:100), at metabase.query_processor.middleware.add_implicit_clauses$add_implicit_fields.invoke(add_implicit_clauses.clj:93), at metabase.query_processor.middleware.add_implicit_clauses$add_implicit_mbql_clauses$fn__61101.invoke(add_implicit_clauses.clj:177), at clojure.walk$walk.invokeStatic(walk.clj:50), at clojure.walk$postwalk.invokeStatic(walk.clj:53), at clojure.walk$postwalk.invoke(walk.clj:53), at metabase.query_processor.middleware.add_implicit_clauses$add_implicit_mbql_clauses.invokeStatic(add_implicit_clauses.clj:170), at metabase.query_processor.middleware.add_implicit_clauses$add_implicit_mbql_clauses.invoke(add_implicit_clauses.clj:167), at clojure.core$update.invokeStatic(core.clj:6232), at clojure.core$update.invoke(core.clj:6224), at metabase.query_processor.middleware.add_implicit_clauses$add_implicit_clauses.invokeStatic(add_implicit_clauses.clj:187), at metabase.query_processor.middleware.add_implicit_clauses$add_implicit_clauses.invoke(add_implicit_clauses.clj:181), at clojure.lang.Var.invoke(Var.java:384), at metabase.query_processor.preprocess$ensure_legacy$fn__67746.invoke(preprocess.clj:62), at metabase.query_processor.preprocess$preprocess$fn__67754$fn__67755.invoke(preprocess.clj:128), ... 241 more
[e4ff8ca1-b3b6-486b-b3d5-bb049c9f4146] 2024-09-19T17:39:43-03:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: No fields found for table "casanatalia_orders".
{:database_id 10,
:started_at #t "2024-09-19T20:39:43.460513Z[GMT]",
:via
[{:status :failed,
:class clojure.lang.ExceptionInfo,
:error
"Error preprocessing query in metabase.query_processor.preprocess$ensure_legacy$fn__67746@59e5482d: No fields found for table \"casanatalia_orders\".",
:stacktrace
["--> query_processor.preprocess$preprocess$fn__67754$fn__67755.invoke(preprocess.clj:133)"
"query_processor.preprocess$preprocess$fn__67754.invoke(preprocess.clj:119)"
"query_processor.setup$do_with_qp_setup.invokeStatic(setup.clj:225)"
"query_processor.setup$do_with_qp_setup.invoke(setup.clj:216)"
"query_processor.preprocess$preprocess.invokeStatic(preprocess.clj:118)"
"query_processor.preprocess$preprocess.invoke(preprocess.clj:114)"
"query_processor$process_query_STAR__STAR_.invokeStatic(query_processor.clj:44)"
"query_processor$process_query_STAR__STAR_.invoke(query_processor.clj:43)"
"query_processor.middleware.enterprise$fn__66824$handle_audit_app_internal_queries__66825$fn__66827.invoke(enterprise.clj:96)"
"query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__66835.invoke(enterprise.clj:103)"
"query_processor.middleware.process_userland_query$process_userland_query_middleware$fn__76807.invoke(process_userland_query.clj:198)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__76876.invoke(catch_exceptions.clj:128)"
"query_processor$process_query$fn__76913.invoke(query_processor.clj:78)"
"query_processor.setup$do_with_canceled_chan$fn__67239.invoke(setup.clj:187)"
"query_processor.setup$do_with_database_local_settings$fn__67234.invoke(setup.clj:181)"
"query_processor.setup$do_with_driver$fn__67229$fn__67230.invoke(setup.clj:166)"
"driver$do_with_driver.invokeStatic(driver.clj:104)"
"driver$do_with_driver.invoke(driver.clj:99)"
"query_processor.setup$do_with_driver$fn__67229.invoke(setup.clj:165)"
"query_processor.setup$do_with_metadata_provider$fn__67222$fn__67225.invoke(setup.clj:151)"
"query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:170)"
"query_processor.store$do_with_metadata_provider.invoke(store.clj:150)"
"query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:159)"
"query_processor.store$do_with_metadata_provider.invoke(store.clj:150)"
"query_processor.setup$do_with_metadata_provider$fn__67222.invoke(setup.clj:150)"
"query_processor.setup$do_with_resolved_database$fn__67216.invoke(setup.clj:128)"
"query_processor.setup$do_with_qp_setup.invokeStatic(setup.clj:232)"
"query_processor.setup$do_with_qp_setup.invoke(setup.clj:216)"
"query_processor$process_query.invokeStatic(query_processor.clj:76)"
"query_processor$process_query.invoke(query_processor.clj:69)"
"api.dataset$run_streaming_query$fn__94128.invoke(dataset.clj:84)"
"query_processor.streaming$_streaming_response$fn__70127$fn__70128$fn__70129.invoke(streaming.clj:176)"
"query_processor.streaming$_streaming_response$fn__70127$fn__70128.invoke(streaming.clj:174)"
"query_processor.streaming$do_with_streaming_rff.invokeStatic(streaming.clj:165)"
"query_processor.streaming$do_with_streaming_rff.invoke(streaming.clj:152)"
"query_processor.streaming$_streaming_response$fn__70127.invoke(streaming.clj:171)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:78)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:76)"
"async.streaming_response$do_f_async$task__52026.invoke(streaming_response.clj:97)"],
:error_type :qp,
:ex-data
{:fn
#object[metabase.query_processor.preprocess$ensure_legacy$fn__67746 0x59e5482d "metabase.query_processor.preprocess$ensure_legacy$fn__67746@59e5482d"],
:query
{:database 10,
:middleware {:js-int-to-string? true, :userland-query? true, :add-default-userland-constraints? true},
:info {:executed-by 15, :context :ad-hoc, :query-hash #object["[B" 0x7078a5a8 "[B@7078a5a8"]},
:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :query,
:query {:source-table 5641}},
:type :qp}}],
:action_id nil,
:error_type :invalid-query,
:json_query
{:database 10,
:query {:source-table 5641},
:type "query",
:parameters [],
:middleware {:js-int-to-string? true, :userland-query? true, :add-default-userland-constraints? true}},
:native nil,
:status :failed,
:class clojure.lang.ExceptionInfo,
:stacktrace
["--> query_processor.middleware.add_implicit_clauses$sorted_implicit_fields_for_table.invokeStatic(add_implicit_clauses.clj:36)"
"query_processor.middleware.add_implicit_clauses$sorted_implicit_fields_for_table.invoke(add_implicit_clauses.clj:30)"
"query_processor.middleware.add_implicit_clauses$add_implicit_fields.invokeStatic(add_implicit_clauses.clj:100)"
"query_processor.middleware.add_implicit_clauses$add_implicit_fields.invoke(add_implicit_clauses.clj:93)"
"query_processor.middleware.add_implicit_clauses$add_implicit_mbql_clauses$fn__61101.invoke(add_implicit_clauses.clj:177)"
"query_processor.middleware.add_implicit_clauses$add_implicit_mbql_clauses.invokeStatic(add_implicit_clauses.clj:170)"
"query_processor.middleware.add_implicit_clauses$add_implicit_mbql_clauses.invoke(add_implicit_clauses.clj:167)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses.invokeStatic(add_implicit_clauses.clj:187)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses.invoke(add_implicit_clauses.clj:181)"
"query_processor.preprocess$ensure_legacy$fn__67746.invoke(preprocess.clj:62)"
"query_processor.preprocess$preprocess$fn__67754$fn__67755.invoke(preprocess.clj:128)"
"query_processor.preprocess$preprocess$fn__67754.invoke(preprocess.clj:119)"
"query_processor.setup$do_with_qp_setup.invokeStatic(setup.clj:225)"
"query_processor.setup$do_with_qp_setup.invoke(setup.clj:216)"
"query_processor.preprocess$preprocess.invokeStatic(preprocess.clj:118)"
"query_processor.preprocess$preprocess.invoke(preprocess.clj:114)"
"query_processor$process_query_STAR__STAR_.invokeStatic(query_processor.clj:44)"
"query_processor$process_query_STAR__STAR_.invoke(query_processor.clj:43)"
"query_processor.middleware.enterprise$fn__66824$handle_audit_app_internal_queries__66825$fn__66827.invoke(enterprise.clj:96)"
"query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__66835.invoke(enterprise.clj:103)"
"query_processor.middleware.process_userland_query$process_userland_query_middleware$fn__76807.invoke(process_userland_query.clj:198)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__76876.invoke(catch_exceptions.clj:128)"
"query_processor$process_query$fn__76913.invoke(query_processor.clj:78)"
"query_processor.setup$do_with_canceled_chan$fn__67239.invoke(setup.clj:187)"
"query_processor.setup$do_with_database_local_settings$fn__67234.invoke(setup.clj:181)"
"query_processor.setup$do_with_driver$fn__67229$fn__67230.invoke(setup.clj:166)"
"driver$do_with_driver.invokeStatic(driver.clj:104)"
"driver$do_with_driver.invoke(driver.clj:99)"
"query_processor.setup$do_with_driver$fn__67229.invoke(setup.clj:165)"
"query_processor.setup$do_with_metadata_provider$fn__67222$fn__67225.invoke(setup.clj:151)"
"query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:170)"
"query_processor.store$do_with_metadata_provider.invoke(store.clj:150)"
"query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:159)"
"query_processor.store$do_with_metadata_provider.invoke(store.clj:150)"
"query_processor.setup$do_with_metadata_provider$fn__67222.invoke(setup.clj:150)"
"query_processor.setup$do_with_resolved_database$fn__67216.invoke(setup.clj:128)"
"query_processor.setup$do_with_qp_setup.invokeStatic(setup.clj:232)"
"query_processor.setup$do_with_qp_setup.invoke(setup.clj:216)"
"query_processor$process_query.invokeStatic(query_processor.clj:76)"
"query_processor$process_query.invoke(query_processor.clj:69)"
"api.dataset$run_streaming_query$fn__94128.invoke(dataset.clj:84)"
"query_processor.streaming$_streaming_response$fn__70127$fn__70128$fn__70129.invoke(streaming.clj:176)"
"query_processor.streaming$_streaming_response$fn__70127$fn__70128.invoke(streaming.clj:174)"
"query_processor.streaming$do_with_streaming_rff.invokeStatic(streaming.clj:165)"
"query_processor.streaming$do_with_streaming_rff.invoke(streaming.clj:152)"
"query_processor.streaming$_streaming_response$fn__70127.invoke(streaming.clj:171)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:78)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:76)"
"async.streaming_response$do_f_async$task__52026.invoke(streaming_response.clj:97)"],
:card_id nil,
:context :ad-hoc,
:error "No fields found for table \"casanatalia_orders\".",
:row_count 0,
:running_time 0,
:preprocessed nil,
:ex-data {:table-id 5641, :type :invalid-query},
:data {:rows [], :cols []}}
What can I do?
Cheers.