I've had an issue recently when republishing a data source (added new columns), but the changes are not reflected immediately in the data source on Data Server (sometimes several hours before the data source is refreshed with changes, sometimes several minutes). Oddly, if I download/create a local copy, the changes are reflected in the local copy. But then when I publish again, the changes are not reflected.
I suspect it is related to cache, but not sure. I've checked known issues, but nothing seems relevant.
Has anyone had similar problem?
If it is cache, is there anyway to clear cache without having to stop server (tabadmin command)?
If it is not, any ideas?
Tableau Desktop/Server 9.3.5 (although I also experienced the issue on 9.3.4 and 9.3.3).
Example, column in DB changed from [State Province] to [StateProvince]. I open the data source and download a copy to update the data source. I move dimension back to appropriate folder, then I republish.
When I connect to the data source again, the dimension name is not updated and dimension is not in the folder. I try to add it to a worksheet, and get the following messages:
Upon selecting Yes, the message repeats indefinitely. Upon selecting No, I get this message:
Show Details displays this:
Show Query displays this:
<?xml version='1.0' encoding='utf-8' ?>
<binding name='[State Province]'>
<query-expression class='identifier' user:aggr-type='scalar' user:expr-type='str'>[State Province]</query-expression>
<query-function class='table' table='[sqlproxy]' user:alias='sqlproxy' />
<datasource hasconnection='false' inline='true' name='Parameters' version='9.3'>
<aliases enabled='yes' />
<column caption='FX Rate' datatype='string' name='[Parameter 1]' param-domain-type='list' role='measure' type='nominal' value='"FX Rate Actual"'>
<calculation class='tableau' formula='"FX Rate Actual"' />
<member value='"FX Rate Actual"' />
<member value='"FX Rate Budget"' />
<member value='"FX Rate Current"' />
Message was edited by: Aaron Booth