APAR status
Closed as program error.
Error description
The REST API does not return all the FAILURELIST records if the following url is used: http://<hostname>:<port>/rest/mbo/failurelist?_lid=maxadmin&_lpw d=maxadmin&_format=json&_compact=1 If the following URL is used then all the records in the FAILURELIST table are being returned: http://<hostname>:<port>/maxrest/rest/mbo/FAILURELIST?_lid=maxad min&_lpwd=maxadmin&_format=json&_compact=1&_includecols=FAILUREC ODE,ORGID,PARENT,TYPE,FAILURELIST,FLCDESCRIPTION,FAILURECLASS Note, the FAILURECODE is needed at the very least in order to return all the records from the FAILURELIST table. Both URL's show in the log file that they are running a SELECT * FROM FAILURELIST, but only one is returning all the records. The first URL return some records but not all of them. In the UI there are 23 records and the URL returns only 19. In the Database there are 379 records in the FAILURELIST table. Only the second URL will return all 379 records. Steps to reproduce: 1. Open Postman 2. Enter get method: http://<hostname>:<port>/rest/mbo/failurelist?_lid=maxadmin&_lpw d=maxadmin&_format=json&_compact=1 Result: 19 records Expectation: All the records (i.e. 379 records) within the FAILURELIST table. Product versions: Maximo 7609 & Maximo 761
Local fix
Dev to provide fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * When querying for FailureList records via REST API, if a * * nonpersistent attribute is included, such as FailureClass or * * FLCDescription, a limited set of results is returned instead * * of the full set of results. * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
The fix for this APAR is included in the following release: | Release 7.6.1.1 of Base Services.
Temporary fix
Comments
APAR Information
APAR number
IJ09029
Reported component name
INTEGRATION
Reported component ID
5724R46I1
Reported release
760
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-09-10
Closed date
2018-09-19
Last modified date
2018-09-19
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"760","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
19 September 2018