Skip to Content
avatar image
Former Member

SAP RDS - Reset Password

Hi experts,

I've imported SAP RDS and it, for the moment, seems to work properly.

I just have one issue by the Reset Password task.

When I try to reset the password with the task provided by RDS I get this screen.

The Attribute exist and seems correct.

When I deactivate the script it works except of course with the list that should show the values :

Do I have to do something ?

Is the script correct ?

SELECT SUBSTRING(attrname,8,30) AS repositories FROM idmv_value_basic WHERE attrname LIKE 'ACCOUNT%' AND mskey = %USERMSKEY% ORDER BY attrname

Thanks for your help,

Nicolas.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 26, 2013 at 02:09 PM

    Hello Nicolas,

    I think it should be SUBSTR and not SUBSTRING. 😊

    Regards,

    Steffi.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Nicolas,

      I am quite interested in this RDS feature, but unfortunately I don't have a RDS system to access.

      Based on my understanding, the RDS reset password should behave differently than standard reset passwords tasks.

      For stand reset password task, you need only one password for all systems. Whenever this password changes, the password will be updated on all backends.

      For RDS one, since you can reset password on individual system, you must store separate passwords (either permanently or temporarily) for each backend system. That's why you must have custom attributes for that purpose. For  instance, SAPC_IDEN_REP_ENCRYPTED_PASSWORD_TESTGS5. TESTGS5 i assume is one of your backend systems.

      Back to your issue, you have noticed that the password has been changed on all backend system in parallel. This is incorrect, you need to confirm MX_PASSWORD should not be updated in this UI task.

      You also got some error messages saying

      "SAPC_IDEN_REP_ENCRYPTED_PASSWORD_TESTGS5 has not been updated successfully with value [{DES3CBC}XSFDSFAFDADFA]"

      You need to check whether these attributes are created for MX_PERSON already and these attributes accept encrypted values?

      Best Regards

      Jack Xiong