Curly brackets do not invoke variables fill-in form

Get Help
1

Hi,
I have used variables extensively, but i this one case, while typing the curly brackets, the variables form does not raise, instead i get the variables help form. I have simplified my sqlite query to its minimum, but the same behavior results. latest Mb version

thx,
Chuick

2

Hi @crwheelr
Post “Diagnostic Info” from Admin > Troubleshooting.
Check your browser console for errors. You are likely seeing this issue, which is difficult to reproduce and is caused by a race-condition. A browser refresh fixes it:
https://github.com/metabase/metabase/issues/10927 - upvote by clicking :+1: on the first post

3

its pretty weird behavior my existing questiond with variables are all okay. but even opening a new question with
select {{anything}} as “any”
doesn’t open the pane.

{
“browser-info”: {
“language”: “en-US”,
“platform”: “Win32”,
“userAgent”: “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36”,
“vendor”: “Google Inc.”
},
“system-info”: {
“file.encoding”: “Cp1252”,
“java.runtime.name”: “Java™ SE Runtime Environment”,
“java.runtime.version”: “1.8.0_271-b09”,
“java.vendor”: “Oracle Corporation”,
“java.vendor.url”: “http://java.oracle.com/”,
“java.version”: “1.8.0_271”,
“java.vm.name”: “Java HotSpot™ Client VM”,
“java.vm.version”: “25.271-b09”,
“os.name”: “Windows 10”,
“os.version”: “10.0”,
“user.language”: “en”,
“user.timezone”: “America/Los_Angeles”
},
“metabase-info”: {
“databases”: [
“sqlite”
],
“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”: {
“tag”: “v0.37.3”,
“date”: “2020-12-03”,
“branch”: “release-x.37.x”,
“hash”: “2f1e783”
},
“settings”: {
“report-timezone”: “US/Pacific”
}
}
}

4

@crwheelr
I have seen this a couple of times, but I have no way of reproducing it. Check your browser console for errors.
Latest release is 0.37.4, and migrate away from H2.

5

@flamber,
logged in this morning and problem is no longer evident. If happens again I will check on browser console as you said,

You have mentioned several times about migrating out of H2. I find this difficult as i am distributing a package to a broad range of people and do not want the additional burden of installing another database engine at their locations. If you see this differently, for example, if there is an existing reliable script that i can embed in my Inno installer to install postgress, please advise. My customers do have sqlite native to their platforms if that can be used.

thanks,

Chuck