Hi

I am using csv file in as a data source in TabMon. Issues which I am facing is:
1: CSV file is not getting updated regularly
2: Few worksheet are not showing the data itself and the one which are showing data that is not correct.

Please let me know what are the steps I should take to resolve this issue?
Thanks

Hi

Below is the TabMon log file showing many failures. Please clarify what necessary changes should I do to get it alinged?

Log file:

2016-04-07 04:33:30,040 [7] DEBUG TabMon.Counters.Perfmon.PerfmonCounter - Error sampling counter Primary\wtabqnas01\Perfmon\Network Interface\Bytes Received/sec: Counter is not single instance, an instance name needs to be specified.
2016-04-07 04:33:30,040 [7] DEBUG TabMon.Counters.Perfmon.PerfmonCounter - Error sampling counter Primary\wtabqnas01\Perfmon\Network Interface\Bytes Sent/sec: Counter is not single instance, an instance name needs to be specified.
2016-04-07 04:33:31,210 [7] DEBUG TabMon.Counters.Perfmon.PerfmonCounter - Error sampling counter Primary\wtabqnas01\Perfmon\Process% Processor Time\tabprotosrv#9: Instance 'tabprotosrv#9' does not exist in the specified Category.
2016-04-07 04:33:31,257 [7] DEBUG TabMon.Counters.Perfmon.PerfmonCounter - Error sampling counter Primary\wtabqnas01\Perfmon\Process% Processor Time\tabprotosrv#10: Instance 'tabprotosrv#10' does not exist in the specified Category.
2016-04-07 04:33:31,272 [7] DEBUG TabMon.Counters.Perfmon.PerfmonCounter - Error sampling counter Primary\wtabqnas01\Perfmon\Process% Processor Time\tabprotosrv#5: Instance 'tabprotosrv#5' does not exist in the specified Category.
2016-04-07 04:33:31,288 [7] DEBUG TabMon.Counters.Perfmon.PerfmonCounter - Error sampling counter Primary\wtabqnas01\Perfmon\Process% Processor Time\tabprotosrv#4: Instance 'tabprotosrv#4' does not exist in the specified Category.
2016-04-07 04:33:31,335 [7] DEBUG TabMon.Counters.Perfmon.PerfmonCounter - Error sampling counter Primary\wtabqnas01\Perfmon\Process% Processor Time\tabprotosrv#3: Instance 'tabprotosrv#3' does not exist in the specified Category.
2016-04-07 04:33:31,350 [7] DEBUG TabMon.Counters.Perfmon.PerfmonCounter - Error sampling counter Primary\wtabqnas01\Perfmon\Process% Processor Time\tabprotosrv#7: Instance 'tabprotosrv#7' does not exist in the specified Category.
2016-04-07 04:33:31,366 [7] DEBUG TabMon.Counters.Perfmon.PerfmonCounter - Error sampling counter Primary\wtabqnas01\Perfmon\Process% Processor Time\tabprotosrv#6: Instance 'tabprotosrv#6' does not exist in the specified Category.
2016-04-07 04:33:31,382 [7] DEBUG TabMon.Counters.Perfmon.PerfmonCounter - Error sampling counter Primary\wtabqnas01\Perfmon\Process% Processor Time\tabprotosrv#11: Instance 'tabprotosrv#11' does not exist in the specified Category.
2016-04-07 04:33:31,397 [7] DEBUG TabMon.Counters.Perfmon.PerfmonCounter - Error sampling counter Primary\wtabqnas01\Perfmon\Process% Processor Time\tabprotosrv#8: Instance 'tabprotosrv#8' does not exist in the specified Category.
2016-04-07 04:33:32,864 [7] DEBUG TabMon.Counters.Perfmon.PerfmonCounter - Error sampling counter Primary\wtabqnas01\Perfmon\Process\Working Set\tabprotosrv#9: Instance 'tabprotosrv#9' does not exist in the specified Category.
2016-04-07 04:33:32,910 [7] DEBUG TabMon.Counters.Perfmon.PerfmonCounter - Error sampling counter Primary\wtabqnas01\Perfmon\Process\Working Set\tabprotosrv#10: Instance 'tabprotosrv#10' does not exist in the specified Category.
2016-04-07 04:33:32,926 [7] DEBUG TabMon.Counters.Perfmon.PerfmonCounter - Error sampling counter Primary\wtabqnas01\Perfmon\Process\Working Set\tabprotosrv#5: Instance 'tabprotosrv#5' does not exist in the specified Category.
2016-04-07 04:33:32,942 [7] DEBUG TabMon.Counters.Perfmon.PerfmonCounter - Error sampling counter Primary\wtabqnas01\Perfmon\Process\Working Set\tabprotosrv#4: Instance 'tabprotosrv#4' does not exist in the specified Category.
2016-04-07 04:33:33,004 [7] DEBUG TabMon.Counters.Perfmon.PerfmonCounter - Error sampling counter Primary\wtabqnas01\Perfmon\Process\Working Set\tabprotosrv#3: Instance 'tabprotosrv#3' does not exist in the specified Category.
2016-04-07 04:33:33,020 [7] DEBUG TabMon.Counters.Perfmon.PerfmonCounter - Error sampling counter Primary\wtabqnas01\Perfmon\Process\Working Set\tabprotosrv#7: Instance 'tabprotosrv#7' does not exist in the specified Category.
2016-04-07 04:33:33,035 [7] DEBUG TabMon.Counters.Perfmon.PerfmonCounter - Error sampling counter Primary\wtabqnas01\Perfmon\Process\Working Set\tabprotosrv#6: Instance 'tabprotosrv#6' does not exist in the specified Category.
2016-04-07 04:33:33,051 [7] DEBUG TabMon.Counters.Perfmon.PerfmonCounter - Error sampling counter Primary\wtabqnas01\Perfmon\Process\Working Set\tabprotosrv#11: Instance 'tabprotosrv#11' does not exist in the specified Category.
2016-04-07 04:33:33,066 [7] DEBUG TabMon.Counters.Perfmon.PerfmonCounter - Error sampling counter Primary\wtabqnas01\Perfmon\Process\Working Set\tabprotosrv#8: Instance 'tabprotosrv#8' does not exist in the specified Category.
2016-04-07 04:33:33,378 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.getview\AverageRequestLatency\vizportal: Unable to query MBean.
2016-04-07 04:33:33,378 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.getview\RequestsFailed\vizportal: Unable to query MBean.
2016-04-07 04:33:33,378 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.getview\RequestsProcessed\vizportal: Unable to query MBean.
2016-04-07 04:33:33,378 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.guestlogin\AverageRequestLatency\vizportal: Unable to query MBean.
2016-04-07 04:33:33,378 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.guestlogin\RequestsFailed\vizportal: Unable to query MBean.
2016-04-07 04:33:33,378 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.guestlogin\RequestsProcessed\vizportal: Unable to query MBean.
2016-04-07 04:33:33,410 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.runextracttasks\AverageBatchFailure\vizportal: Unable to query MBean.
2016-04-07 04:33:33,410 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.runextracttasks\AverageBatchSize\vizportal: Unable to query MBean.
2016-04-07 04:33:33,410 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.runextracttasks\AverageRequestLatency\vizportal: Unable to query MBean.
2016-04-07 04:33:33,410 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.runextracttasks\RequestsFailed\vizportal: Unable to query MBean.
2016-04-07 04:33:33,410 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.runextracttasks\RequestsProcessed\vizportal: Unable to query MBean.
2016-04-07 04:33:33,410 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.runextractrefreshesonworkbooks\AverageBatchFailure\vizportal: Unable to query MBean.
2016-04-07 04:33:33,410 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.runextractrefreshesonworkbooks\AverageBatchSize\vizportal: Unable to query MBean.
2016-04-07 04:33:33,410 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.runextractrefreshesonworkbooks\AverageRequestLatency\vizportal: Unable to query MBean.
2016-04-07 04:33:33,410 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.runextractrefreshesonworkbooks\RequestsFailed\vizportal: Unable to query MBean.
2016-04-07 04:33:33,410 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.runextractrefreshesonworkbooks\RequestsProcessed\vizportal: Unable to query MBean.
2016-04-07 04:33:33,410 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.runextractrefreshesondatasources\AverageBatchFailure\vizportal: Unable to query MBean.
2016-04-07 04:33:33,410 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.runextractrefreshesondatasources\AverageBatchSize\vizportal: Unable to query MBean.
2016-04-07 04:33:33,410 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.runextractrefreshesondatasources\AverageRequestLatency\vizportal: Unable to query MBean.
2016-04-07 04:33:33,425 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.runextractrefreshesondatasources\RequestsFailed\vizportal: Unable to query MBean.
2016-04-07 04:33:33,425 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.runextractrefreshesondatasources\RequestsProcessed\vizportal: Unable to query MBean.
2016-04-07 04:33:33,425 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.runschedules\AverageBatchFailure\vizportal: Unable to query MBean.
2016-04-07 04:33:33,425 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.runschedules\AverageBatchSize\vizportal: Unable to query MBean.
2016-04-07 04:33:33,425 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.runschedules\AverageRequestLatency\vizportal: Unable to query MBean.
2016-04-07 04:33:33,425 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.runschedules\RequestsFailed\vizportal: Unable to query MBean.
2016-04-07 04:33:33,425 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.runschedules\RequestsProcessed\vizportal: Unable to query MBean.
2016-04-07 04:33:33,441 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.login\AverageRequestLatency\vizportal: Unable to query MBean.
2016-04-07 04:33:33,441 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.login\RequestsFailed\vizportal: Unable to query MBean.
2016-04-07 04:33:33,441 [7] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\wtabqnas01\vizportal\tableau.health.jmx:name=webclientappservice.login\RequestsProcessed\vizportal: Unable to query MBean

