Monday, May 30, 2022

OIC - limitation of using Staging area

Staging area:

Staging area is a temporary storage which is used to store file while integration is in execution. All the files being created during the integration run are flushed when the OIC integration completes(Success/Error) it's execution. Stage activity is used to access the staging area.

Limitation:

There is no limit while writing to Staging area but while reading only 10 MB size of messages can be read. 

Solution to limitation:

To read file which has size more than 10 MB, we need to use Read File in Segments. The way around is - use this Read file in Segments action to read file serially, it reads in chunks of 200 and by-passes the 10MB limit.


2 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. Thanks for sharing such beautiful information with us. I hope you will keep sharing such a useful information. Please keep sharing! Are you searching for calling database Please visit - Calling Data Provider

    ReplyDelete

Featured Post

OIC - how can I use XSLT functions to remove leading zeros from numeric and alphanumeric fields?

To remove leading zeros from an numeric field in Oracle Integration Cloud (OIC) using XSLT, you can Use number() Function The number() funct...