SQL Data Management Activity Issue | Community
Skip to main content
R
Adobe Employee
RRafikiAdobe Employee
Adobe Employee
February 21, 2023
Solved

SQL Data Management Activity Issue

  • February 21, 2023
  • 2 replies
  • 804 views

Hi Expert,

 

I hope everyone is doing well. I'm reaching out here to see if anyone knows if there are any issues/bugs with the SQL Data Management Activity, or if i need to refine the scripts to work with this Activity properly.

 

Within testing this activity, when i right-click on the wireframe and "Display the Target" I see an error, and no data is displayed.  Upon viewing the List Configuration and removing the "Targeting Dimension (target) from the output column, the Primary Key does populate, and i am able to view the data.

 

When I try to script to collect other data, for example, I just want to view the emails from the database, I still receive an error, and no matter how I configure the output columns, I can never view the data.

 

My question would be is the SQL Data Management Activity working properly? 

 

Thanks,

 

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 Manoj_Kumar

Hello @rrafiki 

 

Try this:

 

Click on automatically create workflow checkbox and add a enrichment activity after SQL data management activity. Use the outbound transition from enrichment to check the interim data.

2 replies

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity AdvisorAccepted solution
Community Advisor
February 21, 2023

Hello @rrafiki 

 

Try this:

 

Click on automatically create workflow checkbox and add a enrichment activity after SQL data management activity. Use the outbound transition from enrichment to check the interim data.

Manoj  | https://themartech.pro
    Sukrity_Wadhwa
    Community Manager
    Sukrity_WadhwaCommunity Manager
    Community Manager
    March 2, 2023

    Hi @rrafiki,

    Was the given solution helpful to resolve your query or do you still need more help here? Do let us know.

    Thanks!

    Sukrity Wadhwa
    Terms & ConditionsAccessibility statement

    Loading footer...