Filter api requests fail after upgrade to Aria Automation 8.18

Products

• VMware Aria Suite

Issue/Introduction

• When attempting to filter deployments via "Last Updated At" as per the example below you receive a 500 internal server error response:
  
  https://<AriaAutomationFQDN>/deployment/api/deployments?$filter=(lastUpdatedAt gt '2024-07-07T15:29:33.054187')
• The catalog service logs located under /var/log/services-logs/prelude/catalog-service-app/file-logs contain errors similar to:
  
  

2024-08-08T11:05:09.994Z ERROR catalog-service-app [host='catalog-service-app-86d6c57f8f-bnm4b' thread='http-nio-8000-exec-2' user='gss' org='3cdf9016-4027-4473-9fb3-90d75f04d544' trace='66b4a6656fc48b7b390936e3f7c1
f010'] c.v.s.webmvc.error.RestExceptionHandler - Internal Error
com.vmware.symphony.webmvc.error.exception.InternalErrorException: Internal Server Error [Error Reference ID:{fa09e6ea-1a76-4cf4-9299-090a2e9b9e2d}

Caused by: java.lang.IllegalArgumentException: org.hibernate.query.SemanticException: Cannot compare left expression of type 'java.time.Instant' with right expression of type 'java.lang.String'

• The same filter api call works on versions prior to 8.18

Environment

Aria Automation 8.18

Resolution

A resolution for the issue is planned for the vCF 9 release where  a complete set of the odatav2 specification for $filter query statements is targeted.

To workaround the issue you can filter deployments by "Last Updated At" using a range of values:

https://<AriaAutomationFQDN>/deployment/api/deployments?lastUpdatedAt=[2024-08-08T07:00:00.000Z,2024-08-09T06:59:00.000Z]