TM1 Forum

Hello Forum Members,

I am reaching out to seek guidance and assistance regarding a setup we have at our client's environment. Here are the details:

Client Setup:

TM1 Data server is hosted on Serverbox1. (has 30CPU with 156GB RAM; at any given time it is consuming not more than 80GB)
We have two clients, namely PAX and Perspectives.
PAX with dockers is situated on Serverbox2.
This entire setup is on Azure; previously, it was on Citrix/intranet.
Clients are 64-bit

Issues Encountered:

Our main concern is related to PAX templates. Around a month ago, these templates were functioning correctly. However, over the past two weeks, we have observed that low-data templates take an extended time (around 5-6 hours) to refresh. Interestingly, high-data templates take only a few minutes to refresh. As of yesterday, we have been unable to refresh any of the PAX templates. These templates are user-generated and cater to their daily requirements, hence no fixed set of reports is available.

In the midst of this, some of the PAX users attempted to open templates using Perspectives. Occasionally, they were successful, but most of the time, they encountered issues. Based on information available online, it appears that PAX templates may not function properly in Perspectives.

Any insights, advice, or experiences shared would be greatly appreciated.

Thank you in advance for your assistance and expertise.

Have you looked at your PAX logs to see what it may be doing?
Have you changed the Log Level to ALL to see more details?
Have you checked for known issues that impact performance like cells with errors, including on hidden sheets, named ranges with errors, pointing to invalid addresses?
Have you tried the IP address instead of the servername?
Have you tried pointing directly to the server? May limit functionality and/or introduce other issue but worth trying.

Also worth checking what activity is going on in the TM1 DB.

Could there be a long running / broken TI hogging the processors?
Has the issue persisted through a restart of the TM1 DB?

Given the symptoms you describe I'd be looking for some kind of change to the infrastructure or change in the TM1 DB that has triggered the slow performance. (Assuming the issue is impacting all client sessions).