I am unfortunately also getting this error on several extracts. I opened a support request for this among other issues. Let me know what you find and I'll do the same.
Will do. Thanks, Jeff.
Additionally, a couple other extracts are now failing with a different error. In this case, they fail at 0 seconds. Other extracts complete successfully on the same server.
Full error message:
Tableau Data Engine Error: 4:
Invalid Command: database: Path does not exist. Unable to connect to the server "127.0.0.1". Check that the server is running and that you have access privileges to the requested database.
Errors occurred while trying to load the data source "".
The load was not able to complete successfully.
I am getting that error as well. Sometimes with the unable to connect to 127.0.0.1 portion, sometimes without.
Can you check your windows application log on the server? My hypothesis is that the data extract service is crashing over and over again and causing that inability to connect on localhost error. Here is what I found in my windows app log.
[ Name] Tableau Server
- EventID 4096
[ Qualifiers] 0
[ SystemTime] 2012-11-19T16:42:06.000000000Z
Computer <hostname here>
[ UserID] S-1-5-20
Restarting dead component 'Tableau Server Data Engine Extract Database'.
Hi Branden and Jeff,
I believe our Support team has seen a couple of these instances being reported. A couple of options to resolve the issue are: to delete the extract and re-generate it; or do a server cleanup and restart.
I walked through the cleanup and restart steps here and it had no impact: http://kb.tableausoftware.com/articles/knowledgebase/server-maintenance
I also tried uploading a local version of the given workbook to replace the published workbook which is failing. The over-write was successful, but when I triggered the extract refresh, I got the same error. I also again observed the data server crashing in the system event log.
I have a hunch here. Can you add 127.0.0.1 to your trusted hosts? Here is a KB article for ref if you're unfamiliar. Also, be careful if you already have other trusted hosts added to include them also. If you don't know where to find them ping me and I can send you the path to the config file.
Thanks, Ben. Branden is on vacation, so I'm now looking into this issue. Are you referring to the pg_hba.conf.templ file? If so, ours already has 127.0.0.1. Also, we also customized this file with our admin's IP addresses so we could connect to the Tableau Server database, per other instructions in the Tableau Server user guide.
Here is what we have for 127.0.0.1:
# IPv4 local connections:
host all all 127.0.0.1/32 trust
Waiting to talk to Tableau Support next. Thanks for any additional input in the meantime.
Yep, that's it. Hmm, have you zipped the logs and checked out the Backgrounder log? I have a few other clients that were reporting this also and had to downgrade back to 7.0.5 where they were at before upgrading. I suspect you'll get a response soon.
Yes, we were told by Tableau Support that we had to downgrade. This is a new issue found in 7.0.9.
Thank you, everyone, for your input. Good news: issue is resolved. Bad news: we did have to downgrade to resolve the issue.
According to Tableau Support, this is a bug just discovered in 7.0.9, experienced by a few customers. Full cause is not yet known, nor were we given an expected time for resolution, but we are hopeful in the next patch.
So has there been any news on this?
I am also receiving this error.
Not yet, Kirill. Tableau confirmed it was an issue, and we chose to restore our backup (version 7.0.5).
A new release (7.0.10) went out on December 4, but I didn't see this bug addressed in the release notes.
Any solution to this issue ?
- Tableau Data Engine Error: 4: Invalid Command: database: Path does not exist. Unable to connect to the server "127.0.0.1". Check that the server is running and that you have access privileges to the requested database.