Flexi query to find a category who is super category of its own.

[varsha18]

Hi,

I have some problem in data on test environment due to which I am getting recursive error

{"class":"de.hybris.platform.category.impl.DefaultCategoryService","method":"getAllSupercategories","file":"DefaultCategoryService.java","line":388,"exact":false,"location":"platformservicesserver.jar","version":"?"},{"class":"de.hybris.platform.category.impl.DefaultCategoryService","method":"getAllSupercategories","file":"DefaultCategoryService.java","line":388,"exact":false,"location":"platformservicesserver.jar","version":"?"},{"class":"de.hybris.platform.category.impl.DefaultCategoryService","method":"getAllSupercategories","file":"DefaultCategoryService.java","line":388,"exact":false,"location":"platformservicesserver.jar","version":"?"},{"class":"de.hybris.platform.category.impl.DefaultCategoryService","method":"getAllSupercategories","file":"DefaultCategoryService.java","line":388,"exact":false,"location":"platformservicesserver.jar","version":"?"},{"class":"de.hybris.platform.category.impl.DefaultCategoryService","method":"getAllSupercategories","file":"DefaultCategoryService.java","line":388,"exact":false,"location":"platformservicesserver.jar","version":"?"},{"class":"de.hybris.platform.category.impl.DefaultCategoryService","method":"getAllSupercategories","file":"DefaultCategoryService.java","line":388,"exact":false,"location":"platformservicesserver.jar","version":"?"},{"class":"de.hybris.platform.category.impl.DefaultCategoryService","method":"getAllSupercategories","file":"DefaultCategoryService.java","line":388,"exact":false,"location":"platformservicesserver.jar","version":"?"},{"class":"de.hybris.platform.category.impl.DefaultCategoryService","method":"getAllSupercategories","file":"DefaultCategoryService.java","line":388,"exact":false,"location":"platformservicesserver.jar","version":"?"},{"class":"de.hybris.platform.category.impl.DefaultCategoryService","method":"getAllSupercategories","file":"DefaultCategoryService.java","line":388,"exact":false,"location":"platformservicesserver.jar","version":"?"},{"class":"de.hybris.platform.category.impl.DefaultCategoryService","method":"getAllSupercategories","file":"DefaultCategoryService.java","line":388,"exact":false,"location":"platformservicesserver.jar","version":"?"},{"class":"de.hybris.platform.category.impl.DefaultCategoryService","method":"getAllSupercategories","file":"DefaultCategoryService.java","line":388

I suspect that it is happening because data association of category is not correct and someone mistakenly assigned a category to its super category.

Category: Shirt

Supercategory : Shirt

I am looking for a flexi query which can give me results to find the culprit category. I used below , but it is not returning any results.

Select * from {CategoryCategoryRelation as cr} where {cr.source}={cr.target}

[HimanshuDhiman]

any solution? i am also facing same issue