Unable to do data extract | Community
Skip to main content
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 ParthaSarathy

Hi @sanjana12 ,

Is Enrichment or Data extraction activity is copied from an another workflow to this workflow and Ran the workflow?

Follow the below step to troubleshoot,

1. Enable 'Keep the result of interim population' in workflow property

2. Reconfigure the enrichment and run the workflow without data extraction.

3. In the output transition of enrichment > Right click > display the target > and configure all the field which you're planning to extract and see whether you're getting any errors.

4. If there is no error, then configure data extraction and select the fields and run the workflow. You won't be getting error now.

Once testing is done, you can disable 'Keep the result of interim population' in workflow property.

2 replies

LakshmiPravallika
Community Advisor
LakshmiPravallikaCommunity Advisor
Community Advisor
November 17, 2023

Hi @sanjana12 ,

 

Please check the schema used inside the Data Extraction activity for fetching the Data is temp:enrich3 instead of temp:query2

 

Example:

 

 

Regards,

Pravallika.

 

 

S
Sanjana12Author
Level 6
November 17, 2023

Hi, why do we need to change it to temp:query2 ? Inside the enrichment activity, we are reconcilling member data from the query activity with recipient table.

LakshmiPravallika
Community Advisor
LakshmiPravallikaCommunity Advisor
Community Advisor
November 17, 2023

Hi @sanjana12,

 

It needs to be changed to "temp:enrich3" inside the Data Extraction as the Data you require will be taken from Enrichment activity instead of query activity.

 

Regards,

Pravallika.

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
November 17, 2023

Hi @sanjana12 ,

Is Enrichment or Data extraction activity is copied from an another workflow to this workflow and Ran the workflow?

Follow the below step to troubleshoot,

1. Enable 'Keep the result of interim population' in workflow property

2. Reconfigure the enrichment and run the workflow without data extraction.

3. In the output transition of enrichment > Right click > display the target > and configure all the field which you're planning to extract and see whether you're getting any errors.

4. If there is no error, then configure data extraction and select the fields and run the workflow. You won't be getting error now.

Once testing is done, you can disable 'Keep the result of interim population' in workflow property.

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
S
Sanjana12Author
Level 6
November 17, 2023

Hello, neither the enrichment nor the data extraction was copied from another workflow

ParthaSarathy
Community Advisor
ParthaSarathyCommunity Advisor
Community Advisor
November 17, 2023

@sanjana12 , try the troubleshooting steps mentioned in previous comment and check the output transition of enrichment > Right click > display the target > and configure all the field which you're planning to extract in data extraction activity and see whether you're getting any errors.

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
Terms & ConditionsAccessibility statement

Loading footer...