Compact Central Repository - Permissions Lost

dataservices administration
1

Hi All,

I just compacted a central repository and in the process lost a large number of the permissions that had been set on objects, majority now only have a permission of READ, regardless of the central repo group, which isn’t overly helpful…

Are the permissions on objects in the Central Repo only linked to the original/first added object?

Cheers,
Aaron

titmarsh :australia: (BOB member since 2006-08-31)

2

Ouch, sorry to hear that. There isn’t much information out there regarding compacting of central repos. I would have thought that new object versions would inherit the authorisations from the previous version, but it sounds like that is not the case. All I can say is that I have read somewhere that compacting a central repo is not recommended, but the main reason for that recommendation was that obviously you lose your object version history, which is extremely useful to have. The other recommendation I have read is to always back up a repo before compacting (as far as I know you can log into it just like a local repo and then export the repo to file - just make sure no-one else is using it, or back it up at the database level) - I hope you have a recent database backup you can fall back on.

ClintL :south_africa: (BOB member since 2011-01-06)

3

I was looking at re-base lining activity as part of a migration to a new host, so had a copy of the schema, so was able to recover to the pre-compact point.

After watching Werner’s DS4.0 install video, I’m looking forward to what will come of support for (integration with) SubVersion (and hopefully Bamboo too).

Cheers,
Aaron

titmarsh :australia: (BOB member since 2006-08-31)

4

Oh, I didn’t know about the video and I’m about to upgrade at a client in a couple of weeks so I’ll check it out. Thanks!

ClintL :south_africa: (BOB member since 2011-01-06)

5

This is not the case. As far as I remember, from version 11.0 we cannot login to Central Repository. Before to that we can actually do that.

This is a real question about the Rights for the groups. I would say that what it does is centainly not expected.

By the way, what version of DI/DS are you referring to? I would go ahead and see what happens on this? And yes, compact Local but I too recommend don’t compact central.

But as ClintL says, make it as a rule that you take .atl backup of whatever changes you do on objects level.
But on the level of repository, then may be you should submit a DBA request to schedule a DB level backup of your repository database :wink:

ganeshxp :us: (BOB member since 2008-07-17)

6

My apologies. You are correct Ganesh, just tried it and it’s no longer possible to login to central repo from the Designer, whether secure or not. It was a long time ago that I last did that so must have been before ver 11, probably when it was still called Acta :lol:

ClintL :south_africa: (BOB member since 2011-01-06)

7

FYI Link to the Install video is below;

http://www.sdn.sap.com/irj/scn/elearn?rid=/library/uuid/f03c554b-246c-2e10-9f8d-d615331455ef

titmarsh :australia: (BOB member since 2006-08-31)

8

Thanks :+1: I found it yesterday and watched it already. Looks dead easy, especially when it’s a new installation as opposed to an upgrade - which mine basically is because the client wants to keep the old version in place for a while as a fall back option while we test all the jobs on the new version on a new server with a separate SQL instance. So hopefully my installation goes as smoothly as Werner’s :wink:

ClintL :south_africa: (BOB member since 2011-01-06)

9

Mine was absolutely smooth - after the third try. You need to be careful at the prerequisites and don’t select a custom installation, use the standard one. The standard lets you configure every important option anyhow.

Werner Daehn :de: (BOB member since 2004-12-17)

10

Thanks Werner, I appreciate the advice !

ClintL :south_africa: (BOB member since 2011-01-06)