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

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 22, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000013075
Applies ToAAOP 6.0.2.1 SP2
AAOP upgraded from 5.7.3
IssueThe 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>
CauseThis 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.
ResolutionInsert 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.
NotesFull 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 IDa51930

Attachments

    Outcomes