AETLE hangs when trying to open a transformation

v6.3.7.18

Hi
I am trying to open an existing transformation which is in a package that is scheduled and is running every day.
I can see from the logs that the transformation completes every day.
However when I try to Edit the transformation AETLE always hangs while it is attempting to open it and I end up having to end the AETLE process. I have tried leaving it for up to 20 minutes but it never opens.
This is the only transformation I have had this problem with and I have been able to open and edit many others.

Is there anything I can do to find out why this is happening with this transformation?

Thanks

Which kind of data are you working with?

Thanks for getting back so quickly.
I have never looked at the transformation so I can't be 100% sure but I think that it reads from a SQL Server DB and writes to text files

You have all this information in the execution log.
Can you post it here please

There are only 2 lines in the execution log for that transformation:

Information 11/1/2021 1:17:10 AM Executing Transformation: JCK - Get Prospect Events for Unify Export
Information 11/1/2021 2:07:30 AM Execution of Transformation: JCK - Get Prospect Events for Unify Export has completed

I don't know exactly what it does or why it takes so long to do it, but there are steps later in the package which FTP files and then there is a step which deletes the files that have just been FTP'd. Given that the files are deleted at the end of the package I am assuming that they must be created as the output of the transformation. Also given the lack of any incoming files that could feed into the transformation I am assuming that one of our SQL DBs is being queried.

I can see entries later on in the execution log which show that 3 files of a particular type were created and FTP'd and that no files of a second type were created. The reason I am looking at this is that the step which attempts to FTP the second file type has been set up to raise an error and send an email if it fails so I am trying to understand why no file of that type has been created.

I guess you are looking at the package level log
Double click on the transformation and you will see the transformation log.
Please post it here