Symptom
You created a CSV outbound integration in Integration Center.
When running this integration, the error below is occurring:
"Exception occurred during execution on the exchange: Exchange[]"
Environment
- SAP SuccessFactors HCM Suite
- Integration Center
Cause
This error happens when there is too much data being extracted by the Integration Center job.
Resolution
It is not a good practice to create an Integration Center job that extracts a large number of records at once since this can severely impact the performance of the job and cause this issue. More details about this are explained in the KBA 2742107 under question 6.
So, in order to fix this issue, you should decrease the amount of data being extracted by the job. You can consider:
- Setting up more filters.
- Selecting less fields.
- Splitting the Integration Center job into multiple ones.
- You could set each separate job for a different dataset (e.g. one job for employees under company A, another job for company B, and so on ...).
Attachment scenarios
If your job is selecting data from the Attachment entity, note that this issue is likely to occur as the Attachment object handles very large values. In such cases, use the "Attachment" integration type instead of CSV outbound. Refer to the documentation below for such scenarios:
- Guide page Creating an Outbound Integration with Attachment as the Format for an Integration Type: it will provide instructions on how to build an Attachment type integration.
- The KBA 3010575 - How to extract employee photos to an SFTP folder using Integration Center is also an example of Attachment integration.
If the above does not resolve the issue in Attachment scenario:
Please note this may be an out of memory situation, so please set the flag "storageType": "F" in the ICD manually so that it will create a temp file internally instead of using in-memory.
Keywords
base64, base 64, photo, extract, "Exception occurred during execution on the exchange: Exchange[]", attachment, integration center, csv, IC, integration centre, performance, full load , KBA , LOD-SF-INT-INC-FWK , Integration Center UI Framework , Problem