Sorting Info throws an error when the data returned from the QE is null

Question

I am trying to apply sorting on the primary key, while getting data is batches its breaking when the data returned from the query entity rule is null. 
 If sorting based on any other fields its working fine, with or without data 
 Code used: 
 a!pagingInfo( startIndex: 1, batchSize: 5, sort: a!sortInfo( field: "agendaItemIdPk", ascending: true() ) )

If we get the data we batch size -1 its working fine. Has anyone faced this issue if yes then whats the way around?

Mike Schmitt · Answer

Are you saying it works with the exact same code if you change "5" to "-1" to return all rows? Or is there another change involved? 
 If you're querying against a very inefficiently defined View, I suppose you could be running into an issue with QueryEntity/'s fetching of TotalCount. If you don't have " fetchTotalCount " manually defined, it'll behave differently (iirc) between passing "-1" for batchSize and passing an actual batch size (i.e. 5). I could imagine a scenario where just the attempt to fetch the total count causes the query to time out - and for the error message you posted, the query timing out is the most common underlying cause i've seen (though you should check your Tomcat-STDOUT.log file for more detail, it'll probably tell you exactly what the query issue was).

Mike Schmitt · Answer

What does your tomcat-stdout.log file say?