SQL search error - Fail to convert to internal representation query

[Former Member]

 INFO   | jvm 1    | srvmain | 2018/11/09 10:34:32.050 | de.hybris.platform.servicelayer.search.exceptions.FlexibleSearchException: SQL search error - Fail to convert to internal representation query = 'SELECT  item_t0.code  FROM products item_t0 WHERE (item_t0.TypePkString=? AND ((  item_t0.p_onlinedate  IS NULL OR  item_t0.p_onlinedate  <= ?) AND (  item_t0.p_offlinedate  IS NULL OR  item_t0.p_offlinedate  >= ?))AND ( item_t0.p_catalogversion  IN (?,?,?))AND ( item_t0.p_approvalstatus  =  8796099510363  ))'

[arvind-kumar_avinash]

Please write your flexible search query which is giving this issue. Please also mention if you are facing this issue only in Java code or also in hAC.

[Former Member]

In custom code base Code was there in DAO instead of PK

[arvind-kumar_avinash]

Glad to know that you caught the issue and resolved it. You can close this question by selecting the 'Close' action from the cogwheel menu on the right side of your question.