Cant sync view

So, i’ve created a view in my postgres by necessity. When I synchronize the db the view appears, but when I try to do queries on it the columns aren’t available to filter but i can summarize by count of rows and its ok.

My view:

On Admin -> Data Model:

The Diagnostic Info and Logs about the view are below.

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/83.0.4103.97 Safari/537.36”,
“vendor”: “Google Inc.”
},
“system-info”: {
“file.encoding”: “UTF-8”,
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “11.0.7+10-post-Ubuntu-2ubuntu218.04”,
“java.vendor”: “Ubuntu”,
“java.vendor.url”: “https://ubuntu.com/”,
“java.version”: “11.0.7”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “11.0.7+10-post-Ubuntu-2ubuntu218.04”,
“os.name”: “Linux”,
“os.version”: “4.15.0-96-generic”,
“user.language”: “en”,
“user.timezone”: “Etc/UTC”
},
“metabase-info”: {
“databases”: [
“postgres”
],
“hosting-env”: “unknown”,
“application-database”: “h2”,
“application-database-details”: {
“database”: {
“name”: “H2”,
“version”: “1.4.197 (2018-03-18)”
},
“jdbc-driver”: {
“name”: “H2 JDBC Driver”,
“version”: “1.4.197 (2018-03-18)”
}
},
“run-mode”: “prod”,
“version”: {
“date”: “2020-05-28”,
“tag”: “v0.35.4”,
“branch”: “release-0.35.x”,
“hash”: “b3080fa”
},
“settings”: {
“report-timezone”: “America/Sao_Paulo”
}
}
}

Logs:

  • [ffbbcfec-e8c1-4795-81e9-2d0e9e78b53f] 2020-07-23T15:26:31-03:00 INFO metabase.sync.sync-metadata.tables We found new tables: (Table ‘jira.new_operacoes’)

  • [ffbbcfec-e8c1-4795-81e9-2d0e9e78b53f] 2020-07-23T15:26:31-03:00 INFO metabase.sync.sync-metadata.tables Updating descriptions for tables: (Table ‘jira.new_operacoes’)‘jira.new_operacoes’"

  • [ffbbcfec-e8c1-4795-81e9-2d0e9e78b53f] 2020-07-23T15:31:43-03:00 INFO metabase.api.table Table ‘new_operacoes’ is visible. Resynchronizing

  • [ffbbcfec-e8c1-4795-81e9-2d0e9e78b53f] 2020-07-23T15:31:43-03:00 ERROR metabase.sync.util Error syncing Fields for Table ‘Table 341 ‘jira.new_operacoes’’

  • [ffbbcfec-e8c1-4795-81e9-2d0e9e78b53f] 2020-07-23T15:33:34-03:00 ERROR metabase.sync.util Error syncing Fields for Table ‘Table 341 ‘jira.new_operacoes’’

Hi @johhen
This is most likely fixed in the new 0.36.0 release, so I would recommend that you try that version. Remember to backup before upgrading, since you cannot downgrade and have to revert to backup in case of downgrade.
https://github.com/metabase/metabase/releases/tag/v0.36.0

And you should migrate away from H2, if you are using Metabase in production:
https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html

1 Like