JDBC 8 for Peopletools 8.60
Our current flow is as follows: data flows from Campus to PeopleSoft through Mule. PeopleSoft then connects to Regent (now via JDBC 8, previously JDBC 7) and SFP (via REST API) to retrieve the required details. The results from Regent and SFP are combined into a single JSON response, which is sent back to Campus via Mule. Mule and Campus have a 10-second timeout configured.
After upgrading PeopleTools from 8.59 to 8.60 and moving from JDBC 7 to JDBC 8 for the Regent connection, we have been intermittently encountering HTTP 500 server errors or timeouts. For the same EMPLID, the request sometimes succeeds and sometimes fails. Please advise on possible causes and next steps.