Expand my Community achievements bar.

SOLVED

Unable to extract the rejected records from data load activity

Avatar

Level 1

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

sa4_1234aaaaa_0-1653808933790.png

Below is the workflow

sa4_1234aaaaa_1-1653808992547.png

Rejects:

sa4_1234aaaaa_2-1653809060780.png

Extract File:

sa4_1234aaaaa_3-1653809139905.png

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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.

SatheeskannaK_0-1653884684199.png

 

Thanks!

Thanks, Sathees

View solution in original post

4 Replies

Avatar

Correct answer by
Community Advisor

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.

SatheeskannaK_0-1653884684199.png

 

Thanks!

Thanks, Sathees

Avatar

Level 1

Hi SatheesKanna,

 

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

 

Thanks,

Sakthi Kumar Gurusamy

Avatar

Level 2

Hi Sakthi,

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

 

Thank,

Ganesh

Avatar

Level 1

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