GRC AC v5.3 CUP - Initial Data Files

[Former Member]

Hi All,

re: GRC AC v5.3 CUP - Initial Data Files

Our GRC-AC v5.3 CUP Dev system has too many roles and we want it to match our GRC-AC v5.3 CUP QA system. We do not want to go through one role at a time and delete them. Would it be the correct procedure to export the CUP QA system "Initial Data" files for "Roles" and import into CUP DEV using the setting "Clean and Insert".

Both systems are on the same CUP Version / SP / Build.

Any help on this would be greatly appreciated.

Thanks,

John

[koehntopp · Accepted solution]

I'm sorry, there is no easy way to do that.

You can either delete them 10 at a time, or open an OSS message with SAP and ask for assistance. They will send you a DB design document, you should be able to use that with your DB admin to get rid of the roles quickly.

Frank.

[Former Member · Accepted solution]

John,

The clean and insert option would not work with roles. You will have to follow what Frank has mentioned here.

Alpesh

[Former Member]

Hi All,

Yes, you are correct. An attempt gives the following error message:

"x Please select Insert or Append option, to avoid Data Integrity errors, Clean and Insert option is not available."

We came up with some additional options that we will pursue to resolve this.

Thanks for your help on this.

-john

[Former Member]

>

> Hi All,
> 
> Yes, you are correct. An attempt gives the following error message:
> 
> "x Please select Insert or Append option, to avoid Data Integrity errors, Clean and Insert option is not available."
> 
> We came up with some additional options that we will pursue to resolve this.
> 
> Thanks for your help on this.
> 
> -john

Hi John,

Can you elaborate on what options you pursued to do mass role removal in CUP?

Thanks!

--

Jes

[koehntopp]

Jes,

currently there is no such option. You will either have to delete them manually or use the database structure and delete them there directly.

Frank.