Jmeter setup

Post Reply
David Usherwood
Site Admin
Posts: 1453
Joined: Wed May 28, 2008 9:09 am

Jmeter setup

Post by David Usherwood »

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 :evil:
BrianL
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

Post by BrianL »

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.
David Usherwood
Site Admin
Posts: 1453
Joined: Wed May 28, 2008 9:09 am

Re: Jmeter setup

Post by David Usherwood »

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.... :evil:
member
Posts: 7
Joined: Sun Dec 20, 2015 5:01 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

Re: Jmeter setup

Post by member »

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.
BrianL
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

Post by BrianL »

Did you look at the second link in the original post? You need to import the TM1 SSL certificates into the java keystore.
member
Posts: 7
Joined: Sun Dec 20, 2015 5:01 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

Re: Jmeter setup

Post by member »

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.
I've done it.
JamiseBondi
Posts: 141
Joined: Wed Nov 14, 2012 10:37 am
OLAP Product: TM1
Version: 2.0
Excel Version: Office 365

Re: Jmeter setup

Post by JamiseBondi »

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.
User avatar
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

Post by Mike Cowie »

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.
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!
JamiseBondi
Posts: 141
Joined: Wed Nov 14, 2012 10:37 am
OLAP Product: TM1
Version: 2.0
Excel Version: Office 365

Re: Jmeter setup

Post by JamiseBondi »

Thanks Mike! much appreciated.
Post Reply