Diagnostic Info:
{
"browser-info": {
"language": "en-US",
"platform": "Linux x86_64",
"userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.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.15+10",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.15",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.15+10",
"os.name": "Linux",
"os.version": "5.4.0-110-generic",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"postgres",
"h2"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "14.2 (Debian 14.2-1.pgdg110+1)"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.3.2"
}
},
"run-mode": "prod",
"version": {
"date": "2022-05-31",
"tag": "v0.43.2",
"branch": "release-x.43.x",
"hash": "433d533"
},
"settings": {
"report-timezone": "Asia/Dhaka"
}
}
}
Error log:
2022-06-07 11:28:27,206 WARN sync.util :: Error syncing Fields for Table 'Table 155 'public.order_item_analytics''
org.postgresql.util.PSQLException: ERROR: column order_item_analytics.activitydetails does not exist
Hint: Perhaps you meant to reference the column "order_item_analytics.activityDetails".
Position: 8
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:166)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:118)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1471)
at clojure.java.jdbc$execute_query_with_params.invokeStatic(jdbc.clj:1090)
at clojure.java.jdbc$execute_query_with_params.invoke(jdbc.clj:1084)
at clojure.java.jdbc$db_query_with_resultset_STAR_.invokeStatic(jdbc.clj:1113)
at clojure.java.jdbc$db_query_with_resultset_STAR_.invoke(jdbc.clj:1093)
at clojure.java.jdbc$reducible_query$reify__28497.reduce(jdbc.clj:1357)
at clojure.core$transduce.invokeStatic(core.clj:6885)
at clojure.core$transduce.invokeStatic(core.clj:6881)
at clojure.core$transduce.invoke(core.clj:6872)
at metabase.driver.sql_jdbc.sync.describe_table$describe_nested_field_columns.invokeStatic(describe_table.clj:354)
at metabase.driver.sql_jdbc.sync.describe_table$describe_nested_field_columns.invoke(describe_table.clj:338)
at metabase.driver.postgres$fn__59114.invokeStatic(postgres.clj:187)
at metabase.driver.postgres$fn__59114.invoke(postgres.clj:184)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.sync.fetch_metadata$fn__64230$nfc_metadata__64235$fn__64236.invoke(fetch_metadata.clj:33)
at metabase.sync.fetch_metadata$fn__64230$nfc_metadata__64235.invoke(fetch_metadata.clj:28)
at metabase.sync.sync_metadata.fields.fetch_metadata$fn__64450$db_metadata__64455$fn__64456.invoke(fetch_metadata.clj:90)
at metabase.sync.sync_metadata.fields.fetch_metadata$fn__64450$db_metadata__64455.invoke(fetch_metadata.clj:84)
at metabase.sync.sync_metadata.fields$fn__64948$sync_fields_for_table_BANG___64957$fn__64960$fn__64961.invoke(fields.clj:72)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:158)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:151)
at metabase.sync.sync_metadata.fields$fn__64948$sync_fields_for_table_BANG___64957$fn__64960.invoke(fields.clj:71)
at metabase.sync.sync_metadata.fields$fn__64948$sync_fields_for_table_BANG___64957.invoke(fields.clj:65)
at clojure.core$partial$fn__5857.invoke(core.clj:2628)
at clojure.core$map$fn__5884.invoke(core.clj:2757)
at clojure.lang.LazySeq.sval(LazySeq.java:42)
at clojure.lang.LazySeq.seq(LazySeq.java:51)
at clojure.lang.RT.seq(RT.java:535)
at clojure.core$seq__5419.invokeStatic(core.clj:139)
at clojure.core$filter$fn__5911.invoke(core.clj:2813)
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.lang.ChunkedCons.next(ChunkedCons.java:43)
at clojure.lang.RT.boundedLength(RT.java:1793)
at clojure.lang.RestFn.applyTo(RestFn.java:130)
at clojure.core$apply.invokeStatic(core.clj:669)
at clojure.core$apply.invoke(core.clj:662)
at metabase.sync.sync_metadata.fields$fn__64986$sync_fields_BANG___64991$fn__64992.invoke(fields.clj:85)
at metabase.sync.sync_metadata.fields$fn__64986$sync_fields_BANG___64991.invoke(fields.clj:77)
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__41545$run_step_with_metadata__41550$fn__41554$fn__41556.doInvoke(util.clj:388)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:100)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:94)
at metabase.sync.util$with_start_and_finish_debug_logging.invokeStatic(util.clj:117)
at metabase.sync.util$with_start_and_finish_debug_logging.invoke(util.clj:114)
at metabase.sync.util$fn__41545$run_step_with_metadata__41550$fn__41554.invoke(util.clj:383)
at metabase.sync.util$fn__41545$run_step_with_metadata__41550.invoke(util.clj:378)
at metabase.sync.util$fn__41761$run_sync_operation__41766$fn__41767$fn__41775.invoke(util.clj:489)
at metabase.sync.util$fn__41761$run_sync_operation__41766$fn__41767.invoke(util.clj:487)
at metabase.sync.util$fn__41761$run_sync_operation__41766.invoke(util.clj:481)
at metabase.sync.sync_metadata$fn__66491$sync_db_metadata_BANG___66496$fn__66497$fn__66498.invoke(sync_metadata.clj:50)
at metabase.sync.util$do_with_error_handling.invokeStatic(util.clj:158)
at metabase.sync.util$do_with_error_handling.invoke(util.clj:151)
at clojure.core$partial$fn__5859.invoke(core.clj:2634)
at metabase.driver$fn__32609.invokeStatic(driver.clj:592)
at metabase.driver$fn__32609.invoke(driver.clj:592)
at clojure.lang.MultiFn.invoke(MultiFn.java:239)
at metabase.sync.util$sync_in_context$fn__41454.invoke(util.clj:136)
at metabase.sync.util$with_db_logging_disabled$fn__41451.invoke(util.clj:127)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invokeStatic(util.clj:100)
at metabase.sync.util$with_start_and_finish_logging_STAR_.invoke(util.clj:94)
at metabase.sync.util$with_start_and_finish_logging$fn__41440.invoke(util.clj:112)
at metabase.sync.util$with_sync_events$fn__41435.invoke(util.clj:86)
at metabase.sync.util$with_duplicate_ops_prevented$fn__41426.invoke(util.clj:65)
at metabase.sync.util$do_sync_operation.invokeStatic(util.clj:179)
at metabase.sync.util$do_sync_operation.invoke(util.clj:176)
at metabase.sync.sync_metadata$fn__66491$sync_db_metadata_BANG___66496$fn__66497.invoke(sync_metadata.clj:49)
at metabase.sync.sync_metadata$fn__66491$sync_db_metadata_BANG___66496.invoke(sync_metadata.clj:46)
at metabase.api.database$fn__74842$fn__74843.invoke(database.clj:751)
at clojure.core$binding_conveyor_fn$fn__5772.invoke(core.clj:2034)
at clojure.lang.AFn.call(AFn.java:18)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
Please someone help me, I'm unable to use any of the features properly. This particular table just has a simple one level Json object but still all row of this column is null in Database
Can that be an issue?
please help me
on the first post