HcArHist is a table that I can 100% guarantee exists. It works fine when I run it on the server. It runs fine a lot of times inside Metabase as well, but every so often we get that error. If I refresh the page a few times it will eventually run, then refresh again and we get the error.
If we add [DATABASE].[dbo] in front of the table name inside the query it will work fine also, but we don’t have to add it in front of every table in the query, just the one giving the error. It is not the same table every time.
If I restart the Metabase server, I will not see the error for a few days. I’ve disabled the rebooting for right now.