Getting " no types registered yet" with sub-query in from clause

[Former Member]

I'm running the below query as per suggestion in https://answers.sap.com/questions/12753456/does-flexible-search-support-sub-query-in-from-cla.html (hybris 5.4) This works in hac but when running in application it appears to fail to infer the type >>

java.lang.IllegalStateException: no types registered yet

running it with >>

 final SearchResult<ApparelStyleVariantProductModel> searchResult = flexibleSearchService.search(query);
 

Query >>

 SELECT p1.pk FROM
     ({{
         SELECT {p.pk},{p.code} FROM {ApparelStyleVariantProduct! as p} WHERE {catalogVersion} = ?catalogVersion
     }}) p1
     LEFT JOIN
     ({{
         SELECT DISTINCT {p.pk},{p.code} FROM {ApparelStyleVariantProduct! as p}  WHERE {p.pk} NOT IN (?restrictedproducts)
     }}) p2      on p1.code=p2.code
     LEFT JOIN
     (
         {{ SELECT {p2p:source} AS pk FROM {ProductPromotionRelation AS p2p } WHERE ?promo = {p2p:target} }}
         UNION
         {{ SELECT {cat2prod:target} AS pk FROM {CategoryProductRelation AS cat2prod}    WHERE {cat2prod:source} IN (?promotionCategories_0) }}
     ) p3
     on p2.pk=p3.pk
     LEFT JOIN
     ({{
         SELECT {cat2prod:target} AS pk FROM { CategoryProductRelation AS cat2prod} WHERE {cat2prod:source} IN (?restrictedcategories)
     }}) p4
     on p3.pk=p4.pk WHERE p4.pk is null
 ORDER BY {pk} ASC;