Error when removing roles from users

[Former Member]

Hi All,

When I try to remove a role from a user using an Access Request I’m getting one of those “Error in module RSQL of the database interface”:

Category                 ABAP Programming Error

Runtime Errors        DBIF_RSQL_INVALID_RSQL

Except.                  CX_SY_OPEN_SQL_DB

ABAP Program        CL_GRAC_ACCESS_REQUEST_UTIL===CP

Application Component  GRC-AC 

Error analysis

    An exception occurred that is explained in detail below.

    The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught

     in

    procedure "VERIFY_USERROLE_PARTOFBR" "(METHOD)", nor was it propagated by a

     RAISING clause.

    Since the caller of the procedure could not have anticipated that the

    exception would occur, the current program is terminated.

    The reason for the exception is:

    In a SELECT access, the read file could not be placed in the target

    field provided.

    Either the conversion is not supported for the type of the target field,

    the target field is too small to include the value, or the data does not

    have the format required for the target field.

We are in release V1000 SP 11 and the notes I have seen don’t seem to address this problem.  Any help is greatly appreciated.

[Former Member · Accepted solution]

Hi All,

So at least I have a note that will be step one with fixing this issue.  I saw that in our system role removal was not taking in to consideration the date of the role assignment (something that was fix by SAP on SP13 I think) so note 1874161 is the first one in fixing this problem.  After this note there are several others to address issues between Business and Single roles but at least 1874161 will the first.  Thanks

[former_member185447 · Accepted solution]

Hello Tavarez,

Thanks for sharing the solution.

Regards,

Deepak M

[Former Member]

Hi,

     What r ur system details? What support pack r u in?

Regards,

Fazil

[Former Member]

Hi Fazil,

As mentioned in my first post we are in release V1000 SP 11, do you wanted to know something more specific?

[Former Member]

There is this snote, but from a very early support pack http://service.sap.com/sap/support/notes/1637698

i would suggest doing a full object repository sync again and then see if re-importing the role definition into BRM works.

By any chance are you using Business Roles?

[Former Member]

Hi Harinam,

Yea, I saw that note but is grey out in our system.  I try doing several full synchs and re-import but same issue.  As for your last question we are not using Business Roles, as of today we are just using the system for Composite and Single role provisioning.  Any other ideas?

[Former Member]

check this note if you are using Business roles:

1930923 - UAM:-Business role removal is not working correctly in Access Request

[Former Member]

Hi Mahboob,

We are NOT using BRM.