1. Using the Oracle Database Adapter with Oracle Integration Generation 2
  2. Troubleshoot the Oracle Database Adapter
  3. Resolve Message Time Out Errors

Resolve Message Time Out Errors

The following errors can occur during both design time (in both the inbound and outbound directions) and runtime.

  • Message not received within X seconds of wait interval

    There can be multiple reasons for a time out occurring, such as connectivity issues between Oracle Integration and the connectivity agent or the connectivity agent being disabled. Ensure that the connectivity agent is up and running if you see this error. Check the status of the agent under Dashboards > Agents in Oracle Integration.

    Note:

    When using the Oracle Database Adapter to connect to an Oracle E-Business Suite Database instance, you may notice this error occurring continuously. It is recommended that you use the Oracle E-Business Suite Adapter instead of the Oracle Database Adapter to access the Oracle E-Business Suite Database instance. 
  • SQLState: 08006 errorCode: 17002 message: IO Error: Connection timed out

    This error can occur when database sessions are terminated by a network firewall or some other reason. The adapter automatically recovers during this state and new connections are created. However, a few requests using old connections may time out. Ensure that the firewall is not terminating idle connections.

  • Timeouts can also occur due to design problems. Avoid certain antipatterns. For example, do not explicitly update the same table as an invoke operation when the same table is getting polled on the trigger side.