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.
Chore error: No Security Access for "SecurityRefresh".
- 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".
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
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
-
- 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".
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.