Automic Workload Automation

Expand all | Collapse all

Issue with encrpted fields

Jump to Best Answer
  • 1.  Issue with encrpted fields

    Posted 10 days ago
    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 


  • 2.  RE: Issue with encrpted fields
    Best Answer

    Posted 10 days ago
    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
    ------------------------------



  • 3.  RE: Issue with encrpted fields

    Posted 10 days ago
    Thanks Peter, It worked.

    Regards
    Pothen