Condense our data model to decrease the rows inserted into the database.

All of the Memory, CPU, Disk, and Network dashboards load for me, but Cache Hits, Users, Requests and Latency dont load because the measures used in those sheets/dashboards dont exist in my Postgres repo. See the attached image - a ton of my measures dont exist. Any ideas? (bear in mind this is my local server which only gets used lightly by myself)

In the user guide, under Installing tabmon, it simply says "Run the installer". What is the executable name? Which folder can I find it in? I can't find a file named tabmon.exe or installtabmon.exe anywhere. Am I supposed to build it first?

How does tabmon works with Tableau cluster. I have installed Tabmon on the Primary Gateway server. It appears to capture stats from Primary server. I have edited the config file by adding worker IPs in the tag. Am I doiing something wrong. Please advise.

Hello,

Today I installed TabMon for our 3-node cluster, but I'm only able to see metrics for the primary node. How can I configure TabMon so that it collects data for the other 2 nodes as well?

Thanks,
Angie Greenhaw

Hi,

I am getting following error when trying to create extract.

"The extract has a different time zone from underlying server. Calculations using today() NOW() and relative data filters give different data"

Please help me to create the extract

2016-03-14 10:09:04,560 [6] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\SWPMA1TABLEAU01\vizql\tableau.health.jmx:name=vizqlservice\ExternalQueryCacheHits\vizql: Argument key="ExternalQueryCacheHits" is not an existing item name for this CompositeData instance.
2016-03-14 10:09:04,560 [6] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\SWPMA1TABLEAU01\vizql\tableau.health.jmx:name=vizqlservice\ExternalQueryCacheMisses\vizql: Argument key="ExternalQueryCacheMisses" is not an existing item name for this CompositeData instance.
2016-03-14 10:09:04,575 [6] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\SWPMA1TABLEAU01\vizql\tableau.health.jmx:name=vizqlservice\InProcessQueryCacheHits\vizql: Argument key="InProcessQueryCacheHits" is not an existing item name for this CompositeData instance.
2016-03-14 10:09:04,575 [6] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\SWPMA1TABLEAU01\vizql\tableau.health.jmx:name=vizqlservice\InProcessQueryCacheMisses\vizql: Argument key="InProcessQueryCacheMisses" is not an existing item name for this CompositeData instance.
2016-03-14 10:09:04,638 [6] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\SWPMA1TABLEAU01\vizql\tableau.health.jmx:name=vizqlservice\ExternalQueryCacheHits\vizql#1: Argument key="ExternalQueryCacheHits" is not an existing item name for this CompositeData instance.
2016-03-14 10:09:04,638 [6] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\SWPMA1TABLEAU01\vizql\tableau.health.jmx:name=vizqlservice\ExternalQueryCacheMisses\vizql#1: Argument key="ExternalQueryCacheMisses" is not an existing item name for this CompositeData instance.
2016-03-14 10:09:04,653 [6] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\SWPMA1TABLEAU01\vizql\tableau.health.jmx:name=vizqlservice\InProcessQueryCacheHits\vizql#1: Argument key="InProcessQueryCacheHits" is not an existing item name for this CompositeData instance.
2016-03-14 10:09:04,653 [6] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\SWPMA1TABLEAU01\vizql\tableau.health.jmx:name=vizqlservice\InProcessQueryCacheMisses\vizql#1: Argument key="InProcessQueryCacheMisses" is not an existing item name for this CompositeData instance.
2016-03-14 10:09:04,716 [6] INFO TabMon.Sampler.CounterSampler - Finished polling 247 counters. [8 failures]

Installation went smooth, made all the necessary changes to Tabmon.config file, and Tabmon services are started but countersamples table is not present.

Hi,

I am unable to start tabmon services, below is the error i am seeing in logs.

Anyhelp is appreciated

INFO TabMon.TabMonAgent - Initializing TabMon..
2016-02-04 17:29:14,685 [5] FATAL TabMon.TabMonAgent - Invalid TabMon options specified!
Aborting..
2016-02-04 17:29:14,685 [5] FATAL Topshelf.Runtime.Windows.WindowsServiceHost - The service did not start successfully
Topshelf.TopshelfException: The service did not start successfully (returned false).
at Topshelf.Runtime.Windows.WindowsServiceHost.OnStart(String[] args)

Hello,

