tm1py not connecting

Post Reply
User avatar
roei61
Posts: 41
Joined: Wed Aug 22, 2012 5:44 am
OLAP Product: PAX
Version: 2.0.7
Excel Version: 2016
Location: Israel

tm1py not connecting

Post by roei61 »

Hi All,

I have installed the tm1py libary.
While trying to connect (even through the sample connection) i get no response from the service and all gets freeze.

Attached the what I get in the TM1top.
I hope that someone can help me with this
Roei
Attachments
top
top
r.png (8.72 KiB) Viewed 4025 times
EvgenyT
Community Contributor
Posts: 324
Joined: Mon Jul 02, 2012 9:39 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: 2016
Location: Sydney, Australia

Re: tm1py not connecting

Post by EvgenyT »

Looks like you are using SSO. I was having the same issue with SSO, only by entering my credentials (LDAP credentials) I was able to get it to work.
When trying to connect with SSO, I was getting Status Code: 401 Reason: Unauthorized. We are using mode 2.

Give it a go and see if it works with explicit SSO credentials... maybe someone else here can contribute more to this?

Thank you

Evgeny
ByronB
Posts: 17
Joined: Tue Mar 01, 2016 5:55 am
OLAP Product: TM1 + BI
Version: TM1 10.2
Excel Version: Excel 2010

Re: tm1py not connecting

Post by ByronB »

Hi roei61,

It would help if you could add more information such as TM1 version (TM1py supports 10.2 FP5 as minimum), TM1 security, TM1py and Python version.

If TM1py can't connect, check.py should generate an error, so I'm not sure why it froze.

According to your screenshot, the Client CAMURI is empty. If you want to connect using SSO you will need to add the Client CAMURI which looks like this http://localhost:80/ibmcognos/cgi-bin/cognos.cgi

If you still can't connect, you should check if the TM1 REST API is enabled, more information here: https://code.cubewise.com/blog/enabling ... 1-rest-api

I hope this help

Cheers,

ByronB
User avatar
roei61
Posts: 41
Joined: Wed Aug 22, 2012 5:44 am
OLAP Product: PAX
Version: 2.0.7
Excel Version: 2016
Location: Israel

Re: tm1py not connecting

Post by roei61 »

Hi,

Thanks that's may be the reason.
I'm using 10.2 FP2, hopefully after upgrading to PA it will work

Roei
Marcus Scherer
Community Contributor
Posts: 126
Joined: Sun Jun 29, 2008 9:33 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016
Location: Karlsruhe

Re: tm1py not connecting

Post by Marcus Scherer »

Hi,
I cannot connect to TM1 with tm1py either. When executing check.py in PowerShell there is no prompt for login and no error message.
tm1py is installed successfully,
REST API enabled --> https://localhost:8881/api/v1/$metadata gives back data.
OS is Windows 10, TM1 version is 10.2.2 FP7, HTTPPortNumber=8881, IntegratedSecurityMode=1
Any hints? Thank you.


###solved. Entries for Environment variabel PATH were missing, pointing to Python. An Anaconda installation does not set the variables automatically. Thanks.
Post Reply