Hi Pothen,
the option "Password" for a PromptSet text input field encrypts the value and displays it as asterisks (*)
In order to run the command (Windows and Unix) with the decrypted password you have to use the Agent Job Messenger (
parameter CMD).
regards,
Peter
------------------------------
Capture Europe
------------------------------
Original Message:
Sent: 10-14-2020 09:59 PM
From: Pothen Verghese
Subject: Issue with encrpted fields
Team,
We are trying to run a sql (postgres) query via a unix command job. The command needs a password field for it to run. If we pass the password via PROMPTSET as a 'password' it fails with below error:
psql.bin: FATAL: password authentication failed for user "postgres"
But if set the password in plain text within the Process Tab, the job runs successfully. Any idea why the encrypted password is not properly processed in this case?
Thanks
Pothen