We are currently facing a weird issue in Production environment.
For a DB call from SpringFarm(SF) we are seeing continuous response on lower environments, but when it comes to production we are seeing inconsistent response from database(Note: the request parameters is fixed). This procedure contains TABLE_TYPE in the response, where as from SF its a plain DB object call.
Using Curl scripting we executed this SPRING_FARM web service with same request in a loop for 50 times. In the result logs, its been identified for the same request from the same server intermittent response is identified, out of 50 times 4-8 times we have data and for the others the response is empty.
To add, we tried executing the same procedure with the parameters passing from SF to DB, and we are getting response for every hit.