Unable to do data extract

[Sanjana12]

Hello, getting the below error. Please suggest

[LakshmiPravallika]

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.

[Sanjana12]

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]

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.

[Sanjana12]

I checked. It is already temp:enrich3 inside the data extraction activity.

[LakshmiPravallika]

Hi @Sanjana12 ,

Please try configuring a new Data Extraction activity and pull all the Data required , looks like the activity got corrupted.

Regards,

Pravallika.

[ParthaSarathy · Accepted solution]

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.

[Sanjana12]

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

[ParthaSarathy]

@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.