Chore error: No Security Access for "SecurityRefresh".

Post Reply
ajain86
Community Contributor
Posts: 132
Joined: Thu Oct 15, 2009 7:45 pm
OLAP Product: TM1
Version: 9.4.1 9.5 9.5.1
Excel Version: 2003 2007

Chore error: No Security Access for "SecurityRefresh".

Post by ajain86 »

I am running a scheduled chore that does data loads to my tm1 cube.

The last step in my chore is to do a security refresh and then a save data all.

When I run the chore on my own, there is no error.

When the chore is executed on a schedule, I receive an error: No Security Access for "SecurityRefresh".

Why wouldn't a chore have the access to update security. Doesn't it run as an ADMIN?

Any ideas?

Thanks for your help.
Ankur Jain
User avatar
Michel Zijlema
Site Admin
Posts: 712
Joined: Wed May 14, 2008 5:22 am
OLAP Product: TM1, PALO
Version: both 2.5 and higher
Excel Version: 2003-2007-2010
Location: Netherlands
Contact:

Re: Chore error: No Security Access for "SecurityRefresh".

Post by Michel Zijlema »

Hi,

This is an interesting error - I think this has to do with the distinction between Data Admin and Security Admin users introduced in version 9.4.
It looks like the chore (when triggered by the scheduler) is running on a Data Admin user and not on a full Admin user.

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

Re: Chore error: No Security Access for "SecurityRefresh".

Post by lotsaram »

What Michel says is correct. In 9.4 and 9.5 processes run with "Data Admin" access not full admin access (go figure!). To enable a process executed by a non-full admin user (including the chore scheduler) to run security tasks right-click the process and make sure the "Security Access" option is ticked.
ajain86
Community Contributor
Posts: 132
Joined: Thu Oct 15, 2009 7:45 pm
OLAP Product: TM1
Version: 9.4.1 9.5 9.5.1
Excel Version: 2003 2007

Re: Chore error: No Security Access for "SecurityRefresh".

Post by ajain86 »

that worked. thanks.
Ankur Jain
Post Reply