Search found 310 matches

by mce
Fri Dec 06, 2019 1:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Changing Gagteway Ports for PAW in Linux
Replies: 1
Views: 90

Changing Gagteway Ports for PAW in Linux

Hello,

Does anyone know how to change Gateway Ports for PAW in Linux RHEL?
We keep getting errors about PA-Gateway?

Regards,
by mce
Sun Nov 24, 2019 11:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1.Lock Contention happens on some dimension objects due to read operations in concurrent TI processes
Replies: 8
Views: 323

Re: TM1.Lock Contention happens on some dimension objects due to read operations in concurrent TI processes

I still don't trust the *Direct metadata functions very much. The fact you need to remember to run DimensionUpdateDirect after any such updates in order for the new elements to be fully functional tells you a bit about the downsides of overusing these functions. But I digress. When I had issues wit...
by mce
Sun Nov 24, 2019 11:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1.Lock Contention happens on some dimension objects due to read operations in concurrent TI processes
Replies: 8
Views: 323

Re: TM1.Lock Contention happens on some dimension objects due to read operations in concurrent TI processes

We saw something similar in one of the models and unfortunately, there wasn't any real solution, we just had to 'commit' locks in different parts of the process earlier by running each portion as it's own RunTi with ExecuteCommand(...,1). We are already running the threads in different sessions usi...
by mce
Wed Nov 20, 2019 8:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1.Lock Contention happens on some dimension objects due to read operations in concurrent TI processes
Replies: 8
Views: 323

Re: TM1.Lock Contention happens on some dimension objects due to read operations in concurrent TI processes

Do you have any functions in this TI which would operate on these locking dimensions, even as read-only? DIMIX/DIMNM/ATTRS...? Yes, we use DIMIX a lot. In an occasion, I replaced DIMIX by SubsetElementGetIndex, and it was still locking on that dimension. We also use CellGetS for a cube that use the...
by mce
Wed Nov 20, 2019 4:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1.Lock Contention happens on some dimension objects due to read operations in concurrent TI processes
Replies: 8
Views: 323

TM1.Lock Contention happens on some dimension objects due to read operations in concurrent TI processes

Hello, We run the same TI process in parallel with different parameters to update different portions of a cube. However, we observe some locking contentions on some dimension objects causing the processes to roll back and re-execute. There is no dimension operations in this process that is running i...
by mce
Fri Jun 28, 2019 3:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Lock Contention and RollBack
Replies: 11
Views: 4424

Re: Lock Contention and RollBack