I have an issue similar to this one ( #62) . However I am using Tableau Server Version: 9.1.0 (9100.15.0903.2142) 64-bit and the counters.config file has the webclientappservice names (not the old names). Do you have any suggestions on how to restore the references?

I followed the Tabmon user guide for the setup and the JMX ports should be enabled. I get other data in the tabmon data source which seems to confirm this too.

Local Tabmon repo invalid calcs or missing columns
%CPU gradient - invalid
%RAM gradient - invalid

Not exist
%_disk_read_time
%_disk_write_time
%_free_space
Bytes_received/sec
Bytes_sent/sec
Current_disk_queue_length
Disk_read_bytes/sec
Disk_write_bytes/sec
Requests_failed
Requests_processed
%_processor_time
%_committed_bytes
average_batch_failure
average_batch_size
Average_query_latency
average_request_latency
heap_memory_usage\committed
heap_memory_usage\used
non_heap_memory_usage\committed
non_heap_memory_usage\used
Process
Request_processed
Thread_count
Total_compilation_time

Also I wanted to note that I am doing remote polling. Tabmon polling database and tools are installed on my laptop which has access to the dev server. At first I thought firewalls, but I am getting data coming into the tabmon database. But I am open to suggestions!

Here is a screenshot of the config file.

Thanks for your help in advance!

If I see more CPU consumption or Memory consumption for specific period of time, I want to check which workbooks were causing this issue? Do we have a way to check this using tabmon workbook?
If yes, please let me know the steps how to do that?

Hi,

I just installed the Tabmon successfully with the service account that has admin privileges. But when I try to start the Tabmon service from the services.msc, I am getting the below error. Can someone help me on this?

I enabled Tableau server's JMX ports and installed TabMon & the Postgres database. When I went to execute TabMon it was able to successfully open the JMX connections and loaded counters. Once TabMon was initialized it threw the below error.

I was wondering if anyone else experienced this and had a resolution. Or, if anyone has changed the lengths of fields in TabMon's Postgres

2016-03-28 20:38:11,361 [6] FATAL Topshelf.Runtime.Windows.WindowsServiceHost - The service threw an unhandled exception
System.ArgumentException: Cannot set column 'machine'. The value violates the MaxLength limit of this column.
at System.Data.DataColumn.CheckMaxLength(DataRow dr)
at System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction, Boolean fireEvent)
at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge, Boolean suppressEnsurePropertyChanged, Int32 position, Boolean fireEvent, Exception& deferredException)
at System.Data.DataTable.InsertRow(DataRow row, Int64 proposedID, Int32 pos, Boolean fireEvent)
at TabMon.Sampler.CounterSampler.SampleAll()
at TabMon.TabMonAgent.Poll(Object stateInfo)
at System.Threading.TimerQueueTimer.CallCallbackInContext(Object state)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.TimerQueueTimer.CallCallback()
at System.Threading.TimerQueueTimer.Fire()
at System.Threading.TimerQueue.FireNextTimers()
at System.Threading.TimerQueue.AppDomainTimerCallback()

"2016-05-09 09:11:20,519 [5] INFO TabMon.CounterConfig.CounterConfigLoader - Loaded 74 MBean counters on n4dtab1.
2016-05-09 09:11:20,519 [5] DEBUG TabMon.TabMonAgent - Successfully loaded 373 counters from configuration file.
2016-05-09 09:11:20,535 [5] DEBUG TabMon.Sampler.CounterSampler - Dynamically built result schema 'countersamples'. [48 columns]
2016-05-09 09:11:20,535 [5] INFO TabMon.TabMonAgent - TabMon initialized! Starting performance counter polling..
2016-05-09 09:11:20,535 [5] INFO Topshelf.Runtime.Windows.WindowsServiceHost - [Topshelf] Started
2016-05-09 09:11:20,535 [6] INFO TabMon.Sampler.CounterSampler - Polling..
2016-05-09 09:11:20,550 [6] FATAL Topshelf.Runtime.Windows.WindowsServiceHost - The service threw an unhandled exception
System.ArgumentException: Cannot set column 'instance'. The value violates the MaxLength limit of this column.**
at System.Data.DataColumn.CheckMaxLength(DataRow dr)
at System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction, Boolean fireEvent)
at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge, Boolean suppressEnsurePropertyChanged, Int32 position, Boolean fireEvent, Exception& deferredException)
at System.Data.DataTable.InsertRow(DataRow row, Int64 proposedID, Int32 pos, Boolean fireEvent)
at TabMon.Sampler.CounterSampler.SampleAll()
at TabMon.TabMonAgent.Poll(Object stateInfo)"

Hi , I am getting the error stated above, but would have not idea where to begin resolving. Its a big ask, but you help would be much appreciated .

Many thanks

This is a task to update the official TabMon documentation to include troubleshooting steps for the common user pain points we've seen so far.

HI

When I am connecting the data source the visualization on worksheet is showing the updated data.But when I am clicking on data source on view data option it is showing back date data.How to resolve this one?
Also, Is there a limit that for maximum size of csv file getting generated?

My main requirement is that csv file should contain data for one week. After the completion of week automatically a new csv file should get generated and data should be updated in that for rest of the week.
How to achieve this result?

Thanks
Rishabh

Hello,

