TM1 Forum

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

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

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.

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

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

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.

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

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

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

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.

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

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

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

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

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

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

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

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

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.

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