Unable to see orgs after in place upgrade from 5.7.3 to 6.0.2.1 SP2
Originally Published: 2010-08-13
Last Modified: 2023-10-06
Article Number
000046485
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)


Related Articles

Trending Articles

Don't see what you're looking for?