I am able to start Tabmon on our primary Server node, but when I try to stop it (by clicking on the Stop tabmon app in the UI with "Run as Administrator" the service continues to show as running in Task Manager. Is it better to just stop the service in the Services tab of Task Manager? What is the recommended approach?

Thanks,
Angie Greenhaw

Hi

I am using csv file as data source in TabMon. A new csv file is generated whenever I stop and start Tabmon. The file which is getting generated has file name including date and time. If I want to control filename is that possible?

Also, I checked the csv file data. It is gathering large amount of data. Is there a way that I can control data?

Thanks
Rishabh

I am getting the following Error when I try to install TabMon:

Here is the log that is generated:

[151C:0384][2015-10-27T14:49:02]i001: Burn v3.9.1208.0, Windows v6.1 (Build 7601: Service Pack 1), path: C:\Users\poverpec\Desktop\InstallTabMon.exe, cmdline: '-burn.unelevated BurnPipe.{B9E27659-0675-464B-A33B-D55AF1AA8034} {C6320831-8E19-4C19-A115-EADD3D7FF527} 6104 '
[151C:0384][2015-10-27T14:49:02]i000: Initializing string variable 'InstallFolder' to value '[ProgramFilesFolder]TabMon'
[151C:0384][2015-10-27T14:49:02]i000: Initializing string variable 'InstallFolder2' to value '[WindowsVolume]Postgres'
[151C:0384][2015-10-27T14:49:02]i000: Initializing numeric variable 'OptionInstallPostgres' to value '1'
[151C:0384][2015-10-27T14:49:02]i000: Initializing numeric variable 'OptionCreateStartMenuShortcuts' to value '1'
[151C:0384][2015-10-27T14:49:02]i000: Initializing string variable 'PostgresPort' to value '5432'
[151C:0384][2015-10-27T14:49:02]i000: Initializing string variable 'PostgresUsername' to value 'tabmon'
[151C:0384][2015-10-27T14:49:02]i000: Initializing string variable 'PostgresPassword' to value 'password'
[151C:0384][2015-10-27T14:49:02]i000: Setting string variable 'WixBundleLog' to value 'C:\Users\poverpec\AppData\Local\Temp\TabMon_20151027144902.log'
[151C:0384][2015-10-27T14:49:02]i000: Setting string variable 'WixBundleOriginalSource' to value 'C:\Users\poverpec\Desktop\InstallTabMon.exe'
[151C:0384][2015-10-27T14:49:02]i000: Setting string variable 'WixBundleOriginalSourceFolder' to value 'C:\Users\poverpec\Desktop'
[151C:0384][2015-10-27T14:49:02]i000: Setting string variable 'WixBundleName' to value 'TabMon'
[151C:15E4][2015-10-27T14:49:02]i000: Setting version variable 'WixBundleFileVersion' to value '2.0.5762.41569'
[151C:0384][2015-10-27T14:49:02]i100: Detect begin, 4 packages
[151C:0384][2015-10-27T14:49:02]i000: Setting string variable 'NETFRAMEWORK45' to value '378389'
[151C:0384][2015-10-27T14:49:02]i000: Setting numeric variable 'HasPowershellVersion3' to value 1
[151C:0384][2015-10-27T14:49:02]i052: Condition 'NETFRAMEWORK45 >= 378389' evaluates to true.
[151C:0384][2015-10-27T14:49:02]i101: Detected package: NetFx45Web, state: Present, cached: None
[151C:0384][2015-10-27T14:49:02]i101: Detected package: postgresql.exe, state: Absent, cached: None
[151C:0384][2015-10-27T14:49:02]i101: Detected package: MainPackage, state: Absent, cached: None
[151C:0384][2015-10-27T14:49:02]i101: Detected package: PostgresInitializer, state: Absent, cached: None
[151C:0384][2015-10-27T14:49:02]i052: Condition 'HasPowershellVersion3' evaluates to true.
[151C:0384][2015-10-27T14:49:02]i199: Detect complete, result: 0x0
[151C:15E4][2015-10-27T14:50:46]i000: Setting numeric variable 'OptionInstallPostgres' to value 1
[151C:0384][2015-10-27T14:50:46]i200: Plan begin, 4 packages, action: Install
[151C:0384][2015-10-27T14:50:46]w321: Skipping dependency registration on package with no dependency providers: NetFx45Web
[151C:0384][2015-10-27T14:50:46]i052: Condition 'OptionInstallPostgres' evaluates to true.
[151C:0384][2015-10-27T14:50:46]w321: Skipping dependency registration on package with no dependency providers: postgresql.exe
[151C:0384][2015-10-27T14:50:46]i000: Setting string variable 'WixBundleLog_postgresql.exe' to value 'C:\Users\poverpec\AppData\Local\Temp\TabMon_20151027144902_0_postgresql.exe.log'
[151C:0384][2015-10-27T14:50:46]i000: Setting string variable 'WixBundleRollbackLog_postgresql.exe' to value 'C:\Users\poverpec\AppData\Local\Temp\TabMon_20151027144902_0_postgresql.exe_rollback.log'
[151C:0384][2015-10-27T14:50:46]i000: Setting string variable 'WixBundleRollbackLog_MainPackage' to value 'C:\Users\poverpec\AppData\Local\Temp\TabMon_20151027144902_1_MainPackage_rollback.log'
[151C:0384][2015-10-27T14:50:46]i000: Setting string variable 'WixBundleLog_MainPackage' to value 'C:\Users\poverpec\AppData\Local\Temp\TabMon_20151027144902_1_MainPackage.log'
[151C:0384][2015-10-27T14:50:46]i052: Condition 'OptionInstallPostgres' evaluates to true.
[151C:0384][2015-10-27T14:50:46]i000: Setting string variable 'WixBundleRollbackLog_PostgresInitializer' to value 'C:\Users\poverpec\AppData\Local\Temp\TabMon_20151027144902_2_PostgresInitializer_rollback.log'
[151C:0384][2015-10-27T14:50:46]i000: Setting string variable 'WixBundleLog_PostgresInitializer' to value 'C:\Users\poverpec\AppData\Local\Temp\TabMon_20151027144902_2_PostgresInitializer.log'
[151C:0384][2015-10-27T14:50:46]i201: Planned package: NetFx45Web, state: Present, default requested: Present, ba requested: Present, execute: None, rollback: None, cache: No, uncache: No, dependency: None
[151C:0384][2015-10-27T14:50:46]i201: Planned package: postgresql.exe, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: Uninstall, cache: Yes, uncache: No, dependency: None
[151C:0384][2015-10-27T14:50:46]i201: Planned package: MainPackage, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: Uninstall, cache: Yes, uncache: No, dependency: Register
[151C:0384][2015-10-27T14:50:46]i201: Planned package: PostgresInitializer, state: Absent, default requested: Present, ba requested: Present, execute: Install, rollback: Uninstall, cache: Yes, uncache: No, dependency: Register
[151C:0384][2015-10-27T14:50:46]i299: Plan complete, result: 0x0
[151C:0384][2015-10-27T14:50:46]i300: Apply begin
[17D8:02D4][2015-10-27T14:50:47]i000: Caching bundle from: 'C:\Users\poverpec\AppData\Local\Temp{f3e0f9a3-42d5-4e51-ba66-d9ea9f1d5e34}.be\InstallTabMon.exe' to: 'C:\ProgramData\Package Cache{f3e0f9a3-42d5-4e51-ba66-d9ea9f1d5e34}\InstallTabMon.exe'
[17D8:02D4][2015-10-27T14:50:47]i320: Registering bundle dependency provider: {f3e0f9a3-42d5-4e51-ba66-d9ea9f1d5e34}, version: 2.0.5762.41569
[17D8:0788][2015-10-27T14:50:48]i305: Verified acquired payload: postgresql.exe at path: C:\ProgramData\Package Cache.unverified\postgresql.exe, moving to: C:\ProgramData\Package Cache\E00C723134E29DFCA28E476541F7559881647872\postgresql.exe.
[17D8:0788][2015-10-27T14:50:48]i305: Verified acquired payload: MainPackage at path: C:\ProgramData\Package Cache.unverified\MainPackage, moving to: C:\ProgramData\Package Cache{536D8BB3-4D4F-4FAD-AEFA-EB7944FEB174}v2.0.2\TabMon.msi.
[17D8:0788][2015-10-27T14:50:48]i305: Verified acquired payload: PostgresInitializer at path: C:\ProgramData\Package Cache.unverified\PostgresInitializer, moving to: C:\ProgramData\Package Cache{8C3192D8-9D23-4C20-BBCE-459B898CD916}v1.0.0.0\TabMonServiceInstallerDBInitializer.msi.
[17D8:02D4][2015-10-27T14:50:48]i301: Applying execute package: postgresql.exe, action: Install, path: C:\ProgramData\Package Cache\E00C723134E29DFCA28E476541F7559881647872\postgresql.exe, arguments: '"C:\ProgramData\Package Cache\E00C723134E29DFCA28E476541F7559881647872\postgresql.exe" --mode unattended --prefix "C:\Postgres" --extract-only 1'
[151C:0384][2015-10-27T14:51:21]i319: Applied execute package: postgresql.exe, result: 0x0, restart: None
[17D8:02D4][2015-10-27T14:51:21]i323: Registering package dependency provider: {536D8BB3-4D4F-4FAD-AEFA-EB7944FEB174}, version: 2.0.2, package: MainPackage
[17D8:02D4][2015-10-27T14:51:21]i301: Applying execute package: MainPackage, action: Install, path: C:\ProgramData\Package Cache{536D8BB3-4D4F-4FAD-AEFA-EB7944FEB174}v2.0.2\TabMon.msi, arguments: ' ARPSYSTEMCOMPONENT="1" MSIFASTINSTALL="7" INSTALLFOLDER="C:\Program Files (x86)\TabMon " INSTALLSHORTCUTS="1"'
[151C:0384][2015-10-27T14:51:32]i319: Applied execute package: MainPackage, result: 0x0, restart: None
[17D8:02D4][2015-10-27T14:51:32]i325: Registering dependency: {f3e0f9a3-42d5-4e51-ba66-d9ea9f1d5e34} on package provider: {536D8BB3-4D4F-4FAD-AEFA-EB7944FEB174}, package: MainPackage
[17D8:02D4][2015-10-27T14:51:32]i323: Registering package dependency provider: {8C3192D8-9D23-4C20-BBCE-459B898CD916}, version: 1.0.0.0, package: PostgresInitializer
[17D8:02D4][2015-10-27T14:51:32]i301: Applying execute package: PostgresInitializer, action: Install, path: C:\ProgramData\Package Cache{8C3192D8-9D23-4C20-BBCE-459B898CD916}v1.0.0.0\TabMonServiceInstallerDBInitializer.msi, arguments: ' ARPSYSTEMCOMPONENT="1" MSIFASTINSTALL="7" INSTALLFOLDER="C:\Program Files (x86)\TabMon" POSTGRESFOLDER="C:\Postgres" PORT="5432" USERNAME="tabmon" PASSWORD="password"'
[17D8:02D4][2015-10-27T14:51:43]e000: Error 0x80070643: Failed to install MSI package.
[17D8:02D4][2015-10-27T14:51:43]e000: Error 0x80070643: Failed to execute MSI package.
[151C:0384][2015-10-27T14:51:43]e000: Error 0x80070643: Failed to configure per-machine MSI package.
[151C:0384][2015-10-27T14:51:43]i319: Applied execute package: PostgresInitializer, result: 0x80070643, restart: None
[151C:0384][2015-10-27T14:51:43]e000: Error 0x80070643: Failed to execute MSI package.
[17D8:02D4][2015-10-27T14:51:43]i318: Skipped rollback of package: PostgresInitializer, action: Uninstall, already: Absent
[151C:0384][2015-10-27T14:51:43]i319: Applied rollback package: PostgresInitializer, result: 0x0, restart: None
[17D8:02D4][2015-10-27T14:51:43]i329: Removed package dependency provider: {8C3192D8-9D23-4C20-BBCE-459B898CD916}, package: PostgresInitializer
[17D8:02D4][2015-10-27T14:51:43]i351: Removing cached package: PostgresInitializer, from path: C:\ProgramData\Package Cache{8C3192D8-9D23-4C20-BBCE-459B898CD916}v1.0.0.0
[151C:0384][2015-10-27T14:51:44]i399: Apply complete, result: 0x80070643, restart: None, ba requested restart: No

We installed tabmon few minutes back and when trying to access the tabmon workbook, got the error as shown below. can you please suggest why the error and what the fix to the error is?

I also tried to check for dbcreation log.. couldnt find one. there is a tabmon log.
also, when i tried to start & stop tabmon.. a CSV file was generated but most of the counters were null. please suggest.

Hi
I installed TabMon on a Windows Server 2012 R2 server, and when I am trying to check the dashboards on TabMonWorkbook, I noticed that there are many missed fields in the TabMon datasource. Due this issue, obviously many of dashboards does not show information.

Here is a list with some of the missing fields
1.- active_sessions
2.- average_batch_failure
3.- average_batch_size
4.- average_batch_latency
5.- average_request_latency
6.- External Abstract Query Hit Ratio
7.- External Abstract Query Hit Ratio
8.- External Abstract Query Hit Ratio
9.- external_abstract_query_cache_misses
10.- external_abstract_query_cache_misses

Notes
1.- TabMon appears is working OK.
2.- I'm using Tableau Desktop 9.2.6 to open the workbook.

Attached Images:

Do you know why I have these missing fields?

I would appreciate any help.

Best Regards
José Alberto

Looks like 9.2 updated some of the mbean names. I noticed these errors shortly after upgrading to 9.2:

2015-12-16 18:09:14,585 [6] INFO TabMon.Sampler.CounterSampler - Polling..
2015-12-16 18:09:16,184 [6] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\tableau\vizql\tableau.health.jmx:name=vizqlservice\ExternalQueryCacheHits\vizql: Argument key="ExternalQueryCacheHits" is not an existing item name for this CompositeData instance.
2015-12-16 18:09:16,184 [6] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\tableau\vizql\tableau.health.jmx:name=vizqlservice\ExternalQueryCacheMisses\vizql: Argument key="ExternalQueryCacheMisses" is not an existing item name for this CompositeData instance.
2015-12-16 18:09:16,199 [6] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\tableau\vizql\tableau.health.jmx:name=vizqlservice\InProcessQueryCacheHits\vizql: Argument key="InProcessQueryCacheHits" is not an existing item name for this CompositeData instance.
2015-12-16 18:09:16,199 [6] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\tableau\vizql\tableau.health.jmx:name=vizqlservice\InProcessQueryCacheMisses\vizql: Argument key="InProcessQueryCacheMisses" is not an existing item name for this CompositeData instance.
2015-12-16 18:09:16,246 [6] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\tableau\vizql\tableau.health.jmx:name=vizqlservice\ExternalQueryCacheHits\vizql#1: Argument key="ExternalQueryCacheHits" is not an existing item name for this CompositeData instance.
2015-12-16 18:09:16,246 [6] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\tableau\vizql\tableau.health.jmx:name=vizqlservice\ExternalQueryCacheMisses\vizql#1: Argument key="ExternalQueryCacheMisses" is not an existing item name for this CompositeData instance.
2015-12-16 18:09:16,246 [6] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\tableau\vizql\tableau.health.jmx:name=vizqlservice\InProcessQueryCacheHits\vizql#1: Argument key="InProcessQueryCacheHits" is not an existing item name for this CompositeData instance.
2015-12-16 18:09:16,262 [6] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\tableau\vizql\tableau.health.jmx:name=vizqlservice\InProcessQueryCacheMisses\vizql#1: Argument key="InProcessQueryCacheMisses

Sure enough, I attached with jconsole and I see that several vizqlserver mbeans names are different now....For example, InProcessQueryCacheHits is now. InProcessAbstractQueryCacheHits (image attached)

Please update Counters.config in a 9.2-specific branch to fix this. Gracias!

Hello,

I am extending TabMon with a few configuration item using Visual Studio 14 Community edition. After changing the xsd file I do not see any option to regenerate the TabMonConfigSection.cs file. Also, the build does not re-generate it.

What should I do? Could you complete the developer docs including the required tools and processes for the config file schema changes?

Many thanks

One of my customers has requested a feature that would force tabmon to only store data in postgres once performance metrics such as CPU and RAM exceed 70% usage. The reason for this Feature Request is that the customer does not want to use up too much space in their Postgres Database and they find that having data on when performance metrics exceed a threshold is more useful to them.

Hi,

I deployed TabMon and everything works fine so far. However when i open the TabMonWorkbook, i can't see any data or charts. It seems to be blank.
Not sure if TabMon supports Tableau 9.2 here, as I used the latest version already.

Thanks!
Nguyen

Whenever I go into Tabmon, it takes 8+ minutes to render the view for the last 24 hours. Is this normal?

HI,

Can you please let me know there are nearly 70 postgres processes running on my TabMon.
what do they exactly mean.

This might be due to something simple I missed. The perfmon counters are not updated in the tabmon database. I have made sure these are turned on in the server. I'm running Tabmon from a remote pc. Users have been added to Performance Monitor Users group in the Tableau server.

Here is the log for Tabmon -

2016-03-22 13:08:03,685 [5] INFO TabMon.Config.TabMonConfigReader - Loading TabMon user configuration..
2016-03-22 13:08:03,748 [5] DEBUG TabMon.Config.TabMonConfigReader - Loading database configuration..
2016-03-22 13:08:03,764 [5] INFO TabMon.Config.TabMonConfigReader - Connecting to results database..
2016-03-22 13:08:04,107 [5] DEBUG TabMon.Helpers.HostnameHelper - Successfully resolved 'deleted.net' to 'deleted'.
2016-03-22 13:08:04,123 [5] INFO TabMon.Config.TabMonConfigReader - Successfully loaded TabMon config options! [Host='Primary\deleted', Writer='Database Writer (Postgres Driver)', PollInterval='30', TableName='countersamples']
2016-03-22 13:08:04,123 [5] INFO TabMon.TabMonAgent - Initializing TabMon..
2016-03-22 13:08:04,123 [5] INFO TabMon.TabMonAgent - Loading performance counters from C:\Program Files (x86)\TabMon\Config\Counters.config..
2016-03-22 13:08:04,139 [5] DEBUG TabMon.CounterConfig.CounterConfigLoader - Successfully validated 'Config\Counters.config' against 'Resources\CountersConfig.xsd'.
2016-03-22 13:08:04,139 [5] DEBUG TabMon.CounterConfig.CounterConfigLoader - Loading Perfmon counters..
2016-03-22 13:08:04,170 [5] ERROR TabMon.Counters.Perfmon.PerfmonCounterLoader - Could not communicate with Perfmon on target host 'deleted': Access is denied
2016-03-22 13:08:04,170 [5] DEBUG TabMon.Counters.Perfmon.PerfmonCounterLoader - Counter '% Free Space' in category 'LogicalDisk' on host 'deleted' does not exist.
2016-03-22 13:08:04,170 [5] ERROR TabMon.Counters.Perfmon.PerfmonCounterLoader - Could not communicate with Perfmon on target host 'deleted': Access is denied
2016-03-22 13:08:04,170 [5] DEBUG TabMon.Counters.Perfmon.PerfmonCounterLoader - Counter '% Committed Bytes In Use' in category 'Memory' on host 'deleted' does not exist.
2016-03-22 13:08:04,185 [5] ERROR TabMon.Counters.Perfmon.PerfmonCounterLoader - Could not communicate with Perfmon on target host 'deleted': Access is denied
2016-03-22 13:08:04,185 [5] DEBUG TabMon.Counters.Perfmon.PerfmonCounterLoader - Counter 'Bytes Received/sec' in category 'Network Interface' on host 'deleted' does not exist.
2016-03-22 13:08:04,185 [5] ERROR TabMon.Counters.Perfmon.PerfmonCounterLoader - Could not communicate with Perfmon on target host 'deleted': Access is denied
2016-03-22 13:08:04,185 [5] DEBUG TabMon.Counters.Perfmon.PerfmonCounterLoader - Counter 'Bytes Sent/sec' in category 'Network Interface' on host 'deleted' does not exist.
2016-03-22 13:08:04,201 [5] ERROR TabMon.Counters.Perfmon.PerfmonCounterLoader - Could not communicate with Perfmon on target host 'deleted': Access is denied
2016-03-22 13:08:04,201 [5] DEBUG TabMon.Counters.Perfmon.PerfmonCounterLoader - Counter '% Disk Read Time' in category 'PhysicalDisk' on host 'deleted' does not exist.
2016-03-22 13:08:04,201 [5] ERROR TabMon.Counters.Perfmon.PerfmonCounterLoader - Could not communicate with Perfmon on target host 'deleted': Access is denied
2016-03-22 13:08:04,201 [5] DEBUG TabMon.Counters.Perfmon.PerfmonCounterLoader - Counter '% Disk Write Time' in category 'PhysicalDisk' on host 'deleted' does not exist.
2016-03-22 13:08:04,217 [5] ERROR TabMon.Counters.Perfmon.PerfmonCounterLoader - Could not communicate with Perfmon on target host 'deleted': Access is denied
2016-03-22 13:08:04,217 [5] DEBUG TabMon.Counters.Perfmon.PerfmonCounterLoader - Counter 'Current Disk Queue Length' in category 'PhysicalDisk' on host 'deleted' does not exist.
2016-03-22 13:08:04,217 [5] ERROR TabMon.Counters.Perfmon.PerfmonCounterLoader - Could not communicate with Perfmon on target host 'deleted': Access is denied
2016-03-22 13:08:04,217 [5] DEBUG TabMon.Counters.Perfmon.PerfmonCounterLoader - Counter 'Disk Write Bytes/sec' in category 'PhysicalDisk' on host 'deleted' does not exist.
2016-03-22 13:08:04,232 [5] ERROR TabMon.Counters.Perfmon.PerfmonCounterLoader - Could not communicate with Perfmon on target host 'deleted': Access is denied
2016-03-22 13:08:04,232 [5] DEBUG TabMon.Counters.Perfmon.PerfmonCounterLoader - Counter 'Disk Read Bytes/sec' in category 'PhysicalDisk' on host 'deleted' does not exist.
2016-03-22 13:08:04,232 [5] ERROR TabMon.Counters.Perfmon.PerfmonCounterLoader - Could not communicate with Perfmon on target host 'deleted': Access is denied
2016-03-22 13:08:04,232 [5] DEBUG TabMon.Counters.Perfmon.PerfmonCounterLoader - Counter '% Processor Time' in category 'Process' on host 'deleted' does not exist.
2016-03-22 13:08:04,248 [5] ERROR TabMon.Counters.Perfmon.PerfmonCounterLoader - Could not communicate with Perfmon on target host 'deleted': Access is denied
2016-03-22 13:08:04,248 [5] DEBUG TabMon.Counters.Perfmon.PerfmonCounterLoader - Counter 'Thread Count' in category 'Process' on host 'deleted' does not exist.
2016-03-22 13:08:04,248 [5] ERROR TabMon.Counters.Perfmon.PerfmonCounterLoader - Could not communicate with Perfmon on target host 'deleted': Access is denied
2016-03-22 13:08:04,248 [5] DEBUG TabMon.Counters.Perfmon.PerfmonCounterLoader - Counter 'Working Set' in category 'Process' on host 'deleted' does not exist.
2016-03-22 13:08:04,264 [5] ERROR TabMon.Counters.Perfmon.PerfmonCounterLoader - Could not communicate with Perfmon on target host 'deleted': Access is denied
2016-03-22 13:08:04,264 [5] DEBUG TabMon.Counters.Perfmon.PerfmonCounterLoader - Counter '% Processor Time' in category 'Processor' on host 'deleted' does not exist.
2016-03-22 13:08:04,264 [5] ERROR TabMon.Counters.Perfmon.PerfmonCounterLoader - Could not communicate with Perfmon on target host 'deleted': Access is denied
2016-03-22 13:08:04,264 [5] DEBUG TabMon.Counters.Perfmon.PerfmonCounterLoader - Counter 'Processes' in category 'System' on host 'deleted' does not exist.
2016-03-22 13:08:04,264 [5] INFO TabMon.CounterConfig.CounterConfigLoader - Loaded 0 Perfmon counters on deleted.
2016-03-22 13:08:04,279 [5] DEBUG TabMon.CounterConfig.CounterConfigLoader - Loading MBean counters..

The IsMultiInstance() method in PerfmonCounterLoader can currently return false for multi-instance categories containing only a single counter instance.

We should correct this by using the PerformanceCounterCategory CategoryType property in this method instead of the length of instance names collection.

I've started up the Tabmon and Postgres services. I've checked the log, and the only errors I see there are regarding the network interface counter not being a single instance (which appears to be a known problem). I started up the workbook and successfully entered the Server Auditing and Tabmon passwords. I have confirmed that the data sources are passing data, however the dashboards are all completely blank (except for the Glossary). I see all the dashboard tabs, and the sheet headers ("%CPU by Tableau Server Service - Select to See Details), and I can even go to the sheets and confirm they're defined, but they're not showing any data. The only page that has anything on it is the Glossary. It appears to be showing live data, because the numbers change when I refresh the data. Any suggestions?

User documentation should be updated to clarify the following points:

• TabMon does not delete data.
• By default, all date is saved forever.
• Data management is left to the user.

Currently we load all of the PerfMon counters at service start, and anything that doesn't exist is ignored for the lifetime of the service.

In order to properly monitor transitory processes (i.e. tabprotosrv) we need to update the logic to retry missing counters at each polling cycle.

log:

2016-05-03 12:43:09,094 [5] INFO Topshelf.Runtime.Windows.WindowsServiceHost - [Topshelf] Started
2016-05-03 12:43:09,094 [6] INFO TabMon.Sampler.CounterSampler - Polling..
2016-05-03 12:43:09,109 [6] FATAL Topshelf.Runtime.Windows.WindowsServiceHost - The service threw an unhandled exception
System.ArgumentException: Cannot set column 'machine'. The value violates the MaxLength limit of this column.
at System.Data.DataColumn.CheckMaxLength(DataRow dr)
at System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction, Boolean fireEvent)
at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge, Boolean suppressEnsurePropertyChanged, Int32 position, Boolean fireEvent, Exception& deferredException)
at System.Data.DataTable.InsertRow(DataRow row, Int64 proposedID, Int32 pos, Boolean fireEvent)
at TabMon.Sampler.CounterSampler.SampleAll()
at TabMon.TabMonAgent.Poll(Object stateInfo)
at System.Threading.TimerQueueTimer.CallCallbackInContext(Object state)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.TimerQueueTimer.CallCallback()
at System.Threading.TimerQueueTimer.Fire()
at System.Threading.TimerQueue.FireNextTimers()
at System.Threading.TimerQueue.AppDomainTimerCallback()

