IJ36929: WHEN USING THE OSLC API GETLIST FUNCTION, AN EXCEPTION IS RETURNED IF A DATE FIELD WITH A NULL VALUE EXISTS AND THE _DROPNULLS=0

APAR status

• Closed as program error.

Error description

• PROBLEM:
  When using the oslc api getlist function, an exception is
  returned if a date field with a NULL value exists and the
  _dropnulls=0 parameter is used.
  
  
  
  PERFORMANCE ISSUE:
  NO
  
  STEPS TO REPRODUCE:
  https://maximo-xxxx.xxx.com/maximo/oslc/os/mxoperloc/zombie/get
  list~location?lean=1&oslc.select=location,installdate&_dropnull
  s=0
  
  BMXAA1649E - A programming error resulted in a null pointer
  exception.
  
  Steps to reproduce:
  send a GET request to Maximo using the getlist function of the
  location object. The oslc.select statement contains "location"
  and "installdate". In the database used, the value of
  INSTALLDATE is NULL for any LOCATION record for this test.
  
  The GET request looks similar to:
  ttps://maximo-xxxx.xxx.com/maximo/oslc/os/mxoperloc/zombie/getl
  ist~location?lean=1&oslc.select=location,installdate&_dropnulls
  =0
  
  Result:
  The response returned is:
  {
  "Error": {
  "reasonCode": null,
  "message": "BMXAA1649E - A programming error resulted in a null
  pointer exception.",
  "statusCode": "500"
  }
  }
  
  Expected Result:
  The INSTALLDATE attribute should be returned with an empty value
  in the response:
  {
  "member": [
  {
  "location": "SAN101",
  "href": "http://mx-belinda1.fyre.ibm.com:9080/maximo/oslc/os/mx
  operloc/zombie/getlist~location/0-64",
  "installdate": ""
  },
  }
  
  PRODUCT VERSION:
  App Server IBM WebSphere Application Server 9.0.5.3
  Version
  Tivoli's process automation engine 7.6.1.2 Build 20200715-0100
  DB Build V7612-284
  IBM Maximo Asset Management Work Centers 7.6.0.4 Build
  20200715-0100 DB Build V7604-119
  IBM Tpae Integration Framework 7.6.1.2 Build 20200615-2330 DB
  Build V7612-11
  IBM Maximo Asset Management 7.6.1.2 Build 20200715-0100 DB Build
  V7611-01
  IoT Connection Utility 7.6.0.3 Build 20200701-1409 DB Build
  V7603-32
  Server OS Windows Server 2012 R2 6.3
  Server DB DB2/NT64 11.1 (SQL110145)
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When using getlist and when there is a date field in the     *
  * list having a null value, an exception is thrown             *
  ****************************************************************
  

Problem conclusion

• Fixed
  

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