connectionpool issue

[jmliando]

Hi Marius

I tried to run samples_setup.py but had an issue with connectionpool.py as you can see in this screenshot. Can you please help me? Thank you

Version

• Python 3.9.13
• TM1py 2.0.2
• TM1 Server Version 2.0.918.3

I also try to use the check.py to check the connection but it is hanging after I put TM1 User.

[MariusWirtz]

Please try to run the simplest possible tm1py script in your pycharm environment. Like this:

from TM1py import TM1Service

tm1_params = {
    "address": "localhost",
    "port": 12354,
    "user": "admin",
    "password": "apple",
    "ssl": True,
}
with TM1Service(**tm1_params) as tm1:
    print(tm1.server.get_product_version())
    print(tm1.server.get_server_name())

Does that work?

[jmliando]

It is hang.

[MariusWirtz]

If the Python never completes, it typically indicates an issue with the connection to the TM1 server. Here are some potential causes and their solutions:

---

1. Network Connectivity

• Cause: The script cannot establish a connection to the TM1 server because the server is down, unreachable, or the network is blocking the connection.
• Solution:
  • Check if the TM1 server is running and accessible on the specified address and port.
  • Use tools like ping or telnet to test connectivity to the server.

  • Ensure no firewall or network security rules block the connection.

2. Incorrect Connection Parameters

• Cause: Parameters such as address, port, user, password, or ssl are incorrect.
• Solution:
  • Verify the server address and port in the TM1 configuration (tm1s.cfg).
  • Ensure the credentials (user/password) are correct.
  • Confirm if SSL is required (check the UseSSL setting in tm1s.cfg).

---

3. Timeout

• Cause: The connection attempt to the TM1 server is hanging indefinitely.
• Solution:
  • Add a timeout parameter to TM1Service initialization (e.g., timeout=60 for a 60-second timeout).
  • Investigate why the TM1 server might be slow to respond.

---

4. TM1py Library Version

• Cause: An outdated or mismatched version of TM1py may cause compatibility issues with the TM1 server.
• Solution:
  • Ensure you are using the latest version of TM1py.

---

5. SSL Certificate Issue

• Cause: SSL might be enabled, but the certificate is not configured correctly or is self-signed.
• Solution:
  • If using a self-signed certificate, set verify=False in the parameters.
  • Ensure the ssl parameter matches the server's SSL configuration.

---

6. Authentication Issues

• Cause: The admin user may be locked out or disabled, or the authentication method is misconfigured.
• Solution:
  • Check the user account status in the TM1 server.
  • Ensure the TM1 server authentication mode matches the TM1py connection configuration (e.g., CAM, LDAP, or native authentication).

---

Debugging Steps

1. Enable Verbose Logging: Add the following code to capture more details:

   
   import logging
   logging.basicConfig(level=logging.DEBUG)