Hi Team,
I am struggling to make TabMon work on our machines. Everytime ending up with the same issue
Error 5: Access is denied.
Kindly please look into the issue and let me know what steps should I take to make it work.

OS : Windows Server 2008 R2
Followed thread #9, did clean installation of TabMon but still no use.

Log files

TabMon.log.txt

2016-03-15 23:53:05,420 [5] INFO TabMon.Config.TabMonConfigReader - Loading TabMon user configuration..
2016-03-15 23:53:05,471 [5] DEBUG TabMon.Config.TabMonConfigReader - Loading database configuration..
2016-03-15 23:53:05,473 [5] INFO TabMon.Config.TabMonConfigReader - Connecting to results database..
2016-03-15 23:53:05,600 [5] FATAL TabMon.Config.TabMonConfigReader - Could not initialize writer: FATAL: 28P01: password authentication failed for user "tabmon"
2016-03-15 23:53:05,602 [5] DEBUG TabMon.Helpers.HostnameHelper - Successfully resolved 'localhost' to 'ENGTBLVM01-STG'.
2016-03-15 23:53:05,609 [5] FATAL TabMon.Config.TabMonConfigReader - Invalid options in configuration: [Host='Primary\ENGTBLVM01-STG', Writer='null', PollInterval='30', TableName='countersamples']
2016-03-15 23:53:05,610 [5] INFO TabMon.TabMonAgent - Initializing TabMon..
2016-03-15 23:53:05,610 [5] FATAL TabMon.TabMonAgent - Invalid TabMon options specified!
Aborting..
2016-03-15 23:53:05,610 [5] FATAL Topshelf.Runtime.Windows.WindowsServiceHost - The service did not start successfully
Topshelf.TopshelfException: The service did not start successfully (returned false).

