Solr index excluding some products

[Former Member]

We have around 114K products. Once Solr full index is completed, it is listing only around 89K products. There are no errors in the solr & console logs. We are using Hybris 5.7 version. Also while running from HAC, Solr query is returing 114k products. Please suggest.

[Former Member]

Hi Venkata Subrahmanya ,

please share the full index query.

[Former Member]

Below is the Solr indexing query being fired

SELECT item_t0.PK FROM products item_t0 WHERE ( item_t0.p_baseproduct not in (SELECT item_t1.PK FROM products item_t1 JOIN cat2prodrel item_t2 ON item_t1.PK = item_t2.TargetPK JOIN categories item_t3 ON item_t2.SourcePK = item_t3.PK WHERE ( item_t3.p_code ='services') AND ((item_t1.TypePkString IN (?,?,?,?,?) AND item_t2.TypePkString=? AND item_t3.TypePkString IN (?,?,?,?) )))) AND (item_t0.TypePkString=? )

[former_member1284847]

Just check the full indexer query if any condition is giving which is restricting all products to be indexed

[Former Member]

Verified by activating the jdbc logs and no restrictions added to the query.

[Marko_salonen]

Can there be search restrictions that are being applied for the solr indexing? Activate jdbc logs and run the index, see how query looks then. It might be that you have some search restrictions that are applied.