You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

timeout - OIC3 - PostgreSQL adapter

in Integration 3 comments

Hi Team,

We are using OIC3 instance. We have a integration using PostgreSQL adapter, at high level:

  • PostgreSQL fetch (DB Adapter via Agent)
  • Fusion receipt creation (REST/SOAP call to Oracle Fusion)
  • PostgreSQL back update (DB Adapter via Agent)———-failing with backupdate.

Integration sometimes completes in less than 4 minutes, but during month ends, it takes 15 to 20 minutes and the integration fails.

Agent logs:

Caused by: 

java.net.SocketException: Connection timed out.

at org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:161)

We are asked to increase the timeout. Can you please kindly guide us, how to fix this problem.

Thank You,

Satish

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!