Search found 352 matches

by mce
Tue Mar 21, 2023 9:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBC Connection Performance Degradation in PA Server 2.0.9.14 and later
Replies: 3
Views: 783

Re: ODBC Connection Performance Degradation in PA Server 2.0.9.14 and later

APAR is created for this issue:
PH53021: ORACLE ODBC DATASOURCE PERFORMANCE SLOWER THAN PREVIOUS VERSIONSOF PA
https://www.ibm.com/support/pages/apar/ ... s=swgother
by mce
Mon Feb 27, 2023 5:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBC Connection Performance Degradation in PA Server 2.0.9.14 and later
Replies: 3
Views: 783

Re: ODBC Connection Performance Degradation in PA Server 2.0.9.14 and later

When we execute a TI process loading data from Oracle DB, it takes twice longer in new version compared to old one. With the new version, as we run the same process in multiple concurrent threads with different parameters to load different slices of the data, then data load speed for each thread dec...
by mce
Mon Feb 27, 2023 12:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBC Connection Performance Degradation in PA Server 2.0.9.14 and later
Replies: 3
Views: 783

ODBC Connection Performance Degradation in PA Server 2.0.9.14 and later

Hello,

After upgrade to PA 2.0.9.14, we have seen major performance degradation in TI processes pulling data from Oracle DB to TM1.
Is there anyone else who have seen this problem and any solutions so far?

All responses will be appreciated.

Regards,
by mce
Thu Jun 16, 2022 3:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SINCE WORKSPACE 2.0.77, ANY USER CONNECTING FOR THE FIRST TIME IS GRANTED WITH ADMINISTRATOR ROLE
Replies: 1
Views: 608

SINCE WORKSPACE 2.0.77, ANY USER CONNECTING FOR THE FIRST TIME IS GRANTED WITH ADMINISTRATOR ROLE

APAR PH47289 SINCE WORKSPACE 2.0.77, ANY USER CONNECTING FOR THE FIRST TIME IS GRANTED WITH ADMINISTRATOR ROLE
Dev team is already looking at it.
by mce
Thu Dec 02, 2021 1:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and Process Ends msg
Replies: 22
Views: 83734

Re: RunProcess and Process Ends msg

I use synchronized function for the same requirement.
by mce
Sat Sep 18, 2021 10:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Commit Error in PA
Replies: 3
Views: 6418

Re: Cube Commit Error in PA

Hi,

I found that this was due to a defect that is reported here https://www.ibm.com/support/pages/node/6107494
The only option is to upgrade.

Regards,
by mce
Fri Aug 27, 2021 9:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Commit Error in PA
Replies: 3
Views: 6418

Re: Cube Commit Error in PA

Hello, I am also having this problem in recent version of TM1. this happens when I unload a cube from memory, and then once I force it to be reloaded to memory, it keeps throwing this error in TM1Server.log. Due to this error, it block all other threads in TM1 server, and we have no other option tha...
by mce
Sat Apr 10, 2021 9:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 & Cognos Analytics SSL Issue with CAM Security
Replies: 4
Views: 2670

Re: TM1 & Cognos Analytics SSL Issue with CAM Security

I'm assuming TM1 config has been updated to reference cognos analytics with https in the address. Yes, I have done this. Do you have Planning Analytics and Cognos Analytics installed on different servers? Are you using a certificate from a CA authority or a self-certified certificate. They are on t...
by mce
Fri Apr 09, 2021 7:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 & Cognos Analytics SSL Issue with CAM Security
Replies: 4
Views: 2670

TM1 & Cognos Analytics SSL Issue with CAM Security

Hello, I am trying to enable SSL for both Cognos Analytics (11.0.13) and Planning Analytics (2.0.x). I succeeded for enabling SSL for both. Cognos Analytics works with custom SSL by itself with no issues. Planning Analytics works ok by itself with SSL with no issues. I implemented all the steps in h...
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: 1819

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: 53356

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: 53356

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: 6270

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: 11256

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

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: 53399

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: 6270

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: 4971

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: 6270

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: 6270

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,