Issue with "api/v2/ipinterfaces" endpoint , unable to FIQL query hostname/snmpPrimary

Description

Noticed the below issue with "api/v2/ipinterfaces" endpoint, when trying to query hostname/snmpPrimary fields, it gives below hibernate.QueryException Error.
This issue affects the OpenNMS Entities Datasource too.

Log Snippet

I've setup and recreated the same in my lab with below setup [Same as that of client who reported having issue with OpenNMS Entity Datasource] 

Note:
The query works fine when querying for "ipaddress" field but does not work when FIQL Querying for "snmpPrimary" or "hostname".
Also, I've tested the same with Meridian-2021.1.9/2021.1.10/2021.1.11/2021.1.21 and the same issue persists across all those versions.

 

 

 

Acceptance / Success Criteria

None

Attachments

2

Activity

Show:

Alex May January 12, 2023 at 3:29 PM

Merged into `foundation-2020`

Alex May January 10, 2023 at 10:21 PM

PR:

I targeted foundation-2020 as the problem exists there as well.

Sriraag Sridhar January 10, 2023 at 5:04 PM

Thanks , Will wait to hear back more on the same.

Alex May January 10, 2023 at 2:23 PM

For hostname queries, you need to use ‘ipHostName’ instead of ‘hostName’. For snmpPrimary queries, it looks like there was an [issue]() that was fixed in 29.0.0. The fix looks like it’s fairly significant. I’ll ask around to see how dangerous porting it back would be, or if there’s potentially a simpler way to fix it in 2021.

Fixed

Details

Assignee

Reporter

HB Grooming Date

HB Backlog Status

FD#

Components

Sprint

Priority

PagerDuty

Created November 16, 2022 at 11:48 AM
Updated January 12, 2023 at 3:29 PM
Resolved January 12, 2023 at 3:29 PM