We are testing out performance improvement for our server when we add a worker node to handle all extract refreshes.
When I use a single node, there is no issue.
When I add the worker node, but keep all backgrounders on initial node, no issue.
When I change initial node to have zero backgrounders, and worker to have 2 backgrounders, the Prep Conductor service on the worker node becomes Unlicensed and the server is degraded. Note that we don't use Prep so we don't even need this service - just that it was included in the trial key.
Additionally, all extract refreshes fail with the error:
"The job failed on <blah blah> after running for 1.6 min because of: java.lang.RuntimeException: Unexpected ambiguous schema name. The extract does not contain a schema 'dbo'. Unable to connect to the Tableau Data Extract Server"". Check that the server is running and that you have access privileges to the requested database"
The same job runs without an issue if the backgrounder is on the initial node.
I have 2 suspicions but don't know how to verify these:
- We are testing this using a trial license on both nodes - does a trial key not work for second node?
- IT might not have opened some ports? Not sure which ports though.
Any guidance would be great. Thank you in advance!
Hi @vijayalakshmi g
As this is an old thread, if you get no other replies here you may want to raise a new question referring back to this one.
Ta, Steve
