RTC query results in "error running query" for some team areas

A RTC query with simple query condition "Team area is" works fine for many team areas in RTC but it fails with an error message "error running query" for some of the team areas.When the query condition is changed from "Team area is" to "Filed against in subtree/is",the problematic queries are running fine.So far,we could not figure out any difference between the team areas for which the queries are working and for the ones which do not work.

Can someone help me by giving any suggestions on what could be the possible root-cause for this issue?

Many thanks!