Exception while executing flexible search

[former_member651381]

I am getting below exception when i execute any flexible search from hac . Any pointers would be appreciated .

DefaultHandlerExceptionResolver] Failed to write HTTP message: org.springframework.http.converter.HttpMessageNotWritableException: Could not write content: (was java.lang.NullPointerException) (through reference chain: de.hybris.platform.hac.data.dto.SqlSearchResultData["catalogVersionsAsString"]); nested exception is com.fasterxml.jackson.databind.JsonMappingException: (was java.lang.NullPointerException) (through reference chain: de.hybris.platform.hac.data.dto.SqlSearchResultData["catalogVersionsAsString"]

[former_member645853]

The same issue when executing this query from HAC:
SELECT {o.PK} from {Order as o JOIN OrderEntry as oe ON {o.PK}={oe.order}} group by {o.PK} HAVING sum({oe.price}) != {o.price}

[former_member724056]

Hi All Please share now how this issue was resolved as we are really stuck presently with the same trace in some of our lower environments

[g_madhava1]

Unless you show us what impex you are trying to run, it would he hard for us to tell what is wrong.

[former_member651381]

Any flexible search. EX : Select count(*) from {Product}