Try looking in the SWISv3 log to see what the actual error is. C:\ProgramData\SolarWinds\InformationService\v3.0\Orion.InformationService.log
Thanks for the reply. i checked the Orion.InformationService.log file and i am unable to locate the error message.
There is a weird situation where by i notice if i do a search for the subnet, it will return me some values (refer to capture 3). It showed 76201 entry but in the documentation portion, it only show a single entry for the IP 10.10.10.248 (refer to capture 4 and 4a). Seems like this happened in IPAM 4.3.2 as I did not encounter such error while using IPAM 4.3. I have open ticket with Solarwinds on this matter but their feedback was they are not able to support me in custom query.
The duplicate records are a known issue (IPAM-606). You should be able to work around that by changing the query from SELECT to SELECT DISTINCT.
For the failed queries, try adding "ORDER BY 1" to the end of the query.