Hello everyone,
Firstly, I have to say that this is my first experience of attempting to use UOPY so please forgive any obvious mistakes on my part. The issue which I am looking for some guidance on is as follows:
I can log into Universe via an ssh terminal, issue command such as:
SELECT CDC.CARD WITH ID = "1234567890123456" TO 1
LIST CDC.CARD CARDNUM FROM 1
This selects one record into list number one and outputs the ID and CARDNUM values. CARDNUM Is a calculated field and is decrypted / displayed correctly when the operations are performed as above.
However, when using UOPY, I replicate the above using something similar to the below:
cmd=uopy.Command(f'LIST {filename} CARDNUM FROM {list_number}',ses)
cmd.run()
Inspecting the cmd object shows that there's an error in decrypting the value, with the full error message as follows:
error:06065064:digital envelope routines:EVP_DecryptFinal_ex:bad decrypt:crypto/evp/evp_enc.c:570
I understand that the Command objects should be running on the server so assumed the decryption via UOPY would return the same results as per the command line but that's not what I am currently experiencing.
If anyone has any thoughts on an approach I might try, I'd be very happy to hear them.
Thanks in advance.
Andrew