Tuesday, 25 August 2015

Tableau Server Log File Location (Helps to find out actual problem that troubling Tableau Server)

By default, Tableau Server log file archives are gathered in a zip file called logs.zip (you can specify a different name if you create the archive using tabadmin). You can copy the archive from the server to a local computer and open it there, or send it to Tableau Support. When you unzip the archive, a series of folders are created with related log files. This table explains the possible contents of each folder, along with the original location the files came from on the Tableau Server, the process that created the log files, and details about the files.
The Tableau Server log directory is C:\ProgramData\Tableau\Tableau Server\data\tabsvc\logs if you installed Tableau Server on drive C, unless otherwise noted in the table below.

Following list of log file location help you to find out respective log files and its description.

Log Archive File Locations

Files/folders in logs.zip Details Files Generated by Location on Tableau Server
buildversion.txtThe build version of Tableau Server.   
tabsvc.yml   \config
wgserver.checksum    
assetkeyencryptionLogs related to repository encryption.assetkeyencryption.log tabadmin assetkeys \logs\assetkeyencryption
backgrounderLogs related to subscriptions and scheduled activities like extract refreshes, "Run Now" tasks, and tabcmd tasks. backgrounder-#.log
spawn.####.log
tomcat-#.####-##-##.log
backgrounder.exe \logs\backgrounder
cacheserverLogs related to the Cache Server process.redis-server.exe\cacheserver
clustercontrollerLogs related to the Cluster Controller process.clustercontroller.log
clustercontroller.log-####-##-##
clustercontroller.exe\clustercontroller
configConfiguration files.
This is a good place to start gathering information when troubleshooting. Confirm that the configuration settings are what you expect.
connections.yml
workgroup.yml
Tableau Server Configuration\config
datacollector   \logs\datacollector
dataengineThere will be a tdeserver log file for each day with information about data extracts and queries, and responses to VizQL server requests.tdeserver_####_##_##_##_##_##.log tdeserver.exe
tdeserver64.exe
\logs\dataengine
dataserverInformation about connections to Tableau Server data sources.dataserver-#.log dataserver.exe \logs\dataserver
httpdApache logs. Look here for authentication entries. Each request in the Apache log will have a request ID associated with it. This request ID is used throughout the server logs and you can use it to associate log entries with a request.access.####-##-##.##-##-##log
error.log
startup.log
Apache daemon\logs\httpd
licensing   \logs\licensing
logsThis is the location of the logs of most interest and usefulness. Look here after reviewing the configuration files.
tabadmin.log is never overwritten or truncated so it contains all the details.
notify-tabadmin.log contains errors from tabadmin.log (the errors are also included in tabadmin.log).
tablicsrv.log and tabsrvlic.log are related to licensing.
tabadmin.log
tabconfig.log
tablicsrv.log
tabsrvlic.log
wgserver.war.deploy.log
 \logs
pgsqlPostgreSQL database logs, including files related to launching server processes.Tableau data extracts are stored in the PostgreSQL database. tabspawn\logs\pgsql
repository  postgres.exe \logs\repository
service notify-tabsvc.log
tabsvc.log
 \logs\service
solrRelated to search indexing.  \logs\solr
svcmonitor   \logs\svcmonitor
tabadminserviceRelated to log archives created using the Generate a Snapshot of Server Log Files option.   \logs\tabadminservice
tabadmwrkServer Worker Manager process that is used for auto-discovery of worker servers in a distributed environment. tabadmwrk.exe\logs\tabadmwrk
vizportal   \logs\vizportal
vizqlserverRelated to showing and interacting with views.
When running multiple instances of VizQL Server, the instances are distinguished by port number.
notify-production logs contain exceptional events.
vizql-0.log.####-##-##
spawn.####.log
vizqlserver.exe \logs\vizqlserver
vizqlserver\logsMost files are in JSON format.
tabprotosrv.txt is created when you open data or connect to data.
backgrounder_####_####_##_##_##_##_##.txt
dataserver_####_####_##_##_##_##_##.txt
tabadmin_####_##_##_##_##_##.txt
tabprotosrv.txt
vizqlserver_####_####_##_##_##_##_##.txt
wgserver_####_####_##_##_##_##_##.txt
tdserver_vizqlserver_####_####_##_##_##_##_##.txt
  \vizqlserver\logs
wgserverInformation related to administrative tasks, workbook and permissions management, authentication, sign-ins, initial view requests, and publishing requests.
Browsing, searching.
Instances of wgserver are distinguished by port number, immediately following "production" or "notify-production".
notify-production logs contain exceptional events.
There will be a separate production.n_### file for each backgrounder process for each day.
notify-production.n_### correlates to production.n_### but contains only errors.
db-migrate_####_##_##_##_##_##.log
migrate.log
notify-production.####_####_##_##_##_##_##.log
production.####.log
production.####_####_##_##_##_##_##.log
spawn.####.log
tomcat-#.####_##_##.log
wgserver-#.log
wgserver.exe \logs\wgserver
zookeeperInformation related to the Tableau Server Coordination Service.spawn.####.log
zookeeper-#.log
zookeeper-#.log.####_##_##
zookeeper.exe \logs\zookeeper

Tableau Server log files can be found in the following folders on the server:

Tableau Service Logs

The following log files track activities related to the web application, database, and index:
C:\ProgramData\Tableau\Tableau Server\data\tabsvc

VizQL Logs

These log files track activities related to displaying views, such as querying the database and generating images:
C:\ProgramData\Tableau\Tableau Server\data\tabsvc\vizqlserver\Logs

Temporary Files

Any file that starts with exe_ in the folder below is a Tableau Server file and can be deleted.
C:\ProgramData\Tableau\Tableau Server\temp


1 comment: