Search found 305 matches

by mce
Fri Jun 28, 2019 3:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Lock Contention and RollBack
Replies: 6
Views: 166

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: 6
Views: 166

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: 6
Views: 166

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: 6
Views: 166

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

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

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

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

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

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

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

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

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

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

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

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...
by mce
Sun May 05, 2019 10:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Docker & McAfee on Windows Server
Replies: 14
Views: 465

Re: Docker & McAfee on Windows Server

If you can't disable or remove McAfee, see if you can temporarily turn it off while startup and then turn it back on afterwards. This has worked for us (as we have had no luck with IT in removing it from the server). Are you sure that disabling it guarantees that McAfee will not prevent PAW or Dock...
by mce
Sun May 05, 2019 6:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MTCubeLoad
Replies: 8
Views: 311

Re: MTCubeLoad

I've been thinking about this further. What I said earlier still holds; if IBM can't be clear about when the functionality can fail, and indicate that it CAN fail, I'd just turn it off and stay away from it. However... if issues like this go unreported they'll never get fixed. And for it to get fix...
by mce
Sat May 04, 2019 11:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MTCubeLoad
Replies: 8
Views: 311

Re: MTCubeLoad

Well excuse the hell out of me for raising a thing that is known to cause issues with multi threaded loads, especially as you made it clear in the original post that you were talking about input values rather than calculated values... as you didn't. Thanks for bringing the conditional feeder issue ...
by mce
Sat May 04, 2019 10:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MTCubeLoad
Replies: 8
Views: 311

Re: MTCubeLoad

Alan Kirk wrote:
Sat May 04, 2019 6:30 pm
Do you use conditional feeders at all? Multi-threaded loading is something which is best avoided if you do, because you can end up with exactly that result.
This issue has nothing to do with feeders. Some of the input data does not appear with MTCubeLoad=T.
by mce
Sat May 04, 2019 9:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MTCubeLoad
Replies: 8
Views: 311

MTCubeLoad

Hi, We added MTCubeLoad=T and MTQ=15. Then after few days, by chance, a user realized that some numbers in a cube have disappeared. We loaded a backup of few days old in a separate environment and we saw, the numbers are there in the cube. When I checked thed CubeName.cub file, in both the backup an...