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
BedrockMission!

Learn More

View all

Sign in to view all badges

Advanced join Condition in Enrichment Usage

Avatar

Avatar
Validate 1
Level 2
Rishabh46
Level 2

Likes

5 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
Rishabh46
Level 2

Likes

5 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
Rishabh46
Level 2

29-05-2019

Hi,

1761910_pastedImage_0.png

We are trying to use the Advanced join as shown above to a temporary table but we are getting Sql error at the time of delivery is trigger

The error shown below screenshot

1761911_pastedImage_1.png

However, if we use the Simple join it works perfectly

Please help us in understanding how to implement Advance join

Any reference document would also be fine

Thanks

Rishabh

Replies

Avatar

Avatar
Boost 1
Level 1
bhaveshp8596869
Level 1

Like

1 like

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
bhaveshp8596869
Level 1

Like

1 like

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
bhaveshp8596869
Level 1

29-05-2019

Hey Rishabh46,

Can you provide the logs within the Delivery Audit, have you added any additional fields as personalization? Has the delivery been created? Is this error after it was created, or before it hits that activity. Have you enabled any SQL logging? Is so, please provide this so we can look at what tables are throwing this error.

Thanks!

Bhav