Search found 343 matches

by mce
Thu Jan 28, 2021 10:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Login Error: SystemServerConnectionWithCAMPassport failed
Replies: 2
Views: 251

Login Error: SystemServerConnectionWithCAMPassport failed

Hello,

Code: Select all

TM1.Login Login Error: SystemServerConnectionWithCAMPassport failed
Recently I started seeing this message in TM1 Server log. It looks this error happens intermittently. Any ideas why this might be happening?

Regards,
by mce
Wed Jan 27, 2021 2:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW not working after network changes
Replies: 38
Views: 37540

Re: PAW not working after network changes

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.
by mce
Wed Jan 27, 2021 12:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW not working after network changes
Replies: 38
Views: 37540

Re: PAW not working after network changes

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...
by mce
Mon Jan 18, 2021 12:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Servers with TBs of Memory
Replies: 13
Views: 1057

Re: TM1 Servers with TBs of Memory

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...
by mce
Fri Jan 15, 2021 11:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Docker & McAfee on Windows Server
Replies: 18
Views: 4094

Re: Docker & McAfee on Windows Server

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...
by mce
Mon Dec 07, 2020 9:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Servers with TBs of Memory
Replies: 13
Views: 1057

Re: TM1 Servers with TBs of Memory

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...
by mce
Thu Dec 03, 2020 11:56 am
Forum: Enhancements
Topic: Transfer of data between servers
Replies: 9
Views: 1652

Re: Transfer of data between servers

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
by mce
Wed Dec 02, 2020 9:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Servers with TBs of Memory
Replies: 13
Views: 1057

Re: TM1 Servers with TBs of Memory

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...
by mce
Tue Dec 01, 2020 4:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MTCubeLoad=T does not work for some large cubes intermittently
Replies: 0
Views: 660

MTCubeLoad=T does not work for some large cubes intermittently

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...
by mce
Tue Dec 01, 2020 1:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Servers with TBs of Memory
Replies: 13
Views: 1057

Re: TM1 Servers with TBs of Memory

tomok wrote:
Mon Nov 30, 2020 12:39 pm
Why do you think there would be challenges?
Because, sometimes size does matter a lot :)
by mce
Mon Nov 30, 2020 10:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Servers with TBs of Memory
Replies: 13
Views: 1057

TM1 Servers with TBs of Memory

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,
by mce
Mon Oct 19, 2020 4:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Clients intermittently keep disconnecting from server
Replies: 0
Views: 781

TM1 Clients intermittently keep disconnecting from server

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...
by mce
Sat Oct 17, 2020 11:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server Crash with TI Processes with ODBC Data sources in PA 2.0.9.1
Replies: 4
Views: 1530

Re: TM1 Server Crash with TI Processes with ODBC Data sources in PA 2.0.9.1

Upgrading Oracle Client to Oracle 12 solves the problem. PA 2.0.9.1 does not seem to support older Oracle client versions.
by mce
Mon Jul 13, 2020 1:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server Crash with TI Processes with ODBC Data sources in PA 2.0.9.1
Replies: 4
Views: 1530

TM1 Server Crash with TI Processes with ODBC Data sources in PA 2.0.9.1

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...
by mce
Thu Jul 02, 2020 4:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Query Length Limit for TI
Replies: 10
Views: 1411

Re: SQL Query Length Limit for TI

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 ...
by mce
Thu Jul 02, 2020 2:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Query Length Limit for TI
Replies: 10
Views: 1411

Re: SQL Query Length Limit for TI

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 ...
by mce
Thu Jul 02, 2020 9:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Query Length Limit for TI
Replies: 10
Views: 1411

Re: SQL Query Length Limit for TI

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...
by mce
Thu Jul 02, 2020 9:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Query Length Limit for TI
Replies: 10
Views: 1411

SQL Query Length Limit for TI

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
by mce
Fri Jun 19, 2020 9:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server Crash in PA 2.0.7
Replies: 3
Views: 701

Re: TM1 Server Crash in PA 2.0.7

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...
by mce
Fri Jun 19, 2020 8:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server Crash in PA 2.0.7
Replies: 3
Views: 701

TM1 Server Crash in PA 2.0.7

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...