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
Search found 352 matches
- 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: 858
- 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: 858
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...
- 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: 858
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,
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,
- 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: 630
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.
Dev team is already looking at it.
- Thu Dec 02, 2021 1:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: RunProcess and Process Ends msg
- Replies: 22
- Views: 84162
Re: RunProcess and Process Ends msg
I use synchronized function for the same requirement.
- Sat Sep 18, 2021 10:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cube Commit Error in PA
- Replies: 3
- Views: 6511
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,
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,
- Fri Aug 27, 2021 9:11 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cube Commit Error in PA
- Replies: 3
- Views: 6511
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...
- 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: 2754
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...
- 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: 2754
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...
- Thu Jan 28, 2021 10:13 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Login Error: SystemServerConnectionWithCAMPassport failed
- Replies: 2
- Views: 1859
Login Error: SystemServerConnectionWithCAMPassport failed
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,
Code: Select all
TM1.Login Login Error: SystemServerConnectionWithCAMPassport failed
Regards,
- 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: 54486
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.
All PAW containers work ok, but PA-Gateway is not working.
- 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: 54486
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...
- 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: 6393
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...
- Fri Jan 15, 2021 11:35 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Docker & McAfee on Windows Server
- Replies: 18
- Views: 11420
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...
- 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: 6393
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...
- Thu Dec 03, 2020 11:56 am
- Forum: Enhancements
- Topic: Transfer of data between servers
- Replies: 9
- Views: 54661
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
https://ibm-data-and-ai.ideas.aha.io/ideas/PAOC-I-288
- 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: 6393
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...
- 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: 5020
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...
- 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: 6393
- 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: 6393
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,
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,