2399690 - Role Search not working after SP upgrade or error ROLE_NAME on system XYZCLNT100 is invalid firefighter role or TABLE_INVALID_INDEX

Symptom 1: Role Search not working after upgrading GRC 10.0 to SP24, or equally upgrading GRC 10.1 to SP15.

                  "No Records", "No Results" is the message returned in role search, throughout the application.

Symptom 2: Error ROLE_NAME on system XYZCLNT100 is invalid firefighter role

Symptom 3: Unable to add Business role to Access Request after upgrading from SP14 to SP22.  Click okay and resulting dump in ST22:

CLASS= CL_GRAC_MODEL_ACCESS_REQUEST METHOD= UPDATE_BUSROLESNAP DATA=LT_ROLE_HISTORY_ALL

• SAP GRC Access Control 10.0
• SAP GRC Access Control 10.1
• SAP GRC Access Control 12.0

no records, no results, empty results, blank screen, nothing, roles not found, role not found, does not exist, missing role, disappeared, no longer coming, no longer showing, cannot add role, cant add role, search not working, role search, gracrole, gracrlconn, role_name, role name criteria, wild card, asterix, *, role_name_SH, 2419227, Z report, 2329234, role search performance, CL_GRAC_MODEL_ACCESS_REQUEST, UPDATE_BUSROLESNAP,LT_ROLE_HISTORY_ALL, GRAC_OIF_REQUEST_SUBMISSION , search box , KBA , GRC-SAC-ARQ , Access Request , GRC-SAC-EAM , Emergency Access Management , Problem