Thought I'd have a look at Jmeter for TM1 monitoring since it is getting some coverage on the forum.
Followed the instructions at
https://www.ibm.com/developerworks/libr ... c-page675/
Environment is:
TM1 10.2.2 (no FP) X64, Windows 8.1 (I know, I know)
Jmeter 2.13 (2.6 required in the IBM writeup, but not available from Apache)
I have read, and shuddered at, the link ( http://www-01.ibm.com/support/docview.w ... wg21414527 ) saying you have to futz around with the Java keystore. Currently I hope to avoid that by setting UseSSL=F in TM1S.CFG.
Trying to connect to a server I get 'could not connect to server "tm1serv" on host "localhost".
I have also configured TM1Top (placing it in the 10.2.2 bin folder) and can connect to the same server without issues.
Suggestions welcome. Hope they do not involve the Java keystore
Jmeter setup
-
- MVP
- Posts: 264
- Joined: Mon Nov 03, 2014 8:23 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2 PA2
- Excel Version: 2016
Re: Jmeter setup
Unfortunately, your issues are likely caused by not having the required SSL certificates in the keystore. Even if you tell the tm1 server not to use SSL for client connections, the admin server will still be using SSL.
It takes what, 5 minutes to add the certificates to the keystore? I agree it's a PITA, but it's something you should only have to do once.
If you're feeling particularly stubborn, you could try disabling ssl for the admin server too. I expect it's possible, but I've never found it worthwhile to look it up.
It takes what, 5 minutes to add the certificates to the keystore? I agree it's a PITA, but it's something you should only have to do once.
If you're feeling particularly stubborn, you could try disabling ssl for the admin server too. I expect it's possible, but I've never found it worthwhile to look it up.
-
- Site Admin
- Posts: 1453
- Joined: Wed May 28, 2008 9:09 am
Re: Jmeter setup
Thanks for the clarification. I remember mucking around with the keystore for the first release of Ops Console - put me off for life. Oh well....
-
- Posts: 7
- Joined: Sun Dec 20, 2015 5:01 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2010
Re: Jmeter setup
Hello,
Trying to use Jmeter but could not connect to server using "localhost" and server "planning sample". The error is "Could not connect to server "planning sample" on host "localhost".
The same time was able to connect http://www.google.com and monitor it.
I have removed password from "planning sample" but there is UserName: Admin - is this might affect? It was not mentioned on instructions we have to remove passwords as well.
Environment is:
TM1 10.2.0 X64, Windows 7, Jmeter 2.9 (with 2.6 didnt work as well)
Suggestions welcome.
Trying to use Jmeter but could not connect to server using "localhost" and server "planning sample". The error is "Could not connect to server "planning sample" on host "localhost".
The same time was able to connect http://www.google.com and monitor it.
I have removed password from "planning sample" but there is UserName: Admin - is this might affect? It was not mentioned on instructions we have to remove passwords as well.
Environment is:
TM1 10.2.0 X64, Windows 7, Jmeter 2.9 (with 2.6 didnt work as well)
Suggestions welcome.
-
- MVP
- Posts: 264
- Joined: Mon Nov 03, 2014 8:23 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2 PA2
- Excel Version: 2016
Re: Jmeter setup
Did you look at the second link in the original post? You need to import the TM1 SSL certificates into the java keystore.
-
- Posts: 7
- Joined: Sun Dec 20, 2015 5:01 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2010
Re: Jmeter setup
I've done it.BrianL wrote:Did you look at the second link in the original post? You need to import the TM1 SSL certificates into the java keystore.
-
- Posts: 141
- Joined: Wed Nov 14, 2012 10:37 am
- OLAP Product: TM1
- Version: 2.0
- Excel Version: Office 365
Re: Jmeter setup
Hi guys,
I know this is an old thread, but I'm interested in getting Jmeter running to monitor my instances in real-time, rather than load testing a website.
If you look on slide 6 of 29 on this site, it explains we need both the visualizer and wrapper jar files to be able to monitor the server activity in real-time.
https://www.slideshare.net/GracyMendonc ... ring-tools
I've installed the applix cert into the java keystore and modified the environment variables to put JRE into the path so I can launch the Jmeter GUI. I just need to get hold of the jar files to allow me to monitor the servers/instances in real-time. The following link just gets redirected from this URL...
https://www.ibm.com/developerworks/libr ... c-page675/
to this:
https://developer.ibm.com/technologies/analytics/
Which doesn't seem helpful. I've tried googling for com.ibm.cognos.jmeter.tm1.top.visualizer jar file and com.ibm.cognos.tm1.api.wrapper jar file but to no avail. Anyone got these files from another link that works?
thanks in advance.
I know this is an old thread, but I'm interested in getting Jmeter running to monitor my instances in real-time, rather than load testing a website.
If you look on slide 6 of 29 on this site, it explains we need both the visualizer and wrapper jar files to be able to monitor the server activity in real-time.
https://www.slideshare.net/GracyMendonc ... ring-tools
I've installed the applix cert into the java keystore and modified the environment variables to put JRE into the path so I can launch the Jmeter GUI. I just need to get hold of the jar files to allow me to monitor the servers/instances in real-time. The following link just gets redirected from this URL...
https://www.ibm.com/developerworks/libr ... c-page675/
to this:
https://developer.ibm.com/technologies/analytics/
Which doesn't seem helpful. I've tried googling for com.ibm.cognos.jmeter.tm1.top.visualizer jar file and com.ibm.cognos.tm1.api.wrapper jar file but to no avail. Anyone got these files from another link that works?
thanks in advance.
- Mike Cowie
- Site Admin
- Posts: 482
- Joined: Sun May 11, 2008 7:07 pm
- OLAP Product: IBM TM1/PA, SSAS, and more
- Version: Anything thru 11.x
- Excel Version: 2003 - Office 365
- Location: Alabama, USA
- Contact:
Re: Jmeter setup
I don't think I have a copy or alternate link to the old Jar files anymore, but I'd bet IBM isn't actively developing or supporting that JMeter plugin anymore and that's why it's disappeared.
Depending on what you're hoping to monitor you would be better off looking instead at leveraging the TM1 REST API within JMeter's own HTTP request tools for building test scripts (the same sort of things you would have used to record/build test scripts for TM1 Web, for instance). Or, have a look at something like TM1Py to leverage the TM1 REST API, especially if what you need to monitor can just be a scheduled Python script task that doesn't require JMeter in order to be useful to you. The other downside to the older JMeter JAR plugin is that I believe it used the TM1 Java API which I'd assume will officially go away someday-- the TM1 REST API has a much brighter future.
Depending on what you're hoping to monitor you would be better off looking instead at leveraging the TM1 REST API within JMeter's own HTTP request tools for building test scripts (the same sort of things you would have used to record/build test scripts for TM1 Web, for instance). Or, have a look at something like TM1Py to leverage the TM1 REST API, especially if what you need to monitor can just be a scheduled Python script task that doesn't require JMeter in order to be useful to you. The other downside to the older JMeter JAR plugin is that I believe it used the TM1 Java API which I'd assume will officially go away someday-- the TM1 REST API has a much brighter future.
Mike Cowie
QueBIT Consulting, LLC
Are you lost without Print Reports in Planning Analytics for Excel (PAfE)? Get it back today, for free, with Print Reports for IBM Planning Analytics for Excel!
QueBIT Consulting, LLC
Are you lost without Print Reports in Planning Analytics for Excel (PAfE)? Get it back today, for free, with Print Reports for IBM Planning Analytics for Excel!
-
- Posts: 141
- Joined: Wed Nov 14, 2012 10:37 am
- OLAP Product: TM1
- Version: 2.0
- Excel Version: Office 365
Re: Jmeter setup
Thanks Mike! much appreciated.