Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!

SQL Data Management Activity Issue

Avatar

Employee

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,

 

2 Replies

Avatar

Community Advisor

Hello @rafiko 

 

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.

Avatar

Administrator

Hi @rafiko,

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

Thanks!