Related Records Query Unstable

Discussion created by ebrightc on May 17, 2012
I have a map service published to ArcGIS Server 10, with a point feature class in SDE that has 2 ole db tables related in the map document.
I have successfully queried these tables through the REST interface, and gotten the expected results, but once in a while the relate query stops working but I can still retrieve the features from the point feature class.
I have to restart the service in order to get the related tables query working again. The server manager logs do not show anything unusual besides hitting the max record count limit, but this does not seem to correlate with the query breaking.
Also, I have seen other threads regarding related records not working if there is a join on any of the tables. I have confirmed that I do not have any joins in the map doc.