on Jun 14, 2016Article Content
| Article Number | 000013075 |
| Applies To | AAOP 6.0.2.1 SP2 AAOP upgraded from 5.7.3 |
| Issue | The following error appears in the specific accessmanagement application log: ERROR [com.rsa.csd.backoffice.accessmanagement.action.OrgsAction] - <Error getting the list of all orgs.null> |
| Cause | This issue is caused by the org_mapping table in the Back Office database being completely empty. The customer experiencing the issue should run the following SQL script to confirm that the org_mapping table is empty: select user_id,org_id from org_mapping; Because there are no userIDs mapped to any organizations, the authorization subsystem in the Back Office prevents even the admin user from viewing the orgs within the database. |
| Resolution | Insert row(s) in the mapping table associating the admin userID (normally ID=0), to the parent organization IDs that are listed in the Core Database under the Orgs table via the respective database management tool. |
| Notes | Full stacktrace for the above symptom: java.lang.NullPointerException at com.rsa.csd.backoffice.accessmanagement.action.OrgsAndGroupsUtil.getA uthorizedOrgs(OrgsAndGroupsUtil.java:25) at com.rsa.csd.backoffice.accessmanagement.action.OrgsAction.getUserAuth orizedOrgs(OrgsAction.java:236) at com.rsa.csd.backoffice.accessmanagement.action.OrgsAction.setupReques t(OrgsAction.java:183) at com.rsa.csd.backoffice.accessmanagement.action.OrgsAction.unspecified (OrgsAction.java:398) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchActio n.java:256) at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java: 194) at com.rsa.csd.backoffice.action.BaseAction.execute(BaseAction.java:26) at org.apache.struts.action.RequestProcessor.processActionPerform(Reques tProcessor.java:419) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja va:224) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:119 4) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) at javax.servlet.http.HttpServlet.service(HttpServlet.java:718) at javax.servlet.http.HttpServlet.service(HttpServlet.java:831) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper .java:1655) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper .java:1595) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilte rChain.java:131) at com.passmarksecurity.tools.auth.client.AuthServletFilter.doFilter(Aut hServletFilter.java:457) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterI nstanceWrapper.java:188) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilte rChain.java:116) at com.passmarksecurity.tools.auth.client.SetCharacterEncodingFilter.doF ilter(SetCharacterEncodingFilter.java:90) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterI nstanceWrapper.java:188) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilte rChain.java:116) at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilt erChain.java:77) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFil terManager.java:908) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletW rapper.java:932) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletW rapper.java:500) at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(Serv letWrapperImpl.java:178) at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3826) at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:2 76) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java: 931) at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.j ava:1583) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.jav a:186) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimina tion(HttpInboundLink.java:455) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInforma tion(HttpInboundLink.java:384) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboun dLink.java:272) at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDi scriminators(NewConnectionInitialReadCallback.java:214) at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete (NewConnectionInitialReadCallback.java:113) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueu eManager.java:557) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManag er.java:607) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManag er.java:984) at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueMana ger.java:1069) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1550) |
| Legacy Article ID | a51930 |