Query-object search results size has exceeded the limit but the result size is less then the limit

Hello,

I have a Windchill query-object which is returning the exception size has exceeded the limit of 200000. I updated the limit to 400000 then I got the result which strangely counts less then 200000.

Then I tryed to add paging to the query but got this exception:

Exception message:

com.ptc.core.command.common.CommandException: (wt.pom.pomResource/22) wt.pds.PartialResultException: Search results size has exceeded the limit set by the System Administrator.
Nested exception is: (wt.pom.pomResource/22) wt.pds.PartialResultException: Search results size has exceeded the limit set by the System Administrator.

Could you please help?

Thanks in advance.