Clarity

 View Only
  • 1.  Unlock Clarity PPM admin credentials

    Posted Jan 23, 2020 10:36 AM
    Guys, 
    Please help me by unlocking Clarity PPM admin .

    we have not stored the administrator username and password for CA Clarity v14.3 running on windows 2008 R2. 

    I tried resetting the admin password using below steps:

          1. Delete the '.passwd' file located under [Clarity_Home]\config

    1. Start a command prompt on the Clarity Application Server
    2. Type the command 'admin password'
    3. You will be prompted to enter and confirm a new NSA password.

    when i entered username as 'admin' and with the new password, the error message is " CMN-10003: Invalid login information. Your account has been locked."


  • 2.  RE: Unlock Clarity PPM admin credentials

    Broadcom Employee
    Posted Jan 23, 2020 10:47 AM
    the steps you tried to to reset CSA password and not clarity. Try the steps from this document https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=26874

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------



  • 3.  RE: Unlock Clarity PPM admin credentials

    Posted Jan 24, 2020 01:42 AM
    Hi Suman, 
    I tried the same steps mentioned in the article. still it doesnt work. 
    used the below query. 

    begin trans
    UPDATE niku.CMN_SEC_USERS SET PWD ='b42405b424035653363353861396500601c40b454be3099ad54de35b8f2',
    salt='[B@5e3c58a9',
    USER_STATUS_ID = 200
    WHERE USER_NAME = 'admin';
    commit;

    SQL query was success. 
    then I tried the same clarity ppm webpage using
    username: admin, Password: admin
    shows the error again as: CMN-10003: Invalid login information. Your account has been locked.

    verified in cmn_sec_users for the username 'admin'. it is present. 

    Kindly help me.


  • 4.  RE: Unlock Clarity PPM admin credentials

    Broadcom Employee
    Posted Jan 24, 2020 01:47 AM
    The password is rest to admin where user status is locked, you need to unlock the user and below query should work 

    UPDATE CMN_SEC_USERS
    SET USER_STATUS_ID = 200
    WHERE USER_NAME = 'admin';

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------



  • 5.  RE: Unlock Clarity PPM admin credentials

    Posted Jan 24, 2020 04:07 AM
    we tried your steps still unsuccessful. 

    UPDATE niku.CMN_SEC_USERS
    SET USER_STATUS_ID = 200
    WHERE USER_NAME = 'admin';

    username: admin, Password: admin
    shows the error again as: CMN-10003: Invalid login information. Your account has been locked.

    Do I need to restart any services from Windows?
    CA Clarity v14.3 running on windows 2008 R2


  • 6.  RE: Unlock Clarity PPM admin credentials

    Broadcom Employee
    Posted Jan 24, 2020 04:19 AM
    Very strange, can you share the app-ca log please and what error you are getting

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------



  • 7.  RE: Unlock Clarity PPM admin credentials

    Posted Jan 24, 2020 04:35 AM
      |   view attached
    please find the logs attached

    Attachment(s)

    zip
    app-ca.log.zip   127 KB 1 version


  • 8.  RE: Unlock Clarity PPM admin credentials
    Best Answer

    Posted Jan 24, 2020 06:47 AM
    Edited by Christopher Hackett Jan 27, 2020 01:25 PM
    There are a lot of LDAP errors in that log file.

    Have you perhaps "externally authenticated" your admin user?

    Check the is_ldap column value on CMN_SEC_USERS for your admin user - you probably do not want that set to "1" (you want it set to "0")


  • 9.  RE: Unlock Clarity PPM admin credentials

    Broadcom Employee
    Posted Jan 24, 2020 06:55 AM
    As david said this looks like an LDAP issue, is your clarity configured with LDAP?

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------