A fix is available
APAR status
Closed as program error.
Error description
A REST call to query a specific object that includes 'totalcount' and 'state' parameters may return an http 500 return code. For example, https://<mgt-ip>/deployment/resources/instances/?vdc=77f8b9b8-c8 90-43ce-beb6-6ff1a4f04bd2&totalcount=true&state=all returns: Application Error! Error Message Error Error Status Code 500 Root Cause java.lang.Exception: Column(s) [distinct state] are not defined for table 'instances' and https://rack35/admin/resources/compute_nodes/?vdcs=77f8b9b8-c890 -43ce-beb6-6ff1a4f04bd2&totalcount=true&state=all returns: Application Error! Error Message Error Error Status Code 500 Root Cause java.lang.Exception: Column(s) [distinct state] are not defined for table 'compute_nodes'
Local fix
Problem summary
Logic to verify requested columns in the management database did not properly handle a 'distinct' modifier on the column name.
Problem conclusion
Column name verification code is changed to ignore 'distinct' modifier.
Temporary fix
Comments
APAR Information
APAR number
IT00102
Reported component name
PUREAPP SYS W15
Reported component ID
5725G3200
Reported release
110
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-11-15
Closed date
2013-11-19
Last modified date
2013-11-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
PUREAPP SYS W15
Fixed component ID
5725G3200
Applicable component levels
R110 PSY
UP
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSM8NY","label":"PureApplication System"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.1.0.0"}]
Document Information
Modified date:
24 September 2021