AETLPE crashes on routine operations

AETLPE 32 bit 5.9.2.7
Windows Server 2012 R2 on Azure VM

We're having almost daily problems where AETL fails on simple operations like unzipping or renaming files. This usually happens after an FTP operation and started happening right after the "keep alive" option was added. We don't have the keep alive option checked, in the problem packages. If we manually rerun the package it will usually finish without an issue, so doesn't appear do be due to specific files.

We have tried different FTP connection settings and the problem seemed better when use plain ftp.





another one... here there's no next action so but it fails after a successful ftp operation




This may be a red herring, but we noticed it around the same time so I'll mention it. We have packages that exist but don't show up in the pane on the left when you're in "Design". We know they exist because they're contained in another package and we can sort of access them there. If you click edit you get a couple of errors, but the package then appears.




Thanks

I suggest we sort out missing packages first.
Can you provide use with the backup of your repository please.
Please also tell us which package to open to see them.

Ok, I've emailed it.

Hello

Please run the following SQL against the repository.

update OBJECTS_TREE set parent_id=4751 where object_id=4838

update OBJECTS_TREE set parent_id=4751 where object_id=4762

update OBJECTS_TREE set parent_id=4751 where object_id=4767

update OBJECTS_TREE set parent_id=4751 where object_id=4847

This should address the problem with missing packages

Also can you run failing package again and let us know the outcome

Executed the indicated statements successfully, and the packages now show up.
I restarted AETLE.

I can't get the packages to fail on cue. but we did have a failure this morning.


We have a sequence of package that run inside another package which is scheduled for every workday. It has been failing on this particular package (4911) quite often, but 4911 executes fine if run manually.