Unable to extract the rejected records from data load activity

[sa4_1234aaaaa]

Hi All,

I am trying create the technical for data import in ACS, We have usecase to extract the rejected records from the incoming file.

Below are the steps i just followed,

1. Created sample file with 6 records

2. Data load activity used to load the file from my local machine, Enabled the rejection option

3. Connecting the rejection transition to extract file activity and defining the file structure

4, Upload the file to s3 Bucket

Here i am facing the problem on point 3, I am able to see the reject counts but unable to populate the same via extract file activity

Getting the below error

Below is the workflow

Rejects:

Extract File:

Please let me know if anything i missed out to achieve this scenario

[SatheeskannaK · Accepted solution]

Hi @sa4_1234aaaaa,

When you choose "Keep the rejects in a file" option you don't have to use file extract activity rather specify the filename will allow to transfer the rejects in a file.

Thanks!

[sa4_1234aaaaa]

Hi SatheesKanna,

Thanks for your response, But without extract file how to define the file structure and column details.

Thanks,

Sakthi Kumar Gurusamy

[ganesha36040814]

Hi Sakthi,

It uses the same file structure and column details of the import file that you are trying to load.

Thank,

Ganesh

[sa4_1234aaaaa]

Hi ganesha36040814,

I Just tested and its working fine. Able to see the same file strcuture.

Thanks a lot for the quick response.

Thanks,

Sakthi Kumar Gurusamy