IJ28859: UNABLE TO DELETE A RECORD IN MULTI-TENANT ENVIRONMENT AFTER NEW ATTRIBUTE CREATED

APAR status

• Closed as program error.

Error description

• In a Multi-tenant Maximo, not able to delete SRs from within the
  SR application for a specific tenant after a new Tenant
  specific field is added to the TICKET table. This does not
  happen with the other tenants.
  
  ERROR:
  BMXAA4214E Unknown error. Contact Administrator.
  0000164b SystemErr     R Logged an exception at:
  psdi.webclient.system.session.WebClientSession.defaultHandler(We
  bClientSession.java:1624)
  [9/21/20 13:34:19:709 CDT] 0000164b SystemErr     R
  java.lang.NullPointerException: null
  [9/21/20 13:34:19:709 CDT] 0000164b SystemErr     R
  java.lang.NullPointerException
   at java.util.Hashtable.containsKey(Hashtable.java:368)
   at psdi.mbo.Mbo.delete(Mbo.java:4160)
   at psdi.app.ticket.Ticket.delete(Ticket.java:1246)
   at trm.app.ticket.SR.delete(trm.app.ticket.SR.java:149)
  
  atpsdi.webclient.system.beans.DataBean.delete(DataBean.java:3684
  )
   at
  psdi.webclient.system.beans.DataBean.delete(DataBean.java:3667)
   at
  psdi.webclient.system.beans.AppBean.DELETE(AppBean.java:1597)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at
  sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor
  Impl.java:90)
   at
  sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
  AccessorImpl.java:55)
   at java.lang.reflect.Method.invoke(Method.java:508)
   at
  psdi.webclient.system.session.WebClientSession.defaultHandler(We
  bClientSession.java:1510)
   at
  psdi.webclient.system.session.WebClientSession.handleEvent(WebCl
  ientSession.java:1403)
   at
  psdi.webclient.system.session.WebClientSession.processRequestEve
  nt(WebClientSession.java:6219)
   at
  psdi.webclient.system.session.WebClientSession.handleClientSideQ
  ueueRequest(WebClientSession.java:6175)
   at
  psdi.webclient.system.session.WebClientSession.handleRequest(Web
  ClientSession.java:892)
   at
  psdi.webclient.system.session.AsyncRequestManager.handleRequest(
  AsyncRequestManager.java:555)
   at
  psdi.webclient.system.session.AsyncRequestManager.manageRequest(
  AsyncRequestManager.java:253)
   at
  psdi.webclient.system.controller.RequestManager.manageRequest(Re
  questManager.java:290)
   at
  psdi.webclient.servlet.WebClientServlet.handleRequest(WebClientS
  ervlet.java:141)
   at
  psdi.webclient.servlet.WebClientServlet.doPost(WebClientServlet.
  java:52)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  
  
  STEPS TO REPRODUCE:
  1) login to a multi-tenant Maximo as the Tenant Admin
  2) go to the Database Information application
  3) Bring up the TICKET object and add a new Attribute called
  WORKTYPE. Set the same as to WORKTYPE
  4) save the changes, return to the list tab and go to the select
  action menu -> apply changes
  5) DO NOT add the field to the screen
  6) go to Service Requests application, create a new record, save
  it.
  7) try to delete it and get the error
  BMXAA4187E - The relationship does not exist for business object
  SR.....
  * set the field name to other names besides WORKTYPE and  get
  the same error
  ** log into other tenants and able to delete the SR without any
  issue
  
  
  RESULTS:
  BMXAA4187E - The relationship does not exist for business object
  SR.....
  Note:
  * set the field name to other names besides WORKTYPE and  get
  the same error
  ** log into other tenants and able to delete the SR without any
  issue
  
  
  EXPECTED RESULTS:
  should allow  you to delete
  
  
  PRODUCT VERSION:
  TAPE 7.6.1.2
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Any user who added extended attribute to a view and then     *
  * trying to delete record                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Code was not checking of object is view and deleting row     *
  * from incorrect object                                        *
  ****************************************************************
  

Problem conclusion

• Check for the view and find original table name to delete row
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  SYSTEM CONFIG

• Fixed component ID

  5724R46S1

Applicable component levels