Got error Assert failed: (seq dataset-id) when trying create question using data from native sql query

Get Help
1

Hi there, I'm following tutorial from create pivot table from native sql query (this return 3 colums data)
I'm using command like with, timestamp_diff, count inside the native sql query

Followed work around on Limitation section from the article
But when tried create new custom question that uses the results of that question as its starting data, the preview showing error Assert failed: (seq dataset-id)
What these error mean?

2

Hi @shilohbleu
Post "Diagnostic Info" from Admin > Troubleshooting, and which database type you're querying.
And post the full stacktrace from Admin > Troubleshooting > Logs.

3

Hi @flamber @shilohbleu , we're facing similar issue of Assert failed: (seq dataset-id) when creating a question. What was the resolution for this ?

47%20AM
47%20AM2718×718 325 KB

4

@pa101
Post "Diagnostic Info" from Admin > Troubleshooting, and which database type you're querying.
And post the full stacktrace from Admin > Troubleshooting > Logs.

5

Diagnostic report -

{
"browser-info": {
"language": "en-GB",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36 OPR/86.0.4363.59",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.14.1+1",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.14.1",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.14.1+1",
"os.name": "Linux",
"os.version": "5.4.170+",
"user.language": "en",
"user.timezone": "IST"
},
"metabase-info": {
"databases": [
"mysql",
"bigquery",
"bigquery-cloud-sdk"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "5.7.37-google-log"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.6.2"
}
},
"run-mode": "prod",
"version": {
"date": "2022-04-13",
"tag": "v0.41.7",
"branch": "release-x.41.x",
"hash": "d9db729"
},
"settings": {
"report-timezone": "Asia/Calcutta"
}
}
}

6

Logs in Pastebin . - https://pastebin.com/KV5jQbCx

7

@metabase-gr8 So is this on the new or the old BigQuery driver?

8

@flamber This was on new BigQuery driver. For one of the database we reverted to the old BQ driver which also resolved this error. Other databases which are still on new BQ driver, still has the error of Assert failed: (seq dataset-id)

9

@pa101 There has been many changes to the new BigQuery driver in newer versions.

10

@flamber What would you recommend? Should we revert the driver back to old for other database as well ? Is there a way to fix this with new BQ driver ?

11

@pa101 Use whatever works for you. Latest release is 0.43.1, which does not have a old driver anymore. Latest release with the old driver is 0.42.4.

1 Like