TM1 Forum

Hello,
Recently I started seeing this message in TM1 Server log. It looks this error happens intermittently. Any ideas why this might be happening?

Regards,

We also ran the .\WindowsContainerNetworking-LoggingAndCleanupAide.ps1 -Cleanup -ForceDeleteAllSwitches command in powershell but it also errors.
All PAW containers work ok, but PA-Gateway is not working.

Yes save it and run. You may first do the following: docker ps -a | sls gateway If there are any gateway containers delete them docker rm <container-id> Check if the WinNAT module has any static mappings defined (it should not have port 80/443 mapped if there are no gateways): Get-NetNatStaticMappi...

2) When executing RunTI in multiple sessions concurrently to process data in multiple threads, some connections to TM1 server fail in some of the parallel threads. (CAM authentication). RunProcess sometimes helps on this, but cannot not always replace RunTI. Actually this is a really key point that...

Hello, https://kc.mcafee.com/corporate/index?page=content&id=KB90041 As per this tech note, Endpoint Security 10.6.1/10.7.0 November 2020 Update and later should support Docker on host Windows Server 2016 machine. Hence this should solve our problem. Are there anyone who tried this? Does it work? Re...

Thanks for all the valuable comments. Working with large dimensions >500,000 records brings with it many challenges. Ever opened one of these in the subset editor with the properties window enabled? Working with these dimensions get exponentially slower and unwinding roll-ups could take hours and ho...

This RFE has 21 votes now. Hope to get more votes on this so that it can be prioritized by IBMers.
https://ibm-data-and-ai.ideas.aha.io/ideas/PAOC-I-288

Here are my observations: Mostly large memory is a result of large data volume. Large data volumes require more processing time to get a proper performance. This is only possible via multithreading or parallel processing, in both querying and data processing. That is where you start hitting some bar...

Hello, We observe that MTCubeLoad=T parameter does not work for all cubes. Some of the cubes are loaded in parallel using multiple CPUs, and some others are not. Moreover, as per my observation, which cubes are loaded in parallel also changes from time to time. When I check the cubes that are loaded...

tomok wrote: ↑

Mon Nov 30, 2020 12:39 pm

Why do you think there would be challenges?

Because, sometimes size does matter a lot

Hello,

I would like to hear experiences with Large TM1 servers with more than or close to 1 TB of memory.
Are there anyone who experienced TM1 servers with more than or equal to 1 TB of memory?
What are the major challenges and how do you overcome those?
Thanks in advance for all replies.

Regards,

Hello, In one of our PROD TM1 environments, TM1 clients keep disconnecting automatically and the user has to re-login every time after closing all open views and subsets. Disconnect problem occurs in Architect and Perspectives, and even in Tm1top. We checked all timeout settings, they all seem to be...

Upgrading Oracle Client to Oracle 12 solves the problem. PA 2.0.9.1 does not seem to support older Oracle client versions.

Hello, We upgraded from 2.0.7 to 2.0.9.1 in a test environment for one of our clients. But TM1 server keeps crashing immediately when we execute TM1 processes connecting to Oracle DB via ODBC. Not only when executing the process, it crashes even when opening such processes in Architect. It happens i...

There's a bit of conjecture over whether the limit is 32k, 64k or something in between. It does depend whether unicode character sets are used or not, but whatever the exact ceiling the size limit is still going to apply to the DatasourceQuery query variable. Thanks for the info. I am still within ...

Hi, why you dont create a SQL View and just import the View? You can also build 2-6 or more views and combine them to one view for the import. Thats how we handle big SQL Statements to bring it into a Importable format for TM1. BR 1 - Need to keep the logic in TM1 for further changes and additions ...

Per this thread, a TM1 string cannot be > 32k so that would limit an ODBCOutput statement. https://www.tm1forum.com/viewtopic.php?f=3&t=14179&p=70027&hilit=tm1+string+size#p70027 My Query is not for ODBCOutput. Rather it is for SQL when importing data to TM1. Actuall I do not need to put all SQL qu...

Hello,

Is there any limit about the length of the final SQL statement that is passed from Turbo Integrator process to an Oracle DB?
Thanks in advance for any responses.

Regards

There is no special messages in the tm1server log. There is no message about memory issue. No errors at all. It suddenly goes down. In TM1Top, we can see that the last operation was a cube view being oped by a user. Issue is not specific to any cubes or any views. It intermittently happens when a us...

Hello, In one of our large PROD TM1 servers, the TM1 server keep crashing intermittently when a user tries to open views, especially when opening larger cube views that exceed view memory limit. Crash happens almost every day. Anyone else observing similar issues? Since the server is too large, I ca...