10 Replies Latest reply on Dec 28, 2015 4:09 AM by jostna ch

Tabmon workbook dims/measures not in database

Todd Schnack Dec 10, 2015 9:48 AM

I am on Tableau Server 9.2 and just installed Tabmon (which went very smoothly). I open the workbook and there are six items in the TabMon data source that are showing the error "The field [xxx] does not exist in the database.":

average_batch_failure

average_batch_size

average_query_latency

average_request_latency

heap_memory_usage\committed

heap_memory_usage\used

Any ideas on why those fields are not in the data source? The environment I am running Tabmon in is very lightly used, so I am wondering if some of these items are not in the database because certain activities have not been performed in that environment (i.e., scheduled extracts, live connections, etc.)?

1. Re: Tabmon workbook dims/measures not in database

Todd Schnack Dec 10, 2015 9:55 AM (in response to Todd Schnack)
There are more measures with the same error (I forgot to scroll down through the entire list of Measures):
non_heap_memory_usage\committed
non_heap_memory_usage\used
request_processed
requests_failed
requests_processed
total_compilation_time
Like Show 0 Likes(0)

Actions
2. Re: Tabmon workbook dims/measures not in database

Mohmed Shaik Dec 10, 2015 2:08 PM (in response to Todd Schnack)

Hi,

I guess back when i installed tabmon in 9.0.1, I faced the similar situation back then. I had to open some ports through the following cmd for those tabmon fields to get capture.

tabadmin set service.jmx_enabled true.

I entered the below cmd. there are two way, which i dont recall which one i folled back then. i suggest to check in ur dev of the impact.

Stop the server.
Enter the following command:
tabadmin set service.jmx_enabled true
Enter the configure command:
tabadmin configure
Start the server

tabadmin set service.jmx_enabled true
2. tabadmin stop
3. tabadmin configure
4. tabadmin start
Like Show 0 Likes(0)

Actions
3. Re: Tabmon workbook dims/measures not in database

Todd Schnack Dec 11, 2015 9:35 AM (in response to Mohmed Shaik)

Correct - that step is required to get JMX enabled to start (and is explained in the User Guide). The issue I am having is that the database is missing the specific JMX measures I listed.
Like Show 0 Likes(0)

Actions
4. Re: Tabmon workbook dims/measures not in database

Mohmed Shaik Dec 16, 2015 12:43 PM (in response to Todd Schnack)

just now installed 9.2, will check tabmon on 9.2. Wondering 9.2 ram/cpu utilization compared to earlier versions. Any impact, or relatively same as earlier versions ?.
Like Show 0 Likes(0)

Actions
5. Re: Tabmon workbook dims/measures not in database

Jeff Strauss Dec 16, 2015 1:41 PM (in response to Todd Schnack)

did you ever get this figured out?
Like Show 0 Likes(0)

Actions
6. Re: Tabmon workbook dims/measures not in database

Mohmed Shaik Dec 16, 2015 1:52 PM (in response to Jeff Strauss)

As you referred to error msg, even i got back in 9.0.1 version. but i am recalling, buy running the cmd that i posted here, got fixed. Am not able to remember, if i did any more changes. There was one more thing i did. I guess u knew of that for now. below i am attaching the img. I was on 9.0, so i changed wat was given below
Like Show 0 Likes(0)

Actions
7. Re: Tabmon workbook dims/measures not in database

Todd Schnack Dec 16, 2015 2:05 PM (in response to Jeff Strauss)

Nope. I manually added the missing columns to the table, which resolves the "missing" issue in the workbook, but those columns are still not being populated by tabmon. I suspect that the hardcoded port range in the counters.config may need to be changed to match the ports used, but no luck with that so far ...
Like Show 0 Likes(0)

Actions
8. Re: Tabmon workbook dims/measures not in database

Mohmed Shaik Dec 16, 2015 2:10 PM (in response to Todd Schnack)

i was about to open tabmon on 9.2v, but server got down with some unexped error. bammmm. when i open the tabmon later, will check and let u know
Like Show 0 Likes(0)

Actions
9. Re: Tabmon workbook dims/measures not in database

Mohmed Shaik Dec 16, 2015 2:21 PM (in response to Todd Schnack)

hay, just now i opened tabmon through desktop connecting to server, and checked the fields. for me i dont see any red marks on it. and
seems to be fine. below i am attaching the screen shot.
Like Show 0 Likes(0)

Actions
10. Re: Tabmon workbook dims/measures not in database

jostna ch Dec 28, 2015 4:09 AM (in response to Mohmed Shaik)

Hi All,

I am facing similar problem.
Out of all the workbooks, few of them are not showing up the data. please find the below screen shot.

similarly, other tabs like network, latency etc are not sowing up data.

Please help me on how to fix this issue.
Like Show 0 Likes(0)

Actions