Metabase 0.46.6
WITH
cnpq AS (
SELECT
beneficiario,
id_processo,
nivel,
tipo,
fonte,
sexo,
SUM(valor_real) AS valor_acumulado
FROM
`tabelas.br_fl_mobilidade_internacional_capes_cnpq_view`
WHERE
fonte = 'CNPq'
AND sigla_pais_destino <> "BR"
GROUP BY
beneficiario,
id_processo,
nivel,
tipo,
fonte,
sexo),
bolsa_cnpq_acc AS (
SELECT
nivel,
tipo,
fonte,
sexo,
valor_acumulado,
b.ano_inicial
FROM
cnpq
JOIN (
SELECT
beneficiario,
id_processo,
MIN(ano) AS ano_inicial
FROM
`tabelas.br_fl_mobilidade_internacional_capes_cnpq_view`
GROUP BY
beneficiario,
id_processo ) AS b
ON
cnpq.id_processo = b.id_processo
AND cnpq.beneficiario = b.beneficiario),
bolsa_capes_acc AS (
SELECT
nivel,
tipo,
fonte,
sexo,
SUM(valor_real) as valor_acumulado,
ano AS ano_inicial,
FROM
`tabelas.br_fl_mobilidade_internacional_capes_cnpq_view`
WHERE
fonte = 'CAPES'
AND sigla_pais_destino <> "BR"
GROUP BY
beneficiario,
id_processo,
nivel,
tipo,
fonte,
sexo,
ano),
tb_final AS (
SELECT
*
FROM
bolsa_capes_acc
UNION ALL
SELECT * from bolsa_cnpq_acc)
select nivel, ano_inicial, (avg(valor_acumulado)) as media from tb_final
where nivel is not null [[and {{top20}}]] [[and {{area_conhecimento_fl}}]] [[and {{nivel}}]] [[and {{tipo}}]] [[and {{sexo}}]] [[and {{fonte}}]]
group by ano_inicial, nivel
It works perfectly
When applying a filter (sexo = "Feminino) I get the following error:
Log:
[bd8cc969-c3ac-49ff-bd4c-a36ed9070f22] 2023-07-21T12:53:37-03:00 DEBUG metabase.server.middleware.log GET /api/database 200 30.6 ms (3 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 15 Threads do Jetty: 3 / 50 (4 ocioso, 0 na fila) (141 total de threads ativas) Consultas ativas: 0 (0 na fila)
[bd8cc969-c3ac-49ff-bd4c-a36ed9070f22] 2023-07-21T12:54:23-03:00 ERROR metabase.models.field-values Erro ao buscar valores de campo
java.sql.SQLException: Connections could not be acquired from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
at metabase.driver.sql_jdbc.execute$fn__71653.invokeStatic(execute.clj:196)
at metabase.driver.sql_jdbc.execute$fn__71653.invoke(execute.clj:194)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:500)
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 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.ChunkedCons.chunkedNext(ChunkedCons.java:59)
at clojure.core$chunk_next.invokeStatic(core.clj:710)
at clojure.core$reduce1.invokeStatic(core.clj:944)
at clojure.core$reduce1.invokeStatic(core.clj:936)
at clojure.core$merge_with.invokeStatic(core.clj:3076)
at clojure.core$merge_with.doInvoke(core.clj:3068)
at clojure.lang.RestFn.applyTo(RestFn.java:139)
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.task.sync_databases$update_field_values_BANG_.invokeStatic(sync_databases.clj:98)
at metabase.task.sync_databases$update_field_values_BANG_.invoke(sync_databases.clj:88)
at metabase.task.sync_databases.UpdateFieldValues.execute(sync_databases.clj:104)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1507)
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685)
... 128 more
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "saevtreina"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:659)
at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:180)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:235)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:247)
at org.postgresql.Driver.makeConnection(Driver.java:434)
at org.postgresql.Driver.connect(Driver.java:291)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)
at metabase.connection_pool$proxy_data_source$reify__18090.getConnection(connection_pool.clj:29)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:161)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:147)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:202)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
[bd8cc969-c3ac-49ff-bd4c-a36ed9070f22] 2023-07-21T12:54:23-03:00 ERROR metabase.models.field-values Erro ao buscar valores de campo
java.sql.SQLException: Connections could not be acquired from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
at metabase.driver.sql_jdbc.execute$fn__71653.invokeStatic(execute.clj:196)
at metabase.driver.sql_jdbc.execute$fn__71653.invoke(execute.clj:194)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:500)
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 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.ChunkedCons.chunkedNext(ChunkedCons.java:59)
at clojure.core$chunk_next.invokeStatic(core.clj:710)
at clojure.core$reduce1.invokeStatic(core.clj:944)
at clojure.core$reduce1.invokeStatic(core.clj:936)
at clojure.core$merge_with.invokeStatic(core.clj:3076)
at clojure.core$merge_with.doInvoke(core.clj:3068)
at clojure.lang.RestFn.applyTo(RestFn.java:139)
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.task.sync_databases$update_field_values_BANG_.invokeStatic(sync_databases.clj:98)
at metabase.task.sync_databases$update_field_values_BANG_.invoke(sync_databases.clj:88)
at metabase.task.sync_databases.UpdateFieldValues.execute(sync_databases.clj:104)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1507)
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685)
... 128 more
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "saevtreina"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:659)
at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:180)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:235)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:247)
at org.postgresql.Driver.makeConnection(Driver.java:434)
at org.postgresql.Driver.connect(Driver.java:291)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)
at metabase.connection_pool$proxy_data_source$reify__18090.getConnection(connection_pool.clj:29)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:161)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:147)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:202)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
[bd8cc969-c3ac-49ff-bd4c-a36ed9070f22] 2023-07-21T12:54:27-03:00 INFO metabase.query-processor.card A duração média de execução da pergunta é 465.0 ms; usando TTL ' mágico ' de 1.6 mins 💾
[bd8cc969-c3ac-49ff-bd4c-a36ed9070f22] 2023-07-21T12:54:27-03:00 ERROR metabase.query-processor.middleware.catch-exceptions Erro ao processar a consulta: 400 Bad Request
POST https://www.googleapis.com/bigquery/v2/projects/projeto-basedosdados-fl/queries
{
"code" : 400,
"errors" : [ {
"domain" : "global",
"location" : "q",
"locationType" : "parameter",
"message" : "Unrecognized name: `tabelas.br_fl_mobilidade_internacional_capes_cnpq_view` at [78:33]",
"reason" : "invalidQuery"
} ],
"message" : "Unrecognized name: `tabelas.br_fl_mobilidade_internacional_capes_cnpq_view` at [78:33]",
"status" : "INVALID_ARGUMENT"
}
{:database_id 7,
:started_at #t "2023-07-21T15:54:27.029010Z[Etc/UTC]",
:via
[{:status :failed,
:class com.google.cloud.bigquery.BigQueryException,
:error "Unrecognized name: `tabelas.br_fl_mobilidade_internacional_capes_cnpq_view` at [78:33]",
:stacktrace
["com.google.cloud.bigquery.spi.v2.HttpBigQueryRpc.translate(HttpBigQueryRpc.java:115)"
"com.google.cloud.bigquery.spi.v2.HttpBigQueryRpc.queryRpc(HttpBigQueryRpc.java:652)"
"com.google.cloud.bigquery.BigQueryImpl$35.call(BigQueryImpl.java:1278)"
"com.google.cloud.bigquery.BigQueryImpl$35.call(BigQueryImpl.java:1275)"
"com.google.api.gax.retrying.DirectRetryingExecutor.submit(DirectRetryingExecutor.java:105)"
"com.google.cloud.RetryHelper.run(RetryHelper.java:76)"
"com.google.cloud.RetryHelper.runWithRetries(RetryHelper.java:50)"
"com.google.cloud.bigquery.BigQueryImpl.queryRpc(BigQueryImpl.java:1274)"
"com.google.cloud.bigquery.BigQueryImpl.query(BigQueryImpl.java:1262)"
"--> driver.bigquery_cloud_sdk$execute_bigquery$fn__104119.invoke(bigquery_cloud_sdk.clj:269)"]}
{:status :failed,
:class java.util.concurrent.ExecutionException,
:error
"com.google.cloud.bigquery.BigQueryException: Unrecognized name: `tabelas.br_fl_mobilidade_internacional_capes_cnpq_view` at [78:33]",
:stacktrace
["java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122)"
"java.base/java.util.concurrent.FutureTask.get(FutureTask.java:191)"
"clojure.core$deref_future.invokeStatic(core.clj:2317)"
"clojure.core$future_call$reify__8544.deref(core.clj:7041)"
"clojure.core$deref.invokeStatic(core.clj:2337)"
"clojure.core$deref.invoke(core.clj:2323)"
"--> driver.bigquery_cloud_sdk$execute_bigquery.invokeStatic(bigquery_cloud_sdk.clj:257)"
"driver.bigquery_cloud_sdk$execute_bigquery.invoke(bigquery_cloud_sdk.clj:253)"
"driver.bigquery_cloud_sdk$execute_bigquery_on_db.invokeStatic(bigquery_cloud_sdk.clj:298)"
"driver.bigquery_cloud_sdk$execute_bigquery_on_db.invoke(bigquery_cloud_sdk.clj:296)"
"driver.bigquery_cloud_sdk$process_native_STAR_$thunk__104163.invoke(bigquery_cloud_sdk.clj:347)"
"driver.bigquery_cloud_sdk$process_native_STAR_.invokeStatic(bigquery_cloud_sdk.clj:355)"
"driver.bigquery_cloud_sdk$process_native_STAR_.invoke(bigquery_cloud_sdk.clj:339)"
"driver.bigquery_cloud_sdk$fn__104169.invokeStatic(bigquery_cloud_sdk.clj:375)"
"driver.bigquery_cloud_sdk$fn__104169.invoke(bigquery_cloud_sdk.clj:367)"
"query_processor.context$executef.invokeStatic(context.clj:60)"
"query_processor.context$executef.invoke(context.clj:49)"
"query_processor.context.default$default_runf.invokeStatic(default.clj:68)"
"query_processor.context.default$default_runf.invoke(default.clj:66)"
"query_processor.context$runf.invokeStatic(context.clj:46)"
"query_processor.context$runf.invoke(context.clj:40)"
"query_processor.reducible$identity_qp.invokeStatic(reducible.clj:15)"
"query_processor.reducible$identity_qp.invoke(reducible.clj:12)"
"query_processor.middleware.cache$run_query_with_cache.invokeStatic(cache.clj:197)"
"query_processor.middleware.cache$run_query_with_cache.invoke(cache.clj:182)"
"query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___69242.invoke(cache.clj:223)"
"query_processor.middleware.permissions$check_query_permissions$fn__64714.invoke(permissions.clj:126)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__68133.invoke(mbql_to_native.clj:24)"
"query_processor$fn__70761$combined_post_process__70766$combined_post_process_STAR___70767.invoke(query_processor.clj:243)"
"query_processor$fn__70761$combined_pre_process__70762$combined_pre_process_STAR___70763.invoke(query_processor.clj:240)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__69153$fn__69158.invoke(resolve_database_and_driver.clj:36)"
"driver$do_with_driver.invokeStatic(driver.clj:90)"
"driver$do_with_driver.invoke(driver.clj:86)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__69153.invoke(resolve_database_and_driver.clj:35)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__65024.invoke(fetch_source_query.clj:316)"
"query_processor.middleware.store$initialize_store$fn__65202$fn__65203.invoke(store.clj:12)"
"query_processor.store$do_with_store.invokeStatic(store.clj:47)"
"query_processor.store$do_with_store.invoke(store.clj:41)"
"query_processor.middleware.store$initialize_store$fn__65202.invoke(store.clj:11)"
"query_processor.middleware.normalize_query$normalize$fn__69442.invoke(normalize_query.clj:25)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__66380.invoke(constraints.clj:54)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__69378.invoke(process_userland_query.clj:151)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__69755.invoke(catch_exceptions.clj:171)"
"query_processor.reducible$async_qp$qp_STAR___59523$thunk__59525.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___59523$fn__59527.invoke(reducible.clj:108)"]}
{:status :failed,
:class clojure.lang.ExceptionInfo,
:error
"Erro ao executar consulta: com.google.cloud.bigquery.BigQueryException: Unrecognized name: `tabelas.br_fl_mobilidade_internacional_capes_cnpq_view` at [78:33]",
:stacktrace
["--> driver.bigquery_cloud_sdk$throw_invalid_query.invokeStatic(bigquery_cloud_sdk.clj:249)"
"driver.bigquery_cloud_sdk$throw_invalid_query.invoke(bigquery_cloud_sdk.clj:248)"
"driver.bigquery_cloud_sdk$execute_bigquery.invokeStatic(bigquery_cloud_sdk.clj:294)"
"driver.bigquery_cloud_sdk$execute_bigquery.invoke(bigquery_cloud_sdk.clj:253)"
"driver.bigquery_cloud_sdk$execute_bigquery_on_db.invokeStatic(bigquery_cloud_sdk.clj:298)"
"driver.bigquery_cloud_sdk$execute_bigquery_on_db.invoke(bigquery_cloud_sdk.clj:296)"
"driver.bigquery_cloud_sdk$process_native_STAR_$thunk__104163.invoke(bigquery_cloud_sdk.clj:347)"
"driver.bigquery_cloud_sdk$process_native_STAR_.invokeStatic(bigquery_cloud_sdk.clj:355)"
"driver.bigquery_cloud_sdk$process_native_STAR_.invoke(bigquery_cloud_sdk.clj:339)"
"driver.bigquery_cloud_sdk$fn__104169.invokeStatic(bigquery_cloud_sdk.clj:375)"
"driver.bigquery_cloud_sdk$fn__104169.invoke(bigquery_cloud_sdk.clj:367)"
"query_processor.context$executef.invokeStatic(context.clj:60)"
"query_processor.context$executef.invoke(context.clj:49)"
"query_processor.context.default$default_runf.invokeStatic(default.clj:68)"
"query_processor.context.default$default_runf.invoke(default.clj:66)"
"query_processor.context$runf.invokeStatic(context.clj:46)"
"query_processor.context$runf.invoke(context.clj:40)"
"query_processor.reducible$identity_qp.invokeStatic(reducible.clj:15)"
"query_processor.reducible$identity_qp.invoke(reducible.clj:12)"
"query_processor.middleware.cache$run_query_with_cache.invokeStatic(cache.clj:197)"
"query_processor.middleware.cache$run_query_with_cache.invoke(cache.clj:182)"
"query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___69242.invoke(cache.clj:223)"
"query_processor.middleware.permissions$check_query_permissions$fn__64714.invoke(permissions.clj:126)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__68133.invoke(mbql_to_native.clj:24)"
"query_processor$fn__70761$combined_post_process__70766$combined_post_process_STAR___70767.invoke(query_processor.clj:243)"
"query_processor$fn__70761$combined_pre_process__70762$combined_pre_process_STAR___70763.invoke(query_processor.clj:240)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__69153$fn__69158.invoke(resolve_database_and_driver.clj:36)"
"driver$do_with_driver.invokeStatic(driver.clj:90)"
"driver$do_with_driver.invoke(driver.clj:86)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__69153.invoke(resolve_database_and_driver.clj:35)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__65024.invoke(fetch_source_query.clj:316)"
"query_processor.middleware.store$initialize_store$fn__65202$fn__65203.invoke(store.clj:12)"
"query_processor.store$do_with_store.invokeStatic(store.clj:47)"
"query_processor.store$do_with_store.invoke(store.clj:41)"
"query_processor.middleware.store$initialize_store$fn__65202.invoke(store.clj:11)"
"query_processor.middleware.normalize_query$normalize$fn__69442.invoke(normalize_query.clj:25)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__66380.invoke(constraints.clj:54)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__69378.invoke(process_userland_query.clj:151)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__69755.invoke(catch_exceptions.clj:171)"
"query_processor.reducible$async_qp$qp_STAR___59523$thunk__59525.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___59523$fn__59527.invoke(reducible.clj:108)"],
:error_type :invalid-query,
:ex-data
{:type :invalid-query,
:sql
"-- Metabase:: userID: 95 queryType: native queryHash: 43bc18ea3c369fe08a436843917c14ea7170a5196405b21100e7eb24ce6a78a2\nWITH\n cnpq AS (\n SELECT\n beneficiario,\n id_processo,\n nivel,\n tipo,\n fonte,\n sexo,\n SUM(valor_real) AS valor_acumulado\n FROM\n `tabelas.br_fl_mobilidade_internacional_capes_cnpq_view`\n WHERE\n fonte = 'CNPq'\n AND sigla_pais_destino <> \"BR\"\n GROUP BY\n beneficiario,\n id_processo,\n nivel,\n tipo,\n fonte,\n sexo),\n bolsa_cnpq_acc AS (\n SELECT\n nivel,\n tipo,\n fonte,\n sexo,\n valor_acumulado,\n b.ano_inicial\n FROM\n cnpq\n JOIN (\n SELECT\n beneficiario,\n id_processo,\n MIN(ano) AS ano_inicial\n FROM\n `tabelas.br_fl_mobilidade_internacional_capes_cnpq_view`\n GROUP BY\n beneficiario,\n id_processo ) AS b\n ON\n cnpq.id_processo = b.id_processo\n AND cnpq.beneficiario = b.beneficiario),\n bolsa_capes_acc AS (\n SELECT\n nivel,\n tipo,\n fonte,\n sexo,\n SUM(valor_real) as valor_acumulado,\n ano AS ano_inicial,\n FROM\n `tabelas.br_fl_mobilidade_internacional_capes_cnpq_view`\n WHERE\n fonte = 'CAPES'\n AND sigla_pais_destino <> \"BR\"\n GROUP BY\n beneficiario,\n id_processo,\n nivel,\n tipo,\n fonte,\n sexo,\n ano),\n tb_final AS (\nSELECT\n *\nFROM\n bolsa_capes_acc\nUNION ALL\n SELECT * from bolsa_cnpq_acc)\n\n\nselect nivel, ano_inicial, (avg(valor_acumulado)) as media from tb_final\nwhere nivel is not null and `tabelas.br_fl_mobilidade_internacional_capes_cnpq_view`.`sexo` = ? \ngroup by ano_inicial, nivel",
:parameters ["Feminino"]}}],
:error_type :invalid-query,
:json_query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :native,
:middleware {:js-int-to-string? true, :ignore-cached-results? true, :process-viz-settings? false},
:native
{:query
"WITH\n cnpq AS (\n SELECT\n beneficiario,\n id_processo,\n nivel,\n tipo,\n fonte,\n sexo,\n SUM(valor_real) AS valor_acumulado\n FROM\n `tabelas.br_fl_mobilidade_internacional_capes_cnpq_view`\n WHERE\n fonte = 'CNPq'\n AND sigla_pais_destino <> \"BR\"\n GROUP BY\n beneficiario,\n id_processo,\n nivel,\n tipo,\n fonte,\n sexo),\n bolsa_cnpq_acc AS (\n SELECT\n nivel,\n tipo,\n fonte,\n sexo,\n valor_acumulado,\n b.ano_inicial\n FROM\n cnpq\n JOIN (\n SELECT\n beneficiario,\n id_processo,\n MIN(ano) AS ano_inicial\n FROM\n `tabelas.br_fl_mobilidade_internacional_capes_cnpq_view`\n GROUP BY\n beneficiario,\n id_processo ) AS b\n ON\n cnpq.id_processo = b.id_processo\n AND cnpq.beneficiario = b.beneficiario),\n bolsa_capes_acc AS (\n SELECT\n nivel,\n tipo,\n fonte,\n sexo,\n SUM(valor_real) as valor_acumulado,\n ano AS ano_inicial,\n FROM\n `tabelas.br_fl_mobilidade_internacional_capes_cnpq_view`\n WHERE\n fonte = 'CAPES'\n AND sigla_pais_destino <> \"BR\"\n GROUP BY\n beneficiario,\n id_processo,\n nivel,\n tipo,\n fonte,\n sexo,\n ano),\n tb_final AS (\nSELECT\n *\nFROM\n bolsa_capes_acc\nUNION ALL\n SELECT * from bolsa_cnpq_acc)\n\n\nselect nivel, ano_inicial, (avg(valor_acumulado)) as media from tb_final\nwhere nivel is not null [[and {{top20}}]] [[and {{area_conhecimento_fl}}]] [[and {{nivel}}]] [[and {{tipo}}]] [[and {{sexo}}]] [[and {{fonte}}]]\ngroup by ano_inicial, nivel",
:template-tags
{"top20"
{:id "7ac8d05e-25b6-9a0f-75c3-d4db4c98be1b",
:name "top20",
:display-name "Top 20",
:type :dimension,
:dimension [:field 34978 nil],
:widget-type :string/=},
"area_conhecimento_fl"
{:id "74719ad7-395f-d8cf-9445-8135100cf942",
:name "area_conhecimento_fl",
:display-name "Área de Conhecimento",
:type :dimension,
:dimension [:field 34963 nil],
:widget-type :string/=},
"nivel"
{:id "dc0bfc90-2c5b-7e95-7bab-0d995ce405a3",
:name "nivel",
:display-name "Nível de Ensino",
:type :dimension,
:dimension [:field 34971 nil],
:widget-type :string/=},
"tipo"
{:id "23c27e1f-c870-8592-c9ca-265317780ea6",
:name "tipo",
:display-name "Modalidade",
:type :dimension,
:dimension [:field 34980 nil],
:widget-type :string/=},
"sexo"
{:id "3f538ae2-8482-2caf-2a1b-8ab122f177f1",
:name "sexo",
:display-name "Sexo",
:type :dimension,
:dimension [:field 34965 nil],
:widget-type :string/=},
"fonte"
{:id "e12c8634-fe0f-69a6-f480-35b63cb3ec92",
:name "fonte",
:display-name "Fonte",
:type :dimension,
:dimension [:field 34970 nil],
:widget-type :string/=}}},
:database 7,
:parameters
[{:id "3f538ae2-8482-2caf-2a1b-8ab122f177f1",
:type "string/=",
:value ["Feminino"],
:target ["dimension" ["template-tag" "sexo"]]}],
:async? true,
:cache-ttl 93},
:status :failed,
:class com.google.api.client.googleapis.json.GoogleJsonResponseException,
:stacktrace
["com.google.api.client.googleapis.json.GoogleJsonResponseException.from(GoogleJsonResponseException.java:146)"
"com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:118)"
"com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:37)"
"com.google.api.client.googleapis.services.AbstractGoogleClientRequest$1.interceptResponse(AbstractGoogleClientRequest.java:428)"
"com.google.api.client.http.HttpRequest.execute(HttpRequest.java:1111)"
"com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:514)"
"com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:455)"
"com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:565)"
"com.google.cloud.bigquery.spi.v2.HttpBigQueryRpc.queryRpc(HttpBigQueryRpc.java:650)"
"com.google.cloud.bigquery.BigQueryImpl$35.call(BigQueryImpl.java:1278)"
"com.google.cloud.bigquery.BigQueryImpl$35.call(BigQueryImpl.java:1275)"
"com.google.api.gax.retrying.DirectRetryingExecutor.submit(DirectRetryingExecutor.java:105)"
"com.google.cloud.RetryHelper.run(RetryHelper.java:76)"
"com.google.cloud.RetryHelper.runWithRetries(RetryHelper.java:50)"
"com.google.cloud.bigquery.BigQueryImpl.queryRpc(BigQueryImpl.java:1274)"
"com.google.cloud.bigquery.BigQueryImpl.query(BigQueryImpl.java:1262)"
"--> driver.bigquery_cloud_sdk$execute_bigquery$fn__104119.invoke(bigquery_cloud_sdk.clj:269)"],
:card_id 1853,
:context :question,
:error
"400 Bad Request\nPOST https://www.googleapis.com/bigquery/v2/projects/projeto-basedosdados-fl/queries\n{\n \"code\" : 400,\n \"errors\" : [ {\n \"domain\" : \"global\",\n \"location\" : \"q\",\n \"locationType\" : \"parameter\",\n \"message\" : \"Unrecognized name: `tabelas.br_fl_mobilidade_internacional_capes_cnpq_view` at [78:33]\",\n \"reason\" : \"invalidQuery\"\n } ],\n \"message\" : \"Unrecognized name: `tabelas.br_fl_mobilidade_internacional_capes_cnpq_view` at [78:33]\",\n \"status\" : \"INVALID_ARGUMENT\"\n}",
:row_count 0,
:running_time 0,
:data {:rows [], :cols []}}
[bd8cc969-c3ac-49ff-bd4c-a36ed9070f22] 2023-07-21T12:54:27-03:00 DEBUG metabase.server.middleware.log POST /api/card/1853/query 202 [ASYNC: completed] 737.7 ms (16 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 15 Threads do Jetty: 3 / 50 (3 ocioso, 0 na fila) (139 total de threads ativas) Consultas ativas: 0 (0 na fila)
System info:
{
"browser-info": {
"language": "pt-BR",
"platform": "Linux x86_64",
"userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.18+10-post-Debian-1deb10u1",
"java.vendor": "Debian",
"java.vendor.url": "https://tracker.debian.org/openjdk-11",
"java.version": "11.0.18",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.18+10-post-Debian-1deb10u1",
"os.name": "Linux",
"os.version": "4.19.0-24-cloud-amd64",
"user.language": "en",
"user.timezone": "Etc/UTC"
},
"metabase-info": {
"databases": [
"h2",
"googleanalytics",
"mysql",
"bigquery-cloud-sdk",
"postgres"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "8.0.26"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.7.6"
}
},
"run-mode": "prod",
"version": {
"date": "2023-06-29",
"tag": "v0.46.6",
"branch": "release-x.46.x",
"hash": "1bb88f5"
},
"settings": {
"report-timezone": "America/Sao_Paulo"
}
}
}
