- Posts: 122
- Thank you received: 4
Decrypt object throws error when no passphrase is present
2 years 6 months ago - 2 years 6 months ago #20792
by mdspeirs
Last edit: 2 years 6 months ago by mdspeirs.
The following user(s) said Thank You: Peter.Jonson
Please Log in or Create an account to join the conversation.
2 years 6 months ago #20793
by admin
Mike
ETL Architect
Replied by admin on topic Decrypt object throws error when no passphrase is present
That should be easy to address we will have a look at it for you.
Thank you for the feedback
Thank you for the feedback
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
- Peter.Jonson
-
- Offline
- Platinum Member
-
2 years 6 months ago #20794
by Peter.Jonson
Peter Jonson
ETL Developer
Replied by Peter.Jonson on topic Decrypt object throws error when no passphrase is present
Hello
We have modified the source so when no passphrase is present it is not included in the command.
Please try the latest version and let us know the outcome.
Other changes are:
17/03/2021 - 6.3.7.14
+ Added: Extract Attachments option to IMAP4 and POP3 reader
+ Added: Email footer message
+ Added: Cache option to "Get Excel Cell Value Dynamic" transformation function
+ Improved: When the application starts it will ask the user "Reopen last objects? (It will only happen if reopen tabs option is checked)
- Removed: IP Location, URL Location and Url Shortener transformation functions
- Removed: Transformation type toolbar from the mapping designer
- Fixed: Issue with empty decryption passphrase
- Fixed: Licence management issues
- Fixed: Schedule table backup/restore issues
We have modified the source so when no passphrase is present it is not included in the command.
Please try the latest version and let us know the outcome.
Other changes are:
17/03/2021 - 6.3.7.14
+ Added: Extract Attachments option to IMAP4 and POP3 reader
+ Added: Email footer message
+ Added: Cache option to "Get Excel Cell Value Dynamic" transformation function
+ Improved: When the application starts it will ask the user "Reopen last objects? (It will only happen if reopen tabs option is checked)
- Removed: IP Location, URL Location and Url Shortener transformation functions
- Removed: Transformation type toolbar from the mapping designer
- Fixed: Issue with empty decryption passphrase
- Fixed: Licence management issues
- Fixed: Schedule table backup/restore issues
Peter Jonson
ETL Developer
Please Log in or Create an account to join the conversation.
1 year 11 months ago #21348
by ae
Replied by ae on topic Decrypt object throws error when no passphrase is present
I have recently picked up mdspeirs's work after he moved on to another role. There was not a lot of time for handover and AETLE is new to me so please bear with the newbie questions.
I am having issues with other packages that he wrote which decrypt incoming files from a client.
There are daily scheduled processes which run packages that contain GPG objects that decrypt files.
The GPG objects are all configured without a passphrase. When they run via the schedule they all report an error but do succeed in decrypting the file. An example from the logs is attached.
I have tried running some of the packages manually but they always fail - as in they report an error and do not decrypt the file.
I expect that a key is needed to decrypt the files and that the user which runs the schedules has that key. What I can't find is where AETLE has that key stored or how it knows to use it.
The other question I have is why do the processes always report an error but still succeed in decrypting the file?
Thanks
AETLE v 6.3.7.18
I am having issues with other packages that he wrote which decrypt incoming files from a client.
There are daily scheduled processes which run packages that contain GPG objects that decrypt files.
The GPG objects are all configured without a passphrase. When they run via the schedule they all report an error but do succeed in decrypting the file. An example from the logs is attached.
I have tried running some of the packages manually but they always fail - as in they report an error and do not decrypt the file.
I expect that a key is needed to decrypt the files and that the user which runs the schedules has that key. What I can't find is where AETLE has that key stored or how it knows to use it.
The other question I have is why do the processes always report an error but still succeed in decrypting the file?
Thanks
AETLE v 6.3.7.18
Please Log in or Create an account to join the conversation.
1 year 11 months ago #21349
by admin
Mike
ETL Architect
Replied by admin on topic Decrypt object throws error when no passphrase is present
Our software is using GPG for description/encryption (Gpg4Win)
When GPG.exe returns 0 the execution is successful.
Anything else is a failure.
This is standard behaviour on windows.
I assume that you are using an execution agent.
There is a chance that when GPG.exe is executed it prints some warnings/error messages
But you cannot see the message because gpg.exe is executed from the windows service (execution agent).
Can you put > log.txt into the additional parameters box?
It might give you an idea of what is going on.
When GPG.exe returns 0 the execution is successful.
Anything else is a failure.
This is standard behaviour on windows.
I assume that you are using an execution agent.
There is a chance that when GPG.exe is executed it prints some warnings/error messages
But you cannot see the message because gpg.exe is executed from the windows service (execution agent).
Can you put > log.txt into the additional parameters box?
It might give you an idea of what is going on.
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
1 year 11 months ago #21350
by ae
Replied by ae on topic Decrypt object throws error when no passphrase is present
Hi Mike
Thanks for getting back to me.
I have tried adding the parameter but it has not made any difference and I can't see any output being produced anywhere.
Can you suggest anything else I can try?
Could you answer my second question from above please? How does AETLE know where to look for the decryption key?
Thanks
Thanks for getting back to me.
I have tried adding the parameter but it has not made any difference and I can't see any output being produced anywhere.
Can you suggest anything else I can try?
Could you answer my second question from above please? How does AETLE know where to look for the decryption key?
Thanks
Please Log in or Create an account to join the conversation.