Our Oracle HCM import into HR SD is failing after importing 25k worker records with a strange situation.
The flow reports "com.glide.transform.transformer.exceptions.InvalidStructureException: JsonStreamParser[2244]: Colon required after identifier" suggesting that the latest page returned an invalid JSON.
Outbound HTTP logging shows that the response for this call is 200 in a few seconds but the response payload is 0 (empty). This is after 50+ pages of valid responses.
When I replay the failing API call in Postman I get a fast 200 response but it takes 2 minutes to get the payload and it is truncated (invalid JSON).
If I then go back to the outbound REST call in ServiceNow I can see that the response is partly populated but, I'm assuming, the Flow got tired of waiting and failed before it got the whole thing.
If I retry the call in Postman a few minutes later I get a full, valid JSON.
So some kind of transient issue in the speed of the Oracle response? Not a strict timeout but the time it takes to download the whole payload.
Has anybody come across this? Any ways to mitigate it?
