TM1 Forum

Hello,

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

Regards,

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

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

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

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

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