Automic Workload Automation

 View Only
  • 1.  Issue with encrpted fields

    Posted Oct 14, 2020 09:59 PM
    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 Oct 15, 2020 02:10 AM
    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 Oct 15, 2020 03:39 AM
    Thanks Peter, It worked.

    Regards
    Pothen