How should I do it? I want to modify the rules without anyone using TM1.

Post Reply
fanych
Posts: 6
Joined: Mon Dec 11, 2017 2:12 pm
OLAP Product: Cognos TM1
Version: 10.2.2
Excel Version: 2013

How should I do it? I want to modify the rules without anyone using TM1.

Post by fanych » Sat Sep 22, 2018 5:05 pm

Modifying rules and user entry data will cause a lock conflict, resulting in server failure.
so,
Does TM1 have maintenance mode?
or
How to get users who are using TM1

Is there any good way?

message:
140198981224192 [1019] ERROR 2018-09-21 04:06:51.418 TM1.Server Calc has Error, But not fatal:TM1LockException: IX lock conflict(1)


sorry ,My English is poor,

Thank you for your time.

Wim Gielis
MVP
Posts: 1846
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: How should I do it? I want to modify the rules without anyone using TM1.

Post by Wim Gielis » Sat Sep 22, 2018 9:17 pm

In the Security > Clients/Groups option, you can see who is active (logged on) at any point in time.
Or you can use tools like TM1 Top or Operations console or other.

Normally you would adjust/create rules in a development environment. After testing, they would be migrated to the production model with associated (limited) downtilme. If you don't have a development environment, then you will need to save the rules and warn the users of expected downtime / no activity in TM1.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

David Usherwood
Site Admin
Posts: 1337
Joined: Wed May 28, 2008 9:09 am

Re: How should I do it? I want to modify the rules without anyone using TM1.

Post by David Usherwood » Sun Sep 23, 2018 11:28 pm

I recall a post but cannot track it down, suggesting that a good way to lock CAM/AD users out while work is going on is to change IntegratedSecurityMode from 5 to 1. This TM1S.CFG is dynamic in PA 2 at least (not I believe in TM1 10.x)
https://www.ibm.com/support/knowledgece ... n0437.html
Good idea to set up the admin password first of course :)

lotsaram
MVP
Posts: 3148
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: How should I do it? I want to modify the rules without anyone using TM1.

Post by lotsaram » Mon Sep 24, 2018 6:30 am

David Usherwood wrote:
Sun Sep 23, 2018 11:28 pm
I recall a post but cannot track it down, suggesting that a good way to lock CAM/AD users out while work is going on is to change IntegratedSecurityMode from 5 to 1. This TM1S.CFG is dynamic in PA 2 at least (not I believe in TM1 10.x)
https://www.ibm.com/support/knowledgece ... n0437.html
Good idea to set up the admin password first of course :)
That's because it was .. eheeem, posted on LinkenIn. Got to pump up the tyres every now and then.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

Post Reply