TM1 Forum

Hi Gurus,
Everyday after our nightly chores, I see that for a few elements, security is wiped off for all groups in }ElementSecurity_cube. There'snothing that indicates what wiped off in transaction log. I googled but there's nothing that points to my error. How do we debug? There's no porcess that we run nightly that wipes it off. Can anyone please help?

Version: PA 2.0.9.5
We use Contributor and run manage rights daily. After manage rights, the rights are set back. But I want to know what wipes off and how to debug when it's not recorded in transaction log.

Thanks,
Paul.

Sorry I did not mention a point that Transaction Logging is turned on for the }ElementSecurity_cube. After I run the manage rights, I see in transaction log that security s applied. But I do not see what wiped off.

Thanks,
Paul.

You could create a chore with a simple process in it that runs every say 5 minutes. The process just does a few CellPutS statements to certain cells in that cube. At least the following day you can see the evolution… maybe it helps identifying the cause.

Is it possible the elements are getting deleted and then added back? I would expect you to be losing data against these elements as well if this is what is happening too.

Does one of the nightly chores restart the service/model? I've encountered a similar issue before after a package had been redeployed the security would be fine until the service was rebooted after which security would be reverted/cleared. (I don't have a resolution but perhaps it'll point you in the right direction)

Hi,

do you restart the database after setting the permissions?
If so, do you do a SaveDataAll before the restart?
If not, that could explain the loss.

Many greetings
orlando