"Distinct, non-empty sequence of Field clauses" SQL Server Express

Hi all, new to Metabase so not sure if I’m missing something obvious.

I’m not able to browse any of the tables in my database thanks to the “Distinct, non-empty sequence of Field clauses” error. I can however get results from SQL queries using the “Write SQL” option in metabase and the x-ray function returns the number of rows correctly.

I am not using SSH which seems to be the root of the problem that other users have had.

{
“browser-info”: {
“language”: “en-GB”,
“platform”: “Win32”,
“userAgent”: “Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:75.0) Gecko/20100101 Firefox/75.0”,
“vendor”: “”
},
“system-info”: {
“file.encoding”: “UTF-8”,
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “11.0.5+10”,
“java.vendor”: “AdoptOpenJDK”,
“java.vendor.url”: “https://adoptopenjdk.net/”,
“java.version”: “11.0.5”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “11.0.5+10”,
“os.name”: “Linux”,
“os.version”: “5.4.0-0.bpo.2-amd64”,
“user.language”: “en”,
“user.timezone”: “GMT”
},
“metabase-info”: {
“databases”: [
“h2”,
“sqlserver”
],
“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-04-10”,
“tag”: “v0.35.2”,
“branch”: “release-0.35.x”,
“hash”: “f3b2857”
},
“settings”: {
“report-timezone”: null
}
}
}

Hi @josh_p
Depending on the size of your database, Metabase might not be done analyzing your database yet.

But if you have a small database, then try to run a sync+scan again via Admin > Databases > (your-database)
Then have a look in Admin > Troubleshooting > Logs for any warnings/errors that might happen during the analyze process.

The SSH-problem seems to be specific to Postgres, as far as I know.

Hi @flamber,

Thanks for your help.

The sync has completed looking at the logs but there are lines in the log similar to the below for every table:

[ca311a04-77bd-4ab5-8573-7ca106de5dd9] 2020-04-24T14:00:02+01:00 ERROR metabase.sync.util Error syncing Fields for Table ‘Table 248 ‘dbo.Attributes’’

I’m guessing this could be where the issue is coming from. Does this point to anything I can fix?

@josh_p
Can you post the structure/schema of one of the tables that is failing to sync? I guess you have some column type that is triggering a problem.

You can also try starting Metabase with debug logging:
https://www.metabase.com/docs/latest/operations-guide/log-configuration.html
Here’s an example that will start with debug logging of the sync process:

java -Dlog4j.configuration=https://gist.github.com/flamber/53823764c9989415b76acdb9ed88bcc1/raw/e1cd731924c4ae6091a495feec54ab38f5a1543a/log4j-debug-sync.properties -jar metabase.jar