IJ10683: CANNOT DELETE DATA FROM MESSAGE ERROR TABLE BY DELETEQUEUE.CMD.

APAR status

• Closed as program error.

Error description

• PROBLEM:
  When running deletequeue.cmd in LDAP environment,
  NullPointerException happens on deleting data from message
  error tables.
  
  STEPS TO RECREATE:
  1) Add the following system property from System Properties
  application.
  Property Name : mxe.int.securequeueclient
  Value : 0
  
  2) Modify deletequeue.cmd as below.
  ------------------------------------------------
  @echo off
  SETLOCAL
  set JAVA_OPTIONS=-Dqueuename=jms/maximo/int/queues/sqin
  -Dserviceurl=rmi://localhost:13400/MAXIMO -Dusername=maxadmin
  -Dpassword=<password> -Dusermi=1
  rem use the command line below only if appserver security is
  set to true. use launchWebSphereThinClient for websphere
  rem launchWebLogicThinClient psdi.iface.jms.DeleteQueueMessage
  ...
  ------------------------------------------------
  
  3) Run deletequeue.cmd from the command prompt on the
  Administrative Workstation. The following error is shown:
  invoking view queue... jms/maximo/int/queues/sqin
  java.lang.NullPointerException
          at
  psdi.iface.mic.MicService.deleteErrorFileAndTableRow(MicService.
  java:828)
          at
  psdi.iface.mic.MicService.deleteQueueData(MicService.java:793)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
  Method)
          at
  sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor
  Impl.java:94)
          at
  sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
  AccessorImpl.java:55)
          at java.lang.reflect.Method.invoke(Method.java:619)
          at
  sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:3
  39)
          at sun.rmi.transport.Transport$1.run(Transport.java:189)
          at sun.rmi.transport.Transport$1.run(Transport.java:186)
          at
  java.security.AccessController.doPrivileged(AccessController.jav
  a:366)
          at
  sun.rmi.transport.Transport.serviceCall(Transport.java:185)
          at
  sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.j
  ava:568)
          at
  sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTra
  nsport.java:823)
          at
  sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTran
  sport.java:682)
          at
  java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExec
  utor.java:1176)
          at
  java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExe
  cutor.java:641)
          at java.lang.Thread.run(Thread.java:853)
          at
  sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(S
  treamRemoteCall.java:285)
          at
  sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.
  java:263)
          at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:172)
          at
  psdi.iface.mic.MicService_Stub.deleteQueueData(Unknown Source)
          at
  psdi.iface.jms.DeleteQueueMessage.main(DeleteQueueMessage.java:8
  3)
  
  4) Confirm the messages are successfully deleted from the queue
  on the application server but data like entries under Message
  Reprocessing application is not deleted from message error
  tables.
  
  RESULTS:
  Data like entries under Message Reprocessing application is not
  deleted from message error tables by deletequeue.cmd because of
  NullPointerException.
  
  EXPECTED RESULTS:
  Data like entries under Message Reprocessing application should
  be deleted from message error tables when running
  deletequeue.cmd. NullPointerException should not be shown on
  the command prompt.
  
  PRODUCT VERSION:
  7.6.0.9 Build 20171127-0100
  

Local fix

• Use deletequeue.cmd in non-LDAP environment.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users.                                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When deleting Maximo JMS queue error messages via RMI, if    *
  * mxe.int.securequeueclient, the deletion may fail with a null *
  * pointer exception.                                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is included in the following package:
                          | Release 7.6.1.1 of Base Services.
  

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

  INTEGRATION

• Fixed component ID

  5724R46I1

Applicable component levels

• R760 PSY

     UP