Unable to extract the rejected records from data load activity | Community
Skip to main content
S
sa4_1234aaaaa
May 29, 2022
Solved

Unable to extract the rejected records from data load activity

  • May 29, 2022
  • 1 reply
  • 1559 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SatheeskannaK

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!

1 reply

SatheeskannaK
Community Advisor
SatheeskannaKCommunity AdvisorAccepted solution
Community Advisor
May 30, 2022

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!

Thanks, Sathees
    S
    sa4_1234aaaaaAuthor
    May 30, 2022

    Hi SatheesKanna,

     

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

     

    Thanks,

    Sakthi Kumar Gurusamy

    G
    ganesha36040814
    Level 2
    May 30, 2022

    Hi Sakthi,

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

     

    Thank,

    Ganesh

      Terms & ConditionsAccessibility statement

      Loading footer...