TM1 Forum

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). Can you try running this process in the TIDebugger and see wh...

gtonkin wrote: ↑

Tue Oct 29, 2019 6:10 am

ykud wrote: ↑

Tue Oct 29, 2019 12:40 am

...being able to use community docker is one of the main reasons next version of PA will support CentOS, afaik.

PAW 2.0.46 supports CentOS see this note.

Awesome, thanks!

Haven't had a chance to compare performance yet, so a bit off-topic: Make sure you check licensing implications, as far as I understand, Enterprise Docker on RHEL requires a license. And community docker is not available on RHEL. being able to use community docker is one of the main reasons next ver...

I'm starting to think that a sqllite instance to store the flags with guaranteed read / write might be better at large scale. I find this idea quite interesting. But in exactly the kind of scenario where immediacy of file writes might be problemantic with lots of multi-threadig and dozens of TIs ru...

I second Declan's suggestion. File based semaphores are really the only way to go when running processes on independent threads. Reading a cell value (or attribute value) is vey tricky to get right because of TM1's commit model and which version of the data your monitoring process is rteading versu...

Hi mce,

Did you end up figuring out the root causes of it? What version of PA you’re seeing this in?
We see something similar (although not consistently) on PA 2.0.6 if 19.

Y

Create a TI that runs PublishView with view name as a parameter and give users read access to this process. https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_ref.2.0.0.doc/r_tm1_ref_tifun_publishview.html Throw in a nice websheet to select the views to publish and...

I’ll just leave it here for anyone finding this thread later: another reason for memory growth is that PA is preloading all the views and subsets definitions on startup, whereas 10.2.2 didn’t do that. There will be a parameter in tm1s.cfg to disable this behaviour in future releases, but you can che...

I usually do something simple like:

But I do not agree that the processes of orchestration are not solved. In our production environment there are several solutions for sequential queues, one based on files, the other based on a cube of queues, both work (I note that a solution based on a cube is rather complicated, but it works!) Wh...

As I said, process A and B would have their own transaction sets, so would not see the changes made by the other process. The process that finishes last commits its changes last. Thank you very much for confirming this. To get back to Yuri's point about controlling or orchestrating batch processes....

Can I also jump on with some questions on RunProcess (don't have 2.0.6 to test yet): what's with transaction isolation in RunProcess? A simple test is to start with an empty cube with 1 cell. Process A: 1) CellPutN 1 into that cell 2) RunProcess (B) 3) CellGetN that cell in a loop for a minute (does...

Does TM1Web work with https, only contributor fails? I find IKeyMan a lot simpler to use than ThirdPartyCert tool, it can show contents of your cacerts and highlight whether there are any issues with imported certificate (for example, it's missing the whole authority chain or is not trusted). http:/...

- If I schedule the task to run at a certain point in time, so scheduled, and I am logged on: it works fine. Can you see under what user 'excel.exe' process is running in this case? Yours or the one you set up in Scheduled tasks? Interactive Identity setup will launch excel under your account, spec...

This works perfectly if me or anyone else is logged on to the server when the TI process executes the vbscript. However, in the case of NO USER being logged on to the server at that time, it does not work completely. I don't understand why. It seems that the Application.Run "TM1REFRESH" or "TM1RECA...

Hi Elessar, Thanks for the reply. It takes about an hour for SecurityRefresh normally. On PA 2.0.4 and 2.0.6, it takes about 1.5 hours. Since it was taking longer, I asked IBM and they gave us an interim fix and that does not complete securityRefresh. It stops before completing with an error as bel...

Thanks Ykud. Contributor views are not private views. The subsets change from time to time. They are, each connecting user will create a view with node_id in the name the moment he rearranges anything in the application, try yourself, you'll see them created in the user folder under data directory :)

Hi all, In 10.2.2, when ever I delete a chunk of elements from the "Approval hierarchy" dimension and apply manage Rights, it takes 4-5 hours to complete the process in multi threaded configuration. <deployment maxThreads="4"/> Normal manage rights with 4 threads takes about an hour. What happens i...

I have also been sceptical that MaximumCubeLoadThreads has only impact on cubes with conditional feeders, I would have thought any out of order cube processing with cross-cube feeders (DB and ATTRS/n references) could potentially impact data integrity if the Dependent Cube runs to a completion befo...

Maybe spreading capability is explicitly denied?
https://www-01.ibm.com/support/docview. ... wg27043557