Also, I have viewed the vizsqlserver logs, I don't see any corresponding entries in vizql*.log, and I don't see any log files in wgserver to look further.
Hey, Harish. Do the following:
1. Check the server config value in vizalerts.yaml. What does it say? Navigate to that Tableau Server and log in as a Server Administrator.
2. Go to the Status page and create a list of all hosts running the VizQLServer process.
3. Remote to each of those hosts and search all of the log files in ProgramData\Tableau\Tableau Server\data\tabsvc\logs\vizqlserver (dependingon where you installed Tableau Server to) for the "-1" error. Does it give you any clues?
4. On any of the hosts, open (but do not edit) ProgramData\Tableau\Tableau Server\data\tabsvc\config\workgroup.yml. Search for "wgserver.trusted_hosts". Ensure that the IP address listed is the same that the host you're running VizAlerts on resolves to.
Thanks for your reply:
The Server config value on Vizalerts.yaml is our primary node where tableau server is installed on and configured.
A part from it we have 6 other worker nodes. And Vizalerts is installed on the last node say (workernode 6)
And VizSQL process are running on worker nodes 2 5 and 6.
The wgserver.trusted_hosts set on all server is the IP address of Primary Node. And all the worker hosts ProgramData\Tableau\Tableau Server\data\tabsvc\config\workgroup.yml show wgserver.trusted_hosts as the Ip of our Primary node.
Please let us know if this should be the host ip of server where Vizalerts are installed. i.e., or any other setting we are missing.
Appreciate your help.
Thanks & Regards,
wgserver.trusted_hosts should have the IP of worker node 6. Whichever host runs VizAlerts is where the trusted tickets requests will originate from, and this IP address is what needs to be whitelisted as a trusted host. See this portion of the installation guide.
Thanks Matt for confirming, I will have it modified and configure, as this is our production environment we have to wait till Monday to have the schedule reboots happen on Sunday.
Thanks & Regards,