Users cannot login after the import

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

After doing an import users can no longer log in to the Applications Manager client. 

The client log file is showing 

log: C:\AM_Client\log\ABCD_QA_client.log
ErrorMsg: AwE-9999 Internal error (3/10/23 12:22 PM) 
Details: null
java.lang.NullPointerException
    at java.util.ComparableTimSort.binarySort(Unknown Source)
    at java.util.ComparableTimSort.sort(Unknown Source)
    at java.util.Arrays.sort(Unknown Source)
    at java.util.Arrays.sort(Unknown Source)
    at java.util.Vector.sort(Unknown Source)
    at java.util.Collections.sort(Unknown Source)
    at com.appworx.client.screen.reqmgr.ReqMgr.A(ReqMgr.java:939)
    at com.appworx.client.screen.reqmgr.ReqMgr.tableChanged(ReqMgr.java:357)
    at com.appworx.client.screen.reqmgr.ReqMgr.<init>(ReqMgr.java:158)
    at com.appworx.client.screen.main.AxMain.?(AxMain.java:2329)
    at com.appworx.client.screen.main.AxMain.S(AxMain.java:180)
    at com.appworx.client.screen.main.AxMain$42.run(AxMain.java:2191)

Environment

Release: 9.3, 9.3.5

Resolution

1. Make sure that Apache is up and running

If Apache is up and running

2. Make sure that the client's connections.properties file has the correct host value, port value, master name

If these values are correct then log in to the Database as the Applications Manager Oracle user and run

3. SQL> truncate table aw_user_role_details;

You can back up the table if you desire and then truncate. This table is loaded every time a person logs in and you do not have to stop or start anything, just log out and close the Appworx GUI, truncate the above table, and then restart the client. If anybody is logged in they should log out.