DRM – Insufficient Rights Error

I thought today, we’d look at a simple error message that might crop during your implementations. I’ve been neglecting the blog for a month or so, and I need something simple to get me back in gear. So, here goes. Sometimes, when you run action scripts, you might run into the following error, “Insufficient rights to update property”.

error

Let’s take a look at why this happens, and a possible resolution. The property in question, is a simple local property.

prop1

The property contains a list of some of my favorite breweries.

prop2

The hierarchy is pretty simple, as well, with a list of beers grouped by region.

hier1

 I tried to use the following action script to set the “Unlk_Inh” property to “Russian River”.

as_1

Theoretically, that should do it, but the script errors out.

as_4

I happen to be an administrator, but I still run into this issue. Plus, there is no security set on this hierarchy. So why does this happen? The answer lies in the property itself. If we look at the property for the node in question, we see that the property itself is locked, with the value “Alpine”.

prop3

If we move our mouse over the status area of the property, we can see a message that the property value has been inherited from a parent above.

prop4

If we now select that parent node, we can see that the property has been locked at this level. This means that all of the nodes below must use the property value, as set by the parent.

prop5

The fix is pretty simple, all you have to do, is unlock the parent property value, by right clicking and selecting “Unlock”.

unlock

If you now re-run the script, it should complete without issue.

success

And there it is, a quick post on how locked properties may result in unintended consequences. More importantly, Cheers, until next time. BTW, I highly recommend Pliny the Younger, if you can get your hands on it.

Avatar

About Vijay Kurian

Known as the Clem Fandango of EPM consulting, Vijay Kurian has been developing enterprise solutions for companies for the last 12 years (increment years if reading post-2015). Having worked with Essbase, Planning, DRM and other assorted technologies during that time, he’s made the frankly, average decision, to write about them. He is, surprisingly, an Oracle ACE Associate. He hopes to contribute frequently to US Weekly, People and Sensible Chuckle magazines on improving reporting solutions, creating master data management systems and zzz…

Leave a Reply

Your email address will not be published. Required fields are marked *