SYMPTOM:
When using LDAP credentials for warehouse pass-through and Windows Authentication to log in to Strategy, if a user's LDAP password changes, the warehouse credentials are not updated unless an LDAP authentication is done in Strategy 9.x and 10.x.
CAUSE:
This is working as designed. LDAP pass-through was designed to be used in conjunction with LDAP authentication. Consider the following facts regarding the aforementioned Strategy authentication methods.
When using LDAP credentials for warehouse pass-through, the credentials must be stored in the metadata in order to pass them each time it is required to query the database for that user. If Windows authentication is in use, Strategy does not have a way to know if the LDAP credentials have been changed or updated. Therefore, it is necessary to perform at least one LDAP login following the LDAP password change in order to update the password credentials in the metadata.
ACTION / WORKAROUND:
Every time an LDAP user changes their password, an LDAP authentication log-in must be done in order to correctly update the LDAP credentials for LDAP warehouse pass-through. Setting up LDAP as a secondary log-in option is suggested so that users can perform this step following the password change.