Dashboard refresh bugs

Kzdev · October 3, 2025, 9:18am

Hello,

I have been facing some issues with my dashboards. My dashboards where completely fine and working, but after publishing them it started giving me errors on some of them saying that data is missing or something. Then after further investigation it said that the problem was from the data source which i uploaded (ass .csv). After that whenever i refresh the data disappears giving me error and then refresh again it shows. Also I forgot to mention that when i refresh the page some visualizations that weren’t showing (giving error) would work. I don’t understand what’s going on, Can someone help me?

dwhitemv · October 3, 2025, 3:57pm

You should be getting exceptions in the Metabase log when those errors occur. Is anything getting logged? Or anything in the console?

Is there a firewall or WAF between you and your Metabase instance? It might be interfering with the page loads. Check its log and see if its been blocking your requests.

Kzdev · October 6, 2025, 8:00am

This is the log that I get, somehow metabase put timestamp at the end of my table name after I uploaded .csv :

Here it is:

Table "training_cost_analysis_20251003082037" not found; SQL statement: -- Metabase:: userID: 1 queryType: MBQL queryHash: 6ad2c4ec685645ca60de9b1a04f457b827602672a17c69c32e386ad8b1b450ad SELECT "source"."_mb_row_id" AS "_mb_row_id", "source"."htdevtid" AS "htdevtid", "source"."evtdesc" AS "evtdesc", "source"."rid_htdcrsschd" AS "rid_htdcrsschd", "source"."htdcrscode" AS "htdcrscode", "source"."evtinternal" AS "evtinternal", "source"."htdprvdrid" AS "htdprvdrid", "source"."evtstartdt" AS "evtstartdt", "source"."evtregclsdt" AS "evtregclsdt", "source"."evtcrsstartdt" AS "evtcrsstartdt", "source"."evtcrsenddt" AS "evtcrsenddt", "source"."evtduration" AS "evtduration", "source"."evtactdays" AS "evtactdays", "source"."evtminpax" AS "evtminpax", "source"."evtmaxpax" AS "evtmaxpax", "source"."evthrdfperc" AS "evthrdfperc", "source"."evtbgtdt" AS "evtbgtdt", "source"."evtstatus" AS "evtstatus", "source"."evtdone" AS "evtdone", "source"."evtdonedt" AS "evtdonedt", "source"."evtdonestat" AS "evtdonestat", "source"."htdorgcode" AS "htdorgcode", "source"."htdcrsname" AS "htdcrsname", "source"."htdprvdrname" AS "htdprvdrname", "source"."htdorgname" AS "htdorgname", "source"."rid_htdpty" AS "rid_htdpty", "source"."personid" AS "personid", "source"."vdate" AS "vdate", "source"."rid_htdperschd" AS "rid_htdperschd", "source"."nompersonid" AS "nompersonid", "source"."regdt" AS "regdt", "source"."precrsstat" AS "precrsstat", "source"."attended" AS "attended", "source"."attendtype" AS "attendtype", "source"."resched" AS "resched", "source"."rescheddt" AS "rescheddt", "source"."waivecost" AS "waivecost", "source"."done" AS "done", "source"."donedt" AS "donedt", "source"."remark" AS "remark", "source"."ptycrsexpamt" AS "ptycrsexpamt", "source"."ptyothexpamt" AS "ptyothexpamt", "source"."ptyexptot" AS "ptyexptot", "source"."ptyattendcnt" AS "ptyattendcnt", "source"."ptylatecnt" AS "ptylatecnt", "source"."ptyincmpltcnt" AS "ptyincmpltcnt", "source"."htdexpcode" AS "htdexpcode", "source"."expamt" AS "expamt", "source"."htdbgpid" AS "htdbgpid", "source"."ptyexpremark" AS "ptyexpremark", "source"."htdexpdesc" AS "htdexpdesc", "source"."htdbgpname" AS "htdbgpname", "source"."name" AS "name", "source"."gender" AS "gender", "source"."grpjoindt" AS "grpjoindt", "source"."ecompnycode" AS "ecompnycode", "source"."estaffno" AS "estaffno", "source"."ecojoindt" AS "ecojoindt", "source"."eiresigndt" AS "eiresigndt", "source"."ebrhloccode" AS "ebrhloccode", "source"."edivsncode" AS "edivsncode", "source"."edeptcode" AS "edeptcode", "source"."esectiocode" AS "esectiocode", "source"."eunitcode" AS "eunitcode", "source"."ejobcode" AS "ejobcode", "source"."egradecode" AS "egradecode", "source"."eemptypcode" AS "eemptypcode", "source"."ejobname" AS "ejobname", "source"."ejobclscode" AS "ejobclscode", "source"."egrdisexec" AS "egrdisexec", "source"."egrdcatcode" AS "egrdcatcode", "source"."edeptname" AS "edeptname", "source"."vdateyear" AS "vdateyear", "source"."vdatemonth" AS "vdatemonth", "source"."catcode" AS "catcode", "source"."catcodename" AS "catcodename" FROM (SELECT "PUBLIC"."training_cost_analysis_20251003082037"."_mb_row_id" AS "_mb_row_id", "PUBLIC"."training_cost_analysis_20251003082037"."htdevtid" AS "htdevtid", "PUBLIC"."training_cost_analysis_20251003082037"."evtdesc" AS "evtdesc", "PUBLIC"."training_cost_analysis_20251003082037"."rid_htdcrsschd" AS "rid_htdcrsschd", "PUBLIC"."training_cost_analysis_20251003082037"."htdcrscode" AS "htdcrscode", "PUBLIC"."training_cost_analysis_20251003082037"."evtinternal" AS "evtinternal", "PUBLIC"."training_cost_analysis_20251003082037"."htdprvdrid" AS "htdprvdrid", "PUBLIC"."training_cost_analysis_20251003082037"."evtstartdt" AS "evtstartdt", "PUBLIC"."training_cost_analysis_20251003082037"."evtregclsdt" AS "evtregclsdt", "PUBLIC"."training_cost_analysis_20251003082037"."evtcrsstartdt" AS "evtcrsstartdt", "PUBLIC"."training_cost_analysis_20251003082037"."evtcrsenddt" AS "evtcrsenddt", "PUBLIC"."training_cost_analysis_20251003082037"."evtduration" AS "evtduration", "PUBLIC"."training_cost_analysis_20251003082037"."evtactdays" AS "evtactdays", "PUBLIC"."training_cost_analysis_20251003082037"."evtminpax" AS "evtminpax", "PUBLIC"."training_cost_analysis_20251003082037"."evtmaxpax" AS "evtmaxpax", "PUBLIC"."training_cost_analysis_20251003082037"."evthrdfperc" AS "evthrdfperc", "PUBLIC"."training_cost_analysis_20251003082037"."evtbgtdt" AS "evtbgtdt", "PUBLIC"."training_cost_analysis_20251003082037"."evtstatus" AS "evtstatus", "PUBLIC"."training_cost_analysis_20251003082037"."evtdone" AS "evtdone", "PUBLIC"."training_cost_analysis_20251003082037"."evtdonedt" AS "evtdonedt", "PUBLIC"."training_cost_analysis_20251003082037"."evtdonestat" AS "evtdonestat", "PUBLIC"."training_cost_analysis_20251003082037"."htdorgcode" AS "htdorgcode", "PUBLIC"."training_cost_analysis_20251003082037"."htdcrsname" AS "htdcrsname", "PUBLIC"."training_cost_analysis_20251003082037"."htdprvdrname" AS "htdprvdrname", "PUBLIC"."training_cost_analysis_20251003082037"."htdorgname" AS "htdorgname", "PUBLIC"."training_cost_analysis_20251003082037"."rid_htdpty" AS "rid_htdpty", "PUBLIC"."training_cost_analysis_20251003082037"."personid" AS "personid", "PUBLIC"."training_cost_analysis_20251003082037"."vdate" AS "vdate", "PUBLIC"."training_cost_analysis_20251003082037"."rid_htdperschd" AS "rid_htdperschd", "PUBLIC"."training_cost_analysis_20251003082037"."nompersonid" AS "nompersonid", "PUBLIC"."training_cost_analysis_20251003082037"."regdt" AS "regdt", "PUBLIC"."training_cost_analysis_20251003082037"."precrsstat" AS "precrsstat", "PUBLIC"."training_cost_analysis_20251003082037"."attended" AS "attended", "PUBLIC"."training_cost_analysis_20251003082037"."attendtype" AS "attendtype", "PUBLIC"."training_cost_analysis_20251003082037"."resched" AS "resched", "PUBLIC"."training_cost_analysis_20251003082037"."rescheddt" AS "rescheddt", "PUBLIC"."training_cost_analysis_20251003082037"."waivecost" AS "waivecost", "PUBLIC"."training_cost_analysis_20251003082037"."done" AS "done", "PUBLIC"."training_cost_analysis_20251003082037"."donedt" AS "donedt", "PUBLIC"."training_cost_analysis_20251003082037"."remark" AS "remark", "PUBLIC"."training_cost_analysis_20251003082037"."ptycrsexpamt" AS "ptycrsexpamt", "PUBLIC"."training_cost_analysis_20251003082037"."ptyothexpamt" AS "ptyothexpamt", "PUBLIC"."training_cost_analysis_20251003082037"."ptyexptot" AS "ptyexptot", "PUBLIC"."training_cost_analysis_20251003082037"."ptyattendcnt" AS "ptyattendcnt", "PUBLIC"."training_cost_analysis_20251003082037"."ptylatecnt" AS "ptylatecnt", "PUBLIC"."training_cost_analysis_20251003082037"."ptyincmpltcnt" AS "ptyincmpltcnt", "PUBLIC"."training_cost_analysis_20251003082037"."htdexpcode" AS "htdexpcode", "PUBLIC"."training_cost_analysis_20251003082037"."expamt" AS "expamt", "PUBLIC"."training_cost_analysis_20251003082037"."htdbgpid" AS "htdbgpid", "PUBLIC"."training_cost_analysis_20251003082037"."ptyexpremark" AS "ptyexpremark", "PUBLIC"."training_cost_analysis_20251003082037"."htdexpdesc" AS "htdexpdesc", "PUBLIC"."training_cost_analysis_20251003082037"."htdbgpname" AS "htdbgpname", "PUBLIC"."training_cost_analysis_20251003082037"."name" AS "name", "PUBLIC"."training_cost_analysis_20251003082037"."gender" AS "gender", "PUBLIC"."training_cost_analysis_20251003082037"."grpjoindt" AS "grpjoindt", "PUBLIC"."training_cost_analysis_20251003082037"."ecompnycode" AS "ecompnycode", "PUBLIC"."training_cost_analysis_20251003082037"."estaffno" AS "estaffno", "PUBLIC"."training_cost_analysis_20251003082037"."ecojoindt" AS "ecojoindt", "PUBLIC"."training_cost_analysis_20251003082037"."eiresigndt" AS "eiresigndt", "PUBLIC"."training_cost_analysis_20251003082037"."ebrhloccode" AS "ebrhloccode", "PUBLIC"."training_cost_analysis_20251003082037"."edivsncode" AS "edivsncode", "PUBLIC"."training_cost_analysis_20251003082037"."edeptcode" AS "edeptcode", "PUBLIC"."training_cost_analysis_20251003082037"."esectiocode" AS "esectiocode", "PUBLIC"."training_cost_analysis_20251003082037"."eunitcode" AS "eunitcode", "PUBLIC"."training_cost_analysis_20251003082037"."ejobcode" AS "ejobcode", "PUBLIC"."training_cost_analysis_20251003082037"."egradecode" AS "egradecode", "PUBLIC"."training_cost_analysis_20251003082037"."eemptypcode" AS "eemptypcode", "PUBLIC"."training_cost_analysis_20251003082037"."ejobname" AS "ejobname", "PUBLIC"."training_cost_analysis_20251003082037"."ejobclscode" AS "ejobclscode", "PUBLIC"."training_cost_analysis_20251003082037"."egrdisexec" AS "egrdisexec", "PUBLIC"."training_cost_analysis_20251003082037"."egrdcatcode" AS "egrdcatcode", "PUBLIC"."training_cost_analysis_20251003082037"."edeptname" AS "edeptname", "PUBLIC"."training_cost_analysis_20251003082037"."vdateyear" AS "vdateyear", "PUBLIC"."training_cost_analysis_20251003082037"."vdatemonth" AS "vdatemonth", "PUBLIC"."training_cost_analysis_20251003082037"."catcode" AS "catcode", "PUBLIC"."training_cost_analysis_20251003082037"."catcodename" AS "catcodename" FROM "PUBLIC"."training_cost_analysis_20251003082037") AS "source" LIMIT 2000 [42102-214] this is a dataset i uploaded in csv

The only explanation that i found was that metabase like records the time that i uploaded the file and works based on that, but if i refresh the metabase system it wont work since the time stamp is now different.

dwhitemv · October 7, 2025, 3:12am

Use the Model that’s created by the upload process as the source data for your questions. DON’T write questions against the upload database tables directly, it will break your questions when things change.

The timestamp is added to ensure the table name is unique.

To update the data in the Model, open the Model, click the upload button on the button bar, then select “Replace all data in this model.” DON’T re-upload the file as a new data source, it will create a new table and leak the old one (Metabase does not clean up old tables in the upload database).

Kzdev · October 8, 2025, 6:46am

I do the as you instructed and i got this error.

dwhitemv · October 8, 2025, 6:40pm

It appears one of the tables has been removed without removing the parent Model.

Check your upload database for errors. Also check with your DBA teams and make sure someone hasn’t been dropping tables in there.