Architecting, installing and maintaining your SAS environment

How to migrate user/groups from SAS 9.2 to SAS 9.4

Accepted Solution Solved
Reply
Contributor
Posts: 36
Accepted Solution

How to migrate user/groups from SAS 9.2 to SAS 9.4

Hi,

I am having around 10,000 users and 50 groups in SAS 9.2 environment, and I want to create them in SAS 9.4 environment.

Can anyone please help me on bulk import/export for the migration of users and groups?

Thanks,

Mike


Accepted Solutions
Solution
‎04-11-2015 11:58 PM
PROC Star
Posts: 425

Re: How to migrate user/groups from SAS 9.2 to SAS 9.4

Posted in reply to Micheal_S

As I mentioned, did you get anything in the work.mduimplb_failedobjs table after running %mduimplb? This will provide information on any failed metadata updates.


If you are able to post the SAS log (zipped up) that would be helpful to look at.


Also earlier in this thread you were getting the odd error "ERROR: login : Foundation cannot be found in the  container in the  repository." How did you rectify that and what was the cause? I'm wondering if it might be related.

View solution in original post


All Replies
Super User
Posts: 3,254

Re: How to migrate user/groups from SAS 9.2 to SAS 9.4

Posted in reply to Micheal_S

You should check out the "More Like This" questions like this one:

https://communities.sas.com/message/239439#239439

PROC Star
Posts: 425

Re: How to migrate user/groups from SAS 9.2 to SAS 9.4

Posted in reply to Micheal_S

Take a look at SAS Usage Note 42251 - Partial Promotion of User and Group Metadata - it provides an outline (and sample code) of how to synchronize users between 2 different version SAS environments.

If you're going to be at SAS Global Forum 2015 in Dallas in a few weeks, and are interested in seeing a point-and-click approach to synchronizing users from external identity sources (including between different version SAS environments), then come and see me at the Metacoda stand in the Quad and I'll show you what we have been working on in this area.

Contributor
Posts: 36

Re: How to migrate user/groups from SAS 9.2 to SAS 9.4

Posted in reply to Micheal_S

Hey Paul,

I have used the code provided by you to update the users and groups but after rectifying all the issues, I am getting one error which I am not able to understand.

ERROR: login : Foundation cannot be found in the  container in the  repository.

Please suggest if you have any suggestion on this.

Contributor
Posts: 36

Re: How to migrate user/groups from SAS 9.2 to SAS 9.4

Posted in reply to Micheal_S

Thank you all...it worked.

Community Manager
Posts: 407

Re: How to migrate user/groups from SAS 9.2 to SAS 9.4

Posted in reply to Micheal_S

Hi Michael,

Since you were given a good answer, I will mark this as "assumed answered." You can do this any time you receive a helpful/good response. It will ensure others find the answer should they have a similar question. Thanks for using the community!

Shelley

Contributor
Posts: 36

Re: How to migrate user/groups from SAS 9.2 to SAS 9.4

Posted in reply to Micheal_S

Hi,

I was working on loading another set of Users/Groups in SAS 9.4 from SAS 9.2 using backend load thru %MDUIMPLB and other similar macros, its loading all the users and groups but not updating the "GROUP AND ROLES" tab for users. Any suggestions?

Thanks,

Mike

%MDUIMPLB

PROC Star
Posts: 425

Re: How to migrate user/groups from SAS 9.2 to SAS 9.4

Posted in reply to Micheal_S

I'm guessing you've already checked the SAS log for warnings and errors? Does your source grpmems table have contents, and can you see a combination of a grpkeyid + memkeyid for a group and user that appears in the grpmems table but doesn't make it into metadata? After the %mduimplb macro completed did you get anything in the work.mduimplb_failedobjs table?

Finally, looking at the %mduimplb macro, it allows you to set a couple of macro variables to capture the metadata XML requests and responses so you can see if it contains the appropriate metadata XML to configure the group memberships.

%let _mduimplb_outrequest_=/path/to/temp/xml/dir;

%let _mduimplb_outresponse_=/path/to/temp/xml/dir;

Contributor
Posts: 36

Re: How to migrate user/groups from SAS 9.2 to SAS 9.4

Posted in reply to PaulHomes


Hi Paul,

I have executed %mduimplb macro 2 times, first for the purpose of testing i have loaded limited numbers of users. In this run i left grpmems table blank so just users created without any relations. - which is good enough

I deleted all the test users created in above step.

I loaded all the canonical tables including GRPMEMS and again executed %mduimplb macro, this time all the users are created but 'Groups & Roles' and 'Accounts' tab is not updated. - this time its showing an error in log saying

"ERROR: The method is not directed at a repository.  (The Reposid parameter is blank.)"

I seached out but not able to get the proper solution to this issue. Please help

Thanks,
Mike

Solution
‎04-11-2015 11:58 PM
PROC Star
Posts: 425

Re: How to migrate user/groups from SAS 9.2 to SAS 9.4

Posted in reply to Micheal_S

As I mentioned, did you get anything in the work.mduimplb_failedobjs table after running %mduimplb? This will provide information on any failed metadata updates.


If you are able to post the SAS log (zipped up) that would be helpful to look at.


Also earlier in this thread you were getting the odd error "ERROR: login : Foundation cannot be found in the  container in the  repository." How did you rectify that and what was the cause? I'm wondering if it might be related.

Contributor
Posts: 36

Re: How to migrate user/groups from SAS 9.2 to SAS 9.4

Posted in reply to PaulHomes

Hi Paul,

I checked out table work.mduimplb_failedobjs for errors, found out that
multiple Keyid were having same values and it was getting discarded. I updated
them and reloaded. It worked…really wanna thank you for spending time on my
problem.

Thanks,

Mike

PROC Star
Posts: 425

Re: How to migrate user/groups from SAS 9.2 to SAS 9.4

Posted in reply to Micheal_S

No problem. Glad you were able to resolve it.

New Contributor
Posts: 2

Re: How to migrate user/groups from SAS 9.2 to SAS 9.4

Posted in reply to PaulHomes

Please help me to migrate 4500 internal SAS users from SAS 9.2 to 9.4

New Contributor
Posts: 2

Re: How to migrate user/groups from SAS 9.2 to SAS 9.4

Posted in reply to Micheal_S

Hi please help me to migrate internal users 9.2 to 9.4 not able to create internal users login details.

Super User
Posts: 7,806

Re: How to migrate user/groups from SAS 9.2 to SAS 9.4

Since this thread has already been marked as answered, it won't attract many viewers. It is better to open a new one. State what you already tried (see the notes mentioned in this thread) and where you failed.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 14 replies
  • 2434 views
  • 2 likes
  • 6 in conversation