LDAP users with spaces in passwords unable to create exports in Applications Manager

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

When an LDAP user whose password contains spaces (e.g., Horse Unflawed Staple) attempts to perform an export in Applications Manager, the operation fails. The following error is typically observed in the logs or UI:

Error Code: ORA-20064 

Error Message:

ErrorMsg: AwE-5001 Database Query Error
Details: ORA-20064: Module [WORD_FROM_PASSWORD] is not found in table so_job_table
ORA-06512: at "AMS962.AWAPI2", line 4700
ORA-06512: at "AMS962.AWAPI2", line 4422
ORA-06512: at "AMS962.AWAPI2", line 488
ORA-06512: at "AMS962.AWAPI2", line 4042
ORA-06512: at "AMS962.AWAPI2", line 4676
ORA-06512: at "AMS962.AWOP_API", line 675
ORA-06512: at "AMS962.AWOP_API", line 107
ORA-06512: at "AMS962.AW_WEB_API", line 39
ORA-06512: at line 1

Note: In the error above, [WORD_FROM_PASSWORD] is usually the second word of the passphrase, indicating the application is incorrectly parsing the password string.

Environment

Applications Manager 9.4.x - 9.6.2

Cause

This is caused by a software defect (DE184033) where the application incorrectly handles space delimiters within the LDAP password field during export processing and LDAP connection testing.

Resolution

The issue will be resolved in the following versions of Applications Manager:

• Applications Manager 9.6.3
• Applications Manager 10.0.0

The fix ensures that the password string is handled correctly regardless of space characters and also allows spaces to be used in the password field during LDAP connection tests within the Master Options.

Workaround

If an upgrade is not immediately possible, use one of the following methods:

1. Change Password: Modify the LDAP password to a string that does not contain space characters.
2. Local Authentication: Temporarily disable LDAP authentication for the user and use a local Applications Manager password to perform the export.