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

DB adapter clarification about limit of 240 secs.

Summary:

I am new to Db adapter.

Regarding 240 secs. limit for DB adapter.

Content (required):

This is from manual


Oracle Database Adapter Restrictions

Note the following Oracle Database Adapter restrictions in Oracle Integration.

  • The database password length cannot exceed 20 characters.
  • Database schema names with hyphens (-) are not supported.
  • All integrations that include stored procedure, PureSQL, or operation on table database operations must finish within 240 seconds. Otherwise, the query times out and a Limit Exceeded error occurs.


Please, can anybody explain if the limit applies to the whole integration or the individual calls to db adapter.

I have run a basic integration with a wait activity + db insert for 6 minutes (360 secs) and it finishes.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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