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

robertw59784382
Level 2
Level 2

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

1 Reply
florentlb
Level 10
Level 10

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