at Topshelf.Runtime.Windows.WindowsServiceHost.OnStart(String[] args)

DBCreation.log

Ok.

The files belonging to this database system will be owned by user "SYSTEM".
This user must also own the server process.

The database cluster will be initialized with locale "English_United States.1252".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory C:/Postgres/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... windows
creating configuration files ... ok
creating template1 database in C:/Postgres/data/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating collations ... not supported on this platform
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
loading PL/pgSQL server-side language ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok
syncing data to disk ... ok

Success. You can now start the database server using:

"C:\Postgres\bin\postgres" -D "C:\Postgres\data"

or
"C:\Postgres\bin\pg_ctl" -D "C:\Postgres\data" -l logfile start

restart-service : Failed to start service 'TabMon-Postgres (TabMon-Postgres)'.
At C:\Program Files (x86)\TabMon\PGSetup.ps1:29 char:1

• restart-service $ServiceName *>> $LogDir\DBCreation.log;

• - CategoryInfo          : OpenError: (System.ServiceProcess.ServiceController:ServiceController) [Restart-Service], ServiceC 
    ommandException
  - FullyQualifiedErrorId : StartServiceFailed,Microsoft.PowerShell.Commands.RestartServiceCommand
  
  

.\createdb : createdb: could not connect to database template1: fe_sendauth: no password supplied
At C:\Program Files (x86)\TabMon\PGSetup.ps1:33 char:1

