Element Security gets wiped - how to debug

[Paul-TM1]

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.

[Paul-TM1]

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.

[Wim Gielis]

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.

[Steve Rowe]

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.

[burnstripe]

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)

[orlando]

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