I have not tested this, but one possible way around this is to build a temporary subset and use the SubsetElementGetIndex function instead of DIMIX against the base dimension. I tested this and compared performances for DIMIX against SubsetElementGetIndex in a large dimenson (having more than 10k m...
by mce
Thu Jun 27, 2019 4:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Lock Contention and RollBack
Replies: 11
Views: 4424

Re: Lock Contention and RollBack

Does your master process also execute a DIMIX on the DimX dimension? Or any other function on that dim? No, not at all. I have not tested this, but one possible way around this is to build a temporary subset and use the SubsetElementGetIndex function instead of DIMIX against the base dimension. I w...
by mce
Wed Jun 26, 2019 2:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Lock Contention and RollBack
Replies: 11
Views: 4424

Re: Lock Contention and RollBack

Steve Rowe wrote:
Wed Jun 26, 2019 1:35 pm
What do you see against thread 2200 in TM1Top?
Only one process is in Run state, all others are in wait state in Tm1Top. In this case thread 2200 is at Run:R state. All other threads are in Wait:IXC state.
by mce
Wed Jun 26, 2019 12:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Lock Contention and RollBack
Replies: 11
Views: 4424

Lock Contention and RollBack

Hello, I am trying to load data to a cube in many parallel threads using RunTI. Each parallel thread is hitting a different portion of the cube. But before loading data, we do some master data check to make sure elements exists in dimensions and we also lookup some values from other cubes. For some ...
by mce
Fri Jun 21, 2019 3:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?
Replies: 11
Views: 3100

Re: Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?

Hello, I have a similar problem in executing paralel processes via RunTI with the same CAM user. TM1TopScreen.PNG 9372 [23e] DEBUG 2019-06-21 17:58:08.023 TM1.Lock.Exception Contention encountered attempting to acquire lock (0x000000000BEA1C10) on object [Client "CAMID("CognosEx:u:uid=myrunti_user")...
by mce
Sat Jun 15, 2019 8:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Process Keeps Rolling Back and Restarting in Parallel Executions of Batch Mode
Replies: 2
Views: 364

Re: TM1 Process Keeps Rolling Back and Restarting in Parallel Executions of Batch Mode

I understand that this issue might be due to locks on CAM user logins, as we use a CAM user for executing parallel threads via RunTI. I will check this in PA 2.0.7 with RunProcess or with OptimizeClient parameter and will see if the same problem happens there.
by mce
Sat Jun 15, 2019 8:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cannot Open Application URL Entries in TM1Web
Replies: 8
Views: 1454

Re: Cannot Open Application URL Entries in TM1Web

URL API works ok, expept if it is invoked from an TM1 Application Folder URL object via TM1Web. It works when clicked from Architect or Perspectives: TM1ArchitectScreen.JPG It does not work when clicked from TM1Web: TM1WebScreenshot.JPG Hope it is clear. I can see that this issue has been resolved ...
by mce
Sat Jun 15, 2019 8:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and threads
Replies: 20
Views: 6263

Re: RunProcess and threads

How about sequence orchestration by using Synchronized() ? I started using this and works fine, except if the process rolls back. In case of a roll-back operation the process releases the locks and before it starts again other processes that are conditioned to acquiring locks from this process take...
by mce
Sat Jun 15, 2019 8:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunTI Issue
Replies: 11
Views: 1122

Re: RunTI Issue

Slices should be of roughly same order of magnitude in size but not of equal size. This is because the commit phase is always single threaded and serialized. There's no sense having all the loads complete in parallel and all finish at the same time and then form a commit queue. Hi Lotsaram, When lo...
by mce
Sat Jun 15, 2019 7:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunTI Issue
Replies: 11
Views: 1122

Re: RunTI Issue

Thanks for the valuable comments.

I found that there is an APAR for this issue:
PH11163 MULTIPLE TM1RUNTI PROCESSES FAIL TO EXECUTE VIA EXECUTECOMMAND WHEN THE NUMBER IS VERY HIGH

I understand that this APAR is still open and to be fixed in a future release.
by mce
Sat Jun 01, 2019 3:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunTI Issue
Replies: 11
Views: 1122

Re: RunTI Issue

Please re-read and digest Paul's suggestion that dividing the loads by 250 GL accounts is not the best use of resources. If you rethink your 'granularity' and divide the loads to match the (TM1) cores you have you should get better performance and the extra second delay to manage login contention w...
by mce
Sat Jun 01, 2019 7:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunTI Issue
Replies: 11
Views: 1122

Re: RunTI Issue

I would check the TM1Server log to see whether the processes are running but failing or whether they are never being run at all. We already checked and the process has never been triggered via RunTI. I suggest that you make the process output a last time completed to a cube so that you can tell whe...
by mce
Fri May 31, 2019 3:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunTI Issue
Replies: 11
Views: 1122

RunTI Issue

Hello, We trigger the same TI process many times (say 250 times) with different parameters using RunTI at the same time. RunTI is configured to to authenticate via CAM authentication in mode 5. The problem is we observe that some of the TI processes has never been triggered via RunTI although comman...
by mce
Tue May 21, 2019 11:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Docker & McAfee on Windows Server
Replies: 14
Views: 1123

Re: Docker & McAfee on Windows Server

FYI this is the link for docker ee pricing you need a log in though. https://hub.docker.com/editions/enterprise/docker-ee-server-rhel/purchase From memory when you get to the last page you can drop the core count from the default of 10 down to 5. Hi Steve, This is Docker hup pricing. As per my unde...
by mce
Tue May 21, 2019 7:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Docker & McAfee on Windows Server
Replies: 14
Views: 1123

Re: Docker & McAfee on Windows Server

Hi, We considered running PAW on Linux Red Hat for a client, and checked with Docker about Docker EE licensing. They said it costs 500$ per core per year with minimum purchase requirement of 40 cores. This means 20.000$ per year minimum we have to pay to Docker to be able to use PAW on a Linux Red H...