topic Re: How to migrate user/groups from SAS 9.2 to SAS 9.4 in Administration and Deployment

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

Micheal_S — Tue, 24 Mar 2015 18:51:20 GMT

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

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

SASKiwi — Tue, 24 Mar 2015 19:00:07 GMT

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

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

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

PaulHomes — Tue, 24 Mar 2015 22:16:29 GMT

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.

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

Micheal_S — Mon, 30 Mar 2015 20:38:08 GMT

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.

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

Micheal_S — Tue, 31 Mar 2015 18:31:30 GMT

Thank you all...it worked.

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

ShelleySessoms — Tue, 31 Mar 2015 19:53:15 GMT

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

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

Micheal_S — Thu, 09 Apr 2015 19:09:14 GMT

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

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

PaulHomes — Thu, 09 Apr 2015 23:02:28 GMT

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;

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

Micheal_S — Fri, 10 Apr 2015 16:11:36 GMT

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

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

PaulHomes — Sun, 12 Apr 2015 03:58:21 GMT

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.

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

Micheal_S — Tue, 14 Apr 2015 16:13:40 GMT

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

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

PaulHomes — Wed, 15 Apr 2015 23:22:20 GMT

No problem. Glad you were able to resolve it.

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

meri — Tue, 21 Apr 2015 23:46:32 GMT

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

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

meri — Wed, 22 Apr 2015 03:49:31 GMT

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

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

Kurt_Bremser — Wed, 22 Apr 2015 12:37:36 GMT

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.