Stuck Process

AETLE x64 v3.6.7.24

Hi We have a stuck execution. The parent log is indicating that a log file is in use. AETCL.exe process was still running. We let it run for about 30 minutes before we noticed it via an external monitor we have.

I tried to Abort it through the AETL UI but it didn't seem to recognise that.

So, I killed the aetlcl.exe process via the task Manager. But this obviously leaves orphaned rows in the the QUEUE tables. I know I can delete it from the UI Grid, but if we wanted to keep the entry as an audit record how is the best way to cleanup the QUEUE tables?

Thanks

1) Well if you want to keep it for an audit just leave it as it is.
2) It would interesting to see the log file so we can understand why it got stuck.

The log is not very informative in this case. It was in a IMAP4 Read Mail Action in a Package. It got to "Stat Connected" and never moved from there. I've reviewed it and the audit doesn't provide much value anyway. So I have just nuked it. If it happens again I'll put something together. In this case I more curious about the rows in QUEUE_ACTION and if there was another approach to 'keeping a clean house'.
cheers

I see what you mean now.

You can move the record into the history table using the following script.

insert into QUEUE_HISTORY select * from QUEUE where QUEUE_ID=123;
insert into QUEUE_ACTIONS_HISTORY select * from QUEUE_ACTIONS where QUEUE_ID=123;
DELETE FROM QUEUE_ACTIONS where QUEUE_ID=123;
DELETE FROM QUEUE where QUEUE_ID=123;