• .\createdb --port=$Port --username=$SuperUser --owner=$SuperUser --no-password $ ...

• - CategoryInfo          : NotSpecified: (createdb: could...ssword supplied:String) [], RemoteException
  - FullyQualifiedErrorId : NativeCommandError
  
  

.\psql : psql: fe_sendauth: no password supplied
At C:\Program Files (x86)\TabMon\PGSetup.ps1:34 char:1

• .\psql --dbname=$DBname --username=$SuperUser -w --port=$Port --command="CREATE ...

• - CategoryInfo          : NotSpecified: (psql: fe_sendauth: no password supplied:String) [], RemoteException
  - FullyQualifiedErrorId : NativeCommandError
  
  

restart-service : Failed to start service 'TabMon-Postgres (TabMon-Postgres)'.
At C:\Program Files (x86)\TabMon\PGSetup.ps1:41 char:1

• restart-service $ServiceName *>> $LogDir\DBCreation.log;

• - CategoryInfo          : OpenError: (System.ServiceProcess.ServiceController:ServiceController) [Restart-Service], ServiceC 
    ommandException
  - FullyQualifiedErrorId : StartServiceFailed,Microsoft.PowerShell.Commands.RestartServiceCommand
  
  

Regards,
Imtiyaz

The Memory in Use view is showing over 140% for the last 10 hours, before finally dropping below 80% this morning. Our actual memory usage never went above 80% in the last 24 hours. From what I understand of % Committed Bytes in Use, hitting 100% indicates you're using all real memory, as well as all page memory, so results above 100% should be impossible. Am I misinterpreting these numbers, or is this a bug?

How do you guys plan to support Linux Workers? As I understood Tableau Server on Linux is pretty close to public release and I am wondering how the current code base would work on linux.

Like how it compiles with mono

We setup tabmon about a week ago. But as more info gets added to the DB it begins to run extremely slow <30 seconds for a query>. Anyone else seen this?

Hi,

I want to connect to CSV instead of db. for that I have modified the config file accordingly and opened the workbook and connected to the flat file stored in the results folder. but the workbook is still asking DB credentials and data source displayed is DB. can some one help me on how to connect to csv and pull data from flat files.

