-
1. Re: Disable all extract refreshes
Patrick A Van Der HydeAug 7, 2017 12:43 PM (in response to Prashantha Madhurashri)
Hello Prashantha,
You can go into the Site -> Schedules menu of each Site configured on your tableau server and then select all - From the same "Actions" menu, select "Disable". This will disable the server refresh until such time you would like to enable them.
I hope that helps.
Patrick
-
2. Re: Disable all extract refreshes
Prashantha Madhurashri Aug 7, 2017 1:18 PM (in response to Patrick A Van Der Hyde)Thanks Patrick but we are planning to refresh our non-prod environment every week(using tabadmin) and every time we refresh, the settings will be overridden. I am looking for some commands to disable this feature so that I can include it as part of the script and don't have to do this(manually) every time we refresh the content from production.
-
3. Re: Disable all extract refreshes
Donna ColesAug 8, 2017 1:06 AM (in response to Prashantha Madhurashri)
2 of 2 people found this helpfulHi Prashantha
Every night we backup & restore content from our primary Tableau server onto a passive 'standby server' using the standard Tableau back up& restore processes. As part of this all the schedules on the standby server become enabled since they are on the primary server, so we need to disable them as we don't want them running.
We do this by scripting an update onto the SCHEDULES table in the postgres repository to set Active = 'f' for all records where Hidden ='f' along the lines of
UPDATE s
SET Active = 'f'
FROM SCHEDULES s
WHERE Hidden = f'
This does mean you will need to enable an account on the postgres database to have write access which isn't something Tableau advocate and you do so at your own risk, but we have been doing this process for several years now with no issue, and it does fill the gap that is lacking in the product.
You may find it useful to vote up this idea to get the feature into the product https://community.tableau.com/ideas/1792
Thanks
Donna
-
4. Re: Disable all extract refreshes
Prashantha Madhurashri Aug 9, 2017 2:43 PM (in response to Donna Coles)Thank you.
-
5. Re: Disable all extract refreshes
Prashantha Madhurashri Aug 9, 2017 2:44 PM (in response to Prashantha Madhurashri)I will try it in our dev environment tomorrow. Thanks for your help!!
-
6. Re: Disable all extract refreshes
Prashantha Madhurashri Aug 29, 2017 10:10 AM (in response to Prashantha Madhurashri)Hello Donna, Do you know how to enable access to postgress(write access) in NON PROD? I have the password but not able to login - getting below error
FATAL: no pg_hba.conf entry for host "<host IP>", user "tblwgadmin", database "workgroup", SSL off