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
tm1py not connecting
- 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
- Attachments
-
- top
- r.png (8.72 KiB) Viewed 4024 times
-
- 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
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
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
-
- 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
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
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
- 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
Hi,
Thanks that's may be the reason.
I'm using 10.2 FP2, hopefully after upgrading to PA it will work
Roei
Thanks that's may be the reason.
I'm using 10.2 FP2, hopefully after upgrading to PA it will work
Roei
-
- 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
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.
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.