Deliveries and queries getting stuck

robertw59784382

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)

florentlb

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