TM1 Forum

As you and declanr said, the reason for rollback is that one of the sub processes was having a cubesavedata over a particular cube . That was the reason for roll back , i removed it but facing another issue which was the reason for above lock you had mentioned Try adding log4j.logger.TM1.Lock.Excep...

Basically, what we want accomplished is the dimension should contain only active elements and delete any inactive elements whenever the TI is run. How do we accomplish this without causing the server to crash? I'd do the following: in your dimension update process # in prolog remove the isActive at...

I'd also look into this: Event.Thread Thread[28960] is blocking 72 other threads Something is taking a lock and holding it forcing your main process to roll back and restart. SaveCubeData is server side lock, as is SecurityRefresh, ViewConstruct and a few dimension change functions, so I'd scan your...

Indeed. But on IBM SaaS, you have to raise a ticket to get utilities like 7Zip installed. AFAIK, you don't have to 'install' 7-zip, it's available as standalone executable, so you just need to upload it to the tm1 server (any of the shared folders you have access to) and it should work. And 7z is a...

I see this file since i use the "IBM Cognos TM1 Operations Console" - but can also be coincidence, because at that time we also went on a new TM1 version. This is a PA 2.0.3 feature https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_op.2.0.0.doc/c_op_logger.html y...

EvgenyT wrote: ↑

Wed May 20, 2020 2:14 am

Thanks Yuriy, great feedback! I really wanted to be clever

No worries, happy to help.
I have a 'don't be clever' print out just behind my monitor so that I don't forget

It is a real pity that you cannot clear the garbage memory as this would allow you to then allocate maximum resources for quick statups of the model. Assume this is not possible? Maybe through a secret number with the DebugUtility command that only ykud seems to know ;-) Don't know any such command...

I try to avoid being clever around security :) I'd create an individual group for each user and use the lookup cube to populate element security for cost centres via a TI (it will be very fast and doesn't require a Security Refresh). Doing anything with a rule as you describe would require some real...

For example if the view needs 4 gb of memory and there is only 3 gb of garbage memory available the server gets another 4 gb of the unused memory and after the view is no longer needed adds it to the existing 3 gb of garbage for a total of 7 gb. Right or wrong? I'd bet it'll be more the case of the...

Unfortunately the }Stats measures don't include any counters for memory used by dimensions and indicies, only cubes, so there will always be a bit of a gap between "Memory used for cubes" and Total Memory less Garbage Memory. I'm pretty sure you know this trick, but, just in case, this will give yo...

blandmtm1 wrote: ↑

Wed May 13, 2020 1:20 pm

We tried both of these. Job ran without errors but nothing was created in either of the commands. No idea what is going on.

Must be something with user running the tm1 server, try su under it and run the same?

With those documents from IBM, you will find yourself struggling with the syntax of tm1project file eventually. Yes, it can do a few things with Git but very hard to use. :? Do you mind sharing what in tm1project file was confusing? I agree it's very far from intuitive, it's more of an API to build...

The script runs good from terminal / bash but will not run when called from tm1. We gave it 777 just to be safe. We even put a simple echo hello world >> log.txt in the script to see if it ran. Are you trying from the user that runs tm1s? Try running ExecuteCommand ( 'touch /data/disk1/xxx/can_i_cr...

I did this once with a separate tm1 model that ran on a separate / isolated server that had file system level encryption and a different set of OS user accounts. Data was transferred to the main model using file transfer, but files were PGP encrypted. HR server would export the encrypted files to th...

Anything interesting in Admin server log? https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_op.2.0.0.doc/c_usingtheadminserverlog_n1600ba.html I'd put in debug for next weekend to see whether there was a comm error. Anything interesting in the Windows Event log ar...

Hi Guys Our Tm1 model is re-starting for no apparent reason. The Ram usage on the server is very high - around 97% Could this cause it to restart? The physical server itself did not go down, so I'm surprised that it has restarted itself. Any ideas why? Try looking in Windows Event Log -- it might h...

Then I prefer a real client like Architect or PAW, rather than reinventing the wheel - however interesting and challenging that can be 😉 Sure, I'd prefer it as well, but there's none :) I'm not sure PAW will support it anytime soon (they haven't done this in 3 years the capability was there, so it'...

foogy wrote: ↑

Thu Apr 23, 2020 11:17 am

Until then, I will give the SecurityMode=1 option and login with CAM cryptical ID a chance.

Just FYI, IntegratedSecurityMode became a dynamic parameter in PA, so you can flip between 1 and 5 without restarting the service, a little known fact that I really like.

Sorry I just couldn't pass this by without saying that on PA you'd be able to use 'impersonate user' param in REST API and see exactly what that use would see :) https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_rest_api.2.0.0.doc/dg_tm1_odata_auth.html IntegratedSe...

let me first explain the situation: running TM1 10.2.2 with CAM Security (please no comments on outdated version, this is not the topic here) Sorry I just couldn't pass this by without saying that on PA you'd be able to use 'impersonate user' param in REST API and see exactly what that use would se...