db_password environment variable shows only the first 100 characters of a password

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

The $db_password or %db_password%(Windows) environment variable can be used to pass the Job's Primary Login password value to your script or however else a environment variables are used.

The Primary Login is defined within the Job's Execution Options window.

However, if the Login password exceeds 100 characters, the db_password environment variable resolves to only the first 100 characters.

Environment

Applications Manager 9.x

Cause

When saving a Login object with a password greater then 100 characters, only the first 100 characters is written to the database. This is a client specific issue.

Resolution

This issue is currently being investigated to determine if it is a bug.

If found a bug, a fix will be included in a future version of Applications Manager, and this article will be updated.

Workaround:

1. Manually update password while changing the encrypted flag to N:
   
   SQL> update so_ids set so_passwd='<your password>', so_encrypted='N' where so_login='<your login>';
   SQL> commit;
   
   
2. Run the below awexe command to manually re-encrypt the password:
   
   awexe id_recrypt