Unable to see orgs after in place upgrade from 5.7.3 to 6.0.2.1 SP2

3 years ago

Originally Published: 2010-08-13

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)

Don't see what you're looking for?

Related Articles

Trending Articles