We've had a few users run into issues where TabMon failed to start because the "Start TabMon Service.bat" file did not request elevated permissions, and they weren't running it as administrator.

These scripts to start & stop the service should request elevated permissions in these instances.

I ran the TabMon service manually by pasting the 'Path to Executable' command into a command window and this a sample of the errors - see below " Cannot add non-nullable columns to an existing database table!" Therefore the TABMON database is not retrieving any data currently. The row count is same as last week.

Any help would be greatly appreciated.

Could not communicate with Perfmon on target host 'erp-win-s27': Access is denied
Could not communicate with Perfmon on target host 'erp-win-s27': Access is denied
Could not communicate with Perfmon on target host 'erp-win-s27': Access is denied
Could not communicate with Perfmon on target host 'erp-win-s27': Access is denied
Could not communicate with Perfmon on target host 'erp-win-s27': Access is denied
Could not communicate with Perfmon on target host 'erp-win-s27': Access is denied
Could not communicate with Perfmon on target host 'erp-win-s27': Access is denied
Could not communicate with Perfmon on target host 'erp-win-s27': Access is denied
Could not communicate with Perfmon on target host 'erp-win-s27': Access is denied
Could not communicate with Perfmon on target host 'erp-win-s27': Access is denied
Could not communicate with Perfmon on target host 'erp-win-s27': Access is denied
Could not communicate with Perfmon on target host 'erp-win-s27': Access is denied
Could not communicate with Perfmon on target host 'erp-win-s27': Access is denied
Loaded 0 Perfmon counters on erp-win-s27.
Loaded 74 MBean counters on 0058-win-s205.
Loaded 58 MBean counters on 0058-win-s216.
Loaded 0 MBean counters on 0058-win-s206.
Loaded 0 MBean counters on 0058-win-s207.
Loaded 0 MBean counters on 0058-win-s209.
Loaded 0 MBean counters on 0058-win-s210.
Loaded 0 MBean counters on 0058-win-s212.
Loaded 0 MBean counters on 0058-win-s213.
Loaded 0 MBean counters on 0058-win-s214.
Loaded 0 MBean counters on 0058-win-s215.
Loaded 0 MBean counters on 0058-win-s66.
Loaded 0 MBean counters on erp-win-s28.
Loaded 0 MBean counters on 0058-win-s139.
Loaded 0 MBean counters on erp-win-s29.
Loaded 0 MBean counters on 0058-win-s73.
Loaded 0 MBean counters on 0058-win-s61.
Loaded 0 MBean counters on 0058-win-s63.
Loaded 0 MBean counters on 0058-win-s68.
Loaded 0 MBean counters on 0058-win-s69.
Loaded 0 MBean counters on erp-win-s30.
Loaded 0 MBean counters on erp-win-s23.
Loaded 0 MBean counters on erp-win-s24.
Loaded 0 MBean counters on erp-win-s25.
Loaded 0 MBean counters on erp-win-s26.
Loaded 0 MBean counters on erp-win-s27.
TabMon initialized! Starting performance counter polling..
The TabMon service is now running, press Control+C to exit.
Polling..
Finished polling 132 counters. [58 failures]
The service threw an unhandled exception
System.ArgumentException: Cannot add non-nullable columns to an existing database table!
Parameter name: column
at DataTableWriter.Adapters.DbAdapter.AddColumnsToTableToMatchSchema(String t
ableName, DataTable schema)
at DataTableWriter.DbTableManager.UpdateTableToMatchSchema(IDbAdapter adapter
, DataTable schema)
at DataTableWriter.DbTableManager.InitializeTable(IDbAdapter adapter, DataTab
le schema, DbTableInitializationOptions tableInitializationOptions)
at DataTableWriter.Writers.DataTableDbWriter.Write(DataTable table)
at TabMon.TabMonAgent.Poll(Object stateInfo)
at System.Threading.TimerQueueTimer.CallCallbackInContext(Object state)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionCo
ntext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, C
ontextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.TimerQueueTimer.CallCallback()
at System.Threading.TimerQueueTimer.Fire()
at System.Threading.TimerQueue.FireNextTimers()
at System.Threading.TimerQueue.AppDomainTimerCallback()

Using tabmon for the first time and having issues with it. I am seeing the following information in the logs :016-02-26 22:04:48,748 [6] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\zusc-s-tsttbl02\vizportal\tableau.health.jmx:name=webclientappservice.login\RequestsFailed\vizportal: Unable to query MBean.
2016-02-26 22:04:48,748 [6] DEBUG TabMon.Counters.MBean.AbstractMBeanCounter - Error sampling counter Primary\zusc-s-tsttbl02\vizportal\tableau.health.jmx:name=webclientappservice.login\RequestsProcessed\vizportal: Unable to query MBean.

Getting the following error in the log file:

2016-01-13 14:06:01,465 [5] INFO TabMon.TabMonAgent - TabMon initialized!  Starting performance counter polling..
2016-01-13 14:06:01,480 [5] INFO Topshelf.Runtime.Windows.WindowsServiceHost - [Topshelf] Started
2016-01-13 14:06:01,480 [6] INFO TabMon.Sampler.CounterSampler - Polling..
2016-01-13 14:06:01,527 [6] FATAL Topshelf.Runtime.Windows.WindowsServiceHost - The service threw an unhandled exception
System.ArgumentException: Cannot set column 'instance'. The value violates the MaxLength limit of this column.
   at System.Data.DataColumn.CheckMaxLength(DataRow dr)
   at System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction, Boolean fireEvent)
   at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge, Boolean suppressEnsurePropertyChanged, Int32 position, Boolean fireEvent, Exception& deferredException)
   at System.Data.DataTable.InsertRow(DataRow row, Int64 proposedID, Int32 pos, Boolean fireEvent)
   at TabMon.Sampler.CounterSampler.SampleAll()
   at TabMon.TabMonAgent.Poll(Object stateInfo)
   at System.Threading.TimerQueueTimer.CallCallbackInContext(Object state)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.TimerQueueTimer.CallCallback()
   at System.Threading.TimerQueueTimer.Fire()
   at System.Threading.TimerQueue.FireNextTimers()
   at System.Threading.TimerQueue.AppDomainTimerCallback()

I believe to have tracked the cause down to the following line in TabMon.Sampler.CounterSampler.GenerateSchema()

generatedSchema.Columns.Add(BuildColumnMetadata("instance", "System.String", true, 64));

The offending counter instance name seems to be "HP NC375i Integrated Quad Port Multifunction Gigabit Server Adapter" at 67 characters long, exceeding the maxLength of 64.

Explicitly listing the Network Interface counter instances without including the one mentioned above results in TabMon running without issues.

Hello Team,
we installed Tabmon on our environment (version 9.0). but while validating data we are getting blank for Network sheet and we have null values for measures present on dashboard.

Kindly Help me to fix the issue.

Thanks
Manoj

You probably have gotten this before, but I am trying to use TabMon to monitor the performance of my Tableau Server. When trying to login to "localhost" with the database "TabMon" and the default username and password, tabmon and "password" respectively. I get the following error. I am so excited about using this. I hope I left a detailed enough description of my issue.

Add the ability to have the application automatically delete old data based on timestamp, controllable via config options

Hello!

I am unable to open the sample TabMon .twb file provided here:

https://github.com/tableau/TabMon/tree/master/Sample%20Workbooks

When I open it I get the following error message:

Can someone please help me troubleshoot this error? Thank you in advance!

Best,
Angie Greenhaw