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

Deliveries and queries getting stuck

Avatar

Avatar
Validate 1
Level 2
robertw59784382
Level 2

Likes

5 likes

Total Posts

15 posts

Correct Reply

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

Avatar
Validate 1
Level 2
robertw59784382
Level 2

Likes

5 likes

Total Posts

15 posts

Correct Reply

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

06-11-2017

Hi,

We are having an occasional issue whereby queries and deliveries get stuck. They are permanently flashing blue and as they are not failing we do not get an error alert. The 'stuck' delivery uses a recurring delivery. I believe this is getting stuck due to network errors, as shown in logs below.

1342116_pastedImage_0.png

We have a script that automatically restarts a workflow when it fails (below). However, is there any way to adapt the below to target 'stuck' workflows? If due to network error, then perhaps a timer on a delivery would be a solution?

var cnx = application.getConnection()

// Pull HTML Content of an email

var stmt = cnx.query("SELECT iFailed " +

                     "FROM XtkWorkflow " +

                     "WHERE sInternalName = 'Retrieve_Data_from_Salesforce'")

for each(var row in stmt)

{

var Status = row[0]

if ( Status == 1 )

{

xtk.workflow.Restart("Retrieve_Data_from_Salesforce");

}

else

{}

}

Please let me know if you need any further information.

Many thanks,

Rob

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

13-11-2017

Hi Rob,

Is your instance hosted by Adobe? If so, I'd recommend contacting our support team.

If hosted by your company, I'd suggest checking with the department in charge of the network or your Adobe Campaign installation. (Double-checking with support could be useful as well).

Do you encounter this in specific cases only or does this happen every time?

Let